C_MfgOrdCompExcsConsmptQry

Mfg Order Operation Component Excess Consumption - Query | view: CPPMFGORCOMPECQ | Extraction: Not supported | Component: Virtual Data Model in PP
Tables used: SCAL_TT_DATEAFKOAFVCRESBT001TKA02AUFKMARAMARCMAKTT024DT003OT003PT001WT024FT001LTCS03
Column Name Description
Reservation Number of reservation/dependent requirements
ReservationItem Reservation Item
Column Name Description
💲 Currency Key (Currency):
WithdrawnQuantityAmount Value Withdrawn
💲 Company Code Currency (CompanyCodeCurrency):
WithdrawnQtyAmountInCoCodeCry Withdrawn Amount in Company Code Currency
DeviationQtyAmountInCoCodeCrcy Value Withdrawn
Column Name Description
📏 Base Unit of Measure (BaseUnit):
WithdrawnQuantity Withdrawn Quantity
RequiredQuantity Requirement Quantity
DeviationQuantity Deviation Quantity
OriginalDemandQuantity Original Demand Quantity
ExcessConsumptionQuantity Excess Consumption Quantity
Column Name Description
MatlCompRequirementDate Material Component Requirement Date
MatlCompRequirementTime Material Component Requirement Time
Column Name Description
ManufacturingOrderCategory Manufacturing Order Category Show values
ReportingPeriod Reporting Period Show values
Column Name Description Domain name
MaterialName Material Description TEXT40
ProductionPlant Production Plant WERKS
ProductionPlantName Plant Name
MRPControllerName MRP Controller Name TEXT18
ProductionSupervisor Production Supervisor
ProductionSupervisorName Production Supervisor Name
StorageLocationName Storage Location Name TEXT16
ManufacturingOrderCategoryName Manufacturing Order Category Name DDTEXT
ManufacturingOrderType Manufacturing Order Type AUFART
ManufacturingOrderTypeName Manufacturing Order Type Name TEXT40
RequirementDateWeek Calendar Week NUM2
RequirementDateMonth Calendar Month NUM2
RequirementDateMonthName Short Text for Fixed Values DDTEXT
ReportingPeriodName Reporting Period Name DDTEXT
ManufacturingOrderOperation Operation/Phase Number VORNR
MaterialExpectedScrapPercent Component Scrap in Percent
ComponentScrapInPercent null
ExcessConsumptionInPercent null
ComponentScrapDeviationPercent null
StockSegment Stock Segment
RequirementSegment Requirement Segment
Master Data Relations Join Conditions
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • C_MFGORDCOMPEXCSCONSMPTQRY.MANDT == T006.MANDT
  • C_MFGORDCOMPEXCSCONSMPTQRY.BASEUNIT == T006.MSEHI
Batch Number
  • Batch Number
  • Client
  • Material Number
  • Production Plant
  • C_MFGORDCOMPEXCSCONSMPTQRY.BATCH == MCHA.CHARG
  • C_MFGORDCOMPEXCSCONSMPTQRY.MANDT == MCHA.MANDT
  • C_MFGORDCOMPEXCSCONSMPTQRY.MATERIAL == MCHA.MATNR
  • C_MFGORDCOMPEXCSCONSMPTQRY.PRODUCTIONPLANT == MCHA.WERKS
Company Code Currency
  • Client
  • Company Code Currency
  • Currency Key
  • C_MFGORDCOMPEXCSCONSMPTQRY.MANDT == TCURC.MANDT
  • C_MFGORDCOMPEXCSCONSMPTQRY.COMPANYCODECURRENCY == TCURC.WAERS
  • C_MFGORDCOMPEXCSCONSMPTQRY.CURRENCY == TCURC.WAERS
Currency Key
  • Client
  • Company Code Currency
  • Currency Key
  • C_MFGORDCOMPEXCSCONSMPTQRY.MANDT == TCURC.MANDT
  • C_MFGORDCOMPEXCSCONSMPTQRY.COMPANYCODECURRENCY == TCURC.WAERS
  • C_MFGORDCOMPEXCSCONSMPTQRY.CURRENCY == TCURC.WAERS
Manufacturing Order ID
  • Manufacturing Order ID
  • Client
  • C_MFGORDCOMPEXCSCONSMPTQRY.MANUFACTURINGORDER == AUFK.AUFNR
  • C_MFGORDCOMPEXCSCONSMPTQRY.MANDT == AUFK.MANDT
Material Number
  • Client
  • Material Number
  • C_MFGORDCOMPEXCSCONSMPTQRY.MANDT == MARA.MANDT
  • C_MFGORDCOMPEXCSCONSMPTQRY.MATERIAL == MARA.MATNR
MRP controller
  • Client
  • MRP Controller
  • Production Plant
  • C_MFGORDCOMPEXCSCONSMPTQRY.MANDT == T024D.MANDT
  • C_MFGORDCOMPEXCSCONSMPTQRY.MRPCONTROLLER == T024D.DISPO
  • C_MFGORDCOMPEXCSCONSMPTQRY.PRODUCTIONPLANT == T024D.WERKS
Storage Location
  • Client
  • Storage Location
  • Production Plant
  • C_MFGORDCOMPEXCSCONSMPTQRY.MANDT == T001L.MANDT
  • C_MFGORDCOMPEXCSCONSMPTQRY.STORAGELOCATION == T001L.LGORT
  • C_MFGORDCOMPEXCSCONSMPTQRY.PRODUCTIONPLANT == T001L.WERKS