C_OrdHdrItmRealTimeProdnCost

Order Header and Item Real Time Production Cost | view: CEBORDHIRTPRCST | Extraction: Not supported | Component: Fiori FXU Cost Controlling CO-FIO
Tables used: COSL, AFKO, AFPO, JEST, ACDOCA, ACDOCP, FMLT_PRICE, ACDOCA, MARA, TGSBT, T001, TKA02, TKA01, CSKS, CSKT, TCK04, FINSC_CURTYPET, FINSC_LEDGER, FINSC_LEDGER_T, FCOMC_CATEGORY, T003P, T001W, MARA, AUFK, T023T, MKAL, MAKT, CEPC, CEPCT, T000, T001L, TJ02T, FINSC_CURTYPE, FINSC_CURTYPET, FINSC_LEDGER, CKMLHD, CKMLPR, T001K, FINS_MIG_PERIODS, FINSC_ACTVE_APPL, FINSC_LD_CMP, FINSC_LEDGER_REP, FINSC_FISC_DATE, FINSC_PERIOD, FMLC_TOGGLE, FMLT_CURTP_ML
Column Name Description
OrderID Order
OrderItem Order Item
Column Name Description
💲 Currency Key (DisplayCurrency):
CreditActlCostInDspCrcy Actual Cost Credit
DebitActlCostInDspCrcy Actual Cost Debit
ActlCostInDspCrcy Total Actual Cost
DebitActlVarblCostInDspCrcy Actual Variable Cost Debit
CrdtActlVarblCostIndDspCrcy Actual Variable Cost Credit
ActlVarblCostInDspCrcy Actual Variable Cost
CrdtActlFxdCostInDspCrcy Actual Fixed Cost Credit
DebitActlFxdCostInDspCrcy Actual Fixed Cost Debit
ActlFixedCostInDspCrcy Actual Fixed Cost
CreditPlanCostInDspCrcy Plan Cost Credit
DebitPlanCostInDspCrcy Plan Cost Debit
CrdtPlnFxdCostInDspCrcy Plan Fixed Cost Credit
DebitPlnFxdCostInDspCrcy Plan Fixed Cost Debit
CrdtPlnVarblCostInDspCrcy Plan Variable Cost Credit
DebitPlnVarblCostInDspCrcy Plan Variable Cost Debit
PlanCostInDspCrcy Total Plan Cost
PlanFixedCostInDspCrcy Plan Fixed Cost
PlanVarblCostInDspCrcy Plan Variable Cost
CrdtTargetCostInDspCrcy Target Cost Credit
DebitTargetCostInDspCrcy Target Cost Debit
TargetCostInDspCrcy Total Target Cost
CrdtPlanCtrlCostInDspCrcy Control Cost at Plan Credit
DebitPlanCtrlCostInDspCrcy Control Cost at Plan Debit
PlanCtrlCostInDspCrcy Control Cost at Plan
CrdtActlCtrlCostInDspCrcy Control Cost at Actual Credit
DebitActlCtrlCostInDspCrcy Control Cost at Actual Debit
ActlCtrlCostInDspCrcy Control Cost at Actual
CostVarianceInDspCrcy Total Cost Variance in Display Currency
InptPrVarcAmtInDspCrcy Input Price Variance
InptQtyVarcAmtInDspCrcy Input Quantity Variance
RsceUsgeVarcAmtInDspCrcy Resource Usage Variance
LotSizeVarcAmtInDspCrcy Lot Size Variance
RmngVarcAmtInDspCrcy Remaining Variance in Display Currency
WIPCostInDspCrcy Work In Process
UnrlzdCostRsrvAmtInDspCrcy Reserves for Unrealized Costs
TotalWIPAmountInDspCrcy Total WIP
DebitActlPlnDiffCostInDspCrcy Plan Cost Debit/Actual Cost Debit Variance
DebitActlTgtDiffCostInDspCrcy Target Cost Debit/Actual Cost Debit Variance
PlnCtrlTgtDiffCostInDspCrcy Control Cost at Plan/Target Variance
ActlCtrlTgtDiffCostInDspCrcy Control Cost at Actual/Target Variance
InterestAmount Interest Amount
Column Name Description
📏 Output Unit of Measure (BaseUnit):
PlanOutputQuantity Plan Output Quantity
ActualOutputQuantity Actual Output Quantity
ActlPlanDiffOutputQuantity Plan/Actual Quantity Variance
Column Name Description
CreationDate Created On
LastChangeDate Changed On
TechnicalCompletionDate Technical Completion Date
ScheduledBasicEndDate Scheduled Finish Date
ScheduledReleaseDate Scheduled Release Date
ActualStartDate Actual Start Date
ConfirmedEndDate Actual Finish Date
ActualReleasedDate Actual Release Date
Column Name Description
OrderCategory Order Category Show values
MfgOrderHasMultipleItems Joint Production Show values
Column Name Description Domain name
InternalOrderText Order FCO_RT_ORD_CST_DTL_INT_ORD_T
ExternalOrder External Order Number AUFEX
OrderDescription Order Description TEXT40
FromFiscalYearPeriod null
ToFiscalYearPeriod null
PlanningCategory null
Ledger Ledger in General Ledger Accounting FINS_LEDGER
WBSElementInternalID WBS Element FIS_PS_POSNR_C
MfgOrderWithMultipleItemsText Joint Production Text DDTEXT
ActualCostsCostingVariant Costing Variant For Actual Cost KLVAR
PlannedCostsCostingVariant Costing Variant for Planned Costs KLVAR
CreatedByUser Created By XUBNAME
LastChangedByUser Last Changed By USNAM
MaterialGroupName Product Group Description TEXT20
ProductionVersion Production Version VERID
ControllingObjectStatus Current Order Status FCO_CURRENT_ORDER_STATUS
OrderStatusShortText Status Name TEXT30
OrderKeyStatus Current Order Key Status J_ISTAT
SystemStatusName Status Name TEXT30
DebitActlPlanDiffPercent Plan Debit/Actual Debit Cost Variance(%) KKB_PROZABW
DebitActlTgtDiffPercent Target Debit/Actual Debit Cost Variance(%) KKB_PROZABW
DspCrcyActlTgtDiffPct Target/Actual Variance (%) KKB_PROZABW
DspCrcyPlnCtrlTgtDiffPct Control Cost at Plan/Target Variance(%) KKB_PROZABW
DspCrcyActlCtrlTgtDiffPct Control Cost at Actual/Target Variance(%) KKB_PROZABW
ActlPlanDiffOutpQtyPercent Plan/Actual Quantity Variance(%) KKB_PROZABW
LedgerName Ledger Name TEXT30
CompanyCodeName Name of Company Code or Company TEXT25
ControllingAreaName Controlling Area Name TEXT25
OrderTypeName Name of an Order Type TEXT40
OrderCategoryName Order Category Name DDTEXT
PlantName Plant Name TEXT30
MRPPlantName Planning Plant Name TEXT30
MaterialName Product Description TEXT40
StorageLocationName Storage Location Name TEXT16
ProductionVersionText Short Text for Production Version TEXT40
ProfitCenterName Description of Profit Center TEXT20
ResponsibleCostCenterName Responsible Cost Center Name TEXT25
ActlCostsCostingVariantName Actual Costs Costing Variant Name TEXT25
PlndCostsCostingVariantName Planned Costs Costing Variant Name TEXT25
BusinessAreaName Business Area Name TEXT30
Master Data Relations Join Conditions
Activity unit
  • Output Unit of Measure
  • Client
  • C_ORDHDRITMREALTIMEPRODNCOST.BASEUNIT == T006.MSEHI
  • C_ORDHDRITMREALTIMEPRODNCOST.MANDT == T006.MANDT
