The DFKKZWFP table in SAP ERP or S/4HANA stores Doubtful/Individually Adjusted Receivables: Tfrd Receivables data. There are total 59 fields in DFKKZWFP table. The Doubtful/Individually Adjusted Receivables: Tfrd Receivables 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 DFKKZWFP 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 DFKKZWFP Table Fields
Following is the list of fields that are available in SAP DFKKZWFP table. The primary key fields of the table are MANDT (Client), OPBEL (Number of a FI-CA Document), OPUPW (Repetition Item in FI-CA Document), OPUPK (Item Number in FI-CA Document), BUDAT (Posting Date in the Document), BWBER (Valuation Area for FI-CA Year-End Closing), LFDNR (Sequence Number (Internal Use Only)).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | CLNT (3) | |
| OPBEL | Number of a FI-CA Document | OPBEL_KK | CHAR (12) | |
| OPUPW | Repetition Item in FI-CA Document | OPUPW_KK | NUMC (3) | |
| OPUPK | Item Number in FI-CA Document | OPUPK_KK | NUMC (4) | |
| BUDAT | Posting Date in the Document | BUDAT_KK | DATS (8) | |
| BWBER | Valuation Area for FI-CA Year-End Closing | BWBER_KK | CHAR (3) | |
| LFDNR | Sequence Number (Internal Use Only) | LFDNR_KK | NUMC (3) | |
| BUKRS | Company Code | BUKRS | T001 | CHAR (4) |
| GPART | Business Partner Number | GPART_KK | BUT000 | CHAR (10) |
| VKONT | Contract Account Number | VKONT_KK | CHAR (12) | |
| WAERS | Currency Key | WAERS_KK | CUKY (5) | |
| WBUBT | Posted amount of value adjustment in transaction currency | WBUBT_KK | CURR (13) | |
| WBUDT | Transfer date for value adjustment | WBUDT_KK | DATS (8) | |
| SBETU | Posted Tax Amount in Transaction Currency | SBETU_KK | CURR (13) | |
| SBETW | Tax Amount in Transaction Currency with +/- Sign | SBETW_KK | CURR (13) | |
| WZUBT | Posted Amount for Doubtful Entry in Transaction Currency | WZUBT_KK | CURR (13) | |
| WZUDT | Transfer date of doubtful entry | WZUDT_KK | DATS (8) | |
| BFBDT | Date of Doubtful Entry / Individual Value Adjustment | WZDAT_KK | DATS (8) | |
| PROZT | Percentage share of value adjustment | PROZT_KK | NUMC (3) | |
| WBBTR | Specified Value Adjustment Amount | WBBTR_KK | CURR (13) | |
| WFZBT | New Amount of Doubtful Entry | WFZBT_KK | CURR (13) | |
| EWBBT | New Amount for Value Adjustment | EWBBT_KK | CURR (13) | |
| GRUND | Adjustment reason | GRUND_KK | CHAR (2) | |
| RGRND | Reset Reason for Doubtful Entry/ Value Adjustment | RGRND_KK | CHAR (2) | |
| REDAT | Reset Date for Doubtful Entry/ Value Adjustment | REDAT_KK | DATS (8) | |
| AENAM | Last Changed By | AENAM_KK | CHAR (12) | |
| ACPDT | Date the object was last changed | ACPDT_KK | DATS (8) | |
| ACPTM | Time the object was last changed | ACPTM_KK | TIMS (6) | |
| FIKEY | Reconciliation Key for General Ledger | FIKEY_KK | CHAR (12) | |
| LAUFD | Date ID | LAUFD_KK | DATS (8) | |
| LAUFI | Run ID | LAUFI_KK | CHAR (6) | |
| WZKON | G/L account number of doubtful entry account | WZKON_KK | CHAR (10) | |
| WBAKO | Expense account for value adjustment | WBAKO_KK | CHAR (10) | |
| WBKKO | Adjustment account for value adjustment | WBKKO_KK | CHAR (10) | |
| WZKKO | Adjustment Account for Doubtful Receivables | WZKKO_KK | CHAR (10) | |
| STOZW | Reversal indicator for adjusted receivables | STOZW_KK | CHAR (1) | |
| GBRAB | Amount Posted for Reset of Value Adjustment Due to Write-Off | GBRAB_KK | CURR (13) | |
| GSRAB | Total Amount for Reset of Valued Adjustment Due to Write-Off | GSRAB_KK | CURR (13) | |
| GBRZB | Amount Posted for Reset of Value Adjustment Due to Payment | GBRZB_KK | CURR (13) | |
| GSRZB | Total Amount for Reset of Value Adjustment Due to Payment | GSRZB_KK | CURR (13) | |
| WBRAK | Account for Reset of Value Adjustment through Write-Off | WBRAK_KK | SKA1 | CHAR (10) |
| WBRZK | Account for Reset of Value Adjustment through Payment | WBRZK_KK | SKA1 | CHAR (10) |
| GBRWB | Amount Posted for Reset of Value Adjustment Due to VA Change | GBRWB_KK | CURR (13) | |
| GSRWB | Total Amount for Reset of Value Adjustment Due to VA Change | GSRWB_KK | CURR (13) | |
| WBRWK | Account for Reset of Value Adjustment Due to Val.Adj.Change | WBRWK_KK | SKA1 | CHAR (10) |
| GBRVB | Amount Posted for Reset of Value Adjustment Due to Sale | GBRVB_KK | CURR (13) | |
| GSRVB | Total Amount for Reset of Value Adjustment Due to Sale | GSRVB_KK | CURR (13) | |
| WBRVK | Account for Reset of Value Adjustment Due to Sale | WBRVK_KK | SKA1 | CHAR (10) |
| GBRSB | Amount Posted for Reset of Value Adjustment Due to Reversal | GBRSB_KK | CURR (13) | |
| GSRSB | Total Amount for Reset of Value Adjustment Due to Reversal | GSRSB_KK | CURR (13) | |
| WBRSK | Account for Reset of Value Adjustment Due to Reversal | WBRSK_KK | SKA1 | CHAR (10) |
| WBNET | Net Amount of Value Adjustment for Reporting | WBNET_KK | CURR (13) | |
| WBSKO | Tax Account for Value Adjustment | WBSKO_KK | SKA1 | CHAR (10) |
| COLOGRP | Colocation Group for Business Partner | COLOGRP_BP_KK | CHAR (12) | |
| RISK_CLASS | Risk Class | UKM_RISK_CLASS | CHAR (3) | |
| INCRMNT | Aging Increment | FINS_INCRMNT | CHAR (15) | |
| AGING | Aging | FINS_AGING | CHAR (10) | |
| VA_PURPOSE | Purpose for Value Adjustment | VA_PURPOSE_KK | CHAR (2) | |
| BWVAR | Valuation Variant in FI-CA Year-End Closing | BWVAR_KK | TFK044C | CHAR (3) |
