_LISTEDSUBSTANCE

15 Fields

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

Fields (15)

KeyField CDS FieldsUsed in Views
KEY ActiveSubstanceUUID SubstanceUUID 1
KEY ListedSubstance EHSSubjectID,ListedSubstance 2
CASNumber CASNumber 9
CntntCASNumber CntntCASNumber 1
CntntECNumber CntntECNumber 1
CntntListedSubstance CntntListedSubstance 1
CntntListedSubstanceDfltName CntntListedSubstanceDfltName 1
CntntMolecularFormula CntntMolecularFormula 1
CustCASNumber CustCASNumber 1
CustECNumber CustECNumber 1
CustListedSubstance CustListedSubstance 1
CustListedSubstanceDfltName CustListedSubstanceDfltName 1
CustMolecularFormula CustMolecularFormula 1
ECNumber ECNumber 6
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,
    SUBSTANCEUUID,
    PRIMARY KEY (ACTIVESUBSTANCEUUID, LISTEDSUBSTANCE)
);

Learn More