How to create a Product Hierarchy using BAPI from a Flat File (Excel)

[Former Member]

Hi All,

I need to create product heirarchy from a excel.

Could anybody help me in finding out correct BAPI that will create Product Heirarchy using Flat file.

Regards,

Snehaseel.

[rajkj · Accepted solution]

Hi Snehaseel,

Have you tried LSMW? It will be a good fit for your requirement.

There is no one BAPI that can accept a flat file and create product hierarchy in one call. You may need to manage data read from excel (CALL FUNCTION 'ALSM_EXCEL_TO_INTERNAL_TABLE') and populate a structure/table (BAPI10017PHNODE) and pass that data to BAPI_PHSRVAPS_SAVENODES that can save nodes to already existing hierarchy. Please note that it requires you to create one hierarchy header manually and then execute the BAPI to add the nodes to it.

Thanks,

Rajesh