P_SelfReactiveSubstInAllLang

DDL: P_SELFREACTIVESUBSTINALLLANG SQL: PSELFREACALLLNG Type: view COMPOSITE

P_SelfReactiveSubstInAllLang is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (I_Language, P_SelfReactiveSubstance) and exposes 14 fields with key fields Language, CmplRqVersSelfReactvSubstUUID, ActiveSubstanceUUID.

2 data source(s) 14 fields

Data Sources (2)

SourceAliasJoin Type
I_Language I_Language cross
P_SelfReactiveSubstance SelfReactiveSUbstance from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PSELFREACALLLNG view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY Language I_Language Language
KEY CmplRqVersSelfReactvSubstUUID P_SelfReactiveSubstance CmplRqVersSelfReactvSubstUUID
KEY ActiveSubstanceUUID P_SelfReactiveSubstance ActiveSubstanceUUID
LanguageISOCode I_Language LanguageISOCode
SubstanceListUUID P_SelfReactiveSubstance SubstanceListUUID
CmplRqVersUUID P_SelfReactiveSubstance CmplRqVersUUID
ProdCmplncDngrsGdsIdnNmbrType P_SelfReactiveSubstance ProdCmplncDngrsGdsIdnNmbrType
ProdCmplncDngrsGdsIdnNmbr P_SelfReactiveSubstance ProdCmplncDngrsGdsIdnNmbr
ListedSubstance P_SelfReactiveSubstance ListedSubstance
DngrsGdsPositionOnSource P_SelfReactiveSubstance DngrsGdsPositionOnSource
DngrsGdsSelfReactvName P_SelfReactiveSubstance DngrsGdsSelfReactvName
SubstanceUUID P_SelfReactiveSubstance SubstanceUUID
_Text I_Language _Text
_SelfReactvPrintedName P_SelfReactiveSubstance _SelfReactvPrintedName 
@AbapCatalog.sqlViewName: 'PSELFREACALLLNG'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED

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

@ClientHandling.algorithm: #SESSION_VARIABLE

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

// This view cross-joins all self reactive substances with all languages. This view exists for a limitation in CDS, that you cannot

// use the language field from I_Language in inline association conditions, AND have a join on the language view on the same level.


define view P_SelfReactiveSubstInAllLang
  as select from P_SelfReactiveSubstance as SelfReactiveSUbstance
    cross join   I_Language
{
key I_Language.Language,
key SelfReactiveSUbstance.CmplRqVersSelfReactvSubstUUID,
key SelfReactiveSUbstance.ActiveSubstanceUUID,
I_Language.LanguageISOCode,
SelfReactiveSUbstance.SubstanceListUUID,
SelfReactiveSUbstance.CmplRqVersUUID,
SelfReactiveSUbstance.ProdCmplncDngrsGdsIdnNmbrType,
SelfReactiveSUbstance.ProdCmplncDngrsGdsIdnNmbr,
SelfReactiveSUbstance.ListedSubstance,
SelfReactiveSUbstance.DngrsGdsPositionOnSource,
SelfReactiveSUbstance.DngrsGdsSelfReactvName,
//SelfReactiveSUbstance.DngrsGdsConcnLowrQtyOptr,

//SelfReactiveSUbstance.DngrsGdsConcnLowrQty,

//SelfReactiveSUbstance.DngrsGdsConcnLowrQtyUnit,

//SelfReactiveSUbstance.DngrsGdsHasConcnLowrQty,

//SelfReactiveSUbstance.DngrsGdsConcnUprQtyOptr,

//SelfReactiveSUbstance.DngrsGdsConcnUprQty,

//SelfReactiveSUbstance.DngrsGdsConcnUprQtyUnit,

//SelfReactiveSUbstance.DngrsGdsHasConcnUprQty,

//SelfReactiveSUbstance.DngrsGdsSelfReactvAddlInfoTxt,

//SelfReactiveSUbstance.DngrsGdsPackingMethodText,

//SelfReactiveSUbstance.DangerousGoodsControlTemp,

//SelfReactiveSUbstance.DangerousGoodsControlTempUnit,

//SelfReactiveSUbstance.DangerousGoodsEmergencyTemp,

//SelfReactiveSUbstance.DangerousGoodsEmgyTempUnit,

SelfReactiveSUbstance.SubstanceUUID,
/* Associations */
I_Language._Text,
SelfReactiveSUbstance._SelfReactvPrintedName

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_LANGUAGE",
"P_SELFREACTIVESUBSTANCE"
],
"ASSOCIATED":
[
"I_DNGRSGDSSELFREACTVPRNTT",
"I_LANGUAGETEXT"
],
"BASE":
[
"I_LANGUAGE",
"P_SELFREACTIVESUBSTANCE"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More