AccountsPayableTurnover
Source SQL File - Google Cloud Cortex Data Foundation
Google Cloud Cortex Foudantion - Cortex Reporting - (s4) - AccountsPayableTurnover
Overview
This view provides a comprehensive analysis of Accounts Payable (AP) data, including key metrics such as total purchases, period AP, unpaid period AP, closing AP, and AP turnover. It allows users to analyze AP trends over time and across different dimensions such as company code, vendor, and currency.
Data Sources
| Source Table/View | Description |
|---|---|
| AccountsPayable | This table contains detailed information about accounts payable transactions, including invoice data, payment data, and vendor information. |
Key Use Cases
- Monitoring AP performance and identifying areas for improvement.
- Analyzing vendor payment patterns and identifying potential risks.
- Providing insights for financial planning and forecasting.
- Supporting decision-making related to vendor management and payment strategies.
Query Logic
The view is created using a series of subqueries and calculations. The subqueries are used to calculate the total purchases, period AP, unpaid period AP, and closing AP. The calculations are then used to derive the AP turnover ratios.
Possible relation with SAP Transactions
| Transaction Code | Transaction Description |
|---|---|
| FB03 | Display Document |
| FBL1N | Line Item Display: G/L Account |
| FBL3N | Line Item Display: Document |
Data Lineage
Under Development
Table/View Fields
| Field | Field Description | Description in SAP Dictionary (Comming soon) |
|---|---|---|
| Client_MANDT | Client number | |
| CompanyCode_BUKRS | Company code | |
| CompanyText_BUTXT | Company name | |
| AccountNumberOfVendorOrCreditor_LIFNR | Vendor or creditor account number | |
| NAME1 | Vendor or creditor name | |
| AccountingDocumentNumber_BELNR | Accounting document number | |
| NumberOfLineItemWithinAccountingDocument_BUZEI | Line item number within accounting document | |
| PostingDateInTheDocument_BUDAT | Posting date in the document | |
| AccountingDocumenttype_BLART | Accounting document type | |
| AmountInLocalCurrency_DMBTR | Amount in local currency | |
| AmountInTargetCurrency_DMBTR | Amount in target currency | |
| CurrencyKey_WAERS | Currency key | |
| TargetCurrency_TCURR | Target currency | |
| DocFiscPeriod | Document fiscal period | |
| TotalPurchasesInSourceCurrency | Total purchases in source currency | |
| TotalPurchasesInTargetCurrency | Total purchases in target currency | |
| OpeningAPInSourceCurrency | Opening accounts payable in source currency | |
| OpeningAPInTargetCurrency | Opening accounts payable in target currency | |
| PeriodAPInSourceCurrency | Period accounts payable in source currency | |
| PeriodAPInTargetCurrency | Period accounts payable in target currency | |
| ClosingAPInSourceCurrency | Closing accounts payable in source currency | |
| ClosingAPInTargetCurrency | Closing accounts payable in target currency | |
| AccountsPayableTurnoverInSourceCurrency | Accounts payable turnover in source currency | |
| AccountsPayableTurnoverInTargetCurrency | Accounts payable turnover in target currency |