I_ServiceEntrySheetItemTP_2

DDL: I_SERVICEENTRYSHEETITEMTP_2 Type: view_entity TRANSACTIONAL Package: RAP_MM_PUR_SES
69 Fields 1 Data Sources

Service Entry Sheet Item

I_ServiceEntrySheetItemTP_2 is a Transactional CDS View that provides data about "Service Entry Sheet Item" in SAP S/4HANA. It reads from 1 data source (R_ServiceEntrySheetItemTP) and exposes 69 fields with key fields ServiceEntrySheet, ServiceEntrySheetItem. Part of development package RAP_MM_PUR_SES.

Data Sources (1)

SourceAliasJoin Type
R_ServiceEntrySheetItemTP R_ServiceEntrySheetItemTP projection

Annotations (11)

NameValueLevelField
EndUserText.label Service Entry Sheet Item view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
VDM.viewType #TRANSACTIONAL view
ObjectModel.modelingPattern #TRANSACTIONAL_INTERFACE view
ObjectModel.representativeKey ServiceEntrySheetItem view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
Metadata.ignorePropagatedAnnotations true view

Fields (69)

KeyFieldSource TableSource FieldDescription
KEY ServiceEntrySheet ServiceEntrySheet Service Entry Sheet
KEY ServiceEntrySheetItem ServiceEntrySheetItem Item Number of SES
PurchaseOrder PurchaseOrder Purchasing Document
PurchaseOrderItem PurchaseOrderItem Purchasing Document Item
PurgDocumentItemDeletionCode PurgDocumentItemDeletionCode TRUE
Service Service Service Type
ServiceEntrySheetItemDesc ServiceEntrySheetItemDesc
ServicePerformer ServicePerformer Service Performer
AccountAssignmentCategory AccountAssignmentCategory Acct Assgmt Cat
MultipleAcctAssgmtDistribution MultipleAcctAssgmtDistribution Distribution
WorkItem WorkItem Work Item ID
ConfirmedQuantity ConfirmedQuantity Quantity in UnE
QuantityUnit QuantityUnit Unit of measure
OrderPriceUnit OrderPriceUnit Order Price Un.
OrderPriceUnitToOrderUnitNmrtr OrderPriceUnitToOrderUnitNmrtr Quantity Conversion Numerator
OrdPriceUnitToOrderUnitDnmntr OrdPriceUnitToOrderUnitDnmntr Quantity Conversion Denominator
QtyInPurchaseOrderPriceUnit QtyInPurchaseOrderPriceUnit Qty in OPUn
NetPriceQuantity NetPriceQuantity Price Unit
ServicePerformanceDate ServicePerformanceDate
ServicePerformanceEndDate ServicePerformanceEndDate
PerformancePeriodStartDate PerformancePeriodStartDate Start of Performance Period
PerformancePeriodEndDate PerformancePeriodEndDate End of Performance Period
OriginObject OriginObject Reference Document
Currency Currency Valuation Crcy
NetPriceAmount NetPriceAmount Net Price
SESItemMaterialGroupIsInitial SESItemMaterialGroupIsInitial
MaterialGroup MaterialGroup Product Group
IsEndOfPurposeBlocked IsEndOfPurposeBlocked Busin. Purp. Cmpltd.
CreationDateTime CreationDateTime Timestamp
CreatedByUser CreatedByUser User Name
LastChangeDateTime LastChangeDateTime Timestamp
LastChangedByUser LastChangedByUser User Name
Plant Plant Valuation Area
PurgDocItemExternalReference PurgDocItemExternalReference
PurchaseContract PurchaseContract Purchasing Doc.
PurchaseContractItem PurchaseContractItem Item
PurchasingOrganization PurchasingOrganization Purchasing Organization
PurchasingGroup PurchasingGroup Purchasing Group
ParentObjectIsDeleted ParentObjectIsDeleted
PurOrderItemPlant PurOrderItemPlant
PurchaseOrderType PurchaseOrderType PO Type
Supplier Supplier Supplier
PurchaseOrderItemMaterialGroup PurchaseOrderItemMaterialGroup
PurchaseOrderItemQuantity PurchaseOrderItemQuantity
PurchaseOrderItemQuantityUnit PurchaseOrderItemQuantityUnit
PurchaseOrderItemNetAmount PurchaseOrderItemNetAmount
PurchaseOrderCurrency PurchaseOrderCurrency Order currency
PurchaseOrderItemCompanyCode PurchaseOrderItemCompanyCode
OverdelivTolrtdLmtRatioInPct OverdelivTolrtdLmtRatioInPct Overdeliv. Tol.
PurchaseOrderItemCategory PurchaseOrderItemCategory Item Category
ExpectedOverallLimitAmount ExpectedOverallLimitAmount Expected Value
OverallLimitAmount OverallLimitAmount Overall Limit
TotalConfirmedQuantity TotalConfirmedQuantity Total to Be Confirmed
OpenQuantity OpenQuantity PBE Entry Open Qty
OpenAmountInPurchaseOrderCrcy OpenAmountInPurchaseOrderCrcy
NetAmount NetAmount Stated Amount
NetAmountInPurchaseOrderCrcy NetAmountInPurchaseOrderCrcy
NonDeductibleInputTaxAmount NonDeductibleInputTaxAmount Non-deductible
SESNetAmountInclSalesTax SESNetAmountInclSalesTax
TaxCode TaxCode Tax Code
TaxCountry TaxCountry Tax Ctry/Reg.
TaxDeterminationDate TaxDeterminationDate Tx Determination Dte
TaxJurisdiction TaxJurisdiction Tax Jurisdiction
TaxCalculationProcedure TaxCalculationProcedure Tax Procedure
MaterialType MaterialType Material Type
ConsumptionPosting ConsumptionPosting Consumption Posting
InventorySpecialStockType InventorySpecialStockType Special Stock Type
PurgDocProductType PurgDocProductType Product Type Group
SESItemIsFinalEntry SESItemIsFinalEntry Final Entry

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_ServiceEntrySheetItemTP_2.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW I_ServiceEntrySheetItemTP_2 AS
SELECT
  ServiceEntrySheet,
  ServiceEntrySheetItem,
  PurchaseOrder,
  PurchaseOrderItem,
  PurgDocumentItemDeletionCode,
  Service,
  ServiceEntrySheetItemDesc,
  ServicePerformer,
  AccountAssignmentCategory,
  MultipleAcctAssgmtDistribution,
  WorkItem,
  ConfirmedQuantity,
  QuantityUnit,
  OrderPriceUnit,
  OrderPriceUnitToOrderUnitNmrtr,
  OrdPriceUnitToOrderUnitDnmntr,
  QtyInPurchaseOrderPriceUnit,
  NetPriceQuantity,
  ServicePerformanceDate,
  ServicePerformanceEndDate,
  PerformancePeriodStartDate,
  PerformancePeriodEndDate,
  OriginObject,
  Currency,
  NetPriceAmount,
  SESItemMaterialGroupIsInitial,
  MaterialGroup,
  IsEndOfPurposeBlocked,
  CreationDateTime,
  CreatedByUser,
  LastChangeDateTime,
  LastChangedByUser,
  Plant,
  PurgDocItemExternalReference,
  PurchaseContract,
  PurchaseContractItem,
  PurchasingOrganization,
  PurchasingGroup,
  ParentObjectIsDeleted,
  PurOrderItemPlant,
  PurchaseOrderType,
  Supplier,
  PurchaseOrderItemMaterialGroup,
  PurchaseOrderItemQuantity,
  PurchaseOrderItemQuantityUnit,
  PurchaseOrderItemNetAmount,
  PurchaseOrderCurrency,
  PurchaseOrderItemCompanyCode,
  OverdelivTolrtdLmtRatioInPct,
  PurchaseOrderItemCategory,
  ExpectedOverallLimitAmount,
  OverallLimitAmount,
  TotalConfirmedQuantity,
  OpenQuantity,
  OpenAmountInPurchaseOrderCrcy,
  NetAmount,
  NetAmountInPurchaseOrderCrcy,
  NonDeductibleInputTaxAmount,
  SESNetAmountInclSalesTax,
  TaxCode,
  TaxCountry,
  TaxDeterminationDate,
  TaxJurisdiction,
  TaxCalculationProcedure,
  MaterialType,
  ConsumptionPosting,
  InventorySpecialStockType,
  PurgDocProductType,
  SESItemIsFinalEntry
FROM R_ServiceEntrySheetItemTP
;

Learn More