FAC_AUDIT_Z3_Plant

@AbapCatalog.sqlViewName: 'FAC_DZWERKS'
@EndUserText.label: 'Plant'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass:  #MASTER
@ObjectModel.usageType.serviceQuality: #C
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.buffering.status: #NOT_ALLOWED
@AbapCatalog.preserveKey: true
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
define view FAC_AUDIT_Z3_Plant
  // with parameters

  //   P_Company : bukrs

  as select from I_Plant       as plant
    inner join   t001k                    on plant.ValuationArea = t001k.bwkey
    inner join   I_CompanyCode as company on t001k.bukrs = company.CompanyCode
    inner join   t001w                    on plant.Plant = t001w.werks
{
  key company.CompanyCode,
  key plant.Plant,
      @EndUserText.label: 'System Client'
      $session.client                     as SystemClient,
      plant.PlantName                     as name1,
      plant._Address.BusinessPartnerName2 as name2,
      plant._Address.StreetName,
      plant._Address.HouseNumber,
      plant._Address.HouseNumberSupplementText,
      plant._Address.POBox,
      plant._Address.CityName,
      plant._Address.District,
      plant._Address.Region,
      plant._Address.PostalCode,
      plant._Address.Country,
      plant.AddressID,
      plant._Address.TaxJurisdiction,
      plant.DefaultPurchasingOrganization,
      plant.SalesOrganization,
      plant.PlantCategory,
      //t001w.taxiw                         as BusinessPlace,

      t001w.taxiw                         as TaxIndicator,
      t001w.j_1bbranch                    as BusinessPlace,
      t001w.vstel                         as ShippingPoint
}
// where company.CompanyCode = $parameters.P_Company;