Skip to Content

Required Emigall File Structure

                                                                                                                                                                  Target structure for Connection Object
Structure Field Description Data Type Length Optionality Processing Type Remarks
SPRAS Language Key CHAR 2 Fixed Value Fixed value as SY-LANGU
CO_EHA SWERK Maintenance Plant CHAR 4 Mandatory Transfer
CO_ADR CITY1 City CHAR 40 Mandatory Transfer
CITY2 District CHAR 40 Transfer
POST_CODE1 Post Code CHAR 10 Mandatory Transfer
STREET Street CHAR 60 Transfer
HOUSE_NUM1 House Number CHAR 10 Transfer
STR_SUPPL1 Street2 CHAR 40 Transfer
STR_SUPPL2 Street3 CHAR 40 Transfer
COUNTRY Country Code CHAR 3 Mandatory Transfer
LANGU Language Key CHAR 2 Mandatory Fixed VAlue Fixed Value as SY_LANGU
REGION Region (State,Province,County) CHAR 3 Transfer
STR_SUPPL3 Street4 CHAR 40 Transfer
&ENDE Signifies end of a data record

Formar of sample data to Load into SAP using EMIGALL

COB_01 CO_EHA Project_Name

COB_01 CO_ADR Leicester Leicestershire LE3 0LS Cherrylease Drive 19 OFF:Fosse road South Behind:NHS GB LEI Narborough

COB_01 &ENDE

COB_02 CO_EHA Project_Name

COB_02 CO_ADR Leicester Leicestershire LE3 0LS Spinny 20 Street South Behind:NHS GB LEI Narborough

COB_02 &ENDE

COB_03 CO_EHA Project_Name

COB_03 CO_ADR Leicester Leicestershire LE3 0LS Cherrylease Drive 19 OFF:Fosse road South Behind:NHS GB LEI Narborough

COB_03 &ENDE

FAQs

  1. 1.       How to place NULL’s in the file?
  2. i.e. If a column incomplete. 50% data. 50% Nulls.

The file is of fixed length , so keep field value maximum length will be as specified in the target , if the value is only of 5 characters ,for a total lenth of 10 , field should have only 5 characters followed by the

values for subsequent fields .

  1. 2.       What data should be placed when we do not have a corresponding Source column. Can we skip the column by placing one more TAB?
  2. E.g. I need to load City1 and City2 as per the Emigall Structure. But I only have data for City1. So what data can be entered for City2.
  3. ADDRESS.CITY||’              ‘||’         ‘||ADDRESS.POSTALCODE à will this work?

if there is no value on the source  for a field ,leave the field blank separated by tabs only .

  1. 3.       Should the column length exactly be the same? Will Emigall accept if the length is increased.
  2. i.e. Practically we will be entering data for fields “SWERK” and “City1” in the same column. So we will have the column length to the max value – Char 40. But actual length of SWERK is only Char 4.

Structure

Field

Description

Data Type

Length

CO_EHA

SWERK

Maintenance Plant

CHAR

4

CO_ADR

CITY1

City

CHAR

40

Coulmn length should exactly be same as Emigall strcuture , i.e it should accept the value having

maximum lenth as specified in the target structure . In the above case , even though you are mapping the same value for CITY1 and SWERK , SWERK accepts only a four Character value which is configured in ISU . There needs to be mapping mainatined in the source as well , to know what values are configured in SAP .

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply