POVendorConfirmation
Source SQL File - Google Cloud Cortex Data Foundation
Google Cloud Cortex Foudantion - Cortex Reporting - (s4) - POVendorConfirmation
Overview
This reporting view provides detailed information about vendor confirmations for purchasing documents in SAP systems. It combines data from the EKES table, which stores vendor confirmation data, with data from the PurchaseDocuments and VendorsMD views, which provide additional context about the purchasing documents and vendors involved.
Data Sources
| Source Table/View | Description |
|---|---|
| ekes | Vendor confirmation data, including confirmation category, delivery date, quantity, and other details. |
| PurchaseDocuments | Purchasing document header data, including document number, vendor account number, and payment terms. |
| VendorsMD | Vendor master data, including vendor name and account number. |
Key Use Cases
- Analyze vendor confirmation data for specific purchasing documents.
- Track the status of vendor confirmations and identify any delays or issues.
- Monitor the quantity and timing of vendor confirmations to optimize inventory management.
- Reconcile vendor confirmation data with other purchasing and vendor-related data.
Query Logic
The view joins the EKES table with the PurchaseDocuments and VendorsMD views using the Client_MANDT, EBELN, and EBELP fields to ensure that the data is properly aligned. It then selects a comprehensive set of fields from the EKES table, including confirmation category, delivery date, quantity, and other relevant details.
Possible relation with SAP Transactions
| Transaction Code | Transaction Description |
|---|---|
| ME23N | Display Purchase Order |
| ME22N | Change Purchase Order |
| ME21N | Create Purchase Order |
| FK03 | Display Vendor Master Data |
| FK02 | Change Vendor Master Data |
| FK01 | Create Vendor Master Data |
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 | |
| SequentialNumberOfVendorConfirmation_ETENS | Sequential Number of Vendor Confirmation | |
| ConfirmationCategory_EBTYP | Confirmation Category | |
| DeliveryDateOfVendorConfirmation_EINDT | Delivery Date of Vendor Confirmation | |
| DateCategoryOfDeliveryDateInVendorConfirmation_LPEIN | Date Category of Delivery Date in Vendor Confirmation | |
| DeliveryDateTimeSpotInVendorConfirmation_UZEIT | Delivery Date/Time Spot in Vendor Confirmation | |
| CreationDateOfConfirmation_ERDAT | Creation Date of Confirmation | |
| TimeAtWhichVendorConfirmationWasCreated_EZEIT | Time at Which Vendor Confirmation Was Created | |
| QuantityAsPerVendorConfirmation_MENGE | Quantity As Per Vendor Confirmation | |
| QuantityReduced__mrp___DABMG | Quantity Reduced (MRP) | |
| CreationIndicator_VendorConfirmation_ESTKZ | Creation Indicator (Vendor Confirmation) | |
| VendorConfirmationDeletionIndicator_LOEKZ | Vendor Confirmation Deletion Indicator | |
| Indicator_ConfirmationIsRelevantToMaterialsPlanning_KZDIS | Indicator: Confirmation Is Relevant to Materials Planning | |
| ReferenceDocumentNumber__forDependenciesSeeLongText___XBLNR | Reference Document Number (for Dependencies, See Long Text) | |
| Delivery_VBELN | Delivery | |
| DeliveryItem_VBELP | Delivery Item | |
| MfrPartProfile_MPROF | Mfr Part Profile | |
| MaterialNumberCorrespondingToManufacturerPartNumber_EMATN | Material Number Corresponding to Manufacturer Part Number | |
| NumberOfRemindersexpediters_MAHNZ | Number of Reminders/Expediters | |
| BatchNumber_CHARG | Batch Number | |
| HigherLevelItemOfBatchSplitItem_UECHA | Higher-Level Item of Batch Split Item | |
| SequentialNumberOfVendorConfirmation_REF_ETENS | Sequential Number of Vendor Confirmation (REF) | |
| DeliveryHasStatusinPlant_IMWRK | Delivery Has Status in Plant | |
| Delivery_VBELN_ST | Delivery | |
| DeliveryItem_VBELP_ST | Delivery Item | |
| HandoverDateAtTheHandoverLocation_HANDOVERDATE | Handover Date at the Handover Location | |
| HandoverTimeAtTheHandoverLocation_HANDOVERTIME | Handover Time at the Handover Location | |
| StockSegment_SGT_SCAT | Stock Segment | |
| AllocatedStockQuantity_FSH_SALLOC_QTY | Allocated Stock Quantity | |
| AccountNumberOfVendorOrCreditor_LIFNR | Account Number of Vendor or Creditor | |
| NAME1 | Vendor Name 1 | |
| NAME2 | Vendor Name 2 | |
| TermsPaymentKey_ZTERM | Terms of Payment Key | |
| DiscountDays1_ZBD1T | Discount Days 1 |