SAP Table TKEL

CO-PA ledger

TKEL (CO-PA ledger) 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 TKEL to other SAP tables.

TKEL table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
PALEDGER Currency type for an operating concern LEDBO CHAR 2 0
CURTP Currency Type and Valuation View CURTP CHAR 2 0
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
PERFLAG Period-type indicator PERFLAG CHAR 1 0
1 Periods according to fiscal year variant
2 Calendar weeks
NULL
PERIV Fiscal Year Variant PERIV T009 CHAR 2 0
PERFLAG2 Alternative period type indicator PERFLAG2 CHAR 1 0
2 Calendar weeks
PERIV2 Fiscal year variant for alternative period type PERIV2 T009 CHAR 2 0

TKEL foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
TKEL MANDT TKEL MANDT T000 Clients MANDT
TKEL PERIV TKEL PERIV T009 Fiscal Year Variants PERIV
TKEL PERIV TKEL MANDT T009 Fiscal Year Variants MANDT
TKEL PERIV2 TKEL MANDT T009 Fiscal Year Variants MANDT
TKEL PERIV2 TKEL PERIV2 T009 Fiscal Year Variants PERIV
TKEL WAERS TKEL MANDT TCURC Currency Codes MANDT
TKEL WAERS TKEL WAERS TCURC Currency Codes WAERS