P_WBRK_B_2_UC10_ValueHelp

@AbapCatalog.sqlViewName: 'PWBRKB2UC10VH'
@VDM.viewType: #BASIC
@VDM.private: true
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.sizeCategory: #XXL
@ClientHandling.type: #INHERITED
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #MANDATORY
@AbapCatalog.preserveKey: true
//Value help for Settlement Management Documents with Cat. B and Use-Case 10

define view P_WBRK_B_2_UC10_ValueHelp

  as select from wbrk
     inner join P_WBRK_Begru_Values on wbrk.wbeln = P_WBRK_Begru_Values.wbeln

{
  key wbrk.wbeln                          as wbeln,
      wbrk.wrart                          as wrart,
      wbrk.lnrzb                          as lnrzb,
      wbrk.kunrg                          as kunrg,
      wbrk.ekorg                          as ekorg,
      wbrk.ekgrp                          as ekgrp,
      wbrk.vkorg                          as vkorg,
      wbrk.vtweg                          as vtweg,
      wbrk.spart                          as spart,
      wbrk.wfdat                          as wfdat,
      wbrk.bukrs                          as bukrs,
      wbrk.erdat                          as erdat,
      wbrk.ernam                          as ernam,
      wbrk.lifre                          as lifre,
      wbrk.xblnr                          as xblnr,
      wbrk.kunre                          as kunre,
      wbrk.zuonr                          as zuonr,
      wbrk.bldat                          as bldat,
      wbrk.lfart                          as lfart,
      wbrk.rfbsk                          as rfbsk,
      P_WBRK_Begru_Values.lifre_begru     as lifre_begru,
      P_WBRK_Begru_Values.lifnr_fi_begru  as lifnr_fi_begru,
      P_WBRK_Begru_Values.lnrzb_begru     as lnrzb_begru,
      P_WBRK_Begru_Values.kunre_begru     as kunre_begru,
      P_WBRK_Begru_Values.kunrg_begru     as kunrg_begru
}
where
      wdtyp    = 'B'
  and use_case = '10'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_WBRK_BEGRU_VALUES",
"WBRK"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/