I_SERVICEENTRYSHEETITEM

CDS View
68 Fields 12 CDS Views

Service Entry Sheet Item

I_SERVICEENTRYSHEETITEM is a CDS View in S/4HANA. Service Entry Sheet Item. It contains 68 fields. 12 CDS views read from this table.

CDS Views using this table (12)

ViewTypeJoinVDMDescription
C_BSOrdItmProcFlwSrvcEntrSheet view from CONSUMPTION SES Item Attrib for BSOrd Prgrs
I_ServiceEntrySheetItemNote view_entity from COMPOSITE Service Entry Sheet Item Note
I_ServiceEntrySheetItemStdVH view from COMPOSITE Service Entry Sheet Item
I_ServiceEntrySheetItemTP view from TRANSACTIONAL Service Entry Sheet Item with Draft
I_SrvcEntrShtItmOpnAmtOrdCrcy view from COMPOSITE SES Item: Open Amount in PO Currency
I_SrvcEntrShtItmTotConfdAmt view from COMPOSITE SES Item: Total Confirmed Amount
I_SrvcEntrShtItmTotConfdQty view from COMPOSITE SES Item: Total Confirmed Quantity
I_SrvcEntrShtItmTotNetAmt view from COMPOSITE SES Item: Total Net Amount
P_PurOrdServiceEntryItem view from CONSUMPTION
P_PurOrdServiceEntryItem1 view from CONSUMPTION
P_SRVCENTRSHTITMTOTCONFDAMT view from COMPOSITE
R_ServiceEntrySheetItemTP view_entity from TRANSACTIONAL Service Entry Sheet Item

Fields (68)

