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
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
multicomponentproduct ehfnd_mcp_id
cci_bp_uuid ehfnd_cci_bp_uuid
fallback_cr_is_used ehsds_flb_cr_is_used
country_used_for_sds_check ehsds_sds_calc_country_id

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]
    MULTICOMPONENTPRODUCT,       -- ehfnd_mcp_id
    CCI_BP_UUID,                 -- ehfnd_cci_bp_uuid
    FALLBACK_CR_IS_USED,         -- ehsds_flb_cr_is_used
    COUNTRY_USED_FOR_SDS_CHECK,  -- ehsds_sds_calc_country_id
    PRIMARY KEY (MANDT, REQUEST_ITEM_UUID)
);

Learn More