I_SERVICEENTRYSHEETITEMBASIC

CDS View

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)

ViewTypeJoinVDMDescription
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)

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