P_WBRK_H_2_ACC_ValueHelp

DDL: P_WBRK_H_2_ACC_VALUEHELP SQL: PWBRKH2ACCVH Type: view BASIC

P_WBRK_H_2_ACC_ValueHelp is a Basic CDS View in SAP S/4HANA. It reads from 2 data sources (P_WBRK_Begru_Values, wbrk) and exposes 18 fields with key field wbeln.

2 data source(s) 18 fields

Data Sources (2)

SourceAliasJoin Type
P_WBRK_Begru_Values P_WBRK_Begru_Values inner
wbrk wbrk from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PWBRKH2ACCVH view
VDM.viewType #BASIC view
VDM.private true view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #XXL view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #MANDATORY view
AbapCatalog.preserveKey true view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY wbeln wbrk wbeln
lfart wbrk lfart
wfdat wbrk wfdat
kunrg wbrk kunrg
kunre wbrk kunre
vkorg wbrk vkorg
vtweg wbrk vtweg
spart wbrk spart
erdat wbrk erdat
ernam wbrk ernam
bldat wbrk bldat
xblnr wbrk xblnr
zuonr wbrk zuonr
bukrs wbrk bukrs
ekorg wbrk ekorg
ekgrp wbrk ekgrp
kunre_begru P_WBRK_Begru_Values kunre_begru
kunrg_begru P_WBRK_Begru_Values kunrg_begru 
@AbapCatalog.sqlViewName: 'PWBRKH2ACCVH'
@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 Settlement Document Category 'H' to be passed on to Accounting

define view P_WBRK_H_2_ACC_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.lfart                         as lfart,
      wbrk.wfdat                         as wfdat,
      wbrk.kunrg                         as kunrg,
      wbrk.kunre                         as kunre,
      wbrk.vkorg                         as vkorg,
      wbrk.vtweg                         as vtweg,
      wbrk.spart                         as spart,
      wbrk.erdat                         as erdat,
      wbrk.ernam                         as ernam,
      wbrk.bldat                         as bldat,
      wbrk.xblnr                         as xblnr,
      wbrk.zuonr                         as zuonr,
      wbrk.bukrs                         as bukrs,
      wbrk.ekorg                         as ekorg,
      wbrk.ekgrp                         as ekgrp,
      P_WBRK_Begru_Values.kunre_begru    as kunre_begru,
      P_WBRK_Begru_Values.kunrg_begru    as kunrg_begru
}
where
       wdtyp = 'H'
  and(
       rfbsk = 'A'
    or rfbsk = 'B'
    or rfbsk = 'F'
    or rfbsk = 'I'
    or rfbsk = 'M'
    or rfbsk = 'P'
  )

Learn More