SAP table FARR_D_CONTRACT (Contracts)

SAP table FARR_D_CONTRACT has 2 primary key fields being CLIENT,CONTRACT_ID.

Field Description Data Type Length Decimals Checktable Data Element
CLIENT Client CLNT 3 0 MANDT
CONTRACT_ID Revenue Accounting Contract ID CHAR 14 0 FARR_CONTRACT_ID
CONTRACT_CAT Contract Category CHAR 4 0 FARR_CONTRACT_CATEGORY
CUSTOMER_GRP Group key CHAR 10 0 KONZS
ACCT_PRINCIPLE Accounting Principle CHAR 4 0 * ACCOUNTING_PRINCIPLE
DESCRIPTION Description of Revenue Accounting Items CHAR 60 0 FARR_DESCRIPTION
CONTR_CREATED_ON The datetime for contract created DEC 15 0 FARR_CONTR_CREATED_ON
CONTR_EEW_DUMMY Custom Fields: Dummy for Use in Extension Includes CHAR 1 0 CFD_DUMMY
IS_BLOCKED Is Blocked CHAR 1 0 FARR_DPP_IS_BLOCKED
NUM_OF_POB Number of Performance Obligations INT4 10 0 FARR_NUM_OF_POB
CUSTOMER_ID Customer Number CHAR 10 0 KUNNR
PARTNER Business Partner Number CHAR 10 0 BU_PARTNER
VALOBJTYPE Type of the Financial Valuation Object CHAR 4 0 * VAL_OBJ_TYPE
TRX_PRICE Contractual Price CURR 25 2 FARR_TRANSACTION_PRICE
TRX_PRICE_CURK Currency Key CUKY 5 0 * WAERS
STATUS Contract Status CHAR 1 0 FARR_CONTRACT_STATUS
C Completed
I In Process
R Pending Review
VALIDATE_RESULT Validation Result CHAR 1 0 FARR_VALIDATE_RESULT
E Error
S OK
W Warning
MANUAL_CREATED Manually Created CHAR 1 0 FARR_MANUAL_CREATED
MANUAL_CHANGED Manually Changed CHAR 1 0 FARR_MANUAL_CHANGED
MANUAL_DELETED Manually Deleted CHAR 1 0 FARR_MANUAL_DELETED
MANUAL_ALLOCATED Price was allocated manually on the Contract CHAR 1 0 FARR_MANUAL_PRICE_ALLOC
SOFT_DELETED Soft Deleted CHAR 1 0 FARR_SOFT_DELETED
PRICE_ADJUSTED Allocation Effect Exists in the Contract CHAR 1 0 FARR_PRICE_ADJUST_FLAG
COMPANY_CODE Company Code CHAR 4 0 BUKRS
SALES_ORG Sales Organization for Revenue Accounting CHAR 20 0 FARR_SALES_ORG
ALLOC_DIFFER Contract Allocation Effect CURR 23 2 FARR_ALLOC_DIFFERENCE
MANUAL_PRICE_ALLOC_CONFLICT Contract has manual price allocation conflict CHAR 1 0 FARR_MNL_PRICE_ALLOC_CONFLICT
PENDING_CONFLICT Pending Conflict Resolution CHAR 1 0 FARR_PENDING_CONFLICT
RECEIVABLE_ACCOUNT Receivables Account CHAR 10 0 FARR_RECEIV_ACCOUNT
RECEI_ADJ_ACCOUNT Receivable Adjustment Account CHAR 10 0 * FARR_RECE_ADJ_ACCT
ASSET_ACCOUNT Contract Asset Account CHAR 10 0 * FARR_ASSET_ACCOUNT
LIABILITY_ACCOUNT Contract Liability Account CHAR 10 0 * FARR_LIABILITY_ACCOUNT
REFUND_LIABILITY_ACCT Refund Liability Account CHAR 10 0 FARR_REFUND_LIABILITY
REFUND_ASSET_ACCOUNT Refund Asset Account CHAR 10 0 FARR_REFUND_ASSET_ACCOUNT
ASSET_IMPAIRMENT_ACCOUNT Contract Termination Expense (Loss) Account CHAR 10 0 * FARR_ASSET_IMPAIRMENT_ACCOUNT
HAS_TM_POB With Time-Based POB or Event-based POB with Rights of Return CHAR 1 0 FARR_HAS_TM_POB
COMPLETION_DATE Completion Date DATS 8 0 FARR_COMPLETION_DATE
LIABILITY_POST_MODE Level for Posting Liabilities and Assets to Posting Table CHAR 1 0 FARR_LIABILITY_POST_MODE
Post at Contract Level
2 Post at Performance Obligation Level
LC_CALC_METHOD Local Currency Calculation Method CHAR 1 0 FARR_LC_CALC_METHOD
Fixed Exchange Rate Method
A Actual Exchange Rate Method
ROUNDING_TS Timestemp for calculating rounding DEC 15 0 FARR_ROUNDING_TS
FIXED_EX_RATE_DATE The date is used to fix exchange rate DATS 8 0 FARR_FIXED_EX_RATE_DATE
LIAB_METHOD Contract Balance Presentation CHAR 1 0 FARR_CREATE_LIABILITY_METHOD
1 Unbilled Receivable/Deferred Revenue
2 Contract Liability/Contract Asset
ASSET_IMPAIRMENT_DATE Date on which the contract was terminated early DATS 8 0 FARR_ASSET_IMPAIRMENT_DATE
RAR_VERSION_CODE RAR version code CHAR 1 0 FARR_RAR_VERSION_CODE
Version Undefined/Unknown
A Version 1.3
X Version 2.0
CCM_OCM_RECON_KEY Reconciliation Key for a Contract in a Revenue Acctg. Period CHAR 14 0 FARR_RECON_KEY
LAST_SAVED_ON UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) DEC 21 7 TIMESTAMPL
POSTING_MODE Posting Mode CHAR 1 0 FARR_POSTING_MODE
Posting to RAR Subledger/Aggregated Posting to FI
D Direct Posting to FI
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
CREATED_BY Name of Person Responsible for Creating the Object CHAR 12 0 ERNAM
CREATED_ON Date on which the record was created DATS 8 0 ERDAT
LAST_CHANGED_BY Name of Person Who Changed Object CHAR 12 0 AENAM
LAST_CHANGED_ON Last Changed On DATS 8 0 FARR_LAST_CHANGE_ON