What is I_BillgItmPrcgElForCoTypC in SAP S/4HANA?

I_BillgItmPrcgElForCoTypC is a composite CDS view in SAP S/4HANA. Billing Document Item Pricing Element - Cube It contains 66 fields.

Which tables does I_BillgItmPrcgElForCoTypC read from?

I_BillgItmPrcgElForCoTypC reads data from: I_BillgItmPrcgElForCoTypAn.

What VDM layer is I_BillgItmPrcgElForCoTypC?

I_BillgItmPrcgElForCoTypC is classified as a Composite view that combines data from multiple basic views.

I_BillgItmPrcgElForCoTypC

DDL: I_BILLGITMPRCGELFORCOTYPC SQL: ISDBDIPEFCOTYC Type: view COMPOSITE Package: VDM_SD_ANALYTICS

66 Fields 1 Data Sources

Billing Document Item Pricing Element - Cube

I_BillgItmPrcgElForCoTypC (Composite)

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

Sales

I_BillgItmPrcgElForCoTypC is a Composite CDS View (Cube) that provides data about "Billing Document Item Pricing Element - Cube" in SAP S/4HANA. It reads from 1 data source (I_BillgItmPrcgElForCoTypAn) and exposes 66 fields with key fields BillingDocument, BillingDocumentItem, PricingProcedureStep, PricingProcedureCounter. Part of development package VDM_SD_ANALYTICS.

SAP Help Documentation

Category	Billing Document
Data Category	Cube
Corresponding DataSource	2CISDBDIPEFCOTYC

Purpose
This CDS view provides the prerequisites for answering the following business questions: How is a specific condition type distributed over my sales organizations in a specific quarter? Which pricing elements or condition types influence my sales volume by either lowering or increasing it? Is the current pricing strategy adequate? Are the current discount conditions adequate? Which elements, for example, discounts or price, affect my net price? Note For currency conversion, the exchange rate is determined by the exchange rate type and the creation date of the sales order item. However, to avoid potential performance issues caused by the currency conversion, we recommend that you exclude the measures in display currency when querying this cube. Alternatively, you can create a query based on this cube and then define your own measures in the display currency from the corresponding ones in the transaction currency. You do this by using the Custom Analytical Queries app. Note Make sure that you use the cubes for analytical purposes only.

Prerequisites
Authorizations Users who want to use this CDS view must have the following authorization objects assigned: V_VBRK_FKA ( Billing: Authorization for Billing Types ) V_VBRK_VKO ( Billing: Authorization for Sales Organizations )

Structure
Parameters The main parameters are as follows: P_ExchangeRateType : This parameter is used to specify the exchange rate type for currency conversion The default value is M (average rate). P_DisplayCurrency : This parameter is used to specify the target currency for currency conversion. P_StartOfQuarter : This parameter is used to specify the first day of the three month period for the billing document date Further Important Fields Important fields in this view include the following: Important Fields Field Name Description Measure or Attribute ConditionType Condition Type Attribute SalesOrganization Sales Organization Attribute Product Product (that is, material) Attribute ProductGroup Product Group (that is, material group) Attribute Division Division Attribute BillingDocument Billing Document Attribute BillingDocumentDate Billing Date Attribute ConditionBaseQuantity Condition Base Quantity Measure ConditionAmountInDC Condition Value Measure NormalizedConditionAmountInDC Normalized Condition Value Measure

View on SAP Help Portal →

SAP API Hub

Category	Composite
State	C1
Line of Business	Sales
Application Component	SD-ANA-2CL
Capabilities	Data Provider for Analytical Queries,Data Source for Defining CDS Entities
Extensible (Key User)	No
Extensible (Developer)	No
Release State (Key User)	Released
Release State (Developer)	Released
Package	Sales for SAP S/4HANA Cloud Public Edition
Description	This CDS view provides the prerequisites for answering the following business questions:<ul> <li> <p>How is a specific condition type distributed over my sales organizations in a specific quarter?</p> </li> <li> <p>Which pricing elements or condition types influence my sales volume by either lowering or increasing it? </p> </li> <li> <p>Is the current pricing strategy adequate? </p> </li> <li> <p>Are the current discount conditions adequate? </p> </li> <li> <p>Which elements, for example, discounts or price, affect my net price? </p> </li> </ul>

Documentation

