C_CrcyAdjmtItemToBeVerified

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_CrcyAdjmtItemToBeVerified.
-- 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: CCRCYADJMTI

CREATE VIEW C_CrcyAdjmtItemToBeVerified AS
SELECT
  _item.AccountingDocumentItem AS AccountingDocumentItem,
  _item.SourceCompanyCode AS SourceCompanyCode,
  _item.FiscalYear AS FiscalYear,
  _item.AccountingDocument AS AccountingDocument,
  _item.Ledger AS Ledger,
  _item.AccountingDocumentCategory AS AccountingDocumentCategory,
  _item.CompanyCode AS CompanyCode,
  _item.GLAccount AS GLAccount,
  cast( _cocd._Text[1:Language = $session.system_language].GLAccountName as fac_skat_txt20 ) AS GLAccountName,
  cast(_item.DocumentItemText as fac_item_txt50) AS DocumentItemText,
  _item.DebitCreditCode AS DebitCreditCode,
  _DebitCreditCode._Text[1:Language = $session.system_language].DebitCreditCodeName AS DebitCreditCodeName,
  _item.TransactionCurrency AS TransactionCurrency,
  _item.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  _CompanyCode.Currency AS CompanyCodeCurrency,
  _item.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  _item.GlobalCurrency AS GlobalCurrency,
  _item.AmountInGlobalCurrency AS AmountInGlobalCurrency,
  _item.FreeDefinedCurrency1 AS FreeDefinedCurrency1,
  _item.AmountInFreeDefinedCurrency1 AS AmountInFreeDefinedCurrency1,
  _item.FunctionalCurrency AS FunctionalCurrency,
  _item.AmountInFunctionalCurrency AS AmountInFunctionalCurrency,
  _item.ProfitCenter AS ProfitCenter,
  _item.CostCenter AS CostCenter,
  _coa.GLAccountGroup AS GLAccountGroup,
  _item.WBSElementInternalID AS WBSElementInternalID,
  _WBSElement.WBSElement AS WBSElementExternalID,
  _header.LedgerGroup AS LedgerGroup
FROM I_CrcyAdjmtItemToBeVerified AS _item
LEFT OUTER JOIN I_GLAcctInCoCode AS _cocd ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_GLAccountInChartOfAccounts AS _coa ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_DebitCreditCode AS _DebitCreditCode ON DebitCreditCode = _DebitCreditCode.DebitCreditCode  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_WBSElement AS _WBSElement ON WBSElementInternalID = _WBSElement.WBSElementInternalID  -- association [1..1]
LEFT OUTER JOIN I_JournalEntry AS _header ON _item.CompanyCode = _header.CompanyCode AND _item.FiscalYear = _header.FiscalYear AND _item.AccountingDocument = _header.AccountingDocument  -- association [1..1]
;