PurchaseDocumentsHistory
Source SQL File - Google Cloud Cortex Data Foundation
Google Cloud Cortex Foudantion - Cortex Reporting - (s4) - PurchaseDocumentsHistory
Overview
This reporting view provides detailed information about purchasing documents and their related accounting entries from the SAP ERP system. It combines data from the EKBE table with additional dimensions from the calendar_date_dim table to provide a comprehensive view of purchasing activity.
Data Sources
| Source Table/View | Description |
|---|---|
| ekbe | SAP ERP table containing accounting entries for purchasing documents |
| currency_decimal | Dimension table providing currency-specific decimal place information |
| calendar_date_dim | Dimension table providing calendar-related dimensions for dates |
Key Use Cases
- Analyzing purchasing trends and patterns
- Identifying and resolving discrepancies in purchasing data
- Reporting on purchasing performance and efficiency
- Supporting decision-making related to purchasing and inventory 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 additional dimensions. It filters the results to include only accounting entries related to goods receipt (VGABE = '1') and invoice receipt (VGABE = '2').
Possible relation with SAP Transactions
| Transaction Code | Transaction Description |
|---|---|
| ME21N | Create Purchase Order |
| ME22N | Change Purchase Order |
| ME23N | Display Purchase Order |
| MIRO | Enter Invoice |
| MRKO | Goods Receipt for Purchase Order |
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 |