SAP table FAGLFLEXT (Generated Table for View)

SAP table FAGLFLEXT has 123 primary key fields being RCLNT,RYEAR,OBJNR00,OBJNR01,OBJNR02,OBJNR03,OBJNR04,OBJNR05,OBJNR06,OBJNR07,OBJNR08,DRCRK,RPMAX,ACTIV,RMVCT,RTCUR,RUNIT,AWTYP,RLDNR,RRCTY,RVERS,LOGSYS,RACCT,COST_ELEM,RBUKRS,RCNTR,PRCTR,RFAREA,RBUSA,KOKRS,SEGMENT,SCNTR,PPRCTR,SFAREA,SBUSA,RASSC,PSEGMENT,TSLVT,TSL01,TSL02,TSL03,TSL04,TSL05,TSL06,TSL07,TSL08,TSL09,TSL10,TSL11,TSL12,TSL13,TSL14,TSL15,TSL16,HSLVT,HSL01,HSL02,HSL03,HSL04,HSL05,HSL06,HSL07,HSL08,HSL09,HSL10,HSL11,HSL12,HSL13,HSL14,HSL15,HSL16,KSLVT,KSL01,KSL02,KSL03,KSL04,KSL05,KSL06,KSL07,KSL08,KSL09,KSL10,KSL11,KSL12,KSL13,KSL14,KSL15,KSL16,OSLVT,OSL01,OSL02,OSL03,OSL04,OSL05,OSL06,OSL07,OSL08,OSL09,OSL10,OSL11,OSL12,OSL13,OSL14,OSL15,OSL16,MSLVT,MSL01,MSL02,MSL03,MSL04,MSL05,MSL06,MSL07,MSL08,MSL09,MSL10,MSL11,MSL12,MSL13,MSL14,MSL15,MSL16,TIMESTAMP.

