SAP table DFKKZW2 (Doubtful/Indiv. Val. Adjustments for Receivables - Tfr Pstg)

SAP table DFKKZW2 has 6 primary key fields being MANDT,OPBEL,OPUPW,OPUPK,BUDAT,LFDNR.

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
OPBEL Number of a FI-CA Document CHAR 12 0 OPBEL_KK
OPUPW Repetition Item in FI-CA Document NUMC 3 0 OPUPW_KK
OPUPK Item Number in FI-CA Document NUMC 4 0 OPUPK_KK
BUDAT Posting Date in the Document DATS 8 0 BUDAT_KK
LFDNR Sequence Number (Internal Use Only) NUMC 3 0 LFDNR_KK
WAERS Currency Key CUKY 5 0 WAERS_KK
WBUBT Posted amount of value adjustment in transaction currency CURR 13 2 WBUBT_KK
WBUDT Transfer date for value adjustment DATS 8 0 WBUDT_KK
SBETU Posted Tax Amount in Transaction Currency CURR 13 2 SBETU_KK
SBETW Tax Amount in Transaction Currency with +/- Sign CURR 13 2 SBETW_KK
WZUBT Posted Amount for Doubtful Entry in Transaction Currency CURR 13 2 WZUBT_KK
WZUDT Transfer date of doubtful entry DATS 8 0 WZUDT_KK
BFBDT Date of Doubtful Entry / Individual Value Adjustment DATS 8 0 WZDAT_KK
PROZT Percentage share of value adjustment NUMC 3 0 PROZT_KK
WBBTR Specified Value Adjustment Amount CURR 13 2 WBBTR_KK
WFZBT Total Amount of Doubtful Entry CURR 13 2 WFZBT_KK
EWBBT Total Amount of Value Adjustment CURR 13 2 EWBBT_KK
GRUND Adjustment reason CHAR 2 0 GRUND_KK
RGRND Reset Reason for Doubtful Entry/ Value Adjustment CHAR 2 0 RGRND_KK
REDAT Reset Date for Doubtful Entry/ Value Adjustment DATS 8 0 REDAT_KK
AENAM Last Changed By CHAR 12 0 AENAM_KK
ACPDT Date the object was last changed DATS 8 0 ACPDT_KK
ACPTM Time the object was last changed TIMS 6 0 ACPTM_KK
FIKEY Reconciliation Key for General Ledger CHAR 12 0 FIKEY_KK
LAUFD Date ID DATS 8 0 LAUFD_KK
LAUFI Run ID CHAR 6 0 LAUFI_KK
WZKON G/L account number of doubtful entry account CHAR 10 0 WZKON_KK
WBAKO Expense account for value adjustment CHAR 10 0 WBAKO_KK
WBKKO Adjustment account for value adjustment CHAR 10 0 WBKKO_KK
WZKKO Adjustment Account for Doubtful Receivables CHAR 10 0 WZKKO_KK
STOZW Reversal indicator for adjusted receivables CHAR 1 0 STOZW_KK
created by transfer posting run
1 created by reversal run
2 created by transfer posting run and reversed by reversal run
GBRAB Amount Posted for Reset of Value Adjustment Due to Write-Off CURR 13 2 GBRAB_KK
GSRAB Total Amount for Reset of Valued Adjustment Due to Write-Off CURR 13 2 GSRAB_KK
GBRZB Amount Posted for Reset of Value Adjustment Due to Payment CURR 13 2 GBRZB_KK
GSRZB Total Amount for Reset of Value Adjustment Due to Payment CURR 13 2 GSRZB_KK
WBRAK Account for Reset of Value Adjustment through Write-Off CHAR 10 0 SKA1 WBRAK_KK
WBRZK Account for Reset of Value Adjustment through Payment CHAR 10 0 SKA1 WBRZK_KK
GBRWB Amount Posted for Reset of Value Adjustment Due to VA Change CURR 13 2 GBRWB_KK
GSRWB Total Amount for Reset of Value Adjustment Due to VA Change CURR 13 2 GSRWB_KK
WBRWK Account for Reset of Value Adjustment Due to Val.Adj.Change CHAR 10 0 SKA1 WBRWK_KK
GBRVB Amount Posted for Reset of Value Adjustment Due to Sale CURR 13 2 GBRVB_KK
GSRVB Total Amount for Reset of Value Adjustment Due to Sale CURR 13 2 GSRVB_KK
WBRVK Account for Reset of Value Adjustment Due to Sale CHAR 10 0 SKA1 WBRVK_KK
GBRSB Amount Posted for Reset of Value Adjustment Due to Reversal CURR 13 2 GBRSB_KK
GSRSB Total Amount for Reset of Value Adjustment Due to Reversal CURR 13 2 GSRSB_KK
WBRSK Account for Reset of Value Adjustment Due to Reversal CHAR 10 0 SKA1 WBRSK_KK
WBNET Net Amount of Value Adjustment for Reporting CURR 13 2 WBNET_KK
WBSKO Tax Account for Value Adjustment CHAR 10 0 SKA1 WBSKO_KK
RISK_CLASS Risk Class CHAR 3 0 UKM_RISK_CLASS
BUKRS Company Code CHAR 4 0 BUKRS
GPART Business Partner Number CHAR 10 0 GPART_KK
VKONT Contract Account Number CHAR 12 0 VKONT_KK
ECL_RATE Expected Credit Loss Percentage DEC 7 4 FINS_ECL_RATE
INCRMNT Aging Increment CHAR 15 0 FINS_INCRMNT
AGING Aging CHAR 10 0 FINS_AGING
DWBUBTH Transfer amt of value adjustment in local currency CURR 13 2 WBUBTH_KK
DWBUBT2 Transfer Amt of Value Adjustment in Parallel Currency 2 CURR 13 2 WBUBT2_KK
DWBUBT3 Transfer amt of value adjustment in parallel currency 3 CURR 13 2 WBUBT3_KK
EWBBTH Total Amount of Value Adjustment in Local Currency CURR 13 2 EWBBTH_KK
EWBBT2 Total Amount of Value Adjustment in prallel currency 2 CURR 13 2 EWBBT2_KK
EWBBT3 Total Amount of Value Adjustment in prallel currency 3 CURR 13 2 EWBBT3_KK
GBRABH Amount Posted for Reset Due to Write-Off in Local Currency CURR 13 2 GBRABH_KK
GBRAB2 Amount Posted for Reset Due to Write-Off in Local Currency 2 CURR 13 2 GBRAB2_KK
GBRAB3 Amount Posted for Reset Due to Write-Off in Local Currency 3 CURR 13 2 GBRAB3_KK
GSRABH Total Amount for Reset Due to Write-Off in Local Currency 2 CURR 13 2 GSRAB2_KK
GSRAB2 Total Amount for Reset Due to Write-Off in Local Currency 3 CURR 13 2 GSRAB3_KK
GSRAB3 Total Amount for Reset Due to Write-Off in Local Currency 3 CURR 13 2 GSRAB3_KK
GBRZBH Amount Posted for Reset Due to Payment in Local Currency CURR 13 2 GBRZBH_KK
GBRZB2 Amount Posted for Reset Due to Payment in Local Currency 2 CURR 13 2 GBRZB2_KK
GBRZB3 Amount Posted for Reset Due to Payment in Local Currency 3 CURR 13 2 GBRZB3_KK
GSRZBH Total Amount for Reset Due to Payment in Local Currency CURR 13 2 GSRZBH_KK
GSRZB2 Total Amount for Reset Due to Payment in Local Currency 2 CURR 13 2 GSRZB2_KK
GSRZB3 Total Amount for Reset Due to Payment in Local Currency 3 CURR 13 2 GSRZB3_KK
GBRWBH Amount Posted for Reset Due to VA Change in Local Currency CURR 13 2 GBRWBH_KK
GBRWB2 Amount Posted for Reset Due to VA Change in Local Currency 2 CURR 13 2 GBRWB2_KK
GBRWB3 Amount Posted for Reset Due to VA Change in Local Currency 3 CURR 13 2 GBRWB3_KK
GSRWBH Total Amount for Reset Due to VA Change in Local Currency CURR 13 2 GSRWBH_KK
GSRWB2 Total Amount for Reset Due to VA Change in Local Currency 2 CURR 13 2 GSRWB2_KK
GSRWB3 Total Amount for Reset Due to VA Change in Local Currency 3 CURR 13 2 GSRWB3_KK
GBRVBH Amount Posted for Reset Due to Sale in Local Currency CURR 13 2 GBRVBH_KK
GBRVB2 Amount Posted for Reset Due to Sale in Local Currency 2 CURR 13 2 GBRVB2_KK
GBRVB3 Amount Posted for Reset Due to Sale in Local Currency 3 CURR 13 2 GBRVB3_KK
GSRVBH Total Amount for Reset Due to Sale in Local Currency CURR 13 2 GSRVBH_KK
GSRVB2 Total Amount for Reset Due to Sale in Local Currency 2 CURR 13 2 GSRVB2_KK
GSRVB3 Total Amount for Reset Due to Sale in Local Currency 3 CURR 13 2 GSRVB3_KK
GBRSBH Amount Posted for Reset Due to Reversal in Local Currency CURR 13 2 GBRSBH_KK
GBRSB2 Amount Posted for Reset Due to Reversal in Local Currency 2 CURR 13 2 GBRSB2_KK
GBRSB3 Amount Posted for Reset Due to Reversal in Local Currency 3 CURR 13 2 GBRSB3_KK
GSRSBH Total Amount for Reset Due to Reversal in Local Currency CURR 13 2 GSRSBH_KK
GSRSB2 Total Amount for Reset Due to Reversal in Local Currency 2 CURR 13 2 GSRSB2_KK
GSRSB3 Total Amount for Reset Due to Reversal in Local Currency 3 CURR 13 2 GSRSB3_KK
GBFXBH Amount Posted for Realized FX in Local Currency CURR 13 2 GBFXBH_KK
GBFXB2 Amount Posted for Realized FX in Local Currency 2 CURR 13 2 GBFXB2_KK
GBFXB3 Amount Posted for Realized FX in Local Currency 3 CURR 13 2 GBFXB3_KK
GRFXBH Total Amount for Realized FX in Local Currency CURR 13 2 GRFXBH_KK
GRFXB2 Total Amount for Realized FX in Local Currency 2 CURR 13 2 GRFXB2_KK
GRFXB3 Total Amount for Realized FX in Local Currency 3 CURR 13 2 GRFXB3_KK
WFXLKO Realized foreign currency losses account CHAR 10 0 WFXLKO_KK
WFXGKO Realized Foreign Currency Gains Account CHAR 10 0 WFXGKO_KK
/SAPCE/GBRAB Posted amount. for reset of IVA because of write-off CURR 13 2 /SAPCE/FK_GBRAB
/SAPCE/GSRAB Total amount for reset of IVA because of write-off CURR 13 2 /SAPCE/FK_GSRAB
/SAPCE/GBRZB Posted amount. for reset of IVA because of payment CURR 13 2 /SAPCE/FK_GBRZB
/SAPCE/GSRZB Total amount. for reset of IVA because of payment CURR 13 2 /SAPCE/FK_GSRZB
/SAPCE/WBRAK Account for reset of IVA bacause of write-off CHAR 10 0 * /SAPCE/FK_WBRAK
/SAPCE/WBRZK Account for reset of IVA bacause of payment CHAR 10 0 * /SAPCE/FK_WBRZK

