C_ServiceEntrySheetDEX

DDL: C_SERVICEENTRYSHEETDEX SQL: CMMSERVENTSHEET Type: view CONSUMPTION
22 Fields 1 Data Sources

Data Extraction for ServiceEntrySheet

C_ServiceEntrySheetDEX (Consumption)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

Service Entry Sheet · Sourcing & Procurement

C_ServiceEntrySheetDEX is a Consumption CDS View (Fact) that provides data about "Data Extraction for ServiceEntrySheet" in SAP S/4HANA. It reads from 1 data source (I_ServiceEntrySheetAPI01) and exposes 22 fields with key field ServiceEntrySheet.

SAP API Hub

StateC1
Line of BusinessSourcing & Procurement
Application ComponentMM-PUR-ANA
CapabilitiesData Source for Data Extraction
PackageSourcing & Procurement for SAP S/4HANA Cloud Private Edition

Documentation

Data Sources (1)

SourceAliasJoin Type
I_ServiceEntrySheetAPI01 I_ServiceEntrySheetAPI01 from

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName CMMSERVENTSHEET view
EndUserText.label Data Extraction for ServiceEntrySheet view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.supportedCapabilities #EXTRACTION_DATA_SOURCE view
VDM.viewType #CONSUMPTION view
Metadata.ignorePropagatedAnnotations true view
Analytics.dataCategory #FACT view
Analytics.dataExtraction.enabled true view

Fields (22)

KeyFieldSource TableSource FieldDescription
KEY ServiceEntrySheet ServiceEntrySheet Service Entry Sheet
ServiceEntrySheetName ServiceEntrySheetName Name of Service Entry Sheet
Supplier Supplier Account Number of Supplier
PurchaseOrder PurchaseOrder Reference Purchase Order
IsDeleted IsDeleted Deletion Indicator in Purchasing Document
ApprovalStatus ApprovalStatus Document Status for Service Entry Sheet
ApprovalDateTime ApprovalDateTime Date and Time of SES Approval (UTC)
ResponsiblePerson ResponsiblePerson Personnel Number
Currency Currency Valuation Crcy
MaterialDocument MaterialDocument Number of Material Document
MaterialDocumentYear MaterialDocumentYear Material Document Year
PurgDocExternalSystem PurgDocExternalSystem ID of External Reference System
PurgDocExternalReference PurgDocExternalReference External Reference ID
PostingDate PostingDate Posting Date for GR
PurchasingOrganization PurchasingOrganization Purchasing Organization
PurchasingGroup PurchasingGroup Purchasing Group
IsEndOfPurposeBlocked IsEndOfPurposeBlocked Business Purpose Completed
CreationDateTime CreationDateTime UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)
CreatedByUser CreatedByUser User Name
LastChangeDateTime LastChangeDateTime UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)
LastChangedByUser LastChangedByUser User Name
_ServiceEntrySheetItem _ServiceEntrySheetItem

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_ServiceEntrySheetDEX.
-- 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: CMMSERVENTSHEET

CREATE VIEW C_ServiceEntrySheetDEX AS
SELECT
  ServiceEntrySheet,
  ServiceEntrySheetName,
  Supplier,
  PurchaseOrder,
  IsDeleted,
  ApprovalStatus,
  ApprovalDateTime,
  ResponsiblePerson,
  Currency,
  MaterialDocument,
  MaterialDocumentYear,
  PurgDocExternalSystem,
  PurgDocExternalReference,
  PostingDate,
  PurchasingOrganization,
  PurchasingGroup,
  IsEndOfPurposeBlocked,
  CreationDateTime,
  CreatedByUser,
  LastChangeDateTime,
  LastChangedByUser
FROM I_ServiceEntrySheetAPI01
;

Learn More