Field Description Data Type Length Decimals Checktable Data Element
RCLNT Client CLNT 3 0 T000 MANDT
RYEAR Fiscal Year NUMC 4 0 GJAHR
OBJNR00 Object Number for Table Group INT4 10 0 G_OBJNR
OBJNR01 Object Number for Table Group INT4 10 0 G_OBJNR
OBJNR02 Object Number for Table Group INT4 10 0 G_OBJNR
OBJNR03 Object Number for Table Group INT4 10 0 G_OBJNR
OBJNR04 Object Number for Table Group INT4 10 0 G_OBJNR
OBJNR05 Object Number for Table Group INT4 10 0 G_OBJNR
OBJNR06 Object Number for Table Group INT4 10 0 G_OBJNR
OBJNR07 Object Number for Table Group INT4 10 0 G_OBJNR
OBJNR08 Object Number for Table Group INT4 10 0 G_OBJNR
DRCRK Debit/Credit Indicator CHAR 1 0 SHKZG
H Credit
S Debit
RPMAX Period NUMC 3 0 RPMAX
ACTIV FI-SL Business Transaction CHAR 4 0 T022 ACTI1
RMVCT Transaction type CHAR 3 0 T856 RMVCT
RTCUR Currency Key CUKY 5 0 RTCUR
RUNIT Base Unit of Measure UNIT 3 0 MEINS
AWTYP Reference procedure CHAR 5 0 TTYP AWTYP
RLDNR Ledger in General Ledger Accounting CHAR 2 0 V_FAGL_T881_DBAL FAGL_RLDNR
RRCTY Record Type CHAR 1 0 RRCTY
0 Actual
1 Plan
2 Actual assessment/distribution
3 Planned assessment/distribution
5 Year-End Closing Posting
RVERS Version CHAR 3 0 T894 RVERS
LOGSYS Logical system CHAR 10 0 TBDLS LOGSYS
RACCT Account Number CHAR 10 0 SKB1 RACCT
COST_ELEM Cost Element CHAR 10 0 CSKB KSTAR
RBUKRS Company Code CHAR 4 0 T001 BUKRS
RCNTR Cost Center CHAR 10 0 CSKS KOSTL
PRCTR Profit Center CHAR 10 0 CEPC PRCTR
RFAREA Functional Area CHAR 16 0 TFKB FKBER
RBUSA Business Area CHAR 4 0 TGSB GSBER
KOKRS Controlling Area CHAR 4 0 TKA01 KOKRS
SEGMENT Segment for Segmental Reporting CHAR 10 0 FAGL_SEGM FB_SEGMENT
SCNTR Sender cost center CHAR 10 0 CSKS SKOST
PPRCTR Partner Profit Center CHAR 10 0 CEPC PPRCTR
SFAREA Partner Functional Area CHAR 16 0 TFKB SFKBER
SBUSA Trading partner's business area CHAR 4 0 TGSB PARGB
RASSC Company ID of Trading Partner CHAR 6 0 T880 RASSC
PSEGMENT Partner Segment for Segmental Reporting CHAR 10 0 FAGL_SEGM FB_PSEGMENT
TSLVT Balance Carryforward in Transaction Currency CURR 23 2 TSLVT12
TSL01 Total of Transactions of the Period in Transaction Currency CURR 23 2 TSLXX12
TSL02 Total of Transactions of the Period in Transaction Currency CURR 23 2 TSLXX12
TSL03 Total of Transactions of the Period in Transaction Currency CURR 23 2 TSLXX12
TSL04 Total of Transactions of the Period in Transaction Currency CURR 23 2 TSLXX12
TSL05 Total of Transactions of the Period in Transaction Currency CURR 23 2 TSLXX12
TSL06 Total of Transactions of the Period in Transaction Currency CURR 23 2 TSLXX12
TSL07 Total of Transactions of the Period in Transaction Currency CURR 23 2 TSLXX12
TSL08 Total of Transactions of the Period in Transaction Currency CURR 23 2 TSLXX12
TSL09 Total of Transactions of the Period in Transaction Currency CURR 23 2 TSLXX12
TSL10 Total of Transactions of the Period in Transaction Currency CURR 23 2 TSLXX12
TSL11 Total of Transactions of the Period in Transaction Currency CURR 23 2 TSLXX12
TSL12 Total of Transactions of the Period in Transaction Currency CURR 23 2 TSLXX12
TSL13 Total of Transactions of the Period in Transaction Currency CURR 23 2 TSLXX12
TSL14 Total of Transactions of the Period in Transaction Currency CURR 23 2 TSLXX12
TSL15 Total of Transactions of the Period in Transaction Currency CURR 23 2 TSLXX12
TSL16 Total of Transactions of the Period in Transaction Currency CURR 23 2 TSLXX12
HSLVT Balance Carried Forward in Local Currency CURR 23 2 HSLVT12
HSL01 Total of Transactions of the Period in Local Currency CURR 23 2 HSLXX12
HSL02 Total of Transactions of the Period in Local Currency CURR 23 2 HSLXX12
HSL03 Total of Transactions of the Period in Local Currency CURR 23 2 HSLXX12
HSL04 Total of Transactions of the Period in Local Currency CURR 23 2 HSLXX12
HSL05 Total of Transactions of the Period in Local Currency CURR 23 2 HSLXX12
HSL06 Total of Transactions of the Period in Local Currency CURR 23 2 HSLXX12
HSL07 Total of Transactions of the Period in Local Currency CURR 23 2 HSLXX12
HSL08 Total of Transactions of the Period in Local Currency CURR 23 2 HSLXX12
HSL09 Total of Transactions of the Period in Local Currency CURR 23 2 HSLXX12
HSL10 Total of Transactions of the Period in Local Currency CURR 23 2 HSLXX12
HSL11 Total of Transactions of the Period in Local Currency CURR 23 2 HSLXX12
HSL12 Total of Transactions of the Period in Local Currency CURR 23 2 HSLXX12
HSL13 Total of Transactions of the Period in Local Currency CURR 23 2 HSLXX12
HSL14 Total of Transactions of the Period in Local Currency CURR 23 2 HSLXX12
HSL15 Total of Transactions of the Period in Local Currency CURR 23 2 HSLXX12
HSL16 Total of Transactions of the Period in Local Currency CURR 23 2 HSLXX12
KSLVT Total of Transactions of the Period in Group Currency CURR 23 2 KSLXX12
KSL01 Total of Transactions of the Period in Group Currency CURR 23 2 KSLXX12
KSL02 Total of Transactions of the Period in Group Currency CURR 23 2 KSLXX12
KSL03 Total of Transactions of the Period in Group Currency CURR 23 2 KSLXX12
KSL04 Total of Transactions of the Period in Group Currency CURR 23 2 KSLXX12
KSL05 Total of Transactions of the Period in Group Currency CURR 23 2 KSLXX12
KSL06 Total of Transactions of the Period in Group Currency CURR 23 2 KSLXX12
KSL07 Total of Transactions of the Period in Group Currency CURR 23 2 KSLXX12
KSL08 Total of Transactions of the Period in Group Currency CURR 23 2 KSLXX12
KSL09 Total of Transactions of the Period in Group Currency CURR 23 2 KSLXX12
KSL10 Total of Transactions of the Period in Group Currency CURR 23 2 KSLXX12
KSL11 Total of Transactions of the Period in Group Currency CURR 23 2 KSLXX12
KSL12 Total of Transactions of the Period in Group Currency CURR 23 2 KSLXX12
KSL13 Total of Transactions of the Period in Group Currency CURR 23 2 KSLXX12
KSL14 Total of Transactions of the Period in Group Currency CURR 23 2 KSLXX12
KSL15 Total of Transactions of the Period in Group Currency CURR 23 2 KSLXX12
KSL16 Total of Transactions of the Period in Group Currency CURR 23 2 KSLXX12
OSLVT Balance Carried Forward in Fourth Currency CURR 23 2 OSLVT12
OSL01 Total Transactions for the Period in the Fourth Currency CURR 23 2 OSLXX12
OSL02 Total Transactions for the Period in the Fourth Currency CURR 23 2 OSLXX12
OSL03 Total Transactions for the Period in the Fourth Currency CURR 23 2 OSLXX12
OSL04 Total Transactions for the Period in the Fourth Currency CURR 23 2 OSLXX12
OSL05 Total Transactions for the Period in the Fourth Currency CURR 23 2 OSLXX12
OSL06 Total Transactions for the Period in the Fourth Currency CURR 23 2 OSLXX12
OSL07 Total Transactions for the Period in the Fourth Currency CURR 23 2 OSLXX12
OSL08 Total Transactions for the Period in the Fourth Currency CURR 23 2 OSLXX12
OSL09 Total Transactions for the Period in the Fourth Currency CURR 23 2 OSLXX12
OSL10 Total Transactions for the Period in the Fourth Currency CURR 23 2 OSLXX12
OSL11 Total Transactions for the Period in the Fourth Currency CURR 23 2 OSLXX12
OSL12 Total Transactions for the Period in the Fourth Currency CURR 23 2 OSLXX12
OSL13 Total Transactions for the Period in the Fourth Currency CURR 23 2 OSLXX12
OSL14 Total Transactions for the Period in the Fourth Currency CURR 23 2 OSLXX12
OSL15 Total Transactions for the Period in the Fourth Currency CURR 23 2 OSLXX12
OSL16 Total Transactions for the Period in the Fourth Currency CURR 23 2 OSLXX12
MSLVT Balance Carried Forward of Quantity QUAN 23 3 MSLVT12
MSL01 Total of the Transactions of Period in Units of Measure QUAN 23 3 MSLXX12
MSL02 Total of the Transactions of Period in Units of Measure QUAN 23 3 MSLXX12
MSL03 Total of the Transactions of Period in Units of Measure QUAN 23 3 MSLXX12
MSL04 Total of the Transactions of Period in Units of Measure QUAN 23 3 MSLXX12
MSL05 Total of the Transactions of Period in Units of Measure QUAN 23 3 MSLXX12
MSL06 Total of the Transactions of Period in Units of Measure QUAN 23 3 MSLXX12
MSL07 Total of the Transactions of Period in Units of Measure QUAN 23 3 MSLXX12
MSL08 Total of the Transactions of Period in Units of Measure QUAN 23 3 MSLXX12
MSL09 Total of the Transactions of Period in Units of Measure QUAN 23 3 MSLXX12
MSL10 Total of the Transactions of Period in Units of Measure QUAN 23 3 MSLXX12
MSL11 Total of the Transactions of Period in Units of Measure QUAN 23 3 MSLXX12
MSL12 Total of the Transactions of Period in Units of Measure QUAN 23 3 MSLXX12
MSL13 Total of the Transactions of Period in Units of Measure QUAN 23 3 MSLXX12
MSL14 Total of the Transactions of Period in Units of Measure QUAN 23 3 MSLXX12
MSL15 Total of the Transactions of Period in Units of Measure QUAN 23 3 MSLXX12
MSL16 Total of the Transactions of Period in Units of Measure QUAN 23 3 MSLXX12
TIMESTAMP UTC Time Stamp in Short Form (YYYYMMDDhhmmss) DEC 15 0 TIMESTAMP

