C_JournalCaseTP

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_JournalCaseTP.
-- 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 C_JournalCaseTP AS
SELECT
  JournalCaseUUID,
  JournalCase,
  JournalCaseName,
  JournalCaseSummaryText,
  JournalCaseCategory,
  JournalCaseSubcategory,
  FiscalYearVariant,
  FiscalYear,
  FiscalPeriod,
  FiscalYearPeriod,
  ReversalReason,
  _ReversalReason.ReversalReasonName AS ReversalReasonName,
  PlannedReversalDate,
  JournalCaseStatus,
  JournalCaseApprovalStatus,
  JrnlCaseAttchContentBinary,
  MimeType,
  JournalCaseAttachmentFileName,
  JrnlCasePrpslContentBinary,
  JrnlCasePrpslMimeType,
  JournalCaseProposalFileName,
  CreatedByUser,
  CreationDateTime,
  LastChangeByUser,
  LocalLastChangeDateTime,
  ResponsibleUser,
  _ResponsibleUser.PersonFullName AS ResponsibleUserFullName,
  _CaseCategory.JournalCaseCategoryName AS JournalCaseCategoryName,
  _CaseSubcategory.JournalCaseSubcategoryName AS JournalCaseSubcategoryName,
  _JournalCaseStatus.JournalCaseStatusName AS JournalCaseStatusName,
  _JournalCaseApprovalStatus.JournalCaseApprovalStatusName AS JournalCaseApprovalStatusName,
  JournalCasePolicyUUID,
  _FiscalYearVariantText.FiscalYearVariantDescription AS FiscalYearVariantDescription,
  _FiscalPeriodText.FiscalPeriodName AS FiscalPeriodName,
  _JrnlCaseProposal.SenderAccountingDocument AS SenderAccountingDocument,
  virtual UICT_Status :abap_boolean AS virtualUICT_Statusabap_boolean,
  virtual UICT_SUBMIT :abap_boolean AS virtualUICT_SUBMITabap_boolean,
  virtual UICT_DiscardProposal :abap_boolean AS virtualUICT_DiscardProposalabap_boolean,
  virtual UICT_UploadProposal :abap_boolean AS virtualUICT_UploadProposalabap_boolean,
  virtual UICT_DownloadProposal :abap_boolean AS virtualUICT_DownloadProposalabap_boolean,
  virtual UICT_Critical :abap.char( 1 ) AS char1,
  _Policy.JournalCasePolicy AS JournalCasePolicy,
  _Policy.JournalCasePolicyName AS JournalCasePolicyName,
  _CreatedBy.FullName AS CreatedByUserName,
  _ChangedBy.FullName AS ChangedByUserName
FROM R_JournalCaseTP
LEFT OUTER JOIN C_JournalCaseObjPgProposal AS _JournalProposal ON JournalCaseUUID = _JournalProposal.JournalCaseUUID  -- association [1..*]
LEFT OUTER JOIN C_JournalCaseApplicationLogTP AS _CaseAppLog ON JournalCaseUUID = _CaseAppLog.JournalCaseUUID  -- association [1..*]
LEFT OUTER JOIN C_JournalCaseHistory AS _CaseChangeLog ON JournalCaseUUID = _CaseChangeLog.JournalCaseUUID  -- association [0..*]
;