I_CASampleDocHeader

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_CASampleDocHeader.
-- 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: ICASDOCHEADER

CREATE VIEW I_CASampleDocHeader AS
SELECT
  opbel AS CADocumentNumber,
  cast(ernam as fclm_bam_created_by) AS CreatedByUser,
  cast(cpudt as fis_cpdat) AS CreationDate,
  cast(cast(cputm as abap.tims) as ttet_dt_cr_time) AS CreationTime,
  stbuk AS CATaxCompanyCode,
  xtxch AS CATaxCodeWasExchanged,
  cast(vatdate as vatdate) AS TaxReportingDate,
  fikey AS CAReconciliationKey,
  xeibh AS CASeparateDocIsCreatedInGL,
  wnper AS CARequestedPeriodForGLTransfer,
  applk AS CAApplicationArea,
  blart AS CADocumentType,
  herkf AS CADocumentOriginCode,
  cast(waers as fis_rwcur) AS TransactionCurrency,
  cast(bldat as fis_bldat) AS DocumentDate,
  budat AS CAPostingDate,
  cast(wwert as vdm_v_exchange_rate_date) AS ExchangeRateDate,
  xblnr AS CAReferenceDocument,
  rlgrd AS CAReturnReason,
  abgrd AS CAPostingReason,
  cast(awtyp as fis_awtyp) AS ReferenceDocumentType,
  awkey AS OriginalReferenceDocument,
  stbel AS CAReversedDocumentNumber,
  aginf AS CAClearingInformation,
  storb AS CAReversalDocumentNumber,
  appdx AS CADocumentSupplements,
  awsys AS LogicalSystem,
  c4eye AS CAWorkflowCheckReason,
  c4eyp AS CAWorkflowCheckProcess,
  tatyp AS CADocumentTransactionClass,
  xcsha AS CADocContainsCashFlowItems
FROM dfkkmko
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_CADocumentType AS _DocType ON CADocumentType = _DocType.CADocumentType AND CAApplicationArea = _DocType.CAApplicationArea  -- association [1..1]
LEFT OUTER JOIN I_CADocumentOriginCode AS _DocOriginCode ON CADocumentOriginCode = _DocOriginCode.CADocumentOriginCode  -- association [1..1]
LEFT OUTER JOIN I_CAWorkflowCheckReason AS _WorkflowCheckReason ON CAWorkflowCheckReason = _WorkflowCheckReason.CAWorkflowCheckReason  -- association [0..1]
LEFT OUTER JOIN I_CAPostingReasonText AS _PostingReasonText ON CADocumentOriginCode = _PostingReasonText.CADocumentOriginCode AND CAPostingReason = _PostingReasonText.CAPostingReason  -- association [0..*]
;