The EKRS table in SAP ERP or S/4HANA stores ERS Procedure: Goods (Merchandise) Movements to be Invoiced data. There are total 14 fields in EKRS table. The ERS Procedure: Goods (Merchandise) Movements to be Invoiced 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 EKRS table. It is in Purchasing (ME) ABAP package and is part of the Purchasing (MM-PUR) module.
SAP EKRS Table Fields
Following is the list of fields that are available in SAP EKRS table. The primary key fields of the table are MANDT (Client), BUDAT (Posting Date in the Document), LIFNR (Vendor’s account number), BELNR (Number of Material Document), BUZEI (Item in Material Document), GJAHR (Material Document Year).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | * | CLNT (3) |
| BUDAT | Posting Date in the Document | BUDAT | DATS (8) | |
| LIFNR | Vendor’s account number | ELIFN | * | CHAR (10) |
| BELNR | Number of Material Document | MBLNR | CHAR (10) | |
| BUZEI | Item in Material Document | MBLPO | NUMC (4) | |
| GJAHR | Material Document Year | MJAHR | NUMC (4) | |
| EBELN | Purchasing Document Number | EBELN | * | CHAR (10) |
| EBELP | Item Number of Purchasing Document | EBELP | * | NUMC (5) |
| BUKRS | Company Code | BUKRS | * | CHAR (4) |
| WERKS | Plant | WERKS_D | * | CHAR (4) |
| LFGJA | Fiscal Year of a Reference Document | LFBJA | NUMC (4) | |
| LFBNR | Document No. of a Reference Document | LFBNR | CHAR (10) | |
| LFPOS | Item of a Reference Document | LFPOS | NUMC (4) | |
| CPUDTTM | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TIMESTAMP | DEC (15) |
