I_BSOrdGLAcctLineItemCube

DDL: I_BSORDGLACCTLINEITEMCUBE Type: view COMPOSITE
61 Fields 1 Data Sources 1 Associations

GL Account Item for Soln Order - Cube

I_BSOrdGLAcctLineItemCube (Composite)

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

Sales

I_BSOrdGLAcctLineItemCube is a Composite CDS View (Cube) that provides data about "GL Account Item for Soln Order - Cube" in SAP S/4HANA. It reads from 1 data source (P_BSOrdGLAcctLineItemCube) and exposes 61 fields with key fields ServiceObjectType, BusinessSolutionOrder, BusinessSolutionOrderItem, CompanyCode, FiscalYear. It has 1 association to related views.

SAP Help Documentation

CategorySolution Business Analytics
Data CategoryCube
Purpose
This CDS view provides the data to answer the following business questions: What is the recognized revenue for my incoming solution order volume for a given time period? What is the recognized cost for my incoming solution order volume for a given time period? What is the recognized proft margin for my incoming solution order volume for a given time period? 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. Fields used for filtering Important fields in this view include the following: Field Name Description Measure or Attribute SalesOrganization Sales Organization Attribute CalendarYear Calender Year Attribute CalendarQuarter Calender Quarter Attribute CalendarMonth Calender Month Attribute BusSolnOrdRevnAmtInDC Recognized Revenue Measure BusSolnOrdCostAmtInDC Recognized Cost Measure BusSolnOrdRecgdMargAmtInDC Recognized Margin Measure

View on SAP Help Portal →

SAP API Hub

StateC1
Line of BusinessSales
Application ComponentCRM-S4-ANA-CDS
CapabilitiesData Provider for Analytical Queries, Data Source in SQL Select, Data Source for Defining CDS Entities
PackageSales for SAP S/4HANA Cloud Private Edition

Documentation

Data Sources (1)

SourceAliasJoin Type
P_BSOrdGLAcctLineItemCube P_BSOrdGLAcctLineItemCube from

Parameters (1)

NameTypeDefault
P_DisplayCurrency vdm_v_display_currency

Associations (1)

CardinalityTargetAliasCondition
[1] I_CalendarDate _CalendarPeriod $projection.PostingDate = _CalendarPeriod.CalendarDate

Annotations (17)

NameValueLevelField
EndUserText.label GL Account Item for Soln Order - Cube view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName IBSGLLINITMCUBE 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 (61)

