view_ds_gr_par

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_ds_gr_par.
-- 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_DS_GR_PAR
-- Parameters: p_language : spras

CREATE VIEW view_ds_gr_par AS
SELECT
  bvd.num AS num,
  bvd.wbeln AS wbeln,
  bvd.posnr AS posnr,
  bvd.doc_type AS doc_type,
  bvd.doc_id AS doc_id,
  bvd.doc_id2 AS doc_id2,
  bvd.doc_id3 AS doc_id3,
  bvd.doc_item AS doc_item,
  coco_head.contract_type AS cc_type,
  bvd.bv_date AS bv_date,
  bvd.menge AS menge,
  bvd.meina AS meina,
  bvd.busvol_1 AS busvol_1,
  bvd.busvol_2 AS busvol_2,
  bvd.busvol_3 AS busvol_3,
  bvd.busvol_4 AS busvol_4,
  bvd.waers AS waers,
  bvd.ntgew AS ntgew,
  bvd.brgew AS brgew,
  bvd.gewei AS gewei,
  bvd.volum AS volum,
  bvd.voleh AS voleh,
  bvd.anzpu AS anzpu,
  bvd.punei AS punei,
  coco_head.category AS cc_category,
  coco_head.reference AS cc_reference,
  agbu_head_settle.bukrs AS bukrs_settle,
  agbu_head_settle.bldat AS bldat_settle,
  agbu_head_settle.wfdat AS wfdat_settle,
  agbu_head_settle.waerl AS waerl_settle,
  agbu_item_settle.matnr AS matnr_settle,
  agbu_item_settle.arktx AS arktx_settle,
  agbu_head_settle.rfbsk AS rfbsk_settle,
  agbu_head_settle.fksto AS fksto_settle,
  agbu_head_settle.wrart AS wrart_settle,
  agbu_item_settle.lfgru AS lfgru_settle,
  agbu_head_settle.ekorg AS ekorg_settle,
  agbu_head_settle.ekgrp AS ekgrp_settle,
  agbu_head_settle.vkorg AS vkorg_settle,
  agbu_head_settle.vtweg AS vtweg_settle,
  agbu_head_settle.spart AS spart_settle,
  agbu_head_settle.lfart AS lfart_settle,
  coco_head.ekorg AS ekorg_coco,
  coco_head.ekgrp AS ekgrp_coco,
  coco_head.vkorg AS vkorg_coco,
  coco_head.vtweg AS vtweg_coco,
  coco_head.spart AS spart_coco,
  cast( gr_head.vgart as abap.char( 2 ) ) AS doc_category,
  cast( gr_head.blart as abap.char( 4 ) ) AS lfart,
  gr_item.lifnr AS lifnr,
  gr_item.kunnr AS kunnr,
  gr_item.bukrs AS bukrs,
  cast( 'C' as abap.char( 2 ) ) AS rfbsk,
  gr_head.budat AS wfdat,
  gr_head.bldat AS bldat,
  gr_head.cpudt AS erdat,
  cast( gr_head.xblnr as abap.char( 30 ) ) AS xblnr,
  gr_item.smbln AS lfaks,
  gr_item.sjahr AS lfaks_jahr,
  gr_item.matnr AS matnr,
  gr_item.werks AS werks,
  gr_item.lgort AS lgort,
  gr_item.charg AS charg,
  gr_item.mwskz AS mwskz,
  gr_item.txjcd AS txjcd,
  gr_item.kostl AS kostl,
  gr_item.prctr AS prctr,
  gr_item.ebeln AS wbeln_v,
  cast( concat( '0', gr_item.ebelp ) as abap.numc( 6 ) ) AS posnr_v,
  gr_item.aktnr AS aktnr
FROM wb2_d_bvdetail AS bvd
LEFT OUTER JOIN view_ab_head_p AS agbu_head_settle ON wbeln = agbu_head_settle.wbeln  -- association [1..1]
LEFT OUTER JOIN view_ab_items_p AS agbu_item_settle ON wbeln = agbu_item_settle.wbeln AND posnr = agbu_item_settle.posnr  -- association [1..1]
LEFT OUTER JOIN view_gr_head_p AS gr_head ON doc_id = gr_head.mblnr AND doc_id2 = gr_head.mjahr  -- association [1..1]
LEFT OUTER JOIN view_gr_items_p AS gr_item ON doc_id = gr_item.mblnr AND doc_id2 = gr_item.mjahr AND doc_item = gr_item.zeile  -- association [1..1]
LEFT OUTER JOIN view_cc_head_p AS coco_head ON num = coco_head.num  -- association [1..1]
LEFT OUTER JOIN dd07t AS bvd_doc_type_texts ON doc_type = bvd_doc_type_texts.domvalue_l AND bvd_doc_type_texts.domname = 'WB2_DOC_TYPE_BUSVOL' AND bvd_doc_type_texts.as4local = 'A'  -- association [0..*]
;