WB2_WBRP_PRCD_ELM_PART_SETTK

DDL: WB2_WBRP_PRCD_ELM_PART_SETTK SQL: WB2WBRPPRCDSETT Type: view

Settlmt Items with KSCHL in WB2_C_PART_SETTK

WB2_WBRP_PRCD_ELM_PART_SETTK is a CDS View that provides data about "Settlmt Items with KSCHL in WB2_C_PART_SETTK" in SAP S/4HANA. It reads from 5 data sources (WB2_PRCD_ELEM_PART_SETTK, WB2_PRCD_ELEM_PART_SETTK, wb2_c_part_settk, wbrp, WLF_CDS_WBRP_NETWR_POST_PARTY) and exposes 6 fields with key fields wbeln, posnr, k_kschl.

Data Sources (5)

SourceAliasJoin Type
WB2_PRCD_ELEM_PART_SETTK _prcd_elements_c left_outer
WB2_PRCD_ELEM_PART_SETTK _prcd_elements_s left_outer
wb2_c_part_settk wb2_c_part_settk inner
wbrp wbrp from
WLF_CDS_WBRP_NETWR_POST_PARTY WLF_CDS_WBRP_NETWR_POST_PARTY inner

Parameters (3)

NameTypeDefault
p_tg_lftyp wftyp
p_tg_koart koart
p_part_settl_group wb2_part_settl_group

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName WB2WBRPPRCDSETT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Settlmt Items with KSCHL in WB2_C_PART_SETTK view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XXL view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY wbeln wbrp wbeln Sett. Doc. List
KEY posnr wbrp posnr WBS Element
KEY k_kschl wb2_c_part_settk kschl_source Condition Type
knumv WLF_CDS_WBRP_NETWR_POST_PARTY knumv Doc. Condition
knumvd WLF_CDS_WBRP_NETWR_POST_PARTY knumvd Doc. Condition
kschl_target wb2_c_part_settk kschl_target CondType Offset

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 WB2_WBRP_PRCD_ELM_PART_SETTK.
-- 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: WB2WBRPPRCDSETT
-- Parameters: p_tg_lftyp : wftyp, p_tg_koart : koart, p_part_settl_group : wb2_part_settl_group

CREATE VIEW WB2_WBRP_PRCD_ELM_PART_SETTK AS
SELECT
  wbrp.wbeln AS wbeln,
  wbrp.posnr AS posnr,
  wb2_c_part_settk.kschl_source AS k_kschl,
  WLF_CDS_WBRP_NETWR_POST_PARTY.knumv AS knumv,
  WLF_CDS_WBRP_NETWR_POST_PARTY.knumvd AS knumvd,
  wb2_c_part_settk.kschl_target AS kschl_target
FROM wbrp
INNER JOIN WLF_CDS_WBRP_NETWR_POST_PARTY ON /* join condition not captured in parsed metadata */
INNER JOIN wb2_c_part_settk ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN WB2_PRCD_ELEM_PART_SETTK AS _prcd_elements_c ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN WB2_PRCD_ELEM_PART_SETTK AS _prcd_elements_s ON /* join condition not captured in parsed metadata */
;