P_CnsldtnPlantT

@AbapCatalog.sqlViewName: 'PCSPLANTT'

@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true

@ObjectModel.usageType: {
  dataClass: #MASTER,
  serviceQuality: #B,
  sizeCategory: #L
}
@VDM:{
  viewType: #COMPOSITE,
  private:true
  }

define view P_CnsldtnPlantT
  as select from I_Plant
{

  key cast( $session.system_language as spras )                   as Language,

  key Plant,

      cast ( 'ACCTG' as fincs_masterdatasource )                  as AdditionalMasterDataSource,

      cast ( ' ' as fincs_isadditionalmasterdata preserving type) as CnsldtnIsAdditionalMasterData,

      PlantName                                                   as PlantName
}


union all select from I_CnsldtnAddlMD
{

  key _Text.Language                                              as Language,

  key AdditionalMasterDataCode                                    as Plant,

      cast ( 'CNSLDTN' as fincs_masterdatasource )                as AdditionalMasterDataSource,

      cast ( 'X' as fincs_isadditionalmasterdata preserving type) as CnsldtnIsAdditionalMasterData,

      _Text.AdditionalMasterDataText                              as PlantName
}
where
      AdditionalCharcFieldName =  'WERKS'
  and AdditionalMasterDataCode <> ''
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CNSLDTNADDLMD",
"I_CNSLDTNADDLMDT",
"I_PLANT"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/