I_SERVICEENTRYSHEETTP

CDS View

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)

ViewTypeJoinVDMDescription
C_ServiceEntrySheetWD view from CONSUMPTION Service Entry Sheet with Draft

Fields (46)

KeyField CDS FieldsUsed 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)
);