biuan SAP® BUSINESS ONE SDK
DTW Inventory / Item Management / Batches
API TCD2
TCD2 - Key Field Values Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsId KEY UNIQUEInternal NumberInt
11
PRIMARYYes
Tcd1Id KEY UNIQUETax Determination IDInt
11TCD1
Key Fields for Determination
TCD2_UNIYes
DispOrderDisplay OrderInt
11
KeyFld_1_VKey Fields 1 ValuenVarChar
50
KeyFld_2_VKey Fields 2 ValuenVarChar
50
KeyFld_3_VKey Fields 3 ValuenVarChar
50
KeyFld_4_VKey Fields 4 ValuenVarChar
50

Table relationship map

SELECT statement

SELECT TCD2.AbsId AS 'Internal Number', TCD2.Tcd1Id AS 'Tax Determination ID', TCD2.DispOrder AS 'Display Order', TCD2.KeyFld_1_V AS 'Key Fields 1 Value', TCD2.KeyFld_2_V AS 'Key Fields 2 Value', TCD2.KeyFld_3_V AS 'Key Fields 3 Value', TCD2.KeyFld_4_V AS 'Key Fields 4 Value' FROM TCD2 AS TCD2

Related information


TCD2 SQL Table

Key Fields for Determination TCD1 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