DATEFUNCTION

Transparent Table System Table (transport)
23 Fields 4 CDS Views

Date Functions

DATEFUNCTION is an SAP database table in S/4HANA. Date Functions. It contains 23 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
CORE_DATEFUNCTION view from Get Details of all Date Functions
DTF_LANG_VRS_OBJ_ACTIVE_DTF1 view_entity from
DTF_LANG_VRS_OBJ_EDIT_DTF1 view_entity from
I_Datefunction view from BASIC Date Function

Fields (23)

KeyField Data ElementDescription DomainTypeLength
KEY id DATEFUNCTIONID Relative Date Function
abap_language_version ABAP_LANGUAGE_VERSION Language Version
type DATEFUNCTIONTYPE Function Type
granularity DATEFUNCTIONGRANULARITY Granularity
calendartype DATEFUNCTIONCALENDARTYPE Calendar Type
startpoint DATEFUNCTIONSTARTPOINT Start Point
startoffset DATEFUNCTIONSTARTOFFSETVALUE Start Offset Value
startrelativeoffset DATEFUNCTIONSTARTRELOFFSET Start Relative Offse
startoffsetunit DATEFUNCTIONSTARTOFFSETUNIT Start Offset Unit
startrelativeoffsetunit DATEFUNCTIONSTARTRELOFFSETUNIT Start RelOffset Unit
startyearoffset DATEFUNCTIONSTARTYEAROFFSET Start Year Offset
startfixeddate DATEFUNCTIONSTARTFIXEDDATE Fixed Date
endpoint DATEFUNCTIONENDPOINT Start Point
endoffset DATEFUNCTIONENDOFFSETVALUE Start Offset Value
endrelativeoffset DATEFUNCTIONENDRELOFFSET Start Relative Offse
endoffsetunit DATEFUNCTIONENDOFFSETUNIT Start Offset Unit
endrelativeoffsetunit DATEFUNCTIONENDRELOFFSETUNIT End Rel Offset Unit
endyearoffset DATEFUNCTIONENDYEAROFFSET Start Year Offset
endfixeddate DATEFUNCTIONENDFIXEDDATE Fixed Date
createdby DATEFUNCTIONCREATEDBY Created By User
createdon DATEFUNCTIONCREATEDON Date Func Created On
changedby DATEFUNCTIONCHANGEDBY Changed By User
changedon DATEFUNCTIONCHANGEDON Date Func Changed On

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.

-- Date Functions
-- Category TRANSPARENT · Delivery class W
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE DATEFUNCTION (
    ID,                       -- Relative Date Function [DATEFUNCTIONID]
    ABAP_LANGUAGE_VERSION,    -- Language Version [ABAP_LANGUAGE_VERSION]
    TYPE,                     -- Function Type [DATEFUNCTIONTYPE]
    GRANULARITY,              -- Granularity [DATEFUNCTIONGRANULARITY]
    CALENDARTYPE,             -- Calendar Type [DATEFUNCTIONCALENDARTYPE]
    STARTPOINT,               -- Start Point [DATEFUNCTIONSTARTPOINT]
    STARTOFFSET,              -- Start Offset Value [DATEFUNCTIONSTARTOFFSETVALUE]
    STARTRELATIVEOFFSET,      -- Start Relative Offse [DATEFUNCTIONSTARTRELOFFSET]
    STARTOFFSETUNIT,          -- Start Offset Unit [DATEFUNCTIONSTARTOFFSETUNIT]
    STARTRELATIVEOFFSETUNIT,  -- Start RelOffset Unit [DATEFUNCTIONSTARTRELOFFSETUNIT]
    STARTYEAROFFSET,          -- Start Year Offset [DATEFUNCTIONSTARTYEAROFFSET]
    STARTFIXEDDATE,           -- Fixed Date [DATEFUNCTIONSTARTFIXEDDATE]
    ENDPOINT,                 -- Start Point [DATEFUNCTIONENDPOINT]
    ENDOFFSET,                -- Start Offset Value [DATEFUNCTIONENDOFFSETVALUE]
    ENDRELATIVEOFFSET,        -- Start Relative Offse [DATEFUNCTIONENDRELOFFSET]
    ENDOFFSETUNIT,            -- Start Offset Unit [DATEFUNCTIONENDOFFSETUNIT]
    ENDRELATIVEOFFSETUNIT,    -- End Rel Offset Unit [DATEFUNCTIONENDRELOFFSETUNIT]
    ENDYEAROFFSET,            -- Start Year Offset [DATEFUNCTIONENDYEAROFFSET]
    ENDFIXEDDATE,             -- Fixed Date [DATEFUNCTIONENDFIXEDDATE]
    CREATEDBY,                -- Created By User [DATEFUNCTIONCREATEDBY]
    CREATEDON,                -- Date Func Created On [DATEFUNCTIONCREATEDON]
    CHANGEDBY,                -- Changed By User [DATEFUNCTIONCHANGEDBY]
    CHANGEDON,                -- Date Func Changed On [DATEFUNCTIONCHANGEDON]
    PRIMARY KEY (ID)
);

Learn More