EHFNDW_SR

Transparent Table Application Table
25 Fields 1 CDS Views

I_PCSFTYPROPERTYTP I_PCSFTYPROPERTYTP

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

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_PCSftyPropertyDraft view from BASIC Safety-Related Properties - Draft

Fields (25)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY pcsftyprptyuuid EHFND_SR_UUID Safety-Related Property
activepcsftyprptyuuid EHFND_SR_UUID Safety-Related Property
chmlcmplncinfouuid EHFND_CCI_UUID Chemical Compliance Information
substanceuuid EHFND_SUB_UUID Substance
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
pcprptyprocgsts EHFND_PROPERTY_STATUS Processing Status
releasedbyuser EHFND_PROPERTY_RELEASED_BY Released By
validitystartdatetime EHFND_VALID_FROM_TSTMP Valid From
validityenddatetime EHFND_VALID_TO_TSTMP Valid To
pcsftyhzdscmbtnnodatarsnuuid EHFND_SR_HZDCMB_NDRSN_PH_UUID Reason for No Data
pcsftyhzdscmbtnnotetext EHFND_NOTE Comments
pcsftysubstavoidnodatarsnuuid EHFND_SR_SUBSTAV_NDRSN_PH_UUID Reason for No Data
pcsftysubsttoavoidnotetext EHFND_NOTE Comments
pcsftydcmpstnprodnodatarsnuuid EHFND_SR_DCMPS_NDRSN_PH_UUID Reason for No Data
activeuuid /BOBF/UUID Key
hasactiveentity SDRAFT_HAS_ACTIVE Has active
draftentitycreationdatetime SDRAFT_CREATED_AT Draft Created On
draftentitylastchangedatetime SDRAFT_LAST_CHANGED_AT Draft Last Changed On
draftadministrativedatauuid SDRAFT_ADMIN_UUID Draft Adminv Data ID
draftentityconsistencystatus SDRAFT_CONSISTENCY_STATUS Consistency Status
draftentityoperationcode SDRAFT_OPERATION_CODE Draft - Operation Code

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_PCSFTYPROPERTYTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EHFNDW_SR (
    MANDT,                           -- Client [MANDT]
    PCSFTYPRPTYUUID,                 -- Safety-Related Property [EHFND_SR_UUID]
    ACTIVEPCSFTYPRPTYUUID,           -- Safety-Related Property [EHFND_SR_UUID]
    CHMLCMPLNCINFOUUID,              -- Chemical Compliance Information [EHFND_CCI_UUID]
    SUBSTANCEUUID,                   -- Substance [EHFND_SUB_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]
    PCPRPTYPROCGSTS,                 -- Processing Status [EHFND_PROPERTY_STATUS]
    RELEASEDBYUSER,                  -- Released By [EHFND_PROPERTY_RELEASED_BY]
    VALIDITYSTARTDATETIME,           -- Valid From [EHFND_VALID_FROM_TSTMP]
    VALIDITYENDDATETIME,             -- Valid To [EHFND_VALID_TO_TSTMP]
    PCSFTYHZDSCMBTNNODATARSNUUID,    -- Reason for No Data [EHFND_SR_HZDCMB_NDRSN_PH_UUID]
    PCSFTYHZDSCMBTNNOTETEXT,         -- Comments [EHFND_NOTE]
    PCSFTYSUBSTAVOIDNODATARSNUUID,   -- Reason for No Data [EHFND_SR_SUBSTAV_NDRSN_PH_UUID]
    PCSFTYSUBSTTOAVOIDNOTETEXT,      -- Comments [EHFND_NOTE]
    PCSFTYDCMPSTNPRODNODATARSNUUID,  -- Reason for No Data [EHFND_SR_DCMPS_NDRSN_PH_UUID]
    ACTIVEUUID,                      -- Key [/BOBF/UUID]
    HASACTIVEENTITY,                 -- Has active [SDRAFT_HAS_ACTIVE]
    DRAFTENTITYCREATIONDATETIME,     -- Draft Created On [SDRAFT_CREATED_AT]
    DRAFTENTITYLASTCHANGEDATETIME,   -- Draft Last Changed On [SDRAFT_LAST_CHANGED_AT]
    DRAFTADMINISTRATIVEDATAUUID,     -- Draft Adminv Data ID [SDRAFT_ADMIN_UUID]
    DRAFTENTITYCONSISTENCYSTATUS,    -- Consistency Status [SDRAFT_CONSISTENCY_STATUS]
    DRAFTENTITYOPERATIONCODE,        -- Draft - Operation Code [SDRAFT_OPERATION_CODE]
    PRIMARY KEY (MANDT, PCSFTYPRPTYUUID)
);

Learn More