|
|
DTW Inventory / Item Management / Batches
API TCD2
TCD2 - Key Field Values Table
TCD2 SQL Table
Key Fields for Determination TCD1 SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | AbsId KEY UNIQUE | Internal Number | Int | 11 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| Tcd1Id KEY UNIQUE | Tax Determination ID | Int | 11 | TCD1 Key Fields for Determination | TCD2_UNI | Yes | ||
| DispOrder | Display Order | Int | 11 | |||||
| KeyFld_1_V | Key Fields 1 Value | nVarChar | 50 | |||||
| KeyFld_2_V | Key Fields 2 Value | nVarChar | 50 | |||||
| KeyFld_3_V | Key Fields 3 Value | nVarChar | 50 | |||||
| KeyFld_4_V | Key Fields 4 Value | nVarChar | 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
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates