biuan SAP® BUSINESS ONE SDK
SQL Finance / Period-End Closing
API CCPD
CCPD - Period-End Closing Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
PerAbs KEY UNIQUEPeriod CodeInt
11
PRIMARYYes
Line_IDRow NumberInt
11
0
ProfitActAccount CodenVarChar
15OACT
G/L Accounts
Ref1Reference 1nVarChar
11
Ref2Reference 2nVarChar
11
DueDateDue DateDate
8
RefDatePosting DateDate
8
TaxDateDocument DateDate
8
MemoRow DetailsnVarChar
50
MarkLineSelectVarChar
Y) Yes
N) No
1
N
ActKeyLineAccount CodenVarChar
15OACT
G/L Accounts
LocBalLineCurrent BalanceNum
20
FcBalLineBalance (Account Currency)Num
20
SysBalLineBalance (SC)Num
20
ToPerAbsTo Period CodeInt
11
CtrlActControl AccountnVarChar
15OACT
G/L Accounts
PL_ACCOUNTP/L AccountVarChar
Y) Yes
N) No
1
Y
Ref1_lReference 1 for linenVarChar
100
Ref2_lReference 2 for linenVarChar
100
Ref3_lReference 3 for linenVarChar
27

SELECT statement

SELECT CCPD.PerAbs AS 'Period Code', CCPD.Line_ID AS 'Row Number', CCPD.ProfitAct AS 'Account Code', CCPD.Ref1 AS 'Reference 1', CCPD.Ref2 AS 'Reference 2', CCPD.DueDate AS 'Due Date', CCPD.RefDate AS 'Posting Date', CCPD.TaxDate AS 'Document Date', CCPD.Memo AS 'Row Details', CCPD.MarkLine AS 'Select', CCPD.ActKeyLine AS 'Account Code', CCPD.LocBalLine AS 'Current Balance', CCPD.FcBalLine AS 'Balance (Account Currency)', CCPD.SysBalLine AS 'Balance (SC)', CCPD.ToPerAbs AS 'To Period Code', CCPD.CtrlAct AS 'Control Account', CCPD.PL_ACCOUNT AS 'P/L Account', CCPD.Ref1_l AS 'Reference 1 for line', CCPD.Ref2_l AS 'Reference 2 for line', CCPD.Ref3_l AS 'Reference 3 for line' FROM CCPD AS CCPD

Related information


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. Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates