I_ServiceOrderItemEnhcd

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_ServiceOrderItemEnhcd.
-- 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: ISERVORDITMENHCD

CREATE VIEW I_ServiceOrderItemEnhcd AS
SELECT
  I_ServiceDocumentEnhcd.ServiceDocument AS ServiceDocument,
  _ServiceDocItem.ServiceDocumentItem AS ServiceDocumentItem,
  _ServiceOrder.ServiceOrder AS ServiceOrder,
  I_ServiceDocumentEnhcd.ServiceObjectType AS ServiceObjectType,
  ServiceDocumentDescription,
  _ServiceDocItem.PurchaseOrderByCustomer AS PurchaseOrderByCustomer,
  _ServiceDocItem.ServiceDocumentItemStatus AS ServiceDocumentItemStatus,
  ServiceDocumentUUID,
  _ServiceDocItem.ServiceDocItemBillingStatus AS ServiceDocItemBillingStatus,
  _ServiceDocItem.PaymentTerms AS PaymentTerms,
  _ServiceDocItem.SrvcSEPAMandateRelevance AS SrvcSEPAMandateRelevance,
  _ServiceDocItem.SEPAMandate AS SEPAMandate,
  _ServiceDocItem.SrvcDocItemExecutionStatus AS SrvcOrdItemExecutionStatus,
  _ServiceDocItem.WBSElementInternalID AS WBSElementInternalID,
  ServiceDocumentRejectionReason,
  ServiceDocumentIsRejected,
  _ServiceDocItem.SrvcDocItmBslnCostPostgStatus AS SrvcDocItmBslnCostPostgStatus,
  _ServiceDocItem.SrvcDocItmContinuousCostStatus AS SrvcDocItmContinuousCostStatus,
  _ServiceDocItem.BillableControl AS BillableControl,
  _ServiceDocItem.ControllingArea AS ControllingArea,
  _ServiceDocItem.BillingPriceSourceName AS BillingPriceSourceName,
  _ServiceDocItem.DocumentDescription AS DocumentDescription,
  _ServiceDocItem.TimeSheetOvertimeCategory AS TimeSheetOvertimeCategory,
  _ServiceDocItem.ServiceDocumentItemUUID AS ServiceDocumentItemUUID,
  _ServiceDocItem.ServiceDocumentItemCharUUID AS ServiceDocumentItemCharUUID,
  _ServiceDocItem.ServiceDocumentItemDescription AS ServiceDocumentItemDescription,
  _ServiceDocItem.OriginallyRequestedProduct AS OriginallyRequestedProduct,
  _ServiceDocItem.ServiceDocItemQuantityUnit AS ServiceDocItemQuantityUnit,
  _ServiceDocItem.ServiceDocItemGrossAmount AS ServiceDocItemGrossAmount,
  _ServiceDocItem.ServiceDocumentItemQuantity AS ServiceDocumentItemQuantity,
  _ServiceDocItem.TransactionCurrency AS TransactionCurrency,
  _ServiceDocItem.ActualServiceDuration AS ActualServiceDuration,
  _ServiceDocItem.ActualServiceDurationUnit AS ActualServiceDurationUnit,
  _ServiceDocItem.ServiceDuration AS ServiceDuration,
  _ServiceDocItem.ServiceDurationUnit AS ServiceDurationUnit,
  _ServiceDocItem.CumulativeConfirmedQuantity AS SrvcOrdItemReservedQuantity,
  _ServiceDocItem.ServiceDocumentItemObjectType AS ServiceDocumentItemObjectType,
  _ServiceDocItem.PlannedServiceStartDateTime AS PlannedServiceStartDateTime,
  _ServiceDocItem.PlannedServiceEndDateTime AS PlannedServiceEndDateTime,
  _ServiceDocItem.ParentServiceDocumentItemUUID AS ParentServiceDocumentItemUUID,
  _ServiceDocItem.ServiceDocumentItemPriority AS ServiceDocumentItemPriority,
  _ServiceDocItem.ContactPerson AS ContactPerson,
  I_ServiceDocumentEnhcd.ServiceDocumentType AS ServiceDocumentType,
  _ServiceDocItem.PostingDate AS PostingDate,
  _ServiceDocItem.SoldToPartyCountry AS SoldToPartyCountry,
  _ServiceDocItem.SoldToPartyRegion AS SoldToPartyRegion,
  _ServiceDocItem.ServiceDocumentItemIsOpen AS ServiceDocumentItemIsOpen,
  _ServiceDocItem.ServiceDocumentItemIsReleased AS ServiceDocumentItemIsReleased,
  _ServiceDocItem.ServiceDocumentItemIsQuotation AS ServiceDocumentItemIsQuotation,
  _ServiceDocItem.SrvcDocItemTransferStatus AS SrvcDocItemTransferStatus,
  _ServiceDocItem.ServiceTeam AS ServiceTeam,
  _ServiceDocItem.SoldToParty AS SoldToParty,
  _ServiceDocItem.ServiceEmployee AS ServiceEmployee,
  _ServiceDocItem.ResponsibleEmployee AS ResponsibleEmployee,
  _ServiceDocItem.ServiceDocumentItemHasError AS ServiceDocumentItemHasError,
  ServiceDocumentHasError,
  ServiceDocumentStatus,
  _ServiceDocItem.ActualServiceStartDateTime AS ActualServiceStartDateTime,
  _ServiceDocItem.BillingDateTime AS BillingDateTime,
  _ServiceDocItem.ProfitCenterDeterminationDate AS ProfitCenterDeterminationDate,
  _ServiceDocItem.RequestedServiceStartDateTime AS RequestedServiceStartDateTime,
  _ServiceDocItem.RequestedServiceEndDateTime AS RequestedServiceEndDateTime,
  _ServiceDocItem.ServicesRenderedDate AS ServicesRenderedDate,
  ServiceDocumentCharUUID,
  _ServiceDocItem.ServiceDocItemCategory AS ServiceDocItemCategory,
  _ServiceDocItem.ProfitCenter AS ProfitCenter,
  _ServiceDocItem.SrvcDocItmIsReleasedForBilling AS SrvcDocItmIsReleasedForBilling,
  _ServiceDocItem.ServiceOrganization AS ServiceOrganization,
  _ServiceDocItem.ResponsibleServiceOrganization AS ResponsibleServiceOrganization,
  _ServiceDocItem.ServiceDocItemCreationDateTime AS ServiceDocItemCreationDateTime,
  _ServiceDocItem.ServiceDocItemChangedDateTime AS ServiceDocItemChangedDateTime,
  _ServiceDocItem.ServiceDocItemCreatedByUser AS ServiceDocItemCreatedByUser,
  _ServiceDocItem.ServiceDocItemChangedByUser AS ServiceDocItemChangedByUser,
  _ServiceDocItem.PayerParty AS PayerParty,
  _ServiceDocItem.ShipToParty AS ShipToParty,
  _ServiceDocItem.BillToParty AS BillToParty,
  _ServiceDocItem.ServiceDocItemRejectionReason AS ServiceDocItemRejectionReason,
  _ServiceDocItem.SalesOrganization AS SalesOrganization,
  _ServiceDocItem.PaymentMethod AS PaymentMethod,
  _ServiceDocItem._PaymentMethod.PaymentMethodDescription AS PaymentMethodDescription,
  _ServiceDocItem.DistributionChannel AS DistributionChannel,
  _ServiceDocItem.Division AS Division,
  _ServiceDocItem.SalesOffice AS SalesOffice,
  _ServiceDocItem.SalesGroup AS SalesGroup,
  _ServiceDocItem.SalesOrganizationOrgUnitID AS SalesOrganizationOrgUnitID,
  _ServiceDocItem.SalesOfficeOrgUnitID AS SalesOfficeOrgUnitID,
  _ServiceDocItem.SalesGroupOrgUnitID AS SalesGroupOrgUnitID,
  _ServiceDocItem._ServiceTeamHeader.TeamName AS RespyMgmtServiceTeamName,
  _ServiceDocItem._ServiceTeamHeader._TeamDescription.TeamDescription AS RespyMgmtServiceTeamDesc,
  _ServiceDocItem.ServiceProfile AS ServiceProfile,
  _ServiceDocItem.ResponseProfile AS ResponseProfile,
  _ServiceDocItem.ServiceFirstResponseByDateTime AS ServiceFirstResponseByDateTime,
  _ServiceDocItem.SrvcDocItemSLADueByDateTime AS SrvcDocItemSLADueByDateTime,
  _ServiceDocItem.SrvcDocItemCreditStatus AS SrvcOrdItemCreditStatus,
  _ServiceDocItem.SrvcDocItemIsUnplanned AS SrvcOrdItemIsUnplanned,
  _ServiceDocItem.ServiceDocumentItemNetAmount AS ServiceDocumentItemNetAmount,
  _ServiceDocItem._ServiceDocItemCategory.ItemIsBillingRelevant AS ItemIsBillingRelevant,
  _ServiceDocItem._ContactPerson AS _ContactPerson,
  _ServiceDocItem._RespEmployee AS _RespEmployee,
  _ServiceDocItem._ServiceDocItemBillingStatus AS _ServiceDocItemBillingStatus,
  _ServiceDocItem._ServiceDocItemCategory AS _ServiceDocItemCategory,
  _ServiceDocItem._ServiceDocItemHasError AS _ServiceDocItemHasError,
  _ServiceDocItem._ServiceDocItemPriority AS _ServiceDocItemPriority,
  _ServiceDocItem._ServiceDocItemStatus AS _ServiceDocItemStatus,
  _ServiceDocItem._SrvcDocItemTransferStatus AS _SrvcDocItemTransferStatus,
  I_ServiceDocumentEnhcd._ServiceDocumentType AS _ServiceDocumentType,
  _ServiceDocItem._ServiceEmployee AS _ServiceEmployee,
  _ServiceDocItem._ServiceTeam AS _ServiceTeam,
  _ServiceDocItem._SoldToParty AS _SoldToParty,
  _ServiceDocItem._SrvcDocItemIsRelForBillgSts AS _SrvcDocItemIsRelForBillgSts,
  _ServiceDocItem._PayerParty AS _PayerParty,
  _ServiceDocItem._ShipToParty AS _ShipToParty,
  _ServiceDocItem._BillToParty AS _BillToParty,
  _ServiceDocItem._ResponseProfile AS _ResponseProfile,
  _ServiceDocItem._ServiceProfile AS _ServiceProfile,
  _ServiceDocItem._ServiceDocOvertimeCat AS _ServiceDocOvertimeCat,
  _ServiceDocItem._ServiceDocItmPrdcssr_2 AS _ServiceDocItmPrdcssr_2,
  _ServiceDocItem._SalesOrganization AS _SalesOrganization,
  _ServiceDocItem._SalesOffice AS _SalesOffice,
  _ServiceDocItem._SalesGroup AS _SalesGroup,
  _ServiceDocItem._Division AS _Division,
  _ServiceDocItem._DistributionChannel AS _DistributionChannel,
  _ServiceDocItem._PaymentTerms AS _PaymentTerms,
  _ServiceDocItem._PaymentMethod AS _PaymentMethod,
  _ServiceDocItem._SrvcSEPAMandateRelevance AS _SrvcSEPAMandateRelevance,
  _ServiceDocItem._ProfitCenter AS _ProfitCenter,
  _ServiceDocItem._SrvcDocItemCreditStatus AS _SrvcDocItemCreditStatus,
  _ServiceDocItem._SrvcDocItmBslnCostPostgStat AS _SrvcDocItmBslnCostPostgStat,
  _ServiceDocItem._SrvcDocItmContinuousCostStat AS _SrvcDocItmContinuousCostStat,
  _ServiceDocItem._SrvcDocExecutionStatus AS _SrvcDocExecutionStatus
FROM I_ServiceDocumentEnhcd
INNER JOIN P_SrvcOrderSrvcConfInfo AS _ServiceOrder ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CustomerSEPAMandate AS _CustomerSEPAMandate ON SEPAMandate = _CustomerSEPAMandate.SEPAMandate AND _CustomerSEPAMandate.SEPAMandateVersion = '0000'  -- association [1..*]
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElement ON WBSElementInternalID = _WBSElement.WBSElementInternalID  -- association [0..1]
;