R_EntProjElmntLongDescDraft

DDL: R_ENTPROJELMNTLONGDESCDRAFT Type: view_entity BASIC Package: VDM_PPM_OBJECTS_TP_TASK
12 Fields 1 Data Sources 2 Associations

EnterpriseProj Element Long text - Draft

R_EntProjElmntLongDescDraft is a Basic CDS View that provides data about "EnterpriseProj Element Long text - Draft" in SAP S/4HANA. It reads from 1 data source (entprojelmtxt_d) and exposes 12 fields with key field EntProjElmntLongTextUUID. It has 2 associations to related views. Part of development package VDM_PPM_OBJECTS_TP_TASK.

Data Sources (1)

SourceAliasJoin Type
entprojelmtxt_d EntProjectElementLtxtDraft from

Associations (2)

CardinalityTargetAliasCondition
[1..1] R_EnterpriseProject _EnterpriseProject _EnterpriseProject.ProjectUUID = $projection.ProjectUUID
[1..1] R_EnterpriseProjectElement _ProjectElement _ProjectElement.ProjectElementUUID = $projection.ProjectElementUUID

Annotations (9)

NameValueLevelField
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
AbapCatalog.dataMaintenance #RESTRICTED view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #M view
EndUserText.label EnterpriseProj Element Long text - Draft view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY EntProjElmntLongTextUUID entprojelmtxt_d entprojelmntlongtextuuid Entity GUID
ProjectElementUUID entprojelmtxt_d projectelementuuid Obj Link Entity GUID
ProjectUUID entprojelmtxt_d projectuuid Project UUID
LongText entprojelmtxt_d longtext Text Name
DraftAdministrativeDataUUID entprojelmtxt_d draftadministrativedatauuid UUID
DraftEntityCreationDateTime entprojelmtxt_d draftentitycreationdatetime Draft Created On
DraftEntityLastChangeDateTime entprojelmtxt_d draftentitylastchangedatetime Draft Last Changed On
DraftFieldChanges entprojelmtxt_d draftfieldchanges Field Changes
HasActiveEntity entprojelmtxt_d hasactiveentity TRUE
DraftEntityOperationCode entprojelmtxt_d draftentityoperationcode Draft - Operation Code
_EnterpriseProject _EnterpriseProject
_ProjectElement _ProjectElement

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_EntProjElmntLongDescDraft.
-- 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_EntProjElmntLongDescDraft AS
SELECT
  EntProjectElementLtxtDraft.entprojelmntlongtextuuid AS EntProjElmntLongTextUUID,
  EntProjectElementLtxtDraft.projectelementuuid AS ProjectElementUUID,
  EntProjectElementLtxtDraft.projectuuid AS ProjectUUID,
  EntProjectElementLtxtDraft.longtext AS LongText,
  EntProjectElementLtxtDraft.draftadministrativedatauuid AS DraftAdministrativeDataUUID,
  EntProjectElementLtxtDraft.draftentitycreationdatetime AS DraftEntityCreationDateTime,
  EntProjectElementLtxtDraft.draftentitylastchangedatetime AS DraftEntityLastChangeDateTime,
  EntProjectElementLtxtDraft.draftfieldchanges AS DraftFieldChanges,
  EntProjectElementLtxtDraft.hasactiveentity AS HasActiveEntity,
  EntProjectElementLtxtDraft.draftentityoperationcode AS DraftEntityOperationCode
FROM entprojelmtxt_d AS EntProjectElementLtxtDraft
LEFT OUTER JOIN R_EnterpriseProject AS _EnterpriseProject ON _EnterpriseProject.ProjectUUID = ProjectUUID  -- association [1..1]
LEFT OUTER JOIN R_EnterpriseProjectElement AS _ProjectElement ON _ProjectElement.ProjectElementUUID = ProjectElementUUID  -- association [1..1]
;

Learn More