R_ServiceQuotationItemTP

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 R_ServiceQuotationItemTP.
-- 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 R_ServiceQuotationItemTP AS
SELECT
  ServiceDocument AS ServiceQuotation,
  ServiceDocumentItem AS ServiceQuotationItem,
  ServiceObjectType,
  ServiceDocumentItemObjectType,
  ServiceDocItemCategory AS ServiceQtanItemCategory,
  ServiceDocumentItemUUID AS ServiceQuotationItemUUID,
  _ParentServiceDocItem.ServiceDocumentItem AS ParentServiceQuotationItem,
  ServiceDocumentItemDescription AS ServiceQtanItemDescription,
  Language,
  ServiceDocItemCreationDateTime,
  ServiceDocItemChangedDateTime,
  ServiceDocItemCreatedByUser,
  ServiceDocItemChangedByUser,
  Product,
  ServiceDocumentItemQuantity AS Quantity,
  ServiceDocItemQuantityUnit AS QuantityUnit,
  _WorkCenter.Plant AS MaintenanceWorkCenterPlant,
  _WorkCenter.WorkCenter AS MaintenanceWorkCenter,
  MaintenancePlanningPlant,
  Plant,
  StorageLocation,
  SrvcDocItmBillingRelevance,
  DynItemProcessorPrfl,
  SrvcDocItemCategoryUsage,
  SoldToParty,
  ShipToParty,
  ContactPerson AS ContactPersonBusinessPartnerId,
  ResponsibleEmployee AS RespEmployeeBusinessPartnerId,
  _ServicePerformer.CustMgmtBusinessPartner AS ServicePerformer,
  RespyMgmtServiceTeam,
  _ServiceTeamHeader.RespyMgmtGlobalTeamID AS RespyMgmtGlobalTeamID,
  ServiceDocumentItemStatus AS SrvcQtanItemStatus,
  ServiceDocumentItemIsRejected AS ServiceQuotationItemIsRejected,
  ServiceDocumentItemHasError AS ServiceQuotationItemHasError,
  SrvcDocItmGTSEmbargoStatus AS SrvcQtanItemGTSEmbargoStatus,
  SrvcDocItmGTSLglControlStatus AS SrvcQtanItmGTSLglControlStatus,
  SrvcDocItmGTSScreeningStatus AS SrvcQtanItemGTSScreeningStatus,
  TransactionCurrency,
  ServiceDocItemGrossAmount,
  ServiceDocumentItemNetAmount,
  ServiceDocumentItemTaxAmount,
  PaymentTerms,
  _CustMgmtExtRef.CustMgmtExtRefID AS ServiceQtanItemExtReference,
  _CustMgmtHeaderExtRef.CustMgmtExtRefID AS ServiceQtanExtReference,
  cast( _RefServiceContract.CustMgmtPrdcssrTransactionKey as crmt_object_id_db ) AS ReferenceServiceContract,
  cast( _RefServiceContract.BusinessTransactionDocItem as crms4_number_int ) AS ReferenceServiceContractItem,
  ServiceDocItemRejectionReason AS SrvcQtanItmRejectionReason,
  MaterialSubstitutionReason,
  OriginallyRequestedProduct
FROM I_ServiceDocumentItemEnhcd
LEFT OUTER JOIN I_RespyMgmtTeamHeaderDetail AS _ServiceTeamHeader ON RespyMgmtServiceTeam = _ServiceTeamHeader.RespyMgmtTeamID  -- association [0..1]
LEFT OUTER JOIN I_CustMgmtExtRefID AS _CustMgmtExtRef ON ServiceQuotation = _CustMgmtExtRef.CustMgmtDocument AND ServiceObjectType = _CustMgmtExtRef.CustMgmtObjectType AND ServiceQuotationItem = _CustMgmtExtRef.CustMgmtDocumentItem AND _CustMgmtExtRef.CustMgmtExtRefIDType = '0010'  -- association [0..1]
LEFT OUTER JOIN I_CustMgmtExtRefID AS _CustMgmtHeaderExtRef ON ServiceQuotation = _CustMgmtHeaderExtRef.CustMgmtDocument AND ServiceObjectType = _CustMgmtHeaderExtRef.CustMgmtObjectType AND _CustMgmtHeaderExtRef.CustMgmtExtRefIDType = '0009'  -- association [0..1]
LEFT OUTER JOIN I_SrvcMgmtObjectStatus AS _SrvcQtanItmStatus ON ServiceQuotationItemUUID = _SrvcQtanItmStatus.SrvcMgmtObjectUUID AND ( _SrvcQtanItmStatus.SrvcMgmtObjectStatus = 'I1002' OR _SrvcQtanItmStatus.SrvcMgmtObjectStatus = 'I1003' OR _SrvcQtanItmStatus.SrvcMgmtObjectStatus = 'I1005' OR _SrvcQtanItmStatus.SrvcMgmtObjectStatus = 'I1004' ) AND _SrvcQtanItmStatus.SrvcMgmtObjectStatusIsInactive = ' '  -- association [0..1]
LEFT OUTER JOIN R_SrvcDocItemDocumentFlow AS _RefServiceContract ON ServiceQuotation = _RefServiceContract.ServiceDocument AND ServiceQuotationItem = _RefServiceContract.ServiceDocumentItem AND _RefServiceContract.PrdcssrSuccssrDocObjectType = 'BUS2000112' AND _RefServiceContract.ServiceObjectType = 'BUS2000116'  -- association [0..1]
LEFT OUTER JOIN I_SrvcMgmtObjectStatus AS _SrvcMgmtSendToPlanningStatus ON ServiceQuotationItemUUID=_SrvcMgmtSendToPlanningStatus.SrvcMgmtObjectUUID AND( _SrvcMgmtSendToPlanningStatus.SrvcMgmtObjectStatus = 'I1927' ) AND _SrvcMgmtSendToPlanningStatus.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 _ServicePerformer.CustMgmtPartnerFunction = '00000028' AND _ServicePerformer.CustMgmtPartFunctionCategory = '0091' AND ServiceQuotation = _ServicePerformer.CustMgmtDocument AND ServiceQuotationItem = _ServicePerformer.CustMgmtDocumentItem  -- association [0..1]
LEFT OUTER JOIN R_SrvcQtanItemRefObjectTP AS _SrvcQtanItemRefObjectTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SrvcQtanItemPriceElementTP AS _SrvcQtanItemPriceElementTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SrvcQtanItmFUPSrvcOrdTP AS _SrvcQtanItmFUPSrvcOrdTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SrvcQtanItemPartnerTP AS _SrvcQtanItemPartnerTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SrvcQtanItemDurationTP AS _SrvcQtanItemDurationTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SrvcQtanItemAppointmentTP AS _SrvcQtanItemAppointmentTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SrvcQtanItemUserStatusTP AS _SrvcQtanItemUserStatusTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SrvcQtanItemLongTextTP AS _SrvcQtanItemLongTextTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SrvcQtanItmInhRepairItemTP AS _SrvcQtanItmInhRepairItemTP ON /* condition not available in parsed metadata */  -- association [0..*]
;