P_UPADAGDSCLFNTECHNAME

CDS View

P_UPADAGDSCLFNTECHNAME is a CDS View in S/4HANA. It contains 2 fields. 4 CDS views read from this table.

Used by 4 CDS view(s) 2 fields

CDS Views using this table (4)

ViewTypeJoinVDMDescription
C_AnlytlCmpstnMarnPlltntIMDG view inner CONSUMPTION Marine Pollutants for Analytical Composition for IMDG
C_CA_AnlytlCmpstnMarnPlltntTDG view inner CONSUMPTION Marine Pollutants for Analytical Composition for TDG
C_UpaDaGdsClfnTechName view from CONSUMPTION Technical Names - Analytical Composition
C_US_AnlytlCmpstnMarnPlltntCFR view inner CONSUMPTION Marine Pollutants for Analytical Composition for 49 CFR

Fields (2)

KeyField CDS FieldsUsed in Views
KEY SubstanceUUID SubstanceUUID 4
_Substance _Substance 3 
@AbapCatalog.sqlViewName: 'PDGTECHNAM'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED

@VDM: {
  private: true,
  viewType: #CONSUMPTION
}

@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel: {
  usageType: {
    dataClass: #MIXED,
    sizeCategory: #L,
    serviceQuality: #C
  }
}

define view P_UpaDaGdsClfnTechName 
  as select from I_ChmlComposition as ChemicalComposition

{
  key ChemicalComposition.ChmlCompositionUUID              as ChmlCompositionUUID,
  key _ChmlComponent.SubstanceUUID                         as SubstanceUUID,
      _ChmlComponent.ChmlCmplncInfoUUID                    as ChmlCmplncInfoUUID,
      _ChmlComponent._Substance._ListedSubstance.ECNumber  as ECNumber,
      _ChmlComponent._Substance._ListedSubstance.CASNumber as CASNumber,
      
      _ChmlComponent._Substance,

      // Required for DCL

      _ChmlComponent._ChmlCmplncInfo
}
where
      ChemicalComposition.ChmlCompositionType     = 'ANALYTIC1'
  and ChemicalComposition.ChmlCompositionStatus   = 'RE'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CHMLCOMPONENT",
"I_CHMLCOMPOSITION",
"I_LISTEDSUBSTANCE",
"I_SUBSTANCEENHANCED"
],
"ASSOCIATED":
[
"I_CHMLCMPLNCINFO",
"I_SUBSTANCEENHANCED"
],
"BASE":
[
"I_CHMLCOMPONENT"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More