CDR_FILE

Transparent Table Temporary Data
28 Fields 2 CDS Views

Data Return: File Information

CDR_FILE is an SAP database table in S/4HANA. Data Return: File Information. It contains 28 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
CDR_I_FILE_ARC_U view_entity from COMPOSITE CDS View for File Info Screen (Arc Pack)
CDR_I_PACKAGE_FILES_U view_entity from COMPOSITE files information for package level

Fields (28)

KeyField Data ElementDescription DomainTypeLength
KEY client mandt Client
KEY packid cdr_packid Package
KEY appl_comp ufps_posid Applic. Component
KEY tabname tabname Table Name
KEY file_seqno cdr_file_seq File Sequence
filename cdr_fileintern Log. File
filename_ext localfile File name
filesize filesize Length of file
failed boolean Boolean Variable (X = True, - = False, Space = Unknown)
in_process boolean Boolean Variable (X = True, - = False, Space = Unknown)
exec_server btcsrvname Server
exec_procid btcsrvname Server
file_status cdr_file_status File Status
max_file_size filesize Length of file
used_file_size filesize Length of file
dwn_finish boolean Boolean Variable (X = True, - = False, Space = Unknown)
del_finish boolean Boolean Variable (X = True, - = False, Space = Unknown)
crt_user syuname User Name
crt_timestamp timestamp Time Stamp
dwn_user syuname User Name
dwn_timestamp timestamp Time Stamp
dwn_tmstmp_end timestamp Time Stamp
del_user syuname User Name
del_timestamp timestamp Time Stamp
lognumber balognr Log Number
crt_user_alias abap.char Create User Alias
dwn_user_alias abap.char Download User Alias
del_user_alias abap.char Delete User Alias

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.

-- Data Return: File Information
-- Category TRANSPARENT · Delivery class L
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CDR_FILE (
    CLIENT,          -- Client [mandt]
    PACKID,          -- Package [cdr_packid]
    APPL_COMP,       -- Applic. Component [ufps_posid]
    TABNAME,         -- Table Name [tabname]
    FILE_SEQNO,      -- File Sequence [cdr_file_seq]
    FILENAME,        -- Log. File [cdr_fileintern]
    FILENAME_EXT,    -- File name [localfile]
    FILESIZE,        -- Length of file [filesize]
    FAILED,          -- Boolean Variable (X = True, - = False, Space = Unknown) [boolean]
    IN_PROCESS,      -- Boolean Variable (X = True, - = False, Space = Unknown) [boolean]
    EXEC_SERVER,     -- Server [btcsrvname]
    EXEC_PROCID,     -- Server [btcsrvname]
    FILE_STATUS,     -- File Status [cdr_file_status]
    MAX_FILE_SIZE,   -- Length of file [filesize]
    USED_FILE_SIZE,  -- Length of file [filesize]
    DWN_FINISH,      -- Boolean Variable (X = True, - = False, Space = Unknown) [boolean]
    DEL_FINISH,      -- Boolean Variable (X = True, - = False, Space = Unknown) [boolean]
    CRT_USER,        -- User Name [syuname]
    CRT_TIMESTAMP,   -- Time Stamp [timestamp]
    DWN_USER,        -- User Name [syuname]
    DWN_TIMESTAMP,   -- Time Stamp [timestamp]
    DWN_TMSTMP_END,  -- Time Stamp [timestamp]
    DEL_USER,        -- User Name [syuname]
    DEL_TIMESTAMP,   -- Time Stamp [timestamp]
    LOGNUMBER,       -- Log Number [balognr]
    CRT_USER_ALIAS,  -- Create User Alias [abap.char]
    DWN_USER_ALIAS,  -- Download User Alias [abap.char]
    DEL_USER_ALIAS,  -- Delete User Alias [abap.char]
    PRIMARY KEY (CLIENT, PACKID, APPL_COMP, TABNAME, FILE_SEQNO)
);

Learn More