DFKKZW2 foreign key relationships

Table Field Check Table Check Field
0 DFKKZW2 WBRAK SKA1 G/L Account Master (Chart of Accounts) MANDT
0 DFKKZW2 WBRAK SKA1 G/L Account Master (Chart of Accounts) KTOPL
0 DFKKZW2 WBRAK SKA1 G/L Account Master (Chart of Accounts) SAKNR
1 DFKKZW2 WBRSK SKA1 G/L Account Master (Chart of Accounts) MANDT
1 DFKKZW2 WBRSK SKA1 G/L Account Master (Chart of Accounts) KTOPL
1 DFKKZW2 WBRSK SKA1 G/L Account Master (Chart of Accounts) SAKNR
0 DFKKZW2 WBRVK SKA1 G/L Account Master (Chart of Accounts) MANDT
0 DFKKZW2 WBRVK SKA1 G/L Account Master (Chart of Accounts) KTOPL
0 DFKKZW2 WBRVK SKA1 G/L Account Master (Chart of Accounts) SAKNR
1 DFKKZW2 WBRWK SKA1 G/L Account Master (Chart of Accounts) MANDT
1 DFKKZW2 WBRWK SKA1 G/L Account Master (Chart of Accounts) KTOPL
1 DFKKZW2 WBRWK SKA1 G/L Account Master (Chart of Accounts) SAKNR
0 DFKKZW2 WBRZK SKA1 G/L Account Master (Chart of Accounts) MANDT
0 DFKKZW2 WBRZK SKA1 G/L Account Master (Chart of Accounts) KTOPL
0 DFKKZW2 WBRZK SKA1 G/L Account Master (Chart of Accounts) SAKNR
1 DFKKZW2 WBSKO SKA1 G/L Account Master (Chart of Accounts) MANDT
1 DFKKZW2 WBSKO SKA1 G/L Account Master (Chart of Accounts) KTOPL
1 DFKKZW2 WBSKO SKA1 G/L Account Master (Chart of Accounts) SAKNR