FARR_D_CONTRACT

Transparent Table Application Table
56 Fields 2 CDS Views

Contracts

FARR_D_CONTRACT is an SAP database table in S/4HANA. Contracts. It contains 56 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_RevenueAccountingContract view_entity from EXTENSION Extension view for RA Contract
I_RevenueAccountingContract view_entity from BASIC Revenue Accounting Contract

Fields (56)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY contract_id FARR_CONTRACT_ID Contract
contract_cat FARR_CONTRACT_CATEGORY Contract Category
customer_grp KONZS Group
acct_principle ACCOUNTING_PRINCIPLE Accounting Principle
description FARR_DESCRIPTION Description
contr_created_on FARR_CONTR_CREATED_ON Contract created on
contr_eew_dummy CFD_DUMMY Dummy
is_blocked FARR_DPP_IS_BLOCKED Blocked
universal_rev_contr FARR_UNIVERSAL_REV_REC_CONTR Universal Rev Contr
num_of_pob FARR_NUM_OF_POB No. of POBs
customer_id KUNNR Customer
partner BU_PARTNER Busn. Partner
valobjtype VAL_OBJ_TYPE Type of Fin.Val.Obj.
trx_price FARR_TRANSACTION_PRICE Contractual Price
trx_price_curk WAERS Currency
status FARR_CONTRACT_STATUS Contract Status
validate_result FARR_VALIDATE_RESULT Validation Result
manual_created FARR_MANUAL_CREATED Manual Created
manual_changed FARR_MANUAL_CHANGED Manual Changed
manual_deleted FARR_MANUAL_DELETED Manual Deleted
manual_allocated FARR_MANUAL_PRICE_ALLOC Manu Price Allocated
soft_deleted FARR_SOFT_DELETED Soft Deleted
price_adjusted FARR_PRICE_ADJUST_FLAG Allocation Effect
company_code BUKRS Company Code
sales_org FARR_SALES_ORG Sales Org.
alloc_differ FARR_ALLOC_DIFFERENCE Contr.Alloc.Effect
manual_price_alloc_conflict FARR_MNL_PRICE_ALLOC_CONFLICT Allocation Conflict
pending_conflict FARR_PENDING_CONFLICT Pending Conflict
receivable_account FARR_RECEIV_ACCOUNT ReceivAccount
recei_adj_account FARR_RECE_ADJ_ACCT ReceAdjAccount
asset_account FARR_ASSET_ACCOUNT AssetAcct
liability_account FARR_LIABILITY_ACCOUNT ConLiaAcct
refund_liability_acct FARR_REFUND_LIABILITY Refund Lia. Acct
refund_asset_account FARR_REFUND_ASSET_ACCOUNT Refund Ast. Acct
asset_impairment_account FARR_ASSET_IMPAIRMENT_ACCOUNT Termination Acct.
has_tm_pob FARR_HAS_TM_POB Time-Based Related
completion_date FARR_COMPLETION_DATE Completion Date
liability_post_mode FARR_LIABILITY_POST_MODE Lia./Ass. Post Lev.
lc_calc_method FARR_LC_CALC_METHOD LC Calc. Method
rounding_ts FARR_ROUNDING_TS Rounding Timestamp
fixed_ex_rate_date FARR_FIXED_EX_RATE_DATE Fix Ex. Rate Date
liab_method FARR_CREATE_LIABILITY_METHOD Balance Presentation
asset_impairment_date FARR_ASSET_IMPAIRMENT_DATE Contr. Term. Date
rar_version_code FARR_RAR_VERSION_CODE RAR version code
ccm_ocm_recon_key FARR_RECON_KEY Reconcil. Key
last_saved_on TIMESTAMPL Time Stamp
posting_mode FARR_POSTING_MODE Posting Mode
lcc FARR_LCC LCC
exchange_rate KURSF Exchange rate
exchange_rate2 KURS2 Exchange Rate 2
exchange_rate3 KURS3 Exchange Rate 3
created_by ERNAM Created By
created_on ERDAT Created On
last_changed_by AENAM Changed By
last_changed_on FARR_LAST_CHANGE_ON Changed on

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Contracts
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FARR_D_CONTRACT (
    CLIENT,                       -- Client [MANDT]
    CONTRACT_ID,                  -- Contract [FARR_CONTRACT_ID]
    CONTRACT_CAT,                 -- Contract Category [FARR_CONTRACT_CATEGORY]
    CUSTOMER_GRP,                 -- Group [KONZS]
    ACCT_PRINCIPLE,               -- Accounting Principle [ACCOUNTING_PRINCIPLE]
    DESCRIPTION,                  -- Description [FARR_DESCRIPTION]
    CONTR_CREATED_ON,             -- Contract created on [FARR_CONTR_CREATED_ON]
    CONTR_EEW_DUMMY,              -- Dummy [CFD_DUMMY]
    IS_BLOCKED,                   -- Blocked [FARR_DPP_IS_BLOCKED]
    UNIVERSAL_REV_CONTR,          -- Universal Rev Contr [FARR_UNIVERSAL_REV_REC_CONTR]
    NUM_OF_POB,                   -- No. of POBs [FARR_NUM_OF_POB]
    CUSTOMER_ID,                  -- Customer [KUNNR]
    PARTNER,                      -- Busn. Partner [BU_PARTNER]
    VALOBJTYPE,                   -- Type of Fin.Val.Obj. [VAL_OBJ_TYPE]
    TRX_PRICE,                    -- Contractual Price [FARR_TRANSACTION_PRICE]
    TRX_PRICE_CURK,               -- Currency [WAERS]
    STATUS,                       -- Contract Status [FARR_CONTRACT_STATUS]
    VALIDATE_RESULT,              -- Validation Result [FARR_VALIDATE_RESULT]
    MANUAL_CREATED,               -- Manual Created [FARR_MANUAL_CREATED]
    MANUAL_CHANGED,               -- Manual Changed [FARR_MANUAL_CHANGED]
    MANUAL_DELETED,               -- Manual Deleted [FARR_MANUAL_DELETED]
    MANUAL_ALLOCATED,             -- Manu Price Allocated [FARR_MANUAL_PRICE_ALLOC]
    SOFT_DELETED,                 -- Soft Deleted [FARR_SOFT_DELETED]
    PRICE_ADJUSTED,               -- Allocation Effect [FARR_PRICE_ADJUST_FLAG]
    COMPANY_CODE,                 -- Company Code [BUKRS]
    SALES_ORG,                    -- Sales Org. [FARR_SALES_ORG]
    ALLOC_DIFFER,                 -- Contr.Alloc.Effect [FARR_ALLOC_DIFFERENCE]
    MANUAL_PRICE_ALLOC_CONFLICT,  -- Allocation Conflict [FARR_MNL_PRICE_ALLOC_CONFLICT]
    PENDING_CONFLICT,             -- Pending Conflict [FARR_PENDING_CONFLICT]
    RECEIVABLE_ACCOUNT,           -- ReceivAccount [FARR_RECEIV_ACCOUNT]
    RECEI_ADJ_ACCOUNT,            -- ReceAdjAccount [FARR_RECE_ADJ_ACCT]
    ASSET_ACCOUNT,                -- AssetAcct [FARR_ASSET_ACCOUNT]
    LIABILITY_ACCOUNT,            -- ConLiaAcct [FARR_LIABILITY_ACCOUNT]
    REFUND_LIABILITY_ACCT,        -- Refund Lia. Acct [FARR_REFUND_LIABILITY]
    REFUND_ASSET_ACCOUNT,         -- Refund Ast. Acct [FARR_REFUND_ASSET_ACCOUNT]
    ASSET_IMPAIRMENT_ACCOUNT,     -- Termination Acct. [FARR_ASSET_IMPAIRMENT_ACCOUNT]
    HAS_TM_POB,                   -- Time-Based Related [FARR_HAS_TM_POB]
    COMPLETION_DATE,              -- Completion Date [FARR_COMPLETION_DATE]
    LIABILITY_POST_MODE,          -- Lia./Ass. Post Lev. [FARR_LIABILITY_POST_MODE]
    LC_CALC_METHOD,               -- LC Calc. Method [FARR_LC_CALC_METHOD]
    ROUNDING_TS,                  -- Rounding Timestamp [FARR_ROUNDING_TS]
    FIXED_EX_RATE_DATE,           -- Fix Ex. Rate Date [FARR_FIXED_EX_RATE_DATE]
    LIAB_METHOD,                  -- Balance Presentation [FARR_CREATE_LIABILITY_METHOD]
    ASSET_IMPAIRMENT_DATE,        -- Contr. Term. Date [FARR_ASSET_IMPAIRMENT_DATE]
    RAR_VERSION_CODE,             -- RAR version code [FARR_RAR_VERSION_CODE]
    CCM_OCM_RECON_KEY,            -- Reconcil. Key [FARR_RECON_KEY]
    LAST_SAVED_ON,                -- Time Stamp [TIMESTAMPL]
    POSTING_MODE,                 -- Posting Mode [FARR_POSTING_MODE]
    LCC,                          -- LCC [FARR_LCC]
    EXCHANGE_RATE,                -- Exchange rate [KURSF]
    EXCHANGE_RATE2,               -- Exchange Rate 2 [KURS2]
    EXCHANGE_RATE3,               -- Exchange Rate 3 [KURS3]
    CREATED_BY,                   -- Created By [ERNAM]
    CREATED_ON,                   -- Created On [ERDAT]
    LAST_CHANGED_BY,              -- Changed By [AENAM]
    LAST_CHANGED_ON,              -- Changed on [FARR_LAST_CHANGE_ON]
    PRIMARY KEY (CLIENT, CONTRACT_ID)
);

Learn More