KeyFieldSource TableSource FieldDescription
KEY ServiceObjectType ServiceObjectType Business Trans. Cat.
KEY BusinessSolutionOrder BusinessSolutionOrder Solution Order
KEY BusinessSolutionOrderItem BusinessSolutionOrderItem Shortened Item Number in Document
KEY CompanyCode CompanyCode Receiver Company Code
KEY FiscalYear FiscalYear G/L Fiscal Year
KEY AccountingDocument AccountingDocument Journal Entry
KEY LedgerGLLineItem LedgerGLLineItem General Ledger Journal Entry Line Item
KEY SemanticTag SemanticTag Semantic Tag of a Hierarchy Node
BusSolnOrdType BusSolnOrdType Business Transaction Type
BusSolnOrdDescription BusSolnOrdDescription Solution Order Description
BusSolnOrdItmDescription BusSolnOrdItmDescription Product Description
BusSolnOrdItmStatus BusSolnOrdItmStatus Solution Order Item Status
BusSolnOrdStatus BusSolnOrdStatus Solution Order Status
TransactionCurrency TransactionCurrency Transaction Currency
DisplayCurrency
SalesOrganization SalesOrganization Sales Organization
DistributionChannel DistributionChannel Distribution Channel
Division Division Internal Division ID
SalesOffice SalesOffice Sales Office
SalesGroup SalesGroup Sales Group
SoldToParty SoldToParty Sold-to Party
PostingDate PostingDate Posting Date for GR
CompanyCodeCurrency CompanyCodeCurrency Company Code Currency
RevenueAmountInCompanyCodeCrcy RevenueAmountInCompanyCodeCrcy Revenue Amount in Company Code Currency
CostAmountInCompanyCodeCrcy CostAmountInCompanyCodeCrcy Cost Amount in Company Code Currency
RecognizedMarginAmtInCCCrcy RecognizedMarginAmtInCCCrcy Recognized Margin
SlsItmRevenueAmount SlsItmRevenueAmount Revenue Amount in Company Code Currency
SrvcContrItmRevenueAmount SrvcContrItmRevenueAmount Revenue Amount in Company Code Currency
ExpnItmRevenueAmount ExpnItmRevenueAmount Revenue Amount in Company Code Currency
SbscrBilgItmRevenueAmount SbscrBilgItmRevenueAmount Revenue Amount in Company Code Currency
SrvcPrtItmRevenueAmount SrvcPrtItmRevenueAmount Revenue Amount in Company Code Currency
SrvcItmRevenueAmount SrvcItmRevenueAmount Revenue Amount in Company Code Currency
EntProjItmRevenueAmount EntProjItmRevenueAmount Revenue Amount in Company Code Currency
CalendarYear _CalendarPeriod CalendarYear Calendar Year
CalendarQuarter _CalendarPeriod CalendarQuarter Calendar Quarter
CalendarMonth _CalendarPeriod CalendarMonth Calendar Month
FiscalYearVariant FiscalYearVariant Fiscal Year Variant
FiscalPeriod FiscalPeriod Fiscal Period
FiscalQuarter FiscalQuarter Fiscal Quarter
Product Product Product Sold
_ServiceObjType _ServiceObjType
_CompanyCode _CompanyCode
_FiscalYear _FiscalYear
_JournalEntry _JournalEntry
_SemanticTag _SemanticTag
_ServiceDocumentType _ServiceDocumentType
_ServiceDocItemStatus _ServiceDocItemStatus
_SrvcDocItmLifecycleStatus _SrvcDocItmLifecycleStatus
_ServiceDocumentStatus _ServiceDocumentStatus
_SrvcDocLifecycleStatus _SrvcDocLifecycleStatus
_TransactionCurrency _TransactionCurrency
_SalesOrganization _SalesOrganization
_DistributionChannel _DistributionChannel
_Division _Division
_SalesOffice _SalesOffice
_SalesGroup _SalesGroup
_SoldToParty _SoldToParty
_CalendarYear _CalendarPeriod _CalendarYear
_CalendarQuarter _CalendarPeriod _CalendarQuarter
_CalendarMonth _CalendarPeriod _CalendarMonth
_FiscalYearVariant _FiscalYearVariant

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_BSOrdGLAcctLineItemCube.
-- 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_BSOrdGLAcctLineItemCube AS
SELECT
  ServiceObjectType,
  BusinessSolutionOrder,
  BusinessSolutionOrderItem,
  CompanyCode,
  FiscalYear,
  AccountingDocument,
  LedgerGLLineItem,
  SemanticTag,
  BusSolnOrdType,
  BusSolnOrdDescription,
  BusSolnOrdItmDescription,
  BusSolnOrdItmStatus,
  BusSolnOrdStatus,
  TransactionCurrency,
  $parameters.P_DisplayCurrency AS DisplayCurrency,
  SalesOrganization,
  DistributionChannel,
  Division,
  SalesOffice,
  SalesGroup,
  SoldToParty,
  PostingDate,
  CompanyCodeCurrency,
  RevenueAmountInCompanyCodeCrcy,
  CostAmountInCompanyCodeCrcy,
  RecognizedMarginAmtInCCCrcy,
  SlsItmRevenueAmount,
  SrvcContrItmRevenueAmount,
  ExpnItmRevenueAmount,
  SbscrBilgItmRevenueAmount,
  SrvcPrtItmRevenueAmount,
  SrvcItmRevenueAmount,
  EntProjItmRevenueAmount,
  _CalendarPeriod.CalendarYear AS CalendarYear,
  _CalendarPeriod.CalendarQuarter AS CalendarQuarter,
  _CalendarPeriod.CalendarMonth AS CalendarMonth,
  FiscalYearVariant,
  FiscalPeriod,
  FiscalQuarter,
  Product,
  _CalendarPeriod._CalendarYear AS _CalendarYear,
  _CalendarPeriod._CalendarQuarter AS _CalendarQuarter,
  _CalendarPeriod._CalendarMonth AS _CalendarMonth
FROM P_BSOrdGLAcctLineItemCube
LEFT OUTER JOIN I_CalendarDate AS _CalendarPeriod ON PostingDate = _CalendarPeriod.CalendarDate  -- association [1]
;

Learn More