EHSDSD_OR_ITEM

Transparent Table Application Table
22 Fields 2 CDS Views

SDS Output Request Item

EHSDSD_OR_ITEM is an SAP database table in S/4HANA. SDS Output Request Item. It contains 22 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_ProdCmplncLicRlvtCmplncDocs view from BASIC License Relevant Compliance Documents
PRODCMPLNCLICRLVTCMPLNCDOCS view from License Relevant Compliance Documents

Fields (22)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY request_item_uuid EHSDS_OR_ITEM_UUID SDS Output Request Item
request_uuid EHSDS_OR_UUID SDS Output Request
crea_date_time TIMESTAMPL Time Stamp
crea_uname UNAME User Name
lchg_date_time TIMESTAMPL Time Stamp
lchg_uname UNAME User Name
material EHFND_MAT_ID Product
delivery VBELN_VL Delivery
delivery_item POSNR_VL Item
sds_cr_id EHSDS_SDS_CR_ID SDS Compliance Requirement
sds_crr_uuid EHSDS_CRR_UUID SDS Assessment
request_item_status EHSDS_OR_ITEM_STATUS Shipment Status
cci_uuid EHFND_CCI_UUID Chemical Compliance Information
cci_prod_uuid EHFND_CCI_UP_UUID Chemical Compliance Information UP
recipient_party_id EHSDS_SDS_RECIPIENT_PARTY_OBLT SDS Recipient (obsolete)
ship_to_party EHSDS_SDS_SHIP_TO_PARTY_OBSLT Ship-To Party (obsolete)
ship_to_country EHSDS_SDS_SHIP_TO_COUNTRY_OBLT Country/Region (obsolete)
delivery_gi_date EHFND_DELIVERY_GI_DATETIME Delivery Goods Issue
origin EHSDS_OR_ORIGIN_TYPE Origin of SDS Shipment
reason EHSDS_OR_ITEM_REASON Reason
product_name_on_sds 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.

-- SDS Output Request Item
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EHSDSD_OR_ITEM (
    MANDT,                -- Client [MANDT]
    REQUEST_ITEM_UUID,    -- SDS Output Request Item [EHSDS_OR_ITEM_UUID]
    REQUEST_UUID,         -- SDS Output Request [EHSDS_OR_UUID]
    CREA_DATE_TIME,       -- Time Stamp [TIMESTAMPL]
    CREA_UNAME,           -- User Name [UNAME]
    LCHG_DATE_TIME,       -- Time Stamp [TIMESTAMPL]
    LCHG_UNAME,           -- User Name [UNAME]
    MATERIAL,             -- Product [EHFND_MAT_ID]
    DELIVERY,             -- Delivery [VBELN_VL]
    DELIVERY_ITEM,        -- Item [POSNR_VL]
    SDS_CR_ID,            -- SDS Compliance Requirement [EHSDS_SDS_CR_ID]
    SDS_CRR_UUID,         -- SDS Assessment [EHSDS_CRR_UUID]
    REQUEST_ITEM_STATUS,  -- Shipment Status [EHSDS_OR_ITEM_STATUS]
    CCI_UUID,             -- Chemical Compliance Information [EHFND_CCI_UUID]
    CCI_PROD_UUID,        -- Chemical Compliance Information UP [EHFND_CCI_UP_UUID]
    RECIPIENT_PARTY_ID,   -- SDS Recipient (obsolete) [EHSDS_SDS_RECIPIENT_PARTY_OBLT]
    SHIP_TO_PARTY,        -- Ship-To Party (obsolete) [EHSDS_SDS_SHIP_TO_PARTY_OBSLT]
    SHIP_TO_COUNTRY,      -- Country/Region (obsolete) [EHSDS_SDS_SHIP_TO_COUNTRY_OBLT]
    DELIVERY_GI_DATE,     -- Delivery Goods Issue [EHFND_DELIVERY_GI_DATETIME]
    ORIGIN,               -- Origin of SDS Shipment [EHSDS_OR_ORIGIN_TYPE]
    REASON,               -- Reason [EHSDS_OR_ITEM_REASON]
    PRODUCT_NAME_ON_SDS,  -- Product Name on SDS [EHSDS_PRODUCT_NAME_ON_SDS]
    PRIMARY KEY (MANDT, REQUEST_ITEM_UUID)
);

Learn More