P_WBRL_ValueHelp

DDL: P_WBRL_VALUEHELP SQL: PWBRLVH Type: view BASIC

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

Data Sources (2)

SourceAliasJoin Type
P_WBRK_Begru_Values P_WBRK_Begru_Values inner
wbrl wbrl from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PWBRLVH 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 wbrl wbeln Sett. Doc. List
KEY posnr wbrl posnr WBS Element
wbeln_lf wbrl wbeln_lf Document
lifre wbrl lifre Location Alias
lnrzb wbrl lnrzb Payee
kunre wbrl kunre Bill-to Party
kunrg wbrl kunrg Payer
ekorg P_WBRK_Begru_Values ekorg Purchasing Org.
ekgrp P_WBRK_Begru_Values ekgrp Sub. purchasing grp
vkorg P_WBRK_Begru_Values vkorg SD Sales Org.
vtweg P_WBRK_Begru_Values vtweg RefDistCh-Cust/Mat.
spart P_WBRK_Begru_Values spart Source supplier
bukrs P_WBRK_Begru_Values bukrs Value
lfart P_WBRK_Begru_Values lfart Settl Doc Type
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

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view P_WBRL_ValueHelp.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: PWBRLVH

CREATE VIEW P_WBRL_ValueHelp AS
SELECT
  wbrl.wbeln AS wbeln,
  wbrl.posnr AS posnr,
  wbrl.wbeln_lf AS wbeln_lf,
  wbrl.lifre AS lifre,
  wbrl.lnrzb AS lnrzb,
  wbrl.kunre AS kunre,
  wbrl.kunrg AS kunrg,
  P_WBRK_Begru_Values.ekorg AS ekorg,
  P_WBRK_Begru_Values.ekgrp AS ekgrp,
  P_WBRK_Begru_Values.vkorg AS vkorg,
  P_WBRK_Begru_Values.vtweg AS vtweg,
  P_WBRK_Begru_Values.spart AS spart,
  P_WBRK_Begru_Values.bukrs AS bukrs,
  P_WBRK_Begru_Values.lfart AS lfart,
  P_WBRK_Begru_Values.lifre_begru AS lifre_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
FROM wbrl
INNER JOIN P_WBRK_Begru_Values ON /* join condition not captured in parsed metadata */
;