|
|
API ATT1
ATT1 - Bill of Materials - Components - History Table
Product Tree OITT SQL Table
Distribution Rule OOCR SQL Table
Price Lists OPLN SQL Table
Project Codes OPRJ SQL Table
Warehouses OWHS SQL Table
G/L Accounts OACT SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | Father KEY UNIQUE | Parent Item | nVarChar | 20 | OITT Product Tree | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| ChildNum | Child Element No. | Int | 11 | |||||
| Code | Child Code | nVarChar | 20 | |||||
| Quantity | Quantity | Num | 20 | |||||
| Warehouse | Warehouse | nVarChar | 8 | OWHS Warehouses | ||||
| Price | Price | Num | 20 | |||||
| Currency | Currency | nVarChar | 3 | |||||
| PriceList | Price List | Int | 6 | OPLN Price Lists | 0 | |||
| OrigPrice | Original Price | Num | 20 | |||||
| OrigCurr | Original Currency | nVarChar | 3 | |||||
| IssueMthd | Issue Method | VarChar | B) Backflush M) Manual | 1 | ||||
| Uom | Inventory UOM | nVarChar | 100 | |||||
| Comment | Comment | nVarChar | 127 | |||||
| LogInstanc | Log Instance | Int | 11 | |||||
| Object | Object | nVarChar | 20 | 66 | ||||
| OcrCode | Distribution Rule | nVarChar | 8 | OOCR Distribution Rule | ||||
| OcrCode2 | Distribution Rule2 | nVarChar | 8 | OOCR Distribution Rule | ||||
| OcrCode3 | Distribution Rule3 | nVarChar | 8 | OOCR Distribution Rule | ||||
| OcrCode4 | Distribution Rule4 | nVarChar | 8 | OOCR Distribution Rule | ||||
| OcrCode5 | Distribution Rule5 | nVarChar | 8 | OOCR Distribution Rule | ||||
| PrncpInput | Principal Input | VarChar | Y) Yes N) No | 1 | N | |||
| Project | Project Code | nVarChar | 20 | OPRJ Project Codes | ||||
| Type | Component Type | Int | 4) Item 290) Resource -18) Text | 11 | 4 | |||
| WipActCode | WIP Account Code | nVarChar | 15 | OACT G/L Accounts | ||||
| AddQuantit | Additional Quantity | Num | 20 | |||||
| LineText | Row Text | Text | 16 |
Table relationship map
SELECT statement
SELECT
ATT1.Father AS 'Parent Item',
ATT1.ChildNum AS 'Child Element No.',
ATT1.Code AS 'Child Code',
ATT1.Quantity AS 'Quantity',
ATT1.Warehouse AS 'Warehouse',
ATT1.Price AS 'Price',
ATT1.Currency AS 'Currency',
ATT1.PriceList AS 'Price List',
ATT1.OrigPrice AS 'Original Price',
ATT1.OrigCurr AS 'Original Currency',
ATT1.IssueMthd AS 'Issue Method',
ATT1.Uom AS 'Inventory UOM',
ATT1.Comment AS 'Comment',
ATT1.LogInstanc AS 'Log Instance',
ATT1.Object AS 'Object',
ATT1.OcrCode AS 'Distribution Rule',
ATT1.OcrCode2 AS 'Distribution Rule2',
ATT1.OcrCode3 AS 'Distribution Rule3',
ATT1.OcrCode4 AS 'Distribution Rule4',
ATT1.OcrCode5 AS 'Distribution Rule5',
ATT1.PrncpInput AS 'Principal Input',
ATT1.Project AS 'Project Code',
ATT1.Type AS 'Component Type',
ATT1.WipActCode AS 'WIP Account Code',
ATT1.AddQuantit AS 'Additional Quantity',
ATT1.LineText AS 'Row Text'
FROM ATT1 AS ATT1
Related information
Product Tree OITT SQL Table
Distribution Rule OOCR SQL Table
Price Lists OPLN SQL Table
Project Codes OPRJ SQL Table
Warehouses OWHS SQL Table
G/L Accounts OACT SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
