FARR_D_DEFITEM

Transparent Table Application Table
52 Fields 3 CDS Views

Deferral Items

FARR_D_DEFITEM is an SAP database table in S/4HANA. Deferral Items. It contains 52 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
FARR_RACondByReconkey view_entity from
I_RADeferralItemWithoutInvoice view_entity from BASIC RA Deferral Item Without Invoice Data
I_RevnAcctgDeferralItem view_entity from BASIC Revenue Accounting Deferral Item

Fields (52)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY recon_key FARR_RECON_KEY Reconcil. Key
KEY pob_id FARR_POB_ID POB
KEY condition_type KSCHA Condition Type
KEY deferral_cat FARR_DEFERRAL_CATEGORY Deferral Cat.
contract_id FARR_CONTRACT_ID Contract
event_type FARR_EVENT_TYPE Event Type
fulfill_type FARR_FULFILL_TYPE Fulfillment Type
company_code BUKRS Company Code
acct_principle ACCOUNTING_PRINCIPLE Accounting Principle
amount_curk WAERS Currency
quantity_unit FARR_QUANTITY_UNIT Unit of Measure
source_acct FARR_SOURCE_ACCT Source Account
target_acct FARR_TARGET_ACCT Target Account
statistic KSTAT Statistical
category FARR_CONDITION_CATEGORY Price/Cost
spec_indicator FARR_DEFITEM_SPECIAL_INDICATOR Special Indicator
is_ps FARR_IS_PS Proj. Sys.
doc_amt_org FARR_DEFITEM_DOC_AMT_ORG Original Amount
doc_amt_delta FARR_DEFITEM_DOC_AMT_DELTA Delta Amount
doc_qty_delta FARR_DEFITEM_DOC_QTY_DELTA Delta Qty.
doc_amt_cumulate FARR_DEFITEM_DOC_AMT_CUMULATE Effective Value
doc_qty_cumulate FARR_DEFITEM_DOC_QTY_CUMULATE Effective Qty.
rev_amt_catchup FARR_DEFITEM_REV_AMT_CATCHUP Catchup Amount
rev_amt_delta FARR_DEFITEM_REV_AMT_DELTA Posting Amount
rev_qty_delta FARR_DEFITEM_REV_QTY_DELTA Qty. for Postg.
rev_qty_diff_delta FARR_DEFITM_REV_QTY_DIFF_DELTA Rev. Qty Diff.
rev_qty_nd_delta FARR_DEFITEM_REV_QTY_ND_DELTA Rev. Qty Non-Dstct
rev_qty_delta_nm FARR_DEFITEM_REV_QTY_DELTA_NM Postg. Numerat.
rev_qty_delta_dn FARR_DEFITEM_REV_QTY_DELTA_DN Postg. Denomin.
rev_amt_posted FARR_DEFITEM_REV_AMT_POSTED Sum Prev. Def.
rev_qty_posted FARR_DEFITEM_REV_QTY_POSTED Sum Qty. Prev.
rev_qty_pst_nm FARR_DEFITEM_REV_QTY_PST_NM Sum Prev. Num.
rev_qty_pst_dn FARR_DEFITEM_REV_QTY_PST_DN Sum Prev. Den.
cost_amt_delta FARR_DEFITEM_COST_AMT_DELTA Cost Amount
inv_amt_delta FARR_DEFITEM_INV_AMT_DELTA Invoiced Amount
inv_qty_delta FARR_DEFITEM_INV_QTY_DELTA Invoiced Qty.
inv_amt_total FARR_DEFITEM_INV_AMT_TOTAL Total Inv. Amt.
inv_qty_total FARR_DEFITEM_INV_QTY_TOTAL Total Inv. Qty.
mem_amt_delta FARR_DEFITEM_MEM_AMT_DELTA Cr/De Memo Amt.
mem_amt_total FARR_DEFITEM_MEM_AMT_TOTAL Total Cr/D Memo
pro_amt_cumulate FARR_DEFITEM_PRO_AMT_CUMULATE Split Amount
pro_qty_cumulate FARR_DEFITEM_PRO_QTY_CUMULATE Split Qty.
pro_qty_cumulate_nm FARR_DEFITEM_PRO_QTY_CUMUL_NM Split Numerator
pro_qty_cumulate_dn FARR_DEFITEM_PRO_QTY_CUMUL_DN Split Den.
pro_cross_period FARR_CROSS_PERIOD Cross-Period
pro_split FARR_DEFITEM_SPLIT Prosp.Split Ind
has_impair_asset FARR_HAS_IMPAIR_OF_ASSET Terminated Early
latest_defitem FARR_LATEST_ENTRY Latest Entry
timestamp TIMESTAMP Time Stamp
created_on TIMESTAMP Time Stamp
is_legacy FARR_IS_LEGACY Legacy Entry

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.

