I_SERVICEENTRYSHEETITEMBASIC
Service Entry Sheet Item Basic
I_SERVICEENTRYSHEETITEMBASIC is a CDS View in S/4HANA. Service Entry Sheet Item Basic. It contains 48 fields. 10 CDS views read from this table.
CDS Views using this table (10)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| A_ServiceEntrySheetItem | view | from | BASIC | Item |
| C_ServiceEntrySheetProcessFlow | view | right_outer | CONSUMPTION | Process Flow For 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 |
| I_ServiceEntrySheetItem | view | from | COMPOSITE | Service Entry Sheet Item |
| I_ServiceEntrySheetItemAPI01 | view | from | BASIC | Service Entry Sheet Item |
| I_SrvcEntrShtItmDocFlw | view | from | COMPOSITE | Service Entry Sheet Item / Document Flow |
| I_SrvcEntrShtItmProcessFlow | view_entity | from | COMPOSITE | Process Flow Service Entry Sheet Item |
| I_SrvcEntrShtItmProcessFlow | view_entity | union_all | COMPOSITE | Process Flow Service Entry Sheet Item |
| P_SRVCENTRSHTITMTOTCONFDQTY | view | from | COMPOSITE |
Fields (48)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | PurchaseOrder | PurchaseOrder,SubsequentDocument | 3 |
| KEY | PurchaseOrderItem | PurchaseOrderItem,SubsequentDocumentItem | 3 |
| KEY | ServiceEntrySheet | ServiceEntrySheet,SubsequentDocument | 3 |
| KEY | ServiceEntrySheetItem | ServiceEntrySheetItem,SubsequentDocumentItem | 3 |
| _AccountAssignmentCategory | _AccountAssignmentCategory | 1 | |
| _Material | _Material | 1 | |
| _MaterialGroup | _MaterialGroup | 1 | |
| _UnitValueHelp | _UnitValueHelp | 1 | |
| AccountAssignmentCategory | AccountAssignmentCategory | 1 | |
| ConfirmedQuantity | ConfirmedQuantity | 2 | |
| CreatedByUser | CreatedByUser | 1 | |
| Currency | Currency | 3 | |
| IsDeleted | IsDeleted | 1 | |
| IsEndOfPurposeBlocked | IsEndOfPurposeBlocked | 4 | |
| LastChangeDateTime | LastChangeDateTime | 1 | |
| LastChangeUser | LastChangeUser | 1 | |
| MaterialGroup | MaterialGroup | 1 | |
| MultipleAcctAssgmtDistribution | MultipleAcctAssgmtDistribution | 1 | |
| NetAmount | NetAmount,NetAmountInPurchaseOrderCrcy | 1 | |
| NetPriceAmount | NetPriceAmount | 1 | |
| NetPriceQuantity | NetPriceQuantity | 1 | |
| NonDeductibleInputTaxAmount | NonDeductibleInputTaxAmount | 1 | |
| OrderPriceUnit | OrderPriceUnit | 1 | |
| OrderPriceUnitToOrderUnitNmrtr | OrderPriceUnitToOrderUnitNmrtr | 1 | |
| OrdPriceUnitToOrderUnitDnmntr | OrdPriceUnitToOrderUnitDnmntr | 1 | |
| OriginObject | OriginObject | 1 | |
| ParentObjectIsDeleted | ParentObjectIsDeleted | 1 | |
| Plant | Plant | 2 | |
| PurchaseContract | PurchaseContract | 1 | |
| PurchaseContractItem | PurchaseContractItem | 1 | |
| PurchasingGroup | PurchasingGroup | 4 | |
| PurchasingOrganization | PurchasingOrganization | 4 | |
| PurgDocItemExternalReference | PurgDocItemExternalReference | 1 | |
| PurgDocPriceDate | PurgDocPriceDate | 1 | |
| QtyInPurchaseOrderPriceUnit | QtyInPurchaseOrderPriceUnit | 1 | |
| QuantityUnit | QuantityUnit | 2 | |
| Service | Service | 1 | |
| ServiceEntrySheetItemDesc | ServiceEntrySheetItemDesc | 1 | |
| ServicePerformanceDate | ServicePerformanceDate | 2 | |
| ServicePerformanceEndDate | ServicePerformanceEndDate | 1 | |
| ServicePerformer | ServicePerformer | 1 | |
| SESItemIsFinalEntry | SESItemIsFinalEntry | 1 | |
| TaxCalculationProcedure | TaxCalculationProcedure | 1 | |
| TaxCode | TaxCode | 1 | |
| TaxCountry | TaxCountry | 1 | |
| TaxDeterminationDate | TaxDeterminationDate | 1 | |
| TaxJurisdiction | TaxJurisdiction | 1 | |
| WorkItem | WorkItem | 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 Item Basic
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_SERVICEENTRYSHEETITEMBASIC (
PURCHASEORDER,
PURCHASEORDERITEM,
SERVICEENTRYSHEET,
SERVICEENTRYSHEETITEM,
_ACCOUNTASSIGNMENTCATEGORY,
_MATERIAL,
_MATERIALGROUP,
_UNITVALUEHELP,
ACCOUNTASSIGNMENTCATEGORY,
CONFIRMEDQUANTITY,
CREATEDBYUSER,
CURRENCY,
ISDELETED,
ISENDOFPURPOSEBLOCKED,
LASTCHANGEDATETIME,
LASTCHANGEUSER,
MATERIALGROUP,
MULTIPLEACCTASSGMTDISTRIBUTION,
NETAMOUNT,
NETPRICEAMOUNT,
NETPRICEQUANTITY,
NONDEDUCTIBLEINPUTTAXAMOUNT,
ORDERPRICEUNIT,
ORDERPRICEUNITTOORDERUNITNMRTR,
ORDPRICEUNITTOORDERUNITDNMNTR,
ORIGINOBJECT,
PARENTOBJECTISDELETED,
PLANT,
PURCHASECONTRACT,
PURCHASECONTRACTITEM,
PURCHASINGGROUP,
PURCHASINGORGANIZATION,
PURGDOCITEMEXTERNALREFERENCE,
PURGDOCPRICEDATE,
QTYINPURCHASEORDERPRICEUNIT,
QUANTITYUNIT,
SERVICE,
SERVICEENTRYSHEETITEMDESC,
SERVICEPERFORMANCEDATE,
SERVICEPERFORMANCEENDDATE,
SERVICEPERFORMER,
SESITEMISFINALENTRY,
TAXCALCULATIONPROCEDURE,
TAXCODE,
TAXCOUNTRY,
TAXDETERMINATIONDATE,
TAXJURISDICTION,
WORKITEM,
PRIMARY KEY (PURCHASEORDER, PURCHASEORDERITEM, SERVICEENTRYSHEET, SERVICEENTRYSHEETITEM)
);
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