P_FrcElmntOrgBusinessAddress

@AbapCatalog.sqlViewName: 'PFEORGBUSADDR'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM: {
    viewType : #BASIC,
    private  : true
}
@ObjectModel : {
    usageType : {
        dataClass       : #MASTER,
        serviceQuality  : #A,
        sizeCategory    : #L
    }
}
define view P_FrcElmntOrgBusinessAddress
  as select from adrc as FrcElmntOrgBusinessAddress
{
  key FrcElmntOrgBusinessAddress.addrnumber       as AddressNumber,
  key FrcElmntOrgBusinessAddress.date_from        as FrcElmntOrgAddrFromDate,
  key FrcElmntOrgBusinessAddress.nation           as Nation,
      FrcElmntOrgBusinessAddress.date_to          as FrcElmntOrgAddrToDate,
      FrcElmntOrgBusinessAddress.title            as FrcElmntOrgAddrTitle,
      FrcElmntOrgBusinessAddress.name1            as FrcElmntOrgAddrName1,
      FrcElmntOrgBusinessAddress.name2            as FrcElmntOrgAddrName2,
      FrcElmntOrgBusinessAddress.name3            as FrcElmntOrgAddrName3,
      FrcElmntOrgBusinessAddress.name4            as FrcElmntOrgAddrName4,
      FrcElmntOrgBusinessAddress.name_co          as FrcElmntOrgAddrCareOfName,
      FrcElmntOrgBusinessAddress.city1            as CityName,
      FrcElmntOrgBusinessAddress.city2            as FrcElmntOrgAddrDistrict,
      FrcElmntOrgBusinessAddress.home_city        as HomeCityName,
      FrcElmntOrgBusinessAddress.regiogroup       as RegionalStructureGrouping,
      FrcElmntOrgBusinessAddress.post_code1       as PostalCode,
      FrcElmntOrgBusinessAddress.post_code2       as FrcElmntOrgAddrPOBoxPostalCode,
      FrcElmntOrgBusinessAddress.post_code3       as CompanyPostalCode,
      FrcElmntOrgBusinessAddress.po_box           as POBox,
      FrcElmntOrgBusinessAddress.dont_use_p       as FrcElmntOrgPOBoxNonDelivRsn,
      FrcElmntOrgBusinessAddress.po_box_num       as FrcElmntOrgIsPOBoxWthoutNmbr,
      FrcElmntOrgBusinessAddress.po_box_loc       as FrcElmntOrgAddrPOBoxCityName,
      FrcElmntOrgBusinessAddress.po_box_reg       as FrcElmntOrgAddrPOBoxRegion,
      FrcElmntOrgBusinessAddress.po_box_cty       as FrcElmntOrgAddrPOBoxCountry,
      FrcElmntOrgBusinessAddress.transpzone       as TransportZone,
      FrcElmntOrgBusinessAddress.street           as StreetName,
      FrcElmntOrgBusinessAddress.dont_use_s       as FrcElmntOrgAddrNonDelivReason,
      FrcElmntOrgBusinessAddress.house_num1       as HouseNumber,
      FrcElmntOrgBusinessAddress.house_num2       as FrcElmntOrgHsNmbrSuplmntText,
      FrcElmntOrgBusinessAddress.str_suppl1       as FrcElmntOrgAddrStreetName2,
      FrcElmntOrgBusinessAddress.str_suppl2       as FrcElmntOrgAddrStreetName3,
      FrcElmntOrgBusinessAddress.str_suppl3       as FrcElmntOrgAddrStreetName4,
      FrcElmntOrgBusinessAddress.location         as FrcElmntOrgAddrLocationName,
      FrcElmntOrgBusinessAddress.building         as Building,
      FrcElmntOrgBusinessAddress.floor            as Floor,
      FrcElmntOrgBusinessAddress.roomnumber       as RoomNumber,
      FrcElmntOrgBusinessAddress.country          as CountryCode,
      FrcElmntOrgBusinessAddress.langu            as LanguageCode,
      FrcElmntOrgBusinessAddress.region           as Region,
      FrcElmntOrgBusinessAddress.sort1            as AddressSearchText1,
      FrcElmntOrgBusinessAddress.sort2            as AddressSearchText2,
      FrcElmntOrgBusinessAddress.deflt_comm       as CommunicationMediumType,
      FrcElmntOrgBusinessAddress.tel_number       as FrcElmntOrgAddrTelephoneNumber,
      FrcElmntOrgBusinessAddress.tel_extens       as FrcElmntOrgAddrTelExtension,
      FrcElmntOrgBusinessAddress.fax_number       as AddressFaxNumber,
      FrcElmntOrgBusinessAddress.fax_extens       as FrcElmntOrgAddrFaxNumberExtn,
      FrcElmntOrgBusinessAddress.time_zone        as AddressTimeZone,
      FrcElmntOrgBusinessAddress.taxjurcode       as FrcElmntOrgAddrTaxJurisdiction,
      FrcElmntOrgBusinessAddress.po_box_lobby     as FrcElmntOrgAddrPOBoxLobbyName,
      FrcElmntOrgBusinessAddress.deli_serv_type   as DeliveryServiceTypeCode,
      FrcElmntOrgBusinessAddress.deli_serv_number as FrcElmntOrgAddrDelivSrvcNumber

}
where
  FrcElmntOrgBusinessAddress.addr_group = 'DFP1'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"ADRC"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/