I_BPRelshpCntctPersnAddressTP

@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED
@EndUserText.label: 'RAPBO view for BP Contact Person Address'
//@AccessControl.privilegedAssociations:  [ '_BPDataControllerUsage1','_BPDataControllerUsage2' ]

@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass: #MASTER
@Search.searchable: true
@VDM.viewType: #TRANSACTIONAL
define view entity I_BPRelshpCntctPersnAddressTP
  as select from P_BPContactToAddress

  association [1] to I_BPRelshpContactPersonTP      as _BPRelshpContactPerson  
//                                                                                  on  $projection.BPDrftUUID           = _BPRelshpContactPerson.BPDrftUUID

//                                                                                  and $projection.BPRelshpUUID         = _BPRelshpContactPerson.BPRelshpUUID                                                                                  

                                                                                  on $projection.BusinessPartner1     = _BPRelshpContactPerson.BusinessPartner1
                                                                                  and $projection.BusinessPartner2     = _BPRelshpContactPerson.BusinessPartner2
                                                                                  and $projection.ValidityEndDate      = _BPRelshpContactPerson.ValidityEndDate
                                                                                  and $projection.RelationshipCategory = _BPRelshpContactPerson.RelationshipCategory
                                                                                  and $projection.BPRelshpCatIsInFwdDirection = _BPRelshpContactPerson.BPRelshpCatIsInFwdDirection

  association      to parent I_BusPartRelationshipTP as _BusPartRelationship    
//                                                                                  on  $projection.BPDrftUUID           = _BusPartRelationship.BPDrftUUID

//                                                                                  and $projection.BPRelshpUUID         = _BusPartRelationship.BPRelshpUUID

                                                                                  on $projection.BusinessPartner1     = _BusPartRelationship.BusinessPartner1
                                                                                  and $projection.BusinessPartner2     = _BusPartRelationship.BusinessPartner2
                                                                                  and $projection.ValidityEndDate      = _BusPartRelationship.ValidityEndDate
                                                                                  and $projection.RelationshipCategory = _BusPartRelationship.RelationshipCategory
                                                                                  and $projection.BPRelshpCatIsInFwdDirection = _BusPartRelationship.BPRelshpCatIsInFwdDirection
                                                                             
  composition [0..*] of I_BPRelshpCntctPersnAddrVersTP as _BPRelshpCntctPersnAddrVers

  composition [0..*] of I_BPRelshpCntctPersnEmlAddrTP  as _BPRelshpCntctPersnEmlAddr

  composition [0..*] of I_BPRelshpCntctPersnTelNmbrTP  as _BPRelshpCntctPersnTelNmbr

  composition [0..*] of I_BPRelshpCntctPersnMblNmbrTP  as _BPRelshpCntctPersnMblNmbr

  composition [0..*] of I_BPRelshpCntctPersnFaxNmbrTP  as _BPRelshpCntctPersnFaxNmbr

  composition [0..*] of I_BPRelshpCntctPersnWbsteURLTP as _BPRelshpCntctPersnWbsteURL
  
  association [0..1] to I_BPRelshpCntctPersnTelNmbrTP  as _BPRelStandardTelNumber 
//                                                                                  on  $projection.BPDrftUUID                       = _BPRelStandardTelNumber.BPDrftUUID

//                                                                                  and $projection.BPRelshpUUID                     = _BPRelStandardTelNumber.BPRelshpUUID

//                                                                                  and $projection.BPRelshpCntctPersnAddrUUID       = _BPRelStandardTelNumber.BPRelshpCntctPersnAddrUUID

                                                                                  on   $projection.BusinessPartner1                 = _BPRelStandardTelNumber.BusinessPartner1
                                                                                  and $projection.BusinessPartner2                 = _BPRelStandardTelNumber.BusinessPartner2
                                                                                  and $projection.ValidityEndDate                  = _BPRelStandardTelNumber.ValidityEndDate
                                                                                  and $projection.RelationshipCategory             = _BPRelStandardTelNumber.RelationshipCategory
                                                                                  and $projection.AddressID                        = _BPRelStandardTelNumber.AddressID
                                                                                  and $projection.BPRelshpCatIsInFwdDirection = _BPRelStandardTelNumber.BPRelshpCatIsInFwdDirection
                                                                                  and _BPRelStandardTelNumber.PhoneNumberType      = '1'
                                                                                  and _BPRelStandardTelNumber.IsDefaultPhoneNumber = 'X'
 association [0..1] to I_BPRelshpCntctPersnMblNmbrTP  as _BPRelStandardMblNumber 
