I_ProductCostByOrderCube

Production Cost By Order | view: IFIPRODCSTBOCUB | TRAN | Extraction: Not supported | Component: Cost Object Controlling

Tables used: COSL, AFKO, AFPO, ACDOCP, ACDOCA, JEST, COSB, COSP_BAK, COSS_BAK, T001, TKA02, TKA01, FINSC_LEDGER, MARA, MAKT, FCOMC_CATEGORY, T003O, T003P, T001W, AUFK, T000, TKV09, FINS_MIG_PERIODS, FINS_MIG_PERIODS, FINS_MIG_PERIODS, FINSC_ACTVE_APPL, FINSC_FISC_DATE, FINSC_PERIOD

🔑 Keys (1)
💰 Amounts (41)
∑ Quantities (3)
📅 Dates (8)
☰ Categorical (2)
Other (21)
🔗 Relations (13)

Column Name	Description
OrderID	Order Number

Column Name	Description
💲 Currency (DisplayCurrency):
CreditActlCostInDspCrcy	Actual Cost Credit
DebitActlCostInDspCrcy	Actual Cost Debit
ActlCostInDspCrcy	Total Actual Cost
DebitActlVarblCostInDspCrcy	Actual Variable Cost Debit
CrdtActlVarblCostInDspCrcy	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
CreditCtrlCostInDspCrcy	Control Cost Credit
DebitCtrlCostInDspCrcy	Control Cost Debit
CtrlCostInDspCrcy	Total Control Cost
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
TotalWIPAmountInDspCrcy	Total WIP
DebitActlPlnDiffCostInDspCrcy	Plan Cost Debit/Actual Cost Debit Variance
DebitActlTgtDiffCostInDspCrcy	Target Cost Debit/Actual Cost Debit Variance
CtrlTgtDiffCostInDspCrcy	Target/Control Cost Variance

Column Name	Description
📏 Output Unit of Measure (ProductionUnit):
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
ExternalOrder	External Order Number	AUFEX
OrderDescription	Order Description	TEXT40
PlantName	Plant Name	TEXT30
ControllingAreaName	Controlling Area Name	TEXT25
CompanyCodeName	Company Code Name	TEXT25
WBSElementInternalID	WBS Element	FIS_PS_POSNR_C
ActualCostsCostingVariant	Costing Variant For Actual Cost	KLVAR
CreatedByUser	Created By	XUBNAME
LastChangedByUser	Last Changed By	USNAM
FiscalYear	Fiscal Year	GJAHR
FiscalPeriod	Fiscal Period	POPER
FiscalWeek	Fiscal Week	FINS_FISCALWEEK
MaterialName	Material Description	TEXT40
ProductionVersion	Production Version	VERID
ControllingObjectStatus	Order Status
DebitActlPlanDiffPercent	Plan Debit/Actual Debit Cost Variance(%)	KKB_PROZABW
DebitActlTgtDiffPercent	Target Debit/Actual Debit Cost Variance(%)	KKB_PROZABW
DspCrcyCtrlTgtDiffPct	Target/Control Cost Variance (%)	KKB_PROZABW
ActlPlanDiffOutpQtyPercent	Plan/Actual Quantity Variance(%)	KKB_PROZABW
OrderTypeName	Name of an Order Type	TEXT40
OrderCategoryName	Order Category Name	DDTEXT

Master Data Relations	Join Conditions
Business Area Client Business Area	`I_PRODUCTCOSTBYORDERCUBE.MANDT == TGSB.MANDT` `I_PRODUCTCOSTBYORDERCUBE.BUSINESSAREA == TGSB.GSBER`
Company Code Company Code Client	`I_PRODUCTCOSTBYORDERCUBE.COMPANYCODE == T001.BUKRS` `I_PRODUCTCOSTBYORDERCUBE.MANDT == T001.MANDT`
Controlling Area Client Controlling Area	`I_PRODUCTCOSTBYORDERCUBE.MANDT == TKA01.MANDT` `I_PRODUCTCOSTBYORDERCUBE.CONTROLLINGAREA == TKA01.KOKRS`
Material Material Client	`I_PRODUCTCOSTBYORDERCUBE.MATERIAL == MARA.MATNR` `I_PRODUCTCOSTBYORDERCUBE.MANDT == MARA.MANDT`
Planning Plant for The Order Client Planning Plant for The Order	`I_PRODUCTCOSTBYORDERCUBE.MANDT == T001W.MANDT` `I_PRODUCTCOSTBYORDERCUBE.MRPPLANT == T001W.WERKS`
Order Type Client Order Type	`I_PRODUCTCOSTBYORDERCUBE.MANDT == T003O.CLIENT` `I_PRODUCTCOSTBYORDERCUBE.ORDERTYPE == T003O.AUART`
Plant Client Plant	`I_PRODUCTCOSTBYORDERCUBE.MANDT == T001W.MANDT` `I_PRODUCTCOSTBYORDERCUBE.PLANT == T001W.WERKS`
Activity unit Client Output Unit of Measure	`I_PRODUCTCOSTBYORDERCUBE.MANDT == T006.MANDT` `I_PRODUCTCOSTBYORDERCUBE.PRODUCTIONUNIT == T006.MSEHI`
Profit Center Client Controlling Area ? Profit Center	`I_PRODUCTCOSTBYORDERCUBE.MANDT == CEPC.MANDT` `I_PRODUCTCOSTBYORDERCUBE.CONTROLLINGAREA == CEPC.KOKRS` `I_PRODUCTCOSTBYORDERCUBE.[column in domain "DATBI"] == CEPC.DATBI` `I_PRODUCTCOSTBYORDERCUBE.PROFITCENTER == CEPC.PRCTR`
Reference Order Number Client Reference Order Number	`I_PRODUCTCOSTBYORDERCUBE.MANDT == AUFK.MANDT` `I_PRODUCTCOSTBYORDERCUBE.REFERENCEORDER == AUFK.AUFNR`
Responsible Cost Center Responsible Cost Center Client Controlling Area ?	`I_PRODUCTCOSTBYORDERCUBE.RESPONSIBLECOSTCENTER == CSKS.KOSTL` `I_PRODUCTCOSTBYORDERCUBE.MANDT == CSKS.MANDT` `I_PRODUCTCOSTBYORDERCUBE.CONTROLLINGAREA == CSKS.KOKRS` `I_PRODUCTCOSTBYORDERCUBE.[column in domain "DATBI"] == CSKS.DATBI`
Storage Location Client Planning Plant for The Order Storage Location	`I_PRODUCTCOSTBYORDERCUBE.MANDT == T001L.MANDT` `I_PRODUCTCOSTBYORDERCUBE.MRPPLANT == T001L.WERKS` `I_PRODUCTCOSTBYORDERCUBE.STORAGELOCATION == T001L.LGORT`