I_BusSolnOrdItmFUPEntProject

DDL: I_BUSSOLNORDITMFUPENTPROJECT Type: view COMPOSITE
9 Fields 1 Data Sources 2 Associations

Follow up Enterprise Project Items

I_BusSolnOrdItmFUPEntProject is a Composite CDS View that provides data about "Follow up Enterprise Project Items" in SAP S/4HANA. It reads from 1 data source (I_ServiceDocumentItemSuccssr_3) and exposes 9 fields with key fields ServiceDocumentItmRelationUUID, ServiceDocItmRltnSqncNumber. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_ServiceDocumentItemSuccssr_3 I_ServiceDocumentItemSuccssr_3 from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_ServiceDocumentItem _BusSolnOrdEntProjectItem _BusSolnOrdEntProjectItem.ServiceObjectType = 'BUS2000172' and _BusSolnOrdEntProjectItem.ServiceDocumentItemCharUUID = $projection.BusSolnOrderItemCharUUID
[0..1] I_BusSolnOrdFUPEntProject _BusSolnOrdEntProject _BusSolnOrdEntProject.ServiceDocumentRelationUUID = I_ServiceDocumentItemSuccssr_3.ServiceDocumentItmRelationUUID

Annotations (12)

NameValueLevelField
EndUserText.label Follow up Enterprise Project Items view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName IBSOFUPENTPRJITM view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
Metadata.ignorePropagatedAnnotations true view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY ServiceDocumentItmRelationUUID ServiceDocumentItmRelationUUID GUID link
KEY ServiceDocItmRltnSqncNumber ServiceDocItmRltnSqncNumber Sequential no.
BusinessSolutionOrder _BusSolnOrdEntProjectItem ServiceDocument Transaction ID
BusinessSolutionOrderItem _BusSolnOrdEntProjectItem ServiceDocumentItem Service Document
ProjectUUID _BusSolnOrdEntProject ProjectUUID Project UUID
Project _BusSolnOrdEntProject Project WBS Element
BusSolnOrderItemCharUUID ServiceDocumentItemCharUUID
_BusSolnOrdEntProjectItem _BusSolnOrdEntProjectItem
_EnterpriseProject _BusSolnOrdEntProject _EnterpriseProject

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_BusSolnOrdItmFUPEntProject.
-- 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 I_BusSolnOrdItmFUPEntProject AS
SELECT
  ServiceDocumentItmRelationUUID,
  ServiceDocItmRltnSqncNumber,
  _BusSolnOrdEntProjectItem.ServiceDocument AS BusinessSolutionOrder,
  _BusSolnOrdEntProjectItem.ServiceDocumentItem AS BusinessSolutionOrderItem,
  _BusSolnOrdEntProject.ProjectUUID AS ProjectUUID,
  _BusSolnOrdEntProject.Project AS Project,
  ServiceDocumentItemCharUUID AS BusSolnOrderItemCharUUID,
  _BusSolnOrdEntProject._EnterpriseProject AS _EnterpriseProject
FROM I_ServiceDocumentItemSuccssr_3
LEFT OUTER JOIN I_ServiceDocumentItem AS _BusSolnOrdEntProjectItem ON _BusSolnOrdEntProjectItem.ServiceObjectType = 'BUS2000172' AND _BusSolnOrdEntProjectItem.ServiceDocumentItemCharUUID = BusSolnOrderItemCharUUID  -- association [0..1]
LEFT OUTER JOIN I_BusSolnOrdFUPEntProject AS _BusSolnOrdEntProject ON _BusSolnOrdEntProject.ServiceDocumentRelationUUID = I_ServiceDocumentItemSuccssr_3.ServiceDocumentItmRelationUUID  -- association [0..1]
;

Learn More