Kontakt

Ansicht
Dokumentation

J_1BIMPLAYOUT_VC - Define MS Excel Layouts for Data Upload

J_1BIMPLAYOUT_VC - Define MS Excel Layouts for Data Upload

TXBHW - Original Tax Base Amount in Local Currency   BAL_S_LOG - Application Log: Log header data  
This documentation is copyright by SAP AG.
SAP E-Book

To make the manual creation of notas fiscais with many line items easier, for example, for notas fiscais for imports, the system can allow you to upload data from an MS Excel file in a special view of the Nota Fiscal Writer (accessed using the J1B1N_IMP transaction).

To enable the system to offer this upload function, you must record the possible layouts that you want to use in this Customizing activity. The system then displays the names of these layouts as selection criteria for the MS Excel layout on the selection screen called up with the Upload Data for NF from MS Excel (J1B1N_IMP) transaction.Note that this function can only be used to create notas fiscais with entrada as the nota fiscal type.

When the system uploads the data from an MS Excel file, 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 also map the columns in the MS Excel layouts to the corresponding fields in the relevant data structures. To be able to map a column to a field in a tax-relevant data structure, you must have also entered the corresponding tax group for the data structures in this Customizing activity.

  1. You record the possible MS Excel layouts in this Customizing activity.
  2. For each layout, you assign tax types that are relevant for the tax-relevant data in the MS Excel to the corresponding tax groups in Assign Tax Types to Tax Groupsview of this Customizing activity. You can also enter in the MS Excel new columns for assigning specific tax types. In this case, after uploading the MS Excel, the system overwrites the customizing by the value you have added in the MS Excel file.
  3. For each layout, you map the fields in the MS Excel to the fields in the data structures in the system in the Map MS Excel Fields to Data Structure Fields view of this Customizing activity.






CL_GUI_FRONTEND_SERVICES - Frontend Services   TXBHW - Original Tax Base Amount in Local Currency  
This documentation is copyright by SAP AG.

Length: 2422 Date: 20240606 Time: 213643     sap01-206 ( 59 ms )