SAP table BSPL_GRID_FIELDCAT (Field Catalog for Financial Statement Reporting with ALV)
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |
|---|---|---|---|---|---|---|---|
| ID | Internal: Node ID | NUMC | 6 | 0 | SEU_ID | ||
| SUBID | Internal: Node ID | NUMC | 6 | 0 | SEU_ID | ||
| NPAGE | Fin. Statement: Controls Page Break When Using ALV Classic | NUMC | 5 | 0 | BSPL_NPAGE | ||
| TLEVEL | Hierarchy Level for Financial Statements | NUMC | 2 | 0 | BSPL_TLEVEL | ||
| ERGSL | Financial Statement Item | CHAR | 10 | 0 | ERGSL | ||
| TEXT | Text for B/S P&L Item | CHAR | 65 | 0 | BSPL_TEXT | ||
| KTOPL | Chart of Accounts | CHAR | 4 | 0 | T004 | KTOPL | |
| RACCT | Account Number | CHAR | 10 | 0 | SKA1 | RACCT | |
| KKTPL | Group Chart of Accts | CHAR | 4 | 0 | T004 | KKTPL | |
| BILKT | Group Account Number | CHAR | 10 | 0 | SKA1 | BILKT | |
| KTOP2 | Alternative Chart of Accounts | CHAR | 4 | 0 | T004 | KTOP2 | |
| ALTKT | Alternative Account Number in Company Code | CHAR | 10 | 0 | SKA1 | ALTKT_SKB1 | |
| RBUKRS | Company Code | CHAR | 4 | 0 | T001 | BUKRS | |
| RBUSA | Business Area | CHAR | 4 | 0 | TGSB | GSBER | |
| RFAREA | Functional Area | CHAR | 16 | 0 | TFKB | FKBER | |
| RYEAR | Fiscal Year | NUMC | 4 | 0 | GJAHR | ||
| POPER | Posting period | NUMC | 3 | 0 | POPER | ||
| CURTP | Currency Type for Sales Segments | CHAR | 2 | 0 | ALLGCRTP | ||
| WAERS | Currency Key | CUKY | 5 | 0 | TCURC | WAERS | |
| REPVAL | Total of Reporting Period | CURR | 23 | 2 | BSPL_REPVAL | ||
| COMPVAL | Total of the Comparison Period | CURR | 23 | 2 | BSPL_COMPVAL | ||
| ABSVAR | Absolute Difference | CURR | 23 | 2 | BSPL_VARIANCE_ABSOLUTE | ||
| RELVAR | Percentage Difference | CHAR | 10 | 0 | BSPL_VARIANCE_RELATIVE | ||
| RELVAR_D | Percentage Difference (Numeric) | DEC | 31 | 1 | BSPL_VARIANCE_RELATIVE_D | ||
| LINE_COLOR | ALV: Info Column (Definition of Line Color) | CHAR | 3 | 0 | BSPL_ALV_LINE_COLOR | ||
| CELL_COLOR | TTYP | 0 | 0 | SHP_SLIS_T_SPECIALCOL_ALV | |||
| TOTALS_LEVEL | Summary Report | CHAR | 2 | 0 | BILASUMM |
BSPL_GRID_FIELDCAT foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 BSPL_GRID_FIELDCAT | ALTKT | SKA1 | G/L Account Master (Chart of Accounts) | MANDT |
| 0 BSPL_GRID_FIELDCAT | ALTKT | SKA1 | G/L Account Master (Chart of Accounts) | KTOPL |
| 0 BSPL_GRID_FIELDCAT | ALTKT | SKA1 | G/L Account Master (Chart of Accounts) | SAKNR |
| 1 BSPL_GRID_FIELDCAT | BILKT | SKA1 | G/L Account Master (Chart of Accounts) | MANDT |
| 1 BSPL_GRID_FIELDCAT | BILKT | SKA1 | G/L Account Master (Chart of Accounts) | KTOPL |
| 1 BSPL_GRID_FIELDCAT | BILKT | SKA1 | G/L Account Master (Chart of Accounts) | SAKNR |
| 0 BSPL_GRID_FIELDCAT | KKTPL | T004 | Directory of Charts of Accounts | MANDT |
| 0 BSPL_GRID_FIELDCAT | KKTPL | T004 | Directory of Charts of Accounts | KTOPL |
| 1 BSPL_GRID_FIELDCAT | KTOP2 | T004 | Directory of Charts of Accounts | MANDT |
| 0 BSPL_GRID_FIELDCAT | KTOPL | T004 | Directory of Charts of Accounts | MANDT |
| 1 BSPL_GRID_FIELDCAT | RACCT | SKA1 | G/L Account Master (Chart of Accounts) | MANDT |
| 1 BSPL_GRID_FIELDCAT | RACCT | SKA1 | G/L Account Master (Chart of Accounts) | KTOPL |
| 1 BSPL_GRID_FIELDCAT | RACCT | SKA1 | G/L Account Master (Chart of Accounts) | SAKNR |
| 0 BSPL_GRID_FIELDCAT | RBUKRS | T001 | Company Codes | BUKRS |
| 1 BSPL_GRID_FIELDCAT | RBUSA | TGSB | Business Areas | MANDT |
| 1 BSPL_GRID_FIELDCAT | RBUSA | TGSB | Business Areas | GSBER |
| 0 BSPL_GRID_FIELDCAT | RFAREA | TFKB | Functional areas | FKBER |
| 1 BSPL_GRID_FIELDCAT | WAERS | TCURC | Currency Codes | MANDT |
| 1 BSPL_GRID_FIELDCAT | WAERS | TCURC | Currency Codes | WAERS |