topic Re: Table Name in Application Development and Automation Discussions

Table Name

Former Member — Wed, 12 Mar 2008 05:54:41 GMT

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...

Re: Table Name

Former Member — Wed, 12 Mar 2008 05:56:36 GMT

Hi,

Check Table AUFK.

Regards,

Sachin Bhatnagar.

Re: Table Name

former_member188827 — Wed, 12 Mar 2008 05:57:27 GMT

AUFK: for order number

Re: Table Name

Former Member — Wed, 12 Mar 2008 05:57:51 GMT

hi,

Check AUFK table

regards,

Santosh

Re: Table Name

former_member188827 — Wed, 12 Mar 2008 05:59:36 GMT

aufm: for amount in local curreny(dmbtr).

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

Re: Table Name

Former Member — Wed, 12 Mar 2008 06:05:17 GMT

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

Re: Table Name

Former Member — Wed, 12 Mar 2008 06:13:43 GMT

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.

Re: Table Name

Former Member — Wed, 12 Mar 2008 08:37:42 GMT

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..

Re: Table Name

Former Member — Wed, 12 Mar 2008 08:54:06 GMT

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.

Re: Table Name

Former Member — Wed, 12 Mar 2008 09:08:07 GMT

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.

Re: Table Name

Former Member — Wed, 12 Mar 2008 09:15:33 GMT

use AFKO for AUFNR which header table for PP orders

Regards

Shiva

Re: Table Name

Former Member — Wed, 12 Mar 2008 10:09:36 GMT

Hi,

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

Thanks...

Re: Table Name

Former Member — Wed, 12 Mar 2008 10:12:22 GMT

Common field is BUKRS

regards

Shiva

Re: Table Name

Former Member — Thu, 13 Mar 2008 10:44:30 GMT

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...

Re: Table Name

Former Member — Thu, 13 Mar 2008 10:52:01 GMT

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