EHFNDV_CRR

28 Fields 2 CDS Views

Generated Table for View

EHFNDV_CRR is an SAP database table in S/4HANA. Generated Table for View. It contains 28 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

Fields (28)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY cmplrqrsltuuid EHFND_CRR_UUID Compliance Assessment UUID
creationdatetime TIMESTAMPL Time Stamp
createdbyuser UNAME User Name
lastchangedatetime TIMESTAMPL Time Stamp
lastchangedbyuser UNAME User Name
chmlcmplncinfouuid EHFND_CCI_UUID Chemical Compliance Information
chmlsuplrmatluuid EHFND_CSM_UUID Supplier Raw Material
substanceuuid EHFND_SUB_UUID Substance
cmplrqversuuid EHFND_CRV_UUID Compl Req UUID
compliancerequirement EHFND_REQ_IDENTIFIER Compliance Requirement
cmplrqrsltprocessingstatus EHFND_CRR_PROC_STATUS Processing Status
processor EHFND_CRR_PROCESSING_USER_BP Processor
releasedbyuser EHFND_CRR_RELEASED_BY_USER_BP Released By
validitystartdatetime EHFND_VALID_FROM_TSTMP Valid From
validityenddatetime EHFND_VALID_TO_TSTMP Valid To
cmplrqrsltreldcmplncsts EHFND_CRR_RELSTAT Released Compliance Status
cmplrqrsltcalculatedstatus EHFND_CRR_CALC_STAT Calculated Compliance Status
cmplrqrsltmanualstatus EHFND_CRR_MAN_STAT Manually Set Compliance Status
cmplrqrsltstatusremark EHFND_CRR_STAT_REMARK Remarks
chmlcompositiontype EHFND_CCI_CCMPS_TYPE Legal Area
materialissold EHFND_CCI_IS_SOLD Is Sold
materialistransported EHFND_CCI_IS_TRANSPORTED Is Transported
materialissourced EHFND_CCI_IS_SOURCED Is Purchased
materialisproduced EHFND_CCI_IS_PRODUCED Is Produced
cmplrqrsltprelimcmplncsts EHFND_CRR_PRELIM_COMP_STAT Preliminary Compliance Status
chemicalcustomermaterialuuid EHFND_CCM_UUID Customer Material
pcesscenariouuid EHFND_ES_SCENARIO_UUID Scenario UUID

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_CRR (
    CLIENT,                        -- Client [MANDT]
    CMPLRQRSLTUUID,                -- Compliance Assessment UUID [EHFND_CRR_UUID]
    CREATIONDATETIME,              -- Time Stamp [TIMESTAMPL]
    CREATEDBYUSER,                 -- User Name [UNAME]
    LASTCHANGEDATETIME,            -- Time Stamp [TIMESTAMPL]
    LASTCHANGEDBYUSER,             -- User Name [UNAME]
    CHMLCMPLNCINFOUUID,            -- Chemical Compliance Information [EHFND_CCI_UUID]
    CHMLSUPLRMATLUUID,             -- Supplier Raw Material [EHFND_CSM_UUID]
    SUBSTANCEUUID,                 -- Substance [EHFND_SUB_UUID]
    CMPLRQVERSUUID,                -- Compl Req UUID [EHFND_CRV_UUID]
    COMPLIANCEREQUIREMENT,         -- Compliance Requirement [EHFND_REQ_IDENTIFIER]
    CMPLRQRSLTPROCESSINGSTATUS,    -- Processing Status [EHFND_CRR_PROC_STATUS]
    PROCESSOR,                     -- Processor [EHFND_CRR_PROCESSING_USER_BP]
    RELEASEDBYUSER,                -- Released By [EHFND_CRR_RELEASED_BY_USER_BP]
    VALIDITYSTARTDATETIME,         -- Valid From [EHFND_VALID_FROM_TSTMP]
    VALIDITYENDDATETIME,           -- Valid To [EHFND_VALID_TO_TSTMP]
    CMPLRQRSLTRELDCMPLNCSTS,       -- Released Compliance Status [EHFND_CRR_RELSTAT]
    CMPLRQRSLTCALCULATEDSTATUS,    -- Calculated Compliance Status [EHFND_CRR_CALC_STAT]
    CMPLRQRSLTMANUALSTATUS,        -- Manually Set Compliance Status [EHFND_CRR_MAN_STAT]
    CMPLRQRSLTSTATUSREMARK,        -- Remarks [EHFND_CRR_STAT_REMARK]
    CHMLCOMPOSITIONTYPE,           -- Legal Area [EHFND_CCI_CCMPS_TYPE]
    MATERIALISSOLD,                -- Is Sold [EHFND_CCI_IS_SOLD]
    MATERIALISTRANSPORTED,         -- Is Transported [EHFND_CCI_IS_TRANSPORTED]
    MATERIALISSOURCED,             -- Is Purchased [EHFND_CCI_IS_SOURCED]
    MATERIALISPRODUCED,            -- Is Produced [EHFND_CCI_IS_PRODUCED]
    CMPLRQRSLTPRELIMCMPLNCSTS,     -- Preliminary Compliance Status [EHFND_CRR_PRELIM_COMP_STAT]
    CHEMICALCUSTOMERMATERIALUUID,  -- Customer Material [EHFND_CCM_UUID]
    PCESSCENARIOUUID,              -- Scenario UUID [EHFND_ES_SCENARIO_UUID]
    PRIMARY KEY (CLIENT, CMPLRQRSLTUUID)
);

Learn More