PO Report

[Former Member]

Hello experts,

Can any one gimme some sample code or some links for the PO receiver report with ALV GRID.

Thanks alot for anticipation

SRI

[Former Member]

Hello experts,

Can any one gimme some sample code or some links for the PO receiver report with ALV GRID.

Thanks alot for anticipation

SRI

[Former Member]

"the PO receiver report" ??

What do you mean?

[Former Member]

John

just it is stock Purchase order receiver report, It is to get the PO header and item details for each and every purchase order number separately in the grid format. It is just to display the PO header n item details with columns

one box with

PO NUM, PO date, PUR group, PUR org, Vendor

second box with

PO LINE #, ORD QTY, UNIT, MATERIAL DESCRIPTION, QTY TO RECV, QTY RECV, VEND MAT, ST LOCSHELF BIN, ST LOCBULK BIN

I should get these for each n every PO number separately.

Thanks for the anticipation

SRI

[Former Member]

OK... sounds like you have your specs.

What do you need from the SDN? Sounds quite simple...

[RichHeilman]

Sri, could you not start your programming with the tips from this post?

Thought you were going to go for heirarchy sequential list with ALV OM?

REgards,

Rich Heilman

[Former Member]

I have the functional specs...

I want to know the how to do it in alv grids, I am pretty new to ALV's

Plz Can u help me..

Hey rich now it is simplified, its not going to be in multiple lines, its only in sinlge line i should display the output. With your guidance I completed the tech specs I have to develop the program now. I am new to ALV's thats bit confused...

SRI

[RichHeilman]

Ahh man, I just did a quick little example for you using the Heirarchy Sequetial LIst. Well, here it is anyway. You just have to add a couple of the other fields to the detail line.

REPORT  zrich_0001.

Types: begin of tekko,
       ebeln type ekko-ebeln,
       aedat type ekko-aedat,
       ekgrp type ekko-ekgrp,
       lifnr type ekko-lifnr,
       end of tekko.

Types:  begin of tekpo,
        ebeln type ekpo-ebeln,
        ebelp type ekpo-ebelp,
        menge type ekpo-menge,
        meins type ekpo-meins,
        matnr type ekpo-matnr,
        TXZ01 type ekpo-TXZ01,
        end of tekpo.


DATA: gr_table TYPE REF TO cl_salv_hierseq_table.
DATA: iekko TYPE TABLE OF tekko.
DATA: iekpo TYPE TABLE OF tekpo.
DATA: ibinding TYPE salv_t_hierseq_binding.
DATA: xbinding TYPE salv_s_hierseq_binding.

START-OF-SELECTION.

  SELECT * INTO corresponding fields of TABLE iekko
           FROM ekko UP TO 20 ROWS.
  SELECT * INTO corresponding fields of TABLE iekpo FROM ekpo
                FOR ALL ENTRIES IN iekko
                       WHERE ebeln = iekko-ebeln.

  xbinding-master = 'EBELN'.
  xbinding-slave = 'EBELN'.
  APPEND xbinding TO ibinding.

  cl_salv_hierseq_table=>factory(
          EXPORTING
              t_binding_level1_level2 = ibinding
          IMPORTING
              r_hierseq = gr_table
          CHANGING
              t_table_level1 = iekko
              t_table_level2 = iekpo ).

  gr_table->display( ).

Regards.

Rich Heilman

[Former Member]

ok Rich

Thanks alot for your sample code...

With the help of this code I will try to design the grid so that custom can print the report . They need the output in the grid format...

Thanks a lot for your valuable time Rich and John

SRI