EHPMAD_SVT_CCIUP

Transparent Table Application Table

SVT CCI User Profile

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

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_SVTCalcChmlCmplncInfo view from BASIC SVT Chemical Compliance Info calculation

Fields (13)

KeyField Data ElementDescription DomainTypeLength
KEY client mandt Client
KEY svtcciuserprofileuuid ehpma_svt_cci_usr_profile_uuid SVT CCI User Profile UUID
creationutcdatetime abp_creation_tstmpl Created On
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 abp_lastchange_tstmpl Changed On
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,                       -- Client [mandt]
    SVTCCIUSERPROFILEUUID,        -- SVT CCI User Profile UUID [ehpma_svt_cci_usr_profile_uuid]
    CREATIONUTCDATETIME,          -- Created On [abp_creation_tstmpl]
    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,       -- Changed On [abp_lastchange_tstmpl]
    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)
);