P_FsclCalenderLedgerWithCC

Private view for fiscal calendar both ledger and CoCode | view: PFIFCLLDCC | Extraction: Not supported | Component: Information System
Column Name Description
CalendarDate Calendar Date
CompanyCode FK Company Code
Ledger FK Ledger
Column Name Description
Column Name Description
Column Name Description
CalendarDate Calendar Date
LedgerFiscalYearStartDate Start Date of Fiscal Year
LedgerFiscalYearEndDate End Date of Fiscal Year
LedgerFiscalPeriodStartDate Start Date of Fiscal Period
LedgerFiscalPeriodEndDate End Date of Fiscal Period
LedgerFiscalQuarterStartDate Start Date of Fiscal Quarter
LedgerFiscalQuarterEndDate End Date of Fiscal Quarter
LedgerFiscalWeekStartDate Start Date of Fiscal Week
LedgerFiscalWeekEndDate End Date of Fiscal Week
CoCodeFiscalYearStartDate Start Date of Fiscal Year
CoCodeFiscalYearEndDate End Date of Fiscal Year
CoCodeFiscalPeriodStartDate Start Date of Fiscal Period
CoCodeFiscalPeriodEndDate End Date of Fiscal Period
CoCodeFiscalQuarterStartDate Start Date of Fiscal Quarter
CoCodeFiscalQuarterEndDate End Date of Fiscal Quarter
CoCodeFiscalWeekStartDate Start Date of Fiscal Week
CoCodeFiscalWeekEndDate End Date of Fiscal Week
PostingDate Calendar Date
FiscalYearStartDate Start Date of Fiscal Year
FiscalYearEndDate End Date of Fiscal Year
FiscalPeriodStartDate Start Date of Fiscal Period
FiscalPeriodEndDate End Date of Fiscal Period
FiscalQuarterStartDate Start Date of Fiscal Quarter
FiscalQuarterEndDate End Date of Fiscal Quarter
FiscalWeekStartDate Start Date of Fiscal Week
FiscalWeekEndDate End Date of Fiscal Week
Column Name Description
Column Name Description Domain name
LedgerFiscalYear Fiscal Year GJAHR
LedgerFiscalPeriod Fiscal Period POPER
LedgerFiscalQuarter Fiscal Quarter FINS_FSCALQUARTER
LedgerFiscalWeek Fiscal Week FINS_FISCALWEEK
LedgerFiscalYearPeriod Fiscal Year + Fiscal Period FINS_FYEARPERIOD
LedgerFiscalYearQuarter Fiscal Year + Fiscal Quarter FINS_FYEARQUARTER
LedgerFiscalYearWeek Fiscal Year + Fiscal Week FINS_FYEARWEEK
LedgerFiscalPeriodNumber Fiscal Year Period (Numbering) FINS_FYEARPERIOD_I
LedgerFiscalQuarterNumber Fiscal Year Quarter (Numbering) FINS_FYEARQUARTER_I
LedgerFiscalWeekNumber Fiscal Year Week (Numbering) FINS_FYEARWEEK_I
FiscalPeriodDate Fiscal Period Date FIS_FISCALPERIOD_DATE
CoCodeFiscalYear Fiscal Year GJAHR
CoCodeFiscalPeriod Fiscal Period POPER
CoCodeFiscalQuarter Fiscal Quarter FINS_FSCALQUARTER
CoCodeFiscalWeek Fiscal Week FINS_FISCALWEEK
CoCodeFiscalYearPeriod Fiscal Year + Fiscal Period FINS_FYEARPERIOD
CoCodeFiscalYearQuarter Fiscal Year + Fiscal Quarter FINS_FYEARQUARTER
CoCodeFiscalYearWeek Fiscal Year + Fiscal Week FINS_FYEARWEEK
CoCodeFiscalPeriodNumber Fiscal Year Period (Numbering) FINS_FYEARPERIOD_I
CoCodeFiscalQuarterNumber Fiscal Year Quarter (Numbering) FINS_FYEARQUARTER_I
CoCodeFiscalWeekNumber Fiscal Year Week (Numbering) FINS_FYEARWEEK_I
CalendarYear Calendar Year NUM4
CalendarQuarter Calendar Quarter NUM1
CalendarYearQuarter Year Quarter NUM5
CalendarMonth Calendar Month NUM2
CalendarYearMonth Year Month NUM6
CalendarWeek Calendar Week NUM2
CalendarYearWeek Year Week NUM6
FiscalYear Fiscal Year GJAHR
FiscalPeriod Fiscal Period POPER
FiscalQuarter Fiscal Quarter FINS_FSCALQUARTER
FiscalWeek Fiscal Week FINS_FISCALWEEK
FiscalYearPeriod Fiscal Year + Fiscal Period FINS_FYEARPERIOD
FiscalYearQuarter Fiscal Year + Fiscal Quarter FINS_FYEARQUARTER
FiscalYearWeek Fiscal Year + Fiscal Week FINS_FYEARWEEK
FiscalPeriodNumber Fiscal Year Period (Numbering) FINS_FYEARPERIOD_I
FiscalQuarterNumber Fiscal Year Quarter (Numbering) FINS_FYEARQUARTER_I
FiscalWeekNumber Fiscal Year Week (Numbering) FINS_FYEARWEEK_I
Master Data Relations Join Conditions
Fiscal Year Variant
  • Client
  • Fiscal Year Variant
  • Fiscal Year Variant
  • Fiscal Year Variant
  • P_FSCLCALENDERLEDGERWITHCC.MANDT == T009.MANDT
  • P_FSCLCALENDERLEDGERWITHCC.COCODEFISCALYEARVARIANT == T009.PERIV
  • P_FSCLCALENDERLEDGERWITHCC.FISCALYEARVARIANT == T009.PERIV
  • P_FSCLCALENDERLEDGERWITHCC.LEDGERFISCALYEARVARIANT == T009.PERIV
Company Code
  • Client
  • Company Code
  • P_FSCLCALENDERLEDGERWITHCC.MANDT == T001.MANDT
  • P_FSCLCALENDERLEDGERWITHCC.COMPANYCODE == T001.BUKRS
Controlling Area
  • Controlling Area
  • Client
  • P_FSCLCALENDERLEDGERWITHCC.CONTROLLINGAREA == TKA01.KOKRS
  • P_FSCLCALENDERLEDGERWITHCC.MANDT == TKA01.MANDT
Fiscal Year Variant
  • Client
  • Fiscal Year Variant
  • Fiscal Year Variant
  • Fiscal Year Variant
  • P_FSCLCALENDERLEDGERWITHCC.MANDT == T009.MANDT
  • P_FSCLCALENDERLEDGERWITHCC.COCODEFISCALYEARVARIANT == T009.PERIV
  • P_FSCLCALENDERLEDGERWITHCC.FISCALYEARVARIANT == T009.PERIV
  • P_FSCLCALENDERLEDGERWITHCC.LEDGERFISCALYEARVARIANT == T009.PERIV
Ledger
  • Client
  • Ledger
Fiscal Year Variant
  • Client
  • Fiscal Year Variant
  • Fiscal Year Variant
  • Fiscal Year Variant
  • P_FSCLCALENDERLEDGERWITHCC.MANDT == T009.MANDT
  • P_FSCLCALENDERLEDGERWITHCC.COCODEFISCALYEARVARIANT == T009.PERIV
  • P_FSCLCALENDERLEDGERWITHCC.FISCALYEARVARIANT == T009.PERIV
  • P_FSCLCALENDERLEDGERWITHCC.LEDGERFISCALYEARVARIANT == T009.PERIV