I_POSubcontractingCompAPI01

Subcontracting Component in PurOrd | view: IMMPOSUBCOMP | TRAN | Extraction: Not supported | Component: Purchase Orders

Tables used: EKKO, RESB, TCS03

🔑 Keys (5)
💰 Amounts
∑ Quantities (9)
📅 Dates (3)
☰ Categorical (9)
Other (16)
🔗 Relations (19)

Column Name	Description
PurchaseOrder FK	Purchasing Document
PurchaseOrderItem FK	Purchasing Document Item
PurchaseOrderScheduleLine FK	Delivery Schedule Line Counter
ReservationItem	Reservation Item
RecordType	Reservation Record Type

Column Name	Description

Column Name	Description
📏 Base Unit of Measure (BaseUnit):
RequiredQuantity	Requirement Quantity
WithdrawnQuantity	Withdrawn Quantity
📏 Unit of entry (EntryUnit):
QuantityInEntryUnit	Quantity in Unit of Entry
📏 Unit of measure for sizes 1 to 3 (UnitOfMeasureForSize1To3):
NumberOfVariableSizeComponents	Number of Variable-Size Components
Size1	Size 1
Size2	Size 2
Size3	Size 3
📏 Variable-Size Item Unit of Measure (VariableSizeItemUnit):
VariableSizeItemQuantity	Number of Variable-Size Components
📏 Unit of Measure for Variable-Size Components (VariableSizeComponentUnit):
VariableSizeComponentQuantity	Variable-Size Item Quantity per PC

Column Name	Description
RequirementDate	Material Component Requirement Date
RequirementTime	Material Component Requirement Time
LatestRequirementDate	Latest Requirement Date

Column Name	Description
QuantityIsFixed	Quantity is fixed	Show values
MaterialComponentIsPhantomItem	Phantom Item Indicator	Show values
IsBulkMaterialComponent	Indicator: bulk material	Show values
ConsumptionPosting	Consumption Posting	Show values
InventorySpecialStockValnType	Inventory Special Stock Valuation Type	Show values
DebitCreditCode	Debit/Credit Code	Show values
ReservationIsFinallyIssued	Final Issue for Reservation	Show values
IsNetScrap	Net Scrap Indicator	Show values
MaterialCompIsVariableSized	Variable-Sized Item Indicator	Show values

Column Name	Description	Domain name
Reservation	Number of reservation/dependent requirements	RSNUM
OrderLevelValue	Order level	AUFST
OrderPathValue	Order path	AUFWG
BillOfMaterialItemNumber	BOM item number	SPOSN
BillOfMaterialItemNumber_2	Bill Of Material Item Number	VDM_SPOSN
SortField	Sort String	CHAR10
MaterialQtyToBaseQtyNmrtr	Numerator for Conversion to Base Units of Measure	UMBSZ
MaterialQtyToBaseQtyDnmntr	Denominator for conversion to base units of measure	UMBSN
ComponentScrapInPercent	Component Scrap in Percent	DEC3_2
OperationScrapInPercent	Operation Scrap	DEC3_2
LeadTimeOffset	Lead-Time Offset	NLFZT
MaterialRevisionLevel	Revision Level	REVLV
MaterialRevisionLevel_2	Revision Level	VDM_QM_REVLV
ProductionSupplyArea	Production Supply Area	PRVBE
BOMItemDescription	BOM Item Text (Line 1)	TEXT40
BOMItemText2	BOM Item Text (Line 2)	TEXT40

