CustomerOpenItems_BSID
Source SQL File - Google Cloud Cortex Data Foundation
Google Cloud Cortex Foudantion - Cortex Reporting - (ecc) - CustomerOpenItems_BSID
Overview
This view is a reporting view for SAP systems that provides detailed information about accounting documents and their line items. It combines data from the BKPF and BSEG tables to provide a comprehensive view of accounting transactions.
Data Sources
| Source Table/View | Description |
|---|---|
| BKPF | Accounting Document Header Table |
| BSEG | Accounting Document Line Item Table |
Key Use Cases
- Can be used to analyze accounting data for a specific period or range of periods.
- Can be used to drill down into the details of individual accounting documents and line items.
- Can be used to generate reports on accounting activity, such as balance sheets and income statements.
- Can be used to identify trends and patterns in accounting data.
Query Logic
The view is created using a left outer join between the BKPF and BSEG tables. The join condition is on the MANDT, BUKRS, GJAHR, and BELNR fields. This ensures that all accounting documents and their corresponding line items are included in the view.
Possible relation with SAP Transactions
| Transaction Code | Transaction Description |
|---|---|
| FB03 | Display Document |
| FB50 | Post Document |
| FBL1N | Document List |
| FBL3N | Line Item List |
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 |