FARR_D_RECON_KEY

Transparent Table Application Table
22 Fields 1 CDS Views

Reconciliation Keys

FARR_D_RECON_KEY is an SAP database table in S/4HANA. Reconciliation Keys. It contains 22 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_RevnAcctgReconciliationKey view from BASIC Revenue Accounting Reconciliation Key

Fields (22)

KeyField Data ElementDescription DomainTypeLength
KEY client mandt Client
KEY company_code bukrs Company Code
KEY acct_principle accounting_principle Accounting Principle
KEY contract_id farr_contract_id Contract
KEY gjahr gjahr Fiscal Year
KEY poper poper Posting Period
KEY recon_key farr_recon_key Reconcil. Key
pro_split_date farr_pro_split_date Pro Split Date
value_date datum Date
keypp farr_keypp Subarea
status farr_recon_key_status Status of Recon. Key
type farr_recon_key_type Key Type
reason_code farr_recon_reason_code Key Reason
tm_convert farr_tm_convert Time Based Def
liab_asset_flag farr_liab_asset_flag Liability/Asset Ind.
lcc farr_lcc LCC
runid farr_run_id Posting Run ID
run_date datum Date
created_by ernam Created By
created_on timestamp Time Stamp
last_changed_by aenam Changed By
last_changed_on timestamp Time Stamp

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.

-- Reconciliation Keys
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FARR_D_RECON_KEY (
    CLIENT,           -- Client [mandt]
    COMPANY_CODE,     -- Company Code [bukrs]
    ACCT_PRINCIPLE,   -- Accounting Principle [accounting_principle]
    CONTRACT_ID,      -- Contract [farr_contract_id]
    GJAHR,            -- Fiscal Year [gjahr]
    POPER,            -- Posting Period [poper]
    RECON_KEY,        -- Reconcil. Key [farr_recon_key]
    PRO_SPLIT_DATE,   -- Pro Split Date [farr_pro_split_date]
    VALUE_DATE,       -- Date [datum]
    KEYPP,            -- Subarea [farr_keypp]
    STATUS,           -- Status of Recon. Key [farr_recon_key_status]
    TYPE,             -- Key Type [farr_recon_key_type]
    REASON_CODE,      -- Key Reason [farr_recon_reason_code]
    TM_CONVERT,       -- Time Based Def [farr_tm_convert]
    LIAB_ASSET_FLAG,  -- Liability/Asset Ind. [farr_liab_asset_flag]
    LCC,              -- LCC [farr_lcc]
    RUNID,            -- Posting Run ID [farr_run_id]
    RUN_DATE,         -- Date [datum]
    CREATED_BY,       -- Created By [ernam]
    CREATED_ON,       -- Time Stamp [timestamp]
    LAST_CHANGED_BY,  -- Changed By [aenam]
    LAST_CHANGED_ON,  -- Time Stamp [timestamp]
    PRIMARY KEY (CLIENT, COMPANY_CODE, ACCT_PRINCIPLE, CONTRACT_ID, GJAHR, POPER, RECON_KEY)
);

Learn More