EHFNDV_CRR

14 Fields 2 CDS Views

EHFNDV_CRR is an SAP database table in S/4HANA. It contains 14 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_CmplRqRslt view from BASIC CRR - Compliance Requirement Result
P_CmplRqRsltPrelimCmplncStatus view from BASIC CRR Migration of Prelimninary Status

Fields (14)

KeyField CDS FieldsUsed in Views
KEY chemicalcustomermaterialuuid chemicalcustomermaterialuuid 1
KEY chmlcmplncinfouuid chmlcmplncinfouuid 1
KEY chmlsuplrmatluuid chmlsuplrmatluuid 1
KEY client client 1
KEY cmplrqrsltprocessingstatus cmplrqrsltprocessingstatus 1
KEY cmplrqrsltuuid cmplrqrsltuuid 1
KEY cmplrqversuuid cmplrqversuuid 1
KEY pcesscenariouuid pcesscenariouuid 1
KEY substanceuuid substanceuuid 1
chmlcompositiontype chmlcompositiontype 1
cmplrqrsltcalculatedstatus cmplrqrsltcalculatedstatus 1
cmplrqrsltmanualstatus cmplrqrsltmanualstatus 1
cmplrqrsltprelimcmplncsts cmplrqrsltprelimcmplncsts 1
releasedbyuser releasedbyuser 1

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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EHFNDV_CRR (
    CHEMICALCUSTOMERMATERIALUUID,
    CHMLCMPLNCINFOUUID,
    CHMLSUPLRMATLUUID,
    CLIENT,
    CMPLRQRSLTPROCESSINGSTATUS,
    CMPLRQRSLTUUID,
    CMPLRQVERSUUID,
    PCESSCENARIOUUID,
    SUBSTANCEUUID,
    CHMLCOMPOSITIONTYPE,
    CMPLRQRSLTCALCULATEDSTATUS,
    CMPLRQRSLTMANUALSTATUS,
    CMPLRQRSLTPRELIMCMPLNCSTS,
    RELEASEDBYUSER,
    PRIMARY KEY (CHEMICALCUSTOMERMATERIALUUID, CHMLCMPLNCINFOUUID, CHMLSUPLRMATLUUID, CLIENT, CMPLRQRSLTPROCESSINGSTATUS, CMPLRQRSLTUUID, CMPLRQVERSUUID, PCESSCENARIOUUID, SUBSTANCEUUID)
);

Learn More