C_CustRetItemCustomer

@AbapCatalog.sqlViewName: 'CCRTITMCUST'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@VDM.viewType: #CONSUMPTION
@ClientHandling.algorithm:#SESSION_VARIABLE
@EndUserText.label: 'Returns Order Item Partner'
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED

define view C_CustRetItemCustomer
  as select from I_CustomerReturnItem as CustomerReturnItem
  
  left outer to many join I_SalesDocItemCompletePartner as ItemCompletePartner     on CustomerReturnItem.CustomerReturn     = ItemCompletePartner.SalesDocument
                                                                                  and CustomerReturnItem.CustomerReturnItem = ItemCompletePartner.SalesDocumentItem
  
  association [0..1] to C_SDDocumentPartnerCard         as _SDDocumentPartnerCard  on $projection.CustomerReturn            = _SDDocumentPartnerCard.SDDocument
                                                                                  and $projection.CustomerReturnItem        = _SDDocumentPartnerCard.SDDocumentItem
                                                                                  and $projection.PartnerFunction           = _SDDocumentPartnerCard.PartnerFunction
            
  association [0..1] to I_Customer                      as _Customer               on $projection.Customer                  = _Customer.Customer
  association [0..*] to I_PartnerFunctionText           as _PartnerFunctionText    on $projection.PartnerFunction           = _PartnerFunctionText.PartnerFunction
  
{
  @UI.hidden: true
  key CustomerReturnItem.CustomerReturn,
  key CustomerReturnItem.CustomerReturnItem,
  key ItemCompletePartner.SalesDocumentItem as SDDocumentItem,  
  @ObjectModel.text.association: '_PartnerFunctionText'
  key ItemCompletePartner.PartnerFunction,
  @ObjectModel.text.element:  [ 'CustomerName' ]
  ItemCompletePartner.Customer,
  _SDDocumentPartnerCard.FullName as CustomerName,
  //_ItmPartComplete.FullName                            as CustomerName,

  
  @ObjectModel.virtualElement: true
  @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_CUSTOMER_RETURN_OPG_VE'
  cast('' as ad_hsnm1)                                                   as HouseNumber,
  //ItemCompletePartner._DfltAddrRprstn.HouseNumber,

  //_ItmPartComplete._Address.HouseNumber,

  @ObjectModel.virtualElement: true
  @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_CUSTOMER_RETURN_OPG_VE'
  cast('' as ad_hsnm2)                                                   as HouseNumberSupplementText,
  //ItemCompletePartner._DfltAddrRprstn.HouseNumberSupplementText,

  //_ItmPartComplete._Address.HouseNumberSupplementText,

  @ObjectModel.virtualElement: true
  @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_CUSTOMER_RETURN_OPG_VE'
  cast('' as ad_strnum)                                                  as StreetName,
  //ItemCompletePartner._DfltAddrRprstn.StreetName,

  //_ItmPartComplete._Address.StreetName,

  @ObjectModel.virtualElement: true
  @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_CUSTOMER_RETURN_OPG_VE'
  cast('' as ad_pstcd1)                                                  as PostalCode,
  //ItemCompletePartner._DfltAddrRprstn.PostalCode,

  //_ItmPartComplete._Address.PostalCode,

  @ObjectModel.virtualElement: true
  @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_CUSTOMER_RETURN_OPG_VE'
  cast('' as ad_city1)                                                   as CityName,
  //ItemCompletePartner._DfltAddrRprstn.CityName,

  //_ItmPartComplete._Address.CityName,

  @ObjectModel.virtualElement: true
  @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_CUSTOMER_RETURN_OPG_VE'
  cast('' as land1)                                                   as Country,
  //ItemCompletePartner._DfltAddrRprstn.Country,

  //_ItmPartComplete._Address.Country,   

  
  ItemCompletePartner.PartnerIsSpecificForSDDocItem,

  // For Access Control

  @Consumption.hidden: true
  @UI.hidden: true
  _CustomerReturn.CustomerReturnType,
  @Consumption.hidden: true
  @UI.hidden: true
  _CustomerReturn.SalesOrganization,
  @Consumption.hidden: true
  @UI.hidden: true
  _CustomerReturn.DistributionChannel,
  @Consumption.hidden: true
  @UI.hidden: true
  _CustomerReturn.OrganizationDivision,
  
   _Customer,
  _PartnerFunctionText
            
}                                                           
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"C_SDDOCUMENTPARTNERCARD",
"I_CUSTOMERRETURN",
"I_CUSTOMERRETURNITEM",
"I_SALESDOCITEMCOMPLETEPARTNER"
],
"ASSOCIATED":
[
"C_SDDOCUMENTPARTNERCARD",
"I_CUSTOMER",
"I_PARTNERFUNCTIONTEXT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/