SAP ABAP IMG Activity J_1BIMPXLSMAP_V (Map MS Excel Columns to Data Structure Fields)
Hierarchy
BBPCRM (Software Component) BBPCRM
   CRM-LOC-BR (Application Component) Brazil
     J1BA (Package) Localization Brazil
IMG Activity
ID J_1BIMPXLSMAP_V Map MS Excel Columns to Data Structure Fields  
Transaction Code S_EBS_44000520   (empty) 
Created on 20111004    
Customizing Attributes J_1BIMPXLSMAP_V   Map MS Excel Columns to Data Structure Fields 
Customizing Activity J_1BIMPXLSMAP_V   Map MS Excel Columns to Data Structure Fields 
Document
Document Class SIMG   Hypertext: Object Class - Class to which a document belongs.
Document Name J_1BIMPXLSMAP_V    

Use

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.

Requirements

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.

Standard settings

Activities

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_1BIMPXLSMAP_V BR Brazil
Assigned Application Components
Documentation Object Class Documentation Object Name Current line number Application Component Application Component Name
SIMG J_1BIMPXLSMAP_V 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_1BIMPXLSMAP_V V - View SM30  
History
Last changed by/on SAP  20111005 
SAP Release Created in 606