_LISTEDSUBSTANCE

16 Fields

_LISTEDSUBSTANCE is an SAP database table in S/4HANA. It contains 16 fields.

Fields (16)

KeyField CDS FieldsUsed in Views
KEY ActiveSubstanceUUID SubstanceUUID 1
KEY ListedSubstance EHSSubjectID,ListedSubstance 2
CASNumber CASNumber 7
CntntCASNumber CntntCASNumber 2
CntntECNumber CntntECNumber 2
CntntListedSubstance CntntListedSubstance 2
CntntListedSubstanceDfltName CntntListedSubstanceDfltName 2
CntntMolecularFormula CntntMolecularFormula 2
CustCASNumber CustCASNumber 2
CustECNumber CustECNumber 2
CustListedSubstance CustListedSubstance 2
CustListedSubstanceDfltName CustListedSubstanceDfltName 2
CustMolecularFormula CustMolecularFormula 2
ECNumber ECNumber 4
ListedSubstanceUUID ListedSubstanceUUID 1
SubstanceUUID SubstanceUUID 2

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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE _LISTEDSUBSTANCE (
    ACTIVESUBSTANCEUUID,
    LISTEDSUBSTANCE,
    CASNUMBER,
    CNTNTCASNUMBER,
    CNTNTECNUMBER,
    CNTNTLISTEDSUBSTANCE,
    CNTNTLISTEDSUBSTANCEDFLTNAME,
    CNTNTMOLECULARFORMULA,
    CUSTCASNUMBER,
    CUSTECNUMBER,
    CUSTLISTEDSUBSTANCE,
    CUSTLISTEDSUBSTANCEDFLTNAME,
    CUSTMOLECULARFORMULA,
    ECNUMBER,
    LISTEDSUBSTANCEUUID,
    SUBSTANCEUUID,
    PRIMARY KEY (ACTIVESUBSTANCEUUID, LISTEDSUBSTANCE)
);

Learn More