Business Area
  • Business Area
  • Client
  • C_ORDHDRITMREALTIMEPRODNCOST.BUSINESSAREA == TGSB.GSBER
  • C_ORDHDRITMREALTIMEPRODNCOST.MANDT == TGSB.MANDT
Company Code
  • Company Code
  • Client
  • C_ORDHDRITMREALTIMEPRODNCOST.COMPANYCODE == T001.BUKRS
  • C_ORDHDRITMREALTIMEPRODNCOST.MANDT == T001.MANDT
Controlling Area
  • Controlling Area
  • Client
  • C_ORDHDRITMREALTIMEPRODNCOST.CONTROLLINGAREA == TKA01.KOKRS
  • C_ORDHDRITMREALTIMEPRODNCOST.MANDT == TKA01.MANDT
Product
  • Client
  • Product
  • C_ORDHDRITMREALTIMEPRODNCOST.MANDT == MARA.MANDT
  • C_ORDHDRITMREALTIMEPRODNCOST.MATERIAL == MARA.MATNR
Material Group
  • Client
  • Product Group
  • C_ORDHDRITMREALTIMEPRODNCOST.MANDT == T023.MANDT
  • C_ORDHDRITMREALTIMEPRODNCOST.MATERIALGROUP == T023.MATKL
Planning Plant for The Order
  • Planning Plant for The Order
  • Client
  • C_ORDHDRITMREALTIMEPRODNCOST.MRPPLANT == T001W.WERKS
  • C_ORDHDRITMREALTIMEPRODNCOST.MANDT == T001W.MANDT
Order Type
  • Client
  • Order Type
  • C_ORDHDRITMREALTIMEPRODNCOST.MANDT == T003O.CLIENT
  • C_ORDHDRITMREALTIMEPRODNCOST.ORDERTYPE == T003O.AUART
Plant
  • Plant
  • Client
  • C_ORDHDRITMREALTIMEPRODNCOST.PLANT == T001W.WERKS
  • C_ORDHDRITMREALTIMEPRODNCOST.MANDT == T001W.MANDT
Profit Center
  • Controlling Area
  • Profit Center
  • ?
  • Client
  • C_ORDHDRITMREALTIMEPRODNCOST.CONTROLLINGAREA == CEPC.KOKRS
  • C_ORDHDRITMREALTIMEPRODNCOST.PROFITCENTER == CEPC.PRCTR
  • C_ORDHDRITMREALTIMEPRODNCOST.[column in domain "DATBI"] == CEPC.DATBI
  • C_ORDHDRITMREALTIMEPRODNCOST.MANDT == CEPC.MANDT
Responsible Cost Center
  • Controlling Area
  • Responsible Cost Center
  • ?
  • Client
  • C_ORDHDRITMREALTIMEPRODNCOST.CONTROLLINGAREA == CSKS.KOKRS
  • C_ORDHDRITMREALTIMEPRODNCOST.RESPONSIBLECOSTCENTER == CSKS.KOSTL
  • C_ORDHDRITMREALTIMEPRODNCOST.[column in domain "DATBI"] == CSKS.DATBI
  • C_ORDHDRITMREALTIMEPRODNCOST.MANDT == CSKS.MANDT
Storage Location
  • Planning Plant for The Order
  • Client
  • Storage Location
  • C_ORDHDRITMREALTIMEPRODNCOST.MRPPLANT == T001L.WERKS
  • C_ORDHDRITMREALTIMEPRODNCOST.MANDT == T001L.MANDT
  • C_ORDHDRITMREALTIMEPRODNCOST.STORAGELOCATION == T001L.LGORT