C_CrcyAdjmtToBeVerified

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 C_CrcyAdjmtToBeVerified.
-- 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: CCRCYADJMT

CREATE VIEW C_CrcyAdjmtToBeVerified AS
SELECT
  _Header.AccountingDocument AS AccountingDocument,
  _Header.CompanyCode AS CompanyCode,
  _Header.FiscalYear AS FiscalYear,
  _Header.WorkItem AS WorkItem,
  _Header.TaskProcessingStatus AS TaskProcessingStatus,
  _Header.OriginalReferenceDocument AS OriginalReferenceDocument,
  _Header.ObjectKey AS ObjectKey,
  cast ( 0 as fis_ksl ) AS JournalEntryAmountInDspCrcy,
  cast (' ' as vdm_v_display_currency ) AS DisplayCurrency,
  _Header.AccountingDocumentStatus AS AccountingDocumentStatus,
  _StatusText[1:Language = $session.system_language].AccountingDocumentStatusName AS AccountingDocumentStatusName,
  _Header.AccountingDocumentType AS AccountingDocumentType,
  _AccountingDocumentType._Text[1:Language = $session.system_language].AccountingDocumentTypeName AS AccountingDocumentTypeName,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  _Header.DocumentReferenceID AS ReferenceDocument,
  _Header.TransactionCurrency AS TransactionCurrency,
  _Header.AccountingDocumentHeaderText AS AccountingDocumentHeaderText,
  _Header.DocumentDate AS DocumentDate,
  _Header.PostingDate AS PostingDate,
  _Creator.UserDescription AS CreatedByUserName,
  _Header.CreatedByUser AS CreatedByUser,
  _Header.ParkedByUser AS ParkedByUser,
  _Requestor.UserDescription AS ParkedByUserName,
  _Header.AccountingDocumentCreationDate AS AccountingDocumentCreationDate,
  _Header.LedgerGroup AS LedgerGroup,
  _Header.AccountingDocumentCategory AS AccountingDocumentCategory
FROM I_GLJrnlEntryToBeVerified AS _Header
LEFT OUTER JOIN C_CrcyAdjmtItemToBeVerified AS _LineItem ON CompanyCode = _LineItem.SourceCompanyCode AND AccountingDocument = _LineItem.AccountingDocument AND FiscalYear = _LineItem.FiscalYear  -- association [1..*]
LEFT OUTER JOIN I_WorkflowStatusTxt AS _StatusText ON AccountingDocumentStatus = _StatusText.AccountingDocumentStatus  -- association [0..*]
LEFT OUTER JOIN I_AccountingDocumentType AS _AccountingDocumentType ON AccountingDocumentType = _AccountingDocumentType.AccountingDocumentType  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_User AS _Creator ON CreatedByUser = _Creator.UserID  -- association [1..1]
LEFT OUTER JOIN I_User AS _Requestor ON ParkedByUser = _Requestor.UserID  -- association [1..1]
;