1. Home
  2. Resources
  3. SAP Tables
  4. DFKKRDI - Revenue Distribution

SAP Table DFKKRDI

Revenue Distribution

DFKKRDI (Revenue Distribution) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link DFKKRDI to other SAP tables.

DFKKRDI table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT CLNT 3 0
LAUFD Date ID LAUFD_KK DATS 8 0
LAUFI Additional Identification Characteristic LAUFI_KK CHAR 6 0
FINRE Contract Account of Final Recipient FINRE_KK CHAR 12 0
OPBEL Number of Contract Accts Rec. & Payable Doc. OPBEL_KK DFKKKO CHAR 12 0
OPUPW Repetition Item in Contract Account Document OPUPW_KK NUMC 3 0
OPUPK Item number in contract account document OPUPK_KK NUMC 4 0
OPUPZ Subitem for a Partial Clearing in Document OPUPZ_KK NUMC 3 0
CORRECT Revenue Distribution: Correction Record CORRD_KK CHAR 1 0
NULL Normal Distribution Record (After Payment)
X Adjustment Record (After Clearing Reset)
R Item Reversed
S Distribution Was Simulated (Before Payment)
OPBELD Distribution Document Number RDI_OPBEL_DIS_KK CHAR 12 0
GPART Business Partner Number GPART_KK BUT000 CHAR 10 0
VKONT Contract Account Number VKONT_KK CHAR 12 0
VTREF Reference Specifications from Contract VTREF_KK CHAR 20 0
VTPOS Contract: Item Number VTPOS_KK NUMC 6 0
XBLNR Reference document number XBLNR_KK CHAR 16 0
WAERS Transaction Currency BLWAE_KK CUKY 5 0
BETRW Amount in Transaction Currency with +/- Sign BETRW_KK CURR 13 2
HVORG Main Transaction for Distribution Line Item RDI_HVORG_DISTR_KK TFKHVO CHAR 4 0
TVORG Subtransaction for Distribution Document Item RDI_TVORG_DISTR_KK TFKTVO CHAR 4 0
SUBAP Subapplication in Contract Accounts Receivable and Payable SUBAP_KK CHAR 1 0
9 Real Estate
XDETDOC Individual Document Posting for Revenue Distribution XDETDOCRDI_KK CHAR 1 0
X Yes
NULL No
XNEGP Negative Posting for Revenue Distribution XNEGP_RDI_KK CHAR 1 0
X Yes
NULL No
BETRW_ORIG Amount in Transaction Currency with +/- Sign BETRW_KK CURR 13 2
KOFIZ Account Determination ID KOFIZ_KK CHAR 2 0
DISTYP Category of Revenue Distribution RDI_DISTYP_KK CHAR 1 0
NULL Classic Revenue Distribution
K Distribution of Assigned Payments
N Distribution of Unassigned Payments
A Distribution of Expected Revenues
S Reversal of Distribution of Payments
R Reversal of Distribution of Expected Revenues
DISKEY Key of Revenue Distribution (GUID) RDI_DISKEY_KK CHAR 22 0
DISPER Distribution Period DISPER_KK CHAR 8 0
DOC_KEY GUID for Documents (Revenue Distribution) RDI_DOC_KEY_KK CHAR 22 0
XAGGR Aggregated Posting of Revenue Distribution RDI_XAGGR_KK CHAR 1 0
X Yes
NULL No
XAGGR_BASE Included in Aggregated Distribution Information RDI_XAGGR_BASE_KK CHAR 1 0
X Yes
NULL No
XREV Distribution Reversed RDI_XREV_KK CHAR 1 0
X Yes
NULL No
BUKRS Company Code BUKRS CHAR 4 0
HVORG_ORIG Main Transaction for Original Line Item RDI_HVORG_ORIG_KK CHAR 4 0
TVORG_ORIG Subtransaction for Original Line Item RDI_TVORG_ORIG_KK CHAR 4 0
DISGRP Distribution group RDI_DISGRP_KK TFKRDI_DISGRP CHAR 3 0
PERSL Revenue Distribution: Application Period RDI_APPL_PERIOD_KK TFK001P CHAR 4 0
CPUDT Day On Which Accounting Document Was Entered CPUDT DATS 8 0
CPUTM Time of Entry CPUTM TIMS 6 0
LAUFD_POST Date ID LAUFD_KK DATS 8 0
LAUFI_POST Additional Identification Characteristic LAUFI_KK CHAR 6 0
CPUDT_POST Day On Which Accounting Document Was Entered CPUDT DATS 8 0
CPUTM_POST Time of Entry CPUTM TIMS 6 0

DFKKRDI foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
DFKKRDI DISGRP SYST MANDT TFKRDI_DISGRP Distribution Groups MANDT
DFKKRDI DISGRP DFKKRDI DISGRP TFKRDI_DISGRP Distribution Groups DISGRP
DFKKRDI GPART DFKKRDI MANDT BUT000 BP: General data I CLIENT
DFKKRDI GPART DFKKRDI GPART BUT000 BP: General data I PARTNER
DFKKRDI HVORG DFKKRDI MANDT TFKHVO Main transactions in contract accts receivable and payable MANDT
DFKKRDI HVORG * TFKHVO Main transactions in contract accts receivable and payable APPLK
DFKKRDI HVORG DFKKRDI HVORG TFKHVO Main transactions in contract accts receivable and payable HVORG
DFKKRDI OPBEL DFKKRDI MANDT DFKKKO Header Data in Open Item Accounting Document MANDT
DFKKRDI OPBEL DFKKRDI OPBEL DFKKKO Header Data in Open Item Accounting Document OPBEL
DFKKRDI PERSL SYST MANDT TFK001P Period key MANDT
DFKKRDI PERSL DFKKRDI PERSL TFK001P Period key PERSL
DFKKRDI TVORG DFKKRDI MANDT TFKTVO Sub-transactions in Contract Accounts Receivable and Payable MANDT
DFKKRDI TVORG * TFKTVO Sub-transactions in Contract Accounts Receivable and Payable APPLK
DFKKRDI TVORG DFKKRDI HVORG TFKTVO Sub-transactions in Contract Accounts Receivable and Payable HVORG
DFKKRDI TVORG DFKKRDI TVORG TFKTVO Sub-transactions in Contract Accounts Receivable and Payable TVORG