I_CADocument

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_CADocument.
-- 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_CADocument AS
SELECT
  opbel AS CADocumentNumber,
  fikey AS CAReconciliationKey,
  applk AS CAApplicationArea,
  blart AS CADocumentType,
  herkf AS CADocumentOriginCode,
  cast(ernam as fclm_bam_created_by preserving type ) AS CreatedByUser,
  cast(cpudt as fis_cpdat preserving type) AS CreationDate,
  cast(cputm as ttet_dt_cr_time preserving type ) AS CreationTime,
  cast(waers as fis_rwcur preserving type ) AS TransactionCurrency,
  cast(bldat as fis_bldat preserving type ) AS DocumentDate,
  budat AS CAPostingDate,
  cast(wwert as vdm_v_exchange_rate_date preserving type ) AS ExchangeRateDate,
  xblnr AS CAReferenceDocument,
  rlgrd AS CAReturnReason,
  abgrd AS CAPostingReason,
  xeibh AS CASeparateDocIsCreatedInGL,
  cast(awtyp as fis_awtyp preserving type ) AS ReferenceDocumentType,
  awkey AS OriginalReferenceDocument,
  cast(stbel as stbel_gfn_kk preserving type ) AS CAReversedDocumentNumber,
  bltyp AS CADocumentClass,
  aginf AS CAClearingInformation,
  stbuk AS CATaxCompanyCode,
  cast(storb as storb_gfn_kk preserving type ) AS CAReversalDocumentNumber,
  appdx AS CADocumentSupplements,
  awsys AS LogicalSystem,
  versn AS CADocumentVersion,
  c4eye AS CAWorkflowCheckReason,
  c4eyp AS CAWorkflowCheckProcess,
  tatyp AS CADocumentTransactionClass,
  hbbla AS CADocumentTypeForGLTransfer,
  xcsha AS CADocContainsCashFlowItems,
  xtxch AS CATaxCodeWasExchanged,
  cast(vatdate as vatdate preserving type ) AS TaxReportingDate,
  fulfilldate AS TaxFulfillmentDate,
  wnper AS CARequestedPeriodForGLTransfer,
  xsing AS IsIndividualPosting,
  xdaag AS CADocumentIsAged,
  chdate AS LastChangeDate,
  chtime AS LastChangeTime,
  cadoctype AS CAInvcgRefPostingDocType,
  invdocno AS CAInvoicingDocument,
  glo_ref1_hd AS CA1stCountrySpecificReference,
  glo_dat1_hd AS CAFirstCountrySpecificDate
FROM dfkkko
LEFT OUTER JOIN I_AccountingDocumentType AS _AccountingDocType ON CADocumentTypeForGLTransfer = _AccountingDocType.AccountingDocumentType  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompCode ON CATaxCompanyCode = _CompCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_Currency AS _Currency ON TransactionCurrency = _Currency.Currency  -- association [1..1]
LEFT OUTER JOIN I_CAApplicationArea AS _ApplArea ON CAApplicationArea = _ApplArea.CAApplicationArea  -- association [1..1]
LEFT OUTER JOIN I_CAClearingInformation AS _CAClearingInformation ON CAClearingInformation = _CAClearingInformation.CAClearingInformation  -- association [0..1]
LEFT OUTER JOIN I_CADocTransactionClass AS _CADocTransactionClass ON CADocumentTransactionClass = _CADocTransactionClass.CADocumentTransactionClass  -- association [1..1]
LEFT OUTER JOIN I_CADocumentClass AS _CADocumentClass ON CADocumentClass = _CADocumentClass.CADocumentClass  -- association [0..1]
LEFT OUTER JOIN I_CADocumentOriginCode AS _DocOriginCode ON CADocumentOriginCode = _DocOriginCode.CADocumentOriginCode  -- association [1..1]
LEFT OUTER JOIN I_CADocumentSupplement AS _CADocumentSupplement ON CADocumentSupplements = _CADocumentSupplement.CADocumentSupplements  -- association [0..1]
LEFT OUTER JOIN I_CADocumentType AS _DocType ON CADocumentType = _DocType.CADocumentType AND CAApplicationArea = _DocType.CAApplicationArea  -- association [1..1]
LEFT OUTER JOIN I_CADocumentVersion AS _CADocumentVersion ON CADocumentVersion = _CADocumentVersion.CADocumentVersion  -- association [0..1]
LEFT OUTER JOIN I_CAInvcgDocHeader AS _CAInvcgDocument ON CAInvoicingDocument = _CAInvcgDocument.CAInvoicingDocument  -- association [0..1]
LEFT OUTER JOIN I_CAInvcgRefPostgDocTyp AS _CAInvcgRefPostgDocType ON CAInvcgRefPostingDocType = _CAInvcgRefPostgDocType.CAInvcgRefPostingDocType  -- association [0..1]
LEFT OUTER JOIN I_CAPostingReason AS _CAPostingReason ON CADocumentOriginCode = _CAPostingReason.CADocumentOriginCode AND CAPostingReason = _CAPostingReason.CAPostingReason  -- association [0..1]
LEFT OUTER JOIN I_CAReturnReason AS _CAReturnReason ON CAReturnReason = _CAReturnReason.CAReturnReason AND _CAReturnReason.HouseBank is not initial  -- association [0..*]
LEFT OUTER JOIN I_CARequestedSpecialPeriod AS _CARequestedSpecialPeriod ON CARequestedPeriodForGLTransfer = _CARequestedSpecialPeriod.CARequestedPeriodForGLTransfer  -- association [1..1]
LEFT OUTER JOIN I_CATaxSupplementStorageLoc AS _CATaxSupplementStorageLoc ON CAStorageLocationOfTaxSuplmnt = _CATaxSupplementStorageLoc.CAStorageLocationOfTaxSuplmnt  -- association [0..1]
LEFT OUTER JOIN I_CAWorkflowCheckReason AS _WorkflowCheckReason ON CAWorkflowCheckReason = _WorkflowCheckReason.CAWorkflowCheckReason  -- association [0..1]
LEFT OUTER JOIN I_CAWorkflowCheckProcess AS _WorkflowCheckProcess ON CAWorkflowCheckProcess = _WorkflowCheckProcess.CAWorkflowCheckProcess  -- association [0..1]
LEFT OUTER JOIN E_CADocumentHeader AS _Extension ON CADocumentNumber = _Extension.CADocumentNumber  -- association [1..1]
;