TFK000BI SAP (Central Settings for BI Extractions) Table details
Description: Central Settings for BI Extractions
Table field list including key, data, relationships and ABAP select examples
TFK000BI is a standard SAP Table which is used to store Central Settings for BI Extractions data and is available within R/3 SAP systems depending on the version and release level.
The TFK000BI table consists of various fields, each holding specific information or linking keys about Central Settings for BI Extractions data available in SAP. These include XBWDE (Delta Extraction for Business Partner Items Is Active), XBWAB (Extraction of Write-Off Reason Is Active), XBWDE_MAKO (Delta Extraction for Dunning Headers Active), XBWDE_MAZE (Delta Extraction for Dunning Items Active).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: C - Customising table, maintenance only by custDisplay/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type)
SAP TFK000BI table fields - Full list of fields found in SAP data dictionary
| Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
| MANDT | Client | MANDT | CLNT | 3 | Assigned to domain | MANDT | |||
| XBWDE | Delta Extraction for Business Partner Items Is Active | XBWDE_KK | CHAR | 1 | XFELD | ||||
| XBWAB | Extraction of Write-Off Reason Is Active | XBWAB_KK | CHAR | 1 | XFELD | ||||
| XBWDE_MAKO | Delta Extraction for Dunning Headers Active | XBWDE_MAKO_KK | CHAR | 1 | XFELD | ||||
| XBWDE_MAZE | Delta Extraction for Dunning Items Active | XBWDE_MAZE_KK | CHAR | 1 | XFELD | ||||
| XBWDE_MACT | Delta Extraction for Dunning Activities Active | XBWDE_MACT_KK | CHAR | 1 | XFELD | ||||
| XBWEN_RDI | Delta Extraction for Revenue Distribution Active | XBWEN_RDI_KK | CHAR | 1 | XFELD | ||||
| XBWEN_RET | Delta Extraction for Returns Active | XBWEN_RET_KK | CHAR | 1 | XFELD | ||||
| XBWEN_PAY | Delta Extraction for Payments Active | XBWEN_PAY_KK | CHAR | 1 | XFELD | ||||
| XBWEN_WLI | Delta Extraction for Work Items Active | XBWEN_WLI_KK | CHAR | 1 | XFELD | ||||
| XBWEN_PP | Delta Extraction for Promise to Pay Header | XBWEN_PP_KK | CHAR | 1 | XFELD | ||||
| XBWEN_PPD | Delta Extraction for Amount Due Per Payment Date | XBWEN_PPD_KK | CHAR | 1 | XFELD | ||||
| XBWEN_WLIA1 | Delta Extraction for Collection Work Items | XBWEN_WLIA1_KK | CHAR | 1 | XFELD | ||||
| XBWEN_WLIA2 | Delta Extraction for Disconnection/Reconnection Notification | XBWEN_WLIA2_KK | CHAR | 1 | XFELD |
| Key field | Non-key field |
How do I retrieve data from SAP table TFK000BI using ABAP code
The following ABAP code Example will allow you to do a basic selection on TFK000BI to SELECT all data from the tableDATA: WA_TFK000BI TYPE TFK000BI.
SELECT SINGLE *
FROM TFK000BI
INTO CORRESPONDING FIELDS OF WA_TFK000BI
WHERE...
How to access SAP table TFK000BI
Within an ECC or HANA version of SAP you can also view further information about TFK000BI and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects