A_BillingDocReqItemPartner

@ClientHandling.algorithm:#SESSION_VARIABLE
@EndUserText.label: 'Item Partner'
@VDM: {
  viewType: #COMPOSITE,
  lifecycle.contract.type: #PUBLIC_REMOTE_API
}
@AbapCatalog: {
  sqlViewName: 'ASDBDREQITPARTN',
  compiler.compareFilter: true,
  preserveKey:true
}
@AccessControl: { 
  authorizationCheck: #CHECK,
  personalData.blocking: #('TRANSACTIONAL_DATA')
}
@ObjectModel: {
  createEnabled: false,
  updateEnabled: false,
  deleteEnabled: false,
  usageType: {
    dataClass: #TRANSACTIONAL,
    serviceQuality: #C,
    sizeCategory: #XL
  }
} 
@Metadata: {
  ignorePropagatedAnnotations: true
}

define view A_BillingDocReqItemPartner       as select from I_BillingDocReqItemPartner as Partner

  association [1..1] to A_BillingDocumentRequest     as _BillingDocumentRequest     
                                                on  $projection.BillingDocumentRequest = _BillingDocumentRequest.BillingDocumentRequest
                                        
  association [1..1] to A_BillingDocumentRequestItem as _BillingDocumentRequestItem 
                                                on  $projection.BillingDocumentRequest = _BillingDocumentRequestItem.BillingDocumentRequest
                                                    and $projection.BillingDocumentRequestItem = _BillingDocumentRequestItem.BillingDocumentRequestItem
  association [0..1] to I_BusPartAddress         as _BusinessPartnerAddressCP      on Partner.AddressID                  = _BusinessPartnerAddressCP.AddressID
                                                                                    and $projection.ContactPerson is not initial
                                                                                    and Partner.SDDocPartnerAddressRefType =  'I'

{
  
  //key cast(SDDocument as vbeln_vf preserving type) as BillingDocument,

  key BillingDocumentRequest,
  
  //key cast(SDDocumentItem as posnr_vf preserving type) as BillingDocumentItem,

  key BillingDocumentRequestItem,

  // To stay compatible: Cast to the original data element which uses a conversion routine (in principle this is bug!) 

      @ObjectModel.sapObjectNodeTypeReference: 'PartnerFunction'      
  key cast(PartnerFunction as parvw preserving type ) as PartnerFunction,    
  

      Customer,

      Supplier,

      Personnel,

      ContactPerson,
      
      @Feature: 'SW:Q2C_MULTIPLE_BP_ADDRESSES, SW:Q2C_MULTIPLE_BP_ADDRESSES2'
      case ContactPerson
        when '0000000000' then
         _BusinessPartnerAddress.AddressUUID
       else
         _BusinessPartnerAddressCP.AddressUUID
                                                    end as BusinessPartnerAddressUUID,
      
      @Feature: 'SW:Q2C_MULTIPLE_BP_ADDRESSES, SW:Q2C_MULTIPLE_BP_ADDRESSES2'
      @ObjectModel.readOnly: true  
      _BPRefAddressForDocSpcfcAddr.AddressUUID  as BPRefAddrForDocSpcfcAddrUUID,
      

      // For Access control

      @Consumption.hidden: true
      _BillingDocumentRequest.BillingDocumentRequestType, // as BillingDocumentType,

      @Consumption.hidden: true
      _BillingDocumentRequest.SalesOrganization, //

     

      //Expose associations

      _BillingDocumentRequest,
      _BillingDocumentRequestItem
}
//where I_BillingDocItemPartner._BillingDocument.BillingDocumentIsTemporary = ' '

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"A_BILLINGDOCUMENTREQUEST",
"I_BILLINGDOCREQITEMPARTNER",
"I_BUSPARTADDRESS"
],
"ASSOCIATED":
[
"A_BILLINGDOCUMENTREQUEST",
"A_BILLINGDOCUMENTREQUESTITEM",
"I_BUSPARTADDRESS"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/