SAP table DFKKWOH (Write-Off History)
SAP table DFKKWOH has 6 primary key fields being MANDT,ABBEL,OPBEL,OPUPW,OPUPK,OPUPZ.
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 | ||||||||||||||||||||||||||||||
ABBEL | Contract account write-off document number | CHAR | 12 | 0 | ABBEL_KK | ||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||
OPUPZ | Subitem for a Partial Clearing in Document | NUMC | 3 | 0 | OPUPZ_KK | ||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||
WAERS | Currency Key | CUKY | 5 | 0 | WAERS_KK | ||||||||||||||||||||||||||||||
BETRW | Amount in Transaction Currency with +/- Sign | CURR | 13 | 2 | BETRW_KK | ||||||||||||||||||||||||||||||
ABGRD | Write-Off Reason | CHAR | 2 | 0 | ABGRD_KK | ||||||||||||||||||||||||||||||
ABDAT | Date | DATS | 8 | 0 | DATUM | ||||||||||||||||||||||||||||||
STAKZ | Type of statistical item | CHAR | 1 | 0 | STAKZ_KK |
|
|||||||||||||||||||||||||||||
HERKF | Document Origin Key | CHAR | 2 | 0 | HERKF_KK | ||||||||||||||||||||||||||||||
BLART | Document Type | CHAR | 2 | 0 | BLART_KK | ||||||||||||||||||||||||||||||
XRVSD | Item is reversed | CHAR | 1 | 0 | XRVSD_KK | ||||||||||||||||||||||||||||||
LAUFD | Date ID | DATS | 8 | 0 | LAUFD_KK | ||||||||||||||||||||||||||||||
LAUFI | Additional Identification Characteristic | CHAR | 6 | 0 | MLFID_KK |