A_ServiceQuotationItem

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 A_ServiceQuotationItem.
-- 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 A_ServiceQuotationItem AS
SELECT
  ServiceDocument AS ServiceQuotation,
  ServiceDocumentItem AS ServiceQuotationItem,
  ServiceDocItemCategory,
  ServiceDocumentItemUUID AS ServiceQuotationItemUUID,
  ServiceDocumentItemDescription AS ServiceQtanItemDescription,
  Language,
  OriginallyRequestedProduct AS Product,
  ServiceDocItemQuantityUnit AS QuantityUnit,
  ServiceDocumentItemQuantity AS Quantity,
  ServiceDuration,
  ServiceDurationUnit,
  ServiceDocumentItemIsQuotation,
  MaintenancePlanningPlant,
  _WorkCenter.Plant AS MaintenanceWorkCenterPlant,
  _WorkCenter.WorkCenter AS MaintenanceWorkCenter,
  SrvcDocItemCategoryUsage,
  _CustMgmtExtRef.CustMgmtExtRefID AS ServiceQtanItemExtReference,
  SrvcDocItmBillingRelevance,
  DynItemProcessorPrfl,
  SoldToParty,
  ShipToParty,
  ResponsibleEmployee AS PersonResponsible,
  _ServicePerformer.CustMgmtBusinessPartner AS ServicePerformer,
  ServiceDocumentItemIsRejected AS ServiceQuotationItemIsRejected,
  ServiceDocItemRejectionReason AS SrvcQtanItmRejectionReason,
  TimeSheetOvertimeCategory,
  _RefServiceContractItem.ReferenceServiceContract AS ReferenceServiceContract,
  _RefServiceContractItem.ReferenceServiceContractItem AS ReferenceServiceContractItem,
  _RefServiceOrderItem._ServiceDocItm._ServiceDocument.ServiceDocument AS ServiceQtanSuccessorOrder,
  _RefServiceOrderItem._ServiceDocItm.ServiceDocumentItem AS ServiceQtanSuccessorOrderItem,
  _ParentServiceDocItem.ServiceDocumentItem AS ParentServiceQuotationItem,
  PaymentTerms,
  MaterialSubstitutionReason,
  TransactionCurrency,
  ServiceDocumentItemNetAmount,
  ServiceDocItemGrossAmount,
  ServiceDocumentItemTaxAmount,
  RespyMgmtServiceTeam,
  _ServiceTeamHeader.TeamName AS RespyMgmtServiceTeamName,
  _ServiceTeamHeader.RespyMgmtGlobalTeamID AS RespyMgmtGlobalTeamID
FROM I_ServiceDocumentItemEnhcd AS ServiceQuotationItem
LEFT OUTER JOIN A_ServiceQtanItemRefObject AS _ReferenceObject ON ServiceQuotation = _ReferenceObject.ServiceQuotation AND ServiceQuotationItem = _ReferenceObject.ServiceQuotationItem  -- association [0..*]
LEFT OUTER JOIN A_ServiceQuotationItemText AS _Text ON ServiceQuotation = _Text.ServiceQuotation AND ServiceQuotationItem = _Text.ServiceQuotationItem  -- association [0..*]
LEFT OUTER JOIN A_ServiceQtanItemPriceElement AS _PricingElement ON ServiceQuotation = _PricingElement.ServiceQuotation AND ServiceQuotationItem = _PricingElement.ServiceQuotationItem  -- association [0..*]
LEFT OUTER JOIN A_ServiceQuotation AS _ServiceQuotation ON ServiceQuotation = _ServiceQuotation.ServiceQuotation  -- association [1]
LEFT OUTER JOIN I_ServiceDocumentItemSuccssr_2 AS _RefServiceOrderItem ON ServiceQuotationItem.ServiceDocumentItemCharUUID = _RefServiceOrderItem.ServiceDocumentItemCharUUID AND _RefServiceOrderItem.ServiceDocItmSuccssrBusObjType = ServiceQuotationItem.ServiceDocumentItemObjectType  -- association [0..1]
LEFT OUTER JOIN A_ServiceOrdItmRefSrvcContr AS _RefServiceContractItem ON ServiceQuotationItemUUID = _RefServiceContractItem.ServiceOrderItemUUID  -- association [0..1]
LEFT OUTER JOIN I_CustMgmtExtRefID AS _CustMgmtExtRef ON ServiceQuotation = _CustMgmtExtRef.CustMgmtDocument AND _CustMgmtExtRef.CustMgmtObjectType = ServiceObjectType AND ServiceQuotationItem = _CustMgmtExtRef.CustMgmtDocumentItem AND _CustMgmtExtRef.CustMgmtExtRefIDType = '0010'  -- association [0..1]
LEFT OUTER JOIN I_SrvcMgmtObjectStatus AS _SrvcMgmtLifeCycleSystemStatus ON ServiceQuotationItemUUID = _SrvcMgmtLifeCycleSystemStatus.SrvcMgmtObjectUUID AND ( _SrvcMgmtLifeCycleSystemStatus.SrvcMgmtObjectStatus = 'I1002' OR _SrvcMgmtLifeCycleSystemStatus.SrvcMgmtObjectStatus = 'I1003' OR _SrvcMgmtLifeCycleSystemStatus.SrvcMgmtObjectStatus = 'I1004' OR _SrvcMgmtLifeCycleSystemStatus.SrvcMgmtObjectStatus = 'I1005' ) AND _SrvcMgmtLifeCycleSystemStatus.SrvcMgmtObjectStatusIsInactive = ' '  -- association [0..1]
LEFT OUTER JOIN E_ServiceDocumentItem AS _Extension ON _Extension.ServiceCategory = 'BUS2000116' AND ServiceQuotation = _Extension.ServiceOrderItem AND ServiceQuotationItem = _Extension.ServiceLineExternalID  -- association [0..1]
LEFT OUTER JOIN I_CustMgmtPartner AS _ServicePerformer ON CustMgmtPartnerFunction = '00000028' AND CustMgmtPartFunctionCategory = '0091' AND ServiceQuotation = _ServicePerformer.CustMgmtDocument AND ServiceQuotationItem = _ServicePerformer.CustMgmtDocumentItem  -- association [0..1]
LEFT OUTER JOIN A_SrvcQtanItmInHouseRepairItem AS _InHouseRepairItem ON ServiceQuotation = _InHouseRepairItem.ServiceQuotation AND ServiceQuotationItem = _InHouseRepairItem.ServiceQuotationItem  -- association [0..*]
LEFT OUTER JOIN I_SrvcMgmtObjectStatus AS _SrvcMgmtSendToPlanningStatus ON ServiceQuotationItemUUID = _SrvcMgmtSendToPlanningStatus.SrvcMgmtObjectUUID AND ( _SrvcMgmtSendToPlanningStatus.SrvcMgmtObjectStatus = 'I1927' ) AND _SrvcMgmtSendToPlanningStatus.SrvcMgmtObjectStatusIsInactive = ' '  -- association [0..1]
;