FARR_D_POSTING

Transparent Table Application Table
47 Fields 4 CDS Views

Postings

FARR_D_POSTING is an SAP database table in S/4HANA. Postings. It contains 47 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
E_RevenueAccountingPosting view_entity from EXTENSION Extension view for RA Posting
FARR_POSTING view_entity from RA Posting Union FARR_D_POSTING-ACDOCA
I_RAPostingWithoutAcctAssgmt view_entity from BASIC Posting Without Acct Assgmt
I_RevenueAccountingPosting view_entity from BASIC Revenue Accounting Posting

Fields (47)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY company_code BUKRS Company Code
KEY acct_principle ACCOUNTING_PRINCIPLE Accounting Principle
KEY recon_key FARR_RECON_KEY Reconcil. Key
KEY pob_id FARR_POB_ID POB
KEY condition_type KSCHA Condition Type
KEY post_cat FARR_POST_CATEGORY Category for PostDoc
KEY shkzg SHKZG Debit/Credit
KEY guid FARR_POSTING_GUID Posting GUID
gjahr GJAHR Fiscal Year
poper POPER Posting Period
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
contract_id FARR_CONTRACT_ID Contract
hkont SAKNR G/L Account
statistic KSTAT Statistical
pob_type FARR_POB_TYPE POB Type
shkzg_va FARR_SHKZG_VA Returns
spec_indicator FARR_DEFITEM_SPECIAL_INDICATOR Special Indicator
aggregation_type FARR_AGGREGATION_TYPE Aggregation Type
invoice_guid FARR_INVOICE_GUID Invoice GUID
srcdoc_comp FARR_RAI_SRCCO Sender Comp.
srcdoc_logsys FARR_RAI_SRCLS Source System
srcdoc_type FARR_RAI_SRCTY SrcDocItemType
srcdoc_id FARR_RAI_SRCID Src. Item ID
dummy_posting_incl_eew_ps CFD_DUMMY Dummy
rep_eew_dummy CFD_DUMMY Dummy
valobjtype VAL_OBJ_TYPE Type of Fin.Val.Obj.
valobj_id VAL_OBJ_ID Fin Valuation Object
fkber FKBER Functional Area
gsber GSBER Business Area
segment FB_SEGMENT Segment
prctr PRCTR Profit Center
paobjnr FARR_PROFIT_SEGMENT_NUM Profit. segment
kostl KOSTL Cost Center
aufnr AUFNR Order
kdauf FARR_SALES_ORDER_NUM Sales Order
kdpos FARR_ORDER_ITEM_NUM Sales Ord. Item
ps_posid PS_POSID WBS Element
ps_psp_pnr PS_PSP_PNR WBS Element
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.

-- Postings
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FARR_D_POSTING (
    CLIENT,                     -- Client [MANDT]
    COMPANY_CODE,               -- Company Code [BUKRS]
    ACCT_PRINCIPLE,             -- Accounting Principle [ACCOUNTING_PRINCIPLE]
    RECON_KEY,                  -- Reconcil. Key [FARR_RECON_KEY]
    POB_ID,                     -- POB [FARR_POB_ID]
    CONDITION_TYPE,             -- Condition Type [KSCHA]
    POST_CAT,                   -- Category for PostDoc [FARR_POST_CATEGORY]
    SHKZG,                      -- Debit/Credit [SHKZG]
    GUID,                       -- Posting GUID [FARR_POSTING_GUID]
    GJAHR,                      -- Fiscal Year [GJAHR]
    POPER,                      -- Posting Period [POPER]
    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]
    CONTRACT_ID,                -- Contract [FARR_CONTRACT_ID]
    HKONT,                      -- G/L Account [SAKNR]
    STATISTIC,                  -- Statistical [KSTAT]
    POB_TYPE,                   -- POB Type [FARR_POB_TYPE]
    SHKZG_VA,                   -- Returns [FARR_SHKZG_VA]
    SPEC_INDICATOR,             -- Special Indicator [FARR_DEFITEM_SPECIAL_INDICATOR]
    AGGREGATION_TYPE,           -- Aggregation Type [FARR_AGGREGATION_TYPE]
    INVOICE_GUID,               -- Invoice GUID [FARR_INVOICE_GUID]
    SRCDOC_COMP,                -- Sender Comp. [FARR_RAI_SRCCO]
    SRCDOC_LOGSYS,              -- Source System [FARR_RAI_SRCLS]
    SRCDOC_TYPE,                -- SrcDocItemType [FARR_RAI_SRCTY]
    SRCDOC_ID,                  -- Src. Item ID [FARR_RAI_SRCID]
    DUMMY_POSTING_INCL_EEW_PS,  -- Dummy [CFD_DUMMY]
    REP_EEW_DUMMY,              -- Dummy [CFD_DUMMY]
    VALOBJTYPE,                 -- Type of Fin.Val.Obj. [VAL_OBJ_TYPE]
    VALOBJ_ID,                  -- Fin Valuation Object [VAL_OBJ_ID]
    FKBER,                      -- Functional Area [FKBER]
    GSBER,                      -- Business Area [GSBER]
    SEGMENT,                    -- Segment [FB_SEGMENT]
    PRCTR,                      -- Profit Center [PRCTR]
    PAOBJNR,                    -- Profit. segment [FARR_PROFIT_SEGMENT_NUM]
    KOSTL,                      -- Cost Center [KOSTL]
    AUFNR,                      -- Order [AUFNR]
    KDAUF,                      -- Sales Order [FARR_SALES_ORDER_NUM]
    KDPOS,                      -- Sales Ord. Item [FARR_ORDER_ITEM_NUM]
    PS_POSID,                   -- WBS Element [PS_POSID]
    PS_PSP_PNR,                 -- WBS Element [PS_PSP_PNR]
    TIMESTAMP,                  -- Time Stamp [TIMESTAMP]
    PRIMARY KEY (CLIENT, COMPANY_CODE, ACCT_PRINCIPLE, RECON_KEY, POB_ID, CONDITION_TYPE, POST_CAT, SHKZG, GUID)
);

Learn More