Skip to Content

smartform table data group those with same document number

Hi Experts,

I want to group records based on Docno & Doc.type.

For example Consider 4300000024, it's displaying 4 times. I want to display 4300000024 and WE once (like a subheading) and the remaining column values as displayed itself.

capture.png (15.8 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Apr 28 at 12:19 PM

    Hi Kali,

    I solved it myself.

    I have slno as first column. So i write the following code inside the cell for doc no.

    READ TABLE it_out INTO wa_temp WITH KEY slno = wa_out-slno - 1 belnr = wa_out-belnr.
    IF wa_out-belnr = wa_temp-belnr.
    CLEAR: wa_out-belnr, wa_out-blart, wa_temp.
    ENDIF.

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 28 at 10:00 AM

    You want to need exactly like this.

    43000000024

    43000000024 We 89 001040009 Inventory-steel 1004 405.00

    43000000024 We 89 001040001 GR/IR Clear a 1004 -450.00

    If Yes Possible, In driver program it self, we can do.

    In final table sort Doc no, add 43000000024 1 extra row, make all the columns empty except doc no.
    Sort it by doc no.

    completed.

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 28 at 11:21 AM

    Hi,

    I cant do it in the driver program. there i am looping a header table with document number so i need those values inside the smartform.

    I want o/p to be like,

    43000000024 We 89 001040009 Inventory-steel 1004 405.00

    96 001040001 GR/IR Clear a 1004 -450.00

    89 001040009 Inventory-steel 1004 405.00

    96 001040001 GR/IR Clear a 1004 -450.00

    Add comment
    10|10000 characters needed characters exceeded