P_WBRK_Begru_Values

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_Begru_Values.
-- 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: PWBRKBEGRUVALS

CREATE VIEW P_WBRK_Begru_Values AS
SELECT
  SettlmtMgmtDoc AS wbeln,
  SalesOrganization AS vkorg,
  DistributionChannel AS vtweg,
  Division AS spart,
  PurchasingOrganization AS ekorg,
  PurchasingGroup AS ekgrp,
  InvoicingParty AS lifre,
  BillToParty AS kunre,
  PayeeParty AS lnrzb,
  PayerParty AS kunrg,
  AlternativeInvoicingParty AS lifnr_fi,
  CompanyCode AS bukrs,
  IntercompanyCompanyCode AS bukrs_deb,
  SettlmtDocType AS lfart,
  PersonWorkAgreement AS pernr,
  PersonnelCostCenter AS pers_kostl,
  SettlmtPartnerCat AS settl_party
FROM P_SettlmtMgmtDoc
LEFT OUTER JOIN P_WLF_CDS_LFA1_BG AS _InvoicingParty ON lifre = _InvoicingParty.vendor_account  -- association [0..1]
LEFT OUTER JOIN P_WLF_CDS_LFA1_BG AS _PayeeParty ON lnrzb = _PayeeParty.vendor_account  -- association [0..1]
LEFT OUTER JOIN P_WLF_CDS_LFA1_BG AS _AltvInvoicingParty ON lifnr_fi = _AltvInvoicingParty.vendor_account  -- association [0..1]
LEFT OUTER JOIN P_WLF_CDS_KNA1_BG AS _BillToParty ON kunre = _BillToParty.customer_account  -- association [0..1]
LEFT OUTER JOIN P_WLF_CDS_KNA1_BG AS _PayerParty ON kunrg = _PayerParty.customer_account  -- association [0..1]
LEFT OUTER JOIN P_WLF_CDS_LFB1_BG AS _InvoicingPartyCompany ON lifre = _InvoicingPartyCompany.vendor_account AND bukrs = _InvoicingPartyCompany.company_code  -- association [0..1]
LEFT OUTER JOIN P_WLF_CDS_LFB1_BG AS _PayeePartyCompany ON lnrzb = _PayeePartyCompany.vendor_account AND bukrs = _PayeePartyCompany.company_code  -- association [0..1]
LEFT OUTER JOIN P_WLF_CDS_LFB1_BG AS _AltvInvoicingPartyCompany ON lifnr_fi = _AltvInvoicingPartyCompany.vendor_account AND bukrs = _AltvInvoicingPartyCompany.company_code  -- association [0..1]
LEFT OUTER JOIN P_WLF_CDS_KNB1_BG AS _BillToPartyCompany ON kunre = _BillToPartyCompany.customer_account AND bukrs = _BillToPartyCompany.company_code  -- association [0..1]
LEFT OUTER JOIN P_WLF_CDS_KNB1_BG AS _PayerPartyCompany ON kunrg = _PayerPartyCompany.customer_account AND bukrs = _PayerPartyCompany.company_code  -- association [0..1]
LEFT OUTER JOIN P_WLF_CDS_KNB1_BG AS _BillToPartyCompany_deb ON kunre = _BillToPartyCompany_deb.customer_account AND bukrs_deb = _BillToPartyCompany_deb.company_code  -- association [0..1]
LEFT OUTER JOIN P_WLF_CDS_KNB1_BG AS _PayerPartyCompany_deb ON kunrg = _PayerPartyCompany_deb.customer_account AND bukrs_deb = _PayerPartyCompany_deb.company_code  -- association [0..1]
LEFT OUTER JOIN P_WLF_CDS_PERNR_BEGRU AS _PernrBegru ON pernr = _PernrBegru.Pernr  -- association [0..1]
;