R_CustomerReturnItemPartnerTP

@VDM: {
  lifecycle.contract.type: #SAP_INTERNAL_API,
  viewType: #TRANSACTIONAL
}
@AccessControl: { 
  authorizationCheck: #CHECK,
  personalData.blocking: #('TRANSACTIONAL_DATA'),
  privilegedAssociations: [ '_DfltAddrRprstn' ]
}
@ObjectModel: {
   semanticKey: ['CustomerReturn', 'CustomerReturnItem', 'PartnerFunction'],
   usageType: {
     dataClass: #TRANSACTIONAL,
     serviceQuality: #C,
     sizeCategory: #L
    }
}
@Metadata.ignorePropagatedAnnotations: true
@EndUserText.label: 'Returns Order Item Partner - TP'

define view entity R_CustomerReturnItemPartnerTP 
  as select from I_SalesDocItemCompletePartner    as CustomerReturnItemPartner 
  inner join I_SalesDocumentBasic                 as CustomerReturn     on CustomerReturn.SalesDocument      = CustomerReturnItemPartner.SalesDocument
                                                                       and CustomerReturn.SDDocumentCategory = 'H'
                       
  association to parent R_CustomerReturnItemTP    as _Item              on $projection.CustomerReturn     = _Item.CustomerReturn
                                                                       and $projection.CustomerReturnItem = _Item.CustomerReturnItem
                                                                       
  association [1..1] to R_CustomerReturnTP        as _CustomerReturn    on $projection.CustomerReturn     = _CustomerReturn.CustomerReturn
 
  association [0..1] to I_PartnerFunction         as _PartnerFunction   on  $projection.PartnerFunctionForEdit = _PartnerFunction.PartnerFunction
  
  association [0..1] to I_FormOfAddress           as _FormOfAddress          on  $projection.FormOfAddress = _FormOfAddress.FormOfAddress
  association [0..1] to I_Language                as _CorrespondenceLanguage on  $projection.CorrespondenceLanguage = _CorrespondenceLanguage.Language
  association [0..1] to I_TransportationZone      as _TransportationZone     on  $projection.transportzone = _TransportationZone.TransportZone
                                                                             and $projection.country       = _TransportationZone.CountryCode
  
