FARR_D_INVOICE

Transparent Table Application Table
27 Fields 1 CDS Views

Invoice Entries

FARR_D_INVOICE is an SAP database table in S/4HANA. Invoice Entries. It contains 27 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_RevenueAccountingInvoice view_entity from BASIC Revenue Accounting Invoice

Fields (27)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY guid FARR_INVOICE_GUID Invoice GUID
company_code BUKRS Company Code
acct_principle ACCOUNTING_PRINCIPLE Accounting Principle
recon_key FARR_RECON_KEY Reconcil. Key
pob_id FARR_POB_ID POB
invoice_type FARR_INVOICE_TYPE InvoiceTy.
posting_date BUDAT Posting Date
due_date FARR_DUE_DATE Invoice Due Date
due_period FARR_DUE_FISCAL_YEAR_PERIOD InvDueYearPeriod
betrw FARR_AMOUNT_TC Amnt in Trans. Crcy
waers WAERS Currency
betrh FARR_AMOUNT_LC Amount in Local Crcy
hwaer HWAER Local Currency
betr2 FARR_AMOUNT_LC2 Second Local Crcy
hwae2 HWAE2 Local curr. 2
betr3 FARR_AMOUNT_LC3 Third Local Crcy
hwae3 HWAE3 Local curr. 3
invoice_due_lc FARR_AMOUNT_LC Amount in Local Crcy
invoice_due_lc2 FARR_AMOUNT_LC2 Second Local Crcy
invoice_due_lc3 FARR_AMOUNT_LC3 Third Local Crcy
reference_guid FARR_INVOICE_GUID Invoice GUID
is_calculated FARR_INVOICE_CALCULATED Invoice Calculated
created_by ERNAM Created By
created_ts TIMESTAMP Time Stamp
changed_by AENAM Changed By
changed_ts 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.

-- Invoice Entries
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FARR_D_INVOICE (
    CLIENT,           -- Client [MANDT]
    GUID,             -- Invoice GUID [FARR_INVOICE_GUID]
    COMPANY_CODE,     -- Company Code [BUKRS]
    ACCT_PRINCIPLE,   -- Accounting Principle [ACCOUNTING_PRINCIPLE]
    RECON_KEY,        -- Reconcil. Key [FARR_RECON_KEY]
    POB_ID,           -- POB [FARR_POB_ID]
    INVOICE_TYPE,     -- InvoiceTy. [FARR_INVOICE_TYPE]
    POSTING_DATE,     -- Posting Date [BUDAT]
    DUE_DATE,         -- Invoice Due Date [FARR_DUE_DATE]
    DUE_PERIOD,       -- InvDueYearPeriod [FARR_DUE_FISCAL_YEAR_PERIOD]
    BETRW,            -- Amnt in Trans. Crcy [FARR_AMOUNT_TC]
    WAERS,            -- Currency [WAERS]
    BETRH,            -- Amount in Local Crcy [FARR_AMOUNT_LC]
    HWAER,            -- Local Currency [HWAER]
    BETR2,            -- Second Local Crcy [FARR_AMOUNT_LC2]
    HWAE2,            -- Local curr. 2 [HWAE2]
    BETR3,            -- Third Local Crcy [FARR_AMOUNT_LC3]
    HWAE3,            -- Local curr. 3 [HWAE3]
    INVOICE_DUE_LC,   -- Amount in Local Crcy [FARR_AMOUNT_LC]
    INVOICE_DUE_LC2,  -- Second Local Crcy [FARR_AMOUNT_LC2]
    INVOICE_DUE_LC3,  -- Third Local Crcy [FARR_AMOUNT_LC3]
    REFERENCE_GUID,   -- Invoice GUID [FARR_INVOICE_GUID]
    IS_CALCULATED,    -- Invoice Calculated [FARR_INVOICE_CALCULATED]
    CREATED_BY,       -- Created By [ERNAM]
    CREATED_TS,       -- Time Stamp [TIMESTAMP]
    CHANGED_BY,       -- Changed By [AENAM]
    CHANGED_TS,       -- Time Stamp [TIMESTAMP]
    PRIMARY KEY (CLIENT, GUID)
);

Learn More