EHSDSV_OR_ITEM

22 Fields 1 CDS Views

Generated Table for View

EHSDSV_OR_ITEM 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_SftyDataShtOutpReqItem view from BASIC Item of an SDS Output Request

Fields (22)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY sftydatashtoutpreqitemuuid EHSDS_OR_ITEM_UUID SDS Output Request Item
sftydatashtoutprequuid EHSDS_OR_UUID SDS Output Request
creationutcdatetime TIMESTAMPL Time Stamp
createdbyuser UNAME User Name
lastchangeutcdatetime TIMESTAMPL Time Stamp
lastchangedbyuser UNAME User Name
material EHFND_MAT_ID Product
deliverydocumentitem POSNR_VL Item
cmplrqrsltuuid EHSDS_CRR_UUID SDS Assessment
sftydatashtoutpreqitemstatus EHSDS_OR_ITEM_STATUS Shipment Status
chmlcmplncinfouuid EHFND_CCI_UUID Chemical Compliance Information
chmlcmplncproduuid EHFND_CCI_UP_UUID Chemical Compliance Information UP
deliverydocument VBELN_VL Delivery
sftydatashtcmplncrqmt EHSDS_SDS_CR_ID SDS Compliance Requirement
sftydatashtrcpntpty EHSDS_SDS_RECIPIENT_PARTY_OBLT SDS Recipient (obsolete)
shiptoparty EHSDS_SDS_SHIP_TO_PARTY_OBSLT Ship-To Party (obsolete)
country EHSDS_SDS_SHIP_TO_COUNTRY_OBLT Country/Region (obsolete)
goodsissuedatetime EHFND_DELIVERY_GI_DATETIME Delivery Goods Issue
sftydatashtoutpreqorigintype EHSDS_OR_ORIGIN_TYPE Origin of SDS Shipment
sftydatashtoutpreqitemreason EHSDS_OR_ITEM_REASON Reason
sftydatashtproductname EHSDS_PRODUCT_NAME_ON_SDS Product Name on SDS

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_ITEM (
    CLIENT,                        -- Client [MANDT]
    SFTYDATASHTOUTPREQITEMUUID,    -- SDS Output Request Item [EHSDS_OR_ITEM_UUID]
    SFTYDATASHTOUTPREQUUID,        -- SDS Output Request [EHSDS_OR_UUID]
    CREATIONUTCDATETIME,           -- Time Stamp [TIMESTAMPL]
    CREATEDBYUSER,                 -- User Name [UNAME]
    LASTCHANGEUTCDATETIME,         -- Time Stamp [TIMESTAMPL]
    LASTCHANGEDBYUSER,             -- User Name [UNAME]
    MATERIAL,                      -- Product [EHFND_MAT_ID]
    DELIVERYDOCUMENTITEM,          -- Item [POSNR_VL]
    CMPLRQRSLTUUID,                -- SDS Assessment [EHSDS_CRR_UUID]
    SFTYDATASHTOUTPREQITEMSTATUS,  -- Shipment Status [EHSDS_OR_ITEM_STATUS]
    CHMLCMPLNCINFOUUID,            -- Chemical Compliance Information [EHFND_CCI_UUID]
    CHMLCMPLNCPRODUUID,            -- Chemical Compliance Information UP [EHFND_CCI_UP_UUID]
    DELIVERYDOCUMENT,              -- Delivery [VBELN_VL]
    SFTYDATASHTCMPLNCRQMT,         -- SDS Compliance Requirement [EHSDS_SDS_CR_ID]
    SFTYDATASHTRCPNTPTY,           -- SDS Recipient (obsolete) [EHSDS_SDS_RECIPIENT_PARTY_OBLT]
    SHIPTOPARTY,                   -- Ship-To Party (obsolete) [EHSDS_SDS_SHIP_TO_PARTY_OBSLT]
    COUNTRY,                       -- Country/Region (obsolete) [EHSDS_SDS_SHIP_TO_COUNTRY_OBLT]
    GOODSISSUEDATETIME,            -- Delivery Goods Issue [EHFND_DELIVERY_GI_DATETIME]
    SFTYDATASHTOUTPREQORIGINTYPE,  -- Origin of SDS Shipment [EHSDS_OR_ORIGIN_TYPE]
    SFTYDATASHTOUTPREQITEMREASON,  -- Reason [EHSDS_OR_ITEM_REASON]
    SFTYDATASHTPRODUCTNAME,        -- Product Name on SDS [EHSDS_PRODUCT_NAME_ON_SDS]
    PRIMARY KEY (CLIENT, SFTYDATASHTOUTPREQITEMUUID)
);

Learn More