I_JournalEntryProposal

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_JournalEntryProposal.
-- 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_JournalEntryProposal AS
SELECT
  dft_ac_hdr.root_key AS JournalEntryProposalUUID,
  dft_ac_hdr.bukrs AS CompanyCode,
  cast( dft_ac_hdr.gjahr as fis_gjahr_no_conv preserving type ) AS FiscalYear,
  cast( dft_ac_hdr.belnr as fis_belnr ) AS AccountingDocument,
  dft_hdr.id AS JournalEntryProposalDisplayID,
  dft_prpsl.status AS JrnlEntrAIAgtProposalStatus,
  dft_prpsl.category AS JournalEntryProposalCategory,
  dft_ac_hdr.tcode AS TransactionCode,
  cast( dft_ac_hdr.grpid as jrnl_entr_prpsl_batch_id ) AS JournalEntryProposalBatchID,
  dft_ac_hdr.blart AS AccountingDocumentType,
  dft_ac_hdr.bldat AS DocumentDate,
  dft_ac_hdr.budat AS PostingDate,
  cast( concat( '0', dft_ac_hdr.monat ) as fins_fiscalperiod ) AS FiscalPeriod,
  dft_ac_hdr.bktxt AS AccountingDocumentHeaderText,
  dft_ac_hdr.waers AS TransactionCurrency,
  dft_ac_hdr.ldgrp AS LedgerGroup,
  cast(abs(dft_ac_hdr.kursf) as fis_absolute_exchangerate preserving type) AS AbsoluteExchangeRate,
  dft_ac_hdr.wwert AS ExchangeRateDate,
  cast( dft_ac_hdr.xblnr as fis_xblnr1 preserving type ) AS DocumentReferenceID,
  dft_ac_hdr.fulfilldate AS TaxFulfillmentDate,
  cast( dft_ac_hdr.xmwst as fis_xmwst preserving type ) AS TaxIsCalculatedAutomatically,
  dft_ac_hdr.stgrd AS ReversalReason,
  dft_ac_hdr.stodt AS PlannedReversalDate,
  dft_prpsl.spras AS OriginalLanguage,
  dft_prpsl.reasoning AS JrnlEntrPrpslOriglReasoningTxt,
  dft_prpsl.step AS JrnlEntrPrpslOriginalStepText,
  dft_prpsl.created_by_user AS CreatedByUser,
  dft_prpsl.creation_datetime AS CreationDateTime,
  dft_prpsl.last_changed_by_user AS LastChangedByUser,
  dft_prpsl.last_change_datetime AS LastChangeDateTime,
  cast( _JournalEntry.AccountingDocCreatedByUser as fdc_agent_prpsl_je_created_by ) AS JournalEntryCreatedByUser,
  dft_ac_hdr.tmpid AS JrnlEntryProposalTemporaryID
FROM fdc_d_dft_ac_hdr AS dft_ac_hdr
INNER JOIN fdc_d_dft_hdr AS dft_hdr ON /* join condition not captured in parsed metadata */
INNER JOIN fdc_agent_prpsl AS dft_prpsl ON /* join condition not captured in parsed metadata */
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 [0..1]
LEFT OUTER JOIN I_User AS _CreatedByUser ON CreatedByUser = _CreatedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_User AS _LastChangedByUser ON LastChangedByUser = _LastChangedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_User AS _JournalEntryCreatedByUser ON JournalEntryCreatedByUser = _JournalEntryCreatedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_JrnlEntrAIAgtProposalStatus AS _JrnlEntrAIAgtProposalStatus ON JrnlEntrAIAgtProposalStatus = _JrnlEntrAIAgtProposalStatus.JrnlEntrAIAgtProposalStatus  -- association [0..1]
LEFT OUTER JOIN I_ReversalReason AS _ReversalReason ON ReversalReason = _ReversalReason.ReversalReason  -- association [0..1]
LEFT OUTER JOIN I_JrnlEntrPrpslRecmddContent AS _ProposalText ON JournalEntryProposalUUID = _ProposalText.JournalEntryProposalUUID  -- association [0..*]
;