P_UpcgSrvcContrItemDetails

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 P_UpcgSrvcContrItemDetails.
-- 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 P_UpcgSrvcContrItemDetails AS
SELECT
  ServiceObjectType,
  ServiceDocument AS ServiceContract,
  ServiceDocumentItem AS ServiceContractItem,
  ServiceDocument,
  ServiceDocumentType AS ServiceContractType,
  ServiceDocumentDescription AS ServiceContractDescription,
  Product AS ServiceContractItemProduct,
  ServiceContractItemStartDate,
  ServiceContractItemEndDate,
  ServiceDocItemCreationDate,
  PostingDate,
  ServiceDocumentItemStatus AS ServiceContractItemStatus,
  ServiceDocumentItemCanclnParty AS ServiceContractItemCanclnParty,
  ServiceDocumentItmCanclnReason AS ServiceContractItmCanclnReason,
  ProfitCenter,
  ControllingArea,
  PurchaseOrderByCustomer,
  SoldToParty,
  ResponsibleEmployee AS RespEmployeeBusinessPartnerId,
  RefBusinessSolutionOrder,
  SoldToPartyCountry,
  SoldToPartyRegion,
  SalesOrganization,
  DistributionChannel,
  Division,
  SalesOffice,
  SalesGroup,
  ServiceDocumentItemNetAmount AS ServiceContractItemNetAmount,
  cast(1 as abap.int4) AS NmbrOfServiceContractItems,
  TransactionCurrency,
  case when ServiceContractItemEndDate >= $session.system_date and ServiceContractItemEndDate < dats_add_months (_CurrentDate.FirstDayOfMonthDate,7,'FAIL') then cast (1 as abap.int4) end as NrOfExprgServiceContractItems AS int4endasNrOfExprgServiceContractItems,
  case when ServiceDocumentItmCanclnReason != ' ' then cast (1 as abap.int4) end as NrOfCancldServiceContractItems AS int4endasNrOfCancldServiceContractItems,
  case when ServiceDocumentItemIsReleased = 'X' then cast (1 as abap.int4) end as NrOfReldServiceContractItems AS int4endasNrOfReldServiceContractItems
FROM P_UpcgSrvcContrItemDateConv
LEFT OUTER JOIN I_CalendarDate AS _CurrentDate ON _CurrentDate.CalendarDate = $session.system_date  -- association [0..1]
LEFT OUTER JOIN I_ServiceCancellationParty AS _CancelParty ON ServiceContractItemCanclnParty = _CancelParty.ServiceContractCanclnParty  -- association [0..1]
LEFT OUTER JOIN I_ServiceCancellationReason AS _CancelReason ON ServiceContractItmCanclnReason = _CancelReason.ServiceContrCancellationReason  -- association [0..1]
;