Deprecated PUBLIC_LOCAL_API
This CDS view is deprecated in S/4HANA. Use C_BSOrdItmNetValueOvwCard instead. View all deprecated CDS views →

C_BusSolnOrdItmFinOvwQ

DDL: C_BUSSOLNORDITMFINOVWQ Type: view CONSUMPTION

Solution Orders Overview

C_BusSolnOrdItmFinOvwQ is a Consumption CDS View that provides data about "Solution Orders Overview" in SAP S/4HANA. It reads from 1 data source (I_BusSolnOrdItmFinOvwCube) and exposes 15 fields with key fields ServiceObjectType, BusinessSolutionOrder, BusinessSolutionOrderItem.

Data Sources (1)

SourceAliasJoin Type
I_BusSolnOrdItmFinOvwCube I_BusSolnOrdItmFinOvwCube from

Parameters (1)

NameTypeDefault
P_DisplayCurrency vdm_v_display_currency

Annotations (17)

NameValueLevelField
EndUserText.label Solution Orders Overview view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
VDM.lifecycle.status #DEPRECATED view
VDM.lifecycle.successor C_BSOrdItmNetValueOvwCard view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
AbapCatalog.sqlViewName CBSORDITMFINOVWQ view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.modelingPattern #ANALYTICAL_QUERY view
Analytics.query true view
Metadata.ignorePropagatedAnnotations true view
OData.publish true view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY ServiceObjectType ServiceObjectType Transaction Category
KEY BusinessSolutionOrder BusinessSolutionOrder Solution Order
KEY BusinessSolutionOrderItem BusinessSolutionOrderItem Solution Order Item
BusSolnOrdDescription BusSolnOrdDescription Solution Order Description
BusSolnOrdItmDescription BusSolnOrdItmDescription Solution Order Item Description
TransactionCurrency TransactionCurrency Transaction Currency
SoldToParty SoldToParty Sold-To Party
SoldToPartyName _SoldToParty BusinessPartnerName Extracted Customer Name
DisplayCurrency DisplayCurrency Display Currency
Product Product Product Sold
SalesOrganization SalesOrganization Sales Organization
DistributionChannel DistributionChannel Distribution Channel
Division Division Division
BusSolnOrdItmStatus BusSolnOrdItmStatus Item Life Cycle Status
_SoldToParty _SoldToParty

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_BusSolnOrdItmFinOvwQ.
-- 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 C_BusSolnOrdItmFinOvwQ AS
SELECT
  ServiceObjectType,
  BusinessSolutionOrder,
  BusinessSolutionOrderItem,
  BusSolnOrdDescription,
  BusSolnOrdItmDescription,
  TransactionCurrency,
  SoldToParty,
  _SoldToParty.BusinessPartnerName AS SoldToPartyName,
  DisplayCurrency,
  Product,
  SalesOrganization,
  DistributionChannel,
  Division,
  BusSolnOrdItmStatus
FROM I_BusSolnOrdItmFinOvwCube
;