C_SolnOrderProfitabilityQ

DDL: C_SOLNORDERPROFITABILITYQ SQL: CSOLNORDERPROF Type: view CONSUMPTION Package: FINS_COPA_REPORTING
45 Fields 1 Data Sources

Solution Business Profitability - Query

C_SolnOrderProfitabilityQ is a Consumption CDS View that provides data about "Solution Business Profitability - Query" in SAP S/4HANA. It reads from 1 data source (I_SolnOrderProfitabilityCube) and exposes 45 fields with key fields GLAccountHierarchy, Ledger, CompanyCode, AccountingDocument, LedgerGLLineItem. Part of development package FINS_COPA_REPORTING.

Data Sources (1)

SourceAliasJoin Type
I_SolnOrderProfitabilityCube I_SolnOrderProfitabilityCube from

Annotations (19)

NameValueLevelField
AbapCatalog.sqlViewName CSOLNORDERPROF view
Analytics.query true view
OData.publish true view
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
EndUserText.label Solution Business Profitability - Query view
Metadata.allowExtensions true view
AbapCatalog.preserveKey true view
ObjectModel.representativeKey LedgerGLLineItem view
Analytics.settings.maxProcessingEffort #HIGH view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.buffering.status #NOT_ALLOWED view
Metadata.ignorePropagatedAnnotations true view
AbapCatalog.compiler.compareFilter true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
UI.headerInfo.typeName Solution Business Profitability view
UI.headerInfo.typeNamePlural Solution Business Profitability view

Fields (45)

KeyFieldSource TableSource FieldDescription
KEY GLAccountHierarchy GLAccountHierarchy
KEY Ledger Ledger Ledger
KEY CompanyCode CompanyCode Receiver Company Code
KEY AccountingDocument AccountingDocument Journal Entry
KEY LedgerGLLineItem LedgerGLLineItem Journal Entry Item
KEY SourceLedger SourceLedger Source Ledger
KEY SemanticTag SemanticTag Semantic Tag
KEY FiscalYear FiscalYear G/L Fiscal Year
CompanyCodeCurrency CompanyCodeCurrency Local Currency
SoldProductGroup SoldProductGroup Product Sold Group
CustomerGroup CustomerGroup Customer Group
BusinessSolutionOrder BusinessSolutionOrder Solution Order
BusinessSolutionOrderItem BusinessSolutionOrderItem Solution Order Item
ProfitCenter ProfitCenter Profit Center
FiscalYearPeriod FiscalYearPeriod Period/Year
FiscalPeriod FiscalPeriod Tax period
ProjectExternalID ProjectExternalID Project def.
SoldProduct SoldProduct Product Sold
Customer Customer Sold-to Party
AccountAssignmentType AccountAssignmentType Sndr AcctAssgmt Type
Plant Plant Valuation Area
LedgerFiscalYear LedgerFiscalYear
ControllingArea ControllingArea Controlling Area
SalesOrganization SalesOrganization Sales Organization
DistributionChannel DistributionChannel RefDistCh-Cust/Mat.
OrganizationDivision OrganizationDivision Org. Division
SalesDistrict SalesDistrict Sales District
GLAccount GLAccount General Ledger
ChartOfAccounts ChartOfAccounts Node Class
BilledRevenueAmtInCoCodeCrcy BilledRevenueAmtInCoCodeCrcy
RecognizableCostAmtInCCCrcy RecognizableCostAmtInCCCrcy
RecognizedRevnAmtInCCCrcy RecognizedRevnAmtInCCCrcy
RecognizedCOGSAmtInCCCrcy RecognizedCOGSAmtInCCCrcy
RecognizedMarginAmtInCCCrcy RecognizedMarginAmtInCCCrcy
MarginInPct
UnitOfMeasure
BaseUnit BaseUnit Unit of Measure
Quantity Quantity Value
_Hierarchy _Hierarchy
_Ledger _Ledger
_CompanyCode _CompanyCode
_JournalEntry _JournalEntry
_SourceLedger _SourceLedger
_SemanticTag _SemanticTag
_FiscalYear _FiscalYear

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_SolnOrderProfitabilityQ.
-- 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: CSOLNORDERPROF

CREATE VIEW C_SolnOrderProfitabilityQ AS
SELECT
  GLAccountHierarchy,
  Ledger,
  CompanyCode,
  AccountingDocument,
  LedgerGLLineItem,
  SourceLedger,
  SemanticTag,
  FiscalYear,
  CompanyCodeCurrency,
  SoldProductGroup,
  CustomerGroup,
  BusinessSolutionOrder,
  BusinessSolutionOrderItem,
  ProfitCenter,
  FiscalYearPeriod,
  FiscalPeriod,
  ProjectExternalID,
  SoldProduct,
  Customer,
  AccountAssignmentType,
  Plant,
  LedgerFiscalYear,
  ControllingArea,
  SalesOrganization,
  DistributionChannel,
  OrganizationDivision,
  SalesDistrict,
  GLAccount,
  ChartOfAccounts,
  BilledRevenueAmtInCoCodeCrcy,
  RecognizableCostAmtInCCCrcy,
  RecognizedRevnAmtInCCCrcy,
  RecognizedCOGSAmtInCCCrcy,
  RecognizedMarginAmtInCCCrcy,
  cast ( 0 as fins_trr_margininpct ) AS MarginInPct,
  cast('%' as msehi) AS UnitOfMeasure,
  BaseUnit,
  Quantity
FROM I_SolnOrderProfitabilityCube
;

Learn More