Material Group field in FS10N / FBL3N report

[utpalnalinkumar_parikh]

Hi Gurus

How to get "Material Group" (Stock items) field in FS10N or FBL3N report (MM related G/L)?

Means Column "Material Group" appeares in above reports.

Ealiest reply will be appreciated.

Regards

Utpal

[ajaycwa1981 · Accepted solution]

Hi

You need to write the ABAP code in this exit... Ask your ABAPer to do that....

Once you do this, post a transaction i.e. Goods receipt or goods issue and then check whether mat group is populated in the posted docs

Note that it would not affect the already posted docs.... if you want to update the posted docs also, then ask your ABAPer to use BAPI and create an upload program to update the XREF1 in the posted docs

Br, Ajay M

[utpalnalinkumar_parikh · Accepted solution]

Thank you Ajay

All done.... Full points to you...

Regards

Utpal

[ajaycwa1981]

Hi

Material group cant directly come in these reports...

You need to write FI substitution using OBBH using the exit RGGBS000 and populate the Material Group in some reference field

Br, Ajay M

[utpalnalinkumar_parikh]

Thanks Ajay

Any step by step process available???? If possible?

Regards

Utpal

[ajaycwa1981]

Hi

Its the same way you write a substitution in OBBH.. You can search the forum, there will be lots of posts available...Enclosed below are high level guide lines

Go to OBBH -Create a Subst Rule and assign to your Comp Code

Choose the FIeld to be Substituted (BSEG-XREF1) and the Subst method (Using Exit)

Prerequisites:

Include the comp code and required GL accounts in the prerequisites section..... If there are multiple GL accounts, Create a SET ZHKONT in GS01 for BSEG-HKONT and include the GL accounts in it

BSEG-BUKRS = XXXX and BSEG-HKONT IN ZHKONT

Field to be Substituted - XREF1

Choose Exit U100 (This is part of RGGBS000)

Br, Ajay M

Field to be Substituted: BSEG-XREF1

[utpalnalinkumar_parikh]

Hi Ajay

I am very close.. Need your help bit more...

Susbstituion Rule set successfully as per your guidance.

Now,how to populate Material Group field in FBL3N or FS10N reports means what next step to do so, MPG appears in above reports?

Many thanks in advance.

Regards

Utpal