Master Data Relations	Join Conditions
Account Assignment Category Account Assignment Category Client	`I_POSUBCONTRACTINGCOMPAPI01.ACCOUNTASSIGNMENTCATEGORY == T163K.KNTTP` `I_POSUBCONTRACTINGCOMPAPI01.MANDT == T163K.MANDT`
Base Unit of Measure Client Base Unit of Measure	`I_POSUBCONTRACTINGCOMPAPI01.MANDT == T006.MANDT` `I_POSUBCONTRACTINGCOMPAPI01.BASEUNIT == T006.MSEHI`
Batch Number Client Material Number Batch Number Plant	`I_POSUBCONTRACTINGCOMPAPI01.MANDT == MCHA.MANDT` `I_POSUBCONTRACTINGCOMPAPI01.MATERIAL == MCHA.MATNR` `I_POSUBCONTRACTINGCOMPAPI01.BATCH == MCHA.CHARG` `I_POSUBCONTRACTINGCOMPAPI01.PLANT == MCHA.WERKS`
Bill of Material Item Category Bill of Material Item Category Client	`I_POSUBCONTRACTINGCOMPAPI01.BOMITEMCATEGORY == T418.POSTP` `I_POSUBCONTRACTINGCOMPAPI01.MANDT == T418.MANDT`
Change Number Change Number Client	`I_POSUBCONTRACTINGCOMPAPI01.CHANGENUMBER == AENR.AENNR` `I_POSUBCONTRACTINGCOMPAPI01.MANDT == AENR.MANDT`
Unit of entry Unit of entry Client	`I_POSUBCONTRACTINGCOMPAPI01.ENTRYUNIT == T006.MSEHI` `I_POSUBCONTRACTINGCOMPAPI01.MANDT == T006.MANDT`
Formula Key for Variable-Size Items Formula Key for Variable-Size Items Client	`I_POSUBCONTRACTINGCOMPAPI01.FORMULAKEY == T418F.RFORM` `I_POSUBCONTRACTINGCOMPAPI01.MANDT == T418F.MANDT`
Inventory Special Stock Type Client Inventory Special Stock Type	`I_POSUBCONTRACTINGCOMPAPI01.MANDT == T148.MANDT` `I_POSUBCONTRACTINGCOMPAPI01.INVENTORYSPECIALSTOCKTYPE == T148.SOBKZ`
Material Provision Indicator Client Material Provision Indicator Material Provision Type	`I_POSUBCONTRACTINGCOMPAPI01.MANDT == T417.MANDT` `I_POSUBCONTRACTINGCOMPAPI01.ISMATERIALPROVISION == T417.BEIKZ` `I_POSUBCONTRACTINGCOMPAPI01.MATERIALPROVISIONTYPE == T417.BEIKZ`
Material Number Client Material Number	`I_POSUBCONTRACTINGCOMPAPI01.MANDT == MARA.MANDT` `I_POSUBCONTRACTINGCOMPAPI01.MATERIAL == MARA.MATNR`
Material Provision Type Client Material Provision Indicator Material Provision Type	`I_POSUBCONTRACTINGCOMPAPI01.MANDT == T417.MANDT` `I_POSUBCONTRACTINGCOMPAPI01.ISMATERIALPROVISION == T417.BEIKZ` `I_POSUBCONTRACTINGCOMPAPI01.MATERIALPROVISIONTYPE == T417.BEIKZ`
Plant Client Plant	`I_POSUBCONTRACTINGCOMPAPI01.MANDT == T001W.MANDT` `I_POSUBCONTRACTINGCOMPAPI01.PLANT == T001W.WERKS`
Distribution Key Client MRP Distribution Key Plant	`I_POSUBCONTRACTINGCOMPAPI01.MANDT == T437V.MANDT` `I_POSUBCONTRACTINGCOMPAPI01.QUANTITYDISTRIBUTIONKEY == T437V.VERTL` `I_POSUBCONTRACTINGCOMPAPI01.PLANT == T437V.WERKS`
Storage Location Client Storage Location Plant	`I_POSUBCONTRACTINGCOMPAPI01.MANDT == T001L.MANDT` `I_POSUBCONTRACTINGCOMPAPI01.STORAGELOCATION == T001L.LGORT` `I_POSUBCONTRACTINGCOMPAPI01.PLANT == T001L.WERKS`
Unit of measure for sizes 1 to 3 Client Unit of measure for sizes 1 to 3	`I_POSUBCONTRACTINGCOMPAPI01.MANDT == T006.MANDT` `I_POSUBCONTRACTINGCOMPAPI01.UNITOFMEASUREFORSIZE1TO3 == T006.MSEHI`
Unit of Measure for Variable-Size Components Client Unit of Measure for Variable-Size Components	`I_POSUBCONTRACTINGCOMPAPI01.MANDT == T006.MANDT` `I_POSUBCONTRACTINGCOMPAPI01.VARIABLESIZECOMPONENTUNIT == T006.MSEHI`