FARR_D_CONS - RA - consistency check / contract data

RA - consistency check / contract data information is stored in SAP table FARR_D_CONS.
It is part of development package FARR_CONS_CHECK in software component FI-RA. This development package consists of objects that can be grouped under "Consistency Check Framework".

Fields for table FARR_D_CONS

Field Name
Description
Is Key
Data Element
Data Type
Length
Check Table
MANDTClientXMANDTCLNT6
COMPANY_CODECompany CodeXBUKRSCHAR8
CONTRACT_IDRevenue Accounting Contract IDXFARR_CONTRACT_IDCHAR28
POB_IDPerformance Obligation IDXFARR_POB_IDCHAR32
.INCLUDEFARR_S_CONS0
ACCT_PRINCIPLEAccounting PrincipleACCOUNTING_PRINCIPLECHAR8*
POST_LIAB_TXPost.LiabFARR_POST_LIABCHAR120
POST_MODE_TXPosting LevelFARR_POST_MODECHAR120
POST_LIABPost.LiabFARR_POST_LIABCHAR120
POB_ROLELeading/LinkedFARR_POB_ROLECHAR2
LC_CALC_METHODLocal Currency Calculation MethodFARR_LC_CALC_METHODCHAR2
LEADING_POB_IDLeading Performance Obligation IDFARR_LEADING_POB_IDCHAR32
HI_LEVEL_POB_IDHigher-Level Performance Obligation IDFARR_HI_LEVEL_POB_IDCHAR32
PREVENT_ALLOCExcluded from Cross-Allocation of Transaction PricesFARR_PREVENT_ALLOCATIONCHAR2
BOM_POB_IDPOB ID of the Root POB in the BOM StructureFARR_BOM_POB_IDCHAR32
DISTINCT_TYPEPerformance Obligation CompositionFARR_DISTINCTCHAR2
FULFILL_TYPEFulfillment TypeFARR_FULFILL_TYPECHAR2
EVENT_TYPEEvent TypeFARR_EVENT_TYPECHAR4
VALUE_RELEVANTIndicates Whether Quantity on the Invoice is Relevant or NotFARR_VALUE_RELEVANTCHAR2
START_DATE_TYPEStart Date TypeFARR_START_DATE_TYPECHAR2
FULLY_FULFILLEDFully FulfilledFARR_FULLY_FULFILLEDCHAR2
FINAL_INVOICEIs Final InvoiceFARR_FINAL_INVOICECHAR2
REV_REC_BLOCKSuspend PostingFARR_REV_REC_BLOCKCHAR2
SOFT_DELETEDSoft deleted flag - POBFARR_SOFT_DEL_POBCHAR2
MANUAL_CREATEDManually CreatedFARR_MANUAL_CREATEDCHAR2
MANUAL_DELETEDManually DeletedFARR_MANUAL_DELETEDCHAR2
SOURCE_OF_PRICESource of Price Condition TypeFARR_SOURCE_OF_PRICECHAR2
VALIDATE_RESULTValidation ResultFARR_VALIDATE_RESULTCHAR2
PENDING_CONFLICTPending Conflict ResolutionFARR_PENDING_CONFLICTCHAR2
CONTRACT_STATUSContract StatusFARR_CONTRACT_STATUSCHAR2
STATUSPerformance Obligation StatusFARR_POB_STATUSCHAR2
PAOBJNRProfitability Segment Number (CO-PA)RKEOBJNRNUMC20
KDAUFSales Order NumberKDAUFCHAR20
KDPOSItem number in Sales OrderKDPOSNUMC12
QUANTITY_UNITUnit of MeasureFARR_QUANTITY_UNITUNIT6*
QUANTITYQuantityFARR_QUANTITYQUAN10
EFFECTIVE_QTYEffective quantityFARR_EFFECTIVE_QUANTITYQUAN10
SUM_FULFIL_QUANTSum of fulfilled quantityFARR_SUM_FULFILQUAN10
SUM_FULQ_PENDSum of fulfilled quantity pendingFARR_SUM_FULQ_PENDQUAN10
SUM_FULQ_BOOKEDSum of fulfilled quantityFARR_SUM_FULLQ_BOOKEDQUAN10
SUM_REV_QTY_DELTASum of planned quantityFARR_SUM_REV_QTY_DELTAQUAN10
REPORTED_QTYQuantity Reported as FulfilledFARR_RPT_QUANTITYQUAN10
DEFITEM_QTYTotal Quantity of a Condition Type for a POBFARR_DEFITEM_QUANTITYQUAN10
SSP_CURKCurrency KeyWAERSCUKY10*
TRX_PRICETransaction priceFARR_TRX_PRICECURR13
ALLOC_AMTAllocated amountFARR_ALC_AMTCURR12
AFTER_ALLOC_AMTAfter allocation amountFARR_AFTER_ALLOC_AMTCURR12
SUM_REV_SCHEDSum revenue scheduledFARR_SUM_REV_SCHEDCURR12
SUM_TOTAL_PLAN_REVSum total planned revenueFARR_SUM_TOTAL_PLAN_REVCURR12
SUM_PLAN_REVSum planned revenueFARR_SUM_PLAN_REVCURR12
SUM_BOOK_REVSum posted revenueFARR_SUM_BOOK_REVCURR12
SUM_PLAN_INVSum deferred invoiceFARR_SUM_PLAN_INVCURR12
SUM_BOOK_INVSum posted invoiceFARR_SUM_BOOK_INVCURR12
SUM_PLAN_REV_ASum planned revenue for RAR periods, Program A executedFARR_SUM_PLAN_REV_ACURR12
SUM_BOOK_REV_ASum booked revenue from RAR periods, Program A executedFARR_SUM_BOOK_REV_ACURR12
SUM_PLAN_INV_ASum deferred invoice from RAR periods, Program A executedFARR_SUM_PLAN_INV_ACURR12
SUM_BOOK_INV_ASum posted invoice for RAR Periods, Program A executedFARR_SUM_BOOK_INV_ACURR12
SUM_PLAN_REV_CLOSESum planned revenue from closed RAR periodsFARR_SUM_PLAN_REV_CLOSECURR12
SUM_BOOK_REV_CLOSESum booked revenue from closed RAR periodsFARR_SUM_BOOK_REV_CLOSECURR12
SUM_PLAN_INV_CLOSESum deferred invoice from closed periodsFARR_SUM_PLAN_INV_CLOSECURR12
SUM_BOOK_INV_CLOSESum booked invoice from closed periodsFARR_SUM_BOOK_INV_CLOSECURR12
SUM_TRANSF_INVSum transferred invoiceFARR_SUM_TRANSF_INVCURR12
SUM_ALL_ICSum of posted/transferred invoiceFARR_SUM_ALL_ICCURR12
SUM_REC_ADJSum receivable adjustment in transaction currencyFARR_SUM_REC_ADJCURR12
SUM_REC_ADJ_LCSum receivable adjustment in local currency 1FARR_SUM_REC_ADJ_LCCURR12
SUM_TR_INV_LCSum transferred invoice in local currency 1FARR_SUM_TRANSF_INV_LCCURR12
SUM_ALL_IC_LCSum of posted / transferred invoice in local currency 1FARR_SUM_ALL_IC_LCCURR12
SUM_INV_AMT_CALCSum invoices calculated for LC handlingFARR_SUM_INV_AMT_CALCCURR12
SUM_FX_ED_INVSum invoices for actual exchange rate handlingFARR_SUM_FX_ED_INVCURR12
LOCAL_CURRLocal currency 1 - Sum receivable adjustmentFARR_LOCAL_CURSCUKY10*
SUM_REC_ADJ_LC1Sum receivable adjustment in local currency 1FARR_SUM_REC_ADJ_LCCURR12
SUM_TR_INV_LC1Sum transferred invoice in local currency 1FARR_SUM_TRANSF_INV_LCCURR12
SUM_ALL_IC_LC1Sum of posted / transferred invoice in local currency 1FARR_SUM_ALL_IC_LCCURR12
SUM_INV_AMT_CALC_LC1Sum invoices calculated for LC handling in local currency 1FARR_SUM_INV_AMT_CALC_LC1CURR12
SUM_FX_ED_INV_LC1Sum invoices for actual exch. rate meth. in local currency 1FARR_SUM_FX_ED_INV_LC1CURR12
SUM_FX_ED_LC1Sum FX differences for actual exchange rate method in LC1FARR_SUM_FX_ED_LC1CURR12
SUM_FX_ED_BOOK_LC1Sum posted FX diff. for actual exchange rate method in LC1FARR_SUM_FX_ED_BOOK_LC1CURR12
LOCAL_CURR1Local currency 1 - Sum receivable adjustmentFARR_LOCAL_CURSCUKY10*
SUM_REC_ADJ_LC2Sum receivable adjustment in local currency 2FARR_SUM_REC_ADJ_LC2CURR12
SUM_TR_INV_LC2Sum receivable adjustment in local currency 2FARR_SUM_TRANSF_INV_LC2CURR12
SUM_ALL_IC_LC2Sum transferred invoice in local currency 2FARR_SUM_ALL_IC_LC2CURR12
SUM_INV_AMT_CALC_LC2Sum invoices calculated for LC handling in local currency 2FARR_SUM_INV_AMT_CALC_LC2CURR12
SUM_FX_ED_INV_LC2Sum invoices for actual exch. rate meth. in local currency 2FARR_SUM_FX_ED_INV_LC2CURR12
SUM_FX_ED_LC2Sum FX differences for actual exchange rate method in LC2FARR_SUM_FX_ED_LC2CURR12
SUM_FX_ED_BOOK_LC2Sum FX differences for actual exchange rate method in LC2FARR_SUM_FX_ED_LC2CURR12
LOCAL_CURR2Local currency 2 - Sum receivable adjustmentFARR_LOCAL_CURS2CUKY10*
SUM_REC_ADJ_LC3Sum receivable adjustment in local currency 3FARR_SUM_REC_ADJ_LC3CURR12
SUM_TR_INV_LC3Sum transferred invoice in local currency 3FARR_SUM_TRANSF_INV_LC3CURR12
SUM_ALL_IC_LC3Sum of posted / transferred invoice in local currency 3FARR_SUM_ALL_IC_LC3CURR12
SUM_INV_AMT_CALC_LC3Sum invoices calculated for LC handling in local currency 3FARR_SUM_INV_AMT_CALC_LC3CURR12
SUM_FX_ED_INV_LC3Sum invoices for actual exch. rate meth. in local currency 3FARR_SUM_FX_ED_INV_LC3CURR12
SUM_FX_ED_LC3Sum FX differences for actual exchange rate method in LC3FARR_SUM_FX_ED_LC3CURR12
SUM_FX_ED_BOOK_LC3Sum posted FX diff. for actual exchange rate method in LC3FARR_SUM_FX_ED_BOOK_LC3CURR12
LOCAL_CURR3Local currency 3 - Sum receivable adjustmentFARR_LOCAL_CURS3CUKY10*
SUM_PLAN_LIABSum planned liabilityFARR_SUM_PLAN_LIABCURR12
SUM_BOOK_LIABSum booked liabilityFARR_SUM_BOOK_LIABCURR12
SUM_PLAN_ASSETSum planned assetFARR_SUM_PLAN_ASSETCURR12
SUM_BOOK_ASSETSum booked assetFARR_SUM_BOOK_ASSETCURR12
MANUAL_SPREADINGSpreading Manually ChangedFARR_MANUAL_SPREADINGCHAR2
SPREAD_CONFLICTSpreading conflictFARR_SPREAD_CONFLICTCHAR2
MANUAL_SPREAD_AMTManual Change Spreading AmountFARR_MANL_SPREAD_AMTCHAR60
MANUAL_SPREAD_CONFLICTManual Spreading ConflictFARR_MANL_SPREAD_CONFLICTCHAR2
MANUAL_SPREAD_EXISTManual Spreading entry existsFARR_MANL_SPREAD_EXISTCHAR2
MANUAL_ALLOC_COND_MISManual Allocation Condition missingFARR_MANL_ALLOC_COND_MISCHAR2
MANUAL_ANY_CONFLICTManual Any ConflictFARR_MANL_ANY_CONFLICTCHAR2
.INCLUDEFARR_S_ERROR_FLAGS0
ERR01RA - Data Validation/ Error Category 01FARR_ERR01CHAR2
ERR02RA - Data Validation/ Error Category 02FARR_ERR02CHAR2
ERR03RA - Data Validation/ Error Category 03FARR_ERR03CHAR2
ERR04RA - Data Validation/ Error Category 04FARR_ERR04CHAR2
ERR05RA - Data Validation/ Error Category 05FARR_ERR05CHAR2
ERR06RA - Data Validation/ Error Category 06FARR_ERR06CHAR2
ERR07RA - Data Validation/ Error Category 07FARR_ERR07CHAR2
ERR08RA - Data Validation/ Error Category 08FARR_ERR08CHAR2
ERR09RA - Data Validation/ Error Category 09FARR_ERR09CHAR2
ERR10RA - Data Validation/ Error Category 10FARR_ERR10CHAR2
ERR11RA - Data Validation/ Error Category 11FARR_ERR11CHAR2
ERR12RA - Data Validation/ Error Category 12FARR_ERR12CHAR2
ERR13RA - Data Validation/ Error Category 13FARR_ERR13CHAR2
ERR14RA - Data Validation/ Error Category 14FARR_ERR14CHAR2
ERR15RA - Data Validation/ Error Category 15FARR_ERR15CHAR2
ERR16RA - Data Validation/ Error Category 16FARR_ERR16CHAR2
ERR17RA - Data Validation/ Error Category 17FARR_ERR17CHAR2
ERR18RA - Data Validation/ Error Category 18FARR_ERR18CHAR2
ERR19RA - Data Validation/ Error Category 19FARR_ERR19CHAR2
ERR22RA - Data Validation/ Error Category 22FARR_ERR22CHAR2
ERR25RA - Data Validation/ Error Category 25FARR_ERR25CHAR2
ERR29RA - Data Validation/ Error Category 29FARR_ERR29CHAR2
ERR30RA - Data Validation/ Error Category 30FARR_ERR30CHAR2
ERDATDate on which the record was createdERDATDATS16
ERZEITTime at Which Record Was AddedERZEITTIMS12
.INCLUDEINCL_EEW_FARR_CONS_USER_FIELD0
CONS_EEW_DUMMYDummy function in length 1DUMMYCHAR2
.INCLUDEINCL_EEW_FARR_CONS_USER_FLAG0
ERROR_EEW_DUMMYDummy function in length 1DUMMYCHAR2
Privacy Policy