SAP Gateway for Microsoft excel

Hi ,

I want to create Purchase order data from excel . I have PO header and Item as entity in gateway services . I have associated POHeader with PO Items and declared navigation in SEGW. I have implemented method CREATE_DEEP_ENTITY.

While binding the gateway services, it just bind the header fields and i don't have provision to pass on the item fields . My requirement is to bind PO Header and Items together in excel and call the create_deep_entity method so that PO with item is created together in single payload.

In my case i am able to bind either header or Item data and it search for create_entity method and throw error.

Does excel support Deep Insert ? Can we create Hierarchical data using GWPAM excel.

Thanks,

Anju