biuan SAP® BUSINESS ONE SDK
API TPL1
TPL1 - Template - Records Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
TplNum KEY UNIQUETemplate CodeInt
11OTPL
Import Template
PRIMARYYes
LineNumLine No.Int
11
FieldPosField Pos.Int
11
SrcArrTypeSource Array TypeInt
-1) None
1) Main
12) Array 1
13) Array 2
14) Array 3
15) Array 4
16) Array 5
17) Array 6
18) Array 7
19) Array 8
20) Array 9
21) Array 10
22) Array 11
11
1
SrcObjTypeSource Object TypeInt
11
-1

SELECT statement

SELECT TPL1.TplNum AS 'Template Code', TPL1.LineNum AS 'Line No.', TPL1.FieldPos AS 'Field Pos.', TPL1.SrcArrType AS 'Source Array Type', TPL1.SrcObjType AS 'Source Object Type' FROM TPL1 AS TPL1

Related information


Import Template OTPL 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