P_COPCCOrderAndItemCosts1

CO PCC Order and Item Costs Layer 1 | view: PFIPCCOAICOSTS1 | Extraction: Not supported | Component: Cost Object Controlling
Tables used: COSL, AFKO, AFPO, ACDOCP, ACDOCA, COSB, COSP_BAK, COSS_BAK, T001, TKA02, TKA01, FINSC_LEDGER, FCOMC_CATEGORY, AUFK, T000, TKV09, FINS_MIG_PERIODS, FINS_MIG_PERIODS, FINS_MIG_PERIODS, FINS_MIG_PERIODS, FINSC_ACTVE_APPL, FINSC_FISC_DATE, FINSC_PERIOD
Column Name Description
ControllingObject FK Object number
ControllingArea FK Controlling Area
ControllingValueType Value Type Show values
PlanningCategory Plan Category
VarianceResultsAnlysCategory Category for Variance/Results Analysis Show values
CostElement FK General Ledger Account
ControllingKeySubNumber FK CO key subnumber
BusinessTransactionType FK CO Business Transaction
ControllingDebitCreditCode Debit/Credit Indicator (Origin) Show values
PartnerCostObject FK Partner object (always filled)
OriginSenderObject FK Source Object (Cost Center/Activity Type)
CtrlgOriginClassification null
OrderCategory Order Category Show values
OrderID Order Number
MfgOrderHasMultipleItems Joint Production Show values
AccountAssignmentType FK Object Type
PartnerObjectType FK Partner Object Type
PartnerCostCenter FK Sender cost center
PartnerCostCtrActivityType FK Partner activity
PartnerBusinessProcess FK Partner Business Process
PartnerOrder FK Partner order number
UnitOfMeasure FK Unit of Measure for Valuation Quantity
Material FK Material Number
Plant FK Plant
CostOriginGroup FK Origin Group as Subdivision of Cost Element
Column Name Description
AmountInGlobalCurrency null
FixedAmountInGlobalCrcy null
AmountInObjectCurrency null
FixedAmountInObjectCurrency null
Column Name Description
TotalQuantity null
Column Name Description
SystemDate null
Column Name Description
ControllingValueType Value Type Show values
VarianceResultsAnlysCategory Category for Variance/Results Analysis Show values
ControllingDebitCreditCode Debit/Credit Indicator (Origin) Show values
OrderCategory Order Category Show values
MfgOrderHasMultipleItems Joint Production Show values
Column Name Description Domain name
Master Data Relations Join Conditions
Controlling Area
  • Client
  • Controlling Area
  • P_COPCCORDERANDITEMCOSTS1.MANDT == TKA01.MANDT
  • P_COPCCORDERANDITEMCOSTS1.CONTROLLINGAREA == TKA01.KOKRS
CO key subnumber
  • CO key subnumber
  • Client
  • P_COPCCORDERANDITEMCOSTS1.CONTROLLINGKEYSUBNUMBER == COKEY.HRKFT
  • P_COPCCORDERANDITEMCOSTS1.MANDT == COKEY.MANDT
General Ledger Account
  • General Ledger Account
  • ?
  • Client
  • P_COPCCORDERANDITEMCOSTS1.COSTELEMENT == SKB1.SAKNR
  • P_COPCCORDERANDITEMCOSTS1.[column in domain "BUKRS"] == SKB1.BUKRS
  • P_COPCCORDERANDITEMCOSTS1.MANDT == SKB1.MANDT
Origin Group as Subdivision of Cost Element
  • Origin Group as Subdivision of Cost Element
  • ?
  • Controlling Area
  • Client
  • P_COPCCORDERANDITEMCOSTS1.COSTORIGINGROUP == TKKH1.HRKFT
  • P_COPCCORDERANDITEMCOSTS1.[column in domain "HRKTYP"] == TKKH1.KOATY
  • P_COPCCORDERANDITEMCOSTS1.CONTROLLINGAREA == TKKH1.KOKRS
  • P_COPCCORDERANDITEMCOSTS1.MANDT == TKKH1.MANDT
Material Number
  • Material Number
  • Client
  • P_COPCCORDERANDITEMCOSTS1.MATERIAL == MARA.MATNR
  • P_COPCCORDERANDITEMCOSTS1.MANDT == MARA.MANDT
Partner Business Process
  • Partner Business Process
  • ?
  • Controlling Area
  • Client
  • P_COPCCORDERANDITEMCOSTS1.PARTNERBUSINESSPROCESS == CBPR.PRZNR
  • P_COPCCORDERANDITEMCOSTS1.[column in domain "DATBI"] == CBPR.DATBI
  • P_COPCCORDERANDITEMCOSTS1.CONTROLLINGAREA == CBPR.KOKRS
  • P_COPCCORDERANDITEMCOSTS1.MANDT == CBPR.MANDT
Sender cost center
  • Sender cost center
  • ?
  • Controlling Area
  • Client
  • P_COPCCORDERANDITEMCOSTS1.PARTNERCOSTCENTER == CSKS.KOSTL
  • P_COPCCORDERANDITEMCOSTS1.[column in domain "DATBI"] == CSKS.DATBI
  • P_COPCCORDERANDITEMCOSTS1.CONTROLLINGAREA == CSKS.KOKRS
  • P_COPCCORDERANDITEMCOSTS1.MANDT == CSKS.MANDT
Partner activity
  • Partner activity
  • ?
  • Controlling Area
  • Client
  • P_COPCCORDERANDITEMCOSTS1.PARTNERCOSTCTRACTIVITYTYPE == CSLA.LSTAR
  • P_COPCCORDERANDITEMCOSTS1.[column in domain "DATBI"] == CSLA.DATBI
  • P_COPCCORDERANDITEMCOSTS1.CONTROLLINGAREA == CSLA.KOKRS
  • P_COPCCORDERANDITEMCOSTS1.MANDT == CSLA.MANDT
Partner order number
  • Partner order number
  • Client
  • P_COPCCORDERANDITEMCOSTS1.PARTNERORDER == AUFK.AUFNR
  • P_COPCCORDERANDITEMCOSTS1.MANDT == AUFK.MANDT
Plant
  • Client
  • Plant
  • P_COPCCORDERANDITEMCOSTS1.MANDT == T001W.MANDT
  • P_COPCCORDERANDITEMCOSTS1.PLANT == T001W.WERKS
Unit of Measure for Valuation Quantity
  • Unit of Measure for Valuation Quantity
  • Client
  • P_COPCCORDERANDITEMCOSTS1.UNITOFMEASURE == T006.MSEHI
  • P_COPCCORDERANDITEMCOSTS1.MANDT == T006.MANDT