P_WBRK_4_Clearing_ValueHelp

DDL: P_WBRK_4_CLEARING_VALUEHELP SQL: PWBRK4CLEARVH Type: view BASIC

P_WBRK_4_Clearing_ValueHelp is a Basic CDS View in SAP S/4HANA. It reads from 2 data sources (P_WBRK_Begru_Values, wbrk) and exposes 24 fields with key field wbeln. It has 1 association to related views.

2 data source(s) 24 fields

Data Sources (2)

SourceAliasJoin Type
P_WBRK_Begru_Values P_WBRK_Begru_Values inner
wbrk wbrk from

Associations (1)

CardinalityTargetAliasCondition
[0..1] trrlcg _SettlmtDocListTypes $projection.rrlcg = _SettlmtDocListTypes.rrlcg

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PWBRK4CLEARVH 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 (24)

KeyFieldSource TableSource FieldDescription
KEY wbeln wbrk wbeln
lifre wbrk lifre
lnrzb wbrk lnrzb
kunre wbrk kunre
kunrg wbrk kunrg
ekorg wbrk ekorg
ekgrp wbrk ekgrp
vkorg wbrk vkorg
vtweg wbrk vtweg
spart wbrk spart
bukrs wbrk bukrs
xblnr wbrk xblnr
zuonr wbrk zuonr
waerl wbrk waerl
lfgru wbrk lfgru
rrlcg wbrk rrlcg
rrlpa wbrk rrlpa
wdtyp wbrk wdtyp
lfart wbrk lfart
rfbsk wbrk rfbsk
lifre_begru P_WBRK_Begru_Values lifre_begru
lnrzb_begru P_WBRK_Begru_Values lnrzb_begru
kunre_begru P_WBRK_Begru_Values kunre_begru
kunrg_begru P_WBRK_Begru_Values kunrg_begru 
@AbapCatalog.sqlViewName: 'PWBRK4CLEARVH'
@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 (of Cat. F, I, K) for Clearing Operations

define view P_WBRK_4_Clearing_ValueHelp

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

  association [0..1] to trrlcg            as _SettlmtDocListTypes on $projection.rrlcg = _SettlmtDocListTypes.rrlcg

{
  key wbrk.wbeln                                      as wbeln,
      wbrk.lifre                                      as lifre,
      wbrk.lnrzb                                      as lnrzb,
      wbrk.kunre                                      as kunre,
      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.bukrs                                      as bukrs,
      wbrk.xblnr                                      as xblnr,
      wbrk.zuonr                                      as zuonr,
      wbrk.waerl                                      as waerl,
      wbrk.lfgru                                      as lfgru,
      wbrk.rrlcg                                      as rrlcg,
      wbrk.rrlpa                                      as rrlpa,
      wbrk.wdtyp                                      as wdtyp,
      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            =  'F'
    or wdtyp            =  'I'
    or wdtyp            =  'K'
  )
  and  _SettlmtDocListTypes [inner].iv_proc_type <> ''
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_WBRK_BEGRU_VALUES",
"TRRLCG",
"WBRK"
],
"ASSOCIATED":
[
"TRRLCG"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More