SalesOrderPricing
Source SQL File - Google Cloud Cortex Data Foundation
Google Cloud Cortex Foudantion - Cortex Reporting - (ecc) - SalesOrderPricing
Overview
This reporting view provides a summary of pricing conditions for SAP systems. It includes information such as the client, document number, condition item number, condition value currency, checkbox indicator, list price, adjusted price, discount, and intercompany price.
Data Sources
| Source Table/View | Description |
|---|---|
| PricingConditions | This table contains the pricing conditions for SAP systems. |
Key Use Cases
- This view can be used to analyze pricing conditions for different clients and documents.
- It can also be used to identify discounts and intercompany pricing.
Query Logic
The query first groups the data by client, document number, and condition item number. It then calculates the maximum value for the condition value currency and checkbox indicator. It also calculates the sum of the condition value for different condition types and classes.
Possible relation with SAP Transactions
| Transaction Code | Transaction Description |
|---|---|
Data Lineage
Under Development
Table/View Fields
| Field | Field Description | Description in SAP Dictionary (Comming soon) |
|---|---|---|
| Client_MANDT | Client number | |
| NumberOfTheDocumentCondition_KNUMV | Number of the document condition | |
| 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 |