I_CMPLRQVERSSELFREACTVSUBST

CDS View
23 Fields 4 CDS Views

Selfreactive Substances Classif List

I_CMPLRQVERSSELFREACTVSUBST is a CDS View in S/4HANA. Selfreactive Substances Classif List. It contains 23 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
P_CmplRqVersSelfReactvSubst view from COMPOSITE Selfreactive Substances Classif List
P_SelfReactiveSubstance view from COMPOSITE All Self Reactive Substances linked with (company) subst
P_SubstanceSubstListUnion view_entity union_all CONSUMPTION Substance Lists of Substances
R_CmplRqVersSelfReactvSubstTP view_entity from TRANSACTIONAL SR Substance Classific for CBR - TP

Fields (23)

KeyField CDS FieldsUsed in Views
KEY CmplRqVersSelfReactvSubstUUID CmplRqVersSelfReactvSubstUUID 1
CmplRqVersUUID CmplRqVersUUID 2
DangerousGoodsControlTemp DangerousGoodsControlTemp 1
DangerousGoodsControlTempUnit DangerousGoodsControlTempUnit 1
DangerousGoodsEmergencyTemp DangerousGoodsEmergencyTemp 1
DangerousGoodsEmgyTempUnit DangerousGoodsEmgyTempUnit 1
DngrsGdsConcnLowrQty DngrsGdsConcnLowrQty 1
DngrsGdsConcnLowrQtyOptr DngrsGdsConcnLowrQtyOptr 1
DngrsGdsConcnLowrQtyUnit DngrsGdsConcnLowrQtyUnit 1
DngrsGdsConcnUprQty DngrsGdsConcnUprQty 1
DngrsGdsConcnUprQtyOptr DngrsGdsConcnUprQtyOptr 1
DngrsGdsConcnUprQtyUnit DngrsGdsConcnUprQtyUnit 1
DngrsGdsHasConcnLowrQty DngrsGdsHasConcnLowrQty 1
DngrsGdsHasConcnUprQty DngrsGdsHasConcnUprQty 1
DngrsGdsHasControlTemp DngrsGdsHasControlTemp 1
DngrsGdsHasEmergencyTemp DngrsGdsHasEmergencyTemp 1
DngrsGdsPositionOnSource DngrsGdsPositionOnSource 1
DngrsGdsSelfReactvAddlInfoTxt DngrsGdsSelfReactvAddlInfoTxt 1
DngrsGdsSelfReactvName DngrsGdsSelfReactvName 1
ListedSubstance ListedSubstance 2
ProdCmplncDngrsGdsIdnNmbr ProdCmplncDngrsGdsIdnNmbr 1
ProdCmplncDngrsGdsIdnNmbrType ProdCmplncDngrsGdsIdnNmbrType 1
SubstanceListUUID SubstanceListUUID 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.

-- Selfreactive Substances Classif List
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_CMPLRQVERSSELFREACTVSUBST (
    CMPLRQVERSSELFREACTVSUBSTUUID,
    CMPLRQVERSUUID,
    DANGEROUSGOODSCONTROLTEMP,
    DANGEROUSGOODSCONTROLTEMPUNIT,
    DANGEROUSGOODSEMERGENCYTEMP,
    DANGEROUSGOODSEMGYTEMPUNIT,
    DNGRSGDSCONCNLOWRQTY,
    DNGRSGDSCONCNLOWRQTYOPTR,
    DNGRSGDSCONCNLOWRQTYUNIT,
    DNGRSGDSCONCNUPRQTY,
    DNGRSGDSCONCNUPRQTYOPTR,
    DNGRSGDSCONCNUPRQTYUNIT,
    DNGRSGDSHASCONCNLOWRQTY,
    DNGRSGDSHASCONCNUPRQTY,
    DNGRSGDSHASCONTROLTEMP,
    DNGRSGDSHASEMERGENCYTEMP,
    DNGRSGDSPOSITIONONSOURCE,
    DNGRSGDSSELFREACTVADDLINFOTXT,
    DNGRSGDSSELFREACTVNAME,
    LISTEDSUBSTANCE,
    PRODCMPLNCDNGRSGDSIDNNMBR,
    PRODCMPLNCDNGRSGDSIDNNMBRTYPE,
    SUBSTANCELISTUUID,
    PRIMARY KEY (CMPLRQVERSSELFREACTVSUBSTUUID)
);

Learn More