//                                                                                  on  $projection.BPDrftUUID                        = _BPRelStandardMblNumber.BPDrftUUID

//                                                                                  and $projection.BPRelshpUUID                     = _BPRelStandardMblNumber.BPRelshpUUID

//                                                                                  and $projection.BPRelshpCntctPersnAddrUUID       = _BPRelStandardMblNumber.BPRelshpCntctPersnAddrUUID

                                                                                  on $projection.BusinessPartner1                 = _BPRelStandardMblNumber.BusinessPartner1
                                                                                  and $projection.BusinessPartner2                 = _BPRelStandardMblNumber.BusinessPartner2
                                                                                  and $projection.ValidityEndDate                  = _BPRelStandardMblNumber.ValidityEndDate
                                                                                  and $projection.RelationshipCategory             = _BPRelStandardMblNumber.RelationshipCategory
                                                                                  and $projection.AddressID                        = _BPRelStandardMblNumber.AddressID
                                                                                  and $projection.BPRelshpCatIsInFwdDirection      = _BPRelStandardMblNumber.BPRelshpCatIsInFwdDirection
                                                                                  and _BPRelStandardMblNumber.PhoneNumberType      = '3'
                                                                                  and _BPRelStandardMblNumber.IsDefaultPhoneNumber = 'X' 
association [0..1] to I_BPRelshpCntctPersnFaxNmbrTP  as _BPRelStandardFaxNmbr     
//                                                                                  on  $projection.BPDrftUUID                       = _BPRelStandardFaxNmbr.BPDrftUUID

//                                                                                  and $projection.BPRelshpUUID                     = _BPRelStandardFaxNmbr.BPRelshpUUID

//                                                                                  and $projection.BPRelshpCntctPersnAddrUUID       = _BPRelStandardFaxNmbr.BPRelshpCntctPersnAddrUUID

                                                                                  on $projection.BusinessPartner1                 = _BPRelStandardFaxNmbr.BusinessPartner1
                                                                                  and $projection.BusinessPartner2                 = _BPRelStandardFaxNmbr.BusinessPartner2
                                                                                  and $projection.ValidityEndDate                  = _BPRelStandardFaxNmbr.ValidityEndDate
                                                                                  and $projection.RelationshipCategory             = _BPRelStandardFaxNmbr.RelationshipCategory
                                                                                  and $projection.AddressID                        = _BPRelStandardFaxNmbr.AddressID           
                                                                                  and $projection.BPRelshpCatIsInFwdDirection = _BPRelStandardFaxNmbr.BPRelshpCatIsInFwdDirection                                                                       
                                                                                  and _BPRelStandardFaxNmbr.IsDefaultFaxNumber = 'X'     
association [0..1] to I_BPRelshpCntctPersnEmlAddrTP  as _BPRelStandardEmlAddr   
//                                                                                  on  $projection.BPDrftUUID                         = _BPRelStandardEmlAddr.BPDrftUUID

//                                                                                  and $projection.BPRelshpUUID                     = _BPRelStandardEmlAddr.BPRelshpUUID

//                                                                                  and $projection.BPRelshpCntctPersnAddrUUID       = _BPRelStandardEmlAddr.BPRelshpCntctPersnAddrUUID

                                                                                  on $projection.BusinessPartner1                 = _BPRelStandardEmlAddr.BusinessPartner1
                                                                                  and $projection.BusinessPartner2                 = _BPRelStandardEmlAddr.BusinessPartner2
                                                                                  and $projection.ValidityEndDate                  = _BPRelStandardEmlAddr.ValidityEndDate
                                                                                  and $projection.RelationshipCategory             = _BPRelStandardEmlAddr.RelationshipCategory
                                                                                  and $projection.AddressID                        = _BPRelStandardEmlAddr.AddressID     
                                                                                  and $projection.BPRelshpCatIsInFwdDirection = _BPRelStandardEmlAddr.BPRelshpCatIsInFwdDirection                                                                             
                                                                                  and _BPRelStandardEmlAddr.IsDefaultEmailAddress = 'X'    
// association [0..*] to I_BPDataControllerUsage as _BPDataControllerUsage1 on  $projection.BusinessPartner1 = _BPDataControllerUsage1.BusinessPartner

// association [0..*] to I_BPDataControllerUsage as _BPDataControllerUsage2 on  $projection.BusinessPartner2 = _BPDataControllerUsage2.BusinessPartner     

