SQL Server administration and T-SQL development, Web Programming with ASP.NET, HTML5 and Javascript, Windows Phone 8 app development, SAP Smartforms and ABAP Programming, Windows 7, Visual Studio and MS Office software
Development resources, articles, tutorials, code samples, tools and downloads for SAP HANA and ABAP, HANA Database, SQLScript, SAP UI5, Screen Personas, Web Dynpro, Workflow

SAP Currency Table for Currency Text in ABAP Development

I found which ABAP table is used to store SAP Currency descriptions, the SAP table TCURT Currency Code Names table.

You can search for currency description in TCURT Currency Code Names SAP table with SPRAS Language Key and WAERS Currency Key like below.
I used below ABAP SELECT statement from TCURT currencies table for an SAP Invoice Smartforms output in order to display currency text of a given currency code parameter.

SELECT ktext
 INTO TABLE lt_ktext
  spras = 'IT' AND
  waers = is_bil_invoice-hd_gen-bil_waerk.

If you are looking for more detail about SAP Currency table or SAP tables related with currency you can use SAP transaction SE11.
Type "TCUR*" in the "Database table" search parameter input area and request help using F4.


Here is the currency tables list of search results in SAP transaction SE11 for ABAP currency table and currency related tables.

TCURBExchange Rate Calculation Indicator
TCURCCurrency Codes
TCURC_ROUNDClearing of Rounding Diffs per Local Curre
TCURDMax.Exch.Rate Differences for Postings in
TCUREExpiring Currencies
TCUREFCObject Characteristics - Supported IPC Sce
TCURFConversion Factors
TCURKCurrency Code Table Supplements
TCURLLeading Currency
TCURMCustomizing: MM Configuration
TCUROObject Type for Expiring Currencies
TCUROTText Table for Objects for Expiring Curren
TCURPDirect/Indirect Quotation Prefixes for Exc
TCURRExchange Rates
TCURSRate Spreads
TCURTCurrency Code Names
TCURUSuperuser for Expiring Currencies
TCURVExchange rate types for currency translati
TCURWUsage of Exchange Rate Types
TCURWKDATLast Maintenance of a Worklist
TCURWKRTSExch.rate maint: Assign exch. rates to wor
TCURWKSETExch.rate maint: Work list
TCURWKSETTTexts for Worklists
TCURXDecimal Places in Currencies
TCURYWarning Period for Expiring Currencies
TCURY1Reasons for Expiring Currencies
TCURY1TTexts for Expiry Reasons


Install SAP Free
CRM Companies List
Web Based CRM Software

Copyright © 2004 - 2021 Eralper YILMAZ. All rights reserved.