biuan SAP® BUSINESS ONE SDK
DTW Service / Service Call
API OCPL
OCPL - Quick Copy Log Manager Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsEntry KEY UNIQUEInternal NumberInt
11
PRIMARYYes
StartDateStart DateDate
8
StartTimeStart TimenVarChar
6
EndDateEnd DateDate
8
EndTimeEnd TimenVarChar
6
CopySourceCopy SourcenVarChar
127
CopyTargetCopy TargetnVarChar
127
UserNameUser NamenVarChar
20
CopyMethodCopy MethodInt
2) Delete All Records Then Add New Records
4) Update Existing Records Without Adding New Records
8) Add New Records Without Updating Existing Records
16) Add New Records and Update Existing Records
0
6
FailRpnCopy failedInt
1) Ignore All Errors and Copy Valid Records
2) Obtain User Confirmation
3) Terminate Copy Process When One or More Errors Occur
4) Terminate Copy Process When Number of Errors Exceeds
6
MissingUDFUDF missingVarChar
2) N/A
1) Copy Records and Ignore Missing UDFs
0
1
CopyTypeCopy TypeInt
6
ErrorNumError NumbernVarChar
11
NullifyActNullify AccountInt
2) N/A
1) Use Default Accounts in Target
0
6
CopyEmtValCopy Empty ValueInt
2) N/A
1) Do Not Overwrite Target Fields and Keep Original Values
0
6

SELECT statement

SELECT OCPL.AbsEntry AS 'Internal Number', OCPL.StartDate AS 'Start Date', OCPL.StartTime AS 'Start Time', OCPL.EndDate AS 'End Date', OCPL.EndTime AS 'End Time', OCPL.CopySource AS 'Copy Source', OCPL.CopyTarget AS 'Copy Target', OCPL.UserName AS 'User Name', OCPL.CopyMethod AS 'Copy Method', OCPL.FailRpn AS 'Copy failed', OCPL.MissingUDF AS 'UDF missing', OCPL.CopyType AS 'Copy Type', OCPL.ErrorNum AS 'Error Number', OCPL.NullifyAct AS 'Nullify Account', OCPL.CopyEmtVal AS 'Copy Empty Value' FROM OCPL AS OCPL

Related information


OCPL 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