view_ab_items_p

@AbapCatalog.sqlViewName:'CDS_AB_ITEMS_P'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@EndUserText.label: 'Item Related Data of Settlement Management Document'
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.sizeCategory: #XXL
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.type: #INHERITED
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.personalData.blocking: #('TRANSACTIONAL_DATA')
//can have associations to CDS-views with parameters:

define view view_ab_items_p
  as
// all items of an agency business document:

  select from wbrp
// Reason for activity and describing texts (also available on header level):

   association [0..1] to tmlfg              as activity                      on  $projection.lfgru = activity.lfgru
   association [0..*] to tmlfgt             as activity_texts                on  $projection.lfgru = activity_texts.lfgru
// Material group and describing texts:

   association [0..1] to t023               as mat_group                     on  $projection.matkl = mat_group.matkl
   association [0..*] to t023t              as mat_group_texts               on  $projection.matkl = mat_group_texts.matkl
// the associations "VENDOR_SUBRANGE" and "VENDOR_SUBRANGE_TEXTS" are commented because the vendor is needed additionally.

// The vendor is stored on header level (field WBRK-LIFRE). Currently there is no possibility to transfer this vendor

// from outside into this view. Instead of, the view CDS_AB_HD_IT is provided to overcome this issue.

//// Vendor subrange and  describing texts:

//   association [0..*] to WYT1    as vendor_subrange       on $projection.ltsnr = vendor_subrange.ltsnr

//   association [0..*] to WYT1T   as vendor_subrange_texts on $projection.ltsnr = vendor_subrange_texts.ltsnr

// Promotion and describing texts:

//   association [0..1] to wakh               as promotion                     on  $projection.aktnr = promotion.aktnr

//   association [0..*] to wakt               as promotion_texts               on  $projection.aktnr = promotion_texts.aktnr

// join with text description table for domain fixed values for fields of table WBRP:

// domain WB2_WSHKZG_BUSVOL:

   association [0..*] to dd07t              as itemcat_texts                 on  itemcat_texts.domname  = 'WB2_WSHKZG_BUSVOL'
                                                                             and itemcat_texts.as4local = 'A'
// domain WFTYP_V:

   association [0..*] to dd07t              as triggering_doc_category_texts on  $projection.ftypv_v                    = triggering_doc_category_texts.domvalue_l
                                                                             and triggering_doc_category_texts.domname  = 'WFTYP_V'
                                                                             and triggering_doc_category_texts.as4local = 'A'

// display name of prior vendor:

   association [0..1] to view_lfa1_name_p as prior_vendor_name               on $projection.kolif = prior_vendor_name.vendor_account

  { 
   key wbeln                                    ,
   key posnr                                    ,
   matnr                                        ,
   arktx                                        ,
   matkl                                        ,
   werks                                        ,
   charg                                        ,
   mwskz                                        ,
   mwsk2                                        ,
   txjcd                                        ,
   lfgru                                        ,
   customer                                     ,
   itemcat                                      ,
   idnlf                                        ,
   ltsnr                                        ,
   aktnr                                        ,
   ekkol                                        ,
   kolif                                        ,
   kostl                                        ,
   kostld                                       ,
   prctr                                        ,
   prctrd                                       ,
   ftypv_v                                      ,
   wbeln_v                                      ,
   posnr_v                                      ,
   incov_p                                      ,
   inco1_p                                      ,
   inco2_p                                      ,
   inco2_l_p                                    ,
   inco3_l_p                                    ,
   umrez                                        ,
   umren                                        ,
   wfkme                                        ,
   meins                                        ,
   menge                                        ,
   netwr                                        ,
   netwrd                                       ,
   
//Assoziations:

   activity                                     ,
   activity_texts                               ,
   mat_group                                    ,
   mat_group_texts                              ,
//   promotion                                    ,

//   promotion_texts                              ,

   itemcat_texts                                ,
   triggering_doc_category_texts                ,
   prior_vendor_name                            
  } 
         
  
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"WBRP"
],
"ASSOCIATED":
[
"VIEW_LFA1_NAME_P",
"DD07T",
"T023",
"T023T",
"TMLFG",
"TMLFGT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/