FARR_D_BIZ_RECON

Transparent Table Application Table
62 Fields 1 CDS Views

Business Reconciliation Table

FARR_D_BIZ_RECON is an SAP database table in S/4HANA. Business Reconciliation Table. It contains 62 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_RABusinessReconciliation view_entity from BASIC Revenue Accounting Business Recncln

Fields (62)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY company_code bukrs Company Code
KEY acct_principle accounting_principle Accounting Principle
KEY contract_id farr_contract_id Contract
KEY pob_id farr_pob_id POB
KEY condition_type kscha Condition Type
KEY acct_period farr_acct_period Accounting Per.
KEY exec_type farr_exec_type Execution Type
gjahr gjahr Fiscal Year
poper poper Posting Period
reference_type farr_rai_reftype Ref. Type
reference_id farr_rai_refid Ref ID
header_id farr_header_id Header ID
item_id farr_item_id Item ID
customer_id kunnr Customer
partner bu_partner Busn. Partner
cust_name name1_gp Name
op_cond_price farr_op_cond_price Oper Doc Price
op_cond_cost farr_op_cond_cost Oper Cond Cost
operation_curr farr_operation_curreny Operation Document C
invoice_amount farr_invoiced_amt Invoiced Amount
invoice_currency farr_invoice_currency Invoice Currency Key
invoice_amount_lc1 farr_invoiced_amt_lc1 Invoiced Amount LC1
invoice_currency_lc1 farr_invoice_currency_lc1 Invoice LC1 Key
invoice_amount_lc2 farr_invoiced_amt_lc2 Invoiced Amount LC2
invoice_currency_lc2 farr_invoice_currency_lc2 Invoice LC2 Key
invoice_amount_lc3 farr_invoiced_amt_lc3 Invoiced Amount LC3
invoice_currency_lc3 farr_invoice_currency_lc3 Invoice LC3 Key
cost_amount farr_cost_price Cost Price
cost_currency farr_cost_currency Cost Currency Key
op_quantity farr_quantity Quantity
quantity farr_quantity Quantity
quantity_unit farr_quantity_unit Unit of Measure
material matnr Material
mat_desc maktx Description
trx_price farr_transaction_price Contractual Price
trx_price_org farr_transaction_price_org Contractual Price from Operational Doc.
waers waers Currency
ssp farr_ssp StdAlone Price
cost_amt farr_cost Cost(Total)
actual_cost farr_actual_cost Actual Cost
alloc_amt farr_alloc_amt Allocated Amount
sched_rv farr_sched_rv Scheduled Revenue
sched_rv_cumltv farr_sched_rv_cumltv Recognized Revenue from Source Contract
sched_co farr_sched_co Scheduled Cost
sched_co_cumltv farr_sched_co_cumltv Recognized Cost from Source Contract
sched_ic farr_sched_ic Scheduled Invoice
sched_ic_cumltv farr_sched_ic_cumltv Recognized Invoice from Source Contract
liab_asset_flag farr_liab_asset_biz_recon Liability Asset Flag
dv_result farr_icon_dv_result DV Check Results
dv_timestamp farr_dv_timestamp Data Validation Run Time
unproc_rai farr_unpro_rai Unprocessed RAI
conflict farr_conflict POB in Conflict
pob_status farr_validate_status POB in Error
status farr_pob_status Perf.Oblig.Status
freeze farr_freeze Freeze Status
suspend_flag farr_suspend_posting Suspend Posting
suspended_revenue farr_cds_suspended_revenue Suspended Revenue
suspended_cost farr_cds_suspended_cost Suspended Cost
remarks farr_remarks Remarks
uname uname User Name
timestamp 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.

