A_PricingDocumentItemElement

DDL: A_PRICINGDOCUMENTITEMELEMENT Type: view_entity CONSUMPTION Package: VF_PRC_RAP_API
50 Fields 1 Data Sources 2 OData Services

Item Pricing Elements

A_PricingDocumentItemElement is a Consumption CDS View that provides data about "Item Pricing Elements" in SAP S/4HANA. It reads from 1 data source (R_PricingDocumentItemElementTP) and exposes 50 fields with key fields PricingDocument, PrcgDocumentHostObjectNodeID, PrcgDocHostObjSONTInUppercase, PricingDocumentItem, PricingProcedureStep. It is exposed through 2 OData services (API_BILLINGDOCUMENT, API_PRELIMINARYBILLINGDOCUMENT). Part of development package VF_PRC_RAP_API.

Data Sources (1)

SourceAliasJoin Type
R_PricingDocumentItemElementTP R_PricingDocumentItemElementTP projection

Annotations (14)

NameValueLevelField
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
EndUserText.label Item Pricing Elements view
Metadata.ignorePropagatedAnnotations true view
OData.containment.accessByNavigationOnly true view
OData.entityType.name PricingDocumentItemElement_Type view
ObjectModel.modelingPattern #TRANSACTIONAL_QUERY view
ObjectModel.query.implementedBy ABAP:CL_PRC_S4RAP_V4_API_QRY view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.sapObjectNodeType.name PricingDocumentItemElement view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
VDM.viewType #CONSUMPTION view
Feature SD_PRC_READ_ODATAV4 view

OData Services (2)

ServiceBindingVersionContractRelease
API_BILLINGDOCUMENT API_BILLINGDOCUMENT V4 C2 C1
API_PRELIMINARYBILLINGDOCUMENT API_PRELIMINARYBILLINGDOCUMENT V4 C2 C1

Fields (50)

