The DFKKAWM table in SAP ERP or S/4HANA stores Foreign Trade Reporting: Report File data. There are total 26 fields in DFKKAWM table. The Foreign Trade Reporting: Report File table is available in all major of SAP S/4HANA versions and is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of DFKKAWM table. It is in FI-CA: Foreign Trade Declaration (FKK_AWM) ABAP package and is part of the Contract Accounts Receivable and Payable (FI-CA) module.
SAP DFKKAWM Table Fields
Following is the list of fields that are available in SAP DFKKAWM table. The primary key fields of Foreign Trade Reporting: Report File table in SAP are MANDT (Client).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | * | CLNT (3) |
| MLLAND | Country Key | MLLAND_KK | T005 | CHAR (3) |
| MLTYP | Rep Type | MLTYP_KK | TFKAWM005 | CHAR (5) |
| MLKZV | Directory of Report Keys | MLKZV_KK | TFKAWM002 | CHAR (5) |
| MLKZINT | Report Key (Internal) | MLKZINT_KK | TFKAWM003 | CHAR (8) |
| MLWAERS | Reporting Currency | MLWAERS_KK | * | CUKY (5) |
| MLBETR | Amount in Report Currency with +/-Sign | MLBETR_KK | CURR (13) | |
| TRWAERS | Transaction Currency of Report Document | TRWAERS_KK | * | CUKY (5) |
| TRBETR | Amount of Report Doc.in Transaction Currency with +/-Sign | TRBETR_KK | CURR (13) | |
| DOC1T | Type of Report Document | DOC1TM_KK | CHAR (2) | |
| DOC1R | Reference for Report Document | DOC1RM_KK | CHAR (24) | |
| GPA1T | Business Partner Category | GPA1T_PAY | CHAR (2) | |
| GPA1R | Business Partner Reference | GPA1R_PAY | CHAR (12) | |
| BUKRS | Company Code | BUKRS | T001 | CHAR (4) |
| KORRDOC | Document Number of Adjusted Report Documents | KORRDOC_KK | CHAR (24) | |
| KZKORR | Adjustment Records Exist | KZKORR_KK | CHAR (1) | |
| MLVDAT | Report Proposal Date | MLVDAT_KK | DATS (8) | |
| MLDAT | Reporting Date | MLDAT_KK | DATS (8) | |
| MLSTAT | Report Status | MLSTAT_KK | CHAR (1) | |
| MLAKT | Activation Status | MLAKT_KK | CHAR (1) | |
| MLDATA | Additional Report Data | MLDATA_KK | CHAR (40) | |
| ERNAM | Name of Person who Created the Object | ERNAM | CHAR (12) | |
| CPUDT | Date of Entry in Report File | MLCPUDT_KK | DATS (8) | |
| AENAM | Name of person who changed object | AENAM | CHAR (12) | |
| AEDAT | Date of Last Change | AEDAT | DATS (8) | |
| AWSYS | Logical System | LOGSYSTEM | * | CHAR (10) |
