I_SERVICEENTRYSHEET

CDS View
26 Fields 7 CDS Views

Service Entry Sheet

I_SERVICEENTRYSHEET is a CDS View in S/4HANA. Service Entry Sheet. It contains 26 fields. 7 CDS views read from this table.

CDS Views using this table (7)

ViewTypeJoinVDMDescription
C_BSOrdProcFlwSrvcEntrSheet view from CONSUMPTION SES Attrib for BSOrd Prgrs
C_DspDocFlwSESAttrib view_entity from CONSUMPTION Service Entry Sheet Attributes for DDF
ESH_N_SERVICEENTRYSHEET view from Anchor view -SERVICEENTRYSHEET
I_ServiceEntrySheetNote view_entity from COMPOSITE Service Entry Sheet Note
I_ServiceEntrySheetTP view from TRANSACTIONAL Service Entry Sheet with Draft
I_SESPricingElement view from COMPOSITE Service Entry Sheet Pricing Element
R_ServiceEntrySheetTP view_entity from TRANSACTIONAL Service Entry Sheet Header

Fields (26)

KeyField CDS FieldsUsed in Views
KEY ServiceEntrySheet ServiceEntrySheet,UI5NetworkGraphAttributeValue 4
ApprovalDateTime ApprovalDateTime 1
ApprovalStatus ApprovalStatus 1
CreationDateTime CreationDateTime 1
Currency Currency 1
ExternalRevisionDateTime ExternalRevisionDateTime 1
IsDeleted IsDeleted 1
IsEndOfPurposeBlocked IsEndOfPurposeBlocked 2
LastChangeDateTime LastChangeDateTime 1
MaterialDocument MaterialDocument 1
MaterialDocumentYear MaterialDocumentYear 1
OriginObjectType OriginObjectType 1
PostingDate PostingDate 2
PricingDocument PricingDocument 1
PurchaseOrder PurchaseOrder 1
PurchaseOrderCurrency PurchaseOrderCurrency 1
PurchasingGroup PurchasingGroup 2
PurchasingOrganization PurchasingOrganization 2
PurgDocExternalReference PurgDocExternalReference 1
PurgDocExternalSystem PurgDocExternalSystem 1
ResponsiblePerson ResponsiblePerson 1
ServiceEntrySheetName ServiceEntrySheetName 1
SESWorkflowStatus SESWorkflowStatus 1
Supplier Supplier 1
TotalNetAmount TotalNetAmount 1
TotalSESNetAmountInclSalesTax TotalSESNetAmountInclSalesTax 1

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Service Entry Sheet
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_SERVICEENTRYSHEET (
    SERVICEENTRYSHEET,
    APPROVALDATETIME,
    APPROVALSTATUS,
    CREATIONDATETIME,
    CURRENCY,
    EXTERNALREVISIONDATETIME,
    ISDELETED,
    ISENDOFPURPOSEBLOCKED,
    LASTCHANGEDATETIME,
    MATERIALDOCUMENT,
    MATERIALDOCUMENTYEAR,
    ORIGINOBJECTTYPE,
    POSTINGDATE,
    PRICINGDOCUMENT,
    PURCHASEORDER,
    PURCHASEORDERCURRENCY,
    PURCHASINGGROUP,
    PURCHASINGORGANIZATION,
    PURGDOCEXTERNALREFERENCE,
    PURGDOCEXTERNALSYSTEM,
    RESPONSIBLEPERSON,
    SERVICEENTRYSHEETNAME,
    SESWORKFLOWSTATUS,
    SUPPLIER,
    TOTALNETAMOUNT,
    TOTALSESNETAMOUNTINCLSALESTAX,
    PRIMARY KEY (SERVICEENTRYSHEET)
);

Learn More