I_ETOProcessObjectTP

DDL: I_ETOPROCESSOBJECTTP SQL: IETOPROBJTP Type: view TRANSACTIONAL
15 Fields 1 Data Sources 1 Associations

Transactnl View for ETO Process Object

I_ETOProcessObjectTP is a Transactional CDS View that provides data about "Transactnl View for ETO Process Object" in SAP S/4HANA. It reads from 1 data source (I_ETOProcessObject) and exposes 15 fields with key field ETOProcessObjectUUID. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_ETOProcessObject ETOProcessObject from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_ETOProcessObjectStatusTP _ETOProcessObjectStatus $projection.ETOProcessObjectUUID = _ETOProcessObjectStatus.ETOProcessObjectUUID

Annotations (20)

NameValueLevelField
AbapCatalog.sqlViewName IETOPROBJTP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Transactnl View for ETO Process Object view
Search.searchable false view
VDM.viewType #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.transactionalProcessingEnabled true view
ObjectModel.draftEnabled true view
ObjectModel.compositionRoot true view
ObjectModel.writeDraftPersistence ETO_PROBJ_D view
ObjectModel.writeActivePersistence ETO_PROBJ view
ObjectModel.entityChangeStateId LastChangeDateTime view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY ETOProcessObjectUUID I_ETOProcessObject ETOProcessObjectUUID ETO Item ID
SalesOrder I_ETOProcessObject SalesOrder SD Document
SalesOrderItem I_ETOProcessObject SalesOrderItem Sales Order Item
ETOBaseConfigurationNumber I_ETOProcessObject ETOBaseConfigurationNumber Base Config. Number
ETOSlsSnpshtConfignNumber I_ETOProcessObject ETOSlsSnpshtConfignNumber Snapshot Config. No.
ETOEngSnpshtConfignNumber I_ETOProcessObject ETOEngSnpshtConfignNumber Snapshot Config. No.
CreationDateTime I_ETOProcessObject CreationDateTime Timestamp
LastChangeDateTime I_ETOProcessObject LastChangeDateTime Timestamp
CreatedByUser I_ETOProcessObject CreatedByUser User Name
LastChangedByUser I_ETOProcessObject LastChangedByUser User Name
StatusObjectNumber I_ETOProcessObject StatusObjectNumber Object number
ETODepdntDtaLastChangeDateTime I_ETOProcessObject ETODepdntDtaLastChangeDateTime DepDataLastChange
ETOProcessIsCompleted I_ETOProcessObject ETOProcessIsCompleted TRUE
ETOProcessObjectStatusFilter
_ETOProcessObjectStatus _ETOProcessObjectStatus

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_ETOProcessObjectTP.
-- 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: IETOPROBJTP

CREATE VIEW I_ETOProcessObjectTP AS
SELECT
  ETOProcessObject.ETOProcessObjectUUID AS ETOProcessObjectUUID,
  ETOProcessObject.SalesOrder AS SalesOrder,
  ETOProcessObject.SalesOrderItem AS SalesOrderItem,
  ETOProcessObject.ETOBaseConfigurationNumber AS ETOBaseConfigurationNumber,
  ETOProcessObject.ETOSlsSnpshtConfignNumber AS ETOSlsSnpshtConfignNumber,
  ETOProcessObject.ETOEngSnpshtConfignNumber AS ETOEngSnpshtConfignNumber,
  ETOProcessObject.CreationDateTime AS CreationDateTime,
  ETOProcessObject.LastChangeDateTime AS LastChangeDateTime,
  ETOProcessObject.CreatedByUser AS CreatedByUser,
  ETOProcessObject.LastChangedByUser AS LastChangedByUser,
  ETOProcessObject.StatusObjectNumber AS StatusObjectNumber,
  ETOProcessObject.ETODepdntDtaLastChangeDateTime AS ETODepdntDtaLastChangeDateTime,
  ETOProcessObject.ETOProcessIsCompleted AS ETOProcessIsCompleted,
  cast(' ' as j_status preserving type) AS ETOProcessObjectStatusFilter
FROM I_ETOProcessObject AS ETOProcessObject
LEFT OUTER JOIN I_ETOProcessObjectStatusTP AS _ETOProcessObjectStatus ON ETOProcessObjectUUID = _ETOProcessObjectStatus.ETOProcessObjectUUID  -- association [0..*]
;

Learn More