I_BillingDocumentPrcgElmnt

DDL: I_BILLINGDOCUMENTPRCGELMNT Type: view BASIC
66 Fields 1 Data Sources 1 Associations

Billing Document Pricing Element

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

Data Sources (1)

SourceAliasJoin Type
I_BillingDocPrcgElmntBasic PricingElement from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_BillingDocument _BillingDocument $projection.BillingDocument = _BillingDocument.BillingDocument

Annotations (12)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Billing Document Pricing Element view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
AbapCatalog.sqlViewName ISDBILDOCPE 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)

KeyFieldSource TableSource FieldDescription
KEY BillingDocument I_BillingDocPrcgElmntBasic BillingDocument SD Document
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.
_BillingDocument _BillingDocument
_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_BillingDocumentPrcgElmnt.
-- 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_BillingDocumentPrcgElmnt AS
SELECT
  PricingElement.BillingDocument AS BillingDocument,
  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
LEFT OUTER JOIN I_BillingDocument AS _BillingDocument ON BillingDocument = _BillingDocument.BillingDocument  -- association [1..1]
;

Learn More