DB_TKA01_TKA02 SAP (Generated Table for View) Table View details
Dictionary Type: Table View
Description: Generated Table for View
Description: Generated Table for View
ABAP Code to SELECT data from DB_TKA01_TKA02
Related tables to DB_TKA01_TKA02
Access table DB_TKA01_TKA02
Related tables to DB_TKA01_TKA02
Access table DB_TKA01_TKA02
Table View field list including key, data, relationships and ABAP select examples
DB_TKA01_TKA02 is a standard SAP Table View which is used to store Generated Table for View data and is available within R/3 SAP systems depending on the version and release level.
The DB_TKA01_TKA02 table consists of various fields, each holding specific information or linking keys about Generated Table for View data available in SAP. These include KOKRS (Controlling Area), BEZEI (Name of the controlling area), WAERS (Currency Key), KTOPL (Chart of Accounts).. 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:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified
SAP DB_TKA01_TKA02 table view 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 | T000 | MANDT | |||
KOKRS | Controlling Area | KOKRS | CHAR | 4 | CACCD | CAC | |||
BEZEI | Name of the controlling area | BEZEI | CHAR | 25 | TEXT25 | ||||
WAERS | Currency Key | WAERS | CUKY | 5 | TCURC | WAERS | FWS | ||
KTOPL | Chart of Accounts | KTOPL | CHAR | 4 | T004 | KTOPL | KPL | C_KTOPL | |
LMONA | Fiscal Year Variant | PERIV | CHAR | 2 | T009 | PERIV | |||
KOKFI | Allocation Indicator | KOKFI | CHAR | 1 | KOKFI | ||||
LOGSYSTEM | Logical System | LOGSYSTEM | CHAR | 10 | TBDLS | ALPHA | LOGSYS | ||
ALEMT | Cost center distribution method via ALE | CO_ALEMT | CHAR | 2 | ALPHA | CO_ALEMT | |||
MD_LOGSYSTEM | Logical system for master data maintenance | MASTERDATA_LOGSYSTEM | CHAR | 10 | TBDLS | ALPHA | LOGSYS | ||
KHINR | Standard Hierarchy for Cost Centers | KSTHI | CHAR | 12 | SETNR | ||||
KOMP1 | Indicator: Revenue must be converted | KOMP1 | CHAR | 1 | CHAR1_X | ||||
KOMP0 | Productive indicator for controlling area | KOMP0 | CHAR | 1 | CHAR1_X | ||||
KOMP2 | Indicator: reserve (not used at present) | KOMP2 | CHAR | 1 | CHAR1_X | ||||
ERKRS | Operating concern | ERKRS | CHAR | 4 | TKEB | ERKRS | ERB | ||
DPRCT | Dummy Profit Center | DPRCT | CHAR | 10 | CEPC | ALPHA | PRCTR | ||
PHINR | Profit center area | PHINR | CHAR | 12 | SETNR | ||||
PCLDG | Profit center ledger | PCLDG | CHAR | 2 | T881 | ALPHA | RLDNR | ||
PCBEL | Elimination of internal bus. volume for Profit Center Acctg | PCBEL | CHAR | 1 | CHAR1_X | ||||
XWBUK | Indicator: Different Company Code Currency is Allowed | XWBUK | CHAR | 1 | XFELD | ||||
BPHINR | Standard Hierarchy Area | CO_BPHINR | CHAR | 12 | SETNR | KWH | |||
XBPALE | Indicator: ALE for active business process (process costs) | XBPALE | CHAR | 1 | XFELD | ||||
KSTAR_FIN | Cost element for vendor downpayments w/o purchase ord. ref. | KSTAR_FIN | CHAR | 10 | CSKA | ALPHA | KSTAR | ||
KSTAR_FID | Revenue type for debitor downpayments without sales ord. ref | KSTAR_FID | CHAR | 10 | CSKA | ALPHA | KSTAR | ||
PCACUR | Local Currency for Profit Center Accounting | PCACUR | CUKY | 5 | TCURC | WAERS | |||
PCACURTP | Currency type of the profit center report currency | CURTPPC | CHAR | 2 | CURTP | ||||
PCATRCUR | Store transaction currency in EC-PCA | PCATRCUR | CHAR | 1 | XFELD | ||||
CTYP | Currency Type for Controlling Area | CO_CTYP | CHAR | 2 | CURTP | ||||
RCLAC | Reconciliation Ledger Active | RCLACTIV | CHAR | 1 | RKACT | ||||
BLART | Document Type for Reconcil. Postings From Reconcil. Ledger | RCL_BLART | CHAR | 2 | T003 | BLART | BAR | ||
FIKRS | Financial Management Area | FIKRS | CHAR | 4 | FM01 | FIKRS | FIK | ||
RCL_PRIMAC | Reconciliation Ledger: Acct Determination for Primary CElms | RCL_PRIMAC | CHAR | 1 | BOOLE | ||||
PCA_ALEMT | Method for Distributing Profit Centers Using ALE | PCA_ALEMT | CHAR | 2 | ALPHA | PCA_ALEMT | |||
PCA_VALU | Valuation View | VALUTYP | NUMC | 1 | VALUTYP | VTP | |||
CVPROF | Currency and Valuation Profile | CVPROF | CHAR | 4 | TCVPROF | CVPROF | |||
CVACT | Ind.: Currency and Valuation Profile Active | CVACT | CHAR | 1 | XFELD | ||||
VNAME | Person Responsible for the Controlling Area | CO_VNAME | CHAR | 12 | USR02 | XUBNAME | |||
PCA_ACC_DIFF | Account control when transferring valuation differences | PCA_ACCOUNT_VAL_DIFF | CHAR | 1 | PCA_ACCOUNT_VAL_DIFF | ||||
TP_VALOHB | Valuation View for Calculation Base | VALUTYP_OH_BASE | NUMC | 1 | VALUTYP | ||||
DEFPRCTR | Default Profit Center for Nonassigned Processes | FAGL_DEFPRCTR | CHAR | 10 | CEPC | ALPHA | PRCTR | ||
AUTH_USE_NO_STD | Do Not Use Standard Hierarchy for Authorizations | AUTH_USE_NO_STD | CHAR | 1 | CHAR1 | ||||
AUTH_USE_ADD1 | Use First Alternative Hierarchy for Authorizations | AUTH_USE_ADD1 | CHAR | 1 | CHAR1 | ||||
AUTH_USE_ADD2 | Use Second Alternative Hierarchy for Authorizations | AUTH_USE_ADD2 | CHAR | 1 | CHAR1 | ||||
AUTH_KE_NO_STD | Do Not Use Standard Hierarchy for Authorizations | AUTH_USE_NO_STD | CHAR | 1 | CHAR1 | ||||
AUTH_KE_USE_ADD1 | Use First Alternative Hierarchy for Authorizations | AUTH_USE_ADD1 | CHAR | 1 | CHAR1 | ||||
AUTH_KE_USE_ADD2 | Use Second Alternative Hierarchy for Authorizations | AUTH_USE_ADD2 | CHAR | 1 | CHAR1 | ||||
BUKRS | Company Code | BUKRS | CHAR | 4 | T001 | BUKRS | BUK | C_T001 |
Key field | Non-key field |
How do I retrieve data from SAP table DB_TKA01_TKA02 using ABAP code
The following ABAP code Example will allow you to do a basic selection on DB_TKA01_TKA02 to SELECT all data from the tableDATA: WA_DB_TKA01_TKA02 TYPE DB_TKA01_TKA02.
SELECT SINGLE *
FROM DB_TKA01_TKA02
INTO CORRESPONDING FIELDS OF WA_DB_TKA01_TKA02
WHERE...
How to access SAP table DB_TKA01_TKA02
Within an ECC or HANA version of SAP you can also view further information about DB_TKA01_TKA02 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