{

  key cast(CustomerReturnItemPartner.SalesDocument as vdm_customer_return preserving type)          as CustomerReturn,
  
  key cast(CustomerReturnItemPartner.SalesDocumentItem as vdm_customer_return_item preserving type) as CustomerReturnItem,
  
  key cast(CustomerReturnItemPartner.PartnerFunction as parvw_unv preserving type)                  as PartnerFunction,
      @ObjectModel.foreignKey.association: '_PartnerFunction'
      cast(CustomerReturnItemPartner.PartnerFunction as parvw_unv preserving type )                 as PartnerFunctionForEdit,
      
      CustomerReturnItemPartner.Customer,

      CustomerReturnItemPartner.Supplier,

      CustomerReturnItemPartner.Personnel,

      CustomerReturnItemPartner.ContactPerson,

      @ObjectModel.text.element: ['FullName']
      CustomerReturnItemPartner.Partner,
      
      @Semantics.name.fullName: true
      @Semantics.text: true
      CustomerReturnItemPartner.FullName,
      

      _PartnerFunction.SDDocumentPartnerType,
      
       @ObjectModel.foreignKey.association: '_FormOfAddress'
      @Semantics.name.jobTitle: true
      CustomerReturnItemPartner.FormOfAddress,

      @Semantics.address.street: true
      CustomerReturnItemPartner._OrgNamePostalAddress.StreetName,

      @Semantics.address.streetNoNumber: true
      CustomerReturnItemPartner._OrgNamePostalAddress.HouseNumber,

      @Semantics.address.zipCode:true
      CustomerReturnItemPartner._OrgNamePostalAddress.PostalCode,

      @Semantics.address.country:true
      @ObjectModel.foreignKey.association: '_Country'
      CustomerReturnItemPartner._OrgNamePostalAddress.Country,

      @ObjectModel.foreignKey.association: '_Region'
      @Semantics.address.region: true
      CustomerReturnItemPartner._OrgNamePostalAddress.Region,

      CustomerReturnItemPartner._OrgNamePostalAddress.DistrictName,    
      
      @Semantics.address.city:true
      CustomerReturnItemPartner._OrgNamePostalAddress.CityName,

      @Semantics.address.postBox: true
      CustomerReturnItemPartner._OrgNamePostalAddress.POBox,

      @Semantics.address.zipCode:true
      CustomerReturnItemPartner._OrgNamePostalAddress.POBoxPostalCode,
      
      @ObjectModel.foreignKey.association: '_CorrespondenceLanguage'
      CustomerReturnItemPartner.CorrespondenceLanguage,

      CustomerReturnItemPartner._OrgNamePostalAddress.TaxJurisdiction,

      @ObjectModel.foreignKey.association: '_TransportationZone'
      CustomerReturnItemPartner._OrgNamePostalAddress.TransportZone,

      CustomerReturnItemPartner.PartnerIsSpecificForSDDocItem,

      CustomerReturnItemPartner.ReferenceBusinessPartner,

      CustomerReturnItemPartner.AddressID,

      CustomerReturnItemPartner.AddressPersonID,

      CustomerReturnItemPartner.AddressObjectType,

      CustomerReturnItemPartner.SDDocPartnerAddrIsDocSpecific,
      
      CustomerReturnItemPartner.VATRegistration,
      
      @Semantics.text: true
      CustomerReturnItemPartner.UnloadingPointName,
      
      @Semantics.telephone.type: [#WORK]
      CustomerReturnItemPartner.InternationalPhoneNumber,

      @Semantics.telephone.type:  [#CELL]
      CustomerReturnItemPartner.InternationalMobilePhoneNumber,

      @Semantics.eMail.address: true
      @Semantics.eMail.type:  [#WORK]
      CustomerReturnItemPartner.EmailAddress,

      @Consumption.hidden: true
      CustomerReturnItemPartner.SDDocPartnerAddressRefType,
      @Consumption.hidden: true
      CustomerReturnItemPartner.BPAddrDeterminationTransaction,
      @Consumption.hidden: true
      CustomerReturnItemPartner.BPRefAddressIDForDocSpcfcAddr,
            
      @Consumption.hidden: true
      _CustomerReturn.CustomerReturnType,
      @Consumption.hidden: true
      _CustomerReturn.SalesOrganization,
      @Consumption.hidden: true
      _CustomerReturn.DistributionChannel,
      @Consumption.hidden: true
      _CustomerReturn.OrganizationDivision,
      
      //Associations  

      _Item,
      _CustomerReturn,
      _PartnerFunction,
      _CorrespondenceLanguage,
      _TransportationZone,
      _FormOfAddress,
      CustomerReturnItemPartner._ContactPerson,
      CustomerReturnItemPartner._DfltAddrRprstn,
      CustomerReturnItemPartner._BusinessPartnerAddress,
      CustomerReturnItemPartner._BPRefAddressForDocSpcfcAddr,
      CustomerReturnItemPartner._OrgNamePostalAddress._Country,
      CustomerReturnItemPartner._OrgNamePostalAddress._Region
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ADDRORGNAMEPOSTALADDRESS",
"I_PARTNERFUNCTION",
"I_SALESDOCITEMCOMPLETEPARTNER",
"I_SALESDOCUMENTBASIC",
"R_CUSTOMERRETURNTP"
],
"ASSOCIATED":
[
"I_ADDRESS_2",
"I_BUSPARTADDRESS",
"I_CONTACTPERSON",
"I_COUNTRY",
"I_FORMOFADDRESS",
"I_LANGUAGE",
"I_PARTNERFUNCTION",
"I_REGION",
"I_TRANSPORTATIONZONE",
"R_CUSTOMERRETURNITEMTP",
"R_CUSTOMERRETURNTP"
],
"BASE":
[
"I_ADDRORGNAMEPOSTALADDRESS",
"I_SALESDOCITEMCOMPLETEPARTNER"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/