{

//  key cast ( hextobin('00000000000000000000000000000000') as sysuuid_x )                                                                         as BPDrftUUID,

//  key cast ( hextobin('00000000000000000000000000000000') as sysuuid_x )                                                                         as BPRelshpUUID,

//  key cast ( hextobin('00000000000000000000000000000000') as sysuuid_x )                                                                         as BPRelshpCntctPersnAddrUUID,

      @Search.defaultSearchElement: true
  key P_BPContactToAddress.BusinessPartnerCompany                                                                                                as BusinessPartner1,
      @Search.defaultSearchElement: true
  key P_BPContactToAddress.BusinessPartnerPerson                                                                                                 as BusinessPartner2,
  key cast( P_BPContactToAddress.ValidityEndDate as abap.char( 17 ))                                                                             as ValidityEndDate,
  key P_BPContactToAddress.RelationshipCategory                                                                                                  as RelationshipCategory,
  key P_BPContactToAddress.AddressID,
  key P_BPContactToAddress.BPRelshpCatIsInFwdDirection,
      P_BPContactToAddress.AddressID                                                                                                             as AddressIDForEdit,
      @Search.defaultSearchElement: true
      P_BPContactToAddress.RelationshipNumber,
      P_BPContactToAddress.IsDefaultAddress,
      P_BPContactToAddress.ContactRelationshipFunction,
      P_BPContactToAddress.ContactRelationshipDepartment,
      P_BPContactToAddress.Floor,
      P_BPContactToAddress.Building,
      P_BPContactToAddress.RoomNumber,
      P_BPContactToAddress.PrfrdCommMediumType,
      P_BPContactToAddress.CorrespondenceShortName,
      P_BPContactToAddress.InhouseMail,

      concat_with_space(P_BPContactToAddress._BPCompanyPostalAddress.HouseNumber,
      concat_with_space(P_BPContactToAddress._BPCompanyPostalAddress.StreetName,
      concat_with_space(P_BPContactToAddress._BPCompanyPostalAddress.CityName,
      concat_with_space(P_BPContactToAddress._BPCompanyPostalAddress.PostalCode,P_BPContactToAddress._BPCompanyPostalAddress.Country,1),1),1),1) as FormattedAddress,
      P_BPContactToAddress._BPCompanyPostalAddress.FormOfAddress,
      P_BPContactToAddress._BPCompanyPostalAddress.FullName,
      P_BPContactToAddress._BPCompanyPostalAddress.HouseNumber,
      P_BPContactToAddress._BPCompanyPostalAddress.StreetName,
      P_BPContactToAddress._BPCompanyPostalAddress.CityName,
      P_BPContactToAddress._BPCompanyPostalAddress.PostalCode,
      P_BPContactToAddress._BPCompanyPostalAddress.Region,
      P_BPContactToAddress._BPCompanyPostalAddress.Country,
      P_BPContactToAddress._BPCompanyPostalAddress.AddressTimeZone,
     // P_BpContactToAddress.BPRelshpCatIsInFwdDirection,

      P_BPContactToAddress.RelValidityEndDate,
      /* Associations */
      P_BPContactToAddress._BusinessPartnerCompany              as _BusinessPartner1,
      P_BPContactToAddress._BusinessPartnerPerson               as _BusinessPartner2 ,
      _BPRelshpContactPerson,
      _BusPartRelationship,
      _BPRelshpCntctPersnEmlAddr,
      _BPRelshpCntctPersnTelNmbr,
      _BPRelshpCntctPersnMblNmbr,
      _BPRelshpCntctPersnFaxNmbr,
      _BPRelshpCntctPersnWbsteURL,
      _BPRelshpCntctPersnAddrVers,
      _BPRelStandardTelNumber,
      _BPRelStandardMblNumber,
      _BPRelStandardFaxNmbr,
      _BPRelStandardEmlAddr
      
//      _BPDataControllerUsage1,

//      _BPDataControllerUsage2

}
//where

//  P_BpContactToAddress.AddressRepresentationCode = ' '

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BUSINESSPARTNERADDRESS",
"P_BPCONTACTTOADDRESS"
],
"ASSOCIATED":
[
"I_BPRELSHPCNTCTPERSNADDRVERSTP",
"I_BPRELSHPCNTCTPERSNEMLADDRTP",
"I_BPRELSHPCNTCTPERSNFAXNMBRTP",
"I_BPRELSHPCNTCTPERSNMBLNMBRTP",
"I_BPRELSHPCNTCTPERSNTELNMBRTP",
"I_BPRELSHPCNTCTPERSNWBSTEURLTP",
"I_BPRELSHPCONTACTPERSONTP",
"I_BUSINESSPARTNER",
"I_BUSPARTRELATIONSHIPTP"
],
"BASE":
[
"P_BPCONTACTTOADDRESS"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/