P_SrvcOrdItmWthSrvcContrDets

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_SrvcOrdItmWthSrvcContrDets.
-- 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: PSOITMWTHCONTRDT

CREATE VIEW P_SrvcOrdItmWthSrvcContrDets AS
SELECT
  ServiceObjectType,
  ServiceDocument AS ServiceOrder,
  ServiceDocumentItem,
  _SrvOrdItmFupSrvConfContDets.ServiceDocItmSuccssrCharUUID AS ServiceDocItmSuccssrCharUUID,
  ServiceDocumentDescription AS ServiceOrderDescription,
  ServiceDocumentType AS ServiceOrderType,
  ServiceDocumentItemCharUUID AS ServiceOrderItemCharUUID,
  Product AS ServiceOrderItemProduct,
  ServiceDocumentItemStatus AS ServiceOrderItemStatus,
  ServiceDocumentItemIsOpen,
  ServiceDocumentItemIsRejected,
  ServiceDocumentItemQuantity AS ServiceOrderItemQuantity,
  ServiceDocItemQuantityUnit AS ServiceOrderItemQuantityUnit,
  ServiceDocItemCreationDateTime,
  ServiceDocItemCreationDate,
  TransactionCurrency,
  case when _SrvcOrdItmFUPSrvcContrDets.ServiceContract is null then _SrvOrdItmFupSrvConfContDets.ServiceContract else _SrvcOrdItmFUPSrvcContrDets.ServiceContract end as ServiceContract AS ServiceContractendasServiceContract,
  case when _SrvcOrdItmFUPSrvcContrDets.ProfitCenter is null then _SrvOrdItmFupSrvConfContDets.ProfitCenter else _SrvcOrdItmFUPSrvcContrDets.ProfitCenter end as ProfitCenter AS ProfitCenterendasProfitCenter,
  case when _SrvcOrdItmFUPSrvcContrDets.ControllingArea is null then _SrvOrdItmFupSrvConfContDets.ControllingArea else _SrvcOrdItmFUPSrvcContrDets.ControllingArea end as ControllingArea AS ControllingAreaendasControllingArea,
  case when _SrvcOrdItmFUPSrvcContrDets.ServiceContract is not null or _SrvOrdItmFupSrvConfContDets.ServiceContract is not null then cast (1 as abap.int4) else cast (0 as abap.int4) end as NmbrOfFUPServiceOrderItems AS int4endasNmbrOfFUPServiceOrderItems,
  case when _SrvcOrdItmFUPSrvcContrDets.ServiceContract is null and _SrvOrdItmFupSrvConfContDets.ServiceContract is null then cast (1 as abap.int4) else cast (0 as abap.int4) end as NrOfSrvcOrdItmsWthoutContrRef AS int4endasNrOfSrvcOrdItmsWthoutContrRef,
  _MainRefObj.Equipment AS Equipment,
  _MainRefObj.FunctionalLocation AS FunctionalLocation,
  _MainRefObj.ServiceReferenceObjectType AS ServiceReferenceObjectType,
  _MainRefObj._Equipment.EquipmentCategory AS EquipmentCategory,
  _MainRefObj._FunctionalLocation.FunctionalLocationCategory AS FunctionalLocationCategory,
  _MainRefObj._Equipment.TechnicalObjectType AS TechnicalObjectType,
  _MainRefObj._Equipment.Material AS Material,
  _MainRefObj._FunctionalLocation.ConstructionMaterial AS ConstructionMaterial,
  _Period.CalendarQuarter AS SrvcOrdCreationQuarter,
  _Period.CalendarMonth AS SrvcOrdCreationMonth,
  _Period.CalendarYear AS SrvcOrdCreationYear,
  _Period.YearQuarter AS CreationDateYearQuarter,
  _Period.YearMonth AS CreationDateYearMonth,
  RefBusinessSolutionOrder,
  SoldToParty,
  SoldToPartyCountry,
  SoldToPartyRegion,
  Industry,
  SalesOrganization,
  SalesOffice,
  SalesGroup,
  DistributionChannel,
  Division,
  ResponsibleEmployee AS RespEmployeeBusinessPartnerId,
  RespyMgmtServiceTeam,
  _ServiceTeamHeader.TeamName AS TeamName,
  _ServiceTeamHeader._TeamDescription.TeamDescription AS RespyMgmtServiceTeamDesc,
  _MainRefObj._SrvcReferenceObjectType AS _SrvcReferenceObjectType,
  _MainRefObj._Equipment AS _Equipment,
  _MainRefObj._FunctionalLocation AS _FunctionalLocation,
  _MainRefObj._Equipment._EquipmentCategory AS _EquipmentCategory
FROM I_ServiceDocumentItemEnhcd
LEFT OUTER JOIN P_SrvcOrdItmFUPSrvcContrDets AS _SrvcOrdItmFUPSrvcContrDets ON ServiceOrderItemCharUUID = _SrvcOrdItmFUPSrvcContrDets.ServiceOrderItemCharUUID  -- association [0..*]
LEFT OUTER JOIN P_srvorditmfupsrvconfcontrdets AS _SrvOrdItmFupSrvConfContDets ON ServiceOrderItemCharUUID = _SrvOrdItmFupSrvConfContDets.ServiceOrderItemCharUUID  -- association [0..*]
LEFT OUTER JOIN P_SrvcOrdItmFUPSrvcConfDets AS _SrvcOrdItmFUPSrvcConfDets ON ServiceOrderItemCharUUID = _SrvcOrdItmFUPSrvcConfDets.ServiceOrderItemCharUUID  -- association [0..1]
LEFT OUTER JOIN I_ServiceDocumentRefObject AS _MainRefObj ON ServiceObjectType = _MainRefObj.ServiceObjectType AND ServiceOrder = _MainRefObj.ServiceDocument AND ServiceDocumentItem = _MainRefObj.ServiceDocumentItem AND _MainRefObj.SrvcRefObjIsMainObject is not initial  -- association [0..1]
LEFT OUTER JOIN I_CalendarDate AS _Period ON ServiceDocItemCreationDate = _Period.CalendarDate  -- association [0..1]
LEFT OUTER JOIN I_Indicator AS _ServiceContractItemIsActive ON ServiceContractItemIsActive = _ServiceContractItemIsActive.IndicatorValue  -- association [1..1]
LEFT OUTER JOIN I_ServiceDocumentEnhcd AS _ServiceContract ON _ServiceContract.ServiceObjectType = 'BUS2000112' AND ServiceContract = _ServiceContract.ServiceDocument  -- association [0..1]
LEFT OUTER JOIN I_ServiceDocument AS _SolutionOrderVH ON RefBusinessSolutionOrder = _SolutionOrderVH.ServiceDocument AND _SolutionOrderVH.ServiceObjectType = 'BUS2000172'  -- association [0..1]
LEFT OUTER JOIN I_RespyMgmtTeamHeaderDetail AS _ServiceTeamVH ON RespyMgmtServiceTeam = _ServiceTeamVH.RespyMgmtTeamID  -- association [0..1]
;