P_ProdCmplncPlant

@AccessControl.authorizationCheck: #NOT_REQUIRED

@ObjectModel: {
  usageType: {
    serviceQuality: #A,
    sizeCategory:  #L,
    dataClass: #CUSTOMIZING },
    representativeKey: 'Plant'
 }
@Metadata: {
  ignorePropagatedAnnotations: true
 }

@VDM: {
  viewType: #COMPOSITE,
  private: true }
define view entity P_ProdCmplncPlant
  as select from I_Plant as _Plant
   inner join I_ValuationArea as _ValuationArea on _Plant.ValuationArea = _ValuationArea.ValuationArea
   inner join I_CompanyCode as _CompanyCode on _ValuationArea.CompanyCode = _CompanyCode.CompanyCode
{
  key _Plant.Plant,
  key _ValuationArea.CompanyCode,
      _Plant.PlantName,
      _CompanyCode.CompanyCodeName
}

union

select from I_CompanyCode as _CompanyCode
// This returns the language-dependent text for <ANY> (EHFND_UI_COMN/ANY_MARK)

  join      I_OTRText     as _FallbackName on  _FallbackName.OnlnTxtRpstryConceptID = '0894EF4587211EDC9FE9372D9FC3DEB1'
                                           and _FallbackName.OnlnTxtObjectID        is initial
                                           and _FallbackName.Language               = $session.system_language
//association [1..1] to I_Plant             as _Plant     on $projection.Plant = _Plant.Plant

/*+[hideWarning] { "IDS" : [ "CARDINALITY_CHECK" ] }*/
association [1..1] to P_ChmlCmplConstants as _Constants on _Constants.Constant1 = _Constants.Constant1

{
  key _Constants.ConstantEmpty     as Plant,
  key _CompanyCode.CompanyCode     as CompanyCode,
      _FallbackName.Text           as PlantName,
      _CompanyCode.CompanyCodeName as CompanyCodeName

}
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_COMPANYCODE",
"I_OTRTEXT",
"I_PLANT",
"I_VALUATIONAREA",
"P_CHMLCMPLCONSTANTS"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/