JVGLFLEXT
General Ledger: Totals
JVGLFLEXT is an SAP database table in S/4HANA. General Ledger: Totals. It contains 126 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| FGL_GLTT_SRC | view | union_all | View across G/L TT-tables. Generated on 21.08.2015 |
Fields (126)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | rclnt | MANDT | Client | |||
| KEY | ryear | GJAHR | Fiscal Year | |||
| KEY | objnr00 | G_OBJNR | Object number | |||
| KEY | objnr01 | G_OBJNR | Object number | |||
| KEY | objnr02 | G_OBJNR | Object number | |||
| KEY | objnr03 | G_OBJNR | Object number | |||
| KEY | objnr04 | G_OBJNR | Object number | |||
| KEY | objnr05 | G_OBJNR | Object number | |||
| KEY | objnr06 | G_OBJNR | Object number | |||
| KEY | objnr07 | G_OBJNR | Object number | |||
| KEY | objnr08 | G_OBJNR | Object number | |||
| KEY | drcrk | SHKZG | Debit/Credit | |||
| KEY | rpmax | RPMAX | Period | |||
| activ | ACTI1 | Transaction | ||||
| rmvct | RMVCT | Transact. Type | ||||
| rtcur | RTCUR | Currency | ||||
| runit | MEINS | Base Unit | ||||
| awtyp | AWTYP | Ref. procedure | ||||
| rldnr | FAGL_RLDNR | Ledger | ||||
| rrcty | RRCTY | Record Type | ||||
| rvers | RVERS | Version | ||||
| logsys | LOGSYS | Logical system | ||||
| racct | RACCT | Account Number | ||||
| cost_elem | KSTAR | Cost Element | ||||
| rbukrs | BUKRS | Company Code | ||||
| 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. | ||||
| tslvt | TSLVT12 | Bal. c/f TC | ||||
| tsl01 | TSLXX12 | Total TC | ||||
| tsl02 | TSLXX12 | Total TC | ||||
| tsl03 | TSLXX12 | Total TC | ||||
| tsl04 | TSLXX12 | Total TC | ||||
| tsl05 | TSLXX12 | Total TC | ||||
| tsl06 | TSLXX12 | Total TC | ||||
| tsl07 | TSLXX12 | Total TC | ||||
| tsl08 | TSLXX12 | Total TC | ||||
| tsl09 | TSLXX12 | Total TC | ||||
| tsl10 | TSLXX12 | Total TC | ||||
| tsl11 | TSLXX12 | Total TC | ||||
| tsl12 | TSLXX12 | Total TC | ||||
| tsl13 | TSLXX12 | Total TC | ||||
| tsl14 | TSLXX12 | Total TC | ||||
| tsl15 | TSLXX12 | Total TC | ||||
| tsl16 | TSLXX12 | Total TC | ||||
| hslvt | HSLVT12 | Bal. C/F LC | ||||
| hsl01 | HSLXX12 | Total LC | ||||
| hsl02 | HSLXX12 | Total LC | ||||
| hsl03 | HSLXX12 | Total LC | ||||
| hsl04 | HSLXX12 | Total LC | ||||
| hsl05 | HSLXX12 | Total LC | ||||
| hsl06 | HSLXX12 | Total LC | ||||
| hsl07 | HSLXX12 | Total LC | ||||
| hsl08 | HSLXX12 | Total LC | ||||
| hsl09 | HSLXX12 | Total LC | ||||
| hsl10 | HSLXX12 | Total LC | ||||
| hsl11 | HSLXX12 | Total LC | ||||
| hsl12 | HSLXX12 | Total LC | ||||
| hsl13 | HSLXX12 | Total LC | ||||
| hsl14 | HSLXX12 | Total LC | ||||
| hsl15 | HSLXX12 | Total LC | ||||
| hsl16 | HSLXX12 | Total LC | ||||
| kslvt | KSLXX12 | Total GC | ||||
| ksl01 | KSLXX12 | Total GC | ||||
| ksl02 | KSLXX12 | Total GC | ||||
| ksl03 | KSLXX12 | Total GC | ||||
| ksl04 | KSLXX12 | Total GC | ||||
| ksl05 | KSLXX12 | Total GC | ||||
| ksl06 | KSLXX12 | Total GC | ||||
| ksl07 | KSLXX12 | Total GC | ||||
| ksl08 | KSLXX12 | Total GC | ||||
| ksl09 | KSLXX12 | Total GC | ||||
| ksl10 | KSLXX12 | Total GC | ||||
| ksl11 | KSLXX12 | Total GC | ||||
| ksl12 | KSLXX12 | Total GC | ||||
| ksl13 | KSLXX12 | Total GC | ||||
| ksl14 | KSLXX12 | Total GC | ||||
| ksl15 | KSLXX12 | Total GC | ||||
| ksl16 | KSLXX12 | Total GC | ||||
| oslvt | OSLVT12 | Bal.Carried Fwd | ||||
| osl01 | OSLXX12 | Total | ||||
| osl02 | OSLXX12 | Total | ||||
| osl03 | OSLXX12 | Total | ||||
| osl04 | OSLXX12 | Total | ||||
| osl05 | OSLXX12 | Total | ||||
| osl06 | OSLXX12 | Total | ||||
| osl07 | OSLXX12 | Total | ||||
| osl08 | OSLXX12 | Total | ||||
| osl09 | OSLXX12 | Total | ||||
| osl10 | OSLXX12 | Total | ||||
| osl11 | OSLXX12 | Total | ||||
| osl12 | OSLXX12 | Total | ||||
| osl13 | OSLXX12 | Total | ||||
| osl14 | OSLXX12 | Total | ||||
| osl15 | OSLXX12 | Total | ||||
| osl16 | OSLXX12 | Total | ||||
| mslvt | MSLVT12 | Blnce C/F Quant | ||||
| msl01 | MSLXX12 | Total Quants | ||||
| msl02 | MSLXX12 | Total Quants | ||||
| msl03 | MSLXX12 | Total Quants | ||||
| msl04 | MSLXX12 | Total Quants | ||||
| msl05 | MSLXX12 | Total Quants | ||||
| msl06 | MSLXX12 | Total Quants | ||||
| msl07 | MSLXX12 | Total Quants | ||||
| msl08 | MSLXX12 | Total Quants | ||||
| msl09 | MSLXX12 | Total Quants | ||||
| msl10 | MSLXX12 | Total Quants | ||||
| msl11 | MSLXX12 | Total Quants | ||||
| msl12 | MSLXX12 | Total Quants | ||||
| msl13 | MSLXX12 | Total Quants | ||||
| msl14 | MSLXX12 | Total Quants | ||||
| msl15 | MSLXX12 | Total Quants | ||||
| msl16 | MSLXX12 | Total Quants | ||||
| 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.
-- General Ledger: Totals
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE JVGLFLEXT (
RCLNT, -- Client [MANDT]
RYEAR, -- Fiscal Year [GJAHR]
OBJNR00, -- Object number [G_OBJNR]
OBJNR01, -- Object number [G_OBJNR]
OBJNR02, -- Object number [G_OBJNR]
OBJNR03, -- Object number [G_OBJNR]
OBJNR04, -- Object number [G_OBJNR]
OBJNR05, -- Object number [G_OBJNR]
OBJNR06, -- Object number [G_OBJNR]
OBJNR07, -- Object number [G_OBJNR]
OBJNR08, -- Object number [G_OBJNR]
DRCRK, -- Debit/Credit [SHKZG]
RPMAX, -- Period [RPMAX]
ACTIV, -- Transaction [ACTI1]
RMVCT, -- Transact. Type [RMVCT]
RTCUR, -- Currency [RTCUR]
RUNIT, -- Base Unit [MEINS]
AWTYP, -- Ref. procedure [AWTYP]
RLDNR, -- Ledger [FAGL_RLDNR]
RRCTY, -- Record Type [RRCTY]
RVERS, -- Version [RVERS]
LOGSYS, -- Logical system [LOGSYS]
RACCT, -- Account Number [RACCT]
COST_ELEM, -- Cost Element [KSTAR]
RBUKRS, -- Company Code [BUKRS]
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]
TSLVT, -- Bal. c/f TC [TSLVT12]
TSL01, -- Total TC [TSLXX12]
TSL02, -- Total TC [TSLXX12]
TSL03, -- Total TC [TSLXX12]
TSL04, -- Total TC [TSLXX12]
TSL05, -- Total TC [TSLXX12]
TSL06, -- Total TC [TSLXX12]
TSL07, -- Total TC [TSLXX12]
TSL08, -- Total TC [TSLXX12]
TSL09, -- Total TC [TSLXX12]
TSL10, -- Total TC [TSLXX12]
TSL11, -- Total TC [TSLXX12]
TSL12, -- Total TC [TSLXX12]
TSL13, -- Total TC [TSLXX12]
TSL14, -- Total TC [TSLXX12]
TSL15, -- Total TC [TSLXX12]
TSL16, -- Total TC [TSLXX12]
HSLVT, -- Bal. C/F LC [HSLVT12]
HSL01, -- Total LC [HSLXX12]
HSL02, -- Total LC [HSLXX12]
HSL03, -- Total LC [HSLXX12]
HSL04, -- Total LC [HSLXX12]
HSL05, -- Total LC [HSLXX12]
HSL06, -- Total LC [HSLXX12]
HSL07, -- Total LC [HSLXX12]
HSL08, -- Total LC [HSLXX12]
HSL09, -- Total LC [HSLXX12]
HSL10, -- Total LC [HSLXX12]
HSL11, -- Total LC [HSLXX12]
HSL12, -- Total LC [HSLXX12]
HSL13, -- Total LC [HSLXX12]
HSL14, -- Total LC [HSLXX12]
HSL15, -- Total LC [HSLXX12]
HSL16, -- Total LC [HSLXX12]
KSLVT, -- Total GC [KSLXX12]
KSL01, -- Total GC [KSLXX12]
KSL02, -- Total GC [KSLXX12]
KSL03, -- Total GC [KSLXX12]
KSL04, -- Total GC [KSLXX12]
KSL05, -- Total GC [KSLXX12]
KSL06, -- Total GC [KSLXX12]
KSL07, -- Total GC [KSLXX12]
KSL08, -- Total GC [KSLXX12]
KSL09, -- Total GC [KSLXX12]
KSL10, -- Total GC [KSLXX12]
KSL11, -- Total GC [KSLXX12]
KSL12, -- Total GC [KSLXX12]
KSL13, -- Total GC [KSLXX12]
KSL14, -- Total GC [KSLXX12]
KSL15, -- Total GC [KSLXX12]
KSL16, -- Total GC [KSLXX12]
OSLVT, -- Bal.Carried Fwd [OSLVT12]
OSL01, -- Total [OSLXX12]
OSL02, -- Total [OSLXX12]
OSL03, -- Total [OSLXX12]
OSL04, -- Total [OSLXX12]
OSL05, -- Total [OSLXX12]
OSL06, -- Total [OSLXX12]
OSL07, -- Total [OSLXX12]
OSL08, -- Total [OSLXX12]
OSL09, -- Total [OSLXX12]
OSL10, -- Total [OSLXX12]
OSL11, -- Total [OSLXX12]
OSL12, -- Total [OSLXX12]
OSL13, -- Total [OSLXX12]
OSL14, -- Total [OSLXX12]
OSL15, -- Total [OSLXX12]
OSL16, -- Total [OSLXX12]
MSLVT, -- Blnce C/F Quant [MSLVT12]
MSL01, -- Total Quants [MSLXX12]
MSL02, -- Total Quants [MSLXX12]
MSL03, -- Total Quants [MSLXX12]
MSL04, -- Total Quants [MSLXX12]
MSL05, -- Total Quants [MSLXX12]
MSL06, -- Total Quants [MSLXX12]
MSL07, -- Total Quants [MSLXX12]
MSL08, -- Total Quants [MSLXX12]
MSL09, -- Total Quants [MSLXX12]
MSL10, -- Total Quants [MSLXX12]
MSL11, -- Total Quants [MSLXX12]
MSL12, -- Total Quants [MSLXX12]
MSL13, -- Total Quants [MSLXX12]
MSL14, -- Total Quants [MSLXX12]
MSL15, -- Total Quants [MSLXX12]
MSL16, -- Total Quants [MSLXX12]
TIMESTAMP, -- Time Stamp [TIMESTAMP]
PRIMARY KEY (RCLNT, RYEAR, OBJNR00, OBJNR01, OBJNR02, OBJNR03, OBJNR04, OBJNR05, OBJNR06, OBJNR07, OBJNR08, DRCRK, RPMAX)
);Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA