CustomerOpenItems_BSID
Source SQL File - Google Cloud Cortex Data Foundation
Google Cloud Cortex Foudantion - Cortex Reporting - (s4) - CustomerOpenItems_BSID
Overview
The CustomerOpenItems_BSID view provides a comprehensive view of open items for customer accounting in SAP systems. It combines data from the BKPF and BSEG tables to provide detailed information about accounting documents, line items, and open item balances.
Data Sources
| Source Table/View | Description |
|---|---|
| BKPF | Accounting Document Header Table |
| BSEG | Accounting Document Line Item Table |
Key Use Cases
- Analyze customer open items and balances
- Identify overdue invoices and payments
- Reconcile customer accounts
- Generate reports on customer aging and payment history
- Support financial analysis and decision-making
Query Logic
The view is created using a left outer join between the BKPF and BSEG tables, filtered to include only line items with a transaction type of 'D' (debit) and no clearing document number (AUGBL). The query also excludes line items with a deletion flag (H_BSTAT) of 'D' or 'M' in the BSEG table.
Possible relation with SAP Transactions
| Transaction Code | Transaction Description |
|---|---|
| FBL5N | Display Line Items: Customer Line Items |
| FBL1N | Display Line Items: Line Item List |
| FD10N | Maintain Customer Master Data |
| VA01 | Create Sales Order: Initial Screen |
| VF01 | Create Invoice: Initial Screen |
Data Lineage
Under Development
Table/View Fields
| Field | Field Description | Description in SAP Dictionary (Comming soon) |
|---|---|---|
| Client_MANDT | Client | |
| LanguageKey_SPRAS | Language Key | |
| SpecialStockIndicator_SOBKZ | Special Stock Indicator | |
| DescriptionOfSpecialStock_SOTXT | Description of Special Stock |