C_BusSolnOrdListRptAndObjPg

DDL: C_BUSSOLNORDLISTRPTANDOBJPG Type: view_entity CONSUMPTION Package: CRMS4_SOLUTIONORDER_FIORI_UI
77 Fields 1 Data Sources 6 Associations 1 OData Services

Projection: Solution Order

C_BusSolnOrdListRptAndObjPg is a Consumption CDS View that provides data about "Projection: Solution Order" in SAP S/4HANA. It reads from 1 data source (R_BusinessSolutionOrderTP) and exposes 77 fields with key field BusinessSolutionOrder. It has 6 associations to related views. It is exposed through 1 OData service (C_BUSSOLUTIONORDER_SRV). Part of development package CRMS4_SOLUTIONORDER_FIORI_UI.

Data Sources (1)

SourceAliasJoin Type
R_BusinessSolutionOrderTP R_BusinessSolutionOrderTP projection

Associations (6)

CardinalityTargetAliasCondition
[0..*] C_BusSolnOrdItemHierNode _BusSolnOrdItemHierarchy $projection.BusinessSolutionOrder = _BusSolnOrdItemHierarchy.BusinessSolutionOrder
[0..1] C_SrvcMgmtSoldToPartyQuickVw _SrvcMgmtSoldToPartyQuickVw $projection.SoldToParty = _SrvcMgmtSoldToPartyQuickVw.BusinessPartner
[0..1] C_SrvcMgmtRespEmplQuickVw _SrvcMgmtRespEmplQuickVw $projection.RespEmployeeBusinessPartnerId = _SrvcMgmtRespEmplQuickVw.BusinessPartner
[0..1] C_SrvcMgmtCntctPersnQuickVw _SrvcMgmtCntctPersnQuickVw $projection.ContactPersonBusinessPartnerId = _SrvcMgmtCntctPersnQuickVw.BusinessPartner and $projection.SoldToParty = _SrvcMgmtCntctPersnQuickVw.SoldToParty
[0..*] C_SrvcDocUserStatus _SrvcDocUserStatus $projection.BusinessSolutionOrderUUID = _SrvcDocUserStatus.StatusObjectUUID
[0..1] I_CustMgmtLifecycleUserStsText _CustMgmtLifecycleUserStsText $projection.BusSolnOrdStatus = _CustMgmtLifecycleUserStsText.CustMgmtLifecycleUserStatus and _CustMgmtLifecycleUserStsText.Language = $session.system_language

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
ObjectModel.representativeKey BusinessSolutionOrder view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
Metadata.allowExtensions true view
VDM.viewType #CONSUMPTION view
Search.searchable true view
EndUserText.label Projection: Solution Order view
Consumption.semanticObject BusinessSolutionOrder view

OData Services (1)

ServiceBindingVersionContractRelease
C_BUSSOLUTIONORDER_SRV C_BUSSOLUTIONORDER V2 C1 NOT_RELEASED

Fields (77)

