FAGLFLEXA

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.

-- General Ledger: Actual Line Items
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FAGLFLEXA (
    RCLNT,       -- Client [MANDT]
    RYEAR,       -- Fiscal Year [GJAHR]
    DOCNR,       -- Document Number [BELNR_D]
    RLDNR,       -- Ledger [FAGL_RLDNR]
    RBUKRS,      -- Company Code [BUKRS]
    DOCLN,       -- G/L Line Item [DOCLN6]
    ACTIV,       -- Transaction [ACTI1]
    RMVCT,       -- Transact. Type [RMVCT]
    RTCUR,       -- Currency [RTCUR]
    RUNIT,       -- Base Unit [MEINS]
    AWTYP,       -- Ref. procedure [AWTYP]
    RRCTY,       -- Record Type [RRCTY]
    RVERS,       -- Version [RVERS]
    LOGSYS,      -- Logical system [LOGSYS]
    RACCT,       -- Account Number [RACCT]
    COST_ELEM,   -- Cost Element [KSTAR]
    RCNTR,       -- Cost Center [KOSTL]
    PRCTR,       -- Profit Center [PRCTR]
    RFAREA,      -- Functional Area [FKBER]
    RBUSA,       -- Business Area [GSBER]
    KOKRS,       -- CO Area [KOKRS]
    SEGMENT,     -- Segment [FB_SEGMENT]
    SCNTR,       -- Sender Cost Ctr [SKOST]
    PPRCTR,      -- Partner PC [PPRCTR]
    SFAREA,      -- Partner FArea [SFKBER]
    SBUSA,       -- Trdg Part.BA [PARGB]
    RASSC,       -- Trading Partner [RASSC]
    PSEGMENT,    -- Partner Segment [FB_PSEGMENT]
    TSL,         -- Amount in TC [VTCUR12]
    HSL,         -- Local Crcy Amt [VLCUR12]
    KSL,         -- Amnt in GrpCrcy [VGCUR12]
    OSL,         -- Other Crcy Amnt [VOCUR12]
    MSL,         -- Quantity [QUAN1_12]
    WSL,         -- OrigTrnsCrcyAmt [VWCUR12]
    DRCRK,       -- Debit/Credit [SHKZG]
    POPER,       -- Posting Period [POPER]
    RWCUR,       -- Or.trans.currny [RWCUR]
    GJAHR,       -- Fiscal Year [GJAHR]
    BUDAT,       -- Posting Date [BUDAT]
    BELNR,       -- Document Number [BELNR_D]
    BUZEI,       -- Item [BUZEI]
    BSCHL,       -- Posting Key [BSCHL]
    BSTAT,       -- Document Status [BSTAT_D]
    LINETYPE,    -- Item Category [LINETYPE]
    XSPLITMOD,   -- Changed [XSPLITMOD]
    USNAM,       -- User Name [USNAM]
    TIMESTAMP,   -- Time Stamp [TIMESTAMP]
    _DATAAGING,  -- Data Aging [DATA_TEMPERATURE]
    PRIMARY KEY (RCLNT, RYEAR, DOCNR, RLDNR, RBUKRS, DOCLN)
);