Ansicht
Dokumentation

J_1BIMPXLSMAP_V - Map MS Excel Columns to Data Structure Fields

When the system uploads the import data from an MS Excel file in the special view of the Nota Fiscal Writer (J1B1N_IMP transaction), it must be able to place the data in each cell in the corresponding field in the respective data structure. This data is then stored in the corresponding table when you save the nota fiscal. To enable the system to do this data mapping, in this Customizing activity you map the columns in the MS Excel layouts that you want to use for upload to the corresponding fields in the relevant data structures. If you map a column to a field in a tax-relevant data structure, you must also enter the corresponding tax group for the data structures.

For each possible MS Excel layout, you have assigned the tax types relevant for imports to the tax groups for the tax-relevant data structures in the Assign Tax Types to Tax Groups for Import Data Upload Customizing activity.