I_ServiceEntrySheetAPI01

DDL: I_SERVICEENTRYSHEETAPI01 SQL: IMMSESAPI01 Type: view BASIC
23 Fields 1 Data Sources 2 Associations

Service Entry Sheet

I_ServiceEntrySheetAPI01 (Basic)

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

Sourcing & Procurement

I_ServiceEntrySheetAPI01 is a Basic CDS View that provides data about "Service Entry Sheet" in SAP S/4HANA. It reads from 1 data source (I_ServiceEntrySheetBasic) and exposes 23 fields with key field ServiceEntrySheet. It has 2 associations to related views.

SAP API Hub

StateC1
Line of BusinessSourcing & Procurement
Application ComponentMM-PUR-SVC-SES
CapabilitiesData Source in SQL Select
PackageSourcing & Procurement for SAP S/4HANA Cloud Private Edition
Description <p>This CDS view provides the prerequisites for answering questions about service entry sheets for lean services, such as:</p> <ul> <li><p>How many service entry sheets have been approved/rejected for which suppliers in the last 3 months? </p></li> <li><p>Who are my top 10 suppliers for lean services?</p></li> <li><p>How many service entry sheets have been created in a specific period?</p></li> <li><p>How many service entry sheets have been rejected in a specific purchasing organization?</p></li> <li><p>Which service entry sheets have been generated from time sheets in the last year? </p></li> </ul>

Documentation

Data Sources (1)

SourceAliasJoin Type
I_ServiceEntrySheetBasic I_ServiceEntrySheetBasic from

Associations (2)

CardinalityTargetAliasCondition
[1..*] I_ServiceEntrySheetItemAPI01 _ServiceEntrySheetItem $projection.ServiceEntrySheet = _ServiceEntrySheetItem.ServiceEntrySheet
[0..1] E_ServiceEntrySheet _ServiceEntrySheetExtension $projection.ServiceEntrySheet = _ServiceEntrySheetExtension.ServiceEntrySheet

Annotations (12)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName IMMSESAPI01 view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #BASIC view
EndUserText.label Service Entry Sheet view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
Metadata.ignorePropagatedAnnotations true view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view

Fields (23)

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
OriginObjectType OriginObjectType Origin of Service Entry Sheet
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 LastChangeUser 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 I_ServiceEntrySheetAPI01.
-- 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: IMMSESAPI01

CREATE VIEW I_ServiceEntrySheetAPI01 AS
SELECT
  ServiceEntrySheet,
  ServiceEntrySheetName,
  Supplier,
  PurchaseOrder,
  IsDeleted,
  ApprovalStatus,
  ApprovalDateTime,
  ResponsiblePerson,
  OriginObjectType,
  Currency,
  MaterialDocument,
  MaterialDocumentYear,
  PurgDocExternalSystem,
  PurgDocExternalReference,
  PostingDate,
  PurchasingOrganization,
  PurchasingGroup,
  IsEndOfPurposeBlocked,
  CreationDateTime,
  CreatedByUser,
  LastChangeDateTime,
  LastChangeUser AS LastChangedByUser
FROM I_ServiceEntrySheetBasic
LEFT OUTER JOIN I_ServiceEntrySheetItemAPI01 AS _ServiceEntrySheetItem ON ServiceEntrySheet = _ServiceEntrySheetItem.ServiceEntrySheet  -- association [1..*]
LEFT OUTER JOIN E_ServiceEntrySheet AS _ServiceEntrySheetExtension ON ServiceEntrySheet = _ServiceEntrySheetExtension.ServiceEntrySheet  -- association [0..1]
;

Learn More