FRFEC_FICA_DATA2

Transparent Table Application Table
29 Fields 1 CDS Views

FI and FICA reconcilation data for FR FEC

FRFEC_FICA_DATA2 is an SAP database table in S/4HANA. FI and FICA reconcilation data for FR FEC. It contains 29 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_FR_CAAuditFECData view from BASIC France Audit FEC FICA Data

Fields (29)

KeyField Data ElementDescription DomainTypeLength
KEY rclnt mandt Client
KEY rldnr fins_ledger Ledger
KEY rbukrs bukrs Company Code
KEY gjahr gjahr Fiscal Year
KEY belnr belnr_d Document Number
KEY buzei buzei Item
KEY fikey fikey_kk Reconcil. Key
KEY sumsz sumsz_kk Record counter
KEY opbel opbel_kk Document Number
KEY opupk opupk_kk Item
KEY opupz opupz_kk Subitem
KEY oaugb augbl_kk Clearing Doc.
blart blart Document Type
bldat bldat Document Date
monat perbl Period Block
budat budat_kk Posting Date
xblnr xblnr_kk Reference
gpart gpart_kk Bus. Partner
hkont hkont_kk G/L Account
shkzg shkzg Debit/Credit
betrw betrw_kk Amount
waers blwae_kk Currency
betrh betrh_kk Local Crcy Amt
hwaer hwaer Local Currency
augbl augbl_kk Clearing Doc.
augdt augdt_kk Clearing
cpudt cpudt Entered On
blart_kk blart_kk Document Type
applk applk_kk ApplicationArea

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.

-- FI and FICA reconcilation data for FR FEC
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FRFEC_FICA_DATA2 (
    RCLNT,     -- Client [mandt]
    RLDNR,     -- Ledger [fins_ledger]
    RBUKRS,    -- Company Code [bukrs]
    GJAHR,     -- Fiscal Year [gjahr]
    BELNR,     -- Document Number [belnr_d]
    BUZEI,     -- Item [buzei]
    FIKEY,     -- Reconcil. Key [fikey_kk]
    SUMSZ,     -- Record counter [sumsz_kk]
    OPBEL,     -- Document Number [opbel_kk]
    OPUPK,     -- Item [opupk_kk]
    OPUPZ,     -- Subitem [opupz_kk]
    OAUGB,     -- Clearing Doc. [augbl_kk]
    BLART,     -- Document Type [blart]
    BLDAT,     -- Document Date [bldat]
    MONAT,     -- Period Block [perbl]
    BUDAT,     -- Posting Date [budat_kk]
    XBLNR,     -- Reference [xblnr_kk]
    GPART,     -- Bus. Partner [gpart_kk]
    HKONT,     -- G/L Account [hkont_kk]
    SHKZG,     -- Debit/Credit [shkzg]
    BETRW,     -- Amount [betrw_kk]
    WAERS,     -- Currency [blwae_kk]
    BETRH,     -- Local Crcy Amt [betrh_kk]
    HWAER,     -- Local Currency [hwaer]
    AUGBL,     -- Clearing Doc. [augbl_kk]
    AUGDT,     -- Clearing [augdt_kk]
    CPUDT,     -- Entered On [cpudt]
    BLART_KK,  -- Document Type [blart_kk]
    APPLK,     -- ApplicationArea [applk_kk]
    PRIMARY KEY (RCLNT, RLDNR, RBUKRS, GJAHR, BELNR, BUZEI, FIKEY, SUMSZ, OPBEL, OPUPK, OPUPZ, OAUGB)
);

Learn More