|
|
API TCN1
TCN1 - Tracking Note - Line Data Table
TCN1 SQL Table
Tracking Note OTCN SQL Table
Items OITM SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | AbsEntry KEY UNIQUE | Abs. Entry | Int | 11 | OTCN Tracking Note | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| LineNum | Row Number | Int | 11 | |||||
| ItemCCDNum | Item CCD Number | nVarChar | 20 | |||||
| ItemCode | Item Code | nVarChar | 20 | OITM Items | ||||
| Quantity | Quantity | Num | 20 |
Table relationship map
SELECT statement
SELECT
TCN1.AbsEntry AS 'Abs. Entry',
TCN1.LineNum AS 'Row Number',
TCN1.ItemCCDNum AS 'Item CCD Number',
TCN1.ItemCode AS 'Item Code',
TCN1.Quantity AS 'Quantity'
FROM TCN1 AS TCN1
Related information
TCN1 SQL Table
Tracking Note OTCN SQL Table
Items OITM SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
