Link b/w ESTMJ ESTRH and ESTDU

[Former Member]

Hello ALL,

I have a requirement, where I'm fetching data from ESTMJ table by passing MATNR from selection screen.

From ESTMJ, Im passing recnroot to recn of ESTRH and printing the data from ESTRH table.

The material which is passed is from Usage(Validity Area) "RU"(Russia).

The requirement is, we need to output the data only for Usage(Validity Area) "EU"(Europe).

I'm not able to find the link for ESTRH and any other table which has Validity Area.

I checked ESTDU, but when I pass the RECN/RECNROOT (of ESTRH), it is not giving the data.

Please let me know, how to link ESTRH and Usage(Validity Area) related table.

Thanks,

Priya

[christoph_bergemann]

Dear Priya

I did not catch you question.

Regarding:

"The material which is passed is from Usage(Validity Area) "RU"(Russia)."

This is not possible (in most cases). A material can be handled in more than one plant and these plants can be allocated to a number of countries. Therefore it is just a "material number".

ESTDU: ESTDU is used in many circumstanes. E.g. on the level of "Restriction", on the level of "identifier", on the level of "Status" and on the level of data records stored in VATs (like density)

E.g. You can use CG02 to cretae a hit list using a material number. now you can use ouput variant "EXCEL" to get any data shown in property e.g. Density. In doing so you will get indication if the data maintained is valid world wide (e.g. usage PUBLIC / REG_WORLD) or only in Europe (PUBLIC REG_EU)

There is no standard option available to reduce during out put the data records so that only data records which are valid in europe will show up but is it a standard approach to use SAP original output variants copy them and adapt them to your needs so that such a "filter"  mechanism is supported.

But may be I misinterpret your intention or your demand

The similar logic is used to retrieve data for WWI reports.

C.B.