biuan SAP® BUSINESS ONE SDK
API TPI2
TPI2 - Tax Invoice Operation Codes Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
BaseEntry KEY UNIQUEAbs. EntryInt
11OTSI
Sales Tax Invoice
PRIMARYYes
LineNumBase Doc. Abs. EntryInt
11TSI1
Sales Tax Invoice - Rows1
OpCodeOperation CodeInt
11OBSI
Brazil String Indexer
ObjTypeObject TypeInt
11ADP1
Object Settings - History
LogInstancLog InstanceInt
11
0

Table relationship map

SELECT statement

SELECT TPI2.BaseEntry AS 'Abs. Entry', TPI2.LineNum AS 'Base Doc. Abs. Entry', TPI2.OpCode AS 'Operation Code', TPI2.ObjType AS 'Object Type', TPI2.LogInstanc AS 'Log Instance' FROM TPI2 AS TPI2

Related information


Sales Tax Invoice OTSI SQL Table

Sales Tax Invoice - Rows1 TSI1 SQL Table

Object Settings - History ADP1 SQL Table

Brazil String Indexer OBSI 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