P_RAFISCALPERIOD

CDS View
6 Fields 2 CDS Views

Fiscal Period

P_RAFISCALPERIOD is a CDS View in S/4HANA. Fiscal Period. It contains 6 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
P_RAContrBalFiscalPeriodSel view_entity from COMPOSITE 116A: Selected Fiscal Period
P_RAPerfOblignAllPeriods view_entity right_outer COMPOSITE all periods between start and end date

Fields (6)

KeyField CDS FieldsUsed in Views
KEY AccountingPrinciple AccountingPrinciple 1
KEY CompanyCode CompanyCode 1
KEY FiscalPeriod FiscalPeriod 2
KEY FiscalYear FiscalYear 2
KEY FiscalYearPeriod FiscalYearPeriod 1
FiscalQuarter FiscalQuarterNumber 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 Period
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_RAFISCALPERIOD (
    ACCOUNTINGPRINCIPLE,
    COMPANYCODE,
    FISCALPERIOD,
    FISCALYEAR,
    FISCALYEARPERIOD,
    FISCALQUARTER,
    PRIMARY KEY (ACCOUNTINGPRINCIPLE, COMPANYCODE, FISCALPERIOD, FISCALYEAR, FISCALYEARPERIOD)
);

Learn More