| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
DTW Bill of Materials - Components API Product Trees / Product Trees Lines | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
ITT1 - Bill of Materials - Components Table SBO SQL database table details
Table relationship mapSELECT statementSELECT
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 informationProduct 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. ![]() 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 |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
SAP® Business One is the trademark(s) or registered trademark(s) of SAP AG in Germany and in several other countries. Contact This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates |