C_JournalCasePostingPolicyTP

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_JournalCasePostingPolicyTP.
-- 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_JournalCasePostingPolicyTP AS
SELECT
  JournalCasePolicyUUID,
  JournalCasePolicy,
  JournalCasePolicyVersion,
  JournalCaseCategory,
  JournalCaseSubcategory,
  JournalCasePolicyName,
  JournalCasePolicyStatus,
  JrnlCasePolicyExtractionStatus,
  JrnlCasePlcyActnMappingStatus,
  ValidityStartDate,
  ValidityEndDate,
  JrnlCasePlcyAttchContentBinary,
  MimeType,
  JrnlCasePlcyAttachmentFileName,
  virtual UICT_SUBMIT :abap_boolean AS virtualUICT_SUBMITabap_boolean,
  virtual UICT_CRITICAL :abap.char( 1 ) AS char1,
  virtual UICT_INSTRNACTION :abap_boolean AS virtualUICT_INSTRNACTIONabap_boolean,
  _CaseCategory.JournalCaseCategoryName AS JournalCaseCategoryName,
  _CaseSubcategory.JournalCaseSubcategoryName AS JournalCaseSubcategoryName,
  _PolicyStatus.JournalCasePolicyStatusName AS JournalCasePolicyStatusName,
  CreatedByUser,
  CreationDateTime,
  LastChangeByUser,
  LocalLastChangeDateTime,
  _CreatedBy.FullName AS CreatedByUserFullName,
  _ChangedBy.FullName AS LastChangedByUserFullName
FROM R_JournalCasePostingPolicyTP
LEFT OUTER JOIN C_JrnlCasePlcyApplicationLogTP AS _PolicyAppLog ON JournalCasePolicyUUID = _PolicyAppLog.JournalCasePolicyUUID  -- association [0..*]
LEFT OUTER JOIN C_JournalCasePostingPolicyHist AS _PolicyChgLog ON JournalCasePolicyUUID = _PolicyChgLog.JournalCasePolicyUUID  -- association [0..*]
LEFT OUTER JOIN C_JrnlPlcyInstrnActionMapping AS _InstrnActionMap ON JournalCasePolicyUUID = _InstrnActionMap.JournalCasePolicyUUID  -- association [0..*]
;