KeyFieldSource TableSource FieldDescription
KEY BusinessSolutionOrder BusinessSolutionOrder Solution Order
ServiceObjectType ServiceObjectType Object Type
BusinessSolutionOrderUUID BusinessSolutionOrderUUID Object GUID
ServiceDocumentCharUUID ServiceDocumentCharUUID
BusSolnOrdDescription BusSolnOrdDescription
BusSolnOrdType BusSolnOrdType Transaction Type
ServiceDocumentPriority _ServiceDocumentEnhcd ServiceDocumentPriority
RespEmployeeBusinessPartnerId RespEmployeeBusinessPartnerId Employee Resp.
RespEmployeeAtPartnerName _RespEmployee BusinessPartnerFullName Broker Name
SoldToParty SoldToParty Sold-to Party
SoldToPartyName _SoldToParty BusinessPartnerFullName Broker Name
FirstName _SoldToParty FirstName First Name
LastName _SoldToParty LastName Last Name
OrganizationBPName1 _SoldToParty OrganizationBPName1 Name 1
OrganizationBPName2 _SoldToParty OrganizationBPName2 Name 2
ContactPersonBusinessPartnerId ContactPersonBusinessPartnerId Contact Person Key
CompanyContactPersonFullName _ContactPerson BusinessPartnerFullName Broker Name
TransactionCurrency TransactionCurrency Transaction Currency
BusSolnOrdNetAmount ServiceDocNetAmount
BusSolnOrdGrossAmount _ServiceDocumentEnhcd ServiceDocGrossAmount
BusSolnOrdStatus BusSolnOrdStatus
ServiceDocumentStatusName ServiceDocumentStatusName
BusSolnOrdHasError BusSolnOrdHasError
SalesOrganizationNamelocalized
SalesOfficeNamelocalized
SalesGroupNamelocalized
DistributionChannelNamelocalized
DivisionNamelocalized
CreationDate _ServiceDocumentEnhcd ServiceDocumentCreationDate
PostingDate PostingDate Posting Date for GR
LastChangedDate _ServiceDocumentEnhcd ServiceDocumentChangedDate
ServiceDocumentCreatedByUser ServiceDocumentCreatedByUser
CreatedByUser _ServiceDocCreatedBy BusinessPartnerFullName Broker Name
ServiceDocumentChangedByUser ServiceDocumentChangedByUser
LastChangedByUser _ServiceDocChangedBy BusinessPartnerFullName Broker Name
SalesOrganization SalesOrganization Sales Organization
SalesOffice SalesOffice Sales Office
SalesGroup SalesGroup Sales Group
DistributionChannel DistributionChannel RefDistCh-Cust/Mat.
Division Division Internal Division ID
SalesOfficeOrgUnitID SalesOfficeOrgUnitID
SalesOrganizationOrgUnitID SalesOrganizationOrgUnitID
SalesGroupOrgUnitID SalesGroupOrgUnitID
ServiceOrganization ServiceOrganization
SystemStatus _SolutionOrderStatus SrvcMgmtObjectStatus
StatusProfile _ServiceDocumentType StatusProfile Status Profile
PurchaseOrderByCustomer PurchaseOrderByCustomer Purchase Order Number
virtualProductcrmt_ordered_prod_db
virtualSrvcDocSituationStatusboolean
virtualSituationTextval_text
_BusSolnOrdItemHierarchy _BusSolnOrdItemHierarchy
_SrvcDocBPSoldToParty _SrvcDocBPSoldToParty
_SrvcDocBPContactCard _SrvcDocBPContactCard
_SrvcDocBPRespEmployee _SrvcDocBPRespEmployee
_ServiceDocumentStatus _ServiceDocumentStatus
_SrvcDocLifecycleStatus _SrvcDocLifecycleStatus
_ServiceDocCreatedBy _ServiceDocCreatedBy
_ServiceDocChangedBy _ServiceDocChangedBy
_SoldToParty _SoldToParty
_ServiceDocHasError _ServiceDocHasError
_RespEmployee _RespEmployee
_ContactPerson _ContactPerson
_SalesOfficeOrgUnit_2 _SalesOfficeOrgUnit_2
_SalesOrganizationOrgUnit_2 _SalesOrganizationOrgUnit_2
_SalesGroupOrgUnit_2 _SalesGroupOrgUnit_2
_ServiceOrganizationOrgUnit_2 _ServiceOrganizationOrgUnit_2
_SrvcMgmtSoldToPartyQuickVw _SrvcMgmtSoldToPartyQuickVw
_SrvcMgmtRespEmplQuickVw _SrvcMgmtRespEmplQuickVw
_SrvcMgmtCntctPersnQuickVw _SrvcMgmtCntctPersnQuickVw
_SolutionOrderStatus _SolutionOrderStatus
_SrvcDocUserStatus _SrvcDocUserStatus
_CustMgmtLifecycleUserStsText _CustMgmtLifecycleUserStsText
_SalesOrganizationText _SalesOrganizationText
_SalesOfficeText _SalesOfficeText
_SalesGroupText _SalesGroupText
_DistributionChannelText _DistributionChannelText
_DivisionText _DivisionText

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,
  _SalesOrganizationText.SalesOrganizationName : localized AS SalesOrganizationNamelocalized,
  _SalesOfficeText.SalesOfficeName : localized AS SalesOfficeNamelocalized,
  _SalesGroupText.SalesGroupName : localized AS SalesGroupNamelocalized,
  _DistributionChannelText.DistributionChannelName : localized AS DistributionChannelNamelocalized,
  _DivisionText.DivisionName : localized AS DivisionNamelocalized,
  _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_BusSolnOrdItemHierNode AS _BusSolnOrdItemHierarchy ON BusinessSolutionOrder = _BusSolnOrdItemHierarchy.BusinessSolutionOrder  -- association [0..*]
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]
;

Learn More