I_COProductCostByOrderAndItem

CO Product Cost By Order and Item | view: IFIPRDTCOSTBYOAI | Extraction: Not supported | Component: Cost Object Controlling

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

🔑 Keys (2)
💰 Amounts (90)
∑ Quantities (3)
📅 Dates (11)
☰ Categorical (3)
Other (12)
🔗 Relations (19)

Column Name	Description
OrderID	Order Number
OrderItem	Order Item

Column Name	Description
💲 Controlling Area Currency (ControllingAreaCurrency):
CreditActlCostInCtrlgAreaCrcy	Actual Cost Credit
DebitActlCostInCtrlgAreaCrcy	Actual Cost Debit
ActlCostInCtrlgAreaCrcy	Total Actual Cost
CrdtActlFxdCostInCOCrcy	Actual Fixed Cost Credit
DebitActlFxdCostInCOCrcy	Actual Fixed Cost Debit
ActlFixedCostInCtrlgAreaCrcy	Actual Fixed Cost
DebitActlVarblCostInCOCrcy	Actual Variable Cost
CrdtActlVarblCostInCOCrcy	Actual Variable Cost Credit
ActlVarblCostInCtrlgAreaCrcy	Actual Variable Cost
DebitStdCostInGlobalCrcy	order standard cost debit in global currency
DebitStdFxdCostInGlobalCrcy	Order Fixed Standard Cost Debit In Global Currency
DebitStdVarblCostInGlobalCrcy	Order Variable Standard Cost Debit In Global Currency
CreditPlanCostInCtrlgAreaCrcy	Plan Cost Credit
DebitPlanCostInCtrlgAreaCrcy	Plan Cost Debit
PlanCostInCtrlgAreaCrcy	Total Plan Cost
CrdtPlnFxdCostInCtrlgAreaCrcy	Plan Fixed Cost Credit
DebitPlnFxdCostInCtrlgAreaCrcy	Plan Fixed Cost Debit
PlanFixedCostInCtrlgAreaCrcy	Plan Fixed Cost
DebitPlnVarblCostInCOCrcy	Plan Variable Cost Debit
CrdtPlnVarblCostInCOCrcy	Plan Variable Cost Credit
PlanVarblCostInCtrlgAreaCrcy	Plan Variable Cost
CrdtTargetCostInCtrlgAreaCrcy	Target Cost Credit
DebitTargetCostInCtrlgAreaCrcy	Target Cost Debit
TargetCostInCtrlgAreaCrcy	Target Cost Credit
CrdtPlanCtrlCostInGlobCrcy	control cost at plan credit in global currency
DebitPlanCtrlCostInGlobCrcy	Control Cost At Plan Debit
PlanCtrlCostInGlobCrcy	Control Cost at Plan
CrdtActlCtrlCostInGlobCrcy	Control cost at actual credit in global currency
DebitActlCtrlCostInGlobCrcy	Control cost at actual debit in global currency
ActlCtrlCostInGlobCrcy	Control cost at actual in global currency
InptPrVarcAmtInCtrlgAreaCrcy	Input Price Variance
InptQtyVarcAmtInCtrlgAreaCrcy	Input Quantity Variance
RsceUsgeVarcAmtInCtrlgAreaCrcy	Resource Usage Variance
InptRmngVarcAmtInCtrlgAreaCrcy	Remaining Input Variance
MixedPrVarcAmtInCtrlgAreaCrcy	Mixed-Price Variance
OutpPrVarcAmtInCtrlgAreaCrcy	Output Price Variance
LotSizeVarcAmtInCtrlgAreaCrcy	Lot Size Variance
OutpQtyVarcAmtInCtrlgAreaCrcy	Output Quantity Variance
OutpRmngVarcAmtInCtrlgAreaCrcy	Remaining Variance
ScrapVarcAmtInCtrlgAreaCrcy	Scrap Variance
WIPCostInCtrlgAreaCrcy	Work In Process
UnrlzdCostRsrvAmtInGlobCrcy	Reserves for Unrealized Costs
TotalWIPAmountInCOCrcy	Total WIP
DebitActlPlnDiffCostInCOCrcy	Plan Cost Debit/Actual Cost Debit Variance
DebitActlTgtDiffCostInCOCrcy	Target Cost Debit/Actual Cost Debit Variance
💲 Order Currency (CompanyCodeCurrency):
CreditActlCostInCoCodeCrcy	Credit Actual Cost In Company Code Currency
DebitActlCostInCoCodeCrcy	Debit Actual Cost In Company Code Currency
ActlCostInCoCodeCrcy	Actual Cost In Company Code Currency
DebitActlFixedCostInCoCodeCrcy	Debit Actual Fixed Cost In Company Code Currency
CreditActlFixedCostInCCCrcy	Credit Actual Fixed Cost In Company Code Currency
ActlFixedCostInCoCodeCrcy	Actual Fixed Cost In Company Code Currency
DebitActlVarblCostInCoCodeCrcy	Debit Actual Variable Cost In Company Code Currency
CreditActlVarblCostInCCCrcy	Credit Actual Variable Cost In Company Code Currency
ActlVarblCostInCoCodeCrcy	Actual Variable Cost In Company Code Currency
DebitStdCostInCoCodeCrcy	Order Standard Cost Debit In Company Code Currency
DebitStdFxdCostInCoCodeCrcy	Order Fixed Standard Cost Debit In Company Code Currency
DebitStdVarblCostInCoCodeCrcy	Order Variable Standard Cost Debit In Company Code Currency
CreditPlanCostInCoCodeCrcy	Credit Plan CostCredit Plan Cost In Company Code Currency
DebitPlanCostInCoCodeCrcy	Debit Plan Cost In Company Code Currency
PlanCostInCoCodeCrcy	Plan Cost In Company Code Currency
DebitPlanFixedCostInCoCodeCrcy	Debit Plan Fixed Cost In Company Code Currency
CreditPlanFixedCostInCCCrcy	Credit Plan Fixed Cost In Company Code Currency
PlanFixedCostInCoCodeCrcy	Plan Fixed Cost In Company Code Currency
DebitPlanVarblCostInCoCodeCrcy	Debit Plan Variable Cost In Company Code Currency
CreditPlanVarblCostInCCCrcy	Credit Plan Variable Cost In Company Code Currency
PlanVarblCostInCoCodeCrcy	Plan Variable Cost In Company Code Currency
CreditTargetCostInCoCodeCrcy	Credit Target Cost In Company Code Currency
DebitTargetCostInCoCodeCrcy	Debit Target Cost In Company Code Currency
TargetCostInCoCodeCrcy	Target Cost In Company Code Currency
CrdtPlanCtrlCostInCCCrcy	Control Cost At Plan Credit
DebitPlanCtrlCostInCCCrcy	Control Cost At Plan Debit
PlanCtrlCostInCoCodeCrcy	control cost at plan in company code currency
CrdtActlCtrlCostInCCCrcy	Control Cost At Actual Credit
DebitActlCtrlCostInCCCrcy	Control Cost At Actual Debit
ActlCtrlCostInCoCodeCrcy	control cost at actual in company code currency
InptPriceVarcAmtInCoCodeCrcy	Input Price Variance Amount In Company Code Currency
InptQtyVarcAmtInCoCodeCrcy	Input Quantity Variance Amount In Company Code Currency
RsceUsgeVarcAmtInCoCodeCrcy	Resource Usage Variance Amount In Company Code Currency
InputRmngVarcAmtInCoCodeCrcy	Input Remaining Variance Amount In Company Code Currency
MixedPrVarcAmtInCoCodeCrcy	Mixed Price Variance Amount In Company Code Currency
OutpPrVarcAmtInCoCodeCrcy	Output Price Variance Amount In Company Code Currency
LotSizeVarcAmtInCoCodeCrcy	Lot Size Variance Amount In Company Code Currency
OutpQtyVarcAmtInCoCodeCrcy	Output Quantity Variance Amount In Company Code Currency
OutputRmngVarcAmtInCoCodeCrcy	Output Remaining Variance Amount In Company Code Currency
ScrapVarcAmtInCoCodeCrcy	Scrap Variance Amount In Company Code Currency
WIPCostInCoCodeCrcy	WIP Cost In Company Code Currency
UnrlzdCostRsrvAmtInCoCodeCrcy	Reserves for Unrealized Costs
TotalWIPAmountInCoCodeCrcy	Total WIP
DebitActlPlnDiffCostInCCCrcy	Debit Actual Plan Difference Cost In Company Code Currency
DebitActlTgtDiffCostInCCCrcy	Debit Actual Target Difference Cost In Company Code Currency

