Skip to Content
author's profile photo Former Member
Former Member

DISPLAY OF MY INTERNAL TABLE AS PER MY REQUIREMENT

I have a problem with the display of my internal table

Available data

Itab1

Header

BAND1 BAND2 BAND3 …. BAND10

ITAB2

RECORDS

Occid1

Occid2

Occid3

.

.

.

.

.

Occid10

itab1 AmountBand header I have appended it as record in my itab3

I have taken Occasion ID from vbkd-bzirk

And Value from vbap-netwr.

Itab3 contains

AmountBand Occasion ID Value

Band1 occid1 value

Band1 occid2 value .

.

.

.

Band1 occid10 value

Band2 occid1 value

Band2 occid2 value

.

.

.

Band2 occid10 value

..

..

..

..

Band10 occid1 value

Band10 occid2 value

.

.

.

Band10 occid10 value

These r the records which r available for me in my final internal table which I have to display as

Amount Band occid1 occid2…. occid10

Band1 value(oc1) value(oc2) value(oc3)

Band2 value(oc1) value(oc2) value(oc3)

Band3 value(oc1) value(oc2) value(oc3)

..

..

..

Band10 value(oc1) value(oc2) value(oc3)

i require the final output like this.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Aug 08, 2007 at 12:28 PM

    Hi

    Heres the solution

    Sort itab3 by Amountband Occasionid.

    Loop at itab3.

    at new AmountBand.

    < clear final internal table header and variables used>

    endat.

    at new Occasionid.

    <clear variables used for occasionid summation>

    endat.

    var_occ_amount = var_occ_amount + itab3-value.

    at end of Occasionid.

    <assign occasionid variable values to final internal table>

    endat.

    at end of AmountBand.

    <append final internal table>

    endat.

    Endloop.

    Regards

    Raj

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 18, 2008 at 08:41 AM

    thanks ... answered internally

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.