The DFKKOPAA table in SAP ERP or S/4HANA stores Distribution Items with Account Assignment data. There are total 30 fields in DFKKOPAA table. The Distribution Items with Account Assignment 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 DFKKOPAA 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 DFKKOPAA Table Fields
Following is the list of fields that are available in SAP DFKKOPAA table. The primary key fields of Distribution Items with Account Assignment table in SAP are MANDT (Client), OPBEL (Number of a FI-CA Document), OPUPK (Item Number in FI-CA Document), OPUPS (Item Number of Account Assignment).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | CLNT (3) | |
| OPBEL | Number of a FI-CA Document | OPBEL_KK | CHAR (12) | |
| OPUPK | Item Number in FI-CA Document | OPUPK_KK | NUMC (4) | |
| OPUPS | Item Number of Account Assignment | OPUPS_KK | NUMC (4) | |
| BETRH | Amount In Local Currency With +/- Signs | BETRH_KK | CURR (13) | |
| BETRW | Amount in Transaction Currency with +/- Sign | BETRW_KK | CURR (13) | |
| BETR2 | Amount in Second Parallel Currency with +/- Sign | BETR2_KK | CURR (13) | |
| BETR3 | Amount in Third Parallel Currency with +/- Sign | BETR3_KK | CURR (13) | |
| SBASH | Amount Subject to Tax in Local Currency (Tax Base Amount) | SBASH_KK | CURR (13) | |
| SBASW | Amount Subject to Tax in Transaction Currency (Tax Base Amt) | SBASW_KK | CURR (13) | |
| BETRH_CL | Amount In Local Currency With +/- Signs | BETRH_KK | CURR (13) | |
| BETRW_CL | Amount in Transaction Currency with +/- Sign | BETRW_KK | CURR (13) | |
| BETR2_CL | Amount in Second Parallel Currency with +/- Sign | BETR2_KK | CURR (13) | |
| BETR3_CL | Amount in Third Parallel Currency with +/- Sign | BETR3_KK | CURR (13) | |
| SBASH_CL | Amount Subject to Tax in Local Currency (Tax Base Amount) | SBASH_KK | CURR (13) | |
| SBASW_CL | Amount Subject to Tax in Transaction Currency (Tax Base Amt) | SBASW_KK | CURR (13) | |
| TXRID_LAST | ID of a Report for Tax Reporting | TXRID_KK | CHAR (12) | |
| TXRCR | Sequence Number of Tax Report | TXRCR_KK | INT4 (10) | |
| GSBER | Business Area | GSBER | TGSB | CHAR (4) |
| SEGMENT | Segment for Segmental Reporting | SEGMT_KK | FAGL_SEGM | CHAR (10) |
| PRCTR | Profit Center | PRCTR | CHAR (10) | |
| ORIGFIKRS | Original FM Area for FM Account Assignment | ORIGFIKRS_KK | * | CHAR (4) |
| FIPEX | Commitment item | FM_FIPEX | * | CHAR (24) |
| FISTL | Funds Center | FISTL | * | CHAR (16) |
| FONDS | Fund | BP_GEBER | * | CHAR (10) |
| FKBER | Functional Area | FKBER | * | CHAR (16) |
| MEASURE | Funded Program | FM_MEASURE | * | CHAR (24) |
| GRANT_NBR | Grant | GM_GRANT_NBR | CHAR (20) | |
| BUDGETYEAR | Original Year for FM Account Assignment | FM_START_OF_CHAIN | NUMC (4) | |
| BUDGET_PD | Budget Period | FM_BUDGET_PERIOD | * | CHAR (10) |
