I_BusSolnOrdItmFinancialCube

DDL: I_BUSSOLNORDITMFINANCIALCUBE Type: view COMPOSITE Package: CRMS4_ANALYTICS_SOLUTION_ORDER
54 Fields 1 Data Sources 1 Associations

Solution Order Item Financials - Cube

I_BusSolnOrdItmFinancialCube (Composite)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Public Edition with built-in and side-by-side extension capabilities.

Sales

I_BusSolnOrdItmFinancialCube is a Composite CDS View (Cube) that provides data about "Solution Order Item Financials - Cube" in SAP S/4HANA. It reads from 1 data source (P_BusSolnOrdItmFinData) and exposes 54 fields with key fields ServiceObjectType, BusinessSolutionOrder, BusinessSolutionOrderItem. It has 1 association to related views. Part of development package CRMS4_ANALYTICS_SOLUTION_ORDER.

SAP Help Documentation

CategorySolution Business Analytics
Data CategoryCube
Purpose
This CDS view provides the data to answer the following business questions: What is my solution order volume for a given time period? What is my solution order volume by sales organization? How many solution orders do I have in a specific lifecycle status, for example, how many are in released status? What is my revenue, cost, and profit margin for a specific product/products? What is my net value of solution orders by item category over a period of time? To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views .

Prerequisites
Authorizations One of the following business catalogs needs to be assigned to a user to be able to use this CDS view: Solution - Solution Order Analytics ( SAP_S4CRM_BC_SOLN_ORD_ANA_PC )

Structure
Parameters The parameters of the CDS view are as follows: P_DisplayCurrency used to specify the target currency for currency conversion. Further important fields Important fields in this view include the following: Field Name Description Measure or Attribute SalesOrganization Sales Organization Attribute BusinessSolutionOrder Solution Order Attribute BusinessSolutionOrderItem Solution Order Item Attribute SoldToParty Sold-To Party Attribute BusSolnOrdOpgMarginRatio Margin in Percent Measure TotBusSolnOrdItmNetAmtPerPerd Net Value of Solution Orders Measure NrOfReldBusSolnOrders No. of Released Solution Orders Measure BusSolnOrdCostAmtInDC Recognized Cost Measure

View on SAP Help Portal →

SAP API Hub

CategoryComposite
StateC1
Line of BusinessSales
Application ComponentCRM-S4-ANA-CDS-2CL
CapabilitiesData Provider for Analytical Queries,Data Source in SQL Select,Data Source for Defining CDS Entities
Extensible (Key User)No
Extensible (Developer)No
Release State (Key User)Released
Release State (Developer)Released
PackageSales for SAP S/4HANA Cloud Public Edition
Description <p></p> This CDS view provides the data to answer the following business questions:<ul> <li> <p>What is my solution order volume for a given time period?</p> </li> <li> <p>What is my solution order volume by sales organization?</p> </li> <li> <p>How many solution orders do I have in a specific lifecycle status, for example, how many are in released status?</p> </li> <li> <p>What is my revenue, cost, and profit margin for a specific product/products?</p> </li> <li> <p>What is my net value of solution orders by item category over a period of time?</p> </li> </ul> <p>To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views.</p>

Documentation

Data Sources (1)

SourceAliasJoin Type
P_BusSolnOrdItmFinData P_BusSolnOrdItmFinData from

Parameters (1)

NameTypeDefault
P_DisplayCurrency vdm_v_display_currency

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_CalendarDate _Period $projection.ServiceDocItemCreationDate = _Period.CalendarDate

Annotations (17)

NameValueLevelField
EndUserText.label Solution Order Item Financials - Cube view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName IBSOLNITNFINCUBE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
Analytics.dataCategory #CUBE view
Analytics.internalName #LOCAL view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.modelingPattern #ANALYTICAL_CUBE view
Aggregation.allowPrecisionLoss true view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view

Fields (54)

