biuan SAP® BUSINESS ONE SDK
SQL Administration / Closing Date Procedure
DTW Administration / Setup / Inventory / Bin Locations
API OCDP / Closing Date Procedure
OCDP - Closing Date Procedure Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
ClsDateNum KEY UNIQUEClosing Date Procedure NumberInt
6
PRIMARYYes
ClsDtCode KEY UNIQUEClosing Date Procedure CodenVarChar
30
ABS_ENTRYYes
BsLineDateBase Row DateVarChar
P) Posting Date
S) System Date
1
S
DueMonthStart FromVarChar
E) Month End
H) Half Month
Y) Month Start
N)
1
N
ExtraMonthExtra MonthInt
6
ExtraDayExtra DayInt
6

SELECT statement

SELECT OCDP.ClsDateNum AS 'Closing Date Procedure Number', OCDP.ClsDtCode AS 'Closing Date Procedure Code', OCDP.BsLineDate AS 'Base Row Date', OCDP.DueMonth AS 'Start From', OCDP.ExtraMonth AS 'Extra Month', OCDP.ExtraDay AS 'Extra Day' FROM OCDP AS OCDP

Related information


Closing Date Procedure ClosingDateProcedure Object· Table: OCDP
The ClosingDateProcedure object enables to retrieve the closing date procedure definition. This object is applicable for cluster B (country-specific for Japan only). Source table: OCDP.

OCDP 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