R_ServiceOrderTP

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_ServiceOrderTP.
-- 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_ServiceOrderTP AS
SELECT
  ServiceDocument AS ServiceOrder,
  ServiceObjectType,
  ServiceDocumentType AS ServiceOrderType,
  ServiceDocumentUUID AS ServiceOrderUUID,
  ServiceDocumentDescription AS ServiceOrderDescription,
  Language,
  PostingDate,
  ServiceDocCreationDateTime,
  ServiceDocChangedDateTime,
  ServiceDocumentCreatedByUser,
  ServiceDocumentChangedByUser,
  SoldToParty,
  ShipToParty,
  BillToParty,
  PayerParty,
  PaymentTerms,
  PaymentMethod,
  SEPAMandate,
  SrvcSEPAMandateRelevance,
  ContactPerson AS ContactPersonBusinessPartnerId,
  ResponsibleEmployee AS RespEmployeeBusinessPartnerId,
  SalesOrganization,
  DistributionChannel,
  Division,
  ResponsibleSalesOrganization,
  SalesOffice,
  SalesGroup,
  SalesOrganizationOrgUnitID,
  SalesOfficeOrgUnitID,
  SalesGroupOrgUnitID,
  ServiceOrganization,
  RespyMgmtServiceTeam,
  _ServiceTeamHeader.RespyMgmtGlobalTeamID AS RespyMgmtGlobalTeamID,
  EnterpriseServiceOrganization,
  BusinessActivityCategory AS ServiceDocumentCategory,
  SrvcDocGTSEmbargoStatus AS SrvcOrdGTSEmbargoStatus,
  SrvcDocGTSScreeningStatus AS SrvcOrdGTSScreeningStatus,
  SrvcDocGTSLglControlStatus AS SrvcOrdGTSLglControlStatus,
  SrvcOrdIsBusinessCompleted,
  SrvcOrdIsBusinessReopened,
  ServiceDocumentIsRejected AS ServiceOrderIsRejected,
  ServiceDocumentIsQuotation,
  ServiceDocumentTemplateType,
  ServiceDocumentStatus AS ServiceOrderStatus,
  ServiceDocIsReleasedForBilling AS SrvcOrdReldForBillingStatus,
  ServiceDocBillingStatus AS SrvcOrdBillingStatus,
  ServiceDocumentHasError AS ServiceOrderHasError,
  SrvcDocTransferStatus,
  SrvcDocExecutionStatus AS SrvcOrdExecutionStatus,
  SrvcDocRejectionStatus,
  SrvcDocCreditStatus AS SrvcOrdCreditStatus,
  SrvcDocWarrantyStatus,
  RequestedServiceStartDateTime,
  RequestedServiceEndDateTime,
  ErlstRequestedDeliveryDateTime,
  ServiceDocumentPriority,
  TransactionCurrency,
  ServiceDocGrossAmount,
  ServiceDocNetAmount,
  ServiceDocTaxAmount,
  PricingDocument,
  PurchaseOrderByCustomer,
  CustomerPurchaseOrderDate,
  ServiceDocumentRejectionReason AS ServiceOrderRejectionReason,
  _CustMgmtExtRef.CustMgmtExtRefID AS SrvcOrdExtReference,
  _RefServiceContract.ServiceContract AS ReferenceServiceContract,
  cast( _RefServiceTemplate.CustMgmtPrdcssrTransactionKey as crmt_object_id_db ) AS RefServiceOrderTemplate,
  cast( _SinglePredecessorQtan.ReferenceServiceQtan as crms4_reference_document_id_co ) AS ReferenceServiceQtan,
  _RefServiceRequest._ServiceDoc.ServiceDocument AS ReferenceServiceRequest,
  ShippingCondition,
  _WBSElement.WBSElementExternalID AS WBSElementExternalID,
  _SrvcOrdRefFSMServiceCall.FSMServiceCall AS FSMServiceCall,
  _SvOrdRefSvCldV2ServiceOrder.SrvcCloudVersion2ServiceOrder AS SrvcCloudVersion2ServiceOrder
