biuan SAP® BUSINESS ONE SDK
DTW Sales / Blanket Agreement
API OPJT
OPJT - Project Plan Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
DocEntry KEY UNIQUEInternal NumberInt
11
PRIMARYYes
TempTypeTemplate TypeVarChar
S) System Template
N) Nonsystem Template
1
N
TempName KEYTemplate NamenVarChar
127
NAMENo
LogInstancLog InstanceInt
11
UserSignUser SignatureInt
11OUSR
Users
UserSign2Updating UserInt
11OUSR
Users
CreateDateProduction DateDate
8
UpdateDateDate of UpdateDate
8
TempDescTemplate DescriptionnVarChar
127

SELECT statement

SELECT OPJT.DocEntry AS 'Internal Number', OPJT.TempType AS 'Template Type', OPJT.TempName AS 'Template Name', OPJT.LogInstanc AS 'Log Instance', OPJT.UserSign AS 'User Signature', OPJT.UserSign2 AS 'Updating User', OPJT.CreateDate AS 'Production Date', OPJT.UpdateDate AS 'Date of Update', OPJT.TempDesc AS 'Template Description' FROM OPJT AS OPJT

Related information


Users OUSR 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