I_ServiceEntrySheetItem

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_ServiceEntrySheetItem.
-- 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.
-- SQL view name: ISRVCENTRSHTITM

CREATE VIEW I_ServiceEntrySheetItem AS
SELECT
  Document.ServiceEntrySheet AS ServiceEntrySheet,
  Document.ServiceEntrySheetItem AS ServiceEntrySheetItem,
  cast(concat(Document.ServiceEntrySheet, Document.ServiceEntrySheetItem) as purchasingdocumentitemuniqueid) AS ServiceEntrySheetItemUniqueID,
  Document.PurchaseOrder AS PurchaseOrder,
  Document.PurchaseOrderItem AS PurchaseOrderItem,
  Document.IsDeleted AS IsDeleted,
  Document.Service AS Service,
  Document.ServiceEntrySheetItemDesc AS ServiceEntrySheetItemDesc,
  Document.ServicePerformer AS ServicePerformer,
  Document.AccountAssignmentCategory AS AccountAssignmentCategory,
  Document.MultipleAcctAssgmtDistribution AS MultipleAcctAssgmtDistribution,
  Document.WorkItem AS WorkItem,
  Document.ConfirmedQuantity AS ConfirmedQuantity,
  Document.QuantityUnit AS QuantityUnit,
  Document.OrderPriceUnit AS OrderPriceUnit,
  Document.OrderPriceUnitToOrderUnitNmrtr AS OrderPriceUnitToOrderUnitNmrtr,
  Document.OrdPriceUnitToOrderUnitDnmntr AS OrdPriceUnitToOrderUnitDnmntr,
  Document.QtyInPurchaseOrderPriceUnit AS QtyInPurchaseOrderPriceUnit,
  Document.NetPriceQuantity AS NetPriceQuantity,
  Document.ServicePerformanceDate AS ServicePerformanceDate,
  Document.ServicePerformanceEndDate AS ServicePerformanceEndDate,
  _ScheduleLine.PerformancePeriodStartDate AS PerformancePeriodStartDate,
  _ScheduleLine.PerformancePeriodEndDate AS PerformancePeriodEndDate,
  Document.OriginObject AS OriginObject,
  Document.Currency AS Currency,
  Document.NetPriceAmount AS NetPriceAmount,
  Document.MaterialGroup AS MaterialGroup,
  Document.IsEndOfPurposeBlocked AS IsEndOfPurposeBlocked,
  cast(CreationDateTime as mmpur_ses_created_on preserving type ) AS CreationDateTime,
  Document.CreatedByUser AS CreatedByUser,
  Document.LastChangeDateTime AS LastChangeDateTime,
  Document.LastChangeUser AS LastChangeUser,
  Document.Plant AS Plant,
  Document.PurgDocItemExternalReference AS PurgDocItemExternalReference,
  Document.PurchaseContract AS PurchaseContract,
  Document.PurchaseContractItem AS PurchaseContractItem,
  Document.PurchasingOrganization AS PurchasingOrganization,
  Document.PurchasingGroup AS PurchasingGroup,
  Document.ParentObjectIsDeleted AS ParentObjectIsDeleted,
  cast(' ' as ewerk) AS PurOrderItemPlant,
  cast(' ' as esart) AS PurchaseOrderType,
  _PurchaseOrder.Supplier AS Supplier,
  _PurchaseOrderItem.MaterialGroup AS PurchaseOrderItemMaterialGroup,
  _PurchaseOrderItem.OrderQuantity AS PurchaseOrderItemQuantity,
  _PurchaseOrderItem.PurchaseOrderQuantityUnit AS PurchaseOrderItemQuantityUnit,
  _PurchaseOrderItem.NetAmount AS PurchaseOrderItemNetAmount,
  _PurchaseOrderItem.DocumentCurrency AS PurchaseOrderCurrency,
  _PurchaseOrderItem.CompanyCode AS PurchaseOrderItemCompanyCode,
  _PurchaseOrderItem.OverdelivTolrtdLmtRatioInPct AS OverdelivTolrtdLmtRatioInPct,
  _PurchaseOrderItem.PurchaseOrderItemCategory AS PurchaseOrderItemCategory,
  _PurchaseOrderItem.ExpectedOverallLimitAmount AS ExpectedOverallLimitAmount,
  _PurchaseOrderItem.OverallLimitAmount AS OverallLimitAmount,
  cast(0 as mmpur_ses_confirmedquantity) AS TotalConfirmedQuantity,
  cast(0 as mmpur_ses_openquantity) AS OpenQuantity,
  cast(0 as mmpur_ses_open_amount_po_crcy) AS OpenAmountInPurchaseOrderCrcy,
  Document.NetAmount AS NetAmount,
  Document.NetAmount AS NetAmountInPurchaseOrderCrcy,
  Document.NonDeductibleInputTaxAmount AS NonDeductibleInputTaxAmount,
  cast( (Document.NetAmount + Document.NonDeductibleInputTaxAmount ) as mmpur_ses_confirmedvalue_w_tax ) AS SESNetAmountInclSalesTax,
  Document.TaxCode AS TaxCode,
  Document.TaxCountry AS TaxCountry,
  Document.TaxDeterminationDate AS TaxDeterminationDate,
  Document.TaxJurisdiction AS TaxJurisdiction,
  Document.TaxCalculationProcedure AS TaxCalculationProcedure,
  Document.PurgDocPriceDate AS PurgDocPriceDate,
  Document.SESItemIsFinalEntry AS SESItemIsFinalEntry,
  _Material.MaterialType AS MaterialType,
  _AccountAssignmentCategory.ConsumptionPosting AS ConsumptionPosting,
  _AccountAssignmentCategory.InventorySpecialStockType AS InventorySpecialStockType,
  _PurchaseOrderItem.ProductType AS ProductType,
  Document._Material AS _Material,
  Document._MaterialGroup AS _MaterialGroup,
  Document._AccountAssignmentCategory AS _AccountAssignmentCategory,
  Document._UnitValueHelp AS _UnitValueHelp
