I_SUBSTANCE

CDS View
13 Fields 29 CDS Views

Substance

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

CDS Views using this table (29)

ViewTypeJoinVDMDescription
C_EHSCompanySubstanceValueHelp view_entity from CONSUMPTION Company Substance
C_PCStRctHzDePrdsListVH view_entity from CONSUMPTION Decomposition Product
C_PlmrCompositionVH view from CONSUMPTION Polymer Composition
C_PlmrCompositionVH view union_all CONSUMPTION Polymer Composition
C_SubstanceTrdScrtTxtWthFllbck view from CONSUMPTION Trade Secret Name with Fallback
C_UpaDaGdsClfnTechNameAll view from CONSUMPTION Technical Names - All Company Substances
I_CmplRqVersGrpAssgmtAnlyts2 view inner COMPOSITE Group Assignment 2 for Analytics
I_PCPrptyIntNmbrExist view from COMPOSITE Existing Check of Internal Number Used in Migration Object
I_PCPrptyIntNmbrExist view union COMPOSITE Existing Check of Internal Number Used in Migration Object
I_SubstanceEnhanced view from COMPOSITE Substance Enhanced with Substance Name Logic
I_SubstanceLstdSubst view from COMPOSITE Company Substance and related listed sub
I_SubstanceLstdSubstAnlyts1 view from COMPOSITE Company Substance and Listed Substance
I_SubstanceTP view from TRANSACTIONAL Substance
I_SubstNameFallbackLanguage view_entity from COMPOSITE Substance name with a fallback language
P_ListSubstGrpMemberFBAllLang view_entity inner COMPOSITE
P_NameOnGrpMbrListRptblQty view_entity inner COMPOSITE
P_NameOnListRptblQtyInternal view_entity from COMPOSITE
P_SubstanceAssgdPCEctx view from CONSUMPTION Assoc. Ecological Information Property
P_SubstanceAssgdPCPhys view from CONSUMPTION Assoc. Physical Chemical Property
P_SubstanceAssgdPCSfty view from CONSUMPTION Assoc. Safety-Related Property
P_SubstanceAssgdPCTx view from CONSUMPTION Assoc. Toxicological Property
P_SubstanceLstdSubstUnion view_entity from CONSUMPTION Substance with its (Sub-)Root LiSus
P_SubstanceMigration view from COMPOSITE
P_SubstanceMigration view union COMPOSITE
P_SubstanceNameText view from COMPOSITE Substance Names with Listed Substance Names
P_SubstancesInAllLanguages view from COMPOSITE
P_US_AllRptblQtyGrpItemSubSAP view_entity inner COMPOSITE
P_US_SubstNameFllbckRptblQty view_entity from COMPOSITE
R_CompanySubstanceTP view_entity from TRANSACTIONAL Company Substance - TP

Fields (13)

KeyField CDS FieldsUsed in Views
KEY ListedSubstanceUUID ActiveSubstanceUUID,ListedSubstanceUUID 4
KEY SubstanceUUID ActiveSubstanceUUID,SubstanceUUID 9
_ListedSubstance _ListedSubstance 2
_SubstanceText _SubstanceText 1
CreatedByUser CreatedByUser 1
LastChangedByUser LastChangedByUser 1
LastChangeUTCDateTime LastChangeUTCDateTime 1
mandt mandt 1
PolymerIsBsdOnOECDDef PolymerIsBsdOnOECDDef 1
ResponsibleUnit ResponsibleUnit 11
Specification Specification 1
SpecificationInternalID SpecificationInternalID 1
SubstanceInternalName SubstanceInternalName 3

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_SUBSTANCE (
    LISTEDSUBSTANCEUUID,
    SUBSTANCEUUID,
    _LISTEDSUBSTANCE,
    _SUBSTANCETEXT,
    CREATEDBYUSER,
    LASTCHANGEDBYUSER,
    LASTCHANGEUTCDATETIME,
    MANDT,
    POLYMERISBSDONOECDDEF,
    RESPONSIBLEUNIT,
    SPECIFICATION,
    SPECIFICATIONINTERNALID,
    SUBSTANCEINTERNALNAME,
    PRIMARY KEY (LISTEDSUBSTANCEUUID, SUBSTANCEUUID)
);

Learn More