EHSDSV_OR_DOCDTL

15 Fields 1 CDS Views

Generated Table for View

EHSDSV_OR_DOCDTL is an SAP database table in S/4HANA. Generated Table for View. It contains 15 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_SftyDataShtOutpReqDocDetails view from BASIC Document Details of a Safety Data Sheet Output Request

Fields (15)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY sftydatashtoutpreqdocdetsuuid EHSDS_OR_DOC_DETAIL_UUID SDS Document Detail
sftydatashtoutprequuid EHSDS_OR_UUID SDS Output Request
creationutcdatetime TIMESTAMPL Time Stamp
createdbyuser UNAME User Name
lastchangeutcdatetime TIMESTAMPL Time Stamp
lastchangedbyuser UNAME User Name
cmplrqrsltdocinfouuid EHSDS_CRR_DOC_INFO_UUID Document Information
filename EHSDS_FILE_NAME File Name
mimetype W3CONTTYPE MIME type
material MATNR Material
shipment_rejected EHSDS_OR_DOC_SHIPMENT_REJECTED Shipment Rejected
filesize EHSDS_SDS_FILE_SIZE Safety Data Sheet File Size
nmbrofpages EHSDS_SDS_PAGE_COUNT SDS Number of Pages
sftydatashtisavailable EHSDS_SDS_IS_AVAILABLE Safety Data Sheet is Available

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.

-- Generated Table for View
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EHSDSV_OR_DOCDTL (
    CLIENT,                         -- Client [MANDT]
    SFTYDATASHTOUTPREQDOCDETSUUID,  -- SDS Document Detail [EHSDS_OR_DOC_DETAIL_UUID]
    SFTYDATASHTOUTPREQUUID,         -- SDS Output Request [EHSDS_OR_UUID]
    CREATIONUTCDATETIME,            -- Time Stamp [TIMESTAMPL]
    CREATEDBYUSER,                  -- User Name [UNAME]
    LASTCHANGEUTCDATETIME,          -- Time Stamp [TIMESTAMPL]
    LASTCHANGEDBYUSER,              -- User Name [UNAME]
    CMPLRQRSLTDOCINFOUUID,          -- Document Information [EHSDS_CRR_DOC_INFO_UUID]
    FILENAME,                       -- File Name [EHSDS_FILE_NAME]
    MIMETYPE,                       -- MIME type [W3CONTTYPE]
    MATERIAL,                       -- Material [MATNR]
    SHIPMENT_REJECTED,              -- Shipment Rejected [EHSDS_OR_DOC_SHIPMENT_REJECTED]
    FILESIZE,                       -- Safety Data Sheet File Size [EHSDS_SDS_FILE_SIZE]
    NMBROFPAGES,                    -- SDS Number of Pages [EHSDS_SDS_PAGE_COUNT]
    SFTYDATASHTISAVAILABLE,         -- Safety Data Sheet is Available [EHSDS_SDS_IS_AVAILABLE]
    PRIMARY KEY (CLIENT, SFTYDATASHTOUTPREQDOCDETSUUID)
);

Learn More