FARR_D_RECON_KEY

Transparent Table Application Table
26 Fields 1 CDS Views

Reconciliation Keys

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

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_RevnAcctgReconciliationKey view_entity from BASIC Revenue Accounting Reconciliation Key

Fields (26)

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
awtyp AWTYP Ref. procedure
awref AWREF Reference Doc.
aworg AWORG Refer. Org.Unit
awsys AWSYS Logical System
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]
    AWTYP,            -- Ref. procedure [AWTYP]
    AWREF,            -- Reference Doc. [AWREF]
    AWORG,            -- Refer. Org.Unit [AWORG]
    AWSYS,            -- Logical System [AWSYS]
    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