I_Purctraddressint

@AbapCatalog.sqlViewName: 'IPURADDRESS'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Purchase Contract Address Information'
@VDM.viewType: #COMPOSITE
@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass: #MIXED

@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED

define view I_Purctraddressint
  as select from    I_PurchaseContractItem
    left outer join I_Address_2 on I_PurchaseContractItem.ManualDeliveryAddressID    = I_Address_2.AddressID
                              or I_PurchaseContractItem.ReferenceDeliveryAddressID = I_Address_2.AddressID
    //Added association for DCL inheritence

   association [1..1] to I_PurchaseContract     as _PurchaseContract     on  _PurchaseContract.PurchaseContract = $projection.PurchaseContract                          
  //  as select from    I_Address

  //    left outer join I_PurchaseContractItem on I_Address.AddressID = I_PurchaseContractItem.ManualDeliveryAddressID

  //                                           or I_Address.AddressID = I_PurchaseContractItem.ReferenceDeliveryAddressID

{
  key I_PurchaseContractItem.PurchaseContractItem,
  key I_Address_2.AddressID,
  key I_PurchaseContractItem.PurchaseContract,

      I_PurchaseContractItem.Plant,
      I_Address_2.CareOfName,
      I_Address_2.StreetSuffixName2 as AdditionalStreetSuffixName,
      I_Address_2.CorrespondenceLanguage,
      I_Address_2.PrfrdCommMediumType,
      I_Address_2.POBox,
      I_Address_2.POBoxIsWithoutNumber,
      I_Address_2.POBoxPostalCode,
      I_Address_2.POBoxLobbyName,
      I_Address_2.POBoxDeviatingCityName,
      I_Address_2.POBoxDeviatingRegion,
      I_Address_2.POBoxDeviatingCountry,
      I_Address_2.DeliveryServiceTypeCode,
      I_Address_2.DeliveryServiceNumber,
      I_Address_2.AddressTimeZone,
      I_Address_2.AddresseeFullName as FullName,
      I_Address_2.CityName,
      I_Address_2.DistrictName as District,
      I_Address_2.CityNumber as CityCode,
      I_Address_2.CityName as HomeCityName,
      I_Address_2.PostalCode,
      I_Address_2.CompanyPostalCode,
      I_Address_2.StreetName,
      I_Address_2.StreetPrefixName1 as  StreetPrefixName,
      I_Address_2.StreetPrefixName2 as  AdditionalStreetPrefixName,
      I_Address_2.StreetSuffixName1 as StreetSuffixName,
      I_Address_2.HouseNumber,
      I_Address_2.HouseNumberSupplementText,
      I_Address_2.Building,
      I_Address_2.Floor,
      I_Address_2.RoomNumber,
      I_Address_2.Country,
      I_Address_2.Region,
      I_Address_2.SecondaryRegionName as County,
      I_Address_2.FormOfAddress,
      I_Address_2.OrganizationName3                                 as ConsigneeName3,
      I_Address_2.OrganizationName4                                 as ConsigneeName4,
      I_Address_2.TaxJurisdiction,
      I_Address_2.TransportZone,
      //  cast('' as VDM_PURCHASECONTRACT) as PurchaseContract,

      //  cast('' as VDM_PURCHASECONTRACTITEM) as PurchaseContractItem,

      //  _PurchaseContractItem.PurchaseContract as PurchaseCon7tract,

      //  _PurchaseContractItem.PurchaseContractItem as PurchaseContractItem,

      I_Address_2._CurrentDfltLandlinePhoneNmbr.PhoneAreaCodeSubscriberNumber as PhoneNumber,
      I_Address_2._CurrentDfltMobilePhoneNumber.PhoneAreaCodeSubscriberNumber as MobilePhoneNumber,
      I_Address_2._CurrentDfltFaxNumber.FaxAreaCodeSubscriberNumber           as FaxNumber,
      I_Address_2._CurrentDfltEmailAddress.EmailAddress,
      I_Address_2._Country,
      I_Address_2._Region,
      _PurchaseContract
}
where
  I_Address_2.AddressID <> '' 
  
  
  
  
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ADDRCURDEFAULTEMAILADDRESS",
"I_ADDRCURDEFAULTFAXNUMBER",
"I_ADDRCURDFLTLANDLINEPHONENMBR",
"I_ADDRCURDFLTMOBILEPHONENUMBER",
"I_ADDRESS_2",
"I_PURCHASECONTRACTITEM"
],
"ASSOCIATED":
[
"I_COUNTRY",
"I_PURCHASECONTRACT",
"I_REGION"
],
"BASE":
[
"I_ADDRESS_2"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/