I_JournalCaseProposal

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_JournalCaseProposal.
-- 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_JournalCaseProposal AS
SELECT
  jehdr_uuid AS JournalCaseProposalUUID,
  case_uuid AS JournalCaseUUID,
  gjahr AS FiscalYear,
  iju_jeid AS JournalCaseProposal,
  bukrs AS CompanyCode,
  blart AS AccountingDocumentType,
  bldat AS DocumentDate,
  budat AS PostingDate,
  monat AS FiscalPeriod,
  bktxt AS AccountingDocumentHeaderText,
  waers AS TransactionCurrency,
  ldgrp AS LedgerGroup,
  wwert AS ExchangeRateDate,
  xblnr AS DocumentReferenceID,
  xmwst AS TaxIsCalculatedAutomatically,
  belnr AS SenderAccountingDocument,
  cast(abs(kursf) as fis_absolute_exchangerate preserving type) AS AbsoluteExchangeRate,
  pargb AS PartnerBusinessArea,
  _AccountingDocumentTypeText[1: Language=$session.system_language].AccountingDocumentTypeName AS AccountingDocumentTypeName,
  _PartnerBusinessAreaText[1: Language=$session.system_language].BusinessAreaName AS BusinessAreaName,
  _LedgerGroupText[1: Language=$session.system_language].LedgerGroupName AS LedgerGroupName,
  _CompanyCodeText.CompanyCodeName AS CompanyCodeName
FROM finiju_casejehdr
LEFT OUTER JOIN I_AccountingDocumentTypeText AS _AccountingDocumentTypeText ON AccountingDocumentType = _AccountingDocumentTypeText.AccountingDocumentType  -- association [0..*]
LEFT OUTER JOIN I_BusinessAreaText AS _PartnerBusinessAreaText ON PartnerBusinessArea = _PartnerBusinessAreaText.BusinessArea  -- association [0..*]
LEFT OUTER JOIN I_LedgerGroupText AS _LedgerGroupText ON LedgerGroup = _LedgerGroupText.LedgerGroup  -- association [0..*]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCodeText ON CompanyCode = _CompanyCodeText.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_JournalCase AS _JournalCase ON JournalCaseUUID = _JournalCase.JournalCaseUUID  -- association [0..1]
;