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
  _ServiceOrderType[1:Language = $session.system_language].ServiceDocumentTypeName AS ServiceDocumentTypeName,
  ServiceOrder._ContactPerson.BusinessPartnerName AS CompanyContactPersonFullName,
  ServiceOrder._PaymentTerms._Text[1:Language = $session.system_language].PaymentTermsName AS PaymentTermsName,
  ServiceOrder._PaymentMethod[1:SalesOrganization = salesorganization ].PaymentMethodDescription AS PaymentMethodDescription,
  ServiceOrder._ServiceDocumentPriority._ServiceDocumentPriorityText[1:Language = $session.system_language].ServiceDocumentPriorityName AS ServiceDocumentPriorityName,
  ServiceOrder._ServiceDocHasError._ServiceDocHasErrorText[1:Language = $session.system_language].ServiceDocumentHasErrorName AS ServiceDocumentHasErrorName,
  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,
  cast (ServiceOrder.RequestedServiceStartDateTime as timestamp) AS RequestedServiceStartDateTime,
  cast (ServiceOrder.RequestedServiceEndDateTime as timestamp) AS RequestedServiceEndDateTime,
  ServiceOrder._RespEmployee.BusinessPartnerName AS ResponsibleEmployeeName,
  ServiceOrder._ServiceTeam.BusinessPartnerFullName AS BusinessPartnerFullName,
  ServiceOrder._SalesOrganization._Text[1:Language = $session.system_language].SalesOrganizationName AS SalesOrganizationName,
  ServiceOrder._DistributionChannel._Text[1:Language = $session.system_language].DistributionChannelName AS DistributionChannelName,
  ServiceOrder._Division._Text[1:Language = $session.system_language].DivisionName AS DivisionName,
  ServiceOrder._SalesOffice._Text[1:Language = $session.system_language].SalesOfficeName AS SalesOfficeName,
  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._SrvcDocCreditStatus._SrvcDocCreditStatusText[1:Language = $session.system_language].SrvcDocCreditStatusText AS SrvcDocCreditStatusText,
  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,
  ServiceOrder._SrvcDocBslnCostPostgStatus._Text[1:Language = $session.system_language].SrvcDocBslnCostPostgStatusText AS SrvcDocBslnCostPostgStatusText,
  ServiceOrder._SrvcDocTransferStatus._ServiceDocTransferStatusText[1:Language = $session.system_language].SrvcDocTransferStatusText AS SrvcDocTransferStatusText,
  ServiceOrder._ServiceDocumentType.StatusProfile AS StatusProfile,
  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._ServiceDocRefObj[1:ServiceDocumentItem = '000000']._Product AS _Product,
  ServiceOrder._ServiceDocRefObj[1:ServiceDocumentItem = '000000']._Equipment AS _Equipment,
  ServiceOrder.ServiceDocument AS ServiceOrder,
  ServiceOrder.ServiceDocumentType AS ServiceDocumentType,
  ServiceOrder.ServiceObjectType AS ServiceObjectType,
  ServiceOrder.ServiceDocumentDescription AS ServiceOrderDescription,
  ServiceOrder.SoldToParty AS SoldToParty,
  ServiceOrder.ShipToParty AS ShipToParty,
  ServiceOrder.BillToParty AS BillToParty,
  ServiceOrder.PayerParty AS PayerParty,
  ServiceOrder.ContactPerson AS ContactPersonBusinessPartnerId,
  ServiceOrder.PaymentTerms AS PaymentTerms,
  ServiceOrder.PaymentMethod AS PaymentMethod,
  ServiceOrder.SEPAMandate AS SEPAMandate,
  ServiceOrder.ServiceDocumentPriority AS ServiceOrderPriority,
  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.ServiceDocumentStatus AS ServiceOrderStatus,
  ServiceOrder.BusinessActivityCategory AS BusinessActivityCategory,
  ServiceOrder.RequestedServiceStartDate AS RequestedServiceStartDate,
  ServiceOrder.RequestedServiceEndDate AS RequestedServiceEndDate,
  ServiceOrder.ServiceDocCreationDateTime AS ServiceDocCreationDateTime,
  ServiceOrder.ResponsibleEmployee AS RespEmployeeBusinessPartnerId,
  ServiceOrder.ServiceTeam AS ServiceTeam,
  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.DistributionChannel AS DistributionChannel,
  ServiceOrder.Division AS Division,
  ServiceOrder.SalesOffice AS SalesOffice,
  ServiceOrder.SalesGroup AS SalesGroup,
  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._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.SrvcDocBslnCostPostgStatus AS SrvcDocBslnCostPostgStatus,
  ServiceOrder.SrvcDocTransferStatus AS SrvcDocTransferStatus,
  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._SrvcDocCreditStatus AS _SrvcDocCreditStatus,
  ServiceOrder._SrvcDocBPSoldToParty AS _SrvcDocBPSoldToParty,
  ServiceOrder._ServiceObjType AS _ServiceObjType,
  ServiceOrder._SrvcDocBslnCostPostgStatus AS _SrvcDocBslnCostPostgStatus,
  ServiceOrder._SrvcDocTransferStatus AS _SrvcDocTransferStatus,
  _CustMgmtExtRef.CustMgmtExtRefID AS CustMgmtExtRefID,
  _CustomerSEPAMandate.SEPAMandateCreditor AS SEPAMandateCreditor,
  _CustomerSEPAMandate.SEPAMandateApplication AS SEPAMandateApplication,
  _RefMaintenanceItem.MaintenanceItem AS MaintenanceItem,
  _RefMaintenanceItem.MaintenanceItemDescription AS MaintenanceItemDescription,
  _RefMaintenancePlan.MaintenancePlan AS MaintenancePlan,
  _RefMaintenancePlan.MaintenancePlanDesc AS MaintenancePlanDesc,
  _SrvcDocBPBillToParty.BusinessPartnerName AS BillToPartyName,
  _SrvcDocBPPayerParty.BusinessPartnerName AS PayerPartyName,
  _SrvcDocBPShipToParty.BusinessPartnerName AS ShipToPartyName,
  _SrvcDocBslnPlannedCost.SrvcDocBslnPlndCostAmount AS SrvcDocBslnPlndCostAmount,
  _SrvcDocBslnPlannedRevenue.SrvcDocBslnPlndRevenueAmount AS SrvcDocBslnPlndRevenueAmount,
  _SrvcDocSystemStatus.StatusCode AS SystemStatus
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..*]
;