FAGLFLEXT foreign key relationships

Table Field Check Table Check Field
0 FAGLFLEXT AWTYP TTYP Object Types for Accounting AWTYP
1 FAGLFLEXT COST_ELEM CSKB Cost Elements (Data Dependent on Controlling Area) MANDT
1 FAGLFLEXT COST_ELEM CSKB Cost Elements (Data Dependent on Controlling Area) KOKRS
1 FAGLFLEXT COST_ELEM CSKB Cost Elements (Data Dependent on Controlling Area) KSTAR
1 FAGLFLEXT COST_ELEM CSKB Cost Elements (Data Dependent on Controlling Area) DATBI
0 FAGLFLEXT KOKRS TKA01 Controlling Areas MANDT
1 FAGLFLEXT LOGSYS TBDLS Logical system LOGSYS
0 FAGLFLEXT PPRCTR CEPC Profit Center Master Data Table PRCTR
0 FAGLFLEXT PPRCTR CEPC Profit Center Master Data Table DATBI
0 FAGLFLEXT PPRCTR CEPC Profit Center Master Data Table KOKRS
1 FAGLFLEXT PRCTR CEPC Profit Center Master Data Table PRCTR
1 FAGLFLEXT PRCTR CEPC Profit Center Master Data Table DATBI
1 FAGLFLEXT PRCTR CEPC Profit Center Master Data Table KOKRS
0 FAGLFLEXT PSEGMENT FAGL_SEGM Master Data for Segments SEGMENT
1 FAGLFLEXT RACCT SKB1 G/L account master (company code) MANDT
1 FAGLFLEXT RACCT SKB1 G/L account master (company code) BUKRS
0 FAGLFLEXT RASSC T880 Global Company Data (for KONS Ledger) MANDT
0 FAGLFLEXT RASSC T880 Global Company Data (for KONS Ledger) RCOMP
1 FAGLFLEXT RBUKRS T001 Company Codes BUKRS
0 FAGLFLEXT RBUSA TGSB Business Areas MANDT
0 FAGLFLEXT RBUSA TGSB Business Areas GSBER
1 FAGLFLEXT RCLNT T000 Clients MANDT
0 FAGLFLEXT RCNTR CSKS Cost Center Master Record MANDT
0 FAGLFLEXT RCNTR CSKS Cost Center Master Record KOKRS
0 FAGLFLEXT RCNTR CSKS Cost Center Master Record KOSTL
0 FAGLFLEXT RCNTR CSKS Cost Center Master Record DATBI
1 FAGLFLEXT RFAREA TFKB Functional areas FKBER
0 FAGLFLEXT RMVCT T856 Transaction Types MANDT
0 FAGLFLEXT RMVCT T856 Transaction Types TRTYP
1 FAGLFLEXT RVERS T894 FI-SL and FI-LC Versions MANDT
1 FAGLFLEXT RVERS T894 FI-SL and FI-LC Versions RLDNR
1 FAGLFLEXT RVERS T894 FI-SL and FI-LC Versions RVERS
0 FAGLFLEXT SBUSA TGSB Business Areas MANDT
0 FAGLFLEXT SBUSA TGSB Business Areas GSBER
1 FAGLFLEXT SCNTR CSKS Cost Center Master Record MANDT
1 FAGLFLEXT SCNTR CSKS Cost Center Master Record KOKRS
1 FAGLFLEXT SCNTR CSKS Cost Center Master Record KOSTL
1 FAGLFLEXT SCNTR CSKS Cost Center Master Record DATBI
0 FAGLFLEXT SEGMENT FAGL_SEGM Master Data for Segments SEGMENT
1 FAGLFLEXT SFAREA TFKB Functional areas FKBER