R_EntProjElmntJVADraft

DDL: R_ENTPROJELMNTJVADRAFT Type: view_entity BASIC Package: VDM_PPM_OBJECTS_TP_TASK
19 Fields 1 Data Sources 2 Associations

Enterprise Project Element JVA - Draft

R_EntProjElmntJVADraft is a Basic CDS View that provides data about "Enterprise Project Element JVA - Draft" in SAP S/4HANA. It reads from 1 data source (entprojelemjva_d) and exposes 19 fields with key field ProjectElementUUID. It has 2 associations to related views. Part of development package VDM_PPM_OBJECTS_TP_TASK.

Data Sources (1)

SourceAliasJoin Type
entprojelemjva_d EntProjectElementJVADraft 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 Enterprise Project Element JVA - Draft view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY ProjectElementUUID entprojelemjva_d projectelementuuid Obj Link Entity GUID
WBSElementInternalID entprojelemjva_d wbselementinternalid WBS Internal ID
ProjectUUID entprojelemjva_d projectuuid Project UUID
JointVenture entprojelemjva_d jointventure Joint venture
JointVentureCostRecoveryCode entprojelemjva_d jointventurecostrecoverycode Recovery Ind.
JointVentureEquityType entprojelemjva_d jointventureequitytype Joint Venture Equity Type
JntVntrProjectType entprojelemjva_d jntvntrprojecttype JV Object Type
JntIntrstBillgClass entprojelemjva_d jntintrstbillgclass JIB/JIBE Class
JntIntrstBillgSubClass entprojelemjva_d jntintrstbillgsubclass JIB/JIBE SbClsA
JointVentureType entprojelemjva_d jointventuretype Venture Type
CompanyCode entprojelemjva_d companycode Receiver Company Code
DraftAdministrativeDataUUID entprojelemjva_d draftadministrativedatauuid UUID
DraftEntityCreationDateTime entprojelemjva_d draftentitycreationdatetime Draft Created On
DraftEntityLastChangeDateTime entprojelemjva_d draftentitylastchangedatetime Draft Last Changed On
DraftFieldChanges entprojelemjva_d draftfieldchanges Field Changes
HasActiveEntity entprojelemjva_d hasactiveentity TRUE
DraftEntityOperationCode entprojelemjva_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_EntProjElmntJVADraft.
-- 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_EntProjElmntJVADraft AS
SELECT
  EntProjectElementJVADraft.projectelementuuid AS ProjectElementUUID,
  EntProjectElementJVADraft.wbselementinternalid AS WBSElementInternalID,
  EntProjectElementJVADraft.projectuuid AS ProjectUUID,
  EntProjectElementJVADraft.jointventure AS JointVenture,
  EntProjectElementJVADraft.jointventurecostrecoverycode AS JointVentureCostRecoveryCode,
  EntProjectElementJVADraft.jointventureequitytype AS JointVentureEquityType,
  EntProjectElementJVADraft.jntvntrprojecttype AS JntVntrProjectType,
  EntProjectElementJVADraft.jntintrstbillgclass AS JntIntrstBillgClass,
  EntProjectElementJVADraft.jntintrstbillgsubclass AS JntIntrstBillgSubClass,
  EntProjectElementJVADraft.jointventuretype AS JointVentureType,
  EntProjectElementJVADraft.companycode AS CompanyCode,
  EntProjectElementJVADraft.draftadministrativedatauuid AS DraftAdministrativeDataUUID,
  EntProjectElementJVADraft.draftentitycreationdatetime AS DraftEntityCreationDateTime,
  EntProjectElementJVADraft.draftentitylastchangedatetime AS DraftEntityLastChangeDateTime,
  EntProjectElementJVADraft.draftfieldchanges AS DraftFieldChanges,
  EntProjectElementJVADraft.hasactiveentity AS HasActiveEntity,
  EntProjectElementJVADraft.draftentityoperationcode AS DraftEntityOperationCode
FROM entprojelemjva_d AS EntProjectElementJVADraft
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