SAP ABAP IMG Activity J_1BIMPLAYOUT_V (Record MS Excel Layouts for Import Data)
Hierarchy
BBPCRM (Software Component) BBPCRM
   CRM-LOC-BR (Application Component) Brazil
     J1BA (Package) Localization Brazil
IMG Activity
ID J_1BIMPLAYOUT_V Record MS Excel Layouts for Import Data  
Transaction Code S_EBS_44000519   (empty) 
Created on 20111004    
Customizing Attributes J_1BIMPLAYOUT_V   Record MS Excel Layouts for Import Data 
Customizing Activity J_1BIMPLAYOUT_V   Record MS Excel Layouts for Import Data 
Document
Document Class SIMG   Hypertext: Object Class - Class to which a document belongs.
Document Name J_1BIMPLAYOUT_V    

Use

To make the manual creation of a nota fiscal for imports easier, the system can allow you to upload import data in a special view of the Nota Fiscal Writer (accessed using the J1B1N_IMP transaction) from an MS Excel file. 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 J1B1N_IMP transaction.

Requirements

You have assigned tax types that are relevant for imports to the corresponding tax groups in the Assign Tax Types to Tax Groups for Import Data Upload Customizing activity.

Standard settings

Activities

  1. You record the possible MS Excel layouts in this Customizing activity.
  2. You map the fields in your MS Excel layouts to the fields in the data structures in the system in the Map MS Excel Fields to Data Structure Fields 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_V BR Brazil
Assigned Application Components
Documentation Object Class Documentation Object Name Current line number Application Component Application Component Name
SIMG J_1BIMPLAYOUT_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_1BIMPLAYOUT_V V - View SM30  
History
Last changed by/on SAP  20111004 
SAP Release Created in 606