To add custom fields in SalesLine table, first extend SalesLine table and add custom fields:
Next add the custom fields in the SalesOrderLineEntity by extending the entity. When we extend the entity we see the custom fields in SalesLine datasource that we added in the above step:
Drag these fields from datasource to the fields of entity:
Now extend the staging table for the entity named, SalesOrderLineStaging:
Now go to the Data Management:
Click Framework Parameters > Entity Settings > Refresh Entity List:
Create an import project :
Upload the excel file you want to import :
Click on the View Map to map the excel file to your custom fields in staging table:
Click Import :
