R_PPS_PurContrDelivAddressTP

@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.personalData.blocking: #REQUIRED
@EndUserText.label: 'Purchase Contract Address'
@VDM.viewType: #TRANSACTIONAL
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@ObjectModel.semanticKey:  [ 'PurchaseContract','PurchaseContractItem' ]
@ObjectModel.usageType:{
  serviceQuality: #D,
  sizeCategory: #XL,
  dataClass: #MIXED
}
@Metadata.ignorePropagatedAnnotations: true
//BoC  @JIRA-KEY:S4PPS-4885

define view entity R_PPS_PurContrDelivAddressTP
  as select from I_PurCtrAddress
  association to parent R_PPS_PurchaseContractItemTP as _PurchaseContractItem on  _PurchaseContractItem.PurchaseContractItem = $projection.PurchaseContractItem
                                                                              and _PurchaseContractItem.PurchaseContract     = $projection.PurchaseContract
  association to R_PPS_PurchaseContractTP            as _PurchaseContract     on  _PurchaseContract.PurchaseContract = $projection.PurchaseContract
  //  association [1..1] to P_PPS_PurContrControlFlag           as _ControlFlag          on  $projection.PurchaseContract = _ControlFlag.Purchasecontract

  //                                                                                     and $projection.PurchaseContractItem = _ControlFlag.Purchasecontractitem

{
      @ObjectModel.foreignKey.association: '_PurchaseContract'
  key PurchaseContract,
      @ObjectModel.foreignKey.association: '_PurchaseContractItem'
  key PurchaseContractItem,
  key AddressID,
      Plant,
      CareOfName,
      AdditionalStreetSuffixName,
      CorrespondenceLanguage,
      PrfrdCommMediumType,
      POBox,
      POBoxIsWithoutNumber,
      POBoxPostalCode,
      POBoxLobbyName,
      POBoxDeviatingCityName,
      POBoxDeviatingRegion,
      POBoxDeviatingCountry,
      DeliveryServiceTypeCode,
      DeliveryServiceNumber,
      AddressTimeZone,
      FullName,
      CityName,
      District                             as DistrictName,
      CityCode                             as ProcmtHubCityCode,
      HomeCityName,
      PostalCode,
      CompanyPostalCode,
      StreetName,
      StreetPrefixName,
      AdditionalStreetPrefixName,
      StreetSuffixName,
      HouseNumber,
      HouseNumberSupplementText,
      Building,
      Floor,
      RoomNumber,
      Country,
      Region,
      County                               as PurContrCountyText,
      FormOfAddress,
      ConsigneeName3,
      ConsigneeName4,
      TaxJurisdiction,
      TransportZone,
      PhoneNumber,
      MobilePhoneNumber,
      FaxNumber                            as AddressFaxNumber,
      EmailAddress,
      @Semantics.systemDateTime.lastChangedAt: true
      _PurchaseContract.LastChangeDateTime as LastChangeDateTime,

      // _ControlFlag.Control                                                        as ControlFlags,

//       cast ( hextobin( '00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000' ) as pps_e_control_flag preserving type )

//                                                                                                as ControlFlags,

 //     cast ( hextobin( '00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000' ) as pps_e_control_flag preserving type ) as PPSFieldChangeIndicatorBinary,

      cast ( hextobin( _PurchaseContract.PPSFieldChangeIndicatorString ) as pps_e_control_flag preserving type )  as PPSFieldChangeIndicatorBinary,
      /* Associations */
      _PurchaseContract,
      _PurchaseContractItem
}
//EoC  @JIRA-KEY:S4PPS-4885

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PURCTRADDRESS",
"R_PPS_PURCHASECONTRACTTP"
],
"ASSOCIATED":
[
"R_PPS_PURCHASECONTRACTITEMTP",
"R_PPS_PURCHASECONTRACTTP"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/