EHPMAV_CCI_ASSMT

Generated Table for View

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

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_CmplRqRsltChmlCmplncAssmtSts view from BASIC Chemical Compliance Information Assessment Details

Fields (8)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY cmplrqrsltchmlcmplncassmtuuid EHPMA_CCI_ASSMT_UUID Assessment Detail
cmplrqrsltuuid EHFND_CRR_UUID Compliance Assessment UUID
cmplrqrsltchmlcmplncinfouuid EHFND_CRR_UUID Compliance Assessment UUID
cmplrqrsltprocessingstatus EHFND_CRR_PROC_STATUS Processing Status
cmplrqrsltreldcmplncsts EHFND_CRR_COMP_STAT_RMI Raw Material Issue Compliance Status
chmlcompuuid EHFND_CCI_CCOMP_UUID Chemical Component
chmlcmplncinfouuid EHFND_CCI_UUID Chemical Compliance Information

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 EHPMAV_CCI_ASSMT (
    CLIENT,                         -- Client [MANDT]
    CMPLRQRSLTCHMLCMPLNCASSMTUUID,  -- Assessment Detail [EHPMA_CCI_ASSMT_UUID]
    CMPLRQRSLTUUID,                 -- Compliance Assessment UUID [EHFND_CRR_UUID]
    CMPLRQRSLTCHMLCMPLNCINFOUUID,   -- Compliance Assessment UUID [EHFND_CRR_UUID]
    CMPLRQRSLTPROCESSINGSTATUS,     -- Processing Status [EHFND_CRR_PROC_STATUS]
    CMPLRQRSLTRELDCMPLNCSTS,        -- Raw Material Issue Compliance Status [EHFND_CRR_COMP_STAT_RMI]
    CHMLCOMPUUID,                   -- Chemical Component [EHFND_CCI_CCOMP_UUID]
    CHMLCMPLNCINFOUUID,             -- Chemical Compliance Information [EHFND_CCI_UUID]
    PRIMARY KEY (CLIENT, CMPLRQRSLTCHMLCMPLNCASSMTUUID)
);