Analytics with CDS Views — Build Analytics for S/4HANA Cloud Public Edition ABAP CDS views replicated to SAP Cloud Platform
CDS Views on SAP Business Accelerator Hub — Explore SAP S/4HANA Cloud Public Edition CDS Views on SAP Business Accelerator Hub
Create CDS View as API — Create CDS views in SAP S/4HANA Cloud Public Edition and consume them as APIs
Custom CDS Views — Access data using a Custom Core Data Service view (Custom CDS view)
Custom Communication Scenarios — Create custom communication scenarios to configure custom communication arrangement
Key User Extensibility Tools — The Key User Extensibility Tools of S/4HANA
SAP S/4HANA Extensibility — SAP S/4HANA Extensibility Tutorial
VDM View Types — The Virtual Data Model in SAP S/4HANA Cloud Public Edition
View Browser — Search, browse and tag CDS Views

Data Sources (1)

Source	Alias	Join Type
I_BillgItmPrcgElForCoTypAn	I_BillgItmPrcgElForCoTypAn	from

Parameters (4)

Name	Type	Default
P_ExchangeRateType	kurst
P_DisplayCurrency	vdm_v_display_currency
P_ConditionType	conditiontype
P_BillingDocumentDate	startofquarter

Annotations (16)

Name	Value	Level
ClientHandling.algorithm	#SESSION_VARIABLE	view
ObjectModel.usageType.dataClass	#MIXED	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.usageType.sizeCategory	#XL	view
VDM.viewType	#COMPOSITE	view
Analytics.dataCategory	#CUBE	view
EndUserText.label	Billing Document Item Pricing Element - Cube	view
AbapCatalog.sqlViewName	ISDBDIPEFCOTYC	view
AbapCatalog.preserveKey	true	view
AbapCatalog.compiler.compareFilter	true	view
AccessControl.authorizationCheck	#CHECK	view
AccessControl.personalData.blocking	#NOT_REQUIRED	view
Metadata.allowExtensions	true	view
Metadata.ignorePropagatedAnnotations	true	view
Analytics.internalName	#LOCAL	view
ObjectModel.modelingPattern	#ANALYTICAL_CUBE	view

Fields (66)

Key	Field	Source Field	Description
KEY	BillingDocument	BillingDocument	Billing Document
KEY	BillingDocumentItem	BillingDocumentItem	Billing Document Item
KEY	PricingProcedureStep	PricingProcedureStep	Step Number
KEY	PricingProcedureCounter	PricingProcedureCounter	Pricing Procedure Counter
	ConditionApplication	ConditionApplication	Application
	ConditionType	ConditionType	Condition type
	ConditionCategory	ConditionCategory	Condition Category (Examples: Tax, Freight, Price, Cost)
	ConditionClass	ConditionClass	Condition Class
	ConditionIsForStatistics	ConditionIsForStatistics	Condition is used for statistics
	ConditionControl	ConditionControl	Condition Control
	ConditionInactiveReason	ConditionInactiveReason	Condition is Inactive
	ReturnItemProcessingType	ReturnItemProcessingType	Processing Type of Return Item
	SalesDocumentItemCategory	SalesDocumentItemCategory	Sales Document Item Category
	SalesDocumentItemType	SalesDocumentItemType	Sales Document Item Type
	BillingDocumentCategory	BillingDocumentCategory	Billing Category
	SDDocumentCategory	SDDocumentCategory	SD Document Category
	BillingDocumentType	BillingDocumentType	Billing Type
	PricingDateTime	PricingDateTime	Timestamp for Pricing
	BillingDocumentDate	BillingDocumentDate	Billing Date
	BillingDocumentDateYear		Year of Billing
	BillingDocDateYearQuarter		Quarter/Year of Billing
	BillingDocDateYearMonth		Month/Year of Billing
	SalesOrganization	SalesOrganization	Sales Organization
	DistributionChannel	DistributionChannel	Distribution Channel
	OrganizationDivision	OrganizationDivision	Organization Division
	Division	Division	Internal Division ID
	SalesOffice	SalesOffice	Sales Office
	TradingPartnerasPartnerCompany
	_GlobalCompany
	Product	Product	Product Sold
	ProductGroup	ProductGroup	Product Sold Group
	ConditionRecord	ConditionRecord	Number of Condition Record
	ConditionSequentialNumber	ConditionSequentialNumber	Sequential Number of the Condition
	ConditionOrigin	ConditionOrigin	Origin of the Condition
	ConditionIsManuallyChanged	ConditionIsManuallyChanged	Condition Changed Manually
	ConditionQuantityUnit	ConditionQuantityUnit	Condition Unit in the Document
	ConditionCalculationType	ConditionCalculationType	Calculation Type for Condition
	ConditionAmount		Condition Value in Transactional Currency
	trueascond_amt_idcasConditionAmountInDC
	NormalizedConditionAmount	NormalizedConditionAmount	Normalized Condition Value in Transactional Currency
	TransactionCurrency	TransactionCurrency	Transaction Currency
	DisplayCurrency		Display Currency
	ConditionBaseQuantity	ConditionBaseQuantity	Quantity of the Condition Basis
	_BillingDocument	_BillingDocument
	_BillingDocumentCategory	_BillingDocumentCategory
	_SDDocumentCategory	_SDDocumentCategory
	_BillingDocumentType	_BillingDocumentType
	_SalesDocumentItemCategory	_SalesDocumentItemCategory
	_SalesDocumentItemType	_SalesDocumentItemType
	_SalesOrganization	_SalesOrganization
	_DistributionChannel	_DistributionChannel
	_OrganizationDivision	_OrganizationDivision
	_Division	_Division
	_SalesOffice	_SalesOffice
	_Product	_Product
	_ProductGroup	_ProductGroup
	_ConditionApplication	_ConditionApplication
	_PricingConditionType	_PricingConditionType
	_ConditionCategory	_ConditionCategory
	_ConditionClass	_ConditionClass
	_ConditionControl	_ConditionControl
	_ConditionInactiveReason	_ConditionInactiveReason
	_ConditionOrigin	_ConditionOrigin
	_ConditionCalculationType	_ConditionCalculationType
	_ConditionQuantityUnit	_ConditionQuantityUnit
	_Currency	_Currency

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_BillgItmPrcgElForCoTypC.
-- 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: ISDBDIPEFCOTYC
-- Parameters: P_ExchangeRateType : kurst, P_DisplayCurrency : vdm_v_display_currency, P_ConditionType : conditiontype, P_BillingDocumentDate : startofquarter

