|
|
API TCN2
TCN2 - Tracking Note - Brokers Table
Tracking Note OTCN SQL Table
Blanket Agreement OOAT SQL Table
Business Partner OCRD 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 | |||||
| CardCode | BP Code | nVarChar | 15 | OCRD Business Partner | ||||
| AgrNo | Blanket Agreement Number | Int | 11 | OOAT Blanket Agreement |
Table relationship map
SELECT statement
SELECT
TCN2.AbsEntry AS 'Abs. Entry',
TCN2.LineNum AS 'Row Number',
TCN2.CardCode AS 'BP Code',
TCN2.AgrNo AS 'Blanket Agreement Number'
FROM TCN2 AS TCN2
Related information
Tracking Note OTCN SQL Table
Blanket Agreement OOAT SQL Table
Business Partner OCRD SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