KeyField CDS FieldsUsed in Views
KEY PurchaseOrder PurchaseOrder 2
KEY PurchaseOrderItem PurchaseOrderItem 2
KEY ServiceEntrySheet ServiceEntrySheet 2
KEY ServiceEntrySheetItem ServiceEntrySheetItem 2
_DocumentCurrency _DocumentCurrency 1
_MaterialGroup _MaterialGroup 1
_MaterialGroupText _MaterialGroupText 1
_MaterialGroupValueHelp _MaterialGroupValueHelp 1
_SrvcEntrShtAcctAssgmtCat _SrvcEntrShtAcctAssgmtCat 1
_WorkItemText _WorkItemText 1
AccountAssignmentCategory AccountAssignmentCategory 1
ConfirmedQuantity ConfirmedQuantity 2
ConsumptionPosting ConsumptionPosting 1
CreationDateTime CreationDateTime 1
Currency Currency 2
ExpectedOverallLimitAmount ExpectedOverallLimitAmount 1
InventorySpecialStockType InventorySpecialStockType 1
IsDeleted IsDeleted 1
IsEndOfPurposeBlocked IsEndOfPurposeBlocked 2
LastChangeDateTime LastChangeDateTime 1
MaterialGroup MaterialGroup 1
MaterialType MaterialType 1
MultipleAcctAssgmtDistribution MultipleAcctAssgmtDistribution 1
NetAmount NetAmount 1
NetAmountInPurchaseOrderCrcy NetAmountInPurchaseOrderCrcy 1
NetPriceAmount NetPriceAmount 1
NetPriceQuantity NetPriceQuantity 1
NonDeductibleInputTaxAmount NonDeductibleInputTaxAmount 1
OrderPriceUnit OrderPriceUnit 1
OrderPriceUnitToOrderUnitNmrtr OrderPriceUnitToOrderUnitNmrtr 1
OrdPriceUnitToOrderUnitDnmntr OrdPriceUnitToOrderUnitDnmntr 1
OriginObject OriginObject 1
OverallLimitAmount OverallLimitAmount 1
OverdelivTolrtdLmtRatioInPct OverdelivTolrtdLmtRatioInPct 1
PerformancePeriodEndDate PerformancePeriodEndDate 1
PerformancePeriodStartDate PerformancePeriodStartDate 1
Plant Plant 2
ProductType ProductType 1
PurchaseContract PurchaseContract 1
PurchaseContractItem PurchaseContractItem 1
PurchaseOrderCurrency PurchaseOrderCurrency 1
PurchaseOrderItemCategory PurchaseOrderItemCategory 1
PurchaseOrderItemCompanyCode PurchaseOrderItemCompanyCode 1
PurchaseOrderItemMaterialGroup PurchaseOrderItemMaterialGroup 1
PurchaseOrderItemNetAmount PurchaseOrderItemNetAmount 1
PurchaseOrderItemQuantity PurchaseOrderItemQuantity 1
PurchaseOrderItemQuantityUnit PurchaseOrderItemQuantityUnit 1
PurchasingGroup PurchasingGroup 2
PurchasingOrganization PurchasingOrganization 2
PurgDocItemExternalReference PurgDocItemExternalReference 1
PurgDocPriceDate PurgDocPriceDate 1
QtyInPurchaseOrderPriceUnit QtyInPurchaseOrderPriceUnit 1
QuantityUnit QuantityUnit 1
Service Service 1
ServiceEntrySheetItemDesc ServiceEntrySheetItemDesc 1
ServiceEntrySheetItemUniqueID ServiceEntrySheetItemUniqueID 1
ServicePerformanceDate ServicePerformanceDate 2
ServicePerformanceEndDate ServicePerformanceEndDate 1
ServicePerformer ServicePerformer 2
SESItemIsFinalEntry SESItemIsFinalEntry 1
SESNetAmountInclSalesTax SESNetAmountInclSalesTax 1
Supplier Supplier 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
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_SERVICEENTRYSHEETITEM (
    PURCHASEORDER,
    PURCHASEORDERITEM,
    SERVICEENTRYSHEET,
    SERVICEENTRYSHEETITEM,
    _DOCUMENTCURRENCY,
    _MATERIALGROUP,
    _MATERIALGROUPTEXT,
    _MATERIALGROUPVALUEHELP,
    _SRVCENTRSHTACCTASSGMTCAT,
    _WORKITEMTEXT,
    ACCOUNTASSIGNMENTCATEGORY,
    CONFIRMEDQUANTITY,
    CONSUMPTIONPOSTING,
    CREATIONDATETIME,
    CURRENCY,
    EXPECTEDOVERALLLIMITAMOUNT,
    INVENTORYSPECIALSTOCKTYPE,
    ISDELETED,
    ISENDOFPURPOSEBLOCKED,
    LASTCHANGEDATETIME,
    MATERIALGROUP,
    MATERIALTYPE,
    MULTIPLEACCTASSGMTDISTRIBUTION,
    NETAMOUNT,
    NETAMOUNTINPURCHASEORDERCRCY,
    NETPRICEAMOUNT,
    NETPRICEQUANTITY,
    NONDEDUCTIBLEINPUTTAXAMOUNT,
    ORDERPRICEUNIT,
    ORDERPRICEUNITTOORDERUNITNMRTR,
    ORDPRICEUNITTOORDERUNITDNMNTR,
    ORIGINOBJECT,
    OVERALLLIMITAMOUNT,
    OVERDELIVTOLRTDLMTRATIOINPCT,
    PERFORMANCEPERIODENDDATE,
    PERFORMANCEPERIODSTARTDATE,
    PLANT,
    PRODUCTTYPE,
    PURCHASECONTRACT,
    PURCHASECONTRACTITEM,
    PURCHASEORDERCURRENCY,
    PURCHASEORDERITEMCATEGORY,
    PURCHASEORDERITEMCOMPANYCODE,
    PURCHASEORDERITEMMATERIALGROUP,
    PURCHASEORDERITEMNETAMOUNT,
    PURCHASEORDERITEMQUANTITY,
    PURCHASEORDERITEMQUANTITYUNIT,
    PURCHASINGGROUP,
    PURCHASINGORGANIZATION,
    PURGDOCITEMEXTERNALREFERENCE,
    PURGDOCPRICEDATE,
    QTYINPURCHASEORDERPRICEUNIT,
    QUANTITYUNIT,
    SERVICE,
    SERVICEENTRYSHEETITEMDESC,
    SERVICEENTRYSHEETITEMUNIQUEID,
    SERVICEPERFORMANCEDATE,
    SERVICEPERFORMANCEENDDATE,
    SERVICEPERFORMER,
    SESITEMISFINALENTRY,
    SESNETAMOUNTINCLSALESTAX,
    SUPPLIER,
    TAXCALCULATIONPROCEDURE,
    TAXCODE,
    TAXCOUNTRY,
    TAXDETERMINATIONDATE,
    TAXJURISDICTION,
    WORKITEM,
    PRIMARY KEY (PURCHASEORDER, PURCHASEORDERITEM, SERVICEENTRYSHEET, SERVICEENTRYSHEETITEM)
);

Learn More