What is I_PrelimBillingDocPrcgElmnt in SAP S/4HANA?

I_PrelimBillingDocPrcgElmnt is a basic CDS view in SAP S/4HANA. Prelim Billing Document Pricing Element It contains 65 fields.

Which tables does I_PrelimBillingDocPrcgElmnt read from?

I_PrelimBillingDocPrcgElmnt reads data from: I_BillingDocPrcgElmntBasic.

What VDM layer is I_PrelimBillingDocPrcgElmnt?

I_PrelimBillingDocPrcgElmnt is classified as a Basic (interface) view providing a 1:1 representation of a database table.

I_PrelimBillingDocPrcgElmnt

DDL: I_PRELIMBILLINGDOCPRCGELMNT Type: view BASIC

65 Fields 1 Data Sources 1 Associations

Prelim Billing Document Pricing Element

I_PrelimBillingDocPrcgElmnt is a Basic CDS View that provides data about "Prelim Billing Document Pricing Element" in SAP S/4HANA. It reads from 1 data source (I_BillingDocPrcgElmntBasic) and exposes 65 fields with key fields PrelimBillingDocument, PricingProcedureStep, PricingProcedureCounter. It has 1 association to related views.

SAP Help Documentation

Category	Preliminary Billing Documents
Status	Released

Purpose
This CDS view provides the prerequisites for answering questions about pricing elements in preliminary billing document at header level. For more information about preliminary billing documents, see Preliminary Billing Documents . Example business questions could include: What tax conditions were applied in a given preliminary billing document? How many discounts were applied in preliminary billing documents last year and how substantial were they? What are the conditions types used in a given preliminary billing document?

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: PreliminaryBillingDocument

Constraints
Only a reduced view of the data that is visible on the user interface (UI) is saved in the database. Example Only rows that are assigned to a condition type are saved. Therefore, subtotal rows are not saved in the database, but they are calculated so that they can be displayed on the UI.

View on SAP Help Portal →

Data Sources (1)

Source	Alias	Join Type
I_BillingDocPrcgElmntBasic	PricingElement	from

Associations (1)

Cardinality	Target	Alias	Condition
[1..1]	I_PrelimBillingDocument	_PrelimBillingDocument	`$projection.PrelimBillingDocument = _PrelimBillingDocument.PrelimBillingDocument`

Annotations (12)

Name	Value	Level
ClientHandling.algorithm	#SESSION_VARIABLE	view
EndUserText.label	Prelim Billing Document Pricing Element	view
AccessControl.authorizationCheck	#CHECK	view
AccessControl.personalData.blocking	#REQUIRED	view
AbapCatalog.sqlViewName	ISDPREBILDOCPE	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 (65)

Key	Field	Source Table	Source Field	Description
KEY	PrelimBillingDocument
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
	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.
	_PrelimBillingDocument		_PrelimBillingDocument
	_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_PrelimBillingDocPrcgElmnt.
-- 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_PrelimBillingDocPrcgElmnt AS
SELECT
  cast( PricingElement.BillingDocument as prelim_billing_document preserving type ) AS PrelimBillingDocument,
  PricingElement.PricingProcedureStep AS PricingProcedureStep,
  PricingElement.PricingProcedureCounter AS PricingProcedureCounter,
  PricingElement.ConditionApplication AS ConditionApplication,
  PricingElement.ConditionType AS ConditionType,
  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
LEFT OUTER JOIN I_PrelimBillingDocument AS _PrelimBillingDocument ON PrelimBillingDocument = _PrelimBillingDocument.PrelimBillingDocument  -- association [1..1]
;

Depth:

I_PrelimBillingDocPrcgElmnt view

I_BillingDocPrcgElmntBasic view