Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

table for batch value

Former Member
0 Likes
2,070

hi friends,

is there any table in which we get batch number along with its price value.

thanks.

1 ACCEPTED SOLUTION
Read only

Former Member
0 Likes
1,729

Batch number - CHARG is in MCHB, MSEG tables.

Regards,

Joan

5 REPLIES 5
Read only

Former Member
0 Likes
1,729

hi,

mchb and mch1 will have the bach numbers .

from a802 table we can find the condition record number(KNUMH) use it in konp table and get net price for that bach..

to get data from a802 table use condition MATNR = mch1-MATNR AND DATBI >= mch1-HSDAT AND DATAB <= mch1-HSDAT.

to inner join mchb and mch1 tables use AMATNR = BMATNR AND ACHARG = BCHARG.

regds:

rajesh.k

Read only

Former Member
0 Likes
1,730

Batch number - CHARG is in MCHB, MSEG tables.

Regards,

Joan

Read only

Former Member
0 Likes
1,729

Hi,

For batch description you can check the tables STXL and STXH

For more information check this link.

[Batch|]

Hope this helps you

Regards,

Rajani

Read only

Former Member
0 Likes
1,729

Hi,

Tables MCHB and MSEG are two such tables.

VKWRT field for "Value at Sales Prices" and VKWRA for "Value at sales prices excluding value-added tax".

Regards

Ravi

Read only

Former Member
0 Likes
1,729

not get proper answer