I_ProjectMaterialComponent

Project Material Component Details | view: IPROJMATCOMP | Extraction: Not supported | Component: Structures

Tables used: AFKO, AFKO, AFVC, AFVU, AFVV, RESB, JEST, PRTE, RESB, T001, TKA02, AUFK, MAST, MAKT, AUFK, T430, T001W, PROJ, PROJ, CNLDST_SHORTTX, GRPGA, RSADD, PRST, T024, T024E, KDST, LFA1, PRPS, CRHD, RSDB, RSDBS

🔑 Keys (3)
💰 Amounts (2)
∑ Quantities (7)
📅 Dates (3)
☰ Categorical (16)
Other (31)
🔗 Relations (27)

Column Name	Description
Reservation	Number of reservation/dependent requirements
ReservationItem	Item Number of Reservation / Dependent Requirements
RecordType	Record type

Column Name	Description
💲 Currency Key (Currency):
MaterialComponentPrice	Price in component currency
WithdrawnQuantityAmount	Value Withdrawn

Column Name	Description
📏 Base Unit of Measure (BaseUnit):
ShortfallQuantity	Shortfall Quantity of Component in Order
WithdrawnQuantity	Withdrawn Quantity
ReceivedQuantity	Received Quantity of Goods/Services
RequirementQuantityInBaseUnit	Requirement Quantity
MRPRequiredQuantityInBaseUnit	Required quantity for mat.management in stockkeeping units
ConfirmedAvailableQuantity	Confirmed quantity for availability check in SKU
OpenQuantity	null

Column Name	Description
LastChangeDate	Changed On
CreationDate	Date on which the record was created
MatlCompRequirementDate	Requirements date for the component

Column Name	Description
RqmtDateIsEnteredManually	Manual Maintenance of Requirement Date	Show values
BillOfMaterialCategory	BOM category	Show values
InventorySpecialStockValnType	Valuation of Special Stock	Show values
ConsumptionPosting	Consumption posting	Show values
ReservationIsFinallyIssued	Final Issue for Reservation	Show values
MatlCompIsMarkedForBackflush	Indicator: Backflush	Show values
IsBulkMaterialComponent	Indicator: bulk material	Show values
MatlCompIsTextItem	Item is Text indicator	Show values
MaterialComponentIsMissing	Missing Part	Show values
MatlCompIsMarkedForDeletion	Deletion Indicator	Show values
MatlCompIsRelevantForMRP	Effective for Materials Planning	Show values
GoodsMovementIsAllowed	Goods movement for reservation allowed	Show values
MaterialCompIsProcuredDirectly	Direct procurement indicator	Show values
MaterialComponentIsPhantomItem	Phantom item indicator	Show values
MatlCompIsProcuredExternally	Indicator: External procurement	Show values
MaterialCompMainAssemblyCat	BOM category	Show values

Column Name	Description	Domain name
ProjectNetworkInternalID	Routing number of operations in the order	AUFPL
NetworkActivityInternalID	Internal counter	CIM_COUNT
OperationLeadTimeOffset	Lead-time offset for operation	NLFZT
BillOfMaterialItemNumber	BOM item number	SPOSN
BOMItemDescription	BOM Item Text (Line 1)	TEXT40
SalesOrder	Sales Order	VBELN
SalesOrderItem	Sales Order Item	NUM06
GLAccount	G/L Account Number	SAKNR
PurchaseOrderExists	null
GoodsRecipientName	Recipient Name	WEMPF
RequisitionerUser	Name of requisitioner/requester	AFNAM
LastChangedByUser	Name of Person Who Changed Object	USNAM
CreatedByUser	Name of Person Responsible for Creating the Object	USNAM
BillingPlan	Billing plan number / invoicing plan number	FPLNR
ProjectNetworkDescription	Description	TEXT40
Project	Project Definition	PS_PSPID
ProjectWithCodingMask	Project Number (External) Edited	PS_PSPID_EDIT
NetworkActivity	Activity Number	VORNR
NumberOfMissingMatlComp	null
DeliveryDurationInDays	Delivery time in days	DEC3
GoodsReceiptDurationInDays	Goods receipt processing time in days	DEC3
MaterialPriceUnitQty	Price unit
UnloadingPointName	Unloading Point	TEXT25
ProcurementType	Procurement Type	CHAR3
MaterialQtyToBaseQtyDnmntr	Denominator for conversion to base units of measure	UMBSN
QuantityNumerator	Numerator for Conversion to Base Units of Measure	UMBSZ
CommittedQuantity	null
AssemblyName	Material Description	TEXT40
BOMHeaderText	Material Description	TEXT40
PurchaseRequisition	Purchase Requisition	BANFN
PurchaseOrderItem	Item Number of Purchasing Document	EBELP

