PurchaseDocumentsHistory
Source SQL File - Google Cloud Cortex Data Foundation
Google Cloud Cortex Foudantion - Cortex Reporting - (ecc) - PurchaseDocumentsHistory
Overview
This reporting view provides detailed information on purchasing documents and their related transactions in SAP systems. It combines data from the EKBE table with additional dimensions from the calendar_date_dim table, allowing for comprehensive analysis of purchasing activities.
Data Sources
| Source Table/View | Description |
|---|---|
| ekbe | SAP table containing purchasing document and transaction data |
| currency_decimal | Table providing currency-specific decimal place information |
| calendar_date_dim | Dimension table with date-related attributes |
Key Use Cases
- Analyzing purchasing trends and patterns
- Monitoring goods receipt and invoice receipt processes
- Identifying discrepancies between purchase orders and deliveries
- Reconciling financial data related to purchasing activities
- Supporting decision-making in procurement and supply chain management
Query Logic
The query retrieves data from the EKBE table and joins it with the currency_decimal and calendar_date_dim tables to enrich the data with currency-specific information and date-related dimensions. It filters the results to include only goods receipt and invoice receipt transactions (VGABE = '1' or '2').
Possible relation with SAP Transactions
| Transaction Code | Transaction Description |
|---|---|
| ME21N | Create Purchase Order |
| ME22N | Change Purchase Order |
| ME23N | Display Purchase Order |
| MIGO | Goods Receipt |
| MIRO | Invoice Receipt |
Data Lineage
Under Development
Table/View Fields
| Field | Field Description | Description in SAP Dictionary (Comming soon) |
|---|---|---|
| Client_MANDT | Client | |
| PurchasingDocumentNumber_EBELN | Purchasing Document Number | |
| ItemNumberOfPurchasingDocument_EBELP | Item Number of Purchasing Document | |
| SequentialNumberOfAccountAssignment_ZEKKN | Sequential Number of Account Assignment | |
| TransactioneventType_VGABE | Transaction event type | |
| MaterialDocumentYear_GJAHR | Material Document Year | |
| NumberOfMaterialDocument_BELNR | Number of Material Document | |
| ItemInMaterialDocument_BUZEI | Item in Material Document | |
| PurchaseOrderHistoryCategory_BEWTP | Purchase Order History Category | |
| MovementType__inventoryManagement___BWART | Movement Type (inventory management) | |
| PostingDateInTheDocument_BUDAT | Posting Date in the Document | |
| Quantity_MENGE | Quantity | |
| QuantityInPurchaseOrderPriceUnit_BPMNG | Quantity in Purchase Order Price Unit | |
| CurrencyKey_WAERS | Currency Key | |
| DocumentDateInDocument_BLDAT | Document Date in Document | |
| YearOfPostingDateInTheDocument_BUDAT | Year of Posting Date in the Document | |
| MonthOfPostingDateInTheDocument_BUDAT | Month of Posting Date in the Document | |
| WeekOfPostingDateInTheDocument_BUDAT | Week of Posting Date in the Document | |
| QuarterOfPostingDateInTheDocument_BUDAT | Quarter of Posting Date in the Document | |
| YearOfDocumentDateInDocument_BLDAT | Year of Document Date in Document | |
| MonthOfDocumentDateInDocument_BLDAT | Month of Document Date in Document | |
| WeekOfDocumentDateInDocument_BLDAT | Week of Document Date in Document | |
| QuarterOfDocumentDateInDocument_BLDAT | Quarter of Document Date in Document | |
| AmountInLocalCurrency_DMBTR | Amount in Local Currency | |
| AmountInDocumentCurrency_WRBTR | Amount in Document Currency |