SAP ABAP IMG Activity J_1BIMPLAYOUT_VC (Define MS Excel Layouts for Data Upload)
Hierarchy
☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-LOC-BR (Application Component) Brazil
     ⤷ J1BA (Package) Localization Brazil
IMG Activity
ID J_1BIMPLAYOUT_VC Define MS Excel Layouts for Data Upload  
Transaction Code S_EBJ_98000001   (empty) 
Created on 20120227    
Customizing Attributes J_1BIMPLAYOUT_VC   Define MS Excel Layouts for Data Upload 
Customizing Activity J_1BIMPLAYOUT_VC   Define MS Excel Layouts for Data Upload 
Document
Document Class SIMG   Hypertext: Object Class - Class to which a document belongs.
Document Name J_1BIMPLAYOUT_VC    

Use

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.

Requirements

Standard settings

Activities

  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 Groups view 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.

Example

Business Attributes
ASAP Roadmap ID 254   Transfer Data 
Mandatory / Optional 2   Optional activity 
Critical / Non-Critical 2   Non-critical 
Country-Dependency I   Valid for countries specified 
Customizing Attributes Country Key Country Name
J_1BIMPLAYOUT_VC BR Brazil
Assigned Application Components
Documentation Object Class Documentation Object Name Current line number Application Component Application Component Name
SIMG J_1BIMPLAYOUT_VC 0 HLB0006310 General Application Functions 
Maintenance Objects
Maintenance object type C   Customizing Object 
Assigned objects
Customizing Object Object Type Transaction Code Sub-object Do not Summarize Skip Subset Dialog Box Description for multiple selections
J_1BIMPLAYOUT_VC C - View cluster SM34  
History
Last changed by/on SAP  20120227 
SAP Release Created in