P_ProjMatComponentWithVers

Mat Component Union (Operative + Ver.) | view: PPROJMATCOMPVERS | Extraction: Not supported | Component: Structures

Tables used: AFKO, AFKO, AFVC, AFVU, AFVV, RESB, JEST, PRTE, RESB, T001, TKA02, AUFK, MAST, MAKT, AUFK, T430, T430, VSAFKO_CN, VSAFVC_CN, VSAFVU_CN, VSAFVV_CN, VSAUFK_CN, T001W, PROJ, PROJ, CNLDST_SHORTTX, GRPGA, RSADD, VSPROJ_CN, GRPGA, VSRESB_CN, VSRSADD_CN, PRST, T024, T024E, KDST, LFA1, PRPS, VSPRPS_CN, VSPRTE_CN, CRHD, RSDB, RSDBS

🔑 Keys (4)
💰 Amounts (2)
∑ Quantities (7)
📅 Dates (3)
☰ Categorical (16)
Other (29)
🔗 Relations (23)

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

Column Name	Description
💲 Currency Key (Currency):
MaterialComponentPrice	Total Price in Local Currency
WithdrawnQuantityAmount	Value Withdrawn

Column Name	Description
📏 Base Unit of Measure (BaseUnit):
ShortfallQuantity	Shortfall Quantity of Component in Order
WithdrawnQuantity	Withdrawn Quantity
MRPRequiredQuantityInBaseUnit	Required quantity for mat.management in stockkeeping units
RequirementQuantityInBaseUnit	Requirement Quantity
ConfirmedAvailableQuantity	Confirmed quantity for availability check in SKU
ReceivedQuantity	Received Quantity of Goods/Services
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
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
RqmtDateIsEnteredManually	Manual Maintenance of Requirement Date	Show values
BillOfMaterialCategory	BOM category	Show values
MaterialCompMainAssemblyCat	BOM category	Show values

Column Name	Description	Domain name
IsProjectVersionObject	null
SalesOrder	Sales Order	VBELN
SalesOrderItem	Sales Order Item	NUM06
GLAccount	G/L Account Number	SAKNR
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
Supplier	Supplier to be Supplied/Who is to Receive Delivery	LIFNR
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	PACK3
PurchaseRequisition	Purchase Requisition	BANFN
UnloadingPointName	Unloading Point	TEXT25
PurchaseOrderExists	null
ProductionSeries	BOM explosion number	SERNR
OperationLeadTimeOffset	Lead-time offset for operation	NLFZT
BillOfMaterialItemNumber	BOM item number	SPOSN
ProcurementType	Procurement Type	CHAR3
BOMItemDescription	BOM Item Text (Line 1)	TEXT40
CommittedQuantity	null
AssemblyName	Material Description	TEXT40
BOMHeaderText	Material Description	TEXT40

