Customer IDOC : DEBMAS Simplified
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 | |
|
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 |