A_ServiceOrder

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_ServiceOrder.
-- 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_ServiceOrder AS
SELECT
  ServiceDocument AS ServiceOrder,
  ServiceDocumentType AS ServiceOrderType,
  ServiceDocumentUUID AS ServiceOrderUUID,
  ServiceDocumentDescription AS ServiceOrderDescription,
  ServiceObjectType,
  Language,
  ServiceDocumentPriority,
  RequestedServiceStartDateTime,
  RequestedServiceEndDateTime,
  ErlstRequestedDeliveryDateTime,
  ServiceDocChangedDateTime,
  PostingDate,
  ServiceDocumentCreationDate,
  ServiceDocumentChangedDate,
  ServiceDocumentCreatedByUser,
  ServiceDocumentChangedByUser,
  ServiceDocumentTemplateType,
  PurchaseOrderByCustomer,
  CustomerPurchaseOrderDate,
  ServiceDocumentIsReleased AS ServiceOrderIsReleased,
  ServiceDocumentIsRejected AS ServiceOrderIsRejected,
  SrvcOrdIsBusinessCompleted,
  SrvcOrdIsBusinessReopened,
  SalesOrganization,
  DistributionChannel,
  Division,
  SalesOffice,
  SalesGroup,
  SoldToParty,
  ShipToParty,
  BillToParty,
  PayerParty,
  ContactPerson,
  ServiceDocGrossAmount,
  ServiceDocNetAmount,
  ServiceDocTaxAmount,
  TransactionCurrency,
  _RefServiceRequest._ServiceDoc.ServiceDocument AS ReferenceServiceRequest,
  _RefServiceContract.ServiceContract AS ReferenceServiceContract,
  _RefServiceTemplate._ServiceDoc.ServiceDocument AS RefServiceOrderTemplate,
  _CustMgmtExtRef.CustMgmtExtRefID AS ReferenceServiceOrder,
  ShippingCondition,
  RespyMgmtServiceTeam,
  _ServiceTeamHeader.TeamName AS RespyMgmtServiceTeamName,
  _ServiceTeamHeader.RespyMgmtGlobalTeamID AS RespyMgmtGlobalTeamID,
  SrvcDocCreditStatus AS SrvcOrdCreditStatus,
  SrvcDocGTSEmbargoStatus AS SrvcOrdGTSEmbargoStatus,
  SrvcDocGTSScreeningStatus AS SrvcOrdGTSScreeningStatus,
  SrvcDocGTSLglControlStatus AS SrvcOrdGTSLglControlStatus,
  SrvcDocExecutionStatus AS SrvcOrdExecutionStatus,
  PaymentTerms,
  PaymentMethod,
  SEPAMandate,
  SrvcSEPAMandateRelevance,
  SalesOrganizationOrgUnitID,
  ServiceOrganization,
  SalesOfficeOrgUnitID,
  SalesGroupOrgUnitID,
  EnterpriseServiceOrganization,
  _SrvcOrdRefFSMServiceCall.FSMServiceCall AS FSMServiceCall,
  ServiceDocumentRejectionReason AS ServiceOrderRejectionReason,
  ReferenceInHouseRepair,
  ReferenceInHouseRepairItem,
  BusinessActivityCategory AS ServiceDocumentCategory
