EHFNDW_SRDCMPP

Transparent Table Application Table
12 Fields 1 CDS Views

I_PCSFTYPROPERTYTP I_PCSFTYDCMPSTNPRODTP

EHFNDW_SRDCMPP is an SAP database table in S/4HANA. I_PCSFTYPROPERTYTP I_PCSFTYDCMPSTNPRODTP. It contains 12 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_PCSftyDcmpstnProdDraft view from BASIC Decomposition Products Draft Data

Fields (12)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY pcsftydcmpstnproduuid ehfnd_sr_dcmps_prod_uuid Decomposition Product
pcsftyprptyuuid ehfnd_sr_uuid Safety-Related Property
pcsftydcmpstnprodlistuuid ehfnd_sr_dcmps_prod_list_uuid Decomposition Products List Property
creationutcdatetime ehfnd_bo_crea_date_time Created On
createdbyuser ehfnd_bo_crea_uname Created By
lastchangeutcdatetime ehfnd_bo_lchg_date_time Last Changed On
lastchangedbyuser ehfnd_bo_lchg_uname Last Changed By
pcprptysequence ehfnd_property_sequence Sequence
substanceuuid ehfnd_sub_uuid Substance
activeuuid /bobf/uuid Key
hasactiveentity sdraft_has_active Has active

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.

-- I_PCSFTYPROPERTYTP I_PCSFTYDCMPSTNPRODTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EHFNDW_SRDCMPP (
    MANDT,                      -- Client [mandt]
    PCSFTYDCMPSTNPRODUUID,      -- Decomposition Product [ehfnd_sr_dcmps_prod_uuid]
    PCSFTYPRPTYUUID,            -- Safety-Related Property [ehfnd_sr_uuid]
    PCSFTYDCMPSTNPRODLISTUUID,  -- Decomposition Products List Property [ehfnd_sr_dcmps_prod_list_uuid]
    CREATIONUTCDATETIME,        -- Created On [ehfnd_bo_crea_date_time]
    CREATEDBYUSER,              -- Created By [ehfnd_bo_crea_uname]
    LASTCHANGEUTCDATETIME,      -- Last Changed On [ehfnd_bo_lchg_date_time]
    LASTCHANGEDBYUSER,          -- Last Changed By [ehfnd_bo_lchg_uname]
    PCPRPTYSEQUENCE,            -- Sequence [ehfnd_property_sequence]
    SUBSTANCEUUID,              -- Substance [ehfnd_sub_uuid]
    ACTIVEUUID,                 -- Key [/bobf/uuid]
    HASACTIVEENTITY,            -- Has active [sdraft_has_active]
    PRIMARY KEY (MANDT, PCSFTYDCMPSTNPRODUUID)
);

Learn More