SAP table EKRS (ERS Procedure: Goods (Merchandise) Movements to be Invoiced)
SAP table EKRS has 6 primary key fields being MANDT,BUDAT,LIFNR,BELNR,BUZEI,GJAHR.
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 | MANDT | ||
| BUDAT | Posting Date in the Document | DATS | 8 | 0 | BUDAT | ||
| LIFNR | Vendor's account number | CHAR | 10 | 0 | ELIFN | ||
| BELNR | Number of Material Document | CHAR | 10 | 0 | MBLNR | ||
| BUZEI | Item in Material Document | NUMC | 4 | 0 | MBLPO | ||
| GJAHR | Material Document Year | NUMC | 4 | 0 | MJAHR | ||
| EBELN | Purchasing Document Number | CHAR | 10 | 0 | EBELN | ||
| EBELP | Item Number of Purchasing Document | NUMC | 5 | 0 | EBELP | ||
| BUKRS | Company Code | CHAR | 4 | 0 | BUKRS | ||
| WERKS | Plant | CHAR | 4 | 0 | WERKS_D | ||
| LFGJA | Fiscal Year of a Reference Document | NUMC | 4 | 0 | LFBJA | ||
| LFBNR | Document No. of a Reference Document | CHAR | 10 | 0 | LFBNR | ||
| LFPOS | Item of a Reference Document | NUMC | 4 | 0 | LFPOS | ||
| CPUDTTM | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | DEC | 15 | 0 | TIMESTAMP |