I_FISCALYEARPERIODFORCMPNYCODE

CDS View
17 Fields 20 CDS Views

Fiscal Year Period For Company Code

I_FISCALYEARPERIODFORCMPNYCODE is a CDS View in S/4HANA. Fiscal Year Period For Company Code. It contains 17 fields. 20 CDS views read from this table.

CDS Views using this table (20)

ViewTypeJoinVDMDescription
C_ActualCostRateTimeline view inner CONSUMPTION Actual Cost Rate Timeline
C_APMinFiscalPeriodStartDate view from CONSUMPTION Minimal Fiscal Period Start Date
C_FiscalYearPeriodForCoCodeVH view_entity from CONSUMPTION Fiscal Year Period For Company Code
C_ServiceCostRateTimeline view inner CONSUMPTION Service Cost Rate Timeline Chart
C_SlsAcctgFsclPerdForCoCodeVH view from CONSUMPTION Fiscal Year Period for Company Code Value Help
I_JVAFiscalYearPeriodForCoCode view from COMPOSITE JVA Fiscal Year Period For Company Code
I_JVAFiscalYearPeriodForCoCode view inner COMPOSITE JVA Fiscal Year Period For Company Code
I_JVAFiscalYrPerdForEquityGrp view inner COMPOSITE JVA Fiscal Year Period For Equity Group
I_LastDayOfFsclDteFunctionVH view from BASIC Last day of fiscal date function
I_PPM_CurrentPeriod view inner COMPOSITE Current period for a project
I_ProjFYPeriodForCoCodeVH view_entity from COMPOSITE Fiscal Year Period For Company Code
I_USFedFiscalYearPeriod view_entity from BASIC US Federal Fiscal Year Period
P_EBWIP_WIPQtyDocument view_entity inner COMPOSITE
P_EntProjActlCostDatesByID view inner CONSUMPTION
P_FIARCN_TOTAL_PERIODS view from CONSUMPTION
P_FiscalPeriodLast6Mnths view from COMPOSITE
P_Matval_Manage_FiscPer_Info view from COMPOSITE
P_Matval_Manage_Val_Chart view inner BASIC
P_PCCOrderOutPutQtyByPeriod view inner COMPOSITE
P_PH_SalesPurchasesSummaryItem view left_outer COMPOSITE

Fields (17)

KeyField CDS FieldsUsed in Views
KEY CompanyCode CompanyCode 3
KEY FiscalPeriod CurrentFiscalPeriod,FiscalPeriod,PreviousFiscalPeriod 6
KEY FiscalYear CurrentFiscalYear,FiscalYear,PreviousFiscalYear 6
_CompanyCode _CompanyCode 1
_FiscalPeriodStartDate _FiscalPeriodStartDate 1
_FiscalYear _FiscalYear 1
_FiscalYearVariant _FiscalYearVariant 1
_Text _Text 1
FiscalPeriodEndDate FiscalPeriodEndDate 3
FiscalPeriodStartDate DateFunctionStartDate,FiscalPeriodStartDate 3
FiscalYearEndDate FiscalYearEndDate 1
FiscalYearPeriod FiscalYearPeriod 2
FiscalYearStartDate FiscalYearStartDate 1
FiscalYearVariant FiscalYearVariant 1
IsSpecialPeriod IsSpecialPeriod 1
NextFiscalPeriod NextFiscalPeriod 1
NextFiscalPeriodFiscalYear NextFiscalPeriodFiscalYear 1

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Fiscal Year Period For Company Code
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_FISCALYEARPERIODFORCMPNYCODE (
    COMPANYCODE,
    FISCALPERIOD,
    FISCALYEAR,
    _COMPANYCODE,
    _FISCALPERIODSTARTDATE,
    _FISCALYEAR,
    _FISCALYEARVARIANT,
    _TEXT,
    FISCALPERIODENDDATE,
    FISCALPERIODSTARTDATE,
    FISCALYEARENDDATE,
    FISCALYEARPERIOD,
    FISCALYEARSTARTDATE,
    FISCALYEARVARIANT,
    ISSPECIALPERIOD,
    NEXTFISCALPERIOD,
    NEXTFISCALPERIODFISCALYEAR,
    PRIMARY KEY (COMPANYCODE, FISCALPERIOD, FISCALYEAR)
);

Learn More