I_PPM_ChecklistItemText

DDL: I_PPM_CHECKLISTITEMTEXT SQL: IPPMCHKLSTITMTXT Type: view COMPOSITE

Check item text

I_PPM_ChecklistItemText is a Composite CDS View that provides data about "Check item text" in SAP S/4HANA. It reads from 5 data sources (I_PPM_ChecklistItem, I_PPM_ProjectRoot, I_PPM_Task, I_PPM_Text, I_PPM_Text) and exposes 5 fields with key field ChecklistItemUUID.

Data Sources (5)

SourceAliasJoin Type
I_PPM_ChecklistItem entity from
I_PPM_ProjectRoot ProjectRoot left_outer
I_PPM_Task task left_outer
I_PPM_Text TextLogon left_outer
I_PPM_Text TextMaster left_outer

Annotations (10)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view
AbapCatalog.sqlViewName IPPMCHKLSTITMTXT view
AbapCatalog.compiler.compareFilter true view
EndUserText.label Check item text view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY ChecklistItemUUID I_PPM_ChecklistItem ChecklistItemUUID
_AuthUser I_PPM_ChecklistItem _AuthUser
_AuthSubst I_PPM_ChecklistItem _AuthSubst
_AuthRole I_PPM_ChecklistItem _AuthRole
_AuthGroup I_PPM_ChecklistItem _AuthGroup

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_PPM_ChecklistItemText.
-- 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.
-- SQL view name: IPPMCHKLSTITMTXT

CREATE VIEW I_PPM_ChecklistItemText AS
SELECT
  entity.ChecklistItemUUID AS ChecklistItemUUID,
  entity._AuthUser AS _AuthUser,
  entity._AuthSubst AS _AuthSubst,
  entity._AuthRole AS _AuthRole,
  entity._AuthGroup AS _AuthGroup
FROM I_PPM_ChecklistItem AS entity
LEFT OUTER JOIN I_PPM_Task AS task ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PPM_ProjectRoot AS ProjectRoot ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PPM_Text AS TextLogon ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PPM_Text AS TextMaster ON /* join condition not captured in parsed metadata */
;