topic Re: Internal table issue in Application Development and Automation Discussions

Internal table issue

Former Member — Mon, 22 Oct 2007 19:13:41 GMT

Hi All,

I have an internal table itab1 and in this I have the po numbers, now I need to maintain another internal table that will have the details of the PO's that are stored in itab2 such as material no, price, line item no. and po number.

so can you please tell me how to do this.

data: begin of it_tab2 occurs 0,

ebeln like ekko-ebeln,

end of it_tab2

Thanks

Rajeev

Message was edited by:

Rajeev Gupta

Re: Internal table issue

Former Member — Mon, 22 Oct 2007 19:17:07 GMT

You'll have to add the material number to the second table and then retrieve the material number form EKPO.

Rob

Re: Internal table issue

Former Member — Mon, 22 Oct 2007 19:22:32 GMT

Hi Rob,

Thanks for the reply,

But what I need is to retrieve the information of PO's in an internal table, so basically if in itab2 PO # is 12345, then I need to get the materials associated with that PO (12345), item no. and price of the materials in the PO in the other internal table.

If you get my point ...please try to explain in detail.

Thanks

Rajeev

Re: Internal table issue

Former Member — Mon, 22 Oct 2007 19:26:58 GMT

Like I said - it's in EKPO.

Rob

Re: Internal table issue

ferry_lianto — Mon, 22 Oct 2007 19:54:31 GMT

Hi,

Please try somthing like this.


data: begin of it_tab2 occurs 0,
        ebeln like ekpo-ebeln,
        ebelp like ekpo-ebelp,
        matnr like ekpo-matnr,
        netpr like ekpo-netpr.
data: end of it_tab2.

loop at it_tab1.
  select ebeln ebelp matnr netpr
  into (ekpo-ebeln, ekpo-ebelp, ekpo-matnr, ekpo-netpr)
  from ekpo
  where ebeln = it_tab1-ebeln.

    it_tab2-ebeln = ekpo-ebeln.
    it_tab2-ebelp = ekpo-ebelp.
    it_tab2-matnr = ekpo-matnr.
    it_tab2-netpr = ekpo-netpr.
    append it_tab2.

  endselect.
endloop.

Regards,

Ferry Lianto

Re: Internal table issue

Former Member — Mon, 22 Oct 2007 23:17:50 GMT

Hi,

Give the first select to select all PO Numbers from EKKO and store them in internal table I_EKKO

Then to get the details:

SELECT EBELN EBELP NETPR

FROM EKPO

INTO TABLE I_EKPO

FOR ALL ENTRIES IN I_EKKO

WHERE EBELN = EKKO-EBELN.

Hope it helps,

Reward if it is useful.

Thanks,

Srinivasa Rada