KeyFieldSource TableSource FieldDescription
KEY ServiceObjectType ServiceObjectType Business Trans. Cat.
KEY BusinessSolutionOrder BusinessSolutionOrder Solution Order
KEY BusinessSolutionOrderItem BusinessSolutionOrderItem Shortened Item Number in Document
BusSolnOrdType BusSolnOrdType Business Transaction Type
BusSolnOrdDescription BusSolnOrdDescription Transaction Description
BusSolnOrdItmDescription BusSolnOrdItmDescription Product Description
DistributionChannel DistributionChannel Distribution Channel
Division Division Internal Division ID
SalesOrganization SalesOrganization Sales Organization
SalesOffice SalesOffice Sales Office
SalesGroup SalesGroup Sales Group
SoldToParty SoldToParty Sold-to Party
Country Country Venue: Ctry/Reg
Region Region Region (State, Province, County)
BusSolnOrdItmStatus BusSolnOrdItmStatus Item Life Cycle Status
DisplayCurrency
TransactionCurrency TransactionCurrency Transaction Currency
TotBusSolnOrdItmNetAmtPerPerd TotBusSolnOrdItmNetAmtPerPerd Net Value
ServiceDocumentItemObjectType ServiceDocumentItemObjectType CRM Item Object Type
CompanyCodeCurrency CompanyCodeCurrency Company Code Currency
RevenueAmountInCompanyCodeCrcy RevenueAmountInCompanyCodeCrcy
CostAmountInCompanyCodeCrcy CostAmountInCompanyCodeCrcy
RecognizedMarginAmtInCCCrcy RecognizedMarginAmtInCCCrcy
BusSolnOrdStatus BusSolnOrdStatus Solution Order Status
ServiceDocItemCategory ServiceDocItemCategory Item Category
Product Product Product Sold
ProductGroup _Product ProductGroup Product Sold Group
PostingDate PostingDate Posting Date for a Business Transaction
NrOfOpenBusSolnOrders NrOfOpenBusSolnOrders
NrOfReldBusSolnOrders NrOfReldBusSolnOrders
NrOfCmpltdBusSolnOrders NrOfCmpltdBusSolnOrders
BusSolnOrdCreationQuarter _Period CalendarQuarter Calendar Quarter
BusSolnOrdCreationMonth _Period CalendarMonth Calendar Month
BusSolnOrdCreationYear _Period CalendarYear Calendar Year
ServiceDocItemCreationDate ServiceDocItemCreationDate Created On
ServiceDocumentCreationDate ServiceDocumentCreationDate Created On
_Period _Period
_ServiceObjType _ServiceObjType
_ServiceDocumentType _ServiceDocumentType
_DistributionChannel _DistributionChannel
_Division _Division
_SalesOrganization _SalesOrganization
_SalesOffice _SalesOffice
_SalesGroup _SalesGroup
_SoldToParty _SoldToParty
_SoldToPartyCountry _SoldToPartyCountry
_SoldToPartyRegion _SoldToPartyRegion
_ServiceDocItemStatus _ServiceDocItemStatus
_SrvcDocItmLifecycleStatus _SrvcDocItmLifecycleStatus
_TransactionCurrency _TransactionCurrency
_ServiceDocumentStatus _ServiceDocumentStatus
_SrvcDocLifecycleStatus _SrvcDocLifecycleStatus
_ServiceDocItemCategory _ServiceDocItemCategory
_Product _Product

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 I_BusSolnOrdItmFinancialCube.
-- 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.
-- Parameters: P_DisplayCurrency : vdm_v_display_currency

CREATE VIEW I_BusSolnOrdItmFinancialCube AS
SELECT
  ServiceObjectType,
  BusinessSolutionOrder,
  BusinessSolutionOrderItem,
  BusSolnOrdType,
  BusSolnOrdDescription,
  BusSolnOrdItmDescription,
  DistributionChannel,
  Division,
  SalesOrganization,
  SalesOffice,
  SalesGroup,
  SoldToParty,
  Country,
  Region,
  BusSolnOrdItmStatus,
  $parameters.P_DisplayCurrency AS DisplayCurrency,
  TransactionCurrency,
  TotBusSolnOrdItmNetAmtPerPerd,
  ServiceDocumentItemObjectType,
  CompanyCodeCurrency,
  RevenueAmountInCompanyCodeCrcy,
  CostAmountInCompanyCodeCrcy,
  RecognizedMarginAmtInCCCrcy,
  BusSolnOrdStatus,
  ServiceDocItemCategory,
  Product,
  _Product.ProductGroup AS ProductGroup,
  PostingDate,
  NrOfOpenBusSolnOrders,
  NrOfReldBusSolnOrders,
  NrOfCmpltdBusSolnOrders,
  _Period.CalendarQuarter AS BusSolnOrdCreationQuarter,
  _Period.CalendarMonth AS BusSolnOrdCreationMonth,
  _Period.CalendarYear AS BusSolnOrdCreationYear,
  ServiceDocItemCreationDate,
  ServiceDocumentCreationDate
FROM P_BusSolnOrdItmFinData
LEFT OUTER JOIN I_CalendarDate AS _Period ON ServiceDocItemCreationDate = _Period.CalendarDate  -- association [0..1]
;

Learn More