SalesOrderPricing
Source SQL File - Google Cloud Cortex Data Foundation
Google Cloud Cortex Foudantion - Cortex Reporting - (s4) - SalesOrderPricing
Overview
This reporting view provides a consolidated view of pricing conditions for SAP systems. It aggregates pricing data at the document and condition item level, allowing for analysis of list prices, adjusted prices, discounts, and intercompany prices.
Data Sources
| Source Table/View | Description |
|---|---|
| PricingConditions | The source table for this view is the PricingConditions table, which contains detailed information about pricing conditions for sales documents in SAP systems. |
Key Use Cases
- Analyzing pricing trends and patterns across different documents and condition items.
- Identifying opportunities for price optimization and cost reduction.
- Monitoring the impact of discounts and promotions on overall pricing.
- Performing variance analysis between list prices, adjusted prices, and intercompany prices.
Query Logic
The view is created using a SELECT statement that aggregates pricing data from the PricingConditions table. The query groups the data by Client_MANDT, NumberOfTheDocumentCondition_KNUMV, and ConditionItemNumber_KPOSN, and calculates the maximum value for ConditionValueCurrencyKey_WAERS and Checkbox_KDATU. It also calculates the sum of ConditionValue_KWERT for different conditions, such as list prices, adjusted prices, discounts, and intercompany prices.
Possible relation with SAP Transactions
| Transaction Code | Transaction Description |
|---|---|
| VA01 | Create Sales Order |
| VA02 | Change Sales Order |
| VA03 | Display Sales Order |
Data Lineage
Under Development
Table/View Fields
| Field | Field Description | Description in SAP Dictionary (Comming soon) |
|---|---|---|
| PricingConditions.Client_MANDT | Client number | |
| PricingConditions.NumberOfTheDocumentCondition_KNUMV | Number of the document condition | |
| PricingConditions.ConditionItemNumber_KPOSN | Condition item number | |
| ConditionValueCurrencyKey_WAERS | Condition value currency key | |
| Checkbox_KDATU | Checkbox indicator | |
| ListPrice | List price | |
| AdjustedPrice | Adjusted price | |
| Discount | Discount | |
| InterCompanyPrice | Intercompany price | |
| TargetCurrency_TCURR | Target currency | |
| ListPriceInTargetCurrency | List price in target currency | |
| AdjustedPriceInTargetCurrency | Adjusted price in target currency | |
| DiscountInTargetCurrency | Discount in target currency | |
| InterCompanyPriceInTargetCurrency | Intercompany price in target currency |