I_FISCALYEARPERIODFORLEDGER

CDS View
9 Fields 33 CDS Views

Fiscal Year Period for Ledger

I_FISCALYEARPERIODFORLEDGER is a CDS View in S/4HANA. Fiscal Year Period for Ledger. It contains 9 fields. 33 CDS views read from this table.

CDS Views using this table (33)

ViewTypeJoinVDMDescription
C_ActualCostRateTimeline view inner CONSUMPTION Actual Cost Rate Timeline
C_CN_CADEAssetByPeriod view from CONSUMPTION Asset Assignment by Period for CADE
C_CN_CADEAssetChangeLog view from CONSUMPTION Change Log of Assgmt of Asset for CADE
C_CN_FsclPerdVH view from CONSUMPTION Fiscal Period Value Help
C_FxdAstFsclYrPerdForLedgerVH view from CONSUMPTION Fixed Asset Fiscal Year Period for Ledger Value Help
C_NL_SAFTPeriod view from CONSUMPTION SAF-T NL Periods
C_PlanCostRateTimeline view inner CONSUMPTION Plan Cost Rate Timeline
C_ServiceCostRateTimeline view inner CONSUMPTION Service Cost Rate Timeline Chart
I_CN_CADECashFlow view left_outer COMPOSITE CADE cash flow details
I_CN_CADEFixedAssetValueCube view from COMPOSITE Fixed Asset Balance Cube for CADE
I_FxdAstAssgmtByFsclPerdEndDte view inner COMPOSITE Fixed Asset Assignment valid at fiscal period end date
I_FxdAstDeprAreaByFsclPerdEnd view inner COMPOSITE Depreciation Area valid at fiscal period end date
I_PostingPeriodHierarchy1 view from COMPOSITE Posting Period Hierarchy 1
I_PostingPeriodHierarchy1 view union COMPOSITE Posting Period Hierarchy 1
P_CN_CADEAcctBalanceStructure view left_outer COMPOSITE
P_CN_CADEAssetAllChgDocWthPrd view inner COMPOSITE
P_CN_CADEAssetQuantity view from COMPOSITE
P_CN_CADECalcExpiredPeriods view inner COMPOSITE
P_CN_CADECashFlowZeroBal view from COMPOSITE
P_CN_CADEFsclPerdForCmpnyCode view from CONSUMPTION
P_EBOC_MaxOrdKeyStatusByPeriod view inner COMPOSITE
P_EBPC_MaxOrderStatusByPeriod view inner COMPOSITE
P_EvtBsdAFYVPeriodConv view_entity from COMPOSITE Fiscal Year Period Conversion
P_EvtBsdAFYVPeriodConv view_entity inner COMPOSITE Fiscal Year Period Conversion
P_FixedAssetValueCube view inner COMPOSITE
P_FsclYearPerdWithSpclPerd view from COMPOSITE
P_RO_StRpFixedAssetChartValue view inner CONSUMPTION
P_RU_MaxFiscalPeriodForLedger view from COMPOSITE Maximum Fiscal Period For Ledger
P_RU_MinFiscalPeriodForLedger view from COMPOSITE Minimum Fiscal Period For Ledger
P_RU_PropertyTaxFixedAssetVal1 view from COMPOSITE
P_RU_PropertyTaxFixedAssetVal3 view left_outer COMPOSITE
R_EvtBsdFsclYrPeriodByKeyDate view from COMPOSITE Event-Based Fiscal Year Period by Key Date
R_EvtBsdKeyDateByFsclYrPeriod view from COMPOSITE Event-Based Key Date by Fiscal Year Period

Fields (9)

KeyField CDS FieldsUsed in Views
KEY CompanyCode CompanyCode 8
KEY FiscalPeriod FiscalPeriod,NextFiscalPeriod,PostingFiscalPeriod 11
KEY FiscalYear FiscalYear,NextFiscalPeriodFiscalYear 13
KEY FiscalYearPeriod FiscalYearPeriod 5
KEY Ledger Ledger 4
FiscalPeriodEndDate CalendarDeprPeriodEndDate,CalendarPostingPeriodEndDate,FiscalPeriodEndDate 6
FiscalPeriodStartDate CalendarDeprPeriodStartDate,CalendarPostingPeriodStartDate,FiscalPeriodStartDate 2
IsSpecialPeriod IsSpecialPeriod 1
NextFiscalPeriod NextFiscalPeriod 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 Ledger
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_FISCALYEARPERIODFORLEDGER (
    COMPANYCODE,
    FISCALPERIOD,
    FISCALYEAR,
    FISCALYEARPERIOD,
    LEDGER,
    FISCALPERIODENDDATE,
    FISCALPERIODSTARTDATE,
    ISSPECIALPERIOD,
    NEXTFISCALPERIOD,
    PRIMARY KEY (COMPANYCODE, FISCALPERIOD, FISCALYEAR, FISCALYEARPERIOD, LEDGER)
);

Learn More