Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

Need report for these fields

Former Member

‎2007 Apr 05 8:12 AM

0 Likes
701

HI,

need to write a report for these fields.

PO number (EKPO_EBELN), Article number (EKPO_MATNR), Vendor part number (EKPO_MFRPN), Description (MAKT_MAKTX), Quantity in Base unit of Measure (EKPO_MENGE) and Quantity in BuyPack unit of measure and Net price (EKPO_BPRME).

Give me it ASAP.

Regards,

Chow.

HI,

need to write a report for these fields.

PO number (EKPO_EBELN), Article number (EKPO_MATNR), Vendor part number (EKPO_MFRPN), Description (MAKT_MAKTX), Quantity in Base unit of Measure (EKPO_MENGE) and Quantity in BuyPack unit of measure and Net price (EKPO_BPRME).

Give me it ASAP.

Regards,

Chow.

Reply
4 REPLIES 4
Read only

Former Member

‎2007 Apr 05 8:19 AM

0 Likes
670

Hi..

decalre an itab with fields given below.

selecting records based on Select-options for S_ebeln.

<b>select EKPO_EBELN

EKPO_MATNR

EKPO_MFRPN

EKPO_MENGE

EKPO_BPRME

MAKT_MAKTX

from ( ekpo inner join makt on

ekpomatnr = MAKTmatnr )

into table itab

where ebeln in s_ebeln.</b>

**********printing ouput***

loop at itab.

write: itab - fields

endloop.

Read only

Former Member

‎2007 Apr 05 8:28 AM

0 Likes
670

Naidu,

DATA : Begin of I_EKPO occurs 0,

MATNR LIKE EKPO_MATNR,

MFRPN LIKE EKPO_MFRPN,

MENGE LIKE EKPO_MENGE ,

BPRME LIKE EKPO_BPRME ,

MAKTX LIKE MAKT_MAKTX,

End of I_EKPO.

select EKPO~EBELN

EKPO~MATNR

EKPO~MFRPN

EKPO~MENGE

EKPO~BPRME

MAKT~MAKTX

from ( ekpo inner join makt on

ekpomatnr = MAKTmatnr )

into table I_ekpo

where ebeln in s_ebeln.

Don't forget to reward if useful..

Read only

RaymondGiuseppi
Active Contributor
In response to Former Member

‎2007 Apr 05 8:33 AM

0 Likes
670

Use the information on previous posts and go to <a href="http://www.alvrobot.com.ar/home.php">ALV Robot</a> which is a ALV report generator on the web.

Regards

Read only

Former Member

‎2007 Apr 05 8:35 AM

0 Likes
670

Hi,

Do the following steps.

Declare an internal table with these fields.

Select the data of these fields from data base table EKPO into this internal table.

loop the internal table. writhe each field by using write statement in proper format.

<b>or</b>

To display in ALY build field catalog for these fields and supply field catalog internal table and data internal table to any of the ALV function modules like REUSE_ALV_GRID_DISPLAY.

Regards