Column Name	Description
📏 Output Unit of Measure (BaseUnit):
PlanOutputQuantity	Plan Output Quantity
ActualOutputQuantity	Actual Output Quantity
ActlPlanDiffOutputQuantity	null

Column Name	Description
PlannedReleaseDate	Planned Release Date
PlannedCompletionDate	Planned Completion Date
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
ValidityDate	null

Column Name	Description
OrderCategory	Order Category	Show values
IsMarkedForDeletion	Deletion Flag	Show values
MfgOrderHasMultipleItems	Joint Production	Show values

Column Name	Description	Domain name
ExternalOrder	External Order Number	AUFEX
OrderDescription	Order Description	TEXT40
ProductionVersion	Production Version	VERID
ActualCostsCostingVariant	Costing Variant For Actual Cost	KLVAR
CreatedByUser	Created By	XUBNAME
LastChangedByUser	Last Changed By	USNAM
ControllingObjectStatus	Order Status
CtrlgAreaCrcyActlPlanDiffPct	Plan Debit/Actual Debit Cost Variance(%)	KKB_PROZABW
CoCodeCrcyActlPlanDiffPercent	Company Code Currency Actual Plan Difference Percent	KKB_PROZABW
CtrlgAreaCrcyActlTgtDiffPct	Target Debit/Actual Debit Cost Variance(%)	KKB_PROZABW
CoCodeCrcyActlTgtDiffPercent	Company Code Currency Actual Target Difference Percent	KKB_PROZABW
ActlPlanDiffOutpQtyPercent	Plan/Actual Quantity Variance(%)	KKB_PROZABW

