SE11 ABAP Dictionary SE11 TCURC

Popular:

VBAK VBAP MARA MAKT BKPF BSEG BVOR EKKO EKPO KNA1 LFA1 LIKP VBRK

TCURC

Currency Codes

SAP SAP Transparent Table 6 Fields

Primary Key:

MANDT WAERS

#	Field Name	Key	Field Label	Type	Length	Dec	Check Table	Short Description
1	MANDT	KEY	Client	CLNT	3	-	T000	Client
2	WAERS	KEY	Currency	CUKY	5	-	TCURC	Currency Key
3	ISOCD	-	ISO code	CHAR	3	-	-	ISO currency code
4	ALTWR	-	Alternative key for currencies	CHAR	3	-	-	Alternative key for currencies
5	GDATU	-	Valid	DATS	8	-	-	Date until which the currency is valid
6	XPRIMARY	-	Primary	CHAR	1	-	-	Primary SAP Currency Code for ISO Code

Related References & SQL

Diagram ERD, T-Code standar, tabel terkait, dan contoh query untuk TCURC.

Interactive ERD Diagrams

Belum terpasang pada pin diagram ERD.

Standard T-Codes

SE11 SE16

Related Tables

Tidak ada relasi langsung terdeteksi.

ANSI SQL Query

SELECT a.WAERS,
       a.ISOCD,
       a.ALTWR,
       a.GDATU,
       a.XPRIMARY
FROM TCURC AS a
WHERE a.WAERS = '0001';

ABAP OpenSQL (7.40+)

SELECT a~waers,
       a~isocd,
       a~altwr,
       a~gdatu,
       a~xprimary
  FROM tcurc AS a
  WHERE a~waers = '0001'
  INTO TABLE @DATA(lt_tcurc)
  UP TO 100 ROWS.

SE11 ABAP Dictionary SE11 TCURC

TCURC

Dictionary Fields Fields

Related References & SQL