EHPMAD_SVT_CCIUP

Transparent Table Application Table
13 Fields 2 CDS Views

SVT CCI User Profile

EHPMAD_SVT_CCIUP is an SAP database table in S/4HANA. SVT CCI User Profile. It contains 13 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_SVTCalcChmlCmplncInfo view from BASIC SVT Chemical Compliance Info calculation
I_SVTChmlCmplncInfoProfile view from BASIC SVT Chemical Compliance Info Profile for a regulation

Fields (13)

KeyField Data ElementDescription DomainTypeLength
KEY client abap.clnt
KEY svtcciuserprofileuuid EHPMA_SVT_CCI_USR_PROFILE_UUID SVT CCI User Profile UUID
creationutcdatetime TIMESTAMPL Time Stamp
svtcciregulatoryprofileuuid EHPMA_SVT_CCI_REG_PROFILE_UUID CCI Regulatory Profile UUID
chmlcompositiontype EHFND_CCI_CCMPS_TYPE Legal Area
chmlcompositionuuid EHFND_CCI_CCMPS_UUID Chemical Composition
cmplrqrsltuuid EHFND_CRR_UUID Compliance Assessment UUID
calculation_status EHPMA_SVT_CALCULATION_STATUS SVT Calculation Status
ccilastchangeddatetime TIMESTAMPL Time Stamp
validitystartdatetime EHFND_VALID_FROM_TSTMP Valid From
validityenddatetime EHFND_VALID_TO_TSTMP Valid To
prodcmplnceventuuid EHFND_PCE_UUID Product Compliance Event
substvolretrackinguuid EHPMA_SVT_RETRACKING_UUID Retracking 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.

-- SVT CCI User Profile
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EHPMAD_SVT_CCIUP (
    CLIENT,                       -- abap.clnt
    SVTCCIUSERPROFILEUUID,        -- SVT CCI User Profile UUID [EHPMA_SVT_CCI_USR_PROFILE_UUID]
    CREATIONUTCDATETIME,          -- Time Stamp [TIMESTAMPL]
    SVTCCIREGULATORYPROFILEUUID,  -- CCI Regulatory Profile UUID [EHPMA_SVT_CCI_REG_PROFILE_UUID]
    CHMLCOMPOSITIONTYPE,          -- Legal Area [EHFND_CCI_CCMPS_TYPE]
    CHMLCOMPOSITIONUUID,          -- Chemical Composition [EHFND_CCI_CCMPS_UUID]
    CMPLRQRSLTUUID,               -- Compliance Assessment UUID [EHFND_CRR_UUID]
    CALCULATION_STATUS,           -- SVT Calculation Status [EHPMA_SVT_CALCULATION_STATUS]
    CCILASTCHANGEDDATETIME,       -- Time Stamp [TIMESTAMPL]
    VALIDITYSTARTDATETIME,        -- Valid From [EHFND_VALID_FROM_TSTMP]
    VALIDITYENDDATETIME,          -- Valid To [EHFND_VALID_TO_TSTMP]
    PRODCMPLNCEVENTUUID,          -- Product Compliance Event [EHFND_PCE_UUID]
    SUBSTVOLRETRACKINGUUID,       -- Retracking UUID [EHPMA_SVT_RETRACKING_UUID]
    PRIMARY KEY (CLIENT, SVTCCIUSERPROFILEUUID)
);

Learn More