BDC or BAPI for T-Code V/76

[Former Member]

Dear All,

I am having an excel sheet haing 3 columns in it ie Product Hierarchy Code, Desription & Level.

Currently I am copying the Product Hierarchy Code & its Description based on the levels and is saving into the transaction V/76.

Is there any BAPI or BDC available which can solve our purpose of manually entering the records. If any-one has worked on this then please do share his/her views.

Regards,

N.Jain

[Former Member]

Try to use these FM's

BAPI_MATERIAL_GET_PRODUCTHIER

ISP_BP_PRODUCT_HIERARCHY_GET

COM_PRODUCT_READ_CONFIG_HIER

Regards,

Amey

[Former Member]

Hi,

Thanks for your reply but the FM u have stated are to display the product gierarchy data whereas I want to create the data in V/76. If any BAPI exits for this then please do tell me.

Also, when we are creating a BDC program for this transaction then while saving the data it asks for a transport request which we cannot create in a PRD server. So, I think we cannot go for BDC program also for this.

Your views on how to handle this will be appreciated.

Regards,

N.Jain

[Former Member]

Hi

U can write the BDC pgm for V/76

Upload the data from the Excel file

run the BDC pgm

Reward if useful

Narendra