Master Data Relations	Join Conditions
Account assignment category Client Account assignment category	`P_PROJMATCOMPONENTWITHVERS.MANDT == T163K.MANDT` `P_PROJMATCOMPONENTWITHVERS.ACCOUNTASSIGNMENTCATEGORY == T163K.KNTTP`
Material Number Client Material Number Material Number Material Number	`P_PROJMATCOMPONENTWITHVERS.MANDT == MARA.MANDT` `P_PROJMATCOMPONENTWITHVERS.MATERIAL == MARA.MATNR` `P_PROJMATCOMPONENTWITHVERS.ASSEMBLY == MARA.MATNR` `P_PROJMATCOMPONENTWITHVERS.BILLOFMATERIAL == MARA.MATNR`
Base Unit of Measure Client Base Unit of Measure	`P_PROJMATCOMPONENTWITHVERS.MANDT == T006.MANDT` `P_PROJMATCOMPONENTWITHVERS.BASEUNIT == T006.MSEHI`
Material Number Client Material Number Material Number Material Number	`P_PROJMATCOMPONENTWITHVERS.MANDT == MARA.MANDT` `P_PROJMATCOMPONENTWITHVERS.MATERIAL == MARA.MATNR` `P_PROJMATCOMPONENTWITHVERS.ASSEMBLY == MARA.MATNR` `P_PROJMATCOMPONENTWITHVERS.BILLOFMATERIAL == MARA.MATNR`
Item Category (BOM) Client Item Category (BOM)	`P_PROJMATCOMPONENTWITHVERS.MANDT == T418.MANDT` `P_PROJMATCOMPONENTWITHVERS.BOMITEMCATEGORY == T418.POSTP`
Controlling Area Client Controlling Area	`P_PROJMATCOMPONENTWITHVERS.MANDT == TKA01.MANDT` `P_PROJMATCOMPONENTWITHVERS.CONTROLLINGAREA == TKA01.KOKRS`
Account Number of Supplier Client Account Number of Supplier	`P_PROJMATCOMPONENTWITHVERS.MANDT == LFA1.MANDT` `P_PROJMATCOMPONENTWITHVERS.CREDITOR == LFA1.LIFNR`
Currency Key Client Currency Key	`P_PROJMATCOMPONENTWITHVERS.MANDT == TCURC.MANDT` `P_PROJMATCOMPONENTWITHVERS.CURRENCY == TCURC.WAERS`
Formula Key Client Formula Key	`P_PROJMATCOMPONENTWITHVERS.MANDT == T418F.MANDT` `P_PROJMATCOMPONENTWITHVERS.FORMULAKEY == T418F.RFORM`
Movement Type (Inventory Management) Client Movement Type (Inventory Management)	`P_PROJMATCOMPONENTWITHVERS.MANDT == T156.MANDT` `P_PROJMATCOMPONENTWITHVERS.GOODSMOVEMENTTYPE == T156.BWART`
Material Number Client Material Number Material Number Material Number	`P_PROJMATCOMPONENTWITHVERS.MANDT == MARA.MANDT` `P_PROJMATCOMPONENTWITHVERS.MATERIAL == MARA.MATNR` `P_PROJMATCOMPONENTWITHVERS.ASSEMBLY == MARA.MATNR` `P_PROJMATCOMPONENTWITHVERS.BILLOFMATERIAL == MARA.MATNR`
Indicator for Relevancy to Costing Client Indicator for Relevancy to Costing	`P_PROJMATCOMPONENTWITHVERS.MANDT == TCK08.MANDT` `P_PROJMATCOMPONENTWITHVERS.MATERIALCOMPISCOSTRELEVANT == TCK08.SELKZ`
Special Stock Indicator Client Special Stock Indicator	`P_PROJMATCOMPONENTWITHVERS.MANDT == T148.MANDT` `P_PROJMATCOMPONENTWITHVERS.MATERIALCOMPISSPECIALSTOCK == T148.SOBKZ`
Plant Client Plant	`P_PROJMATCOMPONENTWITHVERS.MANDT == T001W.MANDT` `P_PROJMATCOMPONENTWITHVERS.PLANT == T001W.WERKS`
Order Number Client Order Number	`P_PROJMATCOMPONENTWITHVERS.MANDT == AUFK.MANDT` `P_PROJMATCOMPONENTWITHVERS.PROJECTNETWORK == AUFK.AUFNR`
Change Number Client Change Number	`P_PROJMATCOMPONENTWITHVERS.MANDT == AENR.MANDT` `P_PROJMATCOMPONENTWITHVERS.PROJECTOBJECTCHANGENUMBER == AENR.AENNR`
Purchasing Group Purchasing Group Client	`P_PROJMATCOMPONENTWITHVERS.PURCHASINGGROUP == T024.EKGRP` `P_PROJMATCOMPONENTWITHVERS.MANDT == T024.MANDT`
Storage Location Client Plant Storage Location	`P_PROJMATCOMPONENTWITHVERS.MANDT == T001L.MANDT` `P_PROJMATCOMPONENTWITHVERS.PLANT == T001L.WERKS` `P_PROJMATCOMPONENTWITHVERS.STORAGELOCATION == T001L.LGORT`