I_BillgItmPrcgElForCoTypC

DDL: I_BILLGITMPRCGELFORCOTYPC SQL: ISDBDIPEFCOTYC Type: view COMPOSITE
66 Fields 1 Data Sources

Billing Document Item Pricing Element - Cube

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.

SAP Help Documentation

CategoryBilling Document
Data CategoryCube
Corresponding DataSource2CISDBDIPEFCOTYC
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 →

Data Sources (1)

SourceAliasJoin Type
I_BillgItmPrcgElForCoTypAn I_BillgItmPrcgElForCoTypAn from

Parameters (4)

NameTypeDefault
P_ExchangeRateType kurst
P_DisplayCurrency vdm_v_display_currency
P_ConditionType conditiontype
P_BillingDocumentDate startofquarter

Annotations (16)

NameValueLevelField
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)

KeyFieldSource TableSource FieldDescription
KEY BillingDocument BillingDocument SD Document
KEY BillingDocumentItem BillingDocumentItem Item
KEY PricingProcedureStep PricingProcedureStep Step Number
KEY PricingProcedureCounter PricingProcedureCounter Pricing Procedure Counter
ConditionApplication ConditionApplication Application
ConditionType ConditionType Condition type
ConditionCategory ConditionCategory Condit.Category
ConditionClass ConditionClass Condition Class
ConditionIsForStatistics ConditionIsForStatistics Statistical
ConditionControl ConditionControl Cond.Control
ConditionInactiveReason ConditionInactiveReason Inactive
ReturnItemProcessingType ReturnItemProcessingType Returns
SalesDocumentItemCategory SalesDocumentItemCategory Item Category
SalesDocumentItemType SalesDocumentItemType
BillingDocumentCategory BillingDocumentCategory BillingCategory
SDDocumentCategory SDDocumentCategory Document Cat.
BillingDocumentType BillingDocumentType Billing Type
PricingDateTime PricingDateTime
BillingDocumentDate BillingDocumentDate Billing Date
BillingDocumentDateYear
BillingDocDateYearQuarter
BillingDocDateYearMonth
SalesOrganization SalesOrganization Sales Organization
DistributionChannel DistributionChannel RefDistCh-Cust/Mat.
OrganizationDivision OrganizationDivision Org. Division
Division Division Internal Division ID
SalesOffice SalesOffice Sales Office
TradingPartnerasPartnerCompany
_GlobalCompany
Product Product Product Sold
ProductGroup ProductGroup Product Sold Group
ConditionRecord ConditionRecord Cond.Record No.
ConditionSequentialNumber ConditionSequentialNumber SequNo of Cond.
ConditionOrigin ConditionOrigin Condit.Origin
ConditionIsManuallyChanged ConditionIsManuallyChanged Changed Manual.
ConditionQuantityUnit ConditionQuantityUnit Unit of Measure
ConditionCalculationType ConditionCalculationType Calculat.Type
ConditionAmount
trueascond_amt_idcasConditionAmountInDC
NormalizedConditionAmount NormalizedConditionAmount
TransactionCurrency TransactionCurrency Transaction Currency
DisplayCurrency
ConditionBaseQuantity ConditionBaseQuantity Condition Base Quantity
_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
;

Learn More