AccountsPayableTurnover
Source SQL File - Google Cloud Cortex Data Foundation
Google Cloud Cortex Foudantion - Cortex Reporting - (ecc) - AccountsPayableTurnover
Overview
This view provides a comprehensive analysis of Accounts Payable data, including key metrics such as total purchases, accounts payable turnover, and period-end balances. It enables users to gain insights into vendor transactions, invoice processing, and payment trends.
Data Sources
| Source Table/View | Description |
|---|---|
| AccountsPayable | This table contains detailed information about accounts payable transactions, including invoice data, payment details, and vendor information. |
Key Use Cases
- Analyzing vendor performance and payment patterns
- Identifying opportunities for early payment discounts and vendor negotiations
- Monitoring accounts payable turnover to assess the efficiency of the payment process
- Providing insights for financial planning and forecasting
Query Logic
The view is constructed using a series of subqueries and window functions to calculate key metrics. It first calculates the total purchases for each period and currency, as well as the period-end accounts payable balance. The accounts payable turnover is then calculated as the ratio of total purchases to the average accounts payable balance for the period.
Possible relation with SAP Transactions
| Transaction Code | Transaction Description |
|---|---|
| FB03 | Display vendor line items |
| FBL1N | Display vendor balances |
| FBL3N | Display vendor line items with clearing information |
Data Lineage
Under Development
Table/View Fields
| Field | Field Description | Description in SAP Dictionary (Comming soon) |
|---|---|---|
| AccountsPayable.Client_MANDT | Client number | |
| AccountsPayable.CompanyCode_BUKRS | Company code | |
| AccountsPayable.CompanyText_BUTXT | Company name | |
| AccountsPayable.AccountNumberOfVendorOrCreditor_LIFNR | Vendor or creditor account number | |
| AccountsPayable.NAME1 | Vendor or creditor name | |
| AccountsPayable.AccountingDocumentNumber_BELNR | Accounting document number | |
| AccountsPayable.NumberOfLineItemWithinAccountingDocument_BUZEI | Line item number within accounting document | |
| AccountsPayable.PostingDateInTheDocument_BUDAT | Posting date in the document | |
| AccountsPayable.AccountingDocumenttype_BLART | Accounting document type | |
| AccountsPayable.AmountInLocalCurrency_DMBTR | Amount in local currency | |
| AccountsPayable.AmountInTargetCurrency_DMBTR | Amount in target currency | |
| AccountsPayable.CurrencyKey_WAERS | Currency key | |
| AccountsPayable.TargetCurrency_TCURR | Target currency | |
| AccountsPayable.DocFiscPeriod | Document fiscal period | |
| AccountsPayable.TotalPurchasesInSourceCurrency | Total purchases in source currency | |
| AccountsPayable.TotalPurchasesInTargetCurrency | Total purchases in target currency | |
| AccountsPayable.PeriodAPInSourceCurrency | Period AP in source currency | |
| AccountsPayable.PeriodAPInTargetCurrency | Period AP in target currency | |
| AccountsPayable.ClosingAPInSourceCurrency | Closing AP in source currency | |
| AccountsPayable.ClosingAPInTargetCurrency | Closing AP in target currency | |
| OpeningAPInSourceCurrency | Opening AP in source currency | |
| AccountsPayableTurnoverInSourceCurrency | Accounts payable turnover in source currency | |
| AccountsPayableTurnoverInTargetCurrency | Accounts payable turnover in target currency |