view_ab_head_p

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 view_ab_head_p.
-- 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: CDS_AB_HEAD_P

CREATE VIEW view_ab_head_p AS
SELECT
  wbeln,
  waerl,
  lftyp,
  wrart,
  lifre,
  kunre,
  lnrzb,
  kunrg,
  bldat,
  wfdat,
  erdat,
  bukrs,
  ekorg,
  ekgrp,
  vkorg,
  vtweg,
  spart,
  lfart,
  xblnr,
  zuonr,
  post_party,
  use_case,
  lfaks,
  rfbsk,
  fksto,
  stceg,
  stcegd,
  incov,
  inco1,
  inco2,
  inco2_l,
  inco3_l,
  lfgru,
  activity,
  payment_type,
  status_texts,
  payee_name,
  payer_name
FROM wbrk
LEFT OUTER JOIN tmlfg AS activity ON lfgru = activity.lfgru  -- association [0..1]
LEFT OUTER JOIN tmlfgt AS activity_texts ON lfgru = activity_texts.lfgru  -- association [0..*]
LEFT OUTER JOIN tmfk AS document_type ON lfart = document_type.lfart  -- association [1..1]
LEFT OUTER JOIN tmfkt AS document_type_texts ON lfart = document_type_texts.lfart  -- association [0..*]
LEFT OUTER JOIN tmzr AS payment_type ON wrart = payment_type.wrart  -- association [0..1]
LEFT OUTER JOIN tmzrt AS payment_type_texts ON wrart = payment_type_texts.wrart  -- association [0..*]
LEFT OUTER JOIN dd07t AS status_texts ON rfbsk = status_texts.domvalue_l AND status_texts.domname = 'WFBSK' AND status_texts.as4local = 'A'  -- association [0..*]
LEFT OUTER JOIN dd07t AS cancelled_texts ON fksto = cancelled_texts.domvalue_l AND cancelled_texts.domname = 'XFELD' AND cancelled_texts.as4local = 'A'  -- association [0..*]
LEFT OUTER JOIN dd07t AS doc_category_texts ON lftyp = doc_category_texts.domvalue_l AND doc_category_texts.domname = 'WFTYP' AND doc_category_texts.as4local = 'A'  -- association [0..*]
LEFT OUTER JOIN view_lfa1_name_p AS invoicing_party_name ON lifre = invoicing_party_name.vendor_account  -- association [0..1]
LEFT OUTER JOIN view_lfa1_name_p AS payee_name ON lnrzb = payee_name.vendor_account  -- association [0..1]
LEFT OUTER JOIN view_Kna1_name_p AS bill_to_party_name ON kunre = bill_to_party_name.customer_account  -- association [0..1]
LEFT OUTER JOIN view_Kna1_name_p AS payer_name ON kunrg = payer_name.customer_account  -- association [0..1]
;