biuan SAP® BUSINESS ONE SDK
DTW Sales / Delivery
API APJ2
APJ2 - Project Plan Steps Time Record Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
DocEntry KEY UNIQUEInternal NumberInt
11
PRIMARYYes
StepCodeStep CodeInt
11
LineNumLine NumberInt
11
DateDateDate
8
StartTimeStart TimeInt
11
EndTimeEnd TimeInt
11
RemarksRemarksnVarChar
127
LogInstancLog InstanceInt
11
OwnerOwnernVarChar
127OHEM
Employees
DurationDurationNum
20

SELECT statement

SELECT APJ2.DocEntry AS 'Internal Number', APJ2.StepCode AS 'Step Code', APJ2.LineNum AS 'Line Number', APJ2.Date AS 'Date', APJ2.StartTime AS 'Start Time', APJ2.EndTime AS 'End Time', APJ2.Remarks AS 'Remarks', APJ2.LogInstanc AS 'Log Instance', APJ2.Owner AS 'Owner', APJ2.Duration AS 'Duration' FROM APJ2 AS APJ2

Related information


Employees OHEM 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