CREATE VIEW I_BillgItmPrcgElForCoTypC AS
SELECT
  BillingDocument,
  BillingDocumentItem,
  PricingProcedureStep,
  PricingProcedureCounter,
  ConditionApplication,
  ConditionType,
  ConditionCategory,
  ConditionClass,
  ConditionIsForStatistics,
  ConditionControl,
  ConditionInactiveReason,
  ReturnItemProcessingType,
  SalesDocumentItemCategory,
  SalesDocumentItemType,
  BillingDocumentCategory,
  SDDocumentCategory,
  BillingDocumentType,
  PricingDateTime,
  BillingDocumentDate,
  cast(BillgDocCalDate.CalendarYear as billing_document_date_year) AS BillingDocumentDateYear,
  cast(BillgDocCalDate.YearQuarter as billing_doc_date_year_quarter) AS BillingDocDateYearQuarter,
  cast(BillgDocCalDate.YearMonth as billing_doc_date_year_month) AS BillingDocDateYearMonth,
  SalesOrganization,
  DistributionChannel,
  OrganizationDivision,
  Division,
  SalesOffice,
  _BillingDocument._SoldToParty._GlobalCompany AS _GlobalCompany,
  Product,
  ProductGroup,
  ConditionRecord,
  ConditionSequentialNumber,
  ConditionOrigin,
  ConditionIsManuallyChanged,
  ConditionQuantityUnit,
  ConditionCalculationType,
  cast ( currency_conversion( amount => ConditionAmount, source_currency => TransactionCurrency, target_currency => :P_DisplayCurrency, exchange_rate_date => BillingDocumentDate, exchange_rate_type => :P_ExchangeRateType, error_handling => 'FAIL_ON_ERROR', round => #CDSBoolean.true, decimal_shift => #CDSBoolean.true, decimal_shift_back => #CDSBoolean.true ) as cond_amt_idc) as ConditionAmountInDC AS trueascond_amt_idcasConditionAmountInDC,
  NormalizedConditionAmount,
  TransactionCurrency,
  cast(:P_DisplayCurrency as vdm_v_display_currency) AS DisplayCurrency,
  ConditionBaseQuantity
FROM I_BillgItmPrcgElForCoTypAn
;

Depth:

I_BillgItmPrcgElForCoTypC view

I_BillgItmPrcgElForCoTypAn view

C_BillgItmPrcgElForCoTypQ view