SAP ABAP Table GLREFP (Example for Local FI-SL Line Items (Plan))
Hierarchy
☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ GBAS (Package) FI-SL Customizing / integration / Basis
Basic Data
Table Category TRANSP    Transparent table 
Transparent table GLREFP   Table Relationship Diagram
Short Description Example for Local FI-SL Line Items (Plan)    
Delivery and Maintenance
Pool/cluster      
Delivery Class A   Application Table (Master- and Transaction Data) 
Data Browser/Table View Maintenance     Display/Maintenance Allowed with Restrictions 
Components
     
Field Key Data Element Domain Data
Type		 Length Decimal
Places		 Short Description Check
table
1 RCLNT MANDT MANDT CLNT 3   0   Client T000
2 GL_SIRID GU_RECID OBJNR CHAR 18   0   Record number of the line item record  
3 RLDNR RLDNR RLDNR CHAR 2   0   Ledger T881
4 RRCTY RRCTY RRCTY CHAR 1   0   Record Type  
5 RVERS RVERS RVERS CHAR 3   0   Version T894
6 RYEAR GJAHR GJAHR NUMC 4   0   Fiscal Year  
7 RTCUR RTCUR WAERS CUKY 5   0   Currency Key TCURC
8 RUNIT MEINS MEINS UNIT 3   0   Base Unit of Measure T006
9 DRCRK SHKZG SHKZG CHAR 1   0   Debit/Credit Indicator  
10 RPMAX RPMAX RPMAX NUMC 3   0   Period  
11 DOCCT DOCCT DOCCT CHAR 1   0   Document Type  
12 DOCNR BELNR_D BELNR CHAR 10   0   Accounting Document Number  
13 DOCLN DOCLN6 DOCLN6 CHAR 6   0   Six-Character Posting Item for Ledger  
14 RBUKRS BUKRS BUKRS CHAR 4   0   Company Code T001
15 RACCT RACCT SAKNR CHAR 10   0   Account Number *
16 RBUSA GSBER GSBER CHAR 4   0   Business Area TGSB
17 RCNTR KOSTL KOSTL CHAR 10   0   Cost Center *
18 RFAREA FKBER FKBER CHAR 16   0   Functional Area TFKB
19 LOGSYS LOGSYS LOGSYS CHAR 10   0   Logical system TBDLS
20 SBUKRS PBUKRS BUKRS CHAR 4   0   Company code of partner T001
21 SACCT PRACCT SAKNR CHAR 10   0   Partner account number *
22 SBUSA PPARGB GSBER CHAR 4   0   Trading Partner Business Area of the Business Partner TGSB
23 SCNTR PKOSTL KOSTL CHAR 10   0   Partner cost center *
24 SFAREA SFKBER FKBER CHAR 16   0   Partner Functional Area TFKB
25 TSLVT TSLVT9 WERTV9 CURR 17   2   Balance carried forward in transaction currency  
26 TSL01 TSLXX9 WERTV9 CURR 17   2   Total of transactions of the period in transaction currency  
27 TSL02 TSLXX9 WERTV9 CURR 17   2   Total of transactions of the period in transaction currency  
28 TSL03 TSLXX9 WERTV9 CURR 17   2   Total of transactions of the period in transaction currency  
29 TSL04 TSLXX9 WERTV9 CURR 17   2   Total of transactions of the period in transaction currency  
30 TSL05 TSLXX9 WERTV9 CURR 17   2   Total of transactions of the period in transaction currency  
31 TSL06 TSLXX9 WERTV9 CURR 17   2   Total of transactions of the period in transaction currency  
32 TSL07 TSLXX9 WERTV9 CURR 17   2   Total of transactions of the period in transaction currency  
33 TSL08 TSLXX9 WERTV9 CURR 17   2   Total of transactions of the period in transaction currency  
34 TSL09 TSLXX9 WERTV9 CURR 17   2   Total of transactions of the period in transaction currency  
35 TSL10 TSLXX9 WERTV9 CURR 17   2   Total of transactions of the period in transaction currency  
36 TSL11 TSLXX9 WERTV9 CURR 17   2   Total of transactions of the period in transaction currency  
37 TSL12 TSLXX9 WERTV9 CURR 17   2   Total of transactions of the period in transaction currency  
38 TSL13 TSLXX9 WERTV9 CURR 17   2   Total of transactions of the period in transaction currency  
39 TSL14 TSLXX9 WERTV9 CURR 17   2   Total of transactions of the period in transaction currency  
40 TSL15 TSLXX9 WERTV9 CURR 17   2   Total of transactions of the period in transaction currency  
41 TSL16 TSLXX9 WERTV9 CURR 17   2   Total of transactions of the period in transaction currency  
42 HSLVT HSLVT9 WERTV9 CURR 17   2   Balance carried forward in local currency  
43 HSL01 HSLXX9 WERTV9 CURR 17   2   Total of transactions of the period in local currency  
44 HSL02 HSLXX9 WERTV9 CURR 17   2   Total of transactions of the period in local currency  
45 HSL03 HSLXX9 WERTV9 CURR 17   2   Total of transactions of the period in local currency  
46 HSL04 HSLXX9 WERTV9 CURR 17   2   Total of transactions of the period in local currency  
47 HSL05 HSLXX9 WERTV9 CURR 17   2   Total of transactions of the period in local currency  
48 HSL06 HSLXX9 WERTV9 CURR 17   2   Total of transactions of the period in local currency  
49 HSL07 HSLXX9 WERTV9 CURR 17   2   Total of transactions of the period in local currency  
50 HSL08 HSLXX9 WERTV9 CURR 17   2   Total of transactions of the period in local currency  
51 HSL09 HSLXX9 WERTV9 CURR 17   2   Total of transactions of the period in local currency  
52 HSL10 HSLXX9 WERTV9 CURR 17   2   Total of transactions of the period in local currency  
53 HSL11 HSLXX9 WERTV9 CURR 17   2   Total of transactions of the period in local currency  
54 HSL12 HSLXX9 WERTV9 CURR 17   2   Total of transactions of the period in local currency  
55 HSL13 HSLXX9 WERTV9 CURR 17   2   Total of transactions of the period in local currency  
56 HSL14 HSLXX9 WERTV9 CURR 17   2   Total of transactions of the period in local currency  
57 HSL15 HSLXX9 WERTV9 CURR 17   2   Total of transactions of the period in local currency  
58 HSL16 HSLXX9 WERTV9 CURR 17   2   Total of transactions of the period in local currency  
59 KSLVT KSLVT9 WERTV9 CURR 17   2   Balance carried forward in group currency  
60 KSL01 KSLXX9 WERTV9 CURR 17   2   Total of transactions of the period in group currency  
61 KSL02 KSLXX9 WERTV9 CURR 17   2   Total of transactions of the period in group currency  
62 KSL03 KSLXX9 WERTV9 CURR 17   2   Total of transactions of the period in group currency  
63 KSL04 KSLXX9 WERTV9 CURR 17   2   Total of transactions of the period in group currency  
64 KSL05 KSLXX9 WERTV9 CURR 17   2   Total of transactions of the period in group currency  
65 KSL06 KSLXX9 WERTV9 CURR 17   2   Total of transactions of the period in group currency  
66 KSL07 KSLXX9 WERTV9 CURR 17   2   Total of transactions of the period in group currency  
67 KSL08 KSLXX9 WERTV9 CURR 17   2   Total of transactions of the period in group currency  
68 KSL09 KSLXX9 WERTV9 CURR 17   2   Total of transactions of the period in group currency  
69 KSL10 KSLXX9 WERTV9 CURR 17   2   Total of transactions of the period in group currency  
70 KSL11 KSLXX9 WERTV9 CURR 17   2   Total of transactions of the period in group currency  
71 KSL12 KSLXX9 WERTV9 CURR 17   2   Total of transactions of the period in group currency  
72 KSL13 KSLXX9 WERTV9 CURR 17   2   Total of transactions of the period in group currency  
73 KSL14 KSLXX9 WERTV9 CURR 17   2   Total of transactions of the period in group currency  
74 KSL15 KSLXX9 WERTV9 CURR 17   2   Total of transactions of the period in group currency  
75 KSL16 KSLXX9 WERTV9 CURR 17   2   Total of transactions of the period in group currency  
76 MSLVT MSLVT MENGV8 QUAN 15   3   Balance carried forward of quantity  
77 MSL01 MSLXX MENGV8 QUAN 15   3   Total of the transactions of period in units of measure  
78 MSL02 MSLXX MENGV8 QUAN 15   3   Total of the transactions of period in units of measure  
79 MSL03 MSLXX MENGV8 QUAN 15   3   Total of the transactions of period in units of measure  
80 MSL04 MSLXX MENGV8 QUAN 15   3   Total of the transactions of period in units of measure  
81 MSL05 MSLXX MENGV8 QUAN 15   3   Total of the transactions of period in units of measure  
82 MSL06 MSLXX MENGV8 QUAN 15   3   Total of the transactions of period in units of measure  
83 MSL07 MSLXX MENGV8 QUAN 15   3   Total of the transactions of period in units of measure  
84 MSL08 MSLXX MENGV8 QUAN 15   3   Total of the transactions of period in units of measure  
85 MSL09 MSLXX MENGV8 QUAN 15   3   Total of the transactions of period in units of measure  
86 MSL10 MSLXX MENGV8 QUAN 15   3   Total of the transactions of period in units of measure  
87 MSL11 MSLXX MENGV8 QUAN 15   3   Total of the transactions of period in units of measure  
88 MSL12 MSLXX MENGV8 QUAN 15   3   Total of the transactions of period in units of measure  
89 MSL13 MSLXX MENGV8 QUAN 15   3   Total of the transactions of period in units of measure  
90 MSL14 MSLXX MENGV8 QUAN 15   3   Total of the transactions of period in units of measure  
91 MSL15 MSLXX MENGV8 QUAN 15   3   Total of the transactions of period in units of measure  
92 MSL16 MSLXX MENGV8 QUAN 15   3   Total of the transactions of period in units of measure  
93 ASLVT ASLVT MENGV8 QUAN 15   3   Balance carried forward of additional quantity  
94 ASL01 ASLXX MENGV8 QUAN 15   3   Total of transactions of period in additional quantities  
95 ASL02 ASLXX MENGV8 QUAN 15   3   Total of transactions of period in additional quantities  
96 ASL03 ASLXX MENGV8 QUAN 15   3   Total of transactions of period in additional quantities  
97 ASL04 ASLXX MENGV8 QUAN 15   3   Total of transactions of period in additional quantities  
98 ASL05 ASLXX MENGV8 QUAN 15   3   Total of transactions of period in additional quantities  
99 ASL06 ASLXX MENGV8 QUAN 15   3   Total of transactions of period in additional quantities  
100 ASL07 ASLXX MENGV8 QUAN 15   3   Total of transactions of period in additional quantities  
101 ASL08 ASLXX MENGV8 QUAN 15   3   Total of transactions of period in additional quantities  
102 ASL09 ASLXX MENGV8 QUAN 15   3   Total of transactions of period in additional quantities  
103 ASL10 ASLXX MENGV8 QUAN 15   3   Total of transactions of period in additional quantities  
104 ASL11 ASLXX MENGV8 QUAN 15   3   Total of transactions of period in additional quantities  
105 ASL12 ASLXX MENGV8 QUAN 15   3   Total of transactions of period in additional quantities  
106 ASL13 ASLXX MENGV8 QUAN 15   3   Total of transactions of period in additional quantities  
107 ASL14 ASLXX MENGV8 QUAN 15   3   Total of transactions of period in additional quantities  
108 ASL15 ASLXX MENGV8 QUAN 15   3   Total of transactions of period in additional quantities  
109 ASL16 ASLXX MENGV8 QUAN 15   3   Total of transactions of period in additional quantities  
110 AUNIT AUNIT MEINS UNIT 3   0   Additional unit of measure T006
111 SGTXT SGTXT TEXT50 CHAR 50   0   Item Text  
112 DOCTY DOCTY DOCTY CHAR 2   0   FI-SL Document Type T889
113 ACTIV GLVOR CHAR4 CHAR 4   0   Business Transaction  
114 BUDAT BUDAT DATUM DATS 8   0   Posting Date in the Document  
115 WSDAT WSDAT DATUM DATS 8   0   Value Date for Currency Translation  
116 REFDOCNR REFBELNR BELNR CHAR 10   0   Reference document number of an accounting document  
117 REFRYEAR REFGJAHR GJAHR NUMC 4   0   Reference fiscal year  
118 REFDOCLN REFBUZEI6 BUZEI6 NUMC 6   0   Six-digit number of the reference posting line  
119 REFDOCCT REFDOCCT DOCCT CHAR 1   0   Reference document category  
120 REFACTIV REFGLVOR CHAR4 CHAR 4   0   FI-SL Business Reference Transaction  
121 CPUDT CPUDT DATUM DATS 8   0   Accounting document entry date  
122 CPUTM CPUTM UZEIT TIMS 6   0   Time of data entry  
123 USNAM USNAM XUBNAME CHAR 12   0   User name *
124 AWTYP AWTYP AWTYP CHAR 5   0   Reference procedure TTYP
125 AWORG AWORG AWORG CHAR 10   0   Reference organisational units  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 GLREFP AUNIT T006 MSEHI REF C CN
2 GLREFP AWTYP TTYP AWTYP REF C CN
3 GLREFP DOCTY T889 DOCTY REF C CN
4 GLREFP LOGSYS TBDLS LOGSYS REF C CN
5 GLREFP RBUKRS T001 BUKRS REF C CN
6 GLREFP RBUSA TGSB GSBER REF C CN
7 GLREFP RCLNT T000 MANDT KEY 1 CN
8 GLREFP RFAREA TFKB FKBER REF C CN
9 GLREFP RLDNR T881 RLDNR REF C CN
10 GLREFP RTCUR TCURC WAERS REF C CN
11 GLREFP RUNIT T006 MSEHI REF C CN
12 GLREFP RVERS T894 RVERS REF C CN
13 GLREFP SBUKRS T001 BUKRS REF C CN
14 GLREFP SBUSA TGSB GSBER REF C CN
15 GLREFP SFAREA TFKB FKBER REF C CN
History
Last changed by/on SAP  20130529 
SAP Release Created in