biuan SAP® BUSINESS ONE SDK
API CPA1
CPA1 - Periods Category - WIP Mapping Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsEntry KEY UNIQUEInternal NumberInt
11OACP
Periods Category
PRIMARYYes
LineNumLine NumberInt
11
LogInstancLog InstanceInt
11
AcctFromConsolidate from AccountnVarChar
15OACT
G/L Accounts
AcctToConsolidate to AccountnVarChar
15OACT
G/L Accounts

Table relationship map

SELECT statement

SELECT CPA1.AbsEntry AS 'Internal Number', CPA1.LineNum AS 'Line Number', CPA1.LogInstanc AS 'Log Instance', CPA1.AcctFrom AS 'Consolidate from Account', CPA1.AcctTo AS 'Consolidate to Account' FROM CPA1 AS CPA1

Related information


Periods Category OACP SQL Table

G/L Accounts OACT SQL Table



SAP® Business One is the trademark(s) or registered trademark(s) of SAP AG in Germany and in several other countries. Icons by Icons8 Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates