C_ServiceEntrySheetItemDEX

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 C_ServiceEntrySheetItemDEX.
-- 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: CMMSERVENTSHTITM

CREATE VIEW C_ServiceEntrySheetItemDEX AS
SELECT
  ServiceEntrySheet,
  ServiceEntrySheetItem,
  PurchaseOrder,
  PurchaseOrderItem,
  IsDeleted,
  Service,
  ServiceEntrySheetItemDesc,
  ServicePerformer,
  AccountAssignmentCategory,
  MultipleAcctAssgmtDistribution,
  WorkItem,
  ConfirmedQuantity,
  QuantityUnit,
  ServicePerformanceDate,
  NetAmount,
  NetPriceAmount,
  Currency,
  PurgDocItemExternalReference,
  PurchaseContract,
  PurchaseContractItem,
  PurchasingOrganization,
  PurchasingGroup,
  Plant,
  IsEndOfPurposeBlocked,
  CreationDateTime,
  CreatedByUser,
  LastChangeDateTime,
  LastChangedByUser
FROM I_ServiceEntrySheetItemAPI01
LEFT OUTER JOIN C_ServiceEntrySheetDEX AS _ServiceEntrySheetDEX ON ServiceEntrySheet = _ServiceEntrySheetDEX.ServiceEntrySheet  -- association [1..1]
LEFT OUTER JOIN I_Product AS _Product ON Service = _Product.Product  -- association [0..1]
LEFT OUTER JOIN I_AccountAssignmentCategory AS _AccountAssignmentCategory ON AccountAssignmentCategory = _AccountAssignmentCategory.AccountAssignmentCategory  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasure ON QuantityUnit = _UnitOfMeasure.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _DocumentCurrency ON Currency = _DocumentCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN C_PurchaseOrderDEX AS _PurchaseOrder ON PurchaseOrder = _PurchaseOrder.PurchaseOrder  -- association [1..1]
LEFT OUTER JOIN C_PurchaseOrderItemDEX AS _PurchaseOrderItem ON PurchaseOrder = _PurchaseOrderItem.PurchaseOrder AND PurchaseOrderItem = _PurchaseOrderItem.PurchaseOrderItem  -- association [1..1]
LEFT OUTER JOIN C_PurchaseContractDEX AS _PurchaseContract ON PurchaseContract = _PurchaseContract.PurchaseContract  -- association [0..1]
LEFT OUTER JOIN C_PurchaseContractItemDEX AS _PurchaseContractItem ON PurchaseContract = _PurchaseContractItem.PurchaseContract AND PurchaseContractItem = _PurchaseContractItem.PurchaseContractItem  -- association [0..1]
LEFT OUTER JOIN I_PurchasingOrganization AS _PurchasingOrganization ON PurchasingOrganization = _PurchasingOrganization.PurchasingOrganization  -- association [0..1]
LEFT OUTER JOIN I_PurchasingGroup AS _PurchasingGroup ON PurchasingGroup = _PurchasingGroup.PurchasingGroup  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [0..1]
;