P_WBRK_B_2_UC31_ValueHelp

DDL: P_WBRK_B_2_UC31_VALUEHELP SQL: PWBRKB2UC31VH Type: view BASIC
13 Fields 1 Data Sources

P_WBRK_B_2_UC31_ValueHelp is a Basic CDS View in SAP S/4HANA. It reads from 1 data source (wbrk) and exposes 13 fields with key field wbeln.

Data Sources (1)

SourceAliasJoin Type
wbrk wbrk from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PWBRKB2UC31VH 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 (13)

KeyFieldSource TableSource FieldDescription
KEY wbeln wbrk wbeln Sett. Doc. List
lfart wbrk lfart Settl Doc Type
wrart wbrk wrart Settl Proc Type
wfdat wbrk wfdat Posting Date
rfbsk wbrk rfbsk Posting Status
vkorg wbrk vkorg SD Sales Org.
vtweg wbrk vtweg RefDistCh-Cust/Mat.
spart wbrk spart Source supplier
bukrs wbrk bukrs Value
erdat wbrk erdat Entered On
ernam wbrk ernam User Name
ekorg wbrk ekorg Purchasing Org.
ekgrp wbrk ekgrp Sub. purchasing grp

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_WBRK_B_2_UC31_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: PWBRKB2UC31VH

CREATE VIEW P_WBRK_B_2_UC31_ValueHelp AS
SELECT
  wbrk.wbeln AS wbeln,
  wbrk.lfart AS lfart,
  wbrk.wrart AS wrart,
  wbrk.wfdat AS wfdat,
  wbrk.rfbsk AS rfbsk,
  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.ekorg AS ekorg,
  wbrk.ekgrp AS ekgrp
FROM wbrk
;

Learn More