-- Deferral Items
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FARR_D_DEFITEM (
    CLIENT,               -- Client [MANDT]
    RECON_KEY,            -- Reconcil. Key [FARR_RECON_KEY]
    POB_ID,               -- POB [FARR_POB_ID]
    CONDITION_TYPE,       -- Condition Type [KSCHA]
    DEFERRAL_CAT,         -- Deferral Cat. [FARR_DEFERRAL_CATEGORY]
    CONTRACT_ID,          -- Contract [FARR_CONTRACT_ID]
    EVENT_TYPE,           -- Event Type [FARR_EVENT_TYPE]
    FULFILL_TYPE,         -- Fulfillment Type [FARR_FULFILL_TYPE]
    COMPANY_CODE,         -- Company Code [BUKRS]
    ACCT_PRINCIPLE,       -- Accounting Principle [ACCOUNTING_PRINCIPLE]
    AMOUNT_CURK,          -- Currency [WAERS]
    QUANTITY_UNIT,        -- Unit of Measure [FARR_QUANTITY_UNIT]
    SOURCE_ACCT,          -- Source Account [FARR_SOURCE_ACCT]
    TARGET_ACCT,          -- Target Account [FARR_TARGET_ACCT]
    STATISTIC,            -- Statistical [KSTAT]
    CATEGORY,             -- Price/Cost [FARR_CONDITION_CATEGORY]
    SPEC_INDICATOR,       -- Special Indicator [FARR_DEFITEM_SPECIAL_INDICATOR]
    IS_PS,                -- Proj. Sys. [FARR_IS_PS]
    DOC_AMT_ORG,          -- Original Amount [FARR_DEFITEM_DOC_AMT_ORG]
    DOC_AMT_DELTA,        -- Delta Amount [FARR_DEFITEM_DOC_AMT_DELTA]
    DOC_QTY_DELTA,        -- Delta Qty. [FARR_DEFITEM_DOC_QTY_DELTA]
    DOC_AMT_CUMULATE,     -- Effective Value [FARR_DEFITEM_DOC_AMT_CUMULATE]
    DOC_QTY_CUMULATE,     -- Effective Qty. [FARR_DEFITEM_DOC_QTY_CUMULATE]
    REV_AMT_CATCHUP,      -- Catchup Amount [FARR_DEFITEM_REV_AMT_CATCHUP]
    REV_AMT_DELTA,        -- Posting Amount [FARR_DEFITEM_REV_AMT_DELTA]
    REV_QTY_DELTA,        -- Qty. for Postg. [FARR_DEFITEM_REV_QTY_DELTA]
    REV_QTY_DIFF_DELTA,   -- Rev. Qty Diff. [FARR_DEFITM_REV_QTY_DIFF_DELTA]
    REV_QTY_ND_DELTA,     -- Rev. Qty Non-Dstct [FARR_DEFITEM_REV_QTY_ND_DELTA]
    REV_QTY_DELTA_NM,     -- Postg. Numerat. [FARR_DEFITEM_REV_QTY_DELTA_NM]
    REV_QTY_DELTA_DN,     -- Postg. Denomin. [FARR_DEFITEM_REV_QTY_DELTA_DN]
    REV_AMT_POSTED,       -- Sum Prev. Def. [FARR_DEFITEM_REV_AMT_POSTED]
    REV_QTY_POSTED,       -- Sum Qty. Prev. [FARR_DEFITEM_REV_QTY_POSTED]
    REV_QTY_PST_NM,       -- Sum Prev. Num. [FARR_DEFITEM_REV_QTY_PST_NM]
    REV_QTY_PST_DN,       -- Sum Prev. Den. [FARR_DEFITEM_REV_QTY_PST_DN]
    COST_AMT_DELTA,       -- Cost Amount [FARR_DEFITEM_COST_AMT_DELTA]
    INV_AMT_DELTA,        -- Invoiced Amount [FARR_DEFITEM_INV_AMT_DELTA]
    INV_QTY_DELTA,        -- Invoiced Qty. [FARR_DEFITEM_INV_QTY_DELTA]
    INV_AMT_TOTAL,        -- Total Inv. Amt. [FARR_DEFITEM_INV_AMT_TOTAL]
    INV_QTY_TOTAL,        -- Total Inv. Qty. [FARR_DEFITEM_INV_QTY_TOTAL]
    MEM_AMT_DELTA,        -- Cr/De Memo Amt. [FARR_DEFITEM_MEM_AMT_DELTA]
    MEM_AMT_TOTAL,        -- Total Cr/D Memo [FARR_DEFITEM_MEM_AMT_TOTAL]
    PRO_AMT_CUMULATE,     -- Split Amount [FARR_DEFITEM_PRO_AMT_CUMULATE]
    PRO_QTY_CUMULATE,     -- Split Qty. [FARR_DEFITEM_PRO_QTY_CUMULATE]
    PRO_QTY_CUMULATE_NM,  -- Split Numerator [FARR_DEFITEM_PRO_QTY_CUMUL_NM]
    PRO_QTY_CUMULATE_DN,  -- Split Den. [FARR_DEFITEM_PRO_QTY_CUMUL_DN]
    PRO_CROSS_PERIOD,     -- Cross-Period [FARR_CROSS_PERIOD]
    PRO_SPLIT,            -- Prosp.Split Ind [FARR_DEFITEM_SPLIT]
    HAS_IMPAIR_ASSET,     -- Terminated Early [FARR_HAS_IMPAIR_OF_ASSET]
    LATEST_DEFITEM,       -- Latest Entry [FARR_LATEST_ENTRY]
    TIMESTAMP,            -- Time Stamp [TIMESTAMP]
    CREATED_ON,           -- Time Stamp [TIMESTAMP]
    IS_LEGACY,            -- Legacy Entry [FARR_IS_LEGACY]
    PRIMARY KEY (CLIENT, RECON_KEY, POB_ID, CONDITION_TYPE, DEFERRAL_CAT)
);

Learn More