P_RTOCD_Variance1

Real-Time Order Cost Details - Variance Costs | view: PRTOCDVARC1 | Extraction: Not supported | Component: Fiori FXU Cost Controlling CO-FIO
Tables used: ACDOCAFINSC_LEDGER_REP
Column Name Description
CompanyCode FK Company Code
FiscalYear Fiscal Year
AccountingDocument Journal Entry
LedgerGLLineItem Ledger Journal Entry Item
Ledger FK Ledger in General Ledger Accounting
Column Name Description
💲 Company Code Currency (CompanyCodeCurrency):
AmountInCompanyCodeCurrency Amount in Company Code Currency
💲 Global Currency (GlobalCurrency):
AmountInGlobalCurrency Amount in Global Currency
FixedAmountInGlobalCrcy Fixed Amount in Global Currency
💲 Freely Defined Currency 1 (FreeDefinedCurrency1):
AmountInFreeDefinedCurrency1 Amount in Freely Defined Currency 1
💲 Freely Defined Currency 2 (FreeDefinedCurrency2):
AmountInFreeDefinedCurrency2 Amount in Freely Defined Currency 2
💲 Freely Defined Currency 3 (FreeDefinedCurrency3):
AmountInFreeDefinedCurrency3 Amount in Freely Defined Currency 3
💲 Freely Defined Currency 4 (FreeDefinedCurrency4):
AmountInFreeDefinedCurrency4 Amount in Freely Defined Currency 4
💲 Freely Defined Currency 5 (FreeDefinedCurrency5):
AmountInFreeDefinedCurrency5 Amount in Freely Defined Currency 5
💲 Freely Defined Currency 6 (FreeDefinedCurrency6):
AmountInFreeDefinedCurrency6 Amount in Freely Defined Currency 6
💲 Freely Defined Currency 7 (FreeDefinedCurrency7):
AmountInFreeDefinedCurrency7 Amount in Freely Defined Currency 7
💲 Freely Defined Currency 8 (FreeDefinedCurrency8):
AmountInFreeDefinedCurrency8 Amount in Freely Defined Currency 8
Column Name Description
Column Name Description
Column Name Description
ControllingDebitCreditCode Controlling Debit Credit Code Show values
Column Name Description Domain name
FiscalYearPeriod Fiscal Year Period FIS_JAHRPER_CONV
AccountAssignment Account Assignment ACCAS
PartnerAccountAssignment Partner Account Assignment ACCAS
OrderOperation Operation/Activity Number VORNR
Master Data Relations Join Conditions
Activity Type
  • Activity Type
  • ?
  • Controlling Area
  • Client
  • P_RTOCD_VARIANCE1.ACTIVITYTYPE == CSLA.LSTAR
  • P_RTOCD_VARIANCE1.[column in domain "DATBI"] == CSLA.DATBI
  • P_RTOCD_VARIANCE1.CONTROLLINGAREA == CSLA.KOKRS
  • P_RTOCD_VARIANCE1.MANDT == CSLA.MANDT
Business Transaction Type
  • Business Transaction Type
  • Client
Chart of Accounts
  • Chart of Accounts
  • Client
  • P_RTOCD_VARIANCE1.CHARTOFACCOUNTS == T004.KTOPL
  • P_RTOCD_VARIANCE1.MANDT == T004.MANDT
Company Code
  • Company Code
  • Client
  • P_RTOCD_VARIANCE1.COMPANYCODE == T001.BUKRS
  • P_RTOCD_VARIANCE1.MANDT == T001.MANDT
Company Code Currency
  • Client
  • Company Code Currency
  • P_RTOCD_VARIANCE1.MANDT == TCURC.MANDT
  • P_RTOCD_VARIANCE1.COMPANYCODECURRENCY == TCURC.WAERS
Controlling Area
  • Controlling Area
  • Client
  • P_RTOCD_VARIANCE1.CONTROLLINGAREA == TKA01.KOKRS
  • P_RTOCD_VARIANCE1.MANDT == TKA01.MANDT
Cost Center
  • ?
  • Controlling Area
  • Client
  • Cost Center
  • P_RTOCD_VARIANCE1.[column in domain "DATBI"] == CSKS.DATBI
  • P_RTOCD_VARIANCE1.CONTROLLINGAREA == CSKS.KOKRS
  • P_RTOCD_VARIANCE1.MANDT == CSKS.MANDT
  • P_RTOCD_VARIANCE1.COSTCENTER == CSKS.KOSTL
G/L Account
  • G/L Account
  • Company Code
  • Client
  • P_RTOCD_VARIANCE1.COSTELEMENT == SKB1.SAKNR
  • P_RTOCD_VARIANCE1.COMPANYCODE == SKB1.BUKRS
  • P_RTOCD_VARIANCE1.MANDT == SKB1.MANDT
Origin Group as Subdivision of Cost Element
  • ?
  • Controlling Area
  • Client
  • Origin Group as Subdivision of Cost Element
  • P_RTOCD_VARIANCE1.[column in domain "HRKTYP"] == TKKH1.KOATY
  • P_RTOCD_VARIANCE1.CONTROLLINGAREA == TKKH1.KOKRS
  • P_RTOCD_VARIANCE1.MANDT == TKKH1.MANDT
  • P_RTOCD_VARIANCE1.COSTORIGINGROUP == TKKH1.HRKFT
