Retail table

[Former Member]

Hi expert

If someone could help me with finding up table and link

1.Site

2.Site Name

3.Articles

4.Articles Description

5.MCH

6.MCH Description

7.Sub-Category

i would be really greatfull if someone share me with all the table related Retail.

Regard

Nabil

[Former Member · Accepted solution]

Hello,

Here are the tables:

1.Site     - T001W and WRF1

2.Site Name - T001W

3.Articles - MARA and MARC

4.Articles Description - MAKT

5.MCH - KLAH, KSSK ( (If MCH stands for Merch. Category Hierarchy)

6.MCH Description - SWOR

7.Sub-Category - KLAH, KSSK

Thanks,

Venu

[Former Member]

Hi sir

Thanx for Help, but i would greatfull if tell me, in table i am not field which i required.

5.MCH - KLAH, KSSK ( (If MCH stands for Merch. Category Hierarchy)

6.MCH Description - SWOR

7.Sub-Category - KLAH, KSSK.

Regard

Nabil

[Former Member]

Hello,

Can you please restate your question? Are trying to get Merchandise Category Hierarchy for a given article?

Thanks,

Venu

[Former Member]

Dear Sir

i required Merchandise Category Hierarchy for a given article.i have attached excel file

Regard

Nabil

[Former Member]

Hi Nabil,

To get the relation between Article and MC you can look in MARA table, if you need Hierarchy then you have to use the MC that you have and pass it to the Func Module  CLHI_STRUCTURE_CLASSES.

The hierarchy for an article is not stored directly anywhere in a table.  Only the MC for an article is stored, using the MC you have to derive the Hierarchy.

Hope this helps.

Regards,
Kishore MVR

[Former Member]

Hi Nabil,

       There is  Tcode WGUS(Report RWWGH002)which gives a relation between these 2 parameters - MCH and Article,however it requires MCH/MC as an input and lists you the articles but not vice versa.

You may wish to make use of the above report to develop a reversal relationship since you have all the relevant fields in it.Or you may consider different structures like WWGD,T023D etc to derive at the required relationship between an Article and MCH.

Hope it helps.

BR,

Aram.