EHFNDV_CCA_PRPTY

12 Fields 1 CDS Views

Generated Table for View

EHFNDV_CCA_PRPTY is an SAP database table in S/4HANA. Generated Table for View. It contains 12 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_ChmlCmplncPrptyAssgmt view from BASIC Chem Compliance addtl Property assgmt

Fields (12)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY chmlcmplncprptyassgmtuuid EHFND_CCI_PRPTYAS_UUID CCI Property Assignm
chmlcmplncaddlprptyuuid EHFND_CCA_ADLPR_UUID Chml Cmplnc Adl Prpt
creationutcdatetime TIMESTAMPL Time Stamp
createdbyuser UNAME User Name
lastchangeutcdatetime TIMESTAMPL Time Stamp
lastchangedbyuser UNAME User Name
ehschemicalphysicalpropuuid EHFND_CCI_PRPTY_UUID CCI Property
ehschemicalphysicalunituuid EHFND_CCI_PRPTY_UNIT_UUID CCI Property Unit
chmlcmplncprptyvalue EHFND_CCI_PRPTY_VALUE Property Value
ehschemicalphysicalprptyunit EHFND_UNIT_CODE Unit of Measurement
chmlcmplncprptycmnttext EHFND_NAME Name

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.

-- Generated Table for View
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EHFNDV_CCA_PRPTY (
    CLIENT,                        -- Client [MANDT]
    CHMLCMPLNCPRPTYASSGMTUUID,     -- CCI Property Assignm [EHFND_CCI_PRPTYAS_UUID]
    CHMLCMPLNCADDLPRPTYUUID,       -- Chml Cmplnc Adl Prpt [EHFND_CCA_ADLPR_UUID]
    CREATIONUTCDATETIME,           -- Time Stamp [TIMESTAMPL]
    CREATEDBYUSER,                 -- User Name [UNAME]
    LASTCHANGEUTCDATETIME,         -- Time Stamp [TIMESTAMPL]
    LASTCHANGEDBYUSER,             -- User Name [UNAME]
    EHSCHEMICALPHYSICALPROPUUID,   -- CCI Property [EHFND_CCI_PRPTY_UUID]
    EHSCHEMICALPHYSICALUNITUUID,   -- CCI Property Unit [EHFND_CCI_PRPTY_UNIT_UUID]
    CHMLCMPLNCPRPTYVALUE,          -- Property Value [EHFND_CCI_PRPTY_VALUE]
    EHSCHEMICALPHYSICALPRPTYUNIT,  -- Unit of Measurement [EHFND_UNIT_CODE]
    CHMLCMPLNCPRPTYCMNTTEXT,       -- Name [EHFND_NAME]
    PRIMARY KEY (CLIENT, CHMLCMPLNCPRPTYASSGMTUUID)
);

Learn More