SAP table EDMMS (Assignment of EDI partner to purchasing org. and plant)
SAP table EDMMS has 4 primary key fields being MANDT,LIFNR,KUNAG,KUNWE.
If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |
|---|---|---|---|---|---|---|---|
| MANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |
| LIFNR | Account Number of Supplier | CHAR | 10 | 0 | LFA1 | LIFNR | |
| KUNAG | Sold-To Party at Customer, Transferred via EDI by Supplier | CHAR | 20 | 0 | KUNAG_EDI | ||
| KUNWE | Ship-To Party at Customer, Transferred via EDI by Supplier | CHAR | 20 | 0 | KUNWE_EDI | ||
| EKORG | Purchasing organization | CHAR | 4 | 0 | T024E | EKORG | |
| EKGRP | Purchasing Group | CHAR | 3 | 0 | T024 | EKGRP | |
| WERKS | Plant | CHAR | 4 | 0 | T001W | WERKS_D | |
| BSART | Purchasing Document Type | CHAR | 4 | 0 | T161 | ESART | |
| BSART_RET | Purchasing Document Type for Returns Purchase Order | CHAR | 4 | 0 | T161 | EDI_ESART_RETRO_RPO | |
| LGORT_RETRO_RPO | Storage Location for Returns Purchase Order | CHAR | 4 | 0 | EDI_LGORT_RETRO_RPO |
EDMMS foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 EDMMS | BSART | T161 | Purchasing Document Types | MANDT |
| 1 EDMMS | BSART_RET | T161 | Purchasing Document Types | MANDT |
| 0 EDMMS | EKGRP | T024 | Purchasing Groups | EKGRP |
| 1 EDMMS | EKORG | T024E | Purchasing Organizations | EKORG |
| 0 EDMMS | LIFNR | LFA1 | Supplier Master (General Section) | MANDT |
| 0 EDMMS | LIFNR | LFA1 | Supplier Master (General Section) | LIFNR |
| 1 EDMMS | MANDT | T000 | Clients | MANDT |
| 0 EDMMS | WERKS | T001W | Plants/Branches | WERKS |