C_PPS_PurOrdItmPrcgElementTP

DDL: C_PPS_PURORDITMPRCGELEMENTTP Type: view_entity CONSUMPTION
31 Fields 1 Data Sources

Purchase Order Item Pricing Element

C_PPS_PurOrdItmPrcgElementTP is a Consumption CDS View that provides data about "Purchase Order Item Pricing Element" in SAP S/4HANA. It reads from 1 data source (R_PPS_PurOrdItmPrcgElementTP) and exposes 31 fields with key fields PurchaseOrder, PurchaseOrderItem, PricingDocument, PricingDocumentItem, PricingProcedureStep.

Data Sources (1)

SourceAliasJoin Type
R_PPS_PurOrdItmPrcgElementTP R_PPS_PurOrdItmPrcgElementTP projection

Annotations (9)

NameValueLevelField
VDM.viewType #CONSUMPTION view
EndUserText.label Purchase Order Item Pricing Element view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
Metadata.allowExtensions true view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
Metadata.ignorePropagatedAnnotations true view

Fields (31)

KeyFieldSource TableSource FieldDescription
KEY PurchaseOrder Document PurchaseOrder Purchasing Document
KEY PurchaseOrderItem Document PurchaseOrderItem Purchasing Document Item
KEY PricingDocument Document PricingDocument Document Condition
KEY PricingDocumentItem Document PricingDocumentItem Item
KEY PricingProcedureStep Document PricingProcedureStep Step Number
KEY PricingProcedureCounter Document PricingProcedureCounter Pricing Procedure Counter
ConditionApplication Document ConditionApplication Application
ConditionType Document ConditionType Condition type
ConditionAmount Document ConditionAmount Condition Value
ConditionCurrency Document ConditionCurrency Currency
ConditionQuantity Document ConditionQuantity Pricing Unit
ConditionQuantityUnit Document ConditionQuantityUnit Unit of Measure
ConditionCalculationType Document ConditionCalculationType Calculat.Type
ConditionInactiveReason Document ConditionInactiveReason Inactive
TransactionCurrency Document TransactionCurrency Transaction Currency
ConditionRateValue Document ConditionRateValue Condition Rate Value
ConditionRateRatio Document ConditionRateRatio Ratio
ConditionRateValueIsAmount Document ConditionRateValueIsAmount TRUE
ConditionRateValueIsRatio Document ConditionRateValueIsRatio TRUE
ConditionBaseValueIsAmount Document ConditionBaseValueIsAmount
ConditionBaseValueIsQuantity Document ConditionBaseValueIsQuantity
ConditionRateRatioUnit Document ConditionRateRatioUnit Unit of Measure
ConditionTypeName Document ConditionTypeName Name
ConditionBaseValue Document ConditionBaseValue Cond.Basis
ConditionBaseAmount Document ConditionBaseAmount Condition Basis Amount
ConditionBaseQuantity Document ConditionBaseQuantity Quantity
ConditionIsManuallyChanged Document ConditionIsManuallyChanged Changed Manual.
ConditionIsForStatistics Document ConditionIsForStatistics Statistical
PPSItemConditionStatus Document PPSItemConditionStatus
_ConditionApplication _ConditionApplication
_ConditionQuantityUnit _ConditionQuantityUnit

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 C_PPS_PurOrdItmPrcgElementTP.
-- 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 C_PPS_PurOrdItmPrcgElementTP AS
SELECT
  Document.PurchaseOrder AS PurchaseOrder,
  Document.PurchaseOrderItem AS PurchaseOrderItem,
  Document.PricingDocument AS PricingDocument,
  Document.PricingDocumentItem AS PricingDocumentItem,
  Document.PricingProcedureStep AS PricingProcedureStep,
  Document.PricingProcedureCounter AS PricingProcedureCounter,
  Document.ConditionApplication AS ConditionApplication,
  Document.ConditionType AS ConditionType,
  Document.ConditionAmount AS ConditionAmount,
  Document.ConditionCurrency AS ConditionCurrency,
  Document.ConditionQuantity AS ConditionQuantity,
  Document.ConditionQuantityUnit AS ConditionQuantityUnit,
  Document.ConditionCalculationType AS ConditionCalculationType,
  Document.ConditionInactiveReason AS ConditionInactiveReason,
  Document.TransactionCurrency AS TransactionCurrency,
  Document.ConditionRateValue AS ConditionRateValue,
  Document.ConditionRateRatio AS ConditionRateRatio,
  Document.ConditionRateValueIsAmount AS ConditionRateValueIsAmount,
  Document.ConditionRateValueIsRatio AS ConditionRateValueIsRatio,
  Document.ConditionBaseValueIsAmount AS ConditionBaseValueIsAmount,
  Document.ConditionBaseValueIsQuantity AS ConditionBaseValueIsQuantity,
  Document.ConditionRateRatioUnit AS ConditionRateRatioUnit,
  Document.ConditionTypeName AS ConditionTypeName,
  Document.ConditionBaseValue AS ConditionBaseValue,
  Document.ConditionBaseAmount AS ConditionBaseAmount,
  Document.ConditionBaseQuantity AS ConditionBaseQuantity,
  Document.ConditionIsManuallyChanged AS ConditionIsManuallyChanged,
  Document.ConditionIsForStatistics AS ConditionIsForStatistics,
  Document.PPSItemConditionStatus AS PPSItemConditionStatus
FROM R_PPS_PurOrdItmPrcgElementTP
;

Learn More