P_OrganicPeroxideInAllLanguage

DDL: P_ORGANICPEROXIDEINALLLANGUAGE SQL: PORGPRXALLLNG Type: view COMPOSITE

P_OrganicPeroxideInAllLanguage is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (I_Language, P_OrganicPeroxide) and exposes 13 fields with key fields CmplRqVersOrganicPrxdUUID, Language.

2 data source(s) 13 fields

Data Sources (2)

SourceAliasJoin Type
I_Language I_Language cross
P_OrganicPeroxide OrganicPeroxide from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PORGPRXALLLNG 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 (13)

KeyFieldSource TableSource FieldDescription
KEY CmplRqVersOrganicPrxdUUID P_OrganicPeroxide CmplRqVersOrganicPrxdUUID
KEY Language I_Language Language
ProdCmplncDngrsGdsIdnNmbrType P_OrganicPeroxide ProdCmplncDngrsGdsIdnNmbrType
ProdCmplncDngrsGdsIdnNmbr P_OrganicPeroxide ProdCmplncDngrsGdsIdnNmbr
ListedSubstance P_OrganicPeroxide ListedSubstance
DngrsGdsPositionOnSource P_OrganicPeroxide DngrsGdsPositionOnSource
SubstanceListUUID P_OrganicPeroxide SubstanceListUUID
CmplRqVersUUID P_OrganicPeroxide CmplRqVersUUID
DngrsGdsOrganicPrxdName P_OrganicPeroxide DngrsGdsOrganicPrxdName
SubstanceUUID P_OrganicPeroxide SubstanceUUID
ActiveSubstanceUUID P_OrganicPeroxide ActiveSubstanceUUID
_OrgPeroxidePrintedName P_OrganicPeroxide _OrgPeroxidePrintedName
_Text I_Language _Text 
@AbapCatalog.sqlViewName: 'PORGPRXALLLNG'
@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 organic peroxid 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_OrganicPeroxideInAllLanguage
  as select from P_OrganicPeroxide as OrganicPeroxide
    cross join   I_Language
{
  key OrganicPeroxide.CmplRqVersOrganicPrxdUUID,
  key I_Language.Language,

OrganicPeroxide.ProdCmplncDngrsGdsIdnNmbrType,
OrganicPeroxide.ProdCmplncDngrsGdsIdnNmbr,
OrganicPeroxide.ListedSubstance,
OrganicPeroxide.DngrsGdsPositionOnSource,
OrganicPeroxide.SubstanceListUUID,
OrganicPeroxide.CmplRqVersUUID,
OrganicPeroxide.DngrsGdsOrganicPrxdName,
//OrganicPeroxide.DngrsGdsConcnLowrQtyOptr,

//OrganicPeroxide.DngrsGdsConcnLowrQty,

//OrganicPeroxide.DngrsGdsConcnLowrQtyUnit,

//OrganicPeroxide.DngrsGdsHasConcnLowrQty,

//OrganicPeroxide.DngrsGdsConcnUprQtyOptr,

//OrganicPeroxide.DngrsGdsConcnUprQty,

//OrganicPeroxide.DngrsGdsConcnUprQtyUnit,

//OrganicPeroxide.DngrsGdsHasConcnUprQty,

//OrganicPeroxide.DngrsGdsOrganicPrxdAddlInfoTxt,

//OrganicPeroxide.DngrsGdsPrxdDiluentType1Txt,

//OrganicPeroxide.DngrsGdsPrxdDiluentType2Txt,

//OrganicPeroxide.DngrsGdsPrxdInertSolidTxt,

//OrganicPeroxide.DngrsGdsOrganicPrxdWaterTxt,

//OrganicPeroxide.DngrsGdsPackingMethodText,

//OrganicPeroxide.DangerousGoodsControlTemp,

//OrganicPeroxide.DangerousGoodsControlTempUnit,

//OrganicPeroxide.DangerousGoodsEmergencyTemp,

//OrganicPeroxide.DangerousGoodsEmgyTempUnit,

OrganicPeroxide.SubstanceUUID,
OrganicPeroxide.ActiveSubstanceUUID,

OrganicPeroxide._OrgPeroxidePrintedName,

 I_Language._Text
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_LANGUAGE",
"P_ORGANICPEROXIDE"
],
"ASSOCIATED":
[
"I_CMPLRQVERSDNGRSGDSPRXDPRNTT",
"I_LANGUAGETEXT"
],
"BASE":
[
"I_LANGUAGE",
"P_ORGANICPEROXIDE"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More