C_CustInvcItQty

@AbapCatalog.sqlViewName: 'CCUSTINVCITQTY'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@EndUserText.label: 'Customer Invoice Item Quantity'
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.sizeCategory: #XL
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.type: #INHERITED
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.personalData.blocking: #('TRANSACTIONAL_DATA')
define view C_CustInvcItQty as 
// all items of a SD Invoice (billing); only the data which are necessary to determine the following information are selected:

// --- material number, item quantity in document UoM and base UoM, the conversion factors, net value in document currency; concerning

//     the quantities and the net value, the sign is considered depending from the billing category and the 'Returns-Item'-Flag.

// --- Assignment of internal to language dependent Units of Measure (table T006A)


  select from vbrp as sdi_items

// header data:

   association [1..1] to view_sdi_head_p    as sdi_head     on  $projection.BillingDocument = sdi_head.vbeln                                                                                                           
                                                          
// Assign Internal to Language Dependent Unit for Billing Quantity Unit:

   association [0..*] to t006a   as BillingUnitT006A        on  $projection.BillingQuantityUnit = BillingUnitT006A.msehi
 
// Assign Internal to Language Dependent Unit for Base Unit:                                                          

   association [0..*] to t006a   as BaseUnitT006A           on  $projection.BaseUnit = BaseUnitT006A.msehi                                                                                                
  
  { 
    @EndUserText.label: 'Billing Document'
    key sdi_items.vbeln                                                                                         as BillingDocument,
    
    @EndUserText.label: 'Billing Document Item'
    key sdi_items.posnr                                                                                         as BillingDocumentItem,

    @EndUserText.label: 'Material'
    sdi_items.matnr                                                                                             as Material,
    
    @EndUserText.label: 'Billing To Base Quantity Numerator'
    sdi_items.umvkz                                                                                             as BillingToBaseQuantityNmrtr, 
    
    @EndUserText.label: 'Billing To Base Quantity Denominator'
      sdi_items.umvkn                                                                                           as BillingToBaseQuantityDnmntr,
                                                                                                                  
    @Semantics.unitOfMeasure sdi_items.vrkme                                                                    as BillingQuantityUnit,
                    
    @EndUserText.label: 'Billing Quantity Unit'                                                                                                
    BillingUnitT006A                                                                                            as BillingUnitT006A,
        
    @Semantics.unitOfMeasure sdi_items.meins                                                                    as BaseUnit,
        
    @EndUserText.label: 'Base Unit'
    BaseUnitT006A                                                                                               as BaseUnitT006A,
       
    @EndUserText.label: 'Billing Document Currency'    
    @Semantics.currencyCode sdi_head.waerk                                                                      as BillingDocumentCurrency,
    
    @Semantics.quantity.unitOfMeasure: 'BillingQuantityUnit'
    @EndUserText.label:'Billing Quantity'
    sdi_items.fkimg                                                                                             as BillingQuantity, 
    
    @Semantics.quantity.unitOfMeasure: 'BaseUnit'
    sdi_items.fklmg                                                                                             as BillingQuantityInBaseUnit,
   
    @Semantics.amount.currencyCode: 'BillingDocumentCurrency'
    @EndUserText.label:'Item Net Amount of Billing Document'
    sdi_items.netwr                                                                                             as ItemNetAmountOfBillingDoc,
                         
    sdi_items.shkzg                                                                                             as shkzg,
    sdi_head.vbtyp                                                                                              as vbtyp

  }
  
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"VIEW_SDI_HEAD_P",
"VBRP"
],
"ASSOCIATED":
[
"VIEW_SDI_HEAD_P",
"T006A"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/