KeyFieldSource TableSource FieldDescription
KEY PricingDocument PricingDocumentItemElement PricingDocument Document Condition
KEY PrcgDocumentHostObjectNodeID PricingDocumentItemElement PrcgDocumentHostObjectNodeID
KEY PrcgDocHostObjSONTInUppercase PricingDocumentItemElement PrcgDocHostObjSONTInUppercase
KEY PricingDocumentItem PricingDocumentItemElement PricingDocumentItem Item
KEY PricingProcedureStep PricingDocumentItemElement PricingProcedureStep Step Number
KEY PricingDocItemElementCounter PricingDocumentItemElement PricingDocItemElementCounter
ConditionType PricingDocumentItemElement ConditionType Condition type
PriceElementDescription PricingDocumentItemElement ConditionTypeName Name
ConditionClass PricingDocumentItemElement ConditionClass Condition Class
ConditionCalculationType PricingDocumentItemElement ConditionCalculationType Calculat.Type
ConditionCategory PricingDocumentItemElement ConditionCategory Condit.Category
ConditionRateAmount PricingDocumentItemElement ConditionRateAmount Condition Amount
ConditionCurrency PricingDocumentItemElement ConditionCurrency Currency
ConditionQuantity PricingDocumentItemElement ConditionQuantity Pricing Unit
ConditionBaseQuantity PricingDocumentItemElement ConditionBaseQuantity Quantity
ConditionQuantityISOUnit
ConditionQuantitySAPUnit PricingDocumentItemElement ConditionQuantityUnit Unit of Measure
ConditionRateRatio PricingDocumentItemElement ConditionRateRatio Ratio
ConditionRateRatioISOUnit
ConditionRateRatioSAPUnit PricingDocumentItemElement ConditionRateRatioUnit Unit of Measure
ConditionAmount PricingDocumentItemElement ConditionAmount Condition Value
ConditionBaseAmount PricingDocumentItemElement ConditionBaseAmount Condition Basis Amount
TransactionCurrency PricingDocumentItemElement TransactionCurrency Transaction Currency
CndnRoundingOffDiffAmount PricingDocumentItemElement CndnRoundingOffDiffAmount CondRoundDiff.
TaxCode PricingDocumentItemElement TaxCode Tax Code
VariantCondition PricingDocumentItemElement VariantCondition Variant Key
StructureCondition PricingDocumentItemElement StructureCondition Structure Cond.
IsGroupCondition PricingDocumentItemElement IsGroupCondition Group Condition
ConditionIsForConfiguration PricingDocumentItemElement ConditionIsForConfiguration UsedfVarConfig
IsRelevantForAccrual PricingDocumentItemElement IsRelevantForAccrual Accruals
CndnIsRelevantForIntcoBilling PricingDocumentItemElement CndnIsRelevantForIntcoBilling IntcoBillCond
ConditionRecord PricingDocumentItemElement ConditionRecord Cond.Record No.
PriceConditionDeterminationDte PricingDocumentItemElement PriceConditionDeterminationDte Condition Pricing Date
ConditionOrigin PricingDocumentItemElement ConditionOrigin Condit.Origin
ConditionControl PricingDocumentItemElement ConditionControl Cond.Control
ConditionInactiveReason PricingDocumentItemElement ConditionInactiveReason Inactive
ConditionIsManuallyChanged PricingDocumentItemElement ConditionIsManuallyChanged Changed Manual.
ConditionIsForStatistics PricingDocumentItemElement ConditionIsForStatistics Statistical
ConditionExchRateIsIndrctQtan PricingDocumentItemElement ConditionExchRateIsIndrctQtan
ConditionAbsoluteExchangeRate PricingDocumentItemElement ConditionAbsoluteExchangeRate
ConditionToBaseQtyNmrtr PricingDocumentItemElement ConditionToBaseQtyNmrtr Numerator
ConditionToBaseQtyDnmntr PricingDocumentItemElement ConditionToBaseQtyDnmntr Denominator
AccessNumberOfAccessSequence PricingDocumentItemElement AccessNumberOfAccessSequence Access
AccountKeyForGLAccount PricingDocumentItemElement AccountKeyForGLAccount Account Key
GLAccount PricingDocumentItemElement GLAccount General Ledger
AccrualsGLAccount PricingDocumentItemElement AccrualsGLAccount Accruals Acc.
ConditionRateValueIsAmount PricingDocumentItemElement ConditionRateValueIsAmount TRUE
ConditionRateValueIsRatio PricingDocumentItemElement ConditionRateValueIsRatio TRUE
ConditionBaseValueIsAmount PricingDocumentItemElement ConditionBaseValueIsAmount
ConditionBaseValueIsQuantity PricingDocumentItemElement ConditionBaseValueIsQuantity

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 A_PricingDocumentItemElement.
-- 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 A_PricingDocumentItemElement AS
SELECT
  PricingDocumentItemElement.PricingDocument AS PricingDocument,
  PricingDocumentItemElement.PrcgDocumentHostObjectNodeID AS PrcgDocumentHostObjectNodeID,
  PricingDocumentItemElement.PrcgDocHostObjSONTInUppercase AS PrcgDocHostObjSONTInUppercase,
  PricingDocumentItemElement.PricingDocumentItem AS PricingDocumentItem,
  PricingDocumentItemElement.PricingProcedureStep AS PricingProcedureStep,
  PricingDocumentItemElement.PricingDocItemElementCounter AS PricingDocItemElementCounter,
  PricingDocumentItemElement.ConditionType AS ConditionType,
  PricingDocumentItemElement.ConditionTypeName AS PriceElementDescription,
  PricingDocumentItemElement.ConditionClass AS ConditionClass,
  PricingDocumentItemElement.ConditionCalculationType AS ConditionCalculationType,
  PricingDocumentItemElement.ConditionCategory AS ConditionCategory,
  PricingDocumentItemElement.ConditionRateAmount AS ConditionRateAmount,
  PricingDocumentItemElement.ConditionCurrency AS ConditionCurrency,
  PricingDocumentItemElement.ConditionQuantity AS ConditionQuantity,
  PricingDocumentItemElement.ConditionBaseQuantity AS ConditionBaseQuantity,
  cast(_ConditionQuantityUnit.UnitOfMeasureISOCode as sd_cndn_qty_isounit preserving type) AS ConditionQuantityISOUnit,
  PricingDocumentItemElement.ConditionQuantityUnit AS ConditionQuantitySAPUnit,
  PricingDocumentItemElement.ConditionRateRatio AS ConditionRateRatio,
  cast(_ConditionRateRatioUnit.UnitOfMeasureISOCode as sd_cndn_rate_ratio_isounit preserving type) AS ConditionRateRatioISOUnit,
  PricingDocumentItemElement.ConditionRateRatioUnit AS ConditionRateRatioSAPUnit,
  PricingDocumentItemElement.ConditionAmount AS ConditionAmount,
  PricingDocumentItemElement.ConditionBaseAmount AS ConditionBaseAmount,
  PricingDocumentItemElement.TransactionCurrency AS TransactionCurrency,
  PricingDocumentItemElement.CndnRoundingOffDiffAmount AS CndnRoundingOffDiffAmount,
  PricingDocumentItemElement.TaxCode AS TaxCode,
  PricingDocumentItemElement.VariantCondition AS VariantCondition,
  PricingDocumentItemElement.StructureCondition AS StructureCondition,
  PricingDocumentItemElement.IsGroupCondition AS IsGroupCondition,
  PricingDocumentItemElement.ConditionIsForConfiguration AS ConditionIsForConfiguration,
  PricingDocumentItemElement.IsRelevantForAccrual AS IsRelevantForAccrual,
  PricingDocumentItemElement.CndnIsRelevantForIntcoBilling AS CndnIsRelevantForIntcoBilling,
  PricingDocumentItemElement.ConditionRecord AS ConditionRecord,
  PricingDocumentItemElement.PriceConditionDeterminationDte AS PriceConditionDeterminationDte,
  PricingDocumentItemElement.ConditionOrigin AS ConditionOrigin,
  PricingDocumentItemElement.ConditionControl AS ConditionControl,
  PricingDocumentItemElement.ConditionInactiveReason AS ConditionInactiveReason,
  PricingDocumentItemElement.ConditionIsManuallyChanged AS ConditionIsManuallyChanged,
  PricingDocumentItemElement.ConditionIsForStatistics AS ConditionIsForStatistics,
  PricingDocumentItemElement.ConditionExchRateIsIndrctQtan AS ConditionExchRateIsIndrctQtan,
  PricingDocumentItemElement.ConditionAbsoluteExchangeRate AS ConditionAbsoluteExchangeRate,
  PricingDocumentItemElement.ConditionToBaseQtyNmrtr AS ConditionToBaseQtyNmrtr,
  PricingDocumentItemElement.ConditionToBaseQtyDnmntr AS ConditionToBaseQtyDnmntr,
  PricingDocumentItemElement.AccessNumberOfAccessSequence AS AccessNumberOfAccessSequence,
  PricingDocumentItemElement.AccountKeyForGLAccount AS AccountKeyForGLAccount,
  PricingDocumentItemElement.GLAccount AS GLAccount,
  PricingDocumentItemElement.AccrualsGLAccount AS AccrualsGLAccount,
  PricingDocumentItemElement.ConditionRateValueIsAmount AS ConditionRateValueIsAmount,
  PricingDocumentItemElement.ConditionRateValueIsRatio AS ConditionRateValueIsRatio,
  PricingDocumentItemElement.ConditionBaseValueIsAmount AS ConditionBaseValueIsAmount,
  PricingDocumentItemElement.ConditionBaseValueIsQuantity AS ConditionBaseValueIsQuantity
FROM R_PricingDocumentItemElementTP
;

Learn More