Master Data Relations	Join Conditions
Activity unit Output Unit of Measure Client	`I_COPRODUCTCOSTBYORDERANDITEM.BASEUNIT == T006.MSEHI` `I_COPRODUCTCOSTBYORDERANDITEM.MANDT == T006.MANDT`
Business Area Business Area Client	`I_COPRODUCTCOSTBYORDERANDITEM.BUSINESSAREA == TGSB.GSBER` `I_COPRODUCTCOSTBYORDERANDITEM.MANDT == TGSB.MANDT`
Company Code Client Company Code	`I_COPRODUCTCOSTBYORDERANDITEM.MANDT == T001.MANDT` `I_COPRODUCTCOSTBYORDERANDITEM.COMPANYCODE == T001.BUKRS`
Order Currency Order Currency Controlling Area Currency Client	`I_COPRODUCTCOSTBYORDERANDITEM.COMPANYCODECURRENCY == TCURC.WAERS` `I_COPRODUCTCOSTBYORDERANDITEM.CONTROLLINGAREACURRENCY == TCURC.WAERS` `I_COPRODUCTCOSTBYORDERANDITEM.MANDT == TCURC.MANDT`
Controlling Area Client Controlling Area	`I_COPRODUCTCOSTBYORDERANDITEM.MANDT == TKA01.MANDT` `I_COPRODUCTCOSTBYORDERANDITEM.CONTROLLINGAREA == TKA01.KOKRS`
Controlling Area Currency Order Currency Controlling Area Currency Client	`I_COPRODUCTCOSTBYORDERANDITEM.COMPANYCODECURRENCY == TCURC.WAERS` `I_COPRODUCTCOSTBYORDERANDITEM.CONTROLLINGAREACURRENCY == TCURC.WAERS` `I_COPRODUCTCOSTBYORDERANDITEM.MANDT == TCURC.MANDT`
Material Number for Order Client Material Number for Order	`I_COPRODUCTCOSTBYORDERANDITEM.MANDT == MARA.MANDT` `I_COPRODUCTCOSTBYORDERANDITEM.MATERIAL == MARA.MATNR`
Planning Plant for an Order Client Planning Plant for an Order	`I_COPRODUCTCOSTBYORDERANDITEM.MANDT == T001W.MANDT` `I_COPRODUCTCOSTBYORDERANDITEM.MRPPLANT == T001W.WERKS`
Order Type Client Order Type	`I_COPRODUCTCOSTBYORDERANDITEM.MANDT == T003O.CLIENT` `I_COPRODUCTCOSTBYORDERANDITEM.ORDERTYPE == T003O.AUART`
Plant Client Plant	`I_COPRODUCTCOSTBYORDERANDITEM.MANDT == T001W.MANDT` `I_COPRODUCTCOSTBYORDERANDITEM.PLANT == T001W.WERKS`
Output Unit of Measure Output Unit of Measure Client	`I_COPRODUCTCOSTBYORDERANDITEM.PRODUCTIONUNIT == T006.MSEHI` `I_COPRODUCTCOSTBYORDERANDITEM.MANDT == T006.MANDT`
Profit Center Client ? Controlling Area Profit Center	`I_COPRODUCTCOSTBYORDERANDITEM.MANDT == CEPC.MANDT` `I_COPRODUCTCOSTBYORDERANDITEM.[column in domain "DATBI"] == CEPC.DATBI` `I_COPRODUCTCOSTBYORDERANDITEM.CONTROLLINGAREA == CEPC.KOKRS` `I_COPRODUCTCOSTBYORDERANDITEM.PROFITCENTER == CEPC.PRCTR`
Responsible Cost Center Responsible Cost Center Client ? Controlling Area	`I_COPRODUCTCOSTBYORDERANDITEM.RESPONSIBLECOSTCENTER == CSKS.KOSTL` `I_COPRODUCTCOSTBYORDERANDITEM.MANDT == CSKS.MANDT` `I_COPRODUCTCOSTBYORDERANDITEM.[column in domain "DATBI"] == CSKS.DATBI` `I_COPRODUCTCOSTBYORDERANDITEM.CONTROLLINGAREA == CSKS.KOKRS`
Storage location Storage location Client Planning Plant for an Order	`I_COPRODUCTCOSTBYORDERANDITEM.STORAGELOCATION == T001L.LGORT` `I_COPRODUCTCOSTBYORDERANDITEM.MANDT == T001L.MANDT` `I_COPRODUCTCOSTBYORDERANDITEM.MRPPLANT == T001L.WERKS`
Valuation Class Valuation Class Client	`I_COPRODUCTCOSTBYORDERANDITEM.VALUATIONCLASS == T025.BKLAS` `I_COPRODUCTCOSTBYORDERANDITEM.MANDT == T025.MANDT`