R_PurchaseOrderSupplierAddress

@AbapCatalog.sqlViewName: 'RMMPOSUPPLADDR'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl: { authorizationCheck: #PRIVILEGED_ONLY, personalData.blocking: #BLOCKED_DATA_EXCLUDED }
@EndUserText.label: 'Purchase Order Supplier Address'
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType : #COMPOSITE
@ObjectModel.representativeKey: 'SupplierAddressID'
@ObjectModel.uniqueIdField: 'SupplierAddressUUID'
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API

define view R_PurchaseOrderSupplierAddress
  as select from P_PurchaseOrderSupplierAddress
  association [0..1] to R_PurchaseOrder as _PurchaseOrder on $projection.PurchaseOrder = _PurchaseOrder.PurchaseOrder
{
  key P_PurchaseOrderSupplierAddress.SupplierAddressID,
  key P_PurchaseOrderSupplierAddress.PurchaseOrder,
      _SupplierAddress.AddressID,
      _SupplierAddress.AddressPersonID,
      _SupplierAddress.AddressRepresentationCode,

      _SupplierAddress.CorrespondenceLanguage,
      _SupplierAddress.PrfrdCommMediumType,
      _SupplierAddress.AddresseeFullName,
      _SupplierAddress.OrganizationName1,
      _SupplierAddress.OrganizationName2,
      _SupplierAddress.OrganizationName3, 
      _SupplierAddress.OrganizationName4, 
      _SupplierAddress.AddressSearchTerm1,
      _SupplierAddress.AddressSearchTerm2,
      _SupplierAddress.CityName,
      _SupplierAddress.DistrictName, 
      _SupplierAddress.VillageName,
      _SupplierAddress.PostalCode,
      _SupplierAddress.CompanyPostalCode,
      _SupplierAddress.StreetName,
      _SupplierAddress.StreetPrefixName1,
      _SupplierAddress.StreetPrefixName2,
      _SupplierAddress.StreetSuffixName1,
      _SupplierAddress.StreetSuffixName2,
      _SupplierAddress.HouseNumber,
      _SupplierAddress.HouseNumberSupplementText,
      _SupplierAddress.Building, 
      _SupplierAddress.Floor,
      _SupplierAddress.RoomNumber,
      _SupplierAddress.Country,
      _SupplierAddress.Region,
      _SupplierAddress.FormOfAddress,
      _SupplierAddress.TaxJurisdiction,
      _SupplierAddress.TransportZone,
      _SupplierAddress.POBox,
      _SupplierAddress.POBoxIsWithoutNumber,
      _SupplierAddress.POBoxPostalCode,
      _SupplierAddress.POBoxLobbyName,
      _SupplierAddress.POBoxDeviatingCityName,
      _SupplierAddress.POBoxDeviatingRegion,
      _SupplierAddress.POBoxDeviatingCountry,
      _SupplierAddress.CareOfName,
      _SupplierAddress.DeliveryServiceTypeCode,
      _SupplierAddress.DeliveryServiceNumber,
      _SupplierAddress.AddressTimeZone,
      _SupplierAddress._Country,
      _SupplierAddress._CurrentDfltEmailAddress,
      _SupplierAddress._CurrentDfltFaxNumber,
      _SupplierAddress._CurrentDfltLandlinePhoneNmbr,
      _SupplierAddress._CurrentDfltMobilePhoneNumber,
      _SupplierAddress._EmailAddress,
      _SupplierAddress._FaxNumber,
      _SupplierAddress._PhoneNumber,
      _SupplierAddress._Region,
      _SupplierAddress.RegionalStructureCheckStatus,
    

      //  @ObjectModel.association.type: [#TO_COMPOSITION_PARENT, #TO_COMPOSITION_ROOT]

      _PurchaseOrder


      // Old Fields

      // Keys

      //  key AddressID   as SupplierAddressID,

      //      AddressUUID as SupplierAddressUUID,

      //

      //      // Purchase Order Box data

      //      POBox,

      //      POBoxIsWithoutNumber,

      //      POBoxPostalCode,

      //      POBoxLobbyName,

      //      POBoxDeviatingCityName,

      //      POBoxDeviatingRegion,

      //      POBoxDeviatingCountry,

      //

      //      // Main address data

      //      FullName,

      //      CityName,

      //      District as DistrictName,

      //      CityCode,

      //      HomeCityName,

      //      PostalCode,

      //      CompanyPostalCode,

      //      StreetName,

      //      StreetPrefixName,

      //      AdditionalStreetPrefixName,

      //      StreetSuffixName,

      //      HouseNumber,

      //      HouseNumberSupplementText,

      //      Building,

      //      Floor,

      //      RoomNumber,

      //      Country,

      //      Region,

      //      County,

      //      CountyCode,

      //      TownshipCode,

      //      TownshipName,

      //

      //      // Delivery service and status

      //      CareOfName,

      //      AdditionalStreetSuffixName,

      //      CorrespondenceLanguage,

      //      PrfrdCommMediumType,

      //      DeliveryServiceTypeCode,

      //      DeliveryServiceNumber,

      //      AddressTimeZone,

      //      CityFileTestStatus,

      //      AddressStreetUnusable,

      //      AddressPostBoxUnusable,

      //      FormOfAddress,

      //

      //      // The other address data

      //      BusinessPartnerName1,

      //      BusinessPartnerName2,

      //      Nation,

      //      PhoneNumber,

      //      FaxNumber,

      //      SearchTerm1,

      //      SearchTerm2,

      //      StreetSearch,

      //      CitySearch,

      //      BusinessPartnerName3,

      //      BusinessPartnerName4,

      //      TaxJurisdiction,

      //      TransportZone,

      //      AddressCityPostBoxCode,

      //      Person,


      //TODO's

      // Category 1. The fields exist in DB ADRC and need to be added to basic view

      // PostDeliveryDistrict - POSTALAREA

      // StreetNumberForCity - STREETABBR

      // AbbreviationOfStreetName - STREETCODE

      // RegionalStructureGrouping - REGIOGROUP



      // Category 2. The fields don't exist in DB ADRC. Provided component name in BAPI Structure.

      // FormOfAddressText - FORMOFADDR

      // AddressNotes - ADR_NOTES

      // FirstTelephoneNo - TEL1_EXT

      // FirstFaxNumber - FAX_EXTENS

      // EmailAddress - E_MAIL

      // TitleText - TITLE

      // CountryISOUnit - COUNTRYISO

      // CountrySAPUnit

      // LanguageISOUnit - LANGU_ISO

      // LanguageSAPUnit

      // SupplierToReceiveDelivery - SUPP_VENDOR

      // Customer - CUSTOMER

      // SubcontractingSupplier - SC_VENDOR


      /* Associations */
      //      _PurchaseOrder


      //      _CityCode,

      //      _Country,

      //      _CountyCode,

      //      _DefaultCorpEmailAddress,

      //      _DefaultCorpFaxNumber,

      //      _DefaultCorpMobilePhoneNumber,

      //      _DefaultCorporatePhoneNumber,

      //      _DefaultCorpURLAddress,

      //      _DefaultEmailAddress,

      //      _DefaultFaxNumber,

      //      _DefaultMobilePhoneNumber,

      //      _DefaultPhoneNumber,

      //      _DefaultPrivateFaxNumber,

      //      _DefaultPrivatePhoneNumber,

      //      _DefaultPvtEmailAddress,

      //      _DefaultPvtMobilePhoneNumber,

      //      _DefaultPvtURLAddress,

      //      _DefaultURLAddress,

      //      _FormOfAddress,

      //      _Region

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ADDRESS_2",
"P_PURCHASEORDERSUPPLIERADDRESS"
],
"ASSOCIATED":
[
"I_ADDRCURDEFAULTEMAILADDRESS",
"I_ADDRCURDEFAULTFAXNUMBER",
"I_ADDRCURDFLTLANDLINEPHONENMBR",
"I_ADDRCURDFLTMOBILEPHONENUMBER",
"I_ADDRESSEMAILADDRESS_2",
"I_ADDRESSFAXNUMBER_2",
"I_ADDRESSPHONENUMBER_2",
"I_COUNTRY",
"I_REGION",
"R_PURCHASEORDER"
],
"BASE":
[
"I_ADDRESS_2"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/