P_WBRK_D_ValueHelp

DDL: P_WBRK_D_VALUEHELP SQL: PWBRKDVH Type: view BASIC

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

Data Sources (2)

SourceAliasJoin Type
P_WBRK_Begru_Values P_WBRK_Begru_Values inner
wbrk wbrk from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PWBRKDVH 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 (19)

KeyFieldSource TableSource FieldDescription
KEY wbeln wbrk wbeln
wrart wbrk wrart
wfdat wbrk wfdat
lnrzb wbrk lnrzb
ekorg wbrk ekorg
ekgrp wbrk ekgrp
vkorg wbrk vkorg
vtweg wbrk vtweg
spart wbrk spart
bukrs wbrk bukrs
erdat wbrk erdat
ernam wbrk ernam
lifre wbrk lifre
xblnr wbrk xblnr
lfart wbrk lfart
rfbsk wbrk rfbsk
process_type wbrk process_type
lifre_begru P_WBRK_Begru_Values lifre_begru
lnrzb_begru P_WBRK_Begru_Values lnrzb_begru
@AbapCatalog.sqlViewName: 'PWBRKDVH'
@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 Supplier Settlement List (Settlement Document Category 'D')

define view P_WBRK_D_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.wfdat                         as wfdat,
     wbrk.lnrzb                         as lnrzb,
     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.erdat                         as erdat,
     wbrk.ernam                         as ernam,
     wbrk.lifre                         as lifre,
     wbrk.xblnr                         as xblnr,
     wbrk.lfart                         as lfart,
     wbrk.rfbsk                         as rfbsk,
     wbrk.process_type                  as process_type,
     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
}
  where wdtyp = 'D'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_WBRK_BEGRU_VALUES",
"WBRK"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/