C_ETOProcessObjectTP

DDL: C_ETOPROCESSOBJECTTP SQL: CETOPROBJTP Type: view CONSUMPTION
25 Fields 1 Data Sources 5 Associations

Consumption View for ETO Process Object

C_ETOProcessObjectTP is a Consumption CDS View that provides data about "Consumption View for ETO Process Object" in SAP S/4HANA. It reads from 1 data source (I_ETOProcessObjectTP) and exposes 25 fields with key field ETOProcessObjectUUID. It has 5 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_ETOProcessObjectTP ETOProcessObject from

Associations (5)

CardinalityTargetAliasCondition
[0..*] C_ETOProcessObjectStatusTP _ETOProcessObjectStatus $projection.ETOProcessObjectUUID = _ETOProcessObjectStatus.ETOProcessObjectUUID
[1..1] I_SalesOrder _SalesDocument _SalesDocument.SalesOrder = ETOProcessObject.SalesOrder
[1..1] I_SalesOrderItem _SalesDocumentItem _SalesDocumentItem.SalesOrder = ETOProcessObject.SalesOrder and _SalesDocumentItem.SalesOrderItem = ETOProcessObject.SalesOrderItem
[0..1] I_ProductText _ProductDescSystLanguage _ProductDescSystLanguage.Product = $projection.Product and _ProductDescSystLanguage.Language = $session.system_language
[0..1] P_VarConfignProductInstance _VarConfignInstance _VarConfignInstance.VariantConfigurationInstance = ETOProcessObject.ETOBaseConfigurationNumber and _VarConfignInstance.BusObjIsVarConfignOwner = 'X'

Annotations (21)

NameValueLevelField
AbapCatalog.sqlViewName CETOPROBJTP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AbapCatalog.dataMaintenance #RESTRICTED view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label Consumption View for ETO Process Object view
Search.searchable true view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.transactionalProcessingDelegated true view
ObjectModel.draftEnabled true view
ObjectModel.compositionRoot true view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.alternativeKey.id ActiveUUID view
ObjectModel.alternativeKey.uniqueness #UNIQUE_IF_NOT_INITIAL view

Fields (25)

KeyFieldSource TableSource FieldDescription
KEY ETOProcessObjectUUID I_ETOProcessObjectTP ETOProcessObjectUUID ETO Item ID
SalesOrder I_ETOProcessObjectTP SalesOrder SD Document
SalesOrderItem I_ETOProcessObjectTP SalesOrderItem Sales Order Item
ETOBaseConfigurationNumber I_ETOProcessObjectTP ETOBaseConfigurationNumber Base Config. Number
ETOSlsSnpshtConfignNumber I_ETOProcessObjectTP ETOSlsSnpshtConfignNumber Snapshot Config. No.
ETOEngSnpshtConfignNumber I_ETOProcessObjectTP ETOEngSnpshtConfignNumber Snapshot Config. No.
CreationDateTime I_ETOProcessObjectTP CreationDateTime Timestamp
CreatedByUser I_ETOProcessObjectTP CreatedByUser User Name
LastChangeDateTime I_ETOProcessObjectTP LastChangeDateTime Timestamp
LastChangedByUser I_ETOProcessObjectTP LastChangedByUser User Name
StatusObjectNumber I_ETOProcessObjectTP StatusObjectNumber Object number
ETOProcessObjectStatusFilter I_ETOProcessObjectTP ETOProcessObjectStatusFilter
ETOProcessIsCompleted I_ETOProcessObjectTP ETOProcessIsCompleted TRUE
Product _SalesDocumentItem Product Product Sold
SalesOrderItemQuantity _SalesDocumentItem OrderQuantity Quantity
OrderQuantityUnit _SalesDocumentItem OrderQuantityUnit Sales Unit
SoldToParty _SalesDocument SoldToParty Sold-to Party
VariantConfigurationDate _VarConfignInstance VariantConfigurationDate
_ProductDescSystLanguage _ProductDescSystLanguage
_ETOProcessObjectStatus _ETOProcessObjectStatus
_SalesDocument _SalesDocument
_SalesDocumentItem _SalesDocumentItem
_Product _SalesDocumentItem _Product
_OrderQuantityUnit _SalesDocumentItem _OrderQuantityUnit
_SoldToParty _SalesDocument _SoldToParty

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_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: CETOPROBJTP

CREATE VIEW C_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.CreatedByUser AS CreatedByUser,
  ETOProcessObject.LastChangeDateTime AS LastChangeDateTime,
  ETOProcessObject.LastChangedByUser AS LastChangedByUser,
  ETOProcessObject.StatusObjectNumber AS StatusObjectNumber,
  ETOProcessObject.ETOProcessObjectStatusFilter AS ETOProcessObjectStatusFilter,
  ETOProcessObject.ETOProcessIsCompleted AS ETOProcessIsCompleted,
  _SalesDocumentItem.Product AS Product,
  _SalesDocumentItem.OrderQuantity AS SalesOrderItemQuantity,
  _SalesDocumentItem.OrderQuantityUnit AS OrderQuantityUnit,
  _SalesDocument.SoldToParty AS SoldToParty,
  _VarConfignInstance.VariantConfigurationDate AS VariantConfigurationDate,
  _SalesDocumentItem._Product AS _Product,
  _SalesDocumentItem._OrderQuantityUnit AS _OrderQuantityUnit,
  _SalesDocument._SoldToParty AS _SoldToParty
FROM I_ETOProcessObjectTP AS ETOProcessObject
LEFT OUTER JOIN C_ETOProcessObjectStatusTP AS _ETOProcessObjectStatus ON ETOProcessObjectUUID = _ETOProcessObjectStatus.ETOProcessObjectUUID  -- association [0..*]
LEFT OUTER JOIN I_SalesOrder AS _SalesDocument ON _SalesDocument.SalesOrder = ETOProcessObject.SalesOrder  -- association [1..1]
LEFT OUTER JOIN I_SalesOrderItem AS _SalesDocumentItem ON _SalesDocumentItem.SalesOrder = ETOProcessObject.SalesOrder AND _SalesDocumentItem.SalesOrderItem = ETOProcessObject.SalesOrderItem  -- association [1..1]
LEFT OUTER JOIN I_ProductText AS _ProductDescSystLanguage ON _ProductDescSystLanguage.Product = Product AND _ProductDescSystLanguage.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN P_VarConfignProductInstance AS _VarConfignInstance ON _VarConfignInstance.VariantConfigurationInstance = ETOProcessObject.ETOBaseConfigurationNumber AND _VarConfignInstance.BusObjIsVarConfignOwner = 'X'  -- association [0..1]
;

Learn More