Hi All,

The goal of this document is to provide field level details for Debmas idoc, used to load and extract data of Customer Master in SAP.

In our daily job, often we come across a scenario where we need to load data into SAP or extract data from SAP for Customer/Employee/Vendor/Material etc.

We understand that data in SAP are stored in SAP tables, with specific field requirement like data type and Length of field.

Often it’s difficult to memorize the field level details for any table.

In my sincere attempt, I have tried to include the field level details for a particular case of Customer Master.

In Customer Master, we can load the data in, as well as extract from, SAP, using DEBMAS idoc.

Please find attached the document, to understand the meaning of each and every field in IDOC, its system requirement (mandatory/non Mandatory), field name, description, segment name and table name where the field lies in SAP.

The document is designed segment wise.

System Required(Mandatory/NON Manadatory)

Text Description

SAP Technical
Field Name

Field Length

Segment Name

E1KNA1M – Basic Data (KNA1)

*

Customer Number 1       

KUNNR

10

E1KNA1M

Title

ANRED

15

E1KNA1M

Central order block for customer

AUFSD

2

E1KNA1M

Express train station

BAHNE

25

E1KNA1M

Train station

BAHNS

25

E1KNA1M

International location number  (part 1)

BBBNR

7

E1KNA1M

International location number (Part 2)

BBSNR

5

E1KNA1M

Authorization Group

BEGRU

4

E1KNA1M

Industry key

BRSCH

4

E1KNA1M

Check digit for the international location number

BUBKZ

1

E1KNA1M

Data communication line no.

DATLT

14

E1KNA1M

Central billing block for customer

FAKSD

2

E1KNA1M

Account number of the master record with the fiscal address

FISKN

10

E1KNA1M

Account number of an alternative payer

KNRZA

10

E1KNA1M

Group key

KONZS

10

E1KNA1M

*

Customer Account Group

KTOKD

4

E1KNA1M

Customer classification

KUKLA

2

E1KNA1M

*

Country Key

LAND1

3

E1KNA1M

Account Number of Vendor or Creditor

LIFNR

10

E1KNA1M

Central delivery block for the customer

LIFSD

2

E1KNA1M

City Coordinates

LOCCO

10

E1KNA1M

Central Deletion Flag for Master Record

LOEVM

1

E1KNA1M

*

Name 1

NAME1

35

E1KNA1M

Name 2

NAME2

35

E1KNA1M

Name 3

NAME3

35

E1KNA1M

Name 4

NAME4

35

E1KNA1M

Nielsen ID

NIELS

2

E1KNA1M

*

City

ORT01

35

E1KNA1M

District

ORT02

35

E1KNA1M

PO Box

PFACH

10

E1KNA1M

  1. P.O. Box Postal Code

PSTL2

10

E1KNA1M

Postal Code

PSTLZ

10

E1KNA1M

Region (State, Province, County)

REGIO

3

E1KNA1M

County Code

COUNC

3

E1KNA1M

City Code

CITYC

4

E1KNA1M

Regional Market

RPMKR

5

E1KNA1M

*

Sort field

SORTL

10

E1KNA1M

Central posting block

SPERR

1

E1KNA1M

*

Language Key

SPRAS

1

E1KNA1M

Tax Number 1

STCD1

16

E1KNA1M

Tax Number 2

STCD2

11

E1KNA1M

Indicator: Business Partner Subject to Equalization Tax?

STKZA

1

E1KNA1M

Liable for VAT

STKZU

1

E1KNA1M

House number and street

STRAS

35

E1KNA1M

Telebox number

TELBX

15

E1KNA1M

First telephone number

TELF1

16

E1KNA1M

Second telephone number

TELF2

16

E1KNA1M

Fax Number

TELFX

31

E1KNA1M

Teletex number