I_CMPLRQVERSORGANICPRXD

CDS View
23 Fields 4 CDS Views

DG Organic Peroxides Classification List

I_CMPLRQVERSORGANICPRXD is a CDS View in S/4HANA. DG Organic Peroxides Classification List. It contains 23 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
P_CmplRqVersOrganicPrxd view from COMPOSITE
P_OrganicPeroxide view from COMPOSITE
P_SubstanceSubstListUnion view_entity union_all CONSUMPTION Substance Lists of Substances
R_CmplRqVersOrganicPrxdTP view_entity from TRANSACTIONAL Organic Peroxide Classific List CBR - TP

Fields (23)

KeyField CDS FieldsUsed in Views
KEY CmplRqVersOrganicPrxdUUID CmplRqVersOrganicPrxdUUID 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
DngrsGdsOrganicPrxdAddlInfoTxt DngrsGdsOrganicPrxdAddlInfoTxt 1
DngrsGdsOrganicPrxdName DngrsGdsOrganicPrxdName 1
DngrsGdsPositionOnSource DngrsGdsPositionOnSource 1
ListedSubstance ListedSubstance 1
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.

-- DG Organic Peroxides Classification List
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_CMPLRQVERSORGANICPRXD (
    CMPLRQVERSORGANICPRXDUUID,
    CMPLRQVERSUUID,
    DANGEROUSGOODSCONTROLTEMP,
    DANGEROUSGOODSCONTROLTEMPUNIT,
    DANGEROUSGOODSEMERGENCYTEMP,
    DANGEROUSGOODSEMGYTEMPUNIT,
    DNGRSGDSCONCNLOWRQTY,
    DNGRSGDSCONCNLOWRQTYOPTR,
    DNGRSGDSCONCNLOWRQTYUNIT,
    DNGRSGDSCONCNUPRQTY,
    DNGRSGDSCONCNUPRQTYOPTR,
    DNGRSGDSCONCNUPRQTYUNIT,
    DNGRSGDSHASCONCNLOWRQTY,
    DNGRSGDSHASCONCNUPRQTY,
    DNGRSGDSHASCONTROLTEMP,
    DNGRSGDSHASEMERGENCYTEMP,
    DNGRSGDSORGANICPRXDADDLINFOTXT,
    DNGRSGDSORGANICPRXDNAME,
    DNGRSGDSPOSITIONONSOURCE,
    LISTEDSUBSTANCE,
    PRODCMPLNCDNGRSGDSIDNNMBR,
    PRODCMPLNCDNGRSGDSIDNNMBRTYPE,
    SUBSTANCELISTUUID,
    PRIMARY KEY (CMPLRQVERSORGANICPRXDUUID)
);

Learn More