I_PURCHASEREQNADDRESS

@AbapCatalog.sqlViewName: 'IPURREQNADD'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Purchase Requisition Address Basic View'
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #COMPOSITE

@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED

define view I_PurchaseReqnAddress
  as select from R_PurchaseReqnItem as PurchaseReqnItem
  //  association [0..1] to I_Address                as _Address                on  $projection.DeliveryAddressID = _Address.AddressID

  association [0..1] to I_OrganizationAddress     as _OrganizationAddress    on  $projection.DeliveryAddressID                  = _OrganizationAddress.AddressID
                                                                             and _OrganizationAddress.AddressPersonID           is initial
                                                                             and _OrganizationAddress.AddressRepresentationCode is initial
  // assoiation to phone number and Fax

  association [0..1] to I_AddressPhoneNumber_2    as _PhoneNumber            on  $projection.DeliveryAddressID              = _PhoneNumber.AddressID
                                                                             and _PhoneNumber.PhNmbrIsCurrentOverallDefault = 'X'

  association [0..*] to I_AddrCurDefaultFaxNumber as _CurrentDfltFaxNumber   on  $projection.DeliveryAddressID = _CurrentDfltFaxNumber.AddressID

  association [0..1] to I_StorageLocationAddress  as _StorageLocationAddress on  $projection.Plant                 = _StorageLocationAddress.Plant
                                                                             and $projection.StorageLocation       = _StorageLocationAddress.StorageLocation
                                                                             and $projection.ItemDeliveryAddressID = _StorageLocationAddress.AddressID
{
  key PurchaseReqnItem.PurchaseRequisition,
  key PurchaseReqnItem.PurchaseRequisitionItem,
      //      _Address.AddressID,

      _OrganizationAddress.AddressID,
      //Address type

      case
      when PurchaseReqnItem.PurchasingDeliveryAddressType is not initial
       then PurchaseReqnItem.PurchasingDeliveryAddressType
      //manual deliv address

      when PurchaseReqnItem.ManualDeliveryAddressID <> ''
      then cast ( 'U' as purreqnaddrtype  preserving type)
      //referenced other address

      when PurchaseReqnItem.ItemDeliveryAddressID <> ''
          then
            case
                when PurchaseReqnItem.ItemDeliveryAddressID = _StorageLocationAddress.AddressID
                    then cast ( 'L' as purreqnaddrtype  preserving type)
                    else
                    cast( 'R' as purreqnaddrtype  preserving type)  //Reference Address

            end
      //address from supplier

      when PurchaseReqnItem.Subcontractor <> ''
      then cast ( 'S' as purreqnaddrtype  preserving type)

      //address from customer

      when PurchaseReqnItem.PurReqnReceivingCustomer <> ''
      then cast ( 'C' as purreqnaddrtype preserving type )

      //default address from Plant and item not thrid party

      when PurchaseReqnItem.ManualDeliveryAddressID = '' and PurchaseReqnItem.ItemDeliveryAddressID = ''
                   and PurchaseReqnItem.Subcontractor = '' and PurchaseReqnItem.PurReqnReceivingCustomer = ''
                and PurchaseReqnItem.PurchasingDocumentItemCategory <> '5'
      and PurchaseReqnItem.DeliveryAddressID <> ''
      then cast ( 'P' as purreqnaddrtype  preserving type)
      else
      cast ( 'P' as purreqnaddrtype  preserving type)
      end                                               as AddressType,

      PurchaseReqnItem.DeliveryAddressID,
      PurchaseReqnItem.Plant,
      PurchaseReqnItem.StorageLocation,
      //        _PurchaseReqnItm.SupplierReceivingDelivery,

      //        _PurchaseReqnItm.CustomerReceivingDelivery,

      // PurchaseReqnItem.PurReqnReceivingSupplier,

      PurchaseReqnItem.ManualDeliveryAddressID,
      PurchaseReqnItem.ItemDeliveryAddressID,
      PurchaseReqnItem.PurchasingGroup,
      PurchaseReqnItem.PurchaseRequisitionType,
      PurchaseReqnItem.PurchasingOrganization,
      //      _Address.CareOfName,

      //      _Address.AdditionalStreetSuffixName,

      //      _Address.CorrespondenceLanguage,

      //      _Address.PrfrdCommMediumType,

      //      _Address.POBox,

      //      _Address.POBoxIsWithoutNumber,

      //      _Address.POBoxPostalCode,

      //      _Address.POBoxLobbyName,

      //      _Address.POBoxDeviatingCityName,

      //      _Address.POBoxDeviatingRegion,

      //      _Address.POBoxDeviatingCountry,

      //      _Address.DeliveryServiceTypeCode,

      //      _Address.DeliveryServiceNumber,

      //      _Address.AddressTimeZone,

      //      _Address.FullName,

      //      _Address.CityName,

      //      _Address.District,

      //      _Address.CityCode,

      //      _Address.HomeCityName,

      //      _Address.PostalCode,

      //      _Address.CompanyPostalCode,

      //      _Address.StreetName,

      //      _Address.StreetPrefixName,

      //      _Address.AdditionalStreetPrefixName,

      //      _Address.StreetSuffixName,

      //      _Address.HouseNumber,

      //      _Address.HouseNumberSupplementText,

      //      _Address.Building,

      //      _Address.Floor,

      //      _Address.RoomNumber,

      //      _Address.Country,

      //      _Address.Region,

      //      _Address.County,

      //      _Address.FormOfAddress,

      //      _Address.BusinessPartnerName1,

      //      _Address.BusinessPartnerName2,

      //      _Address.Nation,

      //      _Address.PhoneNumber,

      //      _Address.FaxNumber,

      //      _Address.SearchTerm1,

      //      _Address.StreetSearch,

      //      _Address.CitySearch,

      //      _Address.BusinessPartnerName3,

      //      _Address.BusinessPartnerName4,

      //      _Address.TaxJurisdiction,

      //      _Address.TransportZone,

      //      _Address.Person,

      //

      //      //Associations

      //      _Address._FormOfAddress,

      //      _Address._Region,


      // 2308CL : Use new address interface

      _OrganizationAddress.CareOfName,
      _OrganizationAddress.StreetSuffixName2            as AdditionalStreetSuffixName,
      _OrganizationAddress.CorrespondenceLanguage,
      _OrganizationAddress.PrfrdCommMediumType,
      _OrganizationAddress.POBox,
      _OrganizationAddress.POBoxIsWithoutNumber,
      _OrganizationAddress.POBoxPostalCode,
      _OrganizationAddress.POBoxLobbyName,
      _OrganizationAddress.POBoxDeviatingCityName,
      _OrganizationAddress.POBoxDeviatingRegion,
      _OrganizationAddress.POBoxDeviatingCountry,
      _OrganizationAddress.DeliveryServiceTypeCode,
      _OrganizationAddress.DeliveryServiceNumber,
      _OrganizationAddress.AddressTimeZone,
      _OrganizationAddress.AddresseeFullName            as FullName,
      _OrganizationAddress.CityName,
      _OrganizationAddress.DistrictName                 as District,
      _OrganizationAddress.CityNumber                   as CityCode,
      _OrganizationAddress.VillageName                  as HomeCityName,
      _OrganizationAddress.PostalCode,
      _OrganizationAddress.CompanyPostalCode,
      _OrganizationAddress.StreetName,
      _OrganizationAddress.StreetPrefixName1            as StreetPrefixName,
      _OrganizationAddress.StreetPrefixName2            as AdditionalStreetPrefixName,
      _OrganizationAddress.StreetSuffixName1            as StreetSuffixName,
      _OrganizationAddress.HouseNumber,
      _OrganizationAddress.HouseNumberSupplementText,
      _OrganizationAddress.Building,
      _OrganizationAddress.Floor,
      _OrganizationAddress.RoomNumber,
      _OrganizationAddress.Country,
      _OrganizationAddress.Region,
      _OrganizationAddress.SecondaryRegionName          as County,
      _OrganizationAddress.FormOfAddress,
      _OrganizationAddress.AddresseeName1               as BusinessPartnerName1,
      _OrganizationAddress.AddresseeName2               as BusinessPartnerName2,
      _OrganizationAddress.AddressRepresentationCode    as Nation,
      //      cast(coalesce(_OrganizationAddress._CurrentDfltMobilePhoneNumber.PhoneAreaCodeSubscriberNumber,

      //                    _OrganizationAddress._CurrentDfltLandlinePhoneNmbr.PhoneAreaCodeSubscriberNumber ) as ad_tlnmbr preserving type) as PhoneNumber,

      // _OrganizationAddress._PhoneNumber[PhNmbrIsCurrentOverallDefault='X'].PhoneAreaCodeSubscriberNumber as PhoneNumber,

      _PhoneNumber.PhoneAreaCodeSubscriberNumber        as PhoneNumber,
      _CurrentDfltFaxNumber.FaxAreaCodeSubscriberNumber as FaxNumber,
      _OrganizationAddress.AddressSearchTerm1           as SearchTerm1,
      ''                                                as StreetSearch, // To be deleted

      ''                                                as CitySearch, // To be deleted

      _OrganizationAddress.AddresseeName3               as BusinessPartnerName3,
      _OrganizationAddress.AddresseeName4               as BusinessPartnerName4,
      _OrganizationAddress.TaxJurisdiction,
      _OrganizationAddress.TransportZone,
      cast('' as ad_persnum )                           as Person, // This will always be NULL if mapped from organizationAddress


      //Associations

      _OrganizationAddress._FormOfAddress,
      _OrganizationAddress._Region,

      PurchaseReqnItem._Plant.PlantName                 as PlantText

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ADDRCURDEFAULTFAXNUMBER",
"I_ADDRESSPHONENUMBER_2",
"I_ORGANIZATIONADDRESS",
"I_PLANT",
"I_STORAGELOCATIONADDRESS",
"R_PURCHASEREQNITEM"
],
"ASSOCIATED":
[
"I_ADDRCURDEFAULTFAXNUMBER",
"I_ADDRESSPHONENUMBER_2",
"I_FORMOFADDRESS",
"I_ORGANIZATIONADDRESS",
"I_REGION",
"I_STORAGELOCATIONADDRESS"
],
"BASE":
[
"I_ORGANIZATIONADDRESS"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/