P_WBHI_ValueHelp

DDL: P_WBHI_VALUEHELP SQL: PWBHIVH Type: view BASIC Package: VDM_LO_GT

Trading Contract Item ValueHelp

P_WBHI_ValueHelp is a Basic CDS View that provides data about "Trading Contract Item ValueHelp" in SAP S/4HANA. It reads from 3 data sources (wbhd, wbhi, wbhk) and exposes 22 fields with key fields tkonn, tposn, tposn_sub. It has 2 associations to related views. Part of development package VDM_LO_GT.

3 data source(s) 22 fields

Data Sources (3)

SourceAliasJoin Type
wbhd wbhd inner
wbhi wbhi from
wbhk wbhk inner

Associations (2)

CardinalityTargetAliasCondition
[0..1] knvv _CustomerSalesArea $projection.kunnr = _CustomerSalesArea.kunnr and $projection.vkorg = _CustomerSalesArea.vkorg and tvta.vtwku = _CustomerSalesArea.vtweg and tvta.spaku = _CustomerSalesArea.spart
[0..1] P_WLF_CDS_LFA1_BG _Supplier $projection.elifn = _Supplier.vendor_account

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PWBHIVH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true 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
AccessControl.authorizationCheck #MANDATORY view

Fields (22)

KeyFieldSource TableSource FieldDescription
KEY tkonn wbhi tkonn
KEY tposn wbhi tposn
KEY tposn_sub wbhi tposn_sub
matnr wbhi matnr
werks wbhi werks
lgort wbhi lgort
arktx wbhi arktx
charg wbhi charg
portfolio wbhi portfolio
tkonn_ex wbhk tkonn_ex
tctyp wbhk tctyp
tksachb wbhk tksachb
kunnr wbhk kunnr
elifn wbhd elifn
vkorg wbhk vkorg
vtweg wbhk vtweg
spart wbhk spart
ekorg wbhd ekorg
ekgrp wbhd ekgrp
tccat wbhk tccat
wbhd_tposn wbhi wbhd_tposn
vendor_begru _Supplier vendor_begru 
@AbapCatalog.sqlViewName: 'PWBHIVH'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@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
@AccessControl.authorizationCheck: #MANDATORY
// 'Trading Contract Item Data Value Help' with access control for display activity

// ABAP unit tests available in class: CL_CDS_P_WBHI_VALUEHELP

define view P_WBHI_ValueHelp

  as select from           wbhi
    inner join             wbhk on wbhk.tkonn = wbhi.tkonn
    inner join             wbhd on  wbhd.tkonn = wbhk.tkonn
                                and wbhd.tposn = wbhi.wbhd_tposn
    left outer to one join tvta on  tvta.vkorg = wbhk.vkorg
                                and tvta.vtweg = wbhk.vtweg
                                and tvta.spart = wbhk.spart

  association [0..1] to knvv              as _CustomerSalesArea on  $projection.kunnr = _CustomerSalesArea.kunnr
                                                                and $projection.vkorg = _CustomerSalesArea.vkorg
                                                                and tvta.vtwku        = _CustomerSalesArea.vtweg
                                                                and tvta.spaku        = _CustomerSalesArea.spart

  association [0..1] to P_WLF_CDS_LFA1_BG as _Supplier          on  $projection.elifn = _Supplier.vendor_account

{
  key wbhi.tkonn,
  key wbhi.tposn,
  key wbhi.tposn_sub,
      wbhi.matnr,
      wbhi.werks,
      wbhi.lgort,
      wbhi.arktx,
      wbhi.charg,
      wbhi.portfolio,
      wbhi.portfolio_date,
      wbhk.tkonn_ex,
      wbhk.tctyp,
      wbhk.tksachb,
      wbhk.kunnr,
      wbhd.elifn               as elifn,
      wbhk.vkorg,
      wbhk.vtweg,
      wbhk.spart,
      wbhd.ekorg               as ekorg,
      wbhd.ekgrp               as ekgrp,
      wbhk.tccat,
      wbhi.wbhd_tposn,
      _CustomerSalesArea.begru as customer_begru,
      _Supplier.vendor_begru
}

Learn More