|
|
API OITT / Product Trees
OITT - Product Tree Table
Product Trees ProductTrees Object· Table: OITT
OITT SQL Table
Items OITM SQL Table
Distribution Rule OOCR SQL Table
Price Lists OPLN SQL Table
Project Codes OPRJ SQL Table
Users OUSR SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | Code KEY UNIQUE | Parent Item | nVarChar | 20 | OITM Items | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| TreeType | BOM Type | VarChar | A) Assembly S) Sales P) Production T) Template | 1 | P | |||
| PriceList KEY | Price List | Int | 6 | OPLN Price Lists | 0 | PRICE_LIST | No | |
| Qauntity | No. of Units | Num | 20 | |||||
| UseFthrWhs | Issue from Parent Warehouse | VarChar | Y) Yes N) No | 1 | N | |||
| CreateDate | Creation Date | Date | 8 | |||||
| UpdateDate | Date of Update | Date | 8 | |||||
| Transfered | Postponed to Next Year | VarChar | Y) Yes N) No | 1 | N | |||
| DataSource | Data source | VarChar | N) Unknown I) Interface U) Update M) Import O) DI API A) Doc. Generation Wizard D) Restore Wizard P) Partner Implementation T) Year Transfer | 1 | N | |||
| UserSign | User Signature | Int | 6 | OUSR Users | ||||
| SCNCounter | SCN Counter | Int | 6 | |||||
| DispCurr | Display Currency | nVarChar | 3 | |||||
| ToWH | Whse for Finished Product | nVarChar | 8 | |||||
| Object | Object Type | nVarChar | 20 | 66 | ||||
| LogInstac | Log Instance - History | Int | 11 | |||||
| UserSign2 | Updating User | Int | 11 | OUSR Users | ||||
| OcrCode | Distribution Rule | nVarChar | 8 | OOCR Distribution Rule | ||||
| HideComp | Hide Components in Printing | VarChar | Y) Yes N) No | 1 | N | |||
| 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 | ||||
| UpdateTime | Time of Update | Int | 11 | |||||
| Project | Project Code | nVarChar | 20 | OPRJ Project Codes |
Table relationship map
SELECT statement
SELECT
OITT.Code AS 'Parent Item',
OITT.TreeType AS 'BOM Type',
OITT.PriceList AS 'Price List',
OITT.Qauntity AS 'No. of Units',
OITT.UseFthrWhs AS 'Issue from Parent Warehouse',
OITT.CreateDate AS 'Creation Date',
OITT.UpdateDate AS 'Date of Update',
OITT.Transfered AS 'Postponed to Next Year',
OITT.DataSource AS 'Data source',
OITT.UserSign AS 'User Signature',
OITT.SCNCounter AS 'SCN Counter',
OITT.DispCurr AS 'Display Currency',
OITT.ToWH AS 'Whse for Finished Product',
OITT.Object AS 'Object Type',
OITT.LogInstac AS 'Log Instance - History',
OITT.UserSign2 AS 'Updating User',
OITT.OcrCode AS 'Distribution Rule',
OITT.HideComp AS 'Hide Components in Printing',
OITT.OcrCode2 AS 'Distribution Rule2',
OITT.OcrCode3 AS 'Distribution Rule3',
OITT.OcrCode4 AS 'Distribution Rule4',
OITT.OcrCode5 AS 'Distribution Rule5',
OITT.UpdateTime AS 'Time of Update',
OITT.Project AS 'Project Code'
FROM OITT AS OITT
Related information
Product Trees ProductTrees Object· Table: OITT
ProductTrees is a business object that represents a completed product comprising parts and raw materials, which is described by means of a bill of materials. This object is part of the Inventory module.
This object enables you to:
Add an item...
OITT SQL Table
Items OITM SQL Table
Distribution Rule OOCR SQL Table
Price Lists OPLN SQL Table
Project Codes OPRJ SQL Table
Users OUSR SQL Table
ProductTrees
Enumeration
Method
Object
ProductTrees_Lines ITT1
Property
Quantity
DB
TreeCode
DB
TreeType
DB
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
