create purchase order by line items

[Former Member]

hi friends ,

1) how will create internal tables for header data(ekko) and item data(ekpo) seperately . or we take single internal table for both

table fields.

2) how will prepare data in excell sheet.

[Former Member]

HI ,

It is better to prepare two internal table for EKKO and EKPO.

If u want to upload this data, using BDC or LSMW, u can create a single excel sheet which contains fields of EKKO and EKPO.

Can U also give the field name and what u want to do with this?

so that i can help u in a better way.

Reward the points if u find this useful.

Regards,

Romanch.

[Former Member]

hi mahesh,

1> u can create 2 different internal tables...or even 1 single internal table for both ekko and ekpo tables...

example: this is an example i hv used in my program for creating internal table for zvbap and zvbak tables

data: BEGIN OF itab_output OCCURS 0,

zvbeln TYPE zvbap-zvbeln," sales order number

zposnr TYPE zvbak-zposnr," item number

zmatnr TYPE zvbap-zmatnr," material number

zbrgew TYPE zvbapk-zbrgew," ordered quantity

zgi_qty TYPE zvbap-zgi_qty," gi qty

zinv_qty TYPE zvbak-zinv_qty," inv qty

END OF itab_output.

2> the order of fields in which u create internal table...

the same should b d order of fields of data to b uploaded from excel sheet into sap system by lsmw/bdc..

let me know if it helps,

regards,

kanika

[former_member181995]

Konda,

Just refer: