R_SrvcQtanItemPartnerAddressTP

@AccessControl: {
  authorizationCheck: #MANDATORY,
  personalData.blocking: #('TRANSACTIONAL_DATA')
}
@VDM: {
  viewType: #TRANSACTIONAL,
  lifecycle.contract.type: #SAP_INTERNAL_API
}
@Metadata:
{
  ignorePropagatedAnnotations: true
}
@EndUserText.label: 'Prtn Addr For Service Quotation Item-TP'
@ObjectModel: {
   usageType: {dataClass:      #TRANSACTIONAL,
                serviceQuality: #C,
                sizeCategory:   #L}
}
define view entity R_SrvcQtanItemPartnerAddressTP
  as select from R_SrvcDocItemPartnerAddress as ServicePartnerAddress
    inner join   I_ServiceDocumentItem       as ServiceOrderItem on  ServicePartnerAddress.ServiceDocument           = ServiceOrderItem.ServiceDocument
                                                                 and ServicePartnerAddress.ServiceDocumentItem       = ServiceOrderItem.ServiceDocumentItem
                                                                 and ServiceOrderItem.ServiceObjectType              = 'BUS2000116'
                                                                 and ServiceOrderItem.ServiceDocumentItemIsQuotation is not initial

  association        to parent R_SrvcQtanItemPartnerTP as _SrvcQtanItemPartnerTP on  $projection.ServiceQuotation        = _SrvcQtanItemPartnerTP.ServiceQuotation
                                                                                 and $projection.ServiceQuotationItem    = _SrvcQtanItemPartnerTP.ServiceQuotationItem
                                                                                 and $projection.CustMgmtPartnerFunction = _SrvcQtanItemPartnerTP.CustMgmtPartnerFunction
                                                                                 and $projection.CustMgmtBusinessPartner = _SrvcQtanItemPartnerTP.CustMgmtBusinessPartner
  association [0..1] to R_ServiceQuotationTP           as _ServiceQuotationTP    on  $projection.ServiceQuotation = _ServiceQuotationTP.ServiceQuotation

{
      @ObjectModel.foreignKey.association: '_ServiceQuotationTP'
  key ServicePartnerAddress.ServiceDocument     as ServiceQuotation,
  key ServicePartnerAddress.ServiceDocumentItem as ServiceQuotationItem,
  key ServicePartnerAddress.CustMgmtPartnerFunction,
  key ServicePartnerAddress.CustMgmtBusinessPartner,
      ServicePartnerAddress.CityName,
      ServicePartnerAddress.CorrespondenceLanguage,
      ServicePartnerAddress.Country,
      ServicePartnerAddress.DistrictName,
      ServicePartnerAddress.EmailAddress,
      ServicePartnerAddress.FaxAreaCodeSubscriberNumber,
      ServicePartnerAddress.FaxExtensionNumber,
      ServicePartnerAddress.FaxNumberCountry,
      ServicePartnerAddress.FormOfAddress,
      ServicePartnerAddress.HouseNumber,
      ServicePartnerAddress.MobileNumber,
      ServicePartnerAddress.MobilePhoneCountry,
      ServicePartnerAddress.OrganizationName1,
      ServicePartnerAddress.OrganizationName2,
      ServicePartnerAddress.OrganizationName3,
      ServicePartnerAddress.OrganizationName4,
      ServicePartnerAddress.PersonFamilyName,
      ServicePartnerAddress.PersonGivenName,
      ServicePartnerAddress.PhoneExtensionNumber,
      ServicePartnerAddress.PhoneNumber,
      //  PhoneNumberCountry,

      ServicePartnerAddress.POBox,
      ServicePartnerAddress.POBoxPostalCode,
      ServicePartnerAddress.PostalCode,
      ServicePartnerAddress.Region,
      ServicePartnerAddress.StreetName,
      ServicePartnerAddress.StreetPrefixName1,
      ServicePartnerAddress.StreetPrefixName2,
      ServicePartnerAddress.StreetSuffixName1,
      ServicePartnerAddress.StreetSuffixName2,
      ServicePartnerAddress.TaxJurisdiction,
      ServicePartnerAddress.TransportZone,

      //Associations

      _SrvcQtanItemPartnerTP,
      _ServiceQuotationTP
}
where
      ServicePartnerAddress.CustMgmtObjectType  = 'BUS2000116'
  and ServicePartnerAddress.ServiceDocumentItem is not initial