FAC_DART_Z3_PROFITCENTER_BASE

@AbapCatalog.sqlViewName: 'FAC_DZPROFITCTRB'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@EndUserText.label: 'Profit Center Master Data Base'
@AccessControl.authorizationCheck: #CHECK
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass:  #MIXED
@ObjectModel.usageType.serviceQuality: #D
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.buffering.status: #NOT_ALLOWED
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED

define view FAC_DART_Z3_PROFITCENTER_BASE
  with parameters
    @Consumption.hidden: true
    @Environment.systemField: #SYSTEM_LANGUAGE
    P_Language : sylangu
  as select from I_ProfitCenter as _profitcenter

  inner join cepc_bukrs as _assignedcocode    on  _assignedcocode.kokrs = _profitcenter.ControllingArea
                                              and _assignedcocode.prctr = _profitcenter.ProfitCenter

{

  key _profitcenter.ProfitCenter,
      @ObjectModel.foreignKey.association: '_ControllingArea'
  key _profitcenter.ControllingArea,
  key _profitcenter.ValidityEndDate,
  key _assignedcocode.bukrs as CompanyCodeAssigned,
  key _assignedcocode.bukrs as CompanyCode,
      _ControllingArea.ControllingAreaName,
      _profitcenter._Text[1:Language=$parameters.P_Language].ProfitCenterName,
      _profitcenter._Text[1:Language=$parameters.P_Language].ProfitCenterLongName,

      ProfitCtrResponsibleUser,
      @Semantics.businessDate.from: true
      ValidityStartDate,
      Department,
      ProfitCenterStandardHierarchy,
      //--[ GENERATED:012:29JlHNUf7jY4ipE4XHfNBG

      @Consumption.valueHelpDefinition: [
        { entity:  { name:    'I_SegmentStdVH',
                     element: 'Segment' }
        }]
      //@ObjectModel.text.association: '_SegmentText'

      // ]--GENERATED

      @ObjectModel.foreignKey.association: '_Segment' //Inserted by VDM CDS Suite Plugin

      Segment,
      ProfitCenterIsBlocked,
      FormulaPlanningTemplate,
      FormOfAddress,
      AddressName,
      AdditionalName,
      ProfitCenterAddrName3,
      ProfitCenterAddrName4,
      StreetAddressName,
      POBox,
      CityName,
      PostalCode,
      District,
      @ObjectModel.foreignKey.association: '_Country' //Inserted by VDM CDS Suite Plugin

      Country,
      @ObjectModel.foreignKey.association: '_Region'
      Region,
      TaxJurisdiction,
      @Semantics.language:true
      @ObjectModel.foreignKey.association: '_Language' //Inserted by VDM CDS Suite Plugin

      Language,
      PhoneNumber1,
      PhoneNumber2,
      TeleboxNumber,
      TelexNumber,
      FaxNumber,
      DataCommunicationPhoneNumber,
      ProfitCenterPrinterName,
      ProfitCenterCreatedByUser,
      ProfitCenterCreationDate,

      _Text,
      _Country,
      _ControllingArea,
      _ProfitCenterHierarchyNode,
      _Language,
      _Segment,
      _Region



}

union all 

select from I_ProfitCenter as _profitcenter
  inner join I_CompanyCode on I_CompanyCode.CompanyCode <> ''
  left outer to many join cepc_bukrs as _assignedcocode    on  _assignedcocode.kokrs = _profitcenter.ControllingArea
                                                         and _assignedcocode.prctr = _profitcenter.ProfitCenter

{

  key _profitcenter.ProfitCenter,
      @ObjectModel.foreignKey.association: '_ControllingArea'
  key _profitcenter.ControllingArea,
  key _profitcenter.ValidityEndDate,
  key _assignedcocode.bukrs as CompanyCodeAssigned,
  key I_CompanyCode.CompanyCode,
      _profitcenter._ControllingArea.ControllingAreaName,
      _profitcenter._Text[1:Language=$parameters.P_Language].ProfitCenterName,
      _profitcenter._Text[1:Language=$parameters.P_Language].ProfitCenterLongName,

      ProfitCtrResponsibleUser,
      @Semantics.businessDate.from: true
      ValidityStartDate,
      Department,
      ProfitCenterStandardHierarchy,
      //--[ GENERATED:012:29JlHNUf7jY4ipE4XHfNBG

      @Consumption.valueHelpDefinition: [
        { entity:  { name:    'I_SegmentStdVH',
                     element: 'Segment' }
        }]
      //@ObjectModel.text.association: '_SegmentText'

      // ]--GENERATED

      @ObjectModel.foreignKey.association: '_Segment' //Inserted by VDM CDS Suite Plugin

      Segment,
      ProfitCenterIsBlocked,
      FormulaPlanningTemplate,
      FormOfAddress,
      AddressName,
      AdditionalName,
      ProfitCenterAddrName3,
      ProfitCenterAddrName4,
      StreetAddressName,
      POBox,
      _profitcenter.CityName,
      PostalCode,
      District,
      @ObjectModel.foreignKey.association: '_Country' //Inserted by VDM CDS Suite Plugin

      _profitcenter.Country,
      @ObjectModel.foreignKey.association: '_Region'
      Region,
      TaxJurisdiction,
      @Semantics.language:true
      @ObjectModel.foreignKey.association: '_Language' //Inserted by VDM CDS Suite Plugin

      _profitcenter.Language,
      PhoneNumber1,
      PhoneNumber2,
      TeleboxNumber,
      TelexNumber,
      FaxNumber,
      DataCommunicationPhoneNumber,
      ProfitCenterPrinterName,
      ProfitCenterCreatedByUser,
      ProfitCenterCreationDate,

      _Text,
      _Country,
      _ControllingArea,
      _ProfitCenterHierarchyNode,
      _Language,
      _Segment,
      _Region



}
where _assignedcocode.bukrs is null or _assignedcocode.bukrs = ''


/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_COMPANYCODE",
"I_CONTROLLINGAREA",
"I_PROFITCENTER",
"I_PROFITCENTERTEXT",
"CEPC_BUKRS"
],
"ASSOCIATED":
[
"I_CONTROLLINGAREA",
"I_COUNTRY",
"I_LANGUAGE",
"I_PROFITCENTERHIERARCHYNODE",
"I_PROFITCENTERTEXT",
"I_REGION",
"I_SEGMENT"
],
"BASE":
[
"I_PROFITCENTER"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/