R_JournalCaseDraft

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_JournalCaseDraft.
-- 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_JournalCaseDraft AS
SELECT
  finiju_case_d.journalcaseuuid AS JournalCaseUUID,
  finiju_case_d.journalcase AS JournalCase,
  finiju_case_d.fiscalyear AS FiscalYear,
  finiju_case_d.fiscalyearvariant AS FiscalYearVariant,
  finiju_case_d.journalcasecategory AS JournalCaseCategory,
  finiju_case_d.journalcasesubcategory AS JournalCaseSubcategory,
  finiju_case_d.journalcasestatus AS JournalCaseStatus,
  finiju_case_d.journalcaseapprovalstatus AS JournalCaseApprovalStatus,
  finiju_case_d.fiscalperiod AS FiscalPeriod,
  finiju_case_d.fiscalyearperiod AS FiscalYearPeriod,
  finiju_case_d.reversalreason AS ReversalReason,
  finiju_case_d.plannedreversaldate AS PlannedReversalDate,
  finiju_case_d.journalcasepolicyuuid AS JournalCasePolicyUUID,
  finiju_case_d.jrnlcaseattchcontentbinary AS JrnlCaseAttchContentBinary,
  finiju_case_d.mimetype AS MimeType,
  finiju_case_d.journalcaseattachmentfilename AS JournalCaseAttachmentFileName,
  finiju_case_d.createdbyuser AS CreatedByUser,
  finiju_case_d.creationdatetime AS CreationDateTime,
  finiju_case_d.lastchangebyuser AS LastChangeByUser,
  finiju_case_d.locallastchangedatetime AS LocalLastChangeDateTime,
  finiju_case_d.responsibleuser AS ResponsibleUser,
  finiju_case_d.journalcasename AS JournalCaseName,
  finiju_case_d.journalcasesummarytext AS JournalCaseSummaryText,
  finiju_case_d.jrnlcaseprpslcontentbinary AS JrnlCasePrpslContentBinary,
  finiju_case_d.jrnlcaseprpslmimetype AS JrnlCasePrpslMimeType,
  finiju_case_d.journalcaseproposalfilename AS JournalCaseProposalFileName,
  finiju_case_d.draftentitycreationdatetime AS DraftEntityCreationDateTime,
  finiju_case_d.draftentitylastchangedatetime AS DraftEntityLastChangeDateTime,
  finiju_case_d.draftadministrativedatauuid AS DraftAdministrativeDataUUID,
  finiju_case_d.draftentityoperationcode AS DraftEntityOperationCode,
  finiju_case_d.hasactiveentity AS HasActiveEntity,
  finiju_case_d.draftfieldchanges AS DraftFieldChanges,
  finiju_case_d.lastchangedatetime AS LastChangeDateTime,
  finiju_case_d.dummy_jrnl_case_incl_eew_ps AS RFM_Dummy
FROM finiju_case_d
LEFT OUTER JOIN E_JournalCaseDraft AS _Extension ON JournalCaseUUID = _Extension.JournalCaseUUID  -- association [1..1]
;