Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Reply from dbcasey on Oct 23 at 9:58 AM There is no standard transaction or table that shows the mapping of a material group to a GL. The Valuation class determines the GL. You can maintain the ValCl and material group in a material master (MM01/MM02) and then create a custom program to link them to a GL. If a material id is not used, you can maintain a default ValCl to a material group via configuration. IMG: Materials Mgmt > Purchasing > Material Master > Entry Aids for Items without a Material Master. Join TABLES: MARA, MBEW, MARC, SKB1, SKA1, T030, T025T. Below is an example of a starting point. FROM MAKT INNER JOIN MARA ON ( MAKT~MATNR = MARA~MATNR ) INNER JOIN MARC ON ( MAKT~MATNR = MARC~MATNR INNER JOIN MBEW ON ( MBEW~MATNR = MAKT~MATNR AND MBEW~BWKEY = MARC~WERKS) INNER JOIN T023T ON ( MARA~MATKL = T023T~MATKL AND T023T~SPRAS = MAKT~SPRAS ) INNER JOIN T025T ON ( MBEW~BKLAS = T025T~BKLAS AND T025T~SPRAS = MAKT~SPRAS ) Damita Casey
| | | ---------------Original Message--------------- From: Sumok Sent: Wednesday, October 22, 2014 11:33 PM Subject: Display Of Mapping Material Group To GL in SAP Hi, Which T-code shall I use in SAP in order for me to display all material group which already mapped with the particular default GL. (i.e. I need the information whereby can at the same time show the mapping of material group against the GL) Thanks. | | Reply to this email to post your response. __.____._ | _.____.__ |