C_SrvcOrderListRptAndObjPg

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_SrvcOrderListRptAndObjPg.
-- 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.
-- SQL view name: CSRVCORDERLIST

CREATE VIEW C_SrvcOrderListRptAndObjPg AS
SELECT
  cast( 1 as abap.dec(13,3)) AS ServiceDocDuration,
  _ServiceDocRefObj._Equipment._EquipmentText[1: Language=$session.system_language].EquipmentName AS EquipmentName,
  _ServiceDocRefObj._FunctionalLocation._FunctionalLocationText[1: Language=$session.system_language].FunctionalLocationName AS FunctionalLocationName,
  _ServiceDocRefObj._Equipment.Material AS ReferenceProduct,
  _ServiceDocRefObj._Product._Text[1: Language=$session.system_language].ProductName AS ProductName,
  tstmp_to_dats( RequestedServiceStartDateTime, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL' ) as RequestedServiceStartDate AS clientNULLasRequestedServiceStartDate,
  tstmp_to_dats( RequestedServiceEndDateTime, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL' ) as RequestedServiceEndDate AS clientNULLasRequestedServiceEndDate,
  bintohex( ServiceDocumentUUID ) AS ServiceOrderUUID,
  cast( '' as abap.char( 40 )) AS ServiceDocBillingStatusName,
  cast(3 as abap.int4) AS ServiceDocIsRelForBillCritlty,
  cast( '' as abap.char( 40 )) AS ServiceDocOvrlBillgBlkStsName,
  cast(3 as abap.int4) AS SrvcDocOvrlBillgBlkStsCritlty,
  cast( '' as abap.char( 40 )) AS ServiceDocOvrlBillingStsName,
  cast( '' as abap.char( 1 )) AS ServiceDocOvrlBillgBlkSts,
  cast(3 as abap.int4) AS ServiceDocOvrlBillingStsCritl,
  cast( '' as abap.char( 1 )) AS ServiceDocOvrlBillingSts,
  cast( '' as crmt_boolean ) AS PriceIsFixed,
  cast(0 as abap.int4) AS NumberOfItems,
  cast(0 as abap.int4) AS NumberOfCompletedItems,
  SalesOrganization,
  DistributionChannel,
  Division,
  SalesOffice,
  SalesGroup,
  SalesOrganizationOrgUnitID,
  SalesOfficeOrgUnitID,
  SalesGroupOrgUnitID,
  ServiceOrganization,
  _ServiceOrder.ServiceDocument AS ServiceOrder,
  _ServiceOrder.ServiceDocumentType AS ServiceDocumentType,
  _ServiceOrder.ServiceObjectType AS ServiceObjectType,
  _ServiceOrder.ServiceDocumentDescription AS ServiceOrderDescription,
  _ServiceOrder.SoldToParty AS SoldToParty,
  _ServiceOrder.ServiceDocumentPriority AS ServiceOrderPriority,
  _ServiceOrder.PostingDate AS PostingDate,
  _ServiceOrder.ServiceDocumentHasError AS ServiceDocumentHasError,
  _ServiceOrder.ServiceDocGrossAmount AS ServiceDocGrossAmount,
  _ServiceOrder.ServiceDocNetAmount AS ServiceDocNetAmount,
  _ServiceOrder.TransactionCurrency AS TransactionCurrency,
  _ServiceOrder.ServiceDocumentStatus AS ServiceOrderStatus,
  _ServiceOrder.BusinessActivityCategory AS BusinessActivityCategory,
  _ServiceOrder.ResponsibleEmployee AS ResponsibleEmployee,
  _ServiceOrder.ServiceTeam AS ServiceTeam,
  _ServiceOrder.SoldToPartyCountry AS SoldToPartyCountry,
  _ServiceOrder.SoldToPartyRegion AS SoldToPartyRegion,
  _ServiceOrder.PurchaseOrderByCustomer AS PurchaseOrderByCustomer,
  _ServiceOrder.ServiceEmployee AS ServiceEmployee,
  _ServiceOrder.ContactPerson AS ContactPerson,
  _ServiceOrder.ServiceDocumentUUID AS ServiceDocumentUUID,
  _CustMgmtExtRef.CustMgmtExtRefID AS CustMgmtExtRefID,
  _ServiceDocRefObj.Equipment AS Equipment,
  _ServiceDocRefObj.FunctionalLocation AS FunctionalLocation,
  _ServiceDocRefObj.ProductID AS ProductID,
  _ServiceDocumentNotes.ServiceDocNoteText AS ServiceOrderNoteText,
  _SoldToParty.BusinessPartnerName AS BusinessPartnerName,
  _SoldToParty.FirstName AS FirstName,
  _SoldToParty.LastName AS LastName,
  _SoldToParty.GroupBusinessPartnerName1 AS GroupBusinessPartnerName1,
  _SoldToParty.GroupBusinessPartnerName2 AS GroupBusinessPartnerName2,
  _SoldToParty.OrganizationBPName1 AS OrganizationBPName1,
  _SoldToParty.OrganizationBPName2 AS OrganizationBPName2
FROM I_ServiceDocumentEnhcd AS _ServiceOrder
LEFT OUTER JOIN C_ServiceDocumentSoldToPartyVH AS _SoldToParty ON SoldToParty = _SoldToParty.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN C_SrvcDocBusinessPartnerVH AS _ServiceTeam ON ServiceTeam = _ServiceTeam.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN C_SrvcDocBusinessPartnerVH AS _RespEmployee ON ResponsibleEmployee = _RespEmployee.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN C_SrvOrderItemListRptAndObjPg AS _SrvOrderItemListRptAndObjPg ON ServiceOrder = _SrvOrderItemListRptAndObjPg.ServiceDocument  -- association [1..*]
LEFT OUTER JOIN C_ServiceDocObjPgNotes AS _ServiceDocumentNotes ON ServiceObjectType = _ServiceDocumentNotes.ServiceObjectType AND ServiceOrder = _ServiceDocumentNotes.ServiceDocument  -- association [1..*]
LEFT OUTER JOIN C_SrvcDocObjPgTransHistory AS _ServiceDocumentTransHistory ON ServiceObjectType = _ServiceDocumentTransHistory.ServiceObjectType AND ServiceOrder = _ServiceDocumentTransHistory.ServiceDocument  -- association [1..*]
LEFT OUTER JOIN C_ServiceDocObjPgErrorLog AS _ServiceDocumentErrorLog ON ServiceObjectType = _ServiceDocumentErrorLog.ServiceObjectType AND ServiceOrder = _ServiceDocumentErrorLog.ServiceDocument  -- association [1..*]
LEFT OUTER JOIN E_ServiceDocument AS _ServiceDocumentExt ON ServiceObjectType = _ServiceDocumentExt.ServiceCategory  -- association [0..1]
LEFT OUTER JOIN C_ServiceOrderProductVH AS _ConfirmationItem ON ServiceOrder = _ConfirmationItem.ServiceDocument  -- association [1..*]
LEFT OUTER JOIN C_SrvcDocProductVH AS _Product ON ReferenceProduct = _Product.Product  -- association [1..*]
LEFT OUTER JOIN C_SrvcDocItemUnitOfMeasureVH AS _Unit ON ReferenceProduct = _Unit.Product  -- association [1..*]
LEFT OUTER JOIN C_ServiceDocumentPartner AS _PartiesInvolved ON ServiceObjectType = _PartiesInvolved.CustMgmtObjectType AND ServiceOrder = _PartiesInvolved.CustMgmtDocument AND _PartiesInvolved.CustMgmtDocumentItem = '000000'  -- association [0..*]
LEFT OUTER JOIN C_SrvcOrderObjPgPricingDets AS _ServiceOrderPriceDets ON ServiceObjectType = _ServiceOrderPriceDets.ServiceObjectType AND ServiceOrder = _ServiceOrderPriceDets.ServiceDocument  -- association [1..*]
LEFT OUTER JOIN C_SrvcOrderSoldToPartyVH AS _ServiceOrderSoldToParty ON SoldToParty = _ServiceOrderSoldToParty.BusinessPartner  -- association [1..*]
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 C_SrvcDocDateInformation AS _SrvcDateInfo ON ( ServiceOrder = _SrvcDateInfo.ServiceDocument AND ServiceObjectType = _SrvcDateInfo.ServiceObjectType AND _SrvcDateInfo.ServiceDocumentItem = '000000' ) OR ( ServiceDocumentUUID = _SrvcDateInfo.SrvcMgmtObjectUUID )  -- association [1..*]
;