C_ServiceConfirmationItemDEX

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_ServiceConfirmationItemDEX.
-- 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 C_ServiceConfirmationItemDEX AS
SELECT
  ServiceOrderItem.ServiceObjectType AS ServiceObjectType,
  ServiceOrderItem.ServiceDocument AS ServiceDocument,
  ServiceOrderItem.ServiceDocumentItem AS ServiceDocumentItem,
  ServiceOrder.ServiceDocumentUUID AS ServiceDocumentUUID,
  ServiceOrder.ServiceDocumentCharUUID AS ServiceDocumentCharUUID,
  ServiceOrder.ServiceDocumentDescription AS ServiceDocumentDescription,
  ServiceOrder.ServiceDocNetAmount AS ServiceDocNetAmount,
  ServiceOrder.PurchaseOrderByCustomer AS PurchaseOrderByCustomer,
  ServiceOrder.ServiceDocumentStatus AS ServiceDocumentStatus,
  ServiceOrder.ServiceDocumentHasError AS ServiceDocumentHasError,
  ServiceOrder.ServiceDocIsReleasedForBilling AS ServiceDocIsReleasedForBilling,
  ServiceOrder.ServiceDocBillingStatus AS ServiceDocBillingStatus,
  ServiceOrder.ServiceDocumentIsOpen AS ServiceDocumentIsOpen,
  ServiceOrder.BusinessActivityCategory AS BusinessActivityCategory,
  ServiceOrder.ServiceDocChangedDateTime AS ServiceDocChangedDateTime,
  ServiceOrder.ServiceDocCreationDateTime AS ServiceDocCreationDateTime,
  ServiceOrder.RequestedServiceStartDate AS RequestedServiceStartDate,
  ServiceOrder.RequestedServiceEndDate AS RequestedServiceEndDate,
  ServiceOrderItem.ServiceDocumentItemPriority AS ServiceDocumentItemPriority,
  ServiceOrderItem.ServiceDocumentType AS ServiceDocumentType,
  ServiceOrderItem.ServiceDocumentItemUUID AS ServiceDocumentItemUUID,
  ServiceOrderItem.ServiceDocumentItemObjectType AS ServiceDocumentItemObjectType,
  ServiceOrderItem.ParentServiceDocumentItemUUID AS ParentServiceDocumentItemUUID,
  ServiceOrderItem.PostingDate AS PostingDate,
  ServiceOrderItem.ProfitCenter AS ProfitCenter,
  ServiceOrderItem.ControllingArea AS ControllingArea,
  ServiceOrderItem.ProfitCenterDeterminationDate AS ProfitCenterDeterminationDate,
  ServiceOrderItem.ServiceDocItemCategory AS ServiceDocItemCategory,
  ServiceOrderItem.OriginallyRequestedProduct AS OriginallyRequestedProduct,
  ServiceOrderItem.Product AS Product,
  ServiceOrderItem.ActualServiceStartDateTime AS ActualServiceStartDateTime,
  ServiceOrderItem.ActualServiceEndDateTime AS ActualServiceEndDateTime,
  ServiceOrderItem.ActualServiceDuration AS ActualServiceDuration,
  ServiceOrderItem.ActualServiceDurationUnit AS ActualServiceDurationUnit,
  ServiceOrderItem.TimeSheetOvertimeCategory AS TimeSheetOvertimeCategory,
  ServiceOrderItem.InvoiceAmountInInvoiceDocCrcy AS InvoiceAmountInInvoiceDocCrcy,
  ServiceOrderItem.SrvcDocItmRequestedQuantity AS SrvcDocItmRequestedQuantity,
  ServiceOrderItem.InvoiceQuantity AS InvoiceQuantity,
  ServiceOrderItem.SrvcDocItmDeliveredQuantity AS SrvcDocItmDeliveredQuantity,
  ServiceOrderItem.SrvcDocItmOrdToBaseQtyNmrtr AS SrvcDocItmOrdToBaseQtyNmrtr,
  ServiceOrderItem.SrvcDocItmOrdToBaseQtyDnmntr AS SrvcDocItmOrdToBaseQtyDnmntr,
  ServiceOrderItem.OrderToBaseQuantityExponent AS OrderToBaseQuantityExponent,
  ServiceOrderItem.ServiceDocItemQuantityUnit AS ServiceDocItemQuantityUnit,
  ServiceOrderItem.SrvcDocItemBaseQuantityUnit AS SrvcDocItemBaseQuantityUnit,
  ServiceOrderItem.ServiceTeam AS ServiceTeam,
  ServiceOrderItem.SoldToParty AS SoldToParty,
  ServiceOrderItem.SoldToPartyCountry AS SoldToPartyCountry,
  ServiceOrderItem.SoldToPartyRegion AS SoldToPartyRegion,
  ServiceOrderItem.ResponsibleEmployee AS ResponsibleEmployee,
  ServiceOrderItem.ContactPerson AS ContactPerson,
  ServiceOrderItem.TransactionCurrency AS TransactionCurrency,
  ServiceOrderItem.StatisticsCurrency AS StatisticsCurrency,
  ServiceOrderItem.ExchangeRateType AS ExchangeRateType,
  ServiceOrderItem.ExchangeRateDate AS ExchangeRateDate,
  ServiceOrderItem.AccountingExchangeRate AS AccountingExchangeRate,
  ServiceOrderItem.CustomerGroup AS CustomerGroup,
  ServiceOrderItem.BillableControl AS BillableControl,
  ServiceOrderItem.BillingBlockReason AS BillingBlockReason,
  ServiceOrderItem.AdditionalCustomerGroup1 AS AdditionalCustomerGroup1,
  ServiceOrderItem.AdditionalCustomerGroup2 AS AdditionalCustomerGroup2,
  ServiceOrderItem.AdditionalCustomerGroup3 AS AdditionalCustomerGroup3,
  ServiceOrderItem.AdditionalCustomerGroup4 AS AdditionalCustomerGroup4,
  ServiceOrderItem.AdditionalCustomerGroup5 AS AdditionalCustomerGroup5,
  ServiceOrderItem.SalesOrganizationOrgUnitID AS SalesOrganizationOrgUnitID,
  ServiceOrderItem.SalesOfficeOrgUnitID AS SalesOfficeOrgUnitID,
  ServiceOrderItem.SalesGroupOrgUnitID AS SalesGroupOrgUnitID,
  ServiceOrderItem.DistributionChannel AS DistributionChannel,
  ServiceOrderItem.Division AS Division,
  ServiceOrderItem.ServiceOrganization AS ServiceOrganization,
  ServiceOrderItem.ResponsibleSalesOrganization AS ResponsibleSalesOrganization,
  ServiceOrderItem.ResponsibleServiceOrganization AS ResponsibleServiceOrganization,
  ServiceOrderItem.SalesOrganization AS SalesOrganization,
  ServiceOrderItem.SalesOffice AS SalesOffice,
  ServiceOrderItem.SalesGroup AS SalesGroup,
  ServiceOrderItem.ServiceDocumentItemStatus AS ServiceDocumentItemStatus,
  ServiceOrderItem.ServiceDocumentItemHasError AS ServiceDocumentItemHasError,
  ServiceOrderItem.ServiceDocItemBillingStatus AS ServiceDocItemBillingStatus,
  ServiceOrderItem.SrvcDocItmIsReleasedForBilling AS SrvcDocItmIsReleasedForBilling,
  ServiceOrderItem.ServiceDocumentItemIsRejected AS ServiceDocumentItemIsRejected,
  ServiceOrderItem.ServiceDocumentItemIsOpen AS ServiceDocumentItemIsOpen,
  ServiceOrderItem.ServiceDocumentItemNetAmount AS ServiceDocumentItemNetAmount,
  ServiceOrderItem.ServiceDocItemGrossAmount AS ServiceDocItemGrossAmount,
  ServiceOrderItem.ProductGroup AS ProductGroup,
  ServiceOrderItem.ProductGroup AS SrvcMaterialPricingGroup,
  ServiceOrderItem.ProductGroup1 AS ProductGroup1,
  ServiceOrderItem.ProductGroup2 AS ProductGroup2,
  ServiceOrderItem.ProductGroup3 AS ProductGroup3,
  ServiceOrderItem.ProductGroup4 AS ProductGroup4,
  ServiceOrderItem.ProductGroup5 AS ProductGroup5,
  ServiceOrderItem.ProductHierarchy AS ProductHierarchy,
  ServiceOrdItemRefObj.ServiceRefObjectSequenceNumber AS ServiceRefObjectSequenceNumber,
  ServiceOrdItemRefObj.ServiceReferenceObjectType AS ServiceReferenceObjectType,
  ServiceOrdItemRefObj.ServiceReferenceObjectUUID AS ServiceReferenceObjectUUID,
  ServiceOrdItemRefObj.ProductID AS ProductID,
  ServiceOrdItemRefObj.SrvcRefObjIsMainObject AS SrvcRefObjIsMainObject,
  ServiceOrdItemRefObj.ProductUUID AS ProductUUID,
  ServiceOrdItemRefObj.SerialNumber AS SerialNumber,
  ServiceOrdItemRefObj.Equipment AS Equipment,
  ServiceOrdItemRefObj.FunctionalLocation AS FunctionalLocation,
  ServiceDocumentPredecessor.ServiceDocumentRelationUUID AS ServiceDocumentRelationUUID,
  ServiceDocumentPredecessor.ServiceDocumentRelationUUID AS ServiceDocumentRelationUUID_2,
  ServiceDocumentPredecessor.ServiceDocRltnSequenceNumber AS ServiceDocRltnSequenceNumber,
  ServiceDocumentPredecessor.ServiceDocRltnSequenceNumber AS ServiceDocRltnSequenceNumber_2,
  ServiceDocumentPredecessor.ServiceDocumentPredecessorUUID AS SrvcOrdPredecessorUUID,
  ServiceDocumentPredecessor.ServiceDocPrdcssrBusObjType AS SrvcOrdPrdcssrBusObjType,
  ServiceDocumentItemPrdcssr.ServiceDocumentItmRelationUUID AS ServiceDocumentItmRelationUUID,
  ServiceDocumentItemPrdcssr.ServiceDocumentItmRelationUUID AS SrvcDocItmRelationUUID_2,
  ServiceDocumentItemPrdcssr.ServiceDocItmRltnSqncNumber AS ServiceDocItmRltnSqncNumber,
  ServiceDocumentItemPrdcssr.ServiceDocItmRltnSqncNumber AS ServiceDocItmRltnSqncNumber_2,
  ServiceDocumentItemPrdcssr.ServiceDocItmPrdcssrCharUUID AS SrvcOrdItmPrdcssrCharUUID,
  ServiceDocumentItemPrdcssr.ServiceDocItmPrdcssrBusObjType AS SrvcOrdItmPrdcssrBusObjType,
  ServiceOrderItemPrdcssr.ServiceDocItmPrdcssrCharUUID AS SrvcOrdItmPrdcssrCharUUID_2,
  ServiceOrderItemPrdcssr.ServiceDocItmPrdcssrBusObjType AS SrvcOrdItmPrdcssrBusObjType_2,
  ServiceOrderItem._ServiceObjType AS _ServiceObjType,
  ServiceOrderItem._ServiceDocument AS _ServiceDocument,
  ServiceOrderItem._BaseUnit_2 AS _BaseUnit_2,
  ServiceOrderItem._SalesUnit AS _SalesUnit,
  ServiceOrderItem._TransactionCurrency AS _TransactionCurrency
FROM I_ServiceDocumentItemEnhcd AS ServiceOrderItem
LEFT OUTER JOIN E_ServiceDocumentItem AS _ServiceDocItemExt ON ServiceObjectType = _ServiceDocItemExt.ServiceCategory AND ServiceDocument = _ServiceDocItemExt.ServiceOrderItem AND ServiceDocumentItem = _ServiceDocItemExt.ServiceLineExternalID  -- association [0..1]
LEFT OUTER JOIN E_ServiceDocument AS _ServiceDocumentExt ON ServiceObjectType = _ServiceDocumentExt.ServiceCategory AND ServiceDocument = _ServiceDocumentExt.ServiceOrder  -- association [0..1]
;