SAP Table FKKRA_RAI_MI_DATA (Data of Transfer Records to Revenue Accounting (Main))

Field Description Data Type Length Decimals Checktable Data Element
SRCDOC_COMP Source Item Sender Component CHAR 3 0 RAI_SRCCO_KK
SRCDOC_LOGSYS Logical System of the Source Item CHAR 10 0 RAI_SRCLS_KK
SRCDOC_TYPE Source Item Type CHAR 4 0 TFK_RA_SRCTY RAI_SRCTY_KK
SRCDOC_ID Source Item ID CHAR 35 0 RAI_SRCID_KK
TIMESTAMP_UTC Time at Which Revenue Accounting Item Generated (UTC) DEC 15 0 RAI_TMSTMP_KK
HEADER_ID Header ID of Source Document for Revenue Accounting Item CHAR 20 0 RAI_HEADER_ID_KK
ITEM_ID Item ID of Source Document for Revenue Accounting Item CHAR 15 0 RAI_ITEM_ID_KK
SERVICE_TYPE Service Type for Revenue Accounting CHAR 6 0 TFK_RA_SERVTYP RAI_SERVICE_TYPE_KK
CRDATE Date on Which the Revenue Accounting Item Was Created DATS 8 0 RAI_CRDATE_KK
CRTIME Time at Which the Revenue Accounting Item Was Created TIMS 6 0 RAI_CRTIME_KK
SENTDATE Date of Transfer to Revenue Accounting DATS 8 0 SENTDATE_KK
SENTTIME Time of Transfer to Revenue Accounting TIMS 6 0 SENTTIME_KK
SENTTS Time at Which Revenue Accounting Item Transferred (UTC) DEC 15 0 SENTTS_KK
KUNNR Customer Number CHAR 10 0 KUNNR
PARTNER Business Partner Number CHAR 10 0 BU_PARTNER
VKONT Contract Account Number CHAR 12 0 VKONT_KK
VTREF Reference Specifications from Contract CHAR 20 0 VTREF_KK
VTPOS Contract: Item Number NUMC 6 0 VTPOS_KK
SUBAP Subapplication in Contract Accounts Receivable and Payable CHAR 1 0 SUBAP_KK
No Contract Reference/Primary Contract
9 Real Estate
BUKRS Company Code CHAR 4 0 BUKRS
BETRW Amount in Transaction Currency CURR 23 2 RAI_AMOUNT_TC_KK
WAERS Currency Key CUKY 5 0 WAERS
HWAER Local Currency CUKY 5 0 HWAER
HWAE2 Currency Key of Second Local Currency CUKY 5 0 HWAE2
HWAE3 Currency Key of Third Local Currency CUKY 5 0 HWAE3
QUANTITY Quantity QUAN 18 6 RAI_QUANTITY_KK
QUANTITY_UNIT Unit of Measure UNIT 3 0 RAI_QUANTITY_UNIT_KK
QUANTITY_REL Quantity Relevant CHAR 1 0 RAI_QUANTREL_KK
ORIGDOC_COMP Original Item Sender Component CHAR 3 0 RAI_ORICO_KK
ORIGDOC_LOGSYS Logical System of the Original Item CHAR 10 0 RAI_ORILS_KK
ORIGDOC_TYPE Original Item Type CHAR 4 0 RAI_ORITY_KK
ORIGDOC_ID Original Item ID CHAR 35 0 RAI_ORIID_KK
DUE_DATE Invoice Due Date DATS 8 0 RAI_DUE_DATE_KK
INVOICE_TYPE Invoice Type CHAR 2 0 RAI_INVOICE_TYPE_KK
CI Customer Invoice
CR Credit Memo
DR Debit Memo
INVOICE_CAT Invoice Item Category CHAR 1 0 RAI_INVOICE_CAT_KK
Real Invoice Item
1 Planned Invoice Item, Real Invoice Expected
2 Planned Invoice Item as Basis for Invoice Creation
FINAL_INVOICE Final Invoice CHAR 1 0 RAI_FINAL_INVOICE_KK
INVDOCNO Number of Invoicing Document NUMC 12 0 INVDOCNO_KK
RA_INVGR Revenue Grouping of Invoicing CHAR 6 0 RAI_INVGR_KK
POSTING_DATE Posting Date in the Document DATS 8 0 BUDAT
EVENT_DATE Fulfillment Event Date DATS 8 0 RAI_EVENT_DATE_KK
EVENT_TIME Fulfillment Event Time TIMS 6 0 RAI_EVENT_TIME_KK
EVENT_TYPE Fulfillment Type That Results in Fulfillment CHAR 2 0 RAI_EVENT_TYPE_KK
REVERSAL Reversal CHAR 1 0 RAI_REVERSAL_KK
DELETION_IND To Be Deleted CHAR 1 0 RAI_DELIND_KK
EXCHANGE_RATE Exchange rate DEC 9 5 KURSF
EXCHANGE_RATE2 Exchange Rate for the Second Local Currency DEC 9 5 KURS2
EXCHANGE_RATE3 Exchange Rate for the Third Local Currency DEC 9 5 KURS3
REFERENCE_TYPE Reference Type for Revenue Accounting CHAR 3 0 RAI_REFTYPE_KK
REFERENCE_ID Reference ID for Revenue Accounting CHAR 30 0 RAI_REFID_KK
GSBER Business Area CHAR 4 0 GSBER
PRCTR Profit Center CHAR 10 0 PRCTR
SEGMENT Segment for Segmental Reporting CHAR 10 0 FB_SEGMENT
START_DATE Start Date DATS 8 0 RAI_START_DATE_KK
END_DATE End Date DATS 8 0 RAI_END_DATE_KK
HILDOC_COMP Sender Component of Higher-Level Revenue Accounting Item CHAR 3 0 RAI_HLDCO_KK
HILDOC_LOGSYS Logical System of the Higher-Level Revenue Accounting Item CHAR 10 0 RAI_HLDLS_KK
HILDOC_TYPE Type of Higher-Level Revenue Accounting Item CHAR 4 0 RAI_HLDTY_KK
HILDOC_ID Higher-Level Item ID CHAR 35 0 RAI_HLDID_KK
SALES_ORG Sales Organization CHAR 20 0 RAI_SALES_ORG_KK
INCEPTION_DATE Inception Date DATS 8 0 RAI_INCEPTION_DATE_KK
VALUE_RELEVANT Value-Relevant CHAR 1 0 RAI_VALUE_RELEVANT_KK
CHRSN Change Reason CHAR 2 0 RAI_CHANGE_REASON_KK
PRDNR Product ID CHAR 40 0 RAI_PRDNR_KK
PRDNR_SP Product ID of the Sales Package CHAR 40 0 RAI_PRDSP_KK
SPART Division CHAR 2 0 SPART
VTWEG Distribution Channel CHAR 2 0 VTWEG
X_ESTIMATED_QUAN Determine Quantity and Unit Price in Revenue Accounting CHAR 1 0 RAI_X_ESTIMATED_QUAN_KK
KEYPP Subarea for Parallelization in Mass Processing NUMC 3 0 KEYPP_KK
XRECACC_DET Determine Receivables Account in Revenue Accounting CHAR 1 0 RAI_XRECACC_DET_KK
XACCASS_DET Determine Account Assignment Charact. in Revenue Accounting CHAR 1 0 RAI_XACCASS_DET_KK
CHIND Revenue Accounting Item Has Been Changed CHAR 1 0 CHIND_KK
I Added
U Changed
RECEIV_ACCOUNT Receivables Account CHAR 10 0 RAI_REC_ACCOUNT_KK
ITEM_TYPE Type of Revenue Accounting Item CHAR 2 0 RAI_ITEM_TYPE_KK
01 Order Item
02 Fulfillment Item
03 Invoice Item
MIG_PACKAGE Migration Package ID CHAR 4 0 RAI_MIG_PACKAGE_KK
INITIAL_LOAD Initial Data Load CHAR 1 0 RAI_XINITIAL_LOAD_KK
FINAL_DATE End Date DATS 8 0 RAI_FINAL_DATE_KK
PREDOC_COMP Predecessor Item Sender Component CHAR 3 0 RAI_PREDOC_COMP_KK
PREDOC_LOGSYS Logical System of the Predecessor Item CHAR 10 0 RAI_PREDOC_LS_KK
PREDOC_TYPE Predecessor Item Type CHAR 4 0 RAI_PREDOC_TY_KK
PREDOC_ID Predecessor Item ID CHAR 35 0 RAI_PREDOC_ID_KK
CRMET Creation Method of Transfer Records to Revenue Accounting CHAR 1 0 RAI_CRMET_KK
1 Adjustments from Event 8207/8209 (Without Amount)
2 Adjustments from Event 8207/8209 with Amount Change
3 Adjustments from Event 8207 with Amount Change (Only Cond.)
4 Creation by (Customer) Program/(Initializing) Program
5 Adjustments from Event 8207 (Delete Cond.)
6 Adjustments from Event 8202
7 Adjustments from Event 8203
8 No Further Processing in Accordance with Event 8205
9 No Further Processing in Accordance with Event 8207/8209
A No Further Processing in Accordance with Event 8203
EFFECTIVE_DATE Validity Date of Change of Revenue Recognition Contract DATS 8 0 RAI_EFFECTIVE_DATE_KK
ASSET_IMPAIRMENT Reduction in Value of Contract Asset CHAR 1 0 RAI_ASSET_IMPAIRMENT_KK
CHARGE_TYPE Charge Type CHAR 2 0 CHARGE_TYPE_KK
01 One-Time
02 Recurring
03 Usage-Based
AUFNR Order Number CHAR 12 0 AUFNR
PS_PSP_PNR Work Breakdown Structure Element (WBS Element) NUMC 8 0 PS_PSP_PNR

FKKRA_RAI_MI_DATA foreign key relationships

Table Field Check Table Check Field
0 FKKRA_RAI_MI_DATA SERVICE_TYPE TFK_RA_SERVTYP Service Types for Revenue Accounting Items MANDT
0 FKKRA_RAI_MI_DATA SERVICE_TYPE TFK_RA_SERVTYP Service Types for Revenue Accounting Items SERVICE_TYPE
1 FKKRA_RAI_MI_DATA SRCDOC_TYPE TFK_RA_SRCTY Source Item Type SRCDOC_TYPE