The EIDESWTMSGDATA table in SAP ERP or S/4HANA stores Message Data for Switch Document data. There are total 38 fields in EIDESWTMSGDATA table. The Message Data for Switch Document table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of EIDESWTMSGDATA table. It is in IDE Change of Supplier and Service (EE_IDE_SWITCH) ABAP package and is part of the Intercompany Data Exchange (IS-U-IDE) module.
SAP EIDESWTMSGDATA Table Fields
Following is the list of fields that are available in SAP EIDESWTMSGDATA table. The primary key fields of the table are MANDT (Client), SWITCHNUM (Switch Document No.), MSGDATANUM (Message Data for Switch Document).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | * | CLNT (3) |
| SWITCHNUM | Switch Document No. | EIDESWTNUM | * | CHAR (20) |
| MSGDATANUM | Message Data for Switch Document | EIDESWTMDNUM | CHAR (22) | |
| CATEGORY | Message Category | EIDESWTMDCAT | * | CHAR (3) |
| DEXTASKID | Internal Key for Data Exchange Task | E_DEXTASKID | CHAR (22) | |
| DIRECTION | Direction of Data Exchange | E_DEXDIRECTION | NUMC (1) | |
| COMPARTNER | Communication Partner | EIDESWTMDCOMPARTNER | * | CHAR (10) |
| IDREFNR | ID/Reference Number | EIDESWTMDIDREFNR | CHAR (35) | |
| METERNR | Meter Number | EIDESWTMDMETERNR | CHAR (35) | |
| NAME_L | Last name of business partner (person) | BU_NAMEP_L | CHAR (40) | |
| NAME_F | First name of business partner (person) | BU_NAMEP_F | CHAR (40) | |
| STREET | Street | AD_STREET | CHAR (60) | |
| HOUSENR | House Number | EIDESWTMDHOUSENR | CHAR (10) | |
| HOUSENREXT | Supplementary House Number | EIDESWTMDHOUSENREXT | CHAR (35) | |
| POSTCODE | City postal code | AD_PSTCD1 | CHAR (10) | |
| CITY | City | AD_CITY1 | CHAR (40) | |
| TRANSREASON | Transaction Reason | EIDESWTMDTRAN | * | CHAR (3) |
| SETTLRESP | Settlement Area Responsible | EIDESWTMDSETTLRESP | CHAR (35) | |
| METMETHOD | Metering Procedure | EIDESWTMDMETMETHOD | * | CHAR (3) |
| PROFILE | Profile | EIDESWTMDPROFILE | CHAR (35) | |
| MSGSTATUS | Answer Status | EIDESWTMDSTATUS | * | CHAR (3) |
| PROCSTATUS | Processing Status of Message | EIDESWTMDPROCSTATUS | * | CHAR (3) |
| PROCSTATUSTIMEST | UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) | TIMESTAMPL | DEC (21) | |
| EXT_UI | Point of Delivery ID | EXT_UI | CHAR (50) | |
| ERDAT | Date on which the record was created | ERDAT | DATS (8) | |
| ERNAM | Name of Person who Created the Object | ERNAM | CHAR (12) | |
| AEDAT | Date of Last Change | AEDAT | DATS (8) | |
| AENAM | Name of person who changed object | AENAM | CHAR (12) | |
| BEGRU | Authorization Group | BEGRU | CHAR (4) | |
| LOEVM | Deletion Indicator | LOEVM | CHAR (1) | |
| STREET_BU | Street | AD_STREET | CHAR (60) | |
| HOUSENR_BU | House Number | EIDESWTMDHOUSENR | CHAR (10) | |
| HOUSENREXT_BU | Supplementary House Number | EIDESWTMDHOUSENREXT | CHAR (35) | |
| POSTCODE_BU | City postal code | AD_PSTCD1 | CHAR (10) | |
| CITY_BU | City | AD_CITY1 | CHAR (40) | |
| SETTLUNITEXT | External Name of Settlement Unit | E_EDMSETTLUNITEXT | CHAR (40) | |
| MAXDEM_UNIT | Unit of Maximum Demand | EIDESWTMDMAXDUNIT | * | UNIT (3) |
| PRGYCONS_UNIT | Internal Unit of Forecasted Annual Consumption | EIDESWTMDPRGYCUNIT | * | UNIT (3) |
