I_CMPLRQRSLTDNGRSGDSBSCDETS

CDS View
39 Fields 8 CDS Views

Basic Classification Details

I_CMPLRQRSLTDNGRSGDSBSCDETS is a CDS View in S/4HANA. Basic Classification Details. It contains 39 fields. 8 CDS views read from this table.

CDS Views using this table (8)

ViewTypeJoinVDMDescription
C_AnlytlCmpstnMarnPlltntIMDG view from CONSUMPTION Marine Pollutants for Analytical Composition for IMDG
C_CA_AnlytlCmpstnMarnPlltntTDG view from CONSUMPTION Marine Pollutants for Analytical Composition for TDG
C_US_AnlytlCmpstnMarnPlltntCFR view from CONSUMPTION Marine Pollutants for Analytical Composition for 49 CFR
C_US_AnlytlCmpstnRptblQtyCFR view from CONSUMPTION Reportable Qunatity from Analytical Composition for 49 CFR
I_CmplRqRsltDngrsGdsBscDetsTP view from TRANSACTIONAL TP View for CR Result DG Basic Classification Details
I_DangerousGoodsClassification view_entity from COMPOSITE Dangerous Goods Classification
R_DangerousGoodsClassfctnDetTP view_entity from TRANSACTIONAL DG Classification Detail - TP
R_DngrsGdsBasicClassfctnDetTP view_entity from TRANSACTIONAL DG Basic Classification Detail - TP

Fields (39)

KeyField CDS FieldsUsed in Views
KEY CmplRqRsltDngrsGdsBscDetsUUID CmplRqRsltDngrsGdsBscDetsUUID 6
KEY CmplRqRsltUUID CmplRqRsltUUID 3
_EnclosureVariant _EnclosureVariant 1
AddlPlcdIsIgnoredLblFrmRgln AddlPlcdIsIgnoredLblFrmRgln 1
BasicClassfctnIsOverwritten BasicClassfctnIsOverwritten 1
ClassifiedAsDangerousGood ClassifiedAsDangerousGood 7
CmplRqVersUUID CmplRqVersUUID 6
CreatedByUser CreatedByUser 1
CreationDateTime CreationDateTime 1
DangerousGoodsClass DangerousGoodsClass 7
DangerousGoodsIdnNumber DangerousGoodsIdnNumber,ProdCmplncDngrsGdsIdnNmbr 7
DangerousGoodsIdnNumberType DangerousGoodsIdnNumberType,ProdCmplncDngrsGdsIdnNmbrType 7
DangerousGoodsListItemVariant DangerousGoodsListItemVariant 1
DangerousGoodsPackingGroup DangerousGoodsPackingGroup 7
DngrsGdsDescTmplIsOverwritten DngrsGdsDescTmplIsOverwritten 1
DngrsGdsIsIgnoredLblFrmRgln DngrsGdsIsIgnoredLblFrmRgln 1
DngrsGdsMarnPlltnt1SubstUUID DngrsGdsMarnPlltnt1SubstUUID 1
DngrsGdsMarnPlltnt2SubstUUID DngrsGdsMarnPlltnt2SubstUUID 1
DngrsGdsQualifgWordPrefix DngrsGdsQualifgWordPrefix 1
DngrsGdsQualifgWordSuffix DngrsGdsQualifgWordSuffix 1
DngrsGdsRptblQty1SubstUUID DngrsGdsRptblQty1SubstUUID 1
DngrsGdsRptblQty2SubstUUID DngrsGdsRptblQty2SubstUUID 1
DngrsGdsTechName1PosOnSrce DngrsGdsTechName1PosOnSrce 1
DngrsGdsTechName1SubstUUID DngrsGdsTechName1SubstUUID 1
DngrsGdsTechName2PosOnSrce DngrsGdsTechName2PosOnSrce 1
DngrsGdsTechName2SubstUUID DngrsGdsTechName2SubstUUID 1
DngrsGdsTechName3PosOnSrce DngrsGdsTechName3PosOnSrce 1
DngrsGdsTechName3SubstUUID DngrsGdsTechName3SubstUUID 1
DngrsGoodDescForDocsTmplText DngrsGoodDescForDocsTmplText 1
EnclosureVariant EnclosureVariant 3
LastChangeDateTime LastChangeDateTime 1
LastChangedByUser LastChangedByUser 1
PackingInstruction DngrsGdsPackingInstructionText 3
ProdIsEnvironmentalHazardous ProdIsEnvironmentalHazardous 1
ProductIsMarinePollutant ProductIsMarinePollutant 1
ProductIsToxicByInhalation ProductIsToxicByInhalation 1
ReportableQtyIsPrintedOnDoc ReportableQtyIsPrintedOnDoc 1
SpecialProvisionOrExemptionTxt SpecialProvisionOrExemptionTxt 2
ToxicByInhalationHazardZone ToxicByInhalationHazardZone 1

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.

-- Basic Classification Details
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_CMPLRQRSLTDNGRSGDSBSCDETS (
    CMPLRQRSLTDNGRSGDSBSCDETSUUID,
    CMPLRQRSLTUUID,
    _ENCLOSUREVARIANT,
    ADDLPLCDISIGNOREDLBLFRMRGLN,
    BASICCLASSFCTNISOVERWRITTEN,
    CLASSIFIEDASDANGEROUSGOOD,
    CMPLRQVERSUUID,
    CREATEDBYUSER,
    CREATIONDATETIME,
    DANGEROUSGOODSCLASS,
    DANGEROUSGOODSIDNNUMBER,
    DANGEROUSGOODSIDNNUMBERTYPE,
    DANGEROUSGOODSLISTITEMVARIANT,
    DANGEROUSGOODSPACKINGGROUP,
    DNGRSGDSDESCTMPLISOVERWRITTEN,
    DNGRSGDSISIGNOREDLBLFRMRGLN,
    DNGRSGDSMARNPLLTNT1SUBSTUUID,
    DNGRSGDSMARNPLLTNT2SUBSTUUID,
    DNGRSGDSQUALIFGWORDPREFIX,
    DNGRSGDSQUALIFGWORDSUFFIX,
    DNGRSGDSRPTBLQTY1SUBSTUUID,
    DNGRSGDSRPTBLQTY2SUBSTUUID,
    DNGRSGDSTECHNAME1POSONSRCE,
    DNGRSGDSTECHNAME1SUBSTUUID,
    DNGRSGDSTECHNAME2POSONSRCE,
    DNGRSGDSTECHNAME2SUBSTUUID,
    DNGRSGDSTECHNAME3POSONSRCE,
    DNGRSGDSTECHNAME3SUBSTUUID,
    DNGRSGOODDESCFORDOCSTMPLTEXT,
    ENCLOSUREVARIANT,
    LASTCHANGEDATETIME,
    LASTCHANGEDBYUSER,
    PACKINGINSTRUCTION,
    PRODISENVIRONMENTALHAZARDOUS,
    PRODUCTISMARINEPOLLUTANT,
    PRODUCTISTOXICBYINHALATION,
    REPORTABLEQTYISPRINTEDONDOC,
    SPECIALPROVISIONOREXEMPTIONTXT,
    TOXICBYINHALATIONHAZARDZONE,
    PRIMARY KEY (CMPLRQRSLTDNGRSGDSBSCDETSUUID, CMPLRQRSLTUUID)
);

Learn More