C_Customer360ServiceOrder

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 C_Customer360ServiceOrder.
-- 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 C_Customer360ServiceOrder AS
SELECT
  ServiceOrder.ServiceDocument AS ServiceOrder,
  ServiceOrder.ServiceDocumentType AS ServiceDocumentType,
  _ServiceOrderType[1:Language = $session.system_language].ServiceDocumentTypeName AS ServiceDocumentTypeName,
  ServiceOrder.ServiceObjectType AS ServiceObjectType,
  ServiceOrder.ServiceDocumentDescription AS ServiceOrderDescription,
  ServiceOrder.SoldToParty AS SoldToParty,
  ServiceOrder._ContactPerson.BusinessPartnerName AS CompanyContactPersonFullName,
  _SrvcDocBPBillToParty.BusinessPartnerName AS BillToPartyName,
  _SrvcDocBPShipToParty.BusinessPartnerName AS ShipToPartyName,
  _SrvcDocBPPayerParty.BusinessPartnerName AS PayerPartyName,
  ServiceOrder.ShipToParty AS ShipToParty,
  ServiceOrder.BillToParty AS BillToParty,
  ServiceOrder.PayerParty AS PayerParty,
  ServiceOrder.ContactPerson AS ContactPersonBusinessPartnerId,
  ServiceOrder.PaymentTerms AS PaymentTerms,
  ServiceOrder._PaymentTerms._Text[1:Language = $session.system_language].PaymentTermsName AS PaymentTermsName,
  ServiceOrder.PaymentMethod AS PaymentMethod,
  ServiceOrder._PaymentMethod[1:SalesOrganization = salesorganization ].PaymentMethodDescription AS PaymentMethodDescription,
  ServiceOrder.SEPAMandate AS SEPAMandate,
  _CustomerSEPAMandate.SEPAMandateCreditor AS SEPAMandateCreditor,
  _CustomerSEPAMandate.SEPAMandateApplication AS SEPAMandateApplication,
  _CustMgmtExtRef.CustMgmtExtRefID AS CustMgmtExtRefID,
  ServiceOrder.ServiceDocumentPriority AS ServiceOrderPriority,
  ServiceOrder._ServiceDocumentPriority._ServiceDocumentPriorityText[1:Language = $session.system_language].ServiceDocumentPriorityName AS ServiceDocumentPriorityName,
  ServiceOrder.PostingDate AS PostingDate,
  ServiceOrder.ServiceDocumentHasError AS ServiceDocumentHasError,
  ServiceOrder.ServiceDocGrossAmount AS ServiceDocGrossAmount,
  ServiceOrder.ServiceDocNetAmount AS ServiceDocNetAmount,
  ServiceOrder.ServiceDocTaxAmount AS ServiceDocTaxAmount,
  ServiceOrder.TransactionCurrency AS TransactionCurrency,
  ServiceOrder._ServiceDocHasError._ServiceDocHasErrorText[1:Language = $session.system_language].ServiceDocumentHasErrorName AS ServiceDocumentHasErrorName,
  ServiceOrder.ServiceDocumentStatus AS ServiceOrderStatus,
  ServiceOrder._ServiceDocRefObj[1:ServiceDocumentItem = '000000']._Equipment.Material AS Material,
  ServiceOrder._ServiceDocRefObj[1:ServiceDocumentItem = '000000']._Equipment._Material.MaterialType AS MaterialType,
  ServiceOrder._ServiceDocRefObj[1:ServiceDocumentItem = '000000'].ProductID AS ProductID,
  ServiceOrder._ServiceDocRefObj[1:ServiceDocumentItem = '000000']._Product._Text[1:Language=$session.system_language].ProductName AS ProductName,
  ServiceOrder.BusinessActivityCategory AS BusinessActivityCategory,
  ServiceOrder.RequestedServiceStartDate AS RequestedServiceStartDate,
  ServiceOrder.RequestedServiceEndDate AS RequestedServiceEndDate,
  ServiceOrder.ServiceDocCreationDateTime AS ServiceDocCreationDateTime,
  cast (ServiceOrder.RequestedServiceStartDateTime as timestamp) AS RequestedServiceStartDateTime,
  cast (ServiceOrder.RequestedServiceEndDateTime as timestamp) AS RequestedServiceEndDateTime,
  ServiceOrder.ResponsibleEmployee AS RespEmployeeBusinessPartnerId,
  ServiceOrder._RespEmployee.BusinessPartnerName AS ResponsibleEmployeeName,
  ServiceOrder.ServiceTeam AS ServiceTeam,
  ServiceOrder._ServiceTeam.BusinessPartnerFullName AS BusinessPartnerFullName,
  ServiceOrder.SoldToPartyCountry AS SoldToPartyCountry,
  ServiceOrder.SoldToPartyRegion AS SoldToPartyRegion,
  ServiceOrder.PurchaseOrderByCustomer AS PurchaseOrderByCustomer,
  ServiceOrder.ServiceEmployee AS ServiceEmployee,
  ServiceOrder.ServiceDocumentUUID AS ServiceDocumentUUID,
  ServiceOrder.ServiceDocumentIsReleased AS ServiceDocumentIsReleased,
  ServiceOrder.ServiceDocumentIsOpen AS ServiceDocumentIsOpen,
  ServiceOrder.ServiceDocumentIsRejected AS ServiceDocumentIsRejected,
  ServiceOrder.SalesOrganization AS SalesOrganization,
  ServiceOrder._SalesOrganization._Text[1:Language = $session.system_language].SalesOrganizationName AS SalesOrganizationName,
  ServiceOrder.DistributionChannel AS DistributionChannel,
  ServiceOrder._DistributionChannel._Text[1:Language = $session.system_language].DistributionChannelName AS DistributionChannelName,
  ServiceOrder.Division AS Division,
  ServiceOrder._Division._Text[1:Language = $session.system_language].DivisionName AS DivisionName,
  ServiceOrder.SalesOffice AS SalesOffice,
  ServiceOrder._SalesOffice._Text[1:Language = $session.system_language].SalesOfficeName AS SalesOfficeName,
  ServiceOrder.SalesGroup AS SalesGroup,
  ServiceOrder._SalesGroup._Text[1:Language = $session.system_language].SalesGroupName AS SalesGroupName,
  ServiceOrder._ServiceDocRefObj[1:ServiceDocumentItem = '000000'].Equipment AS Equipment,
  ServiceOrder._ServiceDocRefObj[1:ServiceDocumentItem = '000000']._Equipment._EquipmentText[1: Language=$session.system_language].EquipmentName AS EquipmentName,
  ServiceOrder.SalesOrganizationOrgUnitID AS SalesOrganizationOrgUnitID,
  ServiceOrder.SalesOfficeOrgUnitID AS SalesOfficeOrgUnitID,
  ServiceOrder.SalesGroupOrgUnitID AS SalesGroupOrgUnitID,
  ServiceOrder.ServiceOrganization AS ServiceOrganization,
  ServiceOrder.RefBusinessSolutionOrder AS RefBusinessSolutionOrder,
  ServiceOrder.SrvcDocCreditStatus AS SrvcOrdCreditStatus,
  ServiceOrder._SrvcDocCreditStatus._SrvcDocCreditStatusText[1:Language = $session.system_language].SrvcDocCreditStatusText AS SrvcDocCreditStatusText,
  ServiceOrder._SalesOrganizationOrgUnit_2 AS _SalesOrganizationOrgUnit_2,
  ServiceOrder._SalesOfficeOrgUnit_2 AS _SalesOfficeOrgUnit_2,
  ServiceOrder._SalesGroupOrgUnit_2 AS _SalesGroupOrgUnit_2,
  ServiceOrder._ServiceOrganizationOrgUnit_2 AS _ServiceOrganizationOrgUnit_2,
  ServiceOrder.RespyMgmtServiceTeam AS RespyMgmtServiceTeam,
  ServiceOrder._ServiceTeamHeader._TeamDescription.TeamDescription AS RespyMgmtServiceTeamDesc,
  ServiceOrder._ServiceTeamHeader.TeamName AS RespyMgmtServiceTeamName,
  cast (_SrvcOrderDateTimeline.ActualServiceStartDateTime as timestamp) AS ActualServiceStartDateTime,
  cast (_SrvcOrderDateTimeline.PlannedServiceEndDateTime as timestamp) AS PlannedServiceEndDateTime,
  cast (_SrvcOrderDateTimeline.PlannedServiceStartDateTime as timestamp) AS PlannedServiceStartDateTime,
  cast (_SrvcOrderDateTimeline.ServiceFirstResponseByDateTime as timestamp) AS ServiceFirstResponseByDateTime,
  cast(_SrvcOrderDateTimeline.SrvcDocItemSLADueByDateTime as timestamp) AS SrvcDocItemSLADueByDateTime,
  _RefMaintenancePlan.MaintenancePlan AS MaintenancePlan,
  _RefMaintenancePlan.MaintenancePlanDesc AS MaintenancePlanDesc,
  ServiceOrder.SrvcDocBslnCostPostgStatus AS SrvcDocBslnCostPostgStatus,
  ServiceOrder._SrvcDocBslnCostPostgStatus._Text[1:Language = $session.system_language].SrvcDocBslnCostPostgStatusText AS SrvcDocBslnCostPostgStatusText,
  ServiceOrder.SrvcDocTransferStatus AS SrvcDocTransferStatus,
  ServiceOrder._SrvcDocTransferStatus._ServiceDocTransferStatusText[1:Language = $session.system_language].SrvcDocTransferStatusText AS SrvcDocTransferStatusText,
  _RefMaintenanceItem.MaintenanceItem AS MaintenanceItem,
  _RefMaintenanceItem.MaintenanceItemDescription AS MaintenanceItemDescription,
  _SrvcDocSystemStatus.StatusCode AS SystemStatus,
  ServiceOrder._ServiceDocumentType.StatusProfile AS StatusProfile,
  _SrvcDocBslnPlannedCost.SrvcDocBslnPlndCostAmount AS SrvcDocBslnPlndCostAmount,
  _SrvcDocBslnPlannedRevenue.SrvcDocBslnPlndRevenueAmount AS SrvcDocBslnPlndRevenueAmount,
  ServiceOrder._SoldToPartyToCustomer.Customer AS Customer,
  cast ( 0 as sit_de_inst_count ) AS SitnNumberOfInstances,
  cast ( 0 as sit_de_inst_count ) AS SitnNmbrOfInstceInHierarchy,
  cast ('' as val_text) AS SrvcDocSituationStatusText,
  cast( '' as crmt_boolean ) AS SrvcDocSituationStatus,
  ServiceOrder._SoldToParty AS _SoldToParty,
  ServiceOrder._ShipToParty AS _ShipToParty,
  ServiceOrder._BillToParty AS _BillToParty,
  ServiceOrder._PayerParty AS _PayerParty,
  ServiceOrder._RespEmployee AS _RespEmployee,
  ServiceOrder._ServiceTeam AS _ServiceTeam,
  ServiceOrder._ServiceEmployee AS _ServiceEmployee,
  ServiceOrder._ContactPerson AS _ContactPerson,
  ServiceOrder._ServiceDocumentType AS _ServiceDocumentType,
  ServiceOrder._ServiceDocumentPriority AS _ServiceDocumentPriority,
  ServiceOrder._ServiceDocumentStatus AS _ServiceDocumentStatus,
  ServiceOrder._ServiceDocHasError AS _ServiceDocHasError,
  ServiceOrder._ActivityCategory AS _ActivityCategory,
  ServiceOrder._ServiceDocRefObj AS _ServiceDocRefObj,
  ServiceOrder._SalesOrganization AS _SalesOrganization,
  ServiceOrder._SalesOffice AS _SalesOffice,
  ServiceOrder._SalesGroup AS _SalesGroup,
  ServiceOrder._Division AS _Division,
  ServiceOrder._DistributionChannel AS _DistributionChannel,
  ServiceOrder._PaymentTerms AS _PaymentTerms,
  ServiceOrder._PaymentMethod AS _PaymentMethod,
  ServiceOrder._ServiceDocRefObj[1:ServiceDocumentItem = '000000']._Product AS _Product,
  ServiceOrder._SrvcDocCreditStatus AS _SrvcDocCreditStatus,
  ServiceOrder._SrvcDocBPSoldToParty AS _SrvcDocBPSoldToParty,
  ServiceOrder._ServiceObjType AS _ServiceObjType,
  ServiceOrder._SrvcDocBslnCostPostgStatus AS _SrvcDocBslnCostPostgStatus,
  ServiceOrder._SrvcDocTransferStatus AS _SrvcDocTransferStatus,
  ServiceOrder._ServiceDocRefObj[1:ServiceDocumentItem = '000000']._Equipment AS _Equipment
