EHSDSV_OR

EHSDSV_OR is an SAP database table in S/4HANA. It contains 12 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 (12)

KeyField CDS FieldsUsed in Views
customer Customer 1
salesorganization SalesOrganization 1
sftydatashtcntctid SftyDataShtCntctID 1
sftydatashtoutpreqismigrated SftyDataShtOutpReqIsMigrated 1
sftydatashtoutpreqmanreqemail SftyDataShtOutpReqManReqEmail 1
sftydatashtoutpreqnotetext SftyDataShtOutpReqNoteText 1
sftydatashtrcpntaddrid SftyDataShtRcpntAddrID 1
sftydtashtrcpntptydetntype SftyDtaShtRcpntPtyDetnType 1
shiptoparty ShipToParty 1
shiptopartyaddressid ShipToPartyAddressID 1
shiptopartycountry ShipToPartyCountry 1
shiptopartyregion ShipToPartyRegion 1

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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EHSDSV_OR (
    CUSTOMER,
    SALESORGANIZATION,
    SFTYDATASHTCNTCTID,
    SFTYDATASHTOUTPREQISMIGRATED,
    SFTYDATASHTOUTPREQMANREQEMAIL,
    SFTYDATASHTOUTPREQNOTETEXT,
    SFTYDATASHTRCPNTADDRID,
    SFTYDTASHTRCPNTPTYDETNTYPE,
    SHIPTOPARTY,
    SHIPTOPARTYADDRESSID,
    SHIPTOPARTYCOUNTRY,
    SHIPTOPARTYREGION
);