EHSDSV_OR

22 Fields 1 CDS Views

Generated Table for View

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

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_SftyDataShtOutpReq view from BASIC Safety Data Sheet Output Request

Fields (22)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY sftydatashtoutprequuid EHSDS_OR_UUID SDS Output Request
creationutcdatetime TIMESTAMPL Time Stamp
createdbyuser UNAME User Name
lastchangeutcdatetime TIMESTAMPL Time Stamp
lastchangedbyuser UNAME User Name
sftydatashtrcpntpty EHSDS_SDS_RECIPIENT_PARTY Recipient
sftydatashtoutpdatetime EHSDS_OR_OUTPUT_DATETIME Safety Data Sheet Output Date
sftydatashtoutpreqstatus EHSDS_OR_STATUS Status
sftydatashtshipmentdatetime EHSDS_OR_SHIPMENT_DATETIME SDS Shipment Date and Time
salesorganization VKORG Sales Org.
shiptoparty EHSDS_SDS_SHIP_TO_PARTY Ship-To Party
shiptopartycountry EHSDS_SDS_SHIP_TO_COUNTRY_ID Country/Region
sftydatashtcntctid EHSDS_CNTCT_ID Identifier
sftydatashtoutpreqmanreqemail EHSDS_SDS_RECIPIENT_EMAIL E-Mail Address
sftydatashtoutpreqnotetext EHSDS_SDS_NOTES Notes
shiptopartyregion EHSDS_SDS_SHIP_TO_REGION_ID Region
sftydatashtoutpreqismigrated EHSDS_OR_IS_MIGRATED Is Migrated
sftydatashtrcpntaddrid EHSDS_SDS_RECEIVER_ADRNR SDS Recipient Address
shiptopartyaddressid EHSDS_SDS_SHIP_TO_PARTY_ADR Ship-to Party Address
customer EHSDS_SDS_SHIP_TO_PARTY_CUST Ship-To Party Customer
sftydtashtrcpntptydetntype EHSDS_SDS_REC_DETERMINE_TYPE Determination

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 (
    CLIENT,                         -- Client [MANDT]
    SFTYDATASHTOUTPREQUUID,         -- SDS Output Request [EHSDS_OR_UUID]
    CREATIONUTCDATETIME,            -- Time Stamp [TIMESTAMPL]
    CREATEDBYUSER,                  -- User Name [UNAME]
    LASTCHANGEUTCDATETIME,          -- Time Stamp [TIMESTAMPL]
    LASTCHANGEDBYUSER,              -- User Name [UNAME]
    SFTYDATASHTRCPNTPTY,            -- Recipient [EHSDS_SDS_RECIPIENT_PARTY]
    SFTYDATASHTOUTPDATETIME,        -- Safety Data Sheet Output Date [EHSDS_OR_OUTPUT_DATETIME]
    SFTYDATASHTOUTPREQSTATUS,       -- Status [EHSDS_OR_STATUS]
    SFTYDATASHTSHIPMENTDATETIME,    -- SDS Shipment Date and Time [EHSDS_OR_SHIPMENT_DATETIME]
    SALESORGANIZATION,              -- Sales Org. [VKORG]
    SHIPTOPARTY,                    -- Ship-To Party [EHSDS_SDS_SHIP_TO_PARTY]
    SHIPTOPARTYCOUNTRY,             -- Country/Region [EHSDS_SDS_SHIP_TO_COUNTRY_ID]
    SFTYDATASHTCNTCTID,             -- Identifier [EHSDS_CNTCT_ID]
    SFTYDATASHTOUTPREQMANREQEMAIL,  -- E-Mail Address [EHSDS_SDS_RECIPIENT_EMAIL]
    SFTYDATASHTOUTPREQNOTETEXT,     -- Notes [EHSDS_SDS_NOTES]
    SHIPTOPARTYREGION,              -- Region [EHSDS_SDS_SHIP_TO_REGION_ID]
    SFTYDATASHTOUTPREQISMIGRATED,   -- Is Migrated [EHSDS_OR_IS_MIGRATED]
    SFTYDATASHTRCPNTADDRID,         -- SDS Recipient Address [EHSDS_SDS_RECEIVER_ADRNR]
    SHIPTOPARTYADDRESSID,           -- Ship-to Party Address [EHSDS_SDS_SHIP_TO_PARTY_ADR]
    CUSTOMER,                       -- Ship-To Party Customer [EHSDS_SDS_SHIP_TO_PARTY_CUST]
    SFTYDTASHTRCPNTPTYDETNTYPE,     -- Determination [EHSDS_SDS_REC_DETERMINE_TYPE]
    PRIMARY KEY (CLIENT, SFTYDATASHTOUTPREQUUID)
);

Learn More