FROM I_ServiceDocumentEnhcd AS ServiceOrder
LEFT OUTER JOIN A_ServiceOrderItem AS _Item ON ServiceOrder = _Item.ServiceOrder  -- association [0..*]
LEFT OUTER JOIN A_ServiceOrderPersonResp AS _PersonResponsible ON ServiceOrder = _PersonResponsible.ServiceOrder  -- association [0..*]
LEFT OUTER JOIN A_ServiceOrderRefObject AS _ReferenceObject ON ServiceOrder = _ReferenceObject.ServiceOrder  -- association [0..*]
LEFT OUTER JOIN A_SrvcOrdProdRefObject AS _ProductReferenceObject ON ServiceOrder = _ProductReferenceObject.ServiceOrder  -- association [0..*]
LEFT OUTER JOIN A_ServiceOrderConfirmation AS _Confirmation ON ServiceOrder = _Confirmation.ServiceOrder  -- association [0..*]
LEFT OUTER JOIN A_ServiceOrderText AS _Text ON ServiceOrder = _Text.ServiceOrder  -- association [0..*]
LEFT OUTER JOIN A_ServiceOrderDefect AS _Defect ON ServiceOrder = _Defect.ServiceOrder  -- association [0..*]
LEFT OUTER JOIN A_SrvcOrdRefServiceContract AS _ReferenceServiceContract ON ServiceOrder = _ReferenceServiceContract.ServiceOrder  -- association [0..*]
LEFT OUTER JOIN I_ServiceDocumentPredecessor AS _RefServiceRequest ON ServiceOrderUUID = _RefServiceRequest.ServiceDocumentUUID AND _RefServiceRequest.ServiceDocPrdcssrBusObjType = 'BUS2000223'  -- association [0..1]
LEFT OUTER JOIN I_ServiceDocumentPredecessor AS _RefServiceTemplate ON ServiceOrderUUID = _RefServiceTemplate.ServiceDocumentUUID AND _RefServiceTemplate.ServiceDocPrdcssrBusObjType = 'BUS2000116' AND ServiceDocumentTemplateType is not initial  -- association [0..1]
LEFT OUTER JOIN A_ServiceOrderPriceElement AS _PricingElement ON ServiceOrder = _PricingElement.ServiceOrder  -- association [0..*]
LEFT OUTER JOIN A_SrvcOrdQualification AS _Qualification ON ServiceOrder = _Qualification.ServiceOrder  -- association [0..*]
LEFT OUTER JOIN I_RespyMgmtTeamHeaderDetail AS _ServiceTeamHeader ON RespyMgmtServiceTeam = _ServiceTeamHeader.RespyMgmtTeamID  -- association [0..1]
LEFT OUTER JOIN I_SrvcOrdRefFSMServiceCall AS _SrvcOrdRefFSMServiceCall ON ServiceOrderUUID = _SrvcOrdRefFSMServiceCall.ServiceDocumentUUID AND _SrvcOrdRefFSMServiceCall.PrdcssrSuccssrDocObjectType = 'FSMCALL'  -- association [0..1]
LEFT OUTER JOIN E_ServiceDocument AS _Extension ON _Extension.ServiceCategory = 'BUS2000116' AND ServiceOrder = _Extension.ServiceOrder  -- association [0..1]
LEFT OUTER JOIN I_CustMgmtExtRefID AS _CustMgmtExtRef ON _CustMgmtExtRef.CustMgmtObjectType = 'BUS2000116' AND ServiceOrder = _CustMgmtExtRef.CustMgmtDocument AND _CustMgmtExtRef.CustMgmtExtRefIDType = '0001'  -- association [0..1]
LEFT OUTER JOIN I_SrvcMgmtObjectStatus AS _SrvcMgmtLifecycleStatus ON ServiceOrderUUID = _SrvcMgmtLifecycleStatus.SrvcMgmtObjectUUID AND _SrvcMgmtLifecycleStatus.SrvcMgmtObjectStatusIsInactive = '' AND ( _SrvcMgmtLifecycleStatus.SrvcMgmtObjectStatus = 'I1002' OR _SrvcMgmtLifecycleStatus.SrvcMgmtObjectStatus = 'I1003' )  -- association [0..1]
LEFT OUTER JOIN P_SrvcPrdcssrSrvcContr AS _RefServiceContract ON ServiceOrderUUID = _RefServiceContract.ServiceDocumentUUID AND _RefServiceContract.NumberOfOccurrences = 1  -- association [0..1]
LEFT OUTER JOIN A_ServiceOrdUserStatus AS _ServiceOrdUserStatus ON ServiceOrder = _ServiceOrdUserStatus.ServiceOrder  -- association [0..*]
LEFT OUTER JOIN A_SrvcOrdPartner AS _Partner ON ServiceOrder = _Partner.ServiceOrder  -- association [0..*]
LEFT OUTER JOIN A_SrvcOrdTransHistory AS _SrvcOrdTransHistory ON ServiceOrder = _SrvcOrdTransHistory.ServiceOrder  -- association [0..*]
LEFT OUTER JOIN A_SrvcOrdDuration AS _Duration ON ServiceOrder = _Duration.ServiceOrder  -- association [0..*]
LEFT OUTER JOIN A_SrvcOrdAppointment AS _Appointment ON ServiceOrder = _Appointment.ServiceOrder  -- association [0..*]
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElement ON _WBSElement.WBSElementInternalID = ServiceOrder.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN A_SrvcOrdInHouseRepairItem AS _InHouseRepairItem ON ServiceOrder = _InHouseRepairItem.ServiceOrder  -- association [0..*]
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElementCO ON _WBSElementCO.WBSElement = ServiceOrder.WBSElement  -- association [0..1]
;