I_SERVICEENTRYSHEETBASIC

CDS View

Service Entry Sheet Basic

I_SERVICEENTRYSHEETBASIC is a CDS View in S/4HANA. Service Entry Sheet Basic. It contains 25 fields. 10 CDS views read from this table.

CDS Views using this table (10)

ViewTypeJoinVDMDescription
A_ServiceEntrySheet view from COMPOSITE Service Entry Sheet
C_ServiceEntrySheetProcessFlow view inner CONSUMPTION Process Flow For Service Entry Sheet
C_ServiceEntrySheetProcessFlow view union_all CONSUMPTION Process Flow For Service Entry Sheet
C_SESWorkflowEmail view inner CONSUMPTION Email for SES Wfl Approval or Rejection
I_ServiceEntrySheet view from COMPOSITE Service Entry Sheet
I_ServiceEntrySheetAPI01 view from BASIC Service Entry Sheet
I_SESWorkflowStatus view from COMPOSITE Approval Status of Service Entry Sheet
I_SESWorkflowStatus view union_all COMPOSITE Approval Status of Service Entry Sheet
I_SrvcEntrShtCreationDate view from COMPOSITE Service Entry Sheet Creation Date
I_SrvcEntrShtItmProcessFlow view_entity inner COMPOSITE Process Flow Service Entry Sheet Item

Fields (25)

KeyField CDS FieldsUsed in Views
KEY ServiceEntrySheet ServiceEntrySheet 2
_ApprovalStatusValueHelp _ApprovalStatusValueHelp 1
_ResponsiblePersonValueHelp _ResponsiblePersonValueHelp 1
_Supplier _Supplier 1
ApprovalDateTime ApprovalDateTime 1
ApprovalStatus ApprovalStatus 1
CreatedByUser CreatedByUser 1
Currency Currency 1
ExternalRevisionDateTime ExternalRevisionDateTime 1
IsDeleted IsDeleted 1
IsEndOfPurposeBlocked IsEndOfPurposeBlocked 3
LastChangeUser LastChangeUser 1
MaterialDocument MaterialDocument 1
MaterialDocumentYear MaterialDocumentYear 1
OriginObjectType OriginObjectType 1
PostingDate PostingDate 1
PricingDocument PricingDocument 1
PurchaseOrder PurchaseOrder 1
PurchasingGroup PurchasingGroup 3
PurchasingOrganization PurchasingOrganization 3
PurgDocExternalReference PurgDocExternalReference 1
PurgDocExternalSystem PurgDocExternalSystem 1
ResponsiblePerson ResponsiblePerson 1
ServiceEntrySheetName ServiceEntrySheetName 1
Supplier Supplier 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 Basic
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_SERVICEENTRYSHEETBASIC (
    SERVICEENTRYSHEET,
    _APPROVALSTATUSVALUEHELP,
    _RESPONSIBLEPERSONVALUEHELP,
    _SUPPLIER,
    APPROVALDATETIME,
    APPROVALSTATUS,
    CREATEDBYUSER,
    CURRENCY,
    EXTERNALREVISIONDATETIME,
    ISDELETED,
    ISENDOFPURPOSEBLOCKED,
    LASTCHANGEUSER,
    MATERIALDOCUMENT,
    MATERIALDOCUMENTYEAR,
    ORIGINOBJECTTYPE,
    POSTINGDATE,
    PRICINGDOCUMENT,
    PURCHASEORDER,
    PURCHASINGGROUP,
    PURCHASINGORGANIZATION,
    PURGDOCEXTERNALREFERENCE,
    PURGDOCEXTERNALSYSTEM,
    RESPONSIBLEPERSON,
    SERVICEENTRYSHEETNAME,
    SUPPLIER,
    PRIMARY KEY (SERVICEENTRYSHEET)
);