JVGLFLEXA

Transparent Table Application Table
51 Fields 1 CDS Views

General Ledger: Actual Line Items

JVGLFLEXA is an SAP database table in S/4HANA. General Ledger: Actual Line Items. It contains 51 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
FGL_GLSI_SRC view union_all View across G/L SI-tables. Generated on 21.08.2015

Fields (51)

KeyField Data ElementDescription DomainTypeLength
KEY rclnt MANDT Client
KEY ryear GJAHR Fiscal Year
KEY docnr BELNR_D Document Number
KEY rldnr FAGL_RLDNR Ledger
KEY rbukrs BUKRS Company Code
KEY docln DOCLN6 G/L Line Item
activ ACTI1 Transaction
rmvct RMVCT Transact. Type
rtcur RTCUR Currency
runit MEINS Base Unit
awtyp AWTYP Ref. procedure
rrcty RRCTY Record Type
rvers RVERS Version
logsys LOGSYS Logical system
racct RACCT Account Number
cost_elem KSTAR Cost Element
rcntr KOSTL Cost Center
prctr PRCTR Profit Center
rfarea FKBER Functional Area
rbusa GSBER Business Area
kokrs KOKRS CO Area
segment FB_SEGMENT Segment
scntr SKOST Sender Cost Ctr
pprctr PPRCTR Partner PC
sfarea SFKBER Partner FArea
sbusa PARGB Trdg Part.BA
rassc RASSC Trading Partner
psegment FB_PSEGMENT Partner Segment
vname JV_NAME Joint venture
egrup JV_EGROUP Equity group
recid JV_RECIND Recovery Ind.
tsl VTCUR12 Amount in TC
hsl VLCUR12 Local Crcy Amt
ksl VGCUR12 Amnt in GrpCrcy
osl VOCUR12 Other Crcy Amnt
msl QUAN1_12 Quantity
wsl VWCUR12 OrigTrnsCrcyAmt
drcrk SHKZG Debit/Credit
poper POPER Posting Period
rwcur RWCUR Or.trans.currny
gjahr GJAHR Fiscal Year
budat BUDAT Posting Date
belnr BELNR_D Document Number
buzei BUZEI Item
bschl BSCHL Posting Key
bstat BSTAT_D Document Status
linetype LINETYPE Item Category
xsplitmod XSPLITMOD Changed
usnam USNAM User Name
timestamp TIMESTAMP Time Stamp
_dataaging DATA_TEMPERATURE Data Aging

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 JVGLFLEXA (
    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]
    VNAME,       -- Joint venture [JV_NAME]
    EGRUP,       -- Equity group [JV_EGROUP]
    RECID,       -- Recovery Ind. [JV_RECIND]
    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)
);

Learn More