EHSDSD_CNTCT_ADR

Transparent Table Application Table
10 Fields 1 CDS Views

Safety Data Sheet Contact Address Assignment

EHSDSD_CNTCT_ADR is an SAP database table in S/4HANA. Safety Data Sheet Contact Address Assignment. It contains 10 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_SftyDataShtCntctAddr view_entity from BASIC SDS Contact Address

Fields (10)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY uuid EHSDS_CNTCT_ADDR_UUID SDS Contact Address
contact_uuid EHSDS_CNTCT_UUID SDS Contact
creationdatetime /BOBF/CREATIONDATETIME Created On
createdbyuser /BOBF/CREATEDBYUSER Created By
lastchangedatetime /BOBF/LASTCHANGEDATETIME Last Changed On
lastchangedbyuser /BOBF/LASTCHANGEDBYUSER Last Changed By
addr_type EHSDS_CNTCT_ADDR_TYPE Address Type
business_partner BU_PARTNER Busn. Partner
addr_id ADRNR Address

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.

-- Safety Data Sheet Contact Address Assignment
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EHSDSD_CNTCT_ADR (
    MANDT,               -- Client [MANDT]
    UUID,                -- SDS Contact Address [EHSDS_CNTCT_ADDR_UUID]
    CONTACT_UUID,        -- SDS Contact [EHSDS_CNTCT_UUID]
    CREATIONDATETIME,    -- Created On [/BOBF/CREATIONDATETIME]
    CREATEDBYUSER,       -- Created By [/BOBF/CREATEDBYUSER]
    LASTCHANGEDATETIME,  -- Last Changed On [/BOBF/LASTCHANGEDATETIME]
    LASTCHANGEDBYUSER,   -- Last Changed By [/BOBF/LASTCHANGEDBYUSER]
    ADDR_TYPE,           -- Address Type [EHSDS_CNTCT_ADDR_TYPE]
    BUSINESS_PARTNER,    -- Busn. Partner [BU_PARTNER]
    ADDR_ID,             -- Address [ADRNR]
    PRIMARY KEY (MANDT, UUID)
);

Learn More