topic Re: Question with adding in Application Development and Automation Discussions

Question with adding

Former Member — Wed, 29 Nov 2006 22:27:51 GMT

Hi,

I have an internal table with the fields sales order and item number. I also want to add another field to this internal table which can show 'Serial No'.

For ex:

The present internal table:

Order Item

35 10

35 30

37 20

The requirement:

S.No Order Item

1 35 10

2 35 30

3 37 20

Can you tell me the best logic to get this extra field? Is there any standard SAP field that can calculate these serial numbers?

Thanks and best regards,

Krishen

Re: Question with adding

Former Member — Wed, 29 Nov 2006 22:33:02 GMT

Hi,

How are you populating the internal table..One by one or bulk..

DATA: BEGIN OF ITAB OCCURS 0,

SERIAL TYPE SYTABIX,

ORDER TYPE VBELN,

ITEM TYPE POSNR,

END OF ITAB.

If one by one..

DATA: V_TABIX TYPE SYTABIX.

LOOP AT ITAB_OLD.

V_TABIX = V_TABIX + 1.

ITAB-SERAIL = V_TABIX.

ITAB-VBELN = ..

APPEND ITAB.

ENDLOOP.

If bulk insert..Then loop at the internal table and then add the serial number..

LOOP AT ITAB.

ITAB-SERIAL = SY-TABIX.

MODIFY ITAB TRANSPORTING SERIAL.

ENDLOOP.

Thanks,

Naren