FROM I_ServiceDocumentEnhcd
LEFT OUTER JOIN I_CustMgmtExtRefID AS _CustMgmtExtRef ON ServiceOrder = _CustMgmtExtRef.CustMgmtDocument AND ServiceObjectType = _CustMgmtExtRef.CustMgmtObjectType AND _CustMgmtExtRef.CustMgmtExtRefIDType = '0001'  -- association [0..1]
LEFT OUTER JOIN I_ServiceDocumentSuccessor AS _Confirmation ON ServiceOrderUUID = _Confirmation.ServiceDocumentUUID AND _Confirmation.ServiceDocSuccessorBusObjType = 'BUS2000117'  -- association [0..*]
LEFT OUTER JOIN P_SrvcPrdcssrSrvcContr AS _RefServiceContract ON ServiceOrderUUID = _RefServiceContract.ServiceDocumentUUID AND _RefServiceContract.NumberOfOccurrences = 1  -- association [0..1]
LEFT OUTER JOIN R_SrvcDocDocumentFlow AS _RefServiceTemplate ON ServiceOrderUUID = _RefServiceTemplate.ServiceDocumentUUID AND _RefServiceTemplate.PrdcssrSuccssrDocObjectType = 'BUS2000116' AND _RefServiceTemplate.ServiceObjectType = 'BUS2000116' AND _RefServiceTemplate.ServiceDocumentTemplateType is not initial  -- association [0..1]
LEFT OUTER JOIN I_RespyMgmtTeamHeaderDetail AS _ServiceTeamHeader ON RespyMgmtServiceTeam = _ServiceTeamHeader.RespyMgmtTeamID  -- association [0..1]
LEFT OUTER JOIN I_StatusObjectUUIDStatus AS _SrvcOrdStatus ON ServiceOrderUUID = _SrvcOrdStatus.StatusObjectUUID AND ( _SrvcOrdStatus.StatusCode = 'I1002' OR _SrvcOrdStatus.StatusCode = 'I1003' OR _SrvcOrdStatus.StatusCode = 'I1004' OR _SrvcOrdStatus.StatusCode = 'I1005' ) AND _SrvcOrdStatus.StatusIsActive = 'X'  -- association [0..1]
LEFT OUTER JOIN I_SrvcOrdRefFSMServiceCall AS _SrvcOrdRefFSMServiceCall ON ServiceOrderUUID = _SrvcOrdRefFSMServiceCall.ServiceDocumentUUID AND _SrvcOrdRefFSMServiceCall.PrdcssrSuccssrDocObjectType = 'FSMCALL'  -- association [0..1]
LEFT OUTER JOIN I_SvOrdRefSvCldV2ServiceOrder AS _SvOrdRefSvCldV2ServiceOrder ON ServiceOrderUUID = _SvOrdRefSvCldV2ServiceOrder.ServiceDocumentUUID AND _SvOrdRefSvCldV2ServiceOrder.PrdcssrSuccssrDocObjectType = 'SVCLDSO'  -- association [0..1]
LEFT OUTER JOIN E_ServiceDocument AS _Extension ON ServiceObjectType = _Extension.ServiceCategory AND ServiceOrder = _Extension.ServiceOrder  -- association [0..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElement ON _WBSElement.WBSElementInternalID = I_ServiceDocumentEnhcd.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN P_SrvcDocWithSglPrdcssrQtan AS _SinglePredecessorQtan ON ServiceOrderUUID = _SinglePredecessorQtan.ServiceDocumentUUID AND ServiceOrder = _SinglePredecessorQtan.ServiceDocument  -- association [0..1]
LEFT OUTER JOIN I_ServiceDocumentPredecessor AS _RefServiceRequest ON ServiceOrderUUID = _RefServiceRequest.ServiceDocumentUUID AND _RefServiceRequest.ServiceDocPrdcssrBusObjType = 'BUS2000223'  -- association [0..1]
LEFT OUTER JOIN R_ServiceOrderItemTP AS _ServiceOrderItemTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SrvcOrdPartnerTP AS _SrvcOrdPartnerTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SrvcOrdReferenceObjectTP AS _SrvcOrdReferenceObjectTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SrvcOrdPriceElementTP AS _SrvcOrdPriceElementTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SrvcOrdUserStatusTP AS _SrvcOrdUserStatusTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SrvcOrdFUPSrvcConfTP AS _SrvcOrdFUPSrvcConfTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SrvcOrdFUPBillgDocTP AS _SrvcOrdFUPBillgDocTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SrvcOrdFUPBillingDocReqTP AS _SrvcOrdFUPBillingDocReqTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SrvcOrdFUPPurchaseOrderTP AS _SrvcOrdFUPPurchaseOrderTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SrvcOrdFUPPurReqnTP AS _SrvcOrdFUPPurReqnTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SrvcOrdFUPSrvcEntrSheetTP AS _SrvcOrdFUPSrvcEntrSheetTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SrvcOrdFUPSuplrInvcTP AS _SrvcOrdFUPSuplrInvcTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SrvcOrdAppointmentTP AS _SrvcOrdAppointmentTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SrvcOrdDurationTP AS _SrvcOrdDurationTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SrvcOrdFUPMaintOrdTP AS _SrvcOrdFUPMaintOrdTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SrvcOrdLongTextTP AS _SrvcOrdLongTextTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SrvcOrdDefectTP AS _SrvcOrdDefectTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SrvcOrdRefServiceContractTP AS _SrvcOrdRefServiceContractTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SrvcOrdInHouseRepairItemTP AS _SrvcOrdInHouseRepairItemTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SrvcOrdQualificationTP AS _SrvcOrdQualificationTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SrvcOrdFUPServiceOrderTP AS _SrvcOrdFUPServiceOrderTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_ServiceOrderPaymentPlanTP AS _ServiceOrderPaymentPlanTP ON /* condition not available in parsed metadata */  -- association [0..*]
;