C_MfgOrderWIPVarianceQuery

Query view for manufacturing order WIP / Variance | view: CFIORDERWIPVARCQ | Extraction: Not supported | Component: Cost Object Controlling
Tables used: AFKOJESTCOSBT001TKA02TKA01AUFKT000FINS_MIG_PERIODS
Column Name Description
OrderID Order Number
GLAccount FK General Ledger Account
Column Name Description
💲 Currency (DisplayCurrency):
InptPrVarcAmtInDspCrcy Input Price Variance
InptQtyVarcAmtInDspCrcy Input Quantity Variance
RsceUsgeVarcAmtInDspCrcy Resource Usage Variance
InptRmngVarcAmtInDspCrcy Remaining Input Variance
MixedPrVarcAmtInDspCrcy Mixed-Price Variance
OutpPrVarcAmtInDspCrcy Output Price Variance
LotSizeVarcAmtInDspCrcy Lot Size Variance
OutpQtyVarcAmtInDspCrcy Output Quantity Variance
OutpRmngVarcAmtInDspCrcy Remaining Variance
ScrapVarcAmtInDspCrcy Scrap Variance
CostVarianceInDspCrcy Cost Variance
WIPAmtInDisplayCurrency Work In Process
RsrvAmountInDisplayCrcy Reserves for Unrealized Costs
Column Name Description
Column Name Description
Column Name Description
OrderCategory Order Category Show values
Column Name Description Domain name
SalesOrder Sales Order Number VBELN
SalesOrderItem Item number in Sales Order NUM06
Master Data Relations Join Conditions
Chart of Accounts
  • Chart of Accounts
  • Client
  • C_MFGORDERWIPVARIANCEQUERY.CHARTOFACCOUNTS == T004.KTOPL
  • C_MFGORDERWIPVARIANCEQUERY.MANDT == T004.MANDT
Company Code
  • Company Code
  • Client
  • C_MFGORDERWIPVARIANCEQUERY.COMPANYCODE == T001.BUKRS
  • C_MFGORDERWIPVARIANCEQUERY.MANDT == T001.MANDT
General Ledger Account
  • Chart of Accounts
  • General Ledger Account
  • Client
  • C_MFGORDERWIPVARIANCEQUERY.CHARTOFACCOUNTS == CSKA.KTOPL
  • C_MFGORDERWIPVARIANCEQUERY.GLACCOUNT == CSKA.KSTAR
  • C_MFGORDERWIPVARIANCEQUERY.MANDT == CSKA.MANDT
Order Type
  • Order Type
  • Client
  • C_MFGORDERWIPVARIANCEQUERY.ORDERTYPE == T003O.AUART
  • C_MFGORDERWIPVARIANCEQUERY.MANDT == T003O.CLIENT
Plant
  • Plant
  • Client
  • C_MFGORDERWIPVARIANCEQUERY.PLANT == T001W.WERKS
  • C_MFGORDERWIPVARIANCEQUERY.MANDT == T001W.MANDT