I_CAInvcgDocSource

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_CAInvcgDocSource.
-- 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.

CREATE VIEW I_CAInvcgDocSource AS
SELECT
  cast(srcdoccat as srcdoccat_gfn_kk preserving type) AS CAInvcgSourceDocumentCat,
  cast(srcdocno as srcdocno_gfn_kk preserving type) AS CAInvcgSourceDocumentNumber,
  invdocno AS CAInvoicingDocument,
  srcdoctype AS CAInvcgSourceDocumentType,
  log_system AS LogicalSystem,
  applk AS CAApplicationArea,
  invoiced AS CAInvcgIsDocumentPosted,
  simulated AS CAInvcgIsDocumentSimulated,
  cast(preliminary as inv_preliminary_gfn_kk preserving type) AS CAInvcgIsDocumentPreliminary,
  cast(reversaldoc as inv_reversaldoc_gfn_kk preserving type) AS CAInvcgReversalDocument,
  cast(reverseddoc as inv_reverseddoc_gfn_kk preserving type) AS CAInvcgReversedDocument,
  crdate AS CAInvcgCreationDate,
  crtime AS CAInvcgCreationTime
FROM dfkkinvdoc_s
LEFT OUTER JOIN I_CAInvcgDocHeader AS _CAInvcgDocHeader ON CAInvoicingDocument = _CAInvcgDocHeader.CAInvoicingDocument  -- association [1..1]
LEFT OUTER JOIN I_CAInvcgSourceDocCat AS _CAInvcgSourceDocCat ON CAInvcgSourceDocumentCat = _CAInvcgSourceDocCat.CAInvcgSourceDocumentCat  -- association [0..1]
LEFT OUTER JOIN I_CAInvcgSourceDocType AS _CAInvcgSourceDocType ON CAInvcgSourceDocumentType = _CAInvcgSourceDocType.CAInvcgSourceDocumentType AND CAInvcgSourceDocumentCat = _CAInvcgSourceDocType.CAInvcgSourceDocumentCat  -- association [0..1]
LEFT OUTER JOIN I_CAApplicationArea AS _CAApplicationArea ON CAApplicationArea = _CAApplicationArea.CAApplicationArea  -- association [0..1]
LEFT OUTER JOIN I_CAInvcgDocHeader AS _CAInvcgReversalDocument ON CAInvcgReversalDocument = _CAInvcgReversalDocument.CAInvoicingDocument  -- association [0..1]
LEFT OUTER JOIN I_CAInvcgDocHeader AS _CAInvcgReversedDocument ON CAInvcgReversedDocument = _CAInvcgReversedDocument.CAInvoicingDocument  -- association [0..1]
;