I_SERVICEENTRYSHEETTP
Service Entry Sheet with Draft
I_SERVICEENTRYSHEETTP is a CDS View in S/4HANA. Service Entry Sheet with Draft. It contains 46 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| C_ServiceEntrySheetWD | view | from | CONSUMPTION | Service Entry Sheet with Draft |
Fields (46)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | ServiceEntrySheet | ServiceEntrySheet | 1 |
| _ApprovalStatusText | _ApprovalStatusText | 1 | |
| _ApprovalStatusValueHelp | _ApprovalStatusValueHelp | 1 | |
| _DocumentCurrency | _DocumentCurrency | 1 | |
| _OriginObjectType | _OriginObjectType | 1 | |
| _PurchaseOrderCurrency | _PurchaseOrderCurrency | 1 | |
| _ResponsiblePersonValueHelp | _ResponsiblePersonValueHelp | 1 | |
| _SrvcEntrShtPurOrdValueHelp | _SrvcEntrShtPurOrdValueHelp | 1 | |
| _Supplier | _Supplier | 1 | |
| _WorkflowStatusText | _WorkflowStatusText | 1 | |
| _WorkflowStatusValueHelp | _WorkflowStatusValueHelp | 1 | |
| ApprovalStatus | ApprovalStatus | 1 | |
| CancelApprovalIsPossible | CancelApprovalIsPossible | 1 | |
| CreatedByUser | CreatedByUser | 1 | |
| CreationDateTime | CreationDateTime | 1 | |
| Currency | Currency | 1 | |
| DefaultEmailAddress | DefaultEmailAddress | 1 | |
| ExternalRevisionDateTime | ExternalRevisionDateTime | 1 | |
| FormattedAddress | AddressID | 1 | |
| IsDeleted | IsDeleted | 1 | |
| IsEndOfPurposeBlocked | IsEndOfPurposeBlocked | 1 | |
| LastChangeDateTime | LastChangeDateTime | 1 | |
| LastChangeUser | LastChangeUser | 1 | |
| MobilePhoneNumber | MobilePhoneNumber | 1 | |
| NormalizedPhoneNumber | NormalizedPhoneNumber | 1 | |
| OriginObjectType | OriginObjectType | 1 | |
| OverallStatusCriticality | OverallStatusCriticality | 1 | |
| PostingDate | PostingDate | 1 | |
| PricingDocument | PricingDocument | 1 | |
| PurchaseOrder | PurchaseOrder | 1 | |
| PurchaseOrderCurrency | PurchaseOrderCurrency | 1 | |
| PurchasingGroup | PurchasingGroup | 1 | |
| PurchasingOrganization | PurchasingOrganization | 1 | |
| PurgDocExternalSystem | PurgDocExternalSystem | 1 | |
| ResponsiblePerson | ResponsiblePerson | 1 | |
| ResponsiblePersonName | ResponsiblePersonName | 1 | |
| RevokeIsPossible | RevokeIsPossible | 1 | |
| SendToApprovalIsPossible | SendToApprovalIsPossible | 1 | |
| ServiceEntrySheetName | ServiceEntrySheetName | 1 | |
| SESMassEditIsUtilized | SESMassEditIsUtilized | 1 | |
| SESWorkflowStatus | SESWorkflowStatus | 1 | |
| StatusCriticality | StatusCriticality | 1 | |
| Supplier | Supplier | 1 | |
| SupplierName | SupplierName | 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 with Draft
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_SERVICEENTRYSHEETTP (
SERVICEENTRYSHEET,
_APPROVALSTATUSTEXT,
_APPROVALSTATUSVALUEHELP,
_DOCUMENTCURRENCY,
_ORIGINOBJECTTYPE,
_PURCHASEORDERCURRENCY,
_RESPONSIBLEPERSONVALUEHELP,
_SRVCENTRSHTPURORDVALUEHELP,
_SUPPLIER,
_WORKFLOWSTATUSTEXT,
_WORKFLOWSTATUSVALUEHELP,
APPROVALSTATUS,
CANCELAPPROVALISPOSSIBLE,
CREATEDBYUSER,
CREATIONDATETIME,
CURRENCY,
DEFAULTEMAILADDRESS,
EXTERNALREVISIONDATETIME,
FORMATTEDADDRESS,
ISDELETED,
ISENDOFPURPOSEBLOCKED,
LASTCHANGEDATETIME,
LASTCHANGEUSER,
MOBILEPHONENUMBER,
NORMALIZEDPHONENUMBER,
ORIGINOBJECTTYPE,
OVERALLSTATUSCRITICALITY,
POSTINGDATE,
PRICINGDOCUMENT,
PURCHASEORDER,
PURCHASEORDERCURRENCY,
PURCHASINGGROUP,
PURCHASINGORGANIZATION,
PURGDOCEXTERNALSYSTEM,
RESPONSIBLEPERSON,
RESPONSIBLEPERSONNAME,
REVOKEISPOSSIBLE,
SENDTOAPPROVALISPOSSIBLE,
SERVICEENTRYSHEETNAME,
SESMASSEDITISUTILIZED,
SESWORKFLOWSTATUS,
STATUSCRITICALITY,
SUPPLIER,
SUPPLIERNAME,
TOTALNETAMOUNT,
TOTALSESNETAMOUNTINCLSALESTAX,
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