EHSDSD_OR_ITEM

Transparent Table Application Table
18 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 18 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 (18)

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
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]
    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