SHSM_I_EDISCDOCALL

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_I_EDISCDOCALL.
-- 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: SHSMIEDISCALL

CREATE VIEW SHSM_I_EDISCDOCALL AS
SELECT
  ediscdoc.discno AS discno,
  ediscdoc.discreason AS discreason,
  ediscdoc.status AS status,
  ediscdoc.refobjtype AS refobjtype,
  ediscdoc.refobjkey AS refobjkey,
  _ConnObj.AuthorizationGroup AS AuthorizationGroup,
  ' ' AS Division,
  ' ' AS CompanyCode,
  ' ' AS IsBusinessPurposeCompleted,
  ' ' AS BusinessPartner,
  ' ' AS CAAuthorizationGroup,
  _FKKContract.ContractAccountCategory AS ContractAccountCategory
FROM ediscdoc
INNER JOIN SHSM_I_EDISCDOCCONNOBJ AS _ConnObj ON /* join condition not captured in parsed metadata */
INNER JOIN SHSM_I_EDISCDOCDEVICE AS _Device ON /* join condition not captured in parsed metadata */
INNER JOIN SHSM_I_EDISCDOCINSTLN AS _Installation ON /* join condition not captured in parsed metadata */
INNER JOIN SHSM_I_EDISCDOCISUCONTR AS _UtilitiesContract ON /* join condition not captured in parsed metadata */
INNER JOIN SHSM_I_EDISCDOCPREMISE AS _Premise ON /* join condition not captured in parsed metadata */
INNER JOIN SHSM_I_EDISCDOCISUPARTNER AS _Partner ON /* join condition not captured in parsed metadata */
INNER JOIN SHSM_I_EDISCDOCISUACCountVH AS _FKKContract ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): ediscdoc
;