Deprecated PUBLIC_LOCAL_API
This CDS view is deprecated in S/4HANA. Use I_ServiceEntrySheet instead. View all deprecated CDS views →

I_ServEntDetails

DDL: I_SERVENTDETAILS SQL: ISRVENTDET Type: view BASIC

Service Entry Sheet Details

I_ServEntDetails is a Basic CDS View that provides data about "Service Entry Sheet Details" in SAP S/4HANA. It reads from 1 data source (P_ServEntDetails) and exposes 7 fields with key field ServiceEntrySheet.

Data Sources (1)

SourceAliasJoin Type
P_ServEntDetails P_ServEntDetails from

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName ISRVENTDET view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Service Entry Sheet Details view
VDM.lifecycle.status #DEPRECATED view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
VDM.lifecycle.successor I_ServiceEntrySheet view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY ServiceEntrySheet ServiceEntrySheet Service Entry Sheet
PurchaseOrder PurchaseOrder Purchasing Document
PurchaseOrderItem PurchaseOrderItem Purchasing Document Item
TotalNetAmount TotalNetAmount Total Net Amount
Currency Currency Valuation Crcy
CreationDate CreationDate Time Stamp
OrderStatusText OrderStatusText

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_ServEntDetails.
-- 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: ISRVENTDET

CREATE VIEW I_ServEntDetails AS
SELECT
  ServiceEntrySheet,
  PurchaseOrder,
  PurchaseOrderItem,
  TotalNetAmount,
  Currency,
  CreationDate,
  OrderStatusText
FROM P_ServEntDetails
;