FROM I_ServiceEntrySheetItemBasic AS Document
LEFT OUTER JOIN I_ServiceEntrySheet AS _ServiceEntrySheet ON ServiceEntrySheet = _ServiceEntrySheet.ServiceEntrySheet  -- association [1..1]
LEFT OUTER JOIN I_ServiceEntrySheetAcctAssgmt AS _AccountAssignment ON ServiceEntrySheet = _AccountAssignment.ServiceEntrySheet AND ServiceEntrySheetItem = _AccountAssignment.ServiceEntrySheetItem  -- association [1..*]
LEFT OUTER JOIN I_MaterialGroup AS _MaterialGroupValueHelp ON PurchaseOrderItemMaterialGroup = _MaterialGroupValueHelp.MaterialGroup  -- association [0..1]
LEFT OUTER JOIN I_MaterialGroupText AS _MaterialGroupText ON MaterialGroup = _MaterialGroupText.MaterialGroup  -- association [0..*]
LEFT OUTER JOIN I_AcctAssignmentCategoryText AS _AcctAssignmentCategoryText ON AccountAssignmentCategory = _AcctAssignmentCategoryText.AccountAssignmentCategory AND _AcctAssignmentCategoryText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_SrvcEntrShtAcctAssgmtCat AS _SrvcEntrShtAcctAssgmtCat ON _SrvcEntrShtAcctAssgmtCat.AccountAssignmentCategory = AccountAssignmentCategory  -- association [0..1]
LEFT OUTER JOIN I_PurchaseOrder AS _PurchaseOrder ON PurchaseOrder = _PurchaseOrder.PurchaseOrder  -- association [0..1]
LEFT OUTER JOIN R_PurchaseOrderItem AS _PurchaseOrderItem ON PurchaseOrder = _PurchaseOrderItem.PurchaseOrder AND PurchaseOrderItem = _PurchaseOrderItem.PurchaseOrderItem  -- association [0..1]
LEFT OUTER JOIN I_ProductTypeCodeText AS _ProductTypeText ON _ProductTypeText.ProductTypeCode = ProductType AND _ProductTypeText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_PurgDocScheduleLine AS _ScheduleLine ON PurchaseOrder = _ScheduleLine.PurchasingDocument AND PurchaseOrderItem = _ScheduleLine.PurchasingDocumentItem  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _DocumentCurrency ON Currency = _DocumentCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasureText AS _UnitText ON QuantityUnit = _UnitText.UnitOfMeasure  -- association [0..*]
LEFT OUTER JOIN I_UnitOfMeasure AS _PurOrdUnitOfMsrValHelp ON PurchaseOrderItemQuantityUnit = _PurOrdUnitOfMsrValHelp.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasureText AS _PurOrdUnitOfMsrTxt ON PurchaseOrderItemQuantityUnit = _PurOrdUnitOfMsrTxt.UnitOfMeasure  -- association [0..*]
LEFT OUTER JOIN I_WorkItemText AS _WorkItemText ON WorkItem = _WorkItemText.WorkItem AND _WorkItemText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_SESPricingElement AS _SESPricingElement ON ServiceEntrySheet = _SESPricingElement.ServiceEntrySheet AND ServiceEntrySheetItem = _SESPricingElement.ServiceEntrySheetItem AND ServiceEntrySheetItem is not initial  -- association [0..*]
LEFT OUTER JOIN I_ServiceEntrySheetItemNote AS _ServiceEntrySheetItemNote ON ServiceEntrySheet = _ServiceEntrySheetItemNote.ServiceEntrySheet AND ServiceEntrySheetItem = _ServiceEntrySheetItemNote.ServiceEntrySheetItem AND ServiceEntrySheetItem is not initial  -- association [0..*]
LEFT OUTER JOIN E_ServiceEntrySheetItem AS _ServiceEntrySheetItmExtension ON ServiceEntrySheet = _ServiceEntrySheetItmExtension.ServiceEntrySheet AND ServiceEntrySheetItem = _ServiceEntrySheetItmExtension.ServiceEntrySheetItem  -- association [1..1]
;