EHFNDD_REQ_GHSSU

Transparent Table Control Table (SAP+Cust)

Compliance Requirement - GHS Substance

EHFNDD_REQ_GHSSU is an SAP database table in S/4HANA. Compliance Requirement - GHS Substance. It contains 8 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_CmplRqVersGHSSubstance view_entity from BASIC Compliance Requirement GHS Substance

Fields (8)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY bco_id ehfnd_crv_id Compliance Requirement
KEY bco_key ehfnd_bco_key BCO KEY
KEY db_key ehfnd_crv_ghs_substance_uuid
parent_key ehfnd_req_reglist_uuid Substance List
root_key ehfnd_crv_uuid Compl Req UUID
listedsubstance ehfnd_regbaslst_sub Listed Substance
ghsindexnumber ehfnd_ghs_index_number

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.

-- Compliance Requirement - GHS Substance
-- Category TRANSPARENT · Delivery class E
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EHFNDD_REQ_GHSSU (
    MANDT,            -- Client [mandt]
    BCO_ID,           -- Compliance Requirement [ehfnd_crv_id]
    BCO_KEY,          -- BCO KEY [ehfnd_bco_key]
    DB_KEY,           -- ehfnd_crv_ghs_substance_uuid
    PARENT_KEY,       -- Substance List [ehfnd_req_reglist_uuid]
    ROOT_KEY,         -- Compl Req UUID [ehfnd_crv_uuid]
    LISTEDSUBSTANCE,  -- Listed Substance [ehfnd_regbaslst_sub]
    GHSINDEXNUMBER,   -- ehfnd_ghs_index_number
    PRIMARY KEY (MANDT, BCO_ID, BCO_KEY, DB_KEY)
);