C_BusSolnOrdListRptAndObjPg

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_BusSolnOrdListRptAndObjPg.
-- 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_BusSolnOrdListRptAndObjPg AS
SELECT
  BusinessSolutionOrder,
  ServiceObjectType,
  BusinessSolutionOrderUUID,
  ServiceDocumentCharUUID,
  BusSolnOrdDescription,
  BusSolnOrdType,
  _ServiceDocumentEnhcd.ServiceDocumentPriority AS ServiceDocumentPriority,
  RespEmployeeBusinessPartnerId,
  _RespEmployee.BusinessPartnerFullName AS RespEmployeeAtPartnerName,
  SoldToParty,
  _SoldToParty.BusinessPartnerFullName AS SoldToPartyName,
  _SoldToParty.FirstName AS FirstName,
  _SoldToParty.LastName AS LastName,
  _SoldToParty.OrganizationBPName1 AS OrganizationBPName1,
  _SoldToParty.OrganizationBPName2 AS OrganizationBPName2,
  ContactPersonBusinessPartnerId,
  _ContactPerson.BusinessPartnerFullName AS CompanyContactPersonFullName,
  TransactionCurrency,
  ServiceDocNetAmount AS BusSolnOrdNetAmount,
  _ServiceDocumentEnhcd.ServiceDocGrossAmount AS BusSolnOrdGrossAmount,
  BusSolnOrdStatus,
  ServiceDocumentStatusName,
  BusSolnOrdHasError,
  _ServiceDocumentEnhcd.ServiceDocumentCreationDate AS CreationDate,
  PostingDate,
  _ServiceDocumentEnhcd.ServiceDocumentChangedDate AS LastChangedDate,
  ServiceDocumentCreatedByUser,
  _ServiceDocCreatedBy.BusinessPartnerFullName AS CreatedByUser,
  ServiceDocumentChangedByUser,
  _ServiceDocChangedBy.BusinessPartnerFullName AS LastChangedByUser,
  SalesOrganization,
  SalesOffice,
  SalesGroup,
  DistributionChannel,
  Division,
  SalesOfficeOrgUnitID,
  SalesOrganizationOrgUnitID,
  SalesGroupOrgUnitID,
  ServiceOrganization,
  _SolutionOrderStatus.SrvcMgmtObjectStatus AS SystemStatus,
  _ServiceDocumentType.StatusProfile AS StatusProfile,
  PurchaseOrderByCustomer,
  virtual Product : crmt_ordered_prod_db AS virtualProductcrmt_ordered_prod_db,
  virtual SrvcDocSituationStatus : boolean AS virtualSrvcDocSituationStatusboolean,
  virtual SituationText : val_text AS virtualSituationTextval_text
FROM R_BusinessSolutionOrderTP
LEFT OUTER JOIN C_SrvcMgmtSoldToPartyQuickVw AS _SrvcMgmtSoldToPartyQuickVw ON SoldToParty = _SrvcMgmtSoldToPartyQuickVw.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN C_SrvcMgmtRespEmplQuickVw AS _SrvcMgmtRespEmplQuickVw ON RespEmployeeBusinessPartnerId = _SrvcMgmtRespEmplQuickVw.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN C_SrvcMgmtCntctPersnQuickVw AS _SrvcMgmtCntctPersnQuickVw ON ContactPersonBusinessPartnerId = _SrvcMgmtCntctPersnQuickVw.BusinessPartner AND SoldToParty = _SrvcMgmtCntctPersnQuickVw.SoldToParty  -- association [0..1]
LEFT OUTER JOIN C_SrvcDocUserStatus AS _SrvcDocUserStatus ON BusinessSolutionOrderUUID = _SrvcDocUserStatus.StatusObjectUUID  -- association [0..*]
LEFT OUTER JOIN I_CustMgmtLifecycleUserStsText AS _CustMgmtLifecycleUserStsText ON BusSolnOrdStatus = _CustMgmtLifecycleUserStsText.CustMgmtLifecycleUserStatus AND _CustMgmtLifecycleUserStsText.Language = $session.system_language  -- association [0..1]
;