Table Name

[Former Member]

Hi Gurus,

Plz. let me know that from where i can take these values---

1. AUFNR -

---

Order Number

2. WRGBTR -

---

Total Value in Report Currency

I want a table who stores both field values...

Note:.I don't want structure name, i need table name...

Thanks...

[Former Member]

Hi,

Check Table AUFK.

Regards,

Sachin Bhatnagar.

[former_member188827]

AUFK: for order number

[Former Member]

hi,

Check AUFK table

regards,

Santosh

[former_member188827]

aufm: for amount in local curreny(dmbtr).

u can use exchange rate 2 convert dis amount into ny desired currency

[Former Member]

There is not table like you searching. WRGBTR is calculated variable and it's not stored in data-base tables.

[Former Member]

Hi,

both the fields are stored in different tables.

aufnr stored in AUFK,VBAP,VBAK etc.,

WRGBTR stored in KAEP_CM,

KAEP_CM_RC,

KAEP_COAC,

KAEP_COEP_RC,

KAEP_COEP_X.

you can search the table fields in the TABLE DD03L.

Regards,

vineela.

[Former Member]

Hi Prince Kumar

The Field AUFNR and WRGBTR,

AUFNR relates with FI

WRGBTR relates with Asset..

AM-Co-FI.. Through This way there could be some possiblility of Interlinking your requirement..

ANLE and AUFK are the tables your field resides you can interlink them i think.. take a look on these tables..

Reward Points if its useful..

[Former Member]

Hi,

Plz tell me that which field is common in both tables (ANLE and AUFK)...

Thanks...

[Former Member]

Hi

Common field is BUKRS

regards

Shiva

[Former Member]

Hi,

U r right, BUKRS is the common field in both tables....ANLE and AUFK...

But now my problem is that there is no value in ANLE Table...

Plz Tell...

Thanks...

[Former Member]

Hi

use QALS as intermidiate table and

select ANLE then pass the GJAHR ANL1 ANL2 BUKRS to QALS get the LIFNR and use the LIFNR to get the AUFK values

Regards

Shiva

[Former Member]

Hi

1.you open transaction code se84.

2.you find abap-dictionary.expand that.

3.you find fields.expand that.

4.you find table fields,structure fields.click on any one of these two.then give your field name(for example AUFNR) and execute you got all the tables consisting of that field.

[Former Member]

Hi,

U can fine both the fields AUFNR and WRGBTR in the below given tables:

KAEP_CM = Field List: Commitment Line Items

KAEP_COAC = Field List: Line Item Report for Actual Costs

KAEP_COEP_X = Item Field List: Actual Cost Line Item Report

Regards,

kavitha.

[Former Member]

Hi

use AFKO for AUFNR which header table for PP orders

Regards

Shiva