EHPMAD_SVT_SUBUP

Transparent Table Application Table
19 Fields 1 CDS Views

Substance User Profile

EHPMAD_SVT_SUBUP is an SAP database table in S/4HANA. Substance User Profile. It contains 19 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_SVTCalculationSubstance view_entity from BASIC SVT Substance Calculation

Fields (19)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY svtsubstanceuserprofileuuid EHPMA_SVT_SUB_USR_PROFILE_UUID SVT Substance User Profile UUID
creationutcdatetime ABP_CREATION_TSTMPL Created On
svtsubregulatoryprofileuuid EHPMA_SVT_SUB_REG_PROFILE_UUID Substance Regulatory Profile UUID
substanceisnotlisted EHPMA_SVT_SUBST_IS_NOT_LISTED Substance not listed
relevantsubstancelistuuid EHFND_REQ_REGLIST_UUID Substance List
relevantsubstancelist EHFND_REQ_REGLIST_ID Internal List ID
cmplrqrsltuuid EHFND_CRR_UUID Compliance Assessment UUID
crrlastchangedatetime ABP_LASTCHANGE_TSTMPL Changed On
sublastchangedatetime ABP_LASTCHANGE_TSTMPL Changed On
calculationstatus EHPMA_SVT_CALCULATION_STATUS SVT Calculation Status
polymercompositionuuid EHFND_CCI_CCMPS_UUID Chemical Composition
polymercompositionintid EHFND_SUB_PCMPS_INT_ID Internal Number
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
polymerisbsdonoecddef EHFND_SUB_POLYMER_OECD OECD Polymer
had_rlvnt_subst_lst_changed EHFND_BOOLEAN Select

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.

-- Substance User Profile
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EHPMAD_SVT_SUBUP (
    CLIENT,                       -- Client [MANDT]
    SVTSUBSTANCEUSERPROFILEUUID,  -- SVT Substance User Profile UUID [EHPMA_SVT_SUB_USR_PROFILE_UUID]
    CREATIONUTCDATETIME,          -- Created On [ABP_CREATION_TSTMPL]
    SVTSUBREGULATORYPROFILEUUID,  -- Substance Regulatory Profile UUID [EHPMA_SVT_SUB_REG_PROFILE_UUID]
    SUBSTANCEISNOTLISTED,         -- Substance not listed [EHPMA_SVT_SUBST_IS_NOT_LISTED]
    RELEVANTSUBSTANCELISTUUID,    -- Substance List [EHFND_REQ_REGLIST_UUID]
    RELEVANTSUBSTANCELIST,        -- Internal List ID [EHFND_REQ_REGLIST_ID]
    CMPLRQRSLTUUID,               -- Compliance Assessment UUID [EHFND_CRR_UUID]
    CRRLASTCHANGEDATETIME,        -- Changed On [ABP_LASTCHANGE_TSTMPL]
    SUBLASTCHANGEDATETIME,        -- Changed On [ABP_LASTCHANGE_TSTMPL]
    CALCULATIONSTATUS,            -- SVT Calculation Status [EHPMA_SVT_CALCULATION_STATUS]
    POLYMERCOMPOSITIONUUID,       -- Chemical Composition [EHFND_CCI_CCMPS_UUID]
    POLYMERCOMPOSITIONINTID,      -- Internal Number [EHFND_SUB_PCMPS_INT_ID]
    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]
    POLYMERISBSDONOECDDEF,        -- OECD Polymer [EHFND_SUB_POLYMER_OECD]
    HAD_RLVNT_SUBST_LST_CHANGED,  -- Select [EHFND_BOOLEAN]
    PRIMARY KEY (CLIENT, SVTSUBSTANCEUSERPROFILEUUID)
);

Learn More