C_ProjectTextObjectTP

DDL: C_PROJECTTEXTOBJECTTP Type: view_entity CONSUMPTION Package: ODATA_PROJECT_TEXT
26 Fields 1 Data Sources 1 OData Services

Consumption Data of PS - Text

C_ProjectTextObjectTP is a Consumption CDS View that provides data about "Consumption Data of PS - Text" in SAP S/4HANA. It reads from 1 data source (R_ProjectTextObjectTP) and exposes 26 fields with key fields ProjectTextInternalID, ProjectTextDraftInternalUUID. It is exposed through 1 OData service (PS_PROJECTTEXT). Part of development package ODATA_PROJECT_TEXT.

Data Sources (1)

SourceAliasJoin Type
R_ProjectTextObjectTP R_ProjectTextObjectTP projection

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
Metadata.allowExtensions true view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
EndUserText.label Consumption Data of PS - Text view

OData Services (1)

ServiceBindingVersionContractRelease
PS_PROJECTTEXT PS_PROJECTTEXT V2 C1 NOT_RELEASED

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY ProjectTextInternalID ProjectTextInternalID
KEY ProjectTextDraftInternalUUID ProjectTextDraftInternalUUID
ProjTextType ProjTextType
char30 Project Text Description
ProjTextShortDescription ProjTextShortDescription
CreatedByUser CreatedByUser User Name
CreationDate CreationDate Time Stamp
LastChangeByUser LastChangeByUser User Name
LastChangedDate LastChangedDate Created On
ProjTextLongTxt ProjTextLongTxt
ProjTextFirstLineOfLongTxt ProjTextFirstLineOfLongTxt
Language Language Report Text Language
LanguageName _ProjTextLongTextData LanguageName Name
int4
int4
int4
int4
int4 Number of Assignments
virtualProjectps_pspid_edit
virtualStdProjectps_pspid_edit
virtualWBSElementps_s4_posid
virtualStdWBSElementps_s4_posid
virtualProjectNetworkps_s4_aufnr
virtualStdNetworkplnnr
virtualNetworkActivityps_s4_vornr
virtualStdNetworkActivityps_s4_vornr

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_ProjectTextObjectTP.
-- 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_ProjectTextObjectTP AS
SELECT
  ProjectTextInternalID,
  ProjectTextDraftInternalUUID,
  ProjTextType,
  virtual FormattedProjTextDesc : abap.char(30) AS char30,
  ProjTextShortDescription,
  CreatedByUser,
  CreationDate,
  LastChangeByUser,
  LastChangedDate,
  ProjTextLongTxt,
  ProjTextFirstLineOfLongTxt,
  Language,
  _ProjTextLongTextData.LanguageName AS LanguageName,
  virtual NumberOfWBSElements : abap.int4 AS int4,
  virtual Project : ps_pspid_edit AS virtualProjectps_pspid_edit,
  virtual StdProject : ps_pspid_edit AS virtualStdProjectps_pspid_edit,
  virtual WBSElement : ps_s4_posid AS virtualWBSElementps_s4_posid,
  virtual StdWBSElement : ps_s4_posid AS virtualStdWBSElementps_s4_posid,
  virtual ProjectNetwork : ps_s4_aufnr AS virtualProjectNetworkps_s4_aufnr,
  virtual StdNetwork : plnnr AS virtualStdNetworkplnnr,
  virtual NetworkActivity : ps_s4_vornr AS virtualNetworkActivityps_s4_vornr,
  virtual StdNetworkActivity : ps_s4_vornr AS virtualStdNetworkActivityps_s4_vornr
FROM R_ProjectTextObjectTP
;

Learn More