I_SERVICEENTRYSHEETBASIC
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| 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)
| Key | Field | CDS Fields | Used 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)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA