MIGO and MIRO

[former_member827032]

Hi, i need some help

i want to code 1 tcode with MIGO and MIRO layout like this

can everyone help me some idea about the data and code? i am new, hope u guys can help me

Thanks

[Neeraj_Jain]

Hello Aries Vũ

If I understand your question correctly you need to save layout as you shown in screenshot. If yes, then on upper extreme right of this window there is a square button with yellow and blue line. Click on it and save variant with your name. Be careful not to save with administrator.

If not this is the case then elaborate your question.

Regards,

Neeraj Jain

[former_member827032]

thank Neeraj Jain

but what is need is something else

this pic from me23n

and i want to code it (MIGO and MIRO) in my tcode in SE80

[Neeraj_Jain]

Use table EKBE - PO history to build your logic either for ALV report or for use in a transaction code.

[former_member827032]

can u give me some idea of code?

i still new of this ABAP

[Neeraj_Jain]

I am from functional side. So no idea about ABAP code.

[former_member827032]

thank you for help me.

have a good day. ❤️

[Sandra_Rossi]

The words you are looking for are an "ALV" containing "total" or "sum" of "quantities", by "unit of measure". Search the forum with these words.

[Neeraj_Jain]

Hello asddasdasd1212,

Please refer below SAP Blog to create ALV report.

https://blogs.sap.com/2013/10/30/abap-beginners-guide-simple-procedural-alv-report/

Regards,

Neeraj Jain

[former_member827032]

thank Neeraj Jain

thank you a lot for help me

but i know about ALV, i just dont know how to code MIGO and MIRO :((((

[Neeraj_Jain]

I think in MIGO and MIRO screen it would be too hard to enhance the PO history layout as shown in ME23N. Let's wait if someone give an idea.

[raymond_giuseppi]

Did you try to create a simple ALV grid from data of PO and table EKBE as main entry. Just use or create a correct field catalog where quantity and amount fields are linked to correct units of mesure and currency codes.

Else please elaborate on '1 tcode with MIGO and MIRO layout ' specification...

[former_member827032]

Thank Raymon

'1 tcode with MIGO and MIRO layout ' mean: i want to code a report with MIGO and MIRO in Quantity and Amt.in loc.cur.

and i try create a Simple ALV, but it doesn't work :(((

so i hope someone can help me with a code with 'sum'

[raymond_giuseppi]

ALV will do the sum for you, once you create a structure with correct defintions:

• Provide a quantity, uom, amouint and local currency field link either the quantity with the uom and amount with currency with ddic definition/reference or building trhe field catalog.
• Then ALV will group he sum by uom and/or currency code.
• For data selection start with EKBE, you can enrich with data from MKPF/MSEG or RBKP/RSEG tables (also MARA or EKPO for material related uom and T001 for local currency)

For reference look for and read

• Generating the Field Catalog Manually
• join between EKBE MKPF RBKP

[Sandra_Rossi]

As you confirm in one of your latest comments that you "try create a Simple ALV, but it doesn't work" and you "hope someone can help [you] with a code with 'sum'", then just search the forum and you will see lots of answers how to do the sum. Apart that, it's difficult to help you because you didn't say which ALV technology you are using. For information, a fully-functional example would take something like 12 lines of code with CL_SALV_TABLE, so it's really easy.