R_PricingDocumentItemElementTP

DDL: R_PRICINGDOCUMENTITEMELEMENTTP Type: view_entity TRANSACTIONAL
42 Fields 1 Data Sources 1 Associations

Pricing Document Item Element - TP

R_PricingDocumentItemElementTP is a Transactional CDS View that provides data about "Pricing Document Item Element - TP" in SAP S/4HANA. It reads from 1 data source (P_PricingDocumentItemElement) and exposes 42 fields with key fields PricingDocument, HostObjectNodeID, HostObjNodeSAPObjectNodeType, PricingDocumentItem, PricingProcedureStep. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
P_PricingDocumentItemElement PricingDocumentItemElement from

Associations (1)

CardinalityTargetAliasCondition
[1..1] R_PricingDocumentTP _PricingDocument $projection.PricingDocument = _PricingDocument.PricingDocument and $projection.HostObjNodeSAPObjectNodeType = _PricingDocument.HostObjNodeSAPObjectNodeType and $projection.HostObjectNodeID = _PricingDocument.HostObjectNodeID

Annotations (8)

NameValueLevelField
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #TRANSACTIONAL view
Metadata.ignorePropagatedAnnotations true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
EndUserText.label Pricing Document Item Element - TP view

Fields (42)

KeyFieldSource TableSource FieldDescription
KEY PricingDocument P_PricingDocumentItemElement PricingDocument Document Condition
KEY HostObjectNodeID P_PricingDocumentItemElement HostObjectNodeID
KEY HostObjNodeSAPObjectNodeType P_PricingDocumentItemElement HostObjNodeSAPObjectNodeType SAP Obj Node Type
KEY PricingDocumentItem P_PricingDocumentItemElement PricingDocumentItem Item
KEY PricingProcedureStep P_PricingDocumentItemElement PricingProcedureStep Step Number
KEY PricingProcedureCounter P_PricingDocumentItemElement PricingProcedureCounter Pricing Procedure Counter
ConditionApplication P_PricingDocumentItemElement ConditionApplication Application
ConditionType P_PricingDocumentItemElement ConditionType Condition type
ConditionTypeName
ConditionCalculationType P_PricingDocumentItemElement ConditionCalculationType Calculat.Type
PriceConditionDeterminationDte P_PricingDocumentItemElement PriceConditionDeterminationDte Condition Pricing Date
ConditionRateAmount P_PricingDocumentItemElement ConditionRateAmount Condition Amount
ConditionRateRatio P_PricingDocumentItemElement ConditionRateRatio Ratio
ConditionBaseAmount P_PricingDocumentItemElement ConditionBaseAmount Condition Basis Amount
ConditionBaseQuantity P_PricingDocumentItemElement ConditionBaseQuantity Quantity
ConditionQuantity P_PricingDocumentItemElement ConditionQuantity Pricing Unit
ConditionAmount P_PricingDocumentItemElement ConditionAmount Condition Value
ConditionCurrency P_PricingDocumentItemElement ConditionCurrency Currency
TransactionCurrency P_PricingDocumentItemElement TransactionCurrency Transaction Currency
ConditionQuantityUnit P_PricingDocumentItemElement ConditionQuantityUnit Unit of Measure
ConditionRateRatioUnit P_PricingDocumentItemElement ConditionRateRatioUnit Unit of Measure
ConditionIsForStatistics P_PricingDocumentItemElement ConditionIsForStatistics Statistical
ConditionIsManuallyChanged P_PricingDocumentItemElement ConditionIsManuallyChanged Changed Manual.
ConditionInactiveReason P_PricingDocumentItemElement ConditionInactiveReason Inactive
ConditionClass P_PricingDocumentItemElement ConditionClass Condition Class
ConditionOrigin P_PricingDocumentItemElement ConditionOrigin Condit.Origin
ConditionRateValueIsAmount
ConditionRateValueIsRatio
ConditionBaseValueIsQuantity
ConditionBaseValueIsAmount
_PricingDocument _PricingDocument
_ConditionApplication P_PricingDocumentItemElement _ConditionApplication
_PricingConditionType P_PricingDocumentItemElement _PricingConditionType
_ConditionCalculationType P_PricingDocumentItemElement _ConditionCalculationType
_ConditionCurrency P_PricingDocumentItemElement _ConditionCurrency
_TransactionCurrency P_PricingDocumentItemElement _Currency
_ConditionQuantityUnit P_PricingDocumentItemElement _ConditionQuantityUnit
_ConditionInactiveReason P_PricingDocumentItemElement _ConditionInactiveReason
_ConditionClass P_PricingDocumentItemElement _ConditionClass
_ConditionOrigin P_PricingDocumentItemElement _ConditionOrigin
_ConditionRateRatioUnit P_PricingDocumentItemElement _ConditionRateRatioUnit
_PricingDocumentItem _PricingDocumentItem

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 R_PricingDocumentItemElementTP.
-- 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 R_PricingDocumentItemElementTP AS
SELECT
  PricingDocumentItemElement.PricingDocument AS PricingDocument,
  PricingDocumentItemElement.HostObjectNodeID AS HostObjectNodeID,
  PricingDocumentItemElement.HostObjNodeSAPObjectNodeType AS HostObjNodeSAPObjectNodeType,
  PricingDocumentItemElement.PricingDocumentItem AS PricingDocumentItem,
  PricingDocumentItemElement.PricingProcedureStep AS PricingProcedureStep,
  PricingDocumentItemElement.PricingProcedureCounter AS PricingProcedureCounter,
  PricingDocumentItemElement.ConditionApplication AS ConditionApplication,
  PricingDocumentItemElement.ConditionType AS ConditionType,
  PricingDocumentItemElement._PricingConditionType._Text_2[1: Language=$session.system_language].ConditionTypeName AS ConditionTypeName,
  PricingDocumentItemElement.ConditionCalculationType AS ConditionCalculationType,
  PricingDocumentItemElement.PriceConditionDeterminationDte AS PriceConditionDeterminationDte,
  PricingDocumentItemElement.ConditionRateAmount AS ConditionRateAmount,
  PricingDocumentItemElement.ConditionRateRatio AS ConditionRateRatio,
  PricingDocumentItemElement.ConditionBaseAmount AS ConditionBaseAmount,
  PricingDocumentItemElement.ConditionBaseQuantity AS ConditionBaseQuantity,
  PricingDocumentItemElement.ConditionQuantity AS ConditionQuantity,
  PricingDocumentItemElement.ConditionAmount AS ConditionAmount,
  PricingDocumentItemElement.ConditionCurrency AS ConditionCurrency,
  PricingDocumentItemElement.TransactionCurrency AS TransactionCurrency,
  PricingDocumentItemElement.ConditionQuantityUnit AS ConditionQuantityUnit,
  PricingDocumentItemElement.ConditionRateRatioUnit AS ConditionRateRatioUnit,
  PricingDocumentItemElement.ConditionIsForStatistics AS ConditionIsForStatistics,
  PricingDocumentItemElement.ConditionIsManuallyChanged AS ConditionIsManuallyChanged,
  PricingDocumentItemElement.ConditionInactiveReason AS ConditionInactiveReason,
  PricingDocumentItemElement.ConditionClass AS ConditionClass,
  PricingDocumentItemElement.ConditionOrigin AS ConditionOrigin,
  cast( '' as boole_d ) AS ConditionRateValueIsAmount,
  cast( '' as boole_d ) AS ConditionRateValueIsRatio,
  cast( '' as boole_d ) AS ConditionBaseValueIsQuantity,
  cast( '' as boole_d ) AS ConditionBaseValueIsAmount,
  PricingDocumentItemElement._ConditionApplication AS _ConditionApplication,
  PricingDocumentItemElement._PricingConditionType AS _PricingConditionType,
  PricingDocumentItemElement._ConditionCalculationType AS _ConditionCalculationType,
  PricingDocumentItemElement._ConditionCurrency AS _ConditionCurrency,
  PricingDocumentItemElement._Currency AS _TransactionCurrency,
  PricingDocumentItemElement._ConditionQuantityUnit AS _ConditionQuantityUnit,
  PricingDocumentItemElement._ConditionInactiveReason AS _ConditionInactiveReason,
  PricingDocumentItemElement._ConditionClass AS _ConditionClass,
  PricingDocumentItemElement._ConditionOrigin AS _ConditionOrigin,
  PricingDocumentItemElement._ConditionRateRatioUnit AS _ConditionRateRatioUnit
FROM P_PricingDocumentItemElement AS PricingDocumentItemElement
LEFT OUTER JOIN R_PricingDocumentTP AS _PricingDocument ON PricingDocument = _PricingDocument.PricingDocument AND HostObjNodeSAPObjectNodeType = _PricingDocument.HostObjNodeSAPObjectNodeType AND HostObjectNodeID = _PricingDocument.HostObjectNodeID  -- association [1..1]
;

Learn More