The DFKKREPZM table in SAP ERP or S/4HANA stores Recording Data for EC Sales List data. There are total 26 fields in DFKKREPZM table. The Recording Data for EC Sales List 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 DFKKREPZM table. It is in Contract A/R & A/P: Central Objects (FKKB) ABAP package and is part of the Contract Accounts Receivable and Payable (FI-CA) module.
SAP DFKKREPZM Table Fields
Following is the list of fields that are available in SAP DFKKREPZM table. The primary key fields of the table are MANDT (Client), BUKRS (Company Code), DATTY (Reporting Date Type for EC Sales List), DATUM (Date for EC Sales List), GPART (Business Partner Number), OPBEL (Number of a FI-CA Document), LFDNR (Sequence Number for Entries for EC Sales List).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | CLNT (3) | |
| BUKRS | Company Code | BUKRS | T001 | CHAR (4) |
| DATTY | Reporting Date Type for EC Sales List | DATTY_ZM_KK | CHAR (1) | |
| DATUM | Date for EC Sales List | DATUM_ZM_KK | DATS (8) | |
| GPART | Business Partner Number | GPART_KK | CHAR (10) | |
| OPBEL | Number of a FI-CA Document | OPBEL_KK | CHAR (12) | |
| LFDNR | Sequence Number for Entries for EC Sales List | LFDNR_ZM_KK | NUMC (6) | |
| MWSKZ | Tax on sales/purchases code | MWSKZ | CHAR (2) | |
| MWART | Tax Type | MWART | CHAR (1) | |
| EGRKZ | EU Code/Code | EGRKZ | CHAR (1) | |
| LWAER | Country Currency | WAERS_005 | TCURC | CUKY (5) |
| HWAER | Local Currency | HWAER | TCURC | CUKY (5) |
| LWBAS | Tax Base Amount in National Currency | LWBAS_ZM_KK | CURR (13) | |
| HWBAS | Tax Base Amount in Local Currency | HWBAS_ZM_KK | CURR (13) | |
| LSTML | Country for Tax Return | LAND1_STML | T005 | CHAR (3) |
| XBLNR | Reference document number | XBLNR_KK | CHAR (16) | |
| BUDAT | Posting Date in the Document | BUDAT_KK | DATS (8) | |
| BLDAT | Document Date in Document | BLDAT | DATS (8) | |
| FAEDN | Due date for net payment | FAEDN_KK | DATS (8) | |
| VATDATE | Tax Reporting Date | VATDATE_KK | DATS (8) | |
| STBEL | Number of Reversed Document | STBEL_KK | CHAR (12) | |
| STCEG | VAT Registration Number | STCEG | CHAR (20) | |
| LAND1 | Country/Region Key | LAND1 | T005 | CHAR (3) |
| NAME1 | Name field 1 (name1/last name) | BU_NAME1 | CHAR (40) | |
| GPRTP | Type of Business Partner Reference | GPRTP_KK | CHAR (1) | |
| GPREF | Reference to a Business Partner | GPREF_KK | CHAR (10) |