Freely Defined Currency 1
  • Freely Defined Currency 1
  • Client
  • P_RTOCD_VARIANCE1.FREEDEFINEDCURRENCY1 == TCURC.WAERS
  • P_RTOCD_VARIANCE1.MANDT == TCURC.MANDT
Freely Defined Currency 2
  • Client
  • Freely Defined Currency 2
  • P_RTOCD_VARIANCE1.MANDT == TCURC.MANDT
  • P_RTOCD_VARIANCE1.FREEDEFINEDCURRENCY2 == TCURC.WAERS
Freely Defined Currency 3
  • Client
  • Freely Defined Currency 3
  • P_RTOCD_VARIANCE1.MANDT == TCURC.MANDT
  • P_RTOCD_VARIANCE1.FREEDEFINEDCURRENCY3 == TCURC.WAERS
Freely Defined Currency 4
  • Freely Defined Currency 4
  • Client
  • P_RTOCD_VARIANCE1.FREEDEFINEDCURRENCY4 == TCURC.WAERS
  • P_RTOCD_VARIANCE1.MANDT == TCURC.MANDT
Freely Defined Currency 5
  • Client
  • Freely Defined Currency 5
  • P_RTOCD_VARIANCE1.MANDT == TCURC.MANDT
  • P_RTOCD_VARIANCE1.FREEDEFINEDCURRENCY5 == TCURC.WAERS
Freely Defined Currency 6
  • Client
  • Freely Defined Currency 6
  • P_RTOCD_VARIANCE1.MANDT == TCURC.MANDT
  • P_RTOCD_VARIANCE1.FREEDEFINEDCURRENCY6 == TCURC.WAERS
Freely Defined Currency 7
  • Freely Defined Currency 7
  • Client
  • P_RTOCD_VARIANCE1.FREEDEFINEDCURRENCY7 == TCURC.WAERS
  • P_RTOCD_VARIANCE1.MANDT == TCURC.MANDT
Freely Defined Currency 8
  • Client
  • Freely Defined Currency 8
  • P_RTOCD_VARIANCE1.MANDT == TCURC.MANDT
  • P_RTOCD_VARIANCE1.FREEDEFINEDCURRENCY8 == TCURC.WAERS
Global Currency
  • Global Currency
  • Client
  • P_RTOCD_VARIANCE1.GLOBALCURRENCY == TCURC.WAERS
  • P_RTOCD_VARIANCE1.MANDT == TCURC.MANDT
Ledger in General Ledger Accounting
  • Client
  • Ledger in General Ledger Accounting
Material Number
  • Material Number
  • Client
  • P_RTOCD_VARIANCE1.MATERIAL == MARA.MATNR
  • P_RTOCD_VARIANCE1.MANDT == MARA.MANDT
Order ID
  • Client
  • Order ID
  • P_RTOCD_VARIANCE1.MANDT == AUFK.MANDT
  • P_RTOCD_VARIANCE1.ORDERID == AUFK.AUFNR
Partner Business Process
  • ?
  • Partner Business Process
  • Controlling Area
  • Client
  • P_RTOCD_VARIANCE1.[column in domain "DATBI"] == CBPR.DATBI
  • P_RTOCD_VARIANCE1.PARTNERBUSINESSPROCESS == CBPR.PRZNR
  • P_RTOCD_VARIANCE1.CONTROLLINGAREA == CBPR.KOKRS
  • P_RTOCD_VARIANCE1.MANDT == CBPR.MANDT
Partner Cost Center
  • ?
  • Controlling Area
  • Client
  • Partner Cost Center
  • P_RTOCD_VARIANCE1.[column in domain "DATBI"] == CSKS.DATBI
  • P_RTOCD_VARIANCE1.CONTROLLINGAREA == CSKS.KOKRS
  • P_RTOCD_VARIANCE1.MANDT == CSKS.MANDT
  • P_RTOCD_VARIANCE1.PARTNERCOSTCENTER == CSKS.KOSTL
Partner Cost Center Activity Type
  • ?
  • Partner Cost Center Activity Type
  • Controlling Area
  • Client
  • P_RTOCD_VARIANCE1.[column in domain "DATBI"] == CSLA.DATBI
  • P_RTOCD_VARIANCE1.PARTNERCOSTCTRACTIVITYTYPE == CSLA.LSTAR
  • P_RTOCD_VARIANCE1.CONTROLLINGAREA == CSLA.KOKRS
  • P_RTOCD_VARIANCE1.MANDT == CSLA.MANDT
Partner Order
  • Partner Order
  • Client
  • P_RTOCD_VARIANCE1.PARTNERORDER == AUFK.AUFNR
  • P_RTOCD_VARIANCE1.MANDT == AUFK.MANDT
Plant
  • Plant
  • Client
  • P_RTOCD_VARIANCE1.PLANT == T001W.WERKS
  • P_RTOCD_VARIANCE1.MANDT == T001W.MANDT
Base Unit of Measure
  • Base Unit of Measure
  • Client
  • P_RTOCD_VARIANCE1.UNITOFMEASURE == T006.MSEHI
  • P_RTOCD_VARIANCE1.MANDT == T006.MANDT
Object ID of the resource
  • ?
  • Object ID of the resource
  • Client
  • P_RTOCD_VARIANCE1.[column in domain "CR_OBJTY"] == CRID.OBJTY
  • P_RTOCD_VARIANCE1.WORKCENTERINTERNALID == CRID.OBJID
  • P_RTOCD_VARIANCE1.MANDT == CRID.MANDT