DaysPayableOutstanding
Source SQL File - Google Cloud Cortex Data Foundation
Google Cloud Cortex Foudantion - Cortex Reporting - (s4) - DaysPayableOutstanding
Overview
This view calculates the Days Payable Outstanding (DPO) for a given company code and fiscal period. DPO is a measure of how long it takes a company to pay its suppliers. A higher DPO indicates that the company is taking longer to pay its suppliers, which can lead to financial penalties and damage to the company's reputation.
Data Sources
| Source Table/View | Description |
|---|---|
| AccountsPayable | Table containing the accounts payable data. |
| InventoryKeyMetrics | Table containing the inventory key metrics data. |
Key Use Cases
- Financial analysis
- Supplier management
- Working capital management
Query Logic
The view first aggregates the accounts payable data by company code, fiscal year, and fiscal period. It then calculates the total overdue amount in both the source currency and the target currency. The view also aggregates the inventory key metrics data by company code, fiscal year, and fiscal period. It then calculates the total cost of goods sold (COGS) in both the source currency and the target currency. The view finally joins the two aggregated tables on the company code, fiscal year, fiscal period, and target currency. It then calculates the DPO in both the source currency and the target currency.
Possible relation with SAP Transactions
| Transaction Code | Transaction Description |
|---|---|
| FBL1N | Display Accounts Payable Line Items |
| FBL3N | Display Accounts Payable Documents |
Data Lineage
Under Development
Table/View Fields
| Field | Field Description | Description in SAP Dictionary (Comming soon) |
|---|---|---|
| Client_MANDT | Client ID | |
| CompanyCode_BUKRS | Company Code | |
| CompanyText_BUTXT | Company Name | |
| FiscalYear | Fiscal Year | |
| FiscalPeriod | Fiscal Period | |
| TargetCurrency_TCURR | Target Currency | |
| PeriodAPInSourceCurrency | Period Accounts Payable in Source Currency | |
| PeriodAPInTargetCurrency | Period Accounts Payable in Target Currency | |
| COGSInSourceCurrency | Cost of Goods Sold in Source Currency | |
| COGSInTargetCurrency | Cost of Goods Sold in Target Currency | |
| NumberOfDays | Number of Days in Fiscal Period | |
| DaysPayableOutstandingInSourceCurrency | Days Payable Outstanding in Source Currency | |
| DaysPayableOutstandingInTargetCurrency | Days Payable Outstanding in Target Currency |