-- Business Reconciliation Table
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FARR_D_BIZ_RECON (
    MANDT,                 -- Client [mandt]
    COMPANY_CODE,          -- Company Code [bukrs]
    ACCT_PRINCIPLE,        -- Accounting Principle [accounting_principle]
    CONTRACT_ID,           -- Contract [farr_contract_id]
    POB_ID,                -- POB [farr_pob_id]
    CONDITION_TYPE,        -- Condition Type [kscha]
    ACCT_PERIOD,           -- Accounting Per. [farr_acct_period]
    EXEC_TYPE,             -- Execution Type [farr_exec_type]
    GJAHR,                 -- Fiscal Year [gjahr]
    POPER,                 -- Posting Period [poper]
    REFERENCE_TYPE,        -- Ref. Type [farr_rai_reftype]
    REFERENCE_ID,          -- Ref ID [farr_rai_refid]
    HEADER_ID,             -- Header ID [farr_header_id]
    ITEM_ID,               -- Item ID [farr_item_id]
    CUSTOMER_ID,           -- Customer [kunnr]
    PARTNER,               -- Busn. Partner [bu_partner]
    CUST_NAME,             -- Name [name1_gp]
    OP_COND_PRICE,         -- Oper Doc Price [farr_op_cond_price]
    OP_COND_COST,          -- Oper Cond Cost [farr_op_cond_cost]
    OPERATION_CURR,        -- Operation Document C [farr_operation_curreny]
    INVOICE_AMOUNT,        -- Invoiced Amount [farr_invoiced_amt]
    INVOICE_CURRENCY,      -- Invoice Currency Key [farr_invoice_currency]
    INVOICE_AMOUNT_LC1,    -- Invoiced Amount LC1 [farr_invoiced_amt_lc1]
    INVOICE_CURRENCY_LC1,  -- Invoice LC1 Key [farr_invoice_currency_lc1]
    INVOICE_AMOUNT_LC2,    -- Invoiced Amount LC2 [farr_invoiced_amt_lc2]
    INVOICE_CURRENCY_LC2,  -- Invoice LC2 Key [farr_invoice_currency_lc2]
    INVOICE_AMOUNT_LC3,    -- Invoiced Amount LC3 [farr_invoiced_amt_lc3]
    INVOICE_CURRENCY_LC3,  -- Invoice LC3 Key [farr_invoice_currency_lc3]
    COST_AMOUNT,           -- Cost Price [farr_cost_price]
    COST_CURRENCY,         -- Cost Currency Key [farr_cost_currency]
    OP_QUANTITY,           -- Quantity [farr_quantity]
    QUANTITY,              -- Quantity [farr_quantity]
    QUANTITY_UNIT,         -- Unit of Measure [farr_quantity_unit]
    MATERIAL,              -- Material [matnr]
    MAT_DESC,              -- Description [maktx]
    TRX_PRICE,             -- Contractual Price [farr_transaction_price]
    TRX_PRICE_ORG,         -- Contractual Price from Operational Doc. [farr_transaction_price_org]
    WAERS,                 -- Currency [waers]
    SSP,                   -- StdAlone Price [farr_ssp]
    COST_AMT,              -- Cost(Total) [farr_cost]
    ACTUAL_COST,           -- Actual Cost [farr_actual_cost]
    ALLOC_AMT,             -- Allocated Amount [farr_alloc_amt]
    SCHED_RV,              -- Scheduled Revenue [farr_sched_rv]
    SCHED_RV_CUMLTV,       -- Recognized Revenue from Source Contract [farr_sched_rv_cumltv]
    SCHED_CO,              -- Scheduled Cost [farr_sched_co]
    SCHED_CO_CUMLTV,       -- Recognized Cost from Source Contract [farr_sched_co_cumltv]
    SCHED_IC,              -- Scheduled Invoice [farr_sched_ic]
    SCHED_IC_CUMLTV,       -- Recognized Invoice from Source Contract [farr_sched_ic_cumltv]
    LIAB_ASSET_FLAG,       -- Liability Asset Flag [farr_liab_asset_biz_recon]
    DV_RESULT,             -- DV Check Results [farr_icon_dv_result]
    DV_TIMESTAMP,          -- Data Validation Run Time [farr_dv_timestamp]
    UNPROC_RAI,            -- Unprocessed RAI [farr_unpro_rai]
    CONFLICT,              -- POB in Conflict [farr_conflict]
    POB_STATUS,            -- POB in Error [farr_validate_status]
    STATUS,                -- Perf.Oblig.Status [farr_pob_status]
    FREEZE,                -- Freeze Status [farr_freeze]
    SUSPEND_FLAG,          -- Suspend Posting [farr_suspend_posting]
    SUSPENDED_REVENUE,     -- Suspended Revenue [farr_cds_suspended_revenue]
    SUSPENDED_COST,        -- Suspended Cost [farr_cds_suspended_cost]
    REMARKS,               -- Remarks [farr_remarks]
    UNAME,                 -- User Name [uname]
    TIMESTAMP,             -- Time Stamp [timestamp]
    PRIMARY KEY (MANDT, COMPANY_CODE, ACCT_PRINCIPLE, CONTRACT_ID, POB_ID, CONDITION_TYPE, ACCT_PERIOD, EXEC_TYPE)
);

Learn More