P_PlanCostRateByPeriod

Private view for Cost Rate by Period | view: PFIACCOSTRATEBY | TRAN | Extraction: Not supported | Component: Overhead Cost Controlling
Tables used: ACCOSTRATE, T001, TKA02, TKA01, T000, CSSL, FINSC_PERIOD
Column Name Description
PlanningCategory FK Plan Category
BusinessTransactionType Business Transaction Category
Ledger FK Ledger in General Ledger Accounting
FiscalYear Fiscal Year
FiscalPeriod Fiscal Period
ControllingArea FK Controlling Area
CompanyCode FK Company Code
CostCenter FK Cost Center
ActivityType FK Activity Type
Column Name Description
💲 Transaction Currency (TransactionCurrency):
CostRateTotalAmountInTransCrcy Amount in Transaction Currency
CostRateFixedAmountInTransCrcy Amount in Transaction Currency
CostRateVarblAmountInTransCrcy Amount in Transaction Currency
💲 Company Code Currency (CompanyCodeCurrency):
CostRateTotalAmtInCoCodeCrcy Amount in Company Code Currency
CostRateFixedAmtInCoCodeCrcy Amount in Transaction Currency
CostRateVarblAmtInCoCodeCrcy Amount in Transaction Currency
💲 Global Currency (GlobalCurrency):
CostRateTotalAmountInGlobCrcy Amount in Global Currency
CostRateFixedAmountInGlobCrcy Amount in Transaction Currency
CostRateVarblAmountInGlobCrcy Amount in Transaction Currency
Column Name Description
Column Name Description
FiscalPeriodEndDate End Date of Fiscal Period
Column Name Description
Column Name Description Domain name
FiscalYearPeriod Character field, 8 characters long CHAR8
CoCodeCurrencyIsAvailable null
GlobalCurrencyIsAvailable null
Master Data Relations Join Conditions
Activity Type
  • ?
  • Activity Type
  • Controlling Area
  • Client
  • P_PLANCOSTRATEBYPERIOD.[column in domain "DATBI"] == CSLA.DATBI
  • P_PLANCOSTRATEBYPERIOD.ACTIVITYTYPE == CSLA.LSTAR
  • P_PLANCOSTRATEBYPERIOD.CONTROLLINGAREA == CSLA.KOKRS
  • P_PLANCOSTRATEBYPERIOD.MANDT == CSLA.MANDT
Company Code
  • Company Code
  • Client
  • P_PLANCOSTRATEBYPERIOD.COMPANYCODE == T001.BUKRS
  • P_PLANCOSTRATEBYPERIOD.MANDT == T001.MANDT
Company Code Currency
  • Client
  • Company Code Currency
  • Global Currency
  • P_PLANCOSTRATEBYPERIOD.MANDT == TCURC.MANDT
  • P_PLANCOSTRATEBYPERIOD.COMPANYCODECURRENCY == TCURC.WAERS
  • P_PLANCOSTRATEBYPERIOD.GLOBALCURRENCY == TCURC.WAERS
Controlling Area
  • Controlling Area
  • Client
  • P_PLANCOSTRATEBYPERIOD.CONTROLLINGAREA == TKA01.KOKRS
  • P_PLANCOSTRATEBYPERIOD.MANDT == TKA01.MANDT
Cost Center
  • ?
  • Cost Center
  • Controlling Area
  • Client
  • P_PLANCOSTRATEBYPERIOD.[column in domain "DATBI"] == CSKS.DATBI
  • P_PLANCOSTRATEBYPERIOD.COSTCENTER == CSKS.KOSTL
  • P_PLANCOSTRATEBYPERIOD.CONTROLLINGAREA == CSKS.KOKRS
  • P_PLANCOSTRATEBYPERIOD.MANDT == CSKS.MANDT
Activity Unit
  • Activity Unit
  • Client
  • P_PLANCOSTRATEBYPERIOD.COSTCTRACTIVITYTYPEQTYUNIT == T006.MSEHI
  • P_PLANCOSTRATEBYPERIOD.MANDT == T006.MANDT
Global Currency
  • Client
  • Company Code Currency
  • Global Currency
  • P_PLANCOSTRATEBYPERIOD.MANDT == TCURC.MANDT
  • P_PLANCOSTRATEBYPERIOD.COMPANYCODECURRENCY == TCURC.WAERS
  • P_PLANCOSTRATEBYPERIOD.GLOBALCURRENCY == TCURC.WAERS
Ledger in General Ledger Accounting
  • Ledger in General Ledger Accounting
  • Client
Plan Category
  • Plan Category
  • Client