R_CADocumentTP

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 R_CADocumentTP.
-- 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 R_CADocumentTP AS
SELECT
  CADocumentNumber,
  CAReconciliationKey,
  CAApplicationArea,
  CADocumentType,
  CADocumentOriginCode,
  CreatedByUser,
  CreationDate,
  CreationTime,
  TransactionCurrency,
  DocumentDate,
  CAPostingDate,
  ExchangeRateDate,
  CAReferenceDocument,
  CAReturnReason,
  CAPostingReason,
  CASeparateDocIsCreatedInGL,
  ReferenceDocumentType,
  OriginalReferenceDocument,
  CAReversedDocumentNumber,
  CADocumentClass,
  CAClearingInformation,
  CATaxCompanyCode,
  CAReversalDocumentNumber,
  CADocumentSupplements,
  LogicalSystem,
  CADocumentVersion,
  CAWorkflowCheckReason,
  CAWorkflowCheckProcess,
  CADocumentTransactionClass,
  CADocumentTypeForGLTransfer,
  CADocContainsCashFlowItems,
  CATaxCodeWasExchanged,
  TaxReportingDate,
  TaxFulfillmentDate,
  CARequestedPeriodForGLTransfer,
  IsIndividualPosting,
  CADocumentIsAged,
  LastChangeDate,
  LastChangeTime,
  CAInvcgRefPostingDocType,
  CAInvoicingDocument,
  CA1stCountrySpecificReference,
  CAFirstCountrySpecificDate,
  CAClassificationKey,
  cast(dats_tims_to_tstmp(CreationDate, CreationTime, abap_system_timezone($session.client, 'NULL'), $session.client, 'NULL') as vdm_creationdatetime) AS CreationDateTime
FROM I_CADocument
LEFT OUTER JOIN I_CADocumentBPItemPaymentData AS _BPItemPaytData ON CADocumentNumber = _BPItemPaytData.CADocumentNumber  -- association [0..*]
LEFT OUTER JOIN I_CADocumentGLItemPaymentData AS _GLItemPaytData ON CADocumentNumber = _GLItemPaytData.CADocumentNumber  -- association [0..*]
LEFT OUTER JOIN I_CADocumentUI AS _DocUI ON CADocumentNumber = _DocUI.CADocumentNumber  -- association [1..1]
LEFT OUTER JOIN I_ChangeDocument_2 AS _CADocumentChangeDocument ON _CADocumentChangeDocument.ChangeDocObjectClass = 'MKK_BELEG' AND CADocumentNumber = _CADocumentChangeDocument.ChangeDocObject  -- association [0..*]
LEFT OUTER JOIN E_CADocumentHeader AS _Extension ON CADocumentNumber = _Extension.CADocumentNumber  -- association [1..1]
LEFT OUTER JOIN R_CADocumentBPItemTP AS _BPItem ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_CADocumentGLItemTP AS _GLItem ON /* condition not available in parsed metadata */  -- association [0..*]
;