FROM I_ServiceDocumentEnhcd AS ServiceOrder
INNER JOIN I_Customer360BusDocSetting AS Customer360BusDocSetting ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN C_SrvcOrderDateTimeline AS _SrvcOrderDateTimeline ON ServiceOrder = _SrvcOrderDateTimeline.ServiceDocument  -- association [1..1]
LEFT OUTER JOIN C_ServiceDocumentItemRefObject AS _ServiceDocumentItemRefObject ON ServiceOrder = _ServiceDocumentItemRefObject.ServiceDocument AND _ServiceDocumentItemRefObject.ServiceDocumentItem = '000000'  -- association [1..*]
LEFT OUTER JOIN C_SrvcDocBPContactCardQuickVw AS _SrvcDocBPContactCard ON ContactPersonBusinessPartnerId = _SrvcDocBPContactCard.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN C_SrvcDocDateInformation AS _SrvcDateInfo ON ( ServiceOrder = _SrvcDateInfo.ServiceDocument AND ServiceObjectType = _SrvcDateInfo.ServiceObjectType AND _SrvcDateInfo.ServiceDocumentItem = '000000' ) OR ( ServiceDocumentUUID = _SrvcDateInfo.SrvcMgmtObjectUUID )  -- association [1..*]
LEFT OUTER JOIN C_SrvcDocUserStatus AS _SrvcOrdUserStatus ON ServiceDocumentUUID = _SrvcOrdUserStatus.StatusObjectUUID  -- association [0..*]
LEFT OUTER JOIN I_StatusObjectUUIDStatus AS _SrvcDocSystemStatus ON ServiceDocumentUUID = _SrvcDocSystemStatus.StatusObjectUUID AND ( _SrvcDocSystemStatus.StatusCode = 'I1002' OR _SrvcDocSystemStatus.StatusCode = 'I1003' OR _SrvcDocSystemStatus.StatusCode = 'I1004' OR _SrvcDocSystemStatus.StatusCode = 'I1005' ) AND _SrvcDocSystemStatus.StatusIsActive = 'X'  -- association [0..*]
LEFT OUTER JOIN I_CustMgmtLifecycleUserStsText AS _CustMgmtLifecycleUserStsText ON ServiceOrderStatus = _CustMgmtLifecycleUserStsText.CustMgmtLifecycleUserStatus AND _CustMgmtLifecycleUserStsText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_ServiceOrderStdVH AS _ServiceOrderStdVH ON ServiceOrder = _ServiceOrderStdVH.ServiceDocument  -- association [0..*]
LEFT OUTER JOIN I_SrvcDocBslnPlannedCost AS _SrvcDocBslnPlannedCost ON _SrvcDocBslnPlannedCost.ServiceDocument = ServiceOrder AND _SrvcDocBslnPlannedCost.ServiceDocumentType = ServiceDocumentType  -- association [0..1]
LEFT OUTER JOIN I_SrvcDocBslnPlannedRevenue AS _SrvcDocBslnPlannedRevenue ON _SrvcDocBslnPlannedRevenue.ServiceDocument = ServiceOrder AND _SrvcDocBslnPlannedRevenue.ServiceDocumentType = ServiceDocumentType  -- association [0..1]
LEFT OUTER JOIN C_SrvcMgmtSoldToPartyQuickVw AS _SrvcDocBPBillToParty ON BillToParty = _SrvcDocBPBillToParty.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN C_SrvcMgmtSoldToPartyQuickVw AS _SrvcDocBPShipToParty ON ShipToParty = _SrvcDocBPShipToParty.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN C_SrvcMgmtSoldToPartyQuickVw AS _SrvcDocBPPayerParty ON PayerParty = _SrvcDocBPPayerParty.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_CustMgmtExtRefID AS _CustMgmtExtRef ON ServiceOrder = _CustMgmtExtRef.CustMgmtDocument AND ServiceObjectType = _CustMgmtExtRef.CustMgmtObjectType AND _CustMgmtExtRef.CustMgmtExtRefIDType = '0009'  -- association [0..1]
LEFT OUTER JOIN I_SrvcOrdRefMaintenancePlan AS _RefMaintenancePlan ON ServiceDocumentUUID = _RefMaintenancePlan.ServiceDocumentUUID AND ServiceObjectType = _RefMaintenancePlan.ServiceObjectType  -- association [0..1]
LEFT OUTER JOIN I_SrvcOrdRefMaintenanceItem AS _RefMaintenanceItem ON ServiceDocumentUUID = _RefMaintenanceItem.ServiceDocumentUUID AND ServiceObjectType = _RefMaintenanceItem.ServiceObjectType  -- association [0..1]
LEFT OUTER JOIN I_ServiceDocumentTypeText AS _ServiceOrderType ON ServiceDocumentType = _ServiceOrderType.ServiceDocumentType  -- association [0..*]
LEFT OUTER JOIN I_CustomerSEPAMandate AS _CustomerSEPAMandate ON SEPAMandate = _CustomerSEPAMandate.SEPAMandate AND _CustomerSEPAMandate.SEPAMandateVersion = '0000'  -- association [1..*]
;