I_BillingDocReqPrcgElmnt
Billing Document Request Pricing Element
I_BillingDocReqPrcgElmnt is a Basic CDS View that provides data about "Billing Document Request Pricing Element" in SAP S/4HANA. It reads from 1 data source (I_BillingDocPrcgElmntBasic) and exposes 66 fields with key fields BillingDocumentRequest, PricingProcedureStep, PricingProcedureCounter.
SAP Help Documentation
| Category | Billing Document Requests |
|---|---|
| Status | Released |
Purpose
This CDS view provides the prerequisites for answering questions about header-level pricing elements in billing document requests. For more information about billing document requests, see Billing Document Requests . Example business questions could include: What tax conditions were applied in a given billing document request? How many discounts were applied in billing document requests last year and how substantial were they?
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
Object types This view relates to the following SAP object types: BillingDocumentRequest You can use BillingDocumentrequest , PricingProcedureStep , and PricingProcedureCounter as key fields. Measures and attributes The following table explains the most important measures and attributes in the view. Field Description Example Value in CDS View ConditionType The key that uniquely identifies the condition. The condition type indicates, for example, whether, during pricing, the system applies a price, a discount, a surcharge, or other pricing elements, such as freight costs and sales taxes. For each of these pricing elements, there is a condition type defined in the system. PPR0 (Price) ConditionCalculationType Determines how the system calculates prices, discounts, or surcharges in a condition. For example, the system can calculate a price as a fixed amount or as a percentage based on quantity, volume, or weight. The calculation type can be set when generating new condition records. If this does not happen, the calculation type maintained here is valid for the condition record. C (Quantity) The condition type is dependent on the quantity provided the business document. ConditionBaseAmount The amount of the conditions basis defines the value in a business document that the system uses together with the condition amount to calculate the condition value for the price condition. During the pricing process in a business document, for each condition type used in the pricing procedure, the system calculates the condition value as follows: For several calculation types (for example, A, C, D, E, F, H, I, J, K, M, N, O, P, W), the system multiplies the condition amount with the condition basis to calculate the condition value. For several calculation types (for example, A, B, H, I, J, K, W), the condition basis is a currency field and refers to a currency key field. Such a currency field in the context of pricing is called currency amount. If the currency key of the conditions basis (currency amount) differs from the currency key of the document, the system automatically converts the condition basis (currency amount) into the currency of the document. The system uses the exchange rates for the currencies that are defined in the general settings for currencies. Note: The standard number of decimal places for a currency is two. Currencies that use a different number of decimal places must in addition be entered into table TCURX, where you can explicitly define the number of decimal places, for example, zero decimals for Japanese yen JPY. If you have defined scales, the system uses the condition basis to determine the valid scale line with the corresponding condition amount. In usage-based pricing models, the usage corresponds to the condition basis. 100 This would indicate an amount of 100 in the relevant currency. ConditionBaseQuantity The quantity of the condition basis defines the value in a business document that the system uses together with the condition amount to calculate the condition value for the price condition. The condition basis can be a quantity (for example, piece), a weight or a volume. During the pricing process in a business document, for each condition type used in the pricing procedure, the system calculates the condition value as follows For seve
This CDS view provides the prerequisites for answering questions about header-level pricing elements in billing document requests. For more information about billing document requests, see Billing Document Requests . Example business questions could include: What tax conditions were applied in a given billing document request? How many discounts were applied in billing document requests last year and how substantial were they?
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
Object types This view relates to the following SAP object types: BillingDocumentRequest You can use BillingDocumentrequest , PricingProcedureStep , and PricingProcedureCounter as key fields. Measures and attributes The following table explains the most important measures and attributes in the view. Field Description Example Value in CDS View ConditionType The key that uniquely identifies the condition. The condition type indicates, for example, whether, during pricing, the system applies a price, a discount, a surcharge, or other pricing elements, such as freight costs and sales taxes. For each of these pricing elements, there is a condition type defined in the system. PPR0 (Price) ConditionCalculationType Determines how the system calculates prices, discounts, or surcharges in a condition. For example, the system can calculate a price as a fixed amount or as a percentage based on quantity, volume, or weight. The calculation type can be set when generating new condition records. If this does not happen, the calculation type maintained here is valid for the condition record. C (Quantity) The condition type is dependent on the quantity provided the business document. ConditionBaseAmount The amount of the conditions basis defines the value in a business document that the system uses together with the condition amount to calculate the condition value for the price condition. During the pricing process in a business document, for each condition type used in the pricing procedure, the system calculates the condition value as follows: For several calculation types (for example, A, C, D, E, F, H, I, J, K, M, N, O, P, W), the system multiplies the condition amount with the condition basis to calculate the condition value. For several calculation types (for example, A, B, H, I, J, K, W), the condition basis is a currency field and refers to a currency key field. Such a currency field in the context of pricing is called currency amount. If the currency key of the conditions basis (currency amount) differs from the currency key of the document, the system automatically converts the condition basis (currency amount) into the currency of the document. The system uses the exchange rates for the currencies that are defined in the general settings for currencies. Note: The standard number of decimal places for a currency is two. Currencies that use a different number of decimal places must in addition be entered into table TCURX, where you can explicitly define the number of decimal places, for example, zero decimals for Japanese yen JPY. If you have defined scales, the system uses the condition basis to determine the valid scale line with the corresponding condition amount. In usage-based pricing models, the usage corresponds to the condition basis. 100 This would indicate an amount of 100 in the relevant currency. ConditionBaseQuantity The quantity of the condition basis defines the value in a business document that the system uses together with the condition amount to calculate the condition value for the price condition. The condition basis can be a quantity (for example, piece), a weight or a volume. During the pricing process in a business document, for each condition type used in the pricing procedure, the system calculates the condition value as follows For seve
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_BillingDocPrcgElmntBasic | PricingElement | from |
Annotations (12)
| Name | Value | Level | Field |
|---|---|---|---|
| ClientHandling.algorithm | #SESSION_VARIABLE | view | |
| EndUserText.label | Billing Document Request Pricing Element | view | |
| AccessControl.authorizationCheck | #CHECK | view | |
| AccessControl.personalData.blocking | #REQUIRED | view | |
| AbapCatalog.sqlViewName | ISDBILDOCREQPE | view | |
| AbapCatalog.compiler.compareFilter | true | view | |
| AbapCatalog.preserveKey | true | view | |
| ObjectModel.usageType.dataClass | #TRANSACTIONAL | view | |
| ObjectModel.usageType.serviceQuality | #B | view | |
| ObjectModel.usageType.sizeCategory | #XL | view | |
| VDM.viewType | #BASIC | view | |
| Metadata.ignorePropagatedAnnotations | true | view |
Fields (66)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | BillingDocumentRequest | |||
| KEY | PricingProcedureStep | I_BillingDocPrcgElmntBasic | PricingProcedureStep | Step Number |
| KEY | PricingProcedureCounter | I_BillingDocPrcgElmntBasic | PricingProcedureCounter | Pricing Procedure Counter |
| ConditionApplication | I_BillingDocPrcgElmntBasic | ConditionApplication | Application | |
| ConditionType | I_BillingDocPrcgElmntBasic | ConditionType | Condition type | |
| PricingDateTime | I_BillingDocPrcgElmntBasic | PricingDateTime | ||
| PriceConditionDeterminationDte | I_BillingDocPrcgElmntBasic | PriceConditionDeterminationDte | Condition Pricing Date | |
| ConditionCalculationType | I_BillingDocPrcgElmntBasic | ConditionCalculationType | Calculat.Type | |
| ConditionBaseValue | I_BillingDocPrcgElmntBasic | ConditionBaseValue | Cond.Basis | |
| ConditionRateValue | I_BillingDocPrcgElmntBasic | ConditionRateValue | Condition Rate Value | |
| ConditionCurrency | I_BillingDocPrcgElmntBasic | ConditionCurrency | Currency | |
| ConditionQuantity | I_BillingDocPrcgElmntBasic | ConditionQuantity | Pricing Unit | |
| ConditionQuantityUnit | I_BillingDocPrcgElmntBasic | ConditionQuantityUnit | Unit of Measure | |
| ConditionCategory | I_BillingDocPrcgElmntBasic | ConditionCategory | Condit.Category | |
| ConditionIsForStatistics | I_BillingDocPrcgElmntBasic | ConditionIsForStatistics | Statistical | |
| PricingScaleType | I_BillingDocPrcgElmntBasic | PricingScaleType | Scale Type | |
| IsRelevantForAccrual | I_BillingDocPrcgElmntBasic | IsRelevantForAccrual | Accruals | |
| CndnIsRelevantForInvoiceList | I_BillingDocPrcgElmntBasic | CndnIsRelevantForInvoiceList | Settlement Document List Condition | |
| ConditionOrigin | I_BillingDocPrcgElmntBasic | ConditionOrigin | Condit.Origin | |
| IsGroupCondition | I_BillingDocPrcgElmntBasic | IsGroupCondition | Group Condition | |
| ConditionRecord | I_BillingDocPrcgElmntBasic | ConditionRecord | Cond.Record No. | |
| ConditionSequentialNumber | I_BillingDocPrcgElmntBasic | ConditionSequentialNumber | SequNo of Cond. | |
| TaxCode | I_BillingDocPrcgElmntBasic | TaxCode | Tax Code | |
| WithholdingTaxCode | I_BillingDocPrcgElmntBasic | WithholdingTaxCode | WTax Code | |
| CndnRoundingOffDiffAmount | I_BillingDocPrcgElmntBasic | CndnRoundingOffDiffAmount | CondRoundDiff. | |
| ConditionAmount | I_BillingDocPrcgElmntBasic | ConditionAmount | Condition Value | |
| TransactionCurrency | I_BillingDocPrcgElmntBasic | TransactionCurrency | Transaction Currency | |
| ConditionControl | I_BillingDocPrcgElmntBasic | ConditionControl | Cond.Control | |
| ConditionInactiveReason | I_BillingDocPrcgElmntBasic | ConditionInactiveReason | Inactive | |
| ConditionClass | I_BillingDocPrcgElmntBasic | ConditionClass | Condition Class | |
| PrcgProcedureCounterForHeader | I_BillingDocPrcgElmntBasic | PrcgProcedureCounterForHeader | Pricing Procedure Counter for Header | |
| FactorForConditionBasisValue | I_BillingDocPrcgElmntBasic | FactorForConditionBasisValue | Factor for Condition Basis Value | |
| StructureCondition | I_BillingDocPrcgElmntBasic | StructureCondition | Structure Cond. | |
| PeriodFactorForCndnBasisValue | I_BillingDocPrcgElmntBasic | PeriodFactorForCndnBasisValue | Period Factor for Condition Basis Value | |
| PricingScaleBasis | I_BillingDocPrcgElmntBasic | PricingScaleBasis | Scale Basis | |
| ConditionScaleBasisValue | I_BillingDocPrcgElmntBasic | ConditionScaleBasisValue | Scale Base Val. | |
| ConditionScaleBasisUnit | I_BillingDocPrcgElmntBasic | ConditionScaleBasisUnit | Scale UoM | |
| ConditionScaleBasisCurrency | I_BillingDocPrcgElmntBasic | ConditionScaleBasisCurrency | Scale Currency | |
| CndnIsRelevantForIntcoBilling | I_BillingDocPrcgElmntBasic | CndnIsRelevantForIntcoBilling | IntcoBillCond | |
| ConditionIsManuallyChanged | I_BillingDocPrcgElmntBasic | ConditionIsManuallyChanged | Changed Manual. | |
| ConditionIsForConfiguration | I_BillingDocPrcgElmntBasic | ConditionIsForConfiguration | UsedfVarConfig | |
| VariantCondition | I_BillingDocPrcgElmntBasic | VariantCondition | Variant Key | |
| ConditionRateAmount | I_BillingDocPrcgElmntBasic | ConditionRateAmount | Condition Amount | |
| ConditionBaseAmount | I_BillingDocPrcgElmntBasic | ConditionBaseAmount | Condition Basis Amount | |
| ConditionBaseQuantity | I_BillingDocPrcgElmntBasic | ConditionBaseQuantity | Quantity | |
| ConditionRateRatio | I_BillingDocPrcgElmntBasic | ConditionRateRatio | Ratio | |
| ConditionRateRatioUnit | I_BillingDocPrcgElmntBasic | ConditionRateRatioUnit | Unit of Measure | |
| ConditionScaleBaseAmount | I_BillingDocPrcgElmntBasic | ConditionScaleBaseAmount | Scale Base Am. | |
| ConditionScaleBaseQuantity | I_BillingDocPrcgElmntBasic | ConditionScaleBaseQuantity | Scale Base Qu. | |
| _BillingDocumentRequest | _BillingDocumentRequest | |||
| _ConditionApplication | I_BillingDocPrcgElmntBasic | _ConditionApplication | ||
| _PricingConditionType | I_BillingDocPrcgElmntBasic | _PricingConditionType | ||
| _ConditionCalculationType | I_BillingDocPrcgElmntBasic | _ConditionCalculationType | ||
| _ConditionCurrency | I_BillingDocPrcgElmntBasic | _ConditionCurrency | ||
| _Currency | I_BillingDocPrcgElmntBasic | _Currency | ||
| _ConditionQuantityUnit | I_BillingDocPrcgElmntBasic | _ConditionQuantityUnit | ||
| _ConditionCategory | I_BillingDocPrcgElmntBasic | _ConditionCategory | ||
| _ConditionOrigin | I_BillingDocPrcgElmntBasic | _ConditionOrigin | ||
| _ConditionControl | I_BillingDocPrcgElmntBasic | _ConditionControl | ||
| _ConditionInactiveReason | I_BillingDocPrcgElmntBasic | _ConditionInactiveReason | ||
| _ConditionClass | I_BillingDocPrcgElmntBasic | _ConditionClass | ||
| _PricingScaleBasis | I_BillingDocPrcgElmntBasic | _PricingScaleBasis | ||
| _ScaleUnitOfMeasure | I_BillingDocPrcgElmntBasic | _ScaleUnitOfMeasure | ||
| _ScaleCurrency | I_BillingDocPrcgElmntBasic | _ScaleCurrency | ||
| _VariantCondition | I_BillingDocPrcgElmntBasic | _VariantCondition | ||
| _StructureCondition | I_BillingDocPrcgElmntBasic | _StructureCondition |
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_BillingDocReqPrcgElmnt.
-- 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.
CREATE VIEW I_BillingDocReqPrcgElmnt AS
SELECT
cast( PricingElement.BillingDocument as vbeln_bdr preserving type ) AS BillingDocumentRequest,
PricingElement.PricingProcedureStep AS PricingProcedureStep,
PricingElement.PricingProcedureCounter AS PricingProcedureCounter,
PricingElement.ConditionApplication AS ConditionApplication,
PricingElement.ConditionType AS ConditionType,
PricingElement.PricingDateTime AS PricingDateTime,
PricingElement.PriceConditionDeterminationDte AS PriceConditionDeterminationDte,
PricingElement.ConditionCalculationType AS ConditionCalculationType,
PricingElement.ConditionBaseValue AS ConditionBaseValue,
PricingElement.ConditionRateValue AS ConditionRateValue,
PricingElement.ConditionCurrency AS ConditionCurrency,
PricingElement.ConditionQuantity AS ConditionQuantity,
PricingElement.ConditionQuantityUnit AS ConditionQuantityUnit,
PricingElement.ConditionCategory AS ConditionCategory,
PricingElement.ConditionIsForStatistics AS ConditionIsForStatistics,
PricingElement.PricingScaleType AS PricingScaleType,
PricingElement.IsRelevantForAccrual AS IsRelevantForAccrual,
PricingElement.CndnIsRelevantForInvoiceList AS CndnIsRelevantForInvoiceList,
PricingElement.ConditionOrigin AS ConditionOrigin,
PricingElement.IsGroupCondition AS IsGroupCondition,
PricingElement.ConditionRecord AS ConditionRecord,
PricingElement.ConditionSequentialNumber AS ConditionSequentialNumber,
PricingElement.TaxCode AS TaxCode,
PricingElement.WithholdingTaxCode AS WithholdingTaxCode,
PricingElement.CndnRoundingOffDiffAmount AS CndnRoundingOffDiffAmount,
PricingElement.ConditionAmount AS ConditionAmount,
PricingElement.TransactionCurrency AS TransactionCurrency,
PricingElement.ConditionControl AS ConditionControl,
PricingElement.ConditionInactiveReason AS ConditionInactiveReason,
PricingElement.ConditionClass AS ConditionClass,
PricingElement.PrcgProcedureCounterForHeader AS PrcgProcedureCounterForHeader,
PricingElement.FactorForConditionBasisValue AS FactorForConditionBasisValue,
PricingElement.StructureCondition AS StructureCondition,
PricingElement.PeriodFactorForCndnBasisValue AS PeriodFactorForCndnBasisValue,
PricingElement.PricingScaleBasis AS PricingScaleBasis,
PricingElement.ConditionScaleBasisValue AS ConditionScaleBasisValue,
PricingElement.ConditionScaleBasisUnit AS ConditionScaleBasisUnit,
PricingElement.ConditionScaleBasisCurrency AS ConditionScaleBasisCurrency,
PricingElement.CndnIsRelevantForIntcoBilling AS CndnIsRelevantForIntcoBilling,
PricingElement.ConditionIsManuallyChanged AS ConditionIsManuallyChanged,
PricingElement.ConditionIsForConfiguration AS ConditionIsForConfiguration,
PricingElement.VariantCondition AS VariantCondition,
PricingElement.ConditionRateAmount AS ConditionRateAmount,
PricingElement.ConditionBaseAmount AS ConditionBaseAmount,
PricingElement.ConditionBaseQuantity AS ConditionBaseQuantity,
PricingElement.ConditionRateRatio AS ConditionRateRatio,
PricingElement.ConditionRateRatioUnit AS ConditionRateRatioUnit,
PricingElement.ConditionScaleBaseAmount AS ConditionScaleBaseAmount,
PricingElement.ConditionScaleBaseQuantity AS ConditionScaleBaseQuantity,
PricingElement._ConditionApplication AS _ConditionApplication,
PricingElement._PricingConditionType AS _PricingConditionType,
PricingElement._ConditionCalculationType AS _ConditionCalculationType,
PricingElement._ConditionCurrency AS _ConditionCurrency,
PricingElement._Currency AS _Currency,
PricingElement._ConditionQuantityUnit AS _ConditionQuantityUnit,
PricingElement._ConditionCategory AS _ConditionCategory,
PricingElement._ConditionOrigin AS _ConditionOrigin,
PricingElement._ConditionControl AS _ConditionControl,
PricingElement._ConditionInactiveReason AS _ConditionInactiveReason,
PricingElement._ConditionClass AS _ConditionClass,
PricingElement._PricingScaleBasis AS _PricingScaleBasis,
PricingElement._ScaleUnitOfMeasure AS _ScaleUnitOfMeasure,
PricingElement._ScaleCurrency AS _ScaleCurrency,
PricingElement._VariantCondition AS _VariantCondition,
PricingElement._StructureCondition AS _StructureCondition
FROM I_BillingDocPrcgElmntBasic AS PricingElement
;Learn More
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- CDS View Annotations — A Complete Guide
- What Is a CDS View in SAP S/4HANA?
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- BW Extractor to CDS View Migration Guide
- S/4HANA CDS View Deprecation: What You Need to Know
- ABAP CDS View Tutorial — From Basics to Real-World Examples
- RAP and CDS Views — Building Transactional Apps in SAP S/4HANA
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA