I_SUBSTANCETP

CDS View
13 Fields 8 CDS Views

Substance

I_SUBSTANCETP is a CDS View in S/4HANA. Substance. It contains 13 fields. 8 CDS views read from this table.

CDS Views using this table (8)

ViewTypeJoinVDMDescription
C_ChmlCmpstnSubstanceVH view from CONSUMPTION Value Help for Substance in Composition
C_MatlBasedProducedSubstanceVH view from CONSUMPTION Value Help for Produced Substances for Matl Bsd Composition
C_MatlBasedReplacedSubstanceVH view from CONSUMPTION Value Help for Replaced Substances for Matl Bsd Composition
C_PCSftyDcmpstnProdSubstanceVH view from CONSUMPTION Decomposition Product Substance ValueHelp
C_ProdCmplncServiceReqSubst view from CONSUMPTION PC Service Requests Private Substance
C_SubstanceCmplRqRslt view from CONSUMPTION Compliance Assessments Overview for Substance
C_SubstanceQryTP view from CONSUMPTION Manage Substances Compliance
C_SubstanceVH view from CONSUMPTION Substance Value Help

Fields (13)

KeyField CDS FieldsUsed in Views
KEY SubstanceUUID SubstanceUUID 7
ActiveSubstanceUUID ActiveSubstanceUUID 1
CompanySubstanceName CompanySubstanceName 6
CreatedByUser CreatedByUser 1
CreationUTCDateTime CreationUTCDateTime 1
LastChangedByUser LastChangedByUser 1
LastChangeUTCDateTime LastChangeUTCDateTime 1
ListedSubstanceUUID ListedSubstanceUUID 6
PolymerIsBsdOnOECDDef PolymerIsBsdOnOECDDef 1
ResponsibleUnit ResponsibleUnit 6
Specification Specification 2
SubstanceInternalName SubstanceInternalName 7
SubstanceName SubstanceName 7

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
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_SUBSTANCETP (
    SUBSTANCEUUID,
    ACTIVESUBSTANCEUUID,
    COMPANYSUBSTANCENAME,
    CREATEDBYUSER,
    CREATIONUTCDATETIME,
    LASTCHANGEDBYUSER,
    LASTCHANGEUTCDATETIME,
    LISTEDSUBSTANCEUUID,
    POLYMERISBSDONOECDDEF,
    RESPONSIBLEUNIT,
    SPECIFICATION,
    SUBSTANCEINTERNALNAME,
    SUBSTANCENAME,
    PRIMARY KEY (SUBSTANCEUUID)
);

Learn More