view_sdi_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_sdi_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_SDI_HEAD_P

CREATE VIEW view_sdi_head_p AS
SELECT
  vbeln,
  waerk,
  fktyp,
  vbtyp,
  fkart,
  kunrg,
  kunag,
  bukrs,
  vkorg,
  vtweg,
  spart,
  rfbsk,
  fkdat,
  erdat,
  xblnr,
  zuonr,
  sfakn,
  stceg,
  kdgrp,
  incov,
  inco1,
  inco2,
  inco2_l,
  inco3_l,
  status_texts,
  payer_name
FROM vbrk
LEFT OUTER JOIN tvfk AS document_type ON fkart = document_type.fkart  -- association [1..1]
LEFT OUTER JOIN tvfkt AS document_type_texts ON fkart = document_type_texts.fkart  -- association [0..*]
LEFT OUTER JOIN t151 AS customer_group ON kdgrp = customer_group.kdgrp  -- association [0..1]
LEFT OUTER JOIN t151t AS customer_group_texts ON kdgrp = customer_group_texts.kdgrp  -- association [0..*]
LEFT OUTER JOIN dd07t AS status_texts ON rfbsk = status_texts.domvalue_l AND status_texts.domname = 'RFBSK' AND status_texts.as4local = 'A'  -- association [0..*]
LEFT OUTER JOIN dd07t AS doc_category_texts ON fktyp = doc_category_texts.domvalue_l AND doc_category_texts.domname = 'FKTYP' AND doc_category_texts.as4local = 'A'  -- association [0..*]
LEFT OUTER JOIN view_Kna1_name_p AS payer_name ON kunrg = payer_name.customer_account  -- association [0..1]
LEFT OUTER JOIN view_Kna1_name_p AS sold_to_party_name ON kunag = sold_to_party_name.customer_account  -- association [0..1]
;