Master Data Relations	Join Conditions
Account assignment category Client Account assignment category	`I_PROJECTMATERIALCOMPONENT.MANDT == T163K.MANDT` `I_PROJECTMATERIALCOMPONENT.ACCOUNTASSIGNMENTCATEGORY == T163K.KNTTP`
Material Number Client Material Number Material Number Material Number	`I_PROJECTMATERIALCOMPONENT.MANDT == MARA.MANDT` `I_PROJECTMATERIALCOMPONENT.MATERIAL == MARA.MATNR` `I_PROJECTMATERIALCOMPONENT.BILLOFMATERIAL == MARA.MATNR` `I_PROJECTMATERIALCOMPONENT.ASSEMBLY == MARA.MATNR`
Base Unit of Measure Client Base Unit of Measure	`I_PROJECTMATERIALCOMPONENT.MANDT == T006.MANDT` `I_PROJECTMATERIALCOMPONENT.BASEUNIT == T006.MSEHI`
Material Number Client Material Number Material Number Material Number	`I_PROJECTMATERIALCOMPONENT.MANDT == MARA.MANDT` `I_PROJECTMATERIALCOMPONENT.MATERIAL == MARA.MATNR` `I_PROJECTMATERIALCOMPONENT.BILLOFMATERIAL == MARA.MATNR` `I_PROJECTMATERIALCOMPONENT.ASSEMBLY == MARA.MATNR`
Item Category (BOM) Client Item Category (BOM)	`I_PROJECTMATERIALCOMPONENT.MANDT == T418.MANDT` `I_PROJECTMATERIALCOMPONENT.BOMITEMCATEGORY == T418.POSTP`
Controlling Area Client Controlling Area	`I_PROJECTMATERIALCOMPONENT.MANDT == TKA01.MANDT` `I_PROJECTMATERIALCOMPONENT.CONTROLLINGAREA == TKA01.KOKRS`
Vendor Account Number of Supplier Client	`I_PROJECTMATERIALCOMPONENT.CREDITOR == LFA1.LIFNR` `I_PROJECTMATERIALCOMPONENT.MANDT == LFA1.MANDT`
Currency Key Client Currency Key	`I_PROJECTMATERIALCOMPONENT.MANDT == TCURC.MANDT` `I_PROJECTMATERIALCOMPONENT.CURRENCY == TCURC.WAERS`
Formula Key Client Formula Key	`I_PROJECTMATERIALCOMPONENT.MANDT == T418F.MANDT` `I_PROJECTMATERIALCOMPONENT.FORMULAKEY == T418F.RFORM`
Movement Type (Inventory Management) Client Movement Type (Inventory Management)	`I_PROJECTMATERIALCOMPONENT.MANDT == T156.MANDT` `I_PROJECTMATERIALCOMPONENT.GOODSMOVEMENTTYPE == T156.BWART`
Material Number Client Material Number Material Number Material Number	`I_PROJECTMATERIALCOMPONENT.MANDT == MARA.MANDT` `I_PROJECTMATERIALCOMPONENT.MATERIAL == MARA.MATNR` `I_PROJECTMATERIALCOMPONENT.BILLOFMATERIAL == MARA.MATNR` `I_PROJECTMATERIALCOMPONENT.ASSEMBLY == MARA.MATNR`
Indicator for Relevancy to Costing Client Indicator for Relevancy to Costing	`I_PROJECTMATERIALCOMPONENT.MANDT == TCK08.MANDT` `I_PROJECTMATERIALCOMPONENT.MATERIALCOMPISCOSTRELEVANT == TCK08.SELKZ`
Special Stock Indicator Client Special Stock Indicator	`I_PROJECTMATERIALCOMPONENT.MANDT == T148.MANDT` `I_PROJECTMATERIALCOMPONENT.MATERIALCOMPISSPECIALSTOCK == T148.SOBKZ`
Material Group Client Material Group	`I_PROJECTMATERIALCOMPONENT.MANDT == T023.MANDT` `I_PROJECTMATERIALCOMPONENT.MATERIALGROUP == T023.MATKL`
Unit for lead-time offset for operation Client Unit for lead-time offset for operation	`I_PROJECTMATERIALCOMPONENT.MANDT == T006.MANDT` `I_PROJECTMATERIALCOMPONENT.OPERATIONLEADTIMEOFFSETUNIT == T006.MSEHI`
Plant Client Plant	`I_PROJECTMATERIALCOMPONENT.MANDT == T001W.MANDT` `I_PROJECTMATERIALCOMPONENT.PLANT == T001W.WERKS`
BOM explosion number Client BOM explosion number	`I_PROJECTMATERIALCOMPONENT.MANDT == SNUM.MANDT` `I_PROJECTMATERIALCOMPONENT.PRODUCTIONSERIES == SNUM.SERNR`
Order Number Client Order Number	`I_PROJECTMATERIALCOMPONENT.MANDT == AUFK.MANDT` `I_PROJECTMATERIALCOMPONENT.PROJECTNETWORK == AUFK.AUFNR`
Change Number Client Change Number	`I_PROJECTMATERIALCOMPONENT.MANDT == AENR.MANDT` `I_PROJECTMATERIALCOMPONENT.PROJECTOBJECTCHANGENUMBER == AENR.AENNR`
Purchasing Group Purchasing Group Client	`I_PROJECTMATERIALCOMPONENT.PURCHASINGGROUP == T024.EKGRP` `I_PROJECTMATERIALCOMPONENT.MANDT == T024.MANDT`
Storage Location Client Storage Location Plant	`I_PROJECTMATERIALCOMPONENT.MANDT == T001L.MANDT` `I_PROJECTMATERIALCOMPONENT.STORAGELOCATION == T001L.LGORT` `I_PROJECTMATERIALCOMPONENT.PLANT == T001L.WERKS`
Supplier to be Supplied/Who is to Receive Delivery Client Supplier to be Supplied/Who is to Receive Delivery	`I_PROJECTMATERIALCOMPONENT.MANDT == LFA1.MANDT` `I_PROJECTMATERIALCOMPONENT.SUPPLIER == LFA1.LIFNR`