I_CmmdtyOrdReqDocTypeText

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 I_CmmdtyOrdReqDocTypeText.
-- 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: ICMMDTYDOCTYPTXT

CREATE VIEW I_CmmdtyOrdReqDocTypeText AS
SELECT
  Document.application_id AS CmmdtyOrdReqDocApplication,
  Document.document_type AS CmmdtyOrdRequestDocumentType,
  _ApplicationIdText.appl_id_text AS CmmdtyOrdReqDocApplicationText,
  _DocumentTypeText.document_type_text AS CmmdtyOrdReqDocumentTypeText,
  Document.semanticobject AS SemanticObject,
  Document.semanticobjectaction AS SemanticObjectAction
FROM cmmfdor_c_doctyp AS Document
INNER JOIN cmmfdor_c_appid AS ApplicationID ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN cmmfdor_c_appidt AS _ApplicationIdText ON _ApplicationIdText.application_id = CmmdtyOrdReqDocApplication AND _ApplicationIdText.spras = $session.system_language  -- association [0..1]
LEFT OUTER JOIN cmmfdor_c_doctyt AS _DocumentTypeText ON _DocumentTypeText.document_type = CmmdtyOrdRequestDocumentType AND _DocumentTypeText.spras = $session.system_language  -- association [0..1]
;