AccountingDocumentsReceivable
Source SQL File - Google Cloud Cortex Data Foundation
Google Cloud Cortex Foudantion - Cortex Reporting - (s4) - AccountingDocumentsReceivable
Overview
This reporting view provides a comprehensive overview of accounting documents for SAP systems. It combines data from the AccountingDocuments, CustomersMD, and CompaniesMD tables to provide insights into customer transactions, company information, and fiscal periods.
Data Sources
| Source Table/View | Description |
|---|---|
| AccountingDocuments | Contains detailed information about accounting documents, including document numbers, line items, currencies, and posting dates. |
| CustomersMD | Provides customer master data, such as customer numbers, names, addresses, and country keys. |
| CompaniesMD | Contains company-specific information, including company codes, company names, fiscal year variants, and country and city details. |
Key Use Cases
- Analyzing customer receivables and aging reports.
- Monitoring open and overdue invoices.
- Identifying trends in customer payment behavior.
- Performing financial analysis and reporting.
Query Logic
The query retrieves accounting document data and joins it with customer and company master data. It calculates fiscal periods and current periods using custom SQL functions and applies filters to include only documents with a specific account type.
Possible relation with SAP Transactions
| Transaction Code | Transaction Description |
|---|---|
| FBL5N | Display Line Items: Display line items for a specific accounting document. |
| FBL1N | Display Documents: Display accounting documents based on various selection criteria. |
| FD03 | Display Customer Master Data: View and edit customer master data. |
Data Lineage
Under Development
Table/View Fields
| Field | Field Description | Description in SAP Dictionary (Comming soon) |
|---|---|---|
| AccountingDocuments.Client_MANDT | Client ID | |
| AccountingDocuments.ExchangeRateType_KURST | Exchange rate type | |
| AccountingDocuments.CompanyCode_BUKRS | Company code | |
| CompaniesMD.CompanyText_BUTXT | Company name | |
| AccountingDocuments.CustomerNumber_KUNNR | Customer number | |
| AccountingDocuments.FiscalYear_GJAHR | Fiscal year | |
| CustomersMD.NAME1_NAME1 | Customer name | |
| CompaniesMD.Country_LAND1 | Company country | |
| CompaniesMD.CityName_ORT01 | Company city | |
| CustomersMD.CountryKey_LAND1 | Customer country key | |
| CustomersMD.City_ORT01 | Customer city | |
| AccountingDocuments.AccountingDocumentNumber_BELNR | Accounting document number | |
| AccountingDocuments.NumberOfLineItemWithinAccountingDocument_BUZEI | Number of line item within accounting document | |
| AccountingDocuments.CurrencyKey_WAERS | Currency key | |
| AccountingDocuments.LocalCurrency_HWAER | Local currency | |
| CompaniesMD.FiscalyearVariant_PERIV | Fiscal year variant | |
| Period | Fiscal period | |
| Current_Period | Current fiscal period | |
| AccountingDocuments.AccountType_KOART | Account type | |
| AccountingDocuments.PostingDateInTheDocument_BUDAT | Posting date in the document | |
| AccountingDocuments.DocumentDateInDocument_BLDAT | Document date in document | |
| AccountingDocuments.InvoiceToWhichTheTransactionBelongs_REBZG | Invoice to which the transaction belongs | |
| AccountingDocuments.BillingDocument_VBELN | Billing document | |
| AccountingDocuments.WrittenOffAmount_DMBTR | Written off amount | |
| AccountingDocuments.BadDebt_DMBTR | Bad debt | |
| AccountingDocuments.netDueDateCalc | Net due date | |
| AccountingDocuments.sk2dtCalc | Cash discount date 1 | |
| AccountingDocuments.sk1dtCalc | Cash discount date 2 | |
| AccountingDocuments.OpenAndNotDue | Open and not due | |
| AccountingDocuments.ClearedAfterDueDate | Cleared after due date | |
| AccountingDocuments.ClearedOnOrBeforeDueDate | Cleared on or before due date | |
| AccountingDocuments.OpenAndOverDue | Open and overdue | |
| AccountingDocuments.DoubtfulReceivables | Doubtful receivables | |
| AccountingDocuments.DaysInArrear | Days in arrear | |
| AccountingDocuments.AccountsReceivable | Accounts receivable | |
| AccountingDocuments.Sales | Sales |