R_PurOrderItemDeliveryAddress

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

define view R_PurOrderItemDeliveryAddress
  as select from P_PurOrdItemDeliveryAddress

  association [1..1] to R_PurchaseOrderItem as _PurchaseOrderItem on  $projection.PurchaseOrder     = _PurchaseOrderItem.PurchaseOrder
                                                                  and $projection.PurchaseOrderItem = _PurchaseOrderItem.PurchaseOrderItem
  association [1..1] to I_PurchaseOrder     as _PurchaseOrder     on  $projection.PurchaseOrder = _PurchaseOrder.PurchaseOrder
{

  key P_PurOrdItemDeliveryAddress.PurchaseOrder,
  key P_PurOrdItemDeliveryAddress.PurchaseOrderItem,
  key P_PurOrdItemDeliveryAddress.ItemDeliveryAddressID as DeliveryAddressID,
      
      @Consumption.hidden: true
      P_PurOrdItemDeliveryAddress.StorageLocation,
      @Consumption.hidden: true 
      P_PurOrdItemDeliveryAddress.Plant,

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

      /* Associations */

      _DeliveryAddress,
      _PurchaseOrder,
      _PurchaseOrderItem


      //      // Keys

      //  key AddressID                            as DeliveryAddressID,

      //      AddressUUID                          as DeliveryAddressUUID,

      //

      //      @ObjectModel.foreignKey.association: '_PurchaseOrder'

      //      _PurchaseOrderItem.PurchaseOrder     as PurchaseOrder,

      //

      //      _PurchaseOrderItem.PurchaseOrderItem as PurchaseOrderItem,

      //

      //      // 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,

      //      _PurchaseOrderItem,

      //      _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_PURORDITEMDELIVERYADDRESS"
],
"ASSOCIATED":
[
"I_ADDRCURDEFAULTEMAILADDRESS",
"I_ADDRCURDEFAULTFAXNUMBER",
"I_ADDRCURDFLTLANDLINEPHONENMBR",
"I_ADDRCURDFLTMOBILEPHONENUMBER",
"I_ADDRESSEMAILADDRESS_2",
"I_ADDRESSFAXNUMBER_2",
"I_ADDRESSPHONENUMBER_2",
"I_ADDRESS_2",
"I_COUNTRY",
"I_PURCHASEORDER",
"I_REGION",
"R_PURCHASEORDERITEM"
],
"BASE":
[
"I_ADDRESS_2",
"P_PURORDITEMDELIVERYADDRESS"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/