SE11 ABAP Dictionary SE11 TCURC

Data SE16 SE16

TCURC

Currency Codes
SAP SAP Transparent Table 6 Fields
Primary Key:
MANDT WAERS

Dictionary Fields Fields

(6 dari 6 kolom)
# 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.