|
|
DTW Bill of Materials - Components
API Product Trees / Product Trees Lines
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | Father KEY | Parent Item | nVarChar | 20 | OITT Product Tree | FATHER | No |
|---|---|---|---|---|---|---|---|---|
| ChildNum | Component Element Number | Int | 11 | |||||
| Code KEY | Component Code | nVarChar | 20 | CHILD | No | |||
| Quantity | Quantity | Num | 20 | |||||
| Warehouse | Warehouse | nVarChar | 8 | OWHS Warehouses | ||||
| Price | Price | Num | 20 | |||||
| Currency | Currency | nVarChar | 3 | OCRN Currency Codes | ||||
| PriceList KEY | Price List | Int | 6 | OPLN Price Lists | 0 | PRICE_LIST | No | |
| 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
ITT1.Father AS 'Parent Item',
ITT1.ChildNum AS 'Component Element Number',
ITT1.Code AS 'Component Code',
ITT1.Quantity AS 'Quantity',
ITT1.Warehouse AS 'Warehouse',
ITT1.Price AS 'Price',
ITT1.Currency AS 'Currency',
ITT1.PriceList AS 'Price List',
ITT1.OrigPrice AS 'Original Price',
ITT1.OrigCurr AS 'Original Currency',
ITT1.IssueMthd AS 'Issue Method',
ITT1.Uom AS 'Inventory UoM',
ITT1.Comment AS 'Comment',
ITT1.LogInstanc AS 'Log Instance',
ITT1.Object AS 'Object',
ITT1.OcrCode AS 'Distribution Rule',
ITT1.OcrCode2 AS 'Distribution Rule2',
ITT1.OcrCode3 AS 'Distribution Rule3',
ITT1.OcrCode4 AS 'Distribution Rule4',
ITT1.OcrCode5 AS 'Distribution Rule5',
ITT1.PrncpInput AS 'Principal Input',
ITT1.Project AS 'Project Code',
ITT1.Type AS 'Component Type',
ITT1.WipActCode AS 'WIP Account Code',
ITT1.AddQuantit AS 'Additional Quantity',
ITT1.LineText AS 'Row Text'
FROM ITT1 AS ITT1
Related information
Product Trees Lines ProductTrees_Lines Object· Table: ITT1
ProductTrees_Lines is a child object of the ProductTrees object and it represents the line entries of each product tree. This object is part of the Inventory and Production module.
Source table: ITT1.
Parent: Product Trees ProductTrees Object· Table: OITT Currency Codes OCRN SQL 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
ProductTrees
Object
ProductTrees_Lines
Enumeration
Method
Property
Comment
DB
Currency
DB
InventoryUOM
DB
IssueMethod
DB
ItemCode
DB
ParentItem
DB
Price
DB
PriceList
DB
Quantity
DB
Warehouse
DB
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates