Regarding material master

[Former Member]

Hi All,

I have an requirement that i have to identify the fields belongs to which view i.e in material master we have various views under views we have various fields for eg in sales :general /plant view we have a field called load group i just want to identify that field belongs to that particular sales :general /plant view could anybody say the table name which this all the details store or explain the business logic behind this scenario? now i think if i found the hidden fields in material master i can acheive this scenario can anyone say where all the hidden fields of the material master stored i.e table name also say that am going in the right path.

[former_member156446]

let me have ur email id.. I have an excel sheet with all ur req.

and award points after...getting the email

Done

[Former Member]

My email id is naveenkgster@gmail.com

your help will be rewarded.

Regards

Naveen

[Former Member]

Hi Jay,

I didnt get any mail with attachment.

No attachment or any other info...

I just received a mail with the foll msg :

Hi Naveen

Award points if helpful.

Jay.

[Former Member]

Hi,

for the material master fields u can search tables called mara,mseg mainly,

then remaining tables are,

MSCA

MSCAH

MSCD

MSCDH

MSCS

MSDAPPLT

MSDRUNTIMET

MSEG

MSEGO1

MSEGO2

MSET

MSFD

MSFDH

MSFS

MSID

MSIDH

MSIS

MSKA

MSKAH

MSKAHO1

MSKAO1

MSKU

MSKUH

MSKUHO1

MSKUO1

MSLB

reward points if useful,

seshu.

[Former Member]

Hi,

About the various views of the material , u will get in the mara table . PSTAT field. press F1 on this field u will get all the information.

for MRP vieew . can check PLPO,PLKO,AFKO,AFPO table

for purchasing view ... EKKO,EKPO,EKBE tables.

for accounting view ..BSID,BSAD,BKPF tables.

Reward Points if it is Useful.

Thanks,

Manjunath MS

[Former Member]

my requirement is i need to know which table holds the details of which scree field was hiiden and etc,

for eg in basic data view consider field Gross weight was hiiden,

i need to knw which table holds details that this field was hiiden in mm01.

[former_member156446]

hi check the email now... I sent thru another email id..