MB51 - Changing Issuing unit or Add custom fields

[justin_santhanam]

Good Evening,

I'm currently working on development and got one requirement which I'm quite unfamiliar with. We have material X which has multiple plants. The Base UOM for this material is M3 (since being used in Canada). The Same Material is been extended to US Plants and the alternative UOM being used in BBL. The document posting fine for mov.type 309 all good. But the problem is when the user runs the report MB51 they are seeing the Sending Material Unit as BBL and Receiving Unit as M3, same goes with the Quantity. This is technically correct, but visually they are not satisfied with.

So the requirement is

- They wanted to see both Sending/Receiving material as BBL.

- They don't want to change anything in existing layout, hence we need to add one additional column which shows the Quantity 10.000 and BBL(as per my example data).

I hope I was clear in stating my requirement, can anyone suggest how to proceed from here? Can I add one additional column in the standard report(I think there is a note that talks about it, need to dig into it though) or do I need to create ZMB51?

I sincerely appreciate your assistance!

Thanks,

Justin.

[nabheetscn]

Hi Justin

The output is using structure locally declared as LIST in the report. Inside it you will see explicit enhancement option. Implement the enhancement and add your field in output

Do an implicit enhancement in sub routine build_fieldcatalog to add your field in the field catalog.

You can default the value in subroutine process_list via implicit enhancement

Hope it solves your issue.

Thanks

Nabheet

[former_member182546]

Dear Justin ,

Please check the below link.

https://scn.sap.com/message/5073385

With Regards,

Sudhir S

[venkateswaran_k]

Dear Justin,

To include additional field in the report, do as follows:

to add the field in structure of report,

• In the include RM07DOCS_GENERATED create implicit enhancement for structure itab

to populate that fied,

• in the program RM07DOCS, create implicit enhancement at form  create_entry_for_list at end write your statement to update that newly added field.

to get into report layout, in the same program at form  build_fieldcatalog  add the field.

Regards,

Venkat

[justin_santhanam]

thanks for ur valuable answers.. does anyone have seen this kind of problem? I wanted to make sure is this is something only achievable thru coding or something I'm really over looking?

[nabheetscn]

Hi Justin

I believe it can be achieved through coding only or when the movement is done same unit to be used which is desired in output(functional can provide input)

Nabheet

[justin_santhanam]

Nabheet,

Thanks for your response. I have added my two fields to the itab directly and as per your input I have handled my logic in process_list, but when I execute the report I'm not seeing the output in the report. Any ideas why? You have mentioned that the fields has to be included in LIST, but I have included in ITAB...

Thanks,

Justin.     

[nabheetscn]

Hi Justin

did you add your new fields in the field catalog in sub routine build_fieldcatalog?

Nabheet

[arivazhagan_sivasamy]

Hi Justin Santhanam,

Include RM07DOCS_GENERATED will be changed based on the customization done by Core team.

Suppose if the user want to add some standard fields in selection screen or also want to add some standard fields in the output, it can be done using customization.

Please check with your functional team and can be achieved with implicit enhancement.

Regards,

Arivazhagan S