- Home
- Resources
- SAP Tables
- BSPL_GRID_FIELDCAT - Field Catalog for Financial Statement Reporting with ALV
SAP Table BSPL_GRID_FIELDCAT
Field Catalog for Financial Statement Reporting with ALV
BSPL_GRID_FIELDCAT (Field Catalog for Financial Statement Reporting with ALV) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link BSPL_GRID_FIELDCAT to other SAP tables.
Source: BSPL_GRID_FIELDCAT (Field Catalog for Financial Statement Reporting with ALV)
BSPL_GRID_FIELDCAT table fields
| Field |
Data element |
Checktable |
Datatype |
Length |
Decimals |
|
| ID |
Internal: Node ID |
SEU_ID |
|
NUMC |
|
6 |
0 |
|
| SUBID |
Internal: Node ID |
SEU_ID |
|
NUMC |
|
6 |
0 |
|
| NPAGE |
Fin. Statement: Controls page break when using ALV classic |
BSPL_NPAGE |
|
NUMC |
|
5 |
0 |
|
| TLEVEL |
Hierarchy Level for Financial Statements |
BSPL_TLEVEL |
|
NUMC |
|
2 |
0 |
|
| ERGSL |
Financial Statement Item |
ERGSL |
|
CHAR |
|
10 |
0 |
|
| TEXT |
Text for B/S P&L item |
BSPL_TEXT |
|
CHAR |
|
65 |
0 |
|
| KTOPL |
Chart of Accounts |
KTOPL |
T004
|
CHAR |
|
4 |
0 |
|
| RACCT |
Account Number |
RACCT |
SKA1
|
CHAR |
|
10 |
0 |
|
| KKTPL |
Group Chart of Accts |
KKTPL |
T004
|
CHAR |
|
4 |
0 |
|
| BILKT |
Group Account Number |
BILKT |
SKA1
|
CHAR |
|
10 |
0 |
|
| KTOP2 |
Chart of Accounts According to Country Legislation |
KTOP2 |
T004
|
CHAR |
|
4 |
0 |
|
| ALTKT |
Alternative account number in company code |
ALTKT_SKB1 |
SKA1
|
CHAR |
|
10 |
0 |
|
| RBUKRS |
Company Code |
BUKRS |
T001
|
CHAR |
|
4 |
0 |
|
| RBUSA |
Business Area |
GSBER |
TGSB
|
CHAR |
|
4 |
0 |
|
| RFAREA |
Functional Area |
FKBER |
TFKB
|
CHAR |
|
16 |
0 |
|
| RYEAR |
Fiscal Year |
GJAHR |
|
NUMC |
|
4 |
0 |
|
| POPER |
Posting period |
POPER |
|
NUMC |
|
3 |
0 |
|
| CURTP |
Currency Type for Sales Segments |
ALLGCRTP |
|
CHAR |
|
2 |
0 |
Possible values
| 00 |
Document currency |
| 10 |
Company code currency |
| 11 |
Company code currency, group valuation |
| 12 |
Company code currency, profit center valuation |
| 20 |
Controlling area currency |
| 30 |
Group currency |
| 31 |
Group currency, group valuation |
| 32 |
Group currency, profit center valuation |
| 40 |
Hard currency |
| 50 |
Index-based currency |
| 60 |
Global company currency |
| 70 |
Controlling object currency |
| 71 |
Controlling object currency, group valuation |
| 72 |
Controlling object currency, profit center valuation |
| 80 |
Ledger currency |
| 81 |
Ledger currency, group valuation |
| 82 |
Ledger currency, profit center valuation |
| 90 |
Profit center invoice currency |
| 92 |
Profit center accounting currency, profit center valuation |
| A0 |
Financial management area currency |
| B0 |
Operating concern currency |
| B2 |
Operating concern currency, profit center valuation |
| C0 |
Consolidation unit currency |
| C1 |
Consolidation unit currency, group valuation |
| C2 |
Consolidation unit currency, profit center valuation |
|
| WAERS |
Currency Key |
WAERS |
TCURC
|
CUKY |
|
5 |
0 |
|
| REPVAL |
Total of Reporting Period |
BSPL_REPVAL |
|
CURR |
|
17 |
2 |
|
| COMPVAL |
Total of the Comparison Period |
BSPL_COMPVAL |
|
CURR |
|
17 |
2 |
|
| ABSVAR |
Absolute difference |
BSPL_VARIANCE_ABSOLUTE |
|
CURR |
|
17 |
2 |
|
| RELVAR |
Percentage difference |
BSPL_VARIANCE_RELATIVE |
|
CHAR |
|
10 |
0 |
|
| LINE_COLOR |
ALV: info column (definition of line color) |
BSPL_ALV_LINE_COLOR |
|
CHAR |
|
3 |
0 |
|
| CELL_COLOR |
|
SHP_SLIS_T_SPECIALCOL_ALV |
|
TTYP |
|
0 |
0 |
|
| TOTALS_LEVEL |
Summary Report |
BILASUMM |
|
CHAR |
|
2 |
0 |
Possible values
| NULL |
Balance Sheet with Accounts |
| 00 |
Balance Sheet Without Accounts |
| 01 |
Summary Report at Specified Hierarchy Level |
| 10 |
Summary Report at Specified Hierarchy Level |
| 20 |
Summary Report at Specified Hierarchy Level |
| 30 |
Summary Report at Specified Hierarchy Level |
| 40 |
Summary Report at Specified Hierarchy Level |
| 50 |
Summary Report at Specified Hierarchy Level |
| 60 |
Summary Report at Specified Hierarchy Level |
| 70 |
Summary Report at Specified Hierarchy Level |
| 80 |
Summary Report at Specified Hierarchy Level |
| 90 |
Summary Report at Specified Hierarchy Level |
|
BSPL_GRID_FIELDCAT foreign key relationships
| Table |
Field |
Foreign key table |
Foreign key field |
Check table |
Check field |
| BSPL_GRID_FIELDCAT |
ALTKT |
SYST |
MANDT |
SKA1 |
G/L Account Master (Chart of Accounts) |
MANDT |
| BSPL_GRID_FIELDCAT |
ALTKT |
BSPL_GRID_FIELDCAT |
KTOPL |
SKA1 |
G/L Account Master (Chart of Accounts) |
KTOPL |
| BSPL_GRID_FIELDCAT |
ALTKT |
BSPL_GRID_FIELDCAT |
ALTKT |
SKA1 |
G/L Account Master (Chart of Accounts) |
SAKNR |
| BSPL_GRID_FIELDCAT |
BILKT |
SYST |
MANDT |
SKA1 |
G/L Account Master (Chart of Accounts) |
MANDT |
| BSPL_GRID_FIELDCAT |
BILKT |
BSPL_GRID_FIELDCAT |
KTOPL |
SKA1 |
G/L Account Master (Chart of Accounts) |
KTOPL |
| BSPL_GRID_FIELDCAT |
BILKT |
BSPL_GRID_FIELDCAT |
BILKT |
SKA1 |
G/L Account Master (Chart of Accounts) |
SAKNR |
| BSPL_GRID_FIELDCAT |
KKTPL |
BSPL_GRID_FIELDCAT |
KKTPL |
T004 |
Directory of Charts of Accounts |
KTOPL |
| BSPL_GRID_FIELDCAT |
KKTPL |
SYST |
MANDT |
T004 |
Directory of Charts of Accounts |
MANDT |
| BSPL_GRID_FIELDCAT |
KTOP2 |
BSPL_GRID_FIELDCAT |
KTOP2 |
T004 |
Directory of Charts of Accounts |
KTOPL |
| BSPL_GRID_FIELDCAT |
KTOP2 |
SYST |
MANDT |
T004 |
Directory of Charts of Accounts |
MANDT |
| BSPL_GRID_FIELDCAT |
KTOPL |
BSPL_GRID_FIELDCAT |
KTOPL |
T004 |
Directory of Charts of Accounts |
KTOPL |
| BSPL_GRID_FIELDCAT |
KTOPL |
SYST |
MANDT |
T004 |
Directory of Charts of Accounts |
MANDT |
| BSPL_GRID_FIELDCAT |
RACCT |
BSPL_GRID_FIELDCAT |
KTOPL |
SKA1 |
G/L Account Master (Chart of Accounts) |
KTOPL |
| BSPL_GRID_FIELDCAT |
RACCT |
BSPL_GRID_FIELDCAT |
RACCT |
SKA1 |
G/L Account Master (Chart of Accounts) |
SAKNR |
| BSPL_GRID_FIELDCAT |
RACCT |
SYST |
MANDT |
SKA1 |
G/L Account Master (Chart of Accounts) |
MANDT |
| BSPL_GRID_FIELDCAT |
RBUKRS |
SYST |
MANDT |
T001 |
Company Codes |
MANDT |
| BSPL_GRID_FIELDCAT |
RBUKRS |
BSPL_GRID_FIELDCAT |
RBUKRS |
T001 |
Company Codes |
BUKRS |
| BSPL_GRID_FIELDCAT |
RBUSA |
BSPL_GRID_FIELDCAT |
RBUSA |
TGSB |
Business Areas |
GSBER |
| BSPL_GRID_FIELDCAT |
RBUSA |
SYST |
MANDT |
TGSB |
Business Areas |
MANDT |
| BSPL_GRID_FIELDCAT |
RFAREA |
SYST |
MANDT |
TFKB |
Functional areas |
MANDT |
| BSPL_GRID_FIELDCAT |
RFAREA |
BSPL_GRID_FIELDCAT |
RFAREA |
TFKB |
Functional areas |
FKBER |
| BSPL_GRID_FIELDCAT |
WAERS |
SYST |
MANDT |
TCURC |
Currency Codes |
MANDT |
| BSPL_GRID_FIELDCAT |
WAERS |
BSPL_GRID_FIELDCAT |
WAERS |
TCURC |
Currency Codes |
WAERS |
