CPEC_PERIODDET

Transparent Table Control Table (SAP+Cust)
22 Fields 2 CDS Views

CPE Term - Period Determination Rule

CPEC_PERIODDET is an SAP database table in S/4HANA. CPE Term - Period Determination Rule. It contains 22 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_CmmdtyPrcCrcyPerdDetnRuleDef view_entity from BASIC Period Determination Rule Definition
I_CmmdtyPrcgQtnPerdDetnRuleDef view_entity from BASIC Quotation Period Determination Rule

Fields (22)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY logsys LOGSYS Logical system
KEY perioddetrule CPET_PERDETRULE Period Determ. Rule
KEY validto CPET_VALIDFROM Valid From
perioddetrout CPET_PERDETROUT Period Det. Routine
sourcerout CPET_SOURCEROUT Source Routine
refdaterout CPET_REFDATEROUT Ref. Date Routine
dateoffsetrout CPET_DATEOFFSETROUT Date Offset Routine
offsetunits CPET_OFFSETUNITS No. Time Units
timeuomrout CPET_TIMEUOMROUT Time UoM Routine
timeunitsbef CPET_TIMEUNITSBEF Time Units Before
timeunitsaft CPET_TIMEUNITSAFT Time Units After
excl_basedate CPET_EXCL_BASEDATE Exclude Base Date
datefrom CPET_DATEFROM Fixed Start Date
timefrom CPET_TIMEFROM Fixed Start Time
dateto CPET_DATETO Fixed End Date
timeto CPET_TIMETO Fixed End Time
datelistrout CPET_DATELISTROUT Date List Routine
perdetcalid CPET_PERDETCALID Period Det. Calendar
missentryrout CPET_MISSENTRYROUT Miss. Entry Routine
closeddaysrout CPET_CLOSEDDAYSROUT Closed Days Routine
maxweighting CPET_MAXWEIGHTING Max. Weighting

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.

-- CPE Term - Period Determination Rule
-- Category TRANSPARENT · Delivery class E
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CPEC_PERIODDET (
    CLIENT,          -- Client [MANDT]
    LOGSYS,          -- Logical system [LOGSYS]
    PERIODDETRULE,   -- Period Determ. Rule [CPET_PERDETRULE]
    VALIDTO,         -- Valid From [CPET_VALIDFROM]
    PERIODDETROUT,   -- Period Det. Routine [CPET_PERDETROUT]
    SOURCEROUT,      -- Source Routine [CPET_SOURCEROUT]
    REFDATEROUT,     -- Ref. Date Routine [CPET_REFDATEROUT]
    DATEOFFSETROUT,  -- Date Offset Routine [CPET_DATEOFFSETROUT]
    OFFSETUNITS,     -- No. Time Units [CPET_OFFSETUNITS]
    TIMEUOMROUT,     -- Time UoM Routine [CPET_TIMEUOMROUT]
    TIMEUNITSBEF,    -- Time Units Before [CPET_TIMEUNITSBEF]
    TIMEUNITSAFT,    -- Time Units After [CPET_TIMEUNITSAFT]
    EXCL_BASEDATE,   -- Exclude Base Date [CPET_EXCL_BASEDATE]
    DATEFROM,        -- Fixed Start Date [CPET_DATEFROM]
    TIMEFROM,        -- Fixed Start Time [CPET_TIMEFROM]
    DATETO,          -- Fixed End Date [CPET_DATETO]
    TIMETO,          -- Fixed End Time [CPET_TIMETO]
    DATELISTROUT,    -- Date List Routine [CPET_DATELISTROUT]
    PERDETCALID,     -- Period Det. Calendar [CPET_PERDETCALID]
    MISSENTRYROUT,   -- Miss. Entry Routine [CPET_MISSENTRYROUT]
    CLOSEDDAYSROUT,  -- Closed Days Routine [CPET_CLOSEDDAYSROUT]
    MAXWEIGHTING,    -- Max. Weighting [CPET_MAXWEIGHTING]
    PRIMARY KEY (CLIENT, LOGSYS, PERIODDETRULE, VALIDTO)
);

Learn More