SHSM_M_DEBI_BO

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 SHSM_M_DEBI_BO.
-- 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: SHSMMDEBIBO

CREATE VIEW SHSM_M_DEBI_BO AS
SELECT
  cast( m_debi_bo.bokre as bokre preserving type ) AS bokre,
  cast( m_debi_bo.kunnr as kunnr preserving type ) AS kunnr,
  cast( m_debi_bo.mcod1 as mcdd1 preserving type ) AS mcod1,
  cast( m_debi_bo.mcod3 as mcdd3 preserving type ) AS mcod3,
  cast( m_debi_bo.pstlz as pstlz preserving type ) AS pstlz,
  cast( m_debi_bo.sortl as sortl preserving type ) AS sortl,
  cast( m_debi_bo.spart as spart preserving type ) AS spart,
  cast( m_debi_bo.vkbur as vkbur preserving type ) AS vkbur,
  cast( m_debi_bo.vkgrp as vkgrp preserving type ) AS vkgrp,
  cast( m_debi_bo.vkorg as vkorg preserving type ) AS vkorg,
  cast( m_debi_bo.vtweg as vtweg preserving type ) AS vtweg,
  _Customer.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted,
  _Customer.AuthorizationGroup AS AuthorizationGroup,
  _Customer.CustomerAccountGroup AS CustomerAccountGroup
FROM m_debi_bo
LEFT OUTER JOIN I_Customer AS _Customer ON kunnr = _Customer.Customer  -- association [0..1]
;