I_ProjectMaterialCompBasicData

Project Material Component Basic Data | view: IPRJMATCOMBASDAT | Extraction: Not supported | Component: Structures
Tables used: RESB
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
Column Name Description
📏 Base Unit of Measure (BaseUnit):
OpenQuantity null
RequirementQuantityInBaseUnit Requirement Quantity
WithdrawnQuantity Withdrawn Quantity
ReceivedQuantity Received Quantity of Goods/Services
ShortfallQuantity Shortfall Quantity of Component in Order
MRPRequiredQuantityInBaseUnit Required quantity for mat.management in stockkeeping units
Column Name Description
MatlCompRequirementDate Requirements date for the component
Column Name Description
MaterialComponentIsMissing Missing Part Show values
ReservationIsFinallyIssued Final Issue for Reservation Show values
GoodsMovementIsAllowed Goods movement for reservation allowed Show values
MatlCompIsMarkedForDeletion Deletion Indicator Show values
MatlCompIsMarkedForBackflush Indicator: Backflush Show values
IsBulkMaterialComponent Indicator: bulk material Show values
ConsumptionPosting Consumption posting Show values
RqmtDateIsEnteredManually Manual Maintenance of Requirement Date Show values
BillOfMaterialCategory BOM category Show values
Column Name Description Domain name
DeliveryDurationInDays Delivery time in days DEC3
GoodsReceiptDurationInDays Goods receipt processing time in days DEC3
BillOfMaterialItemNumber Undefined range (can be used for patch levels) CHAR4
ProjectNetworkInternalID Routing number of operations in the order AUFPL
NetworkActivityInternalID Internal counter CIM_COUNT
CommittedQuantity null
SalesOrder Sales Order VBELN
SalesOrderItem Sales Order Item NUM06
GoodsRecipientName Recipient Name WEMPF
UnloadingPointName Unloading Point TEXT25
MaterialPriceUnitQty Price unit
GLAccount G/L Account Number SAKNR
OperationLeadTimeOffset Lead-time offset for operation NLFZT
BOMItemDescription BOM Item Text (Line 1) TEXT40
NetworkActivity Activity number in network and standard network
NumberOfAssignedMaterials null
BillOfMaterialVariant Alternative BOM ALTNR
Master Data Relations Join Conditions
Account assignment category
  • Account assignment category
  • Client
  • I_PROJECTMATERIALCOMPBASICDATA.ACCOUNTASSIGNMENTCATEGORY == T163K.KNTTP
  • I_PROJECTMATERIALCOMPBASICDATA.MANDT == T163K.MANDT
Base Unit of Measure
  • Base Unit of Measure
  • Client
  • I_PROJECTMATERIALCOMPBASICDATA.BASEUNIT == T006.MSEHI
  • I_PROJECTMATERIALCOMPBASICDATA.MANDT == T006.MANDT
Item Category (BOM)
  • Item Category (BOM)
  • Client
  • I_PROJECTMATERIALCOMPBASICDATA.BOMITEMCATEGORY == T418.POSTP
  • I_PROJECTMATERIALCOMPBASICDATA.MANDT == T418.MANDT
Vendor
  • Client
  • Account Number of Supplier
  • I_PROJECTMATERIALCOMPBASICDATA.MANDT == LFA1.MANDT
  • I_PROJECTMATERIALCOMPBASICDATA.CREDITOR == LFA1.LIFNR
Currency Key
  • Client
  • Currency Key
  • I_PROJECTMATERIALCOMPBASICDATA.MANDT == TCURC.MANDT
  • I_PROJECTMATERIALCOMPBASICDATA.CURRENCY == TCURC.WAERS
Formula Key
  • Client
  • Formula Key
  • I_PROJECTMATERIALCOMPBASICDATA.MANDT == T418F.MANDT
  • I_PROJECTMATERIALCOMPBASICDATA.FORMULAKEY == T418F.RFORM
Movement Type (Inventory Management)
  • Movement Type (Inventory Management)
  • Client
  • I_PROJECTMATERIALCOMPBASICDATA.GOODSMOVEMENTTYPE == T156.BWART
  • I_PROJECTMATERIALCOMPBASICDATA.MANDT == T156.MANDT
Material Number
  • Material Number
  • Client
  • I_PROJECTMATERIALCOMPBASICDATA.MATERIAL == MARA.MATNR
  • I_PROJECTMATERIALCOMPBASICDATA.MANDT == MARA.MANDT
Indicator for Relevancy to Costing
  • Indicator for Relevancy to Costing
  • Client
  • I_PROJECTMATERIALCOMPBASICDATA.MATERIALCOMPISCOSTRELEVANT == TCK08.SELKZ
  • I_PROJECTMATERIALCOMPBASICDATA.MANDT == TCK08.MANDT
Special Stock Indicator
  • Special Stock Indicator
  • Client
  • I_PROJECTMATERIALCOMPBASICDATA.MATERIALCOMPISSPECIALSTOCK == T148.SOBKZ
  • I_PROJECTMATERIALCOMPBASICDATA.MANDT == T148.MANDT
Unit for lead-time offset for operation
  • Unit for lead-time offset for operation
  • Client
  • I_PROJECTMATERIALCOMPBASICDATA.OPERATIONLEADTIMEOFFSETUNIT == T006.MSEHI
  • I_PROJECTMATERIALCOMPBASICDATA.MANDT == T006.MANDT
Plant
  • Plant
  • Client
  • I_PROJECTMATERIALCOMPBASICDATA.PLANT == T001W.WERKS
  • I_PROJECTMATERIALCOMPBASICDATA.MANDT == T001W.MANDT
BOM explosion number
  • Client
  • BOM explosion number
  • I_PROJECTMATERIALCOMPBASICDATA.MANDT == SNUM.MANDT
  • I_PROJECTMATERIALCOMPBASICDATA.PRODUCTIONSERIES == SNUM.SERNR
Order Number
  • Order Number
  • Client
  • I_PROJECTMATERIALCOMPBASICDATA.PROJECTNETWORK == AUFK.AUFNR
  • I_PROJECTMATERIALCOMPBASICDATA.MANDT == AUFK.MANDT
Change Number
  • Change Number
  • Client
  • I_PROJECTMATERIALCOMPBASICDATA.PROJECTOBJECTCHANGENUMBER == AENR.AENNR
  • I_PROJECTMATERIALCOMPBASICDATA.MANDT == AENR.MANDT
Purchasing Group
  • Client
  • Purchasing Group
  • I_PROJECTMATERIALCOMPBASICDATA.MANDT == T024.MANDT
  • I_PROJECTMATERIALCOMPBASICDATA.PURCHASINGGROUP == T024.EKGRP
Storage Location
  • Plant
  • Storage Location
  • Client
  • I_PROJECTMATERIALCOMPBASICDATA.PLANT == T001L.WERKS
  • I_PROJECTMATERIALCOMPBASICDATA.STORAGELOCATION == T001L.LGORT
  • I_PROJECTMATERIALCOMPBASICDATA.MANDT == T001L.MANDT