SAP ABAP Table FAGL_S_SREP_LINE_ITEMS (Gen. Ledger: Line Items)
Hierarchy
SAP_FIN (Software Component) SAP_FIN
   FI-GL (Application Component) General Ledger Accounting
     GBIW_ERP_LI (Package) Line Item Extractors for General Ledger ERP
Basic Data
Table Category INTTAB    Structure 
Structure FAGL_S_SREP_LINE_ITEMS   Table Relationship Diagram
Short Description Gen. Ledger: Line Items    
Delivery and Maintenance
Pool/cluster      
Delivery Class      
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 .INCLUDE       0   0   Core Fields for Reading Data of Line Items in New GL  
2 ANLN1 ANLN1 ANLN1 CHAR 12   0   Main Asset Number *
3 ANLN2 ANLN2_4 ANLN2_4 CHAR 4   0   New asset subnumber, 4 characters  
4 AUFNR AUFNR AUFNR CHAR 12   0   Order Number *
5 AUGBL AUGBL BELNR CHAR 10   0   Document Number of the Clearing Document  
6 AUGDT AUGDT DATUM DATS 8   0   Clearing Date  
7 BELNR BELNR_D BELNR CHAR 10   0   Accounting Document Number  
8 BLART BLART BLART CHAR 2   0   Document type T003
9 BLDAT BLDAT DATUM DATS 8   0   Document Date in Document  
10 BSCHL BSCHL BSCHL CHAR 2   0   Posting Key TBSL
11 BSTAT BSTAT_D BSTAT CHAR 1   0   Document Status  
12 BUDAT BUDAT DATUM DATS 8   0   Posting Date in the Document  
13 BUKRS BUKRS BUKRS CHAR 4   0   Company Code T001
14 BUZEI BUZEI BUZEI NUMC 3   0   Number of Line Item Within Accounting Document  
15 BWWRT BWWRT_X8 WRTV8 CURR 15   2   Valuated Amount in Local Currency  
16 BWWR2 BWWR2_X8 WRTV8 CURR 15   2   Amount Valuated in Local Currency 2  
17 BWWR3 BWWR3_X8 WRTV8 CURR 15   2   Amount Valuated in Local Currency 3  
18 DMSHB DMSHB_X8 WRTV8 CURR 15   2   Amount in Local Currency with +/- Signs  
19 HWAER HWAER WAERS CUKY 5   0   Local Currency TCURC
20 DMBE2 DMBE2_X8 WRTV8 CURR 15   2   Amount in Second Local Currency  
21 HWAE2 HWAE2 WAERS CUKY 5   0   Currency Key of Second Local Currency *
22 DMBE3 DMBE3_X8 WRTV8 CURR 15   2   Amount in Third Local Currency  
23 HWAE3 HWAE3 WAERS CUKY 5   0   Currency Key of Third Local Currency *
24 EBELN EBELN EBELN CHAR 10   0   Purchasing Document Number *
25 EBELP EBELP EBELP NUMC 5   0   Item Number of Purchasing Document *
26 ETEN2 ETENR ETENR NUMC 4   0   Schedule line *
27 FAEDT FAEDT_FPOS DATUM DATS 8   0   Net Due Date  
28 FILKD FILKD MAXKK CHAR 10   0   Account Number of the Branch  
29 GJAHR GJAHR GJAHR NUMC 4   0   Fiscal Year  
30 GSBER GSBER GSBER CHAR 4   0   Business Area TGSB
31 JAMON JAMON_XPO JAMON_XPO CHAR 7   0   Fiscal Year/Posting Period from Posting Date  
32 KOART KOART KOART CHAR 1   0   Account type  
33 KONTO KTONR_AV KTONR CHAR 10   0   Account Number  
34 KOSTL KOSTL KOSTL CHAR 10   0   Cost Center CSKS
35 MABER MABER MABER CHAR 2   0   Dunning Area T047M
36 MADAT MADAT DATUM DATS 8   0   Date of Last Dunning Notice  
37 MANSP MANSP MANSP CHAR 1   0   Dunning block T040S
38 MANST MAHNS_D MAHNS NUMC 1   0   Dunning Level  
39 MONAT MONAT MONAT NUMC 2   0   Fiscal period  
40 MSCHL MSCHL MSCHL CHAR 1   0   Dunning key T040
41 MWSKZ MWSKZ MWSKZ CHAR 2   0   Tax on sales/purchases code *
42 POSN2 POSNR_VA POSNR NUMC 6   0   Sales Document Item *
43 PRCTR PRCTR PRCTR CHAR 10   0   Profit Center CEPC
44 QBSHB QBSHB_X8 WRTV8 CURR 15   2   Withholding Tax Amount in Document Currency  
45 QSFBT QSFBT_X8 WRTV8 CURR 15   2   Withholding Tax Exempt Amount in Document Currency  
46 QSSHB QSSHB_X8 WRTV8 CURR 15   2   Withholding Tax Base Amount in Document Currency  
47 REBZG REBZG BELNR CHAR 10   0   Number of the Invoice the Transaction Belongs to  
48 SAMNR SAMNR SAMNR NUMC 8   0   Invoice List Number  
49 SGTXT SGTXT TEXT50 CHAR 50   0   Item Text  
50 SHKZG SHKZG SHKZG CHAR 1   0   Debit/Credit Indicator  
51 SKFBT SKFBT_X8 WRTV8 CURR 15   2   Amount Eligible for Cash Discount in Document Currency  
52 WSKTO WSKTO_X8 WRTV8 CURR 15   2   Cash Discount Amount in Document Currency  
53 SKNTO SKNTO_X8 WRTV8 CURR 15   2   Cash Discount Amount in Local Currency  
54 STAKZ XSTKZ XFELD CHAR 1   0   Indicator: Statistical document ?  
55 UMSKS UMSKS UMSKS CHAR 1   0   Special G/L Transaction Type  
56 UMSKZ UMSKZ UMSKZ CHAR 1   0   Special G/L Indicator T074U
57 UZAWE UZAWE UZAWE CHAR 2   0   Payment method supplement *
58 VALUT VALUT DATUM DATS 8   0   Fixed Value Date  
59 VBEL2 VBELN_VA VBELN CHAR 10   0   Sales Document *
60 VBELN VBELN_VF VBELN CHAR 10   0   Billing document *
61 VBEWA SBEWART SBEWART CHAR 4   0   Flow Type *
62 VBUND RASSC RCOMP CHAR 6   0   Company ID of trading partner T880
63 VERTN RANL RANL CHAR 13   0   Contract Number  
64 VERTT RANTYP RANTYP CHAR 1   0   Contract Type  
65 VERZ1 VERZ1 WRTV3 DEC 5   0   Days in Arrears for Cash Discount Terms 1  
66 VERZN VERZN WRTV3 DEC 5   0   Days in Arrears by Net Due Date  
67 WERKS WERKS_D WERKS CHAR 4   0   Plant T001W
68 WRSHB WRSHB_X8 WRTV8 CURR 15   2   Amount in Document Currency (Foreign Currency)  
69 WAERS WAER_DOC WAERS CUKY 5   0   Document Currency (Key) TCURC
70 WVERW WVERW WVERW CHAR 1   0   Bill of Exchange Usage Type  
71 XBLNR XBLNR1 XBLNR1 CHAR 16   0   Reference Document Number  
72 XSTRP XSTRP XFELD CHAR 1   0   Indicator: Disputed item?  
73 XZAHL XZAHL XFELD CHAR 1   0   Indicator: Is Posting Key Used in a Payment Transaction?  
74 ZALDT DZALDT DATUM DATS 8   0   Probable Payment Date (Cash Discount 1 Due)  
75 ZBD1P DZBD1P PRZ23 DEC 5   3   Cash discount percentage 1  
76 ZBD1T DZBD1T ZBDXT DEC 3   0   Cash discount days 1  
77 ZBD2P DZBD2P PRZ23 DEC 5   3   Cash Discount Percentage 2  
78 ZBD2T DZBD2T ZBDXT DEC 3   0   Cash discount days 2  
79 ZBD3T DZBD3T ZBDXT DEC 3   0   Net Payment Terms Period  
80 ZFBDT DZFBDT DATUM DATS 8   0   Baseline date for due date calculation  
81 ZINSZ DZINSZ WRTV8 CURR 15   2   Interest Calculation Numerator (Days in Arrears * Amount)  
82 ZLSCH DZLSCH ZLSCH CHAR 1   0   Payment method T042Z
83 ZLSPR DZLSPR ZAHLS CHAR 1   0   Payment Block Key T008
84 ZTERM DZTERM ZTERM CHAR 4   0   Terms of payment key  
85 ZUONR DZUONR ZUONR CHAR 18   0   Assignment number  
86 XREF1 XREF1 CHAR12 CHAR 12   0   Business partner reference key  
87 XREF2 XREF2 CHAR12 CHAR 12   0   Business partner reference key  
88 XARCH XARCH XFELD CHAR 1   0   Indicator: Document already archived ?  
89 RSTGR RSTGR RSTGR CHAR 3   0   Reason Code for Payments T053R
90 ASKTO ASKTO_X8 WRTV8 CURR 15   2   Current Cash Discount Amount in Document Currency  
91 KURSE KURSE KURSF DEC 9   5   Effective Exchange Rate in the Line Item  
92 REBZT REBZT REBZT CHAR 1   0   Follow-On Document Type  
93 PSWSL PSWSL WAERS CUKY 5   0   Update Currency for General Ledger Transaction Figures TCURC
94 PSWBT PSWBT_X8 WERT8 CURR 15   2   Amount for General Ledger Update (Absolute)  
95 HKONT HKONT SAKNR CHAR 10   0   General Ledger Account *
96 XNEGP XNEGP XFELD CHAR 1   0   Indicator: Negative posting  
97 ZBFIX DZBFIX ZBFIX CHAR 1   0   Fixed Payment Terms  
98 RFZEI RFZEI_CC NUM03 NUMC 3   0   Payment Card Item  
99 CCBTC CCBTC CCBTC CHAR 10   0   Payment cards: Settlement run  
100 KKBER KKBER KKBER CHAR 4   0   Credit control area T014
101 XREF3 XREF3 CHAR20 CHAR 20   0   Reference key for line item  
102 DTWS1 DTAT16 DTWSX NUMC 2   0   Instruction key 1 *
103 DTWS2 DTAT17 DTWSX NUMC 2   0   Instruction key 2 *
104 DTWS3 DTAT18 DTWSX NUMC 2   0   Instruction key 3 *
105 DTWS4 DTAT19 DTWSX NUMC 2   0   Instruction key 4 *
106 ABSBT ABSBT_X8 WERT8 CURR 15   2   Credit Management: Hedged Amount (Absolute)  
107 KKBWR KKBWR WAERS CUKY 5   0   Currency of Credit Control Area *
108 PROJK PROJK_EXT CHAR24 CHAR 24   0   Individual Structural Element (WBS Element) in Ext. Format  
109 XPYPR XPYPR XFELD CHAR 1   0   Indicator: Items from Payment Program Blocked  
110 KIDNO KIDNO CHAR30 CHAR 30   0   Payment Reference  
111 XAUGP XAUGP XFELD CHAR 1   0   Indicator: Item has been cleared?  
112 BUPLA BUPLA J_1BBRANCH CHAR 4   0   Business Place *
113 SECCO SECCO SECCO CHAR 4   0   Section Code *
114 GKART GKART GKART CHAR 1   0   Offsetting Account Type  
115 GKONT GKONT GKONT CHAR 10   0   Offsetting Account Number  
116 PYCUR PYCUR WAERS CUKY 5   0   Currency for Automatic Payment *
117 PYAMT PYAMT_X8 WERT8 CURR 15   2   Amount in Automatic Payment Currency (Absolute)  
118 PYORD PYORD PYORD CHAR 10   0   Payment Order  
119 XRAGL XRAGL XFELD CHAR 1   0   Indicator: Clearing was Reversed  
120 CESSION_KZ CESSION_KZ CESSION_KZ CHAR 2   0   Accounts Receivable Pledging Indicator TCESSION
121 BUZID BUZID CHAR1 CHAR 1   0   Identification of the Line Item  
122 AUGGJ AUGGJ GJAHR NUMC 4   0   Fiscal Year of Clearing Document  
123 AGZEI AGZEI AGZEI DEC 5   0   Clearing Item  
124 LONGNUM /SAPPSPRO/LONGNUM /SAPPSPRO/LONGNUM CHAR 40   0   Smart Number  
125 AWSYS LOGSYSTEM LOGSYS CHAR 10   0   Logical System TBDLS
126 AWTYP AWTYP AWTYP CHAR 5   0   Reference procedure TTYP
127 BDIFF BDIFF WRTV7 CURR 13   2   Valuation Difference  
128 BDIF2 BDIF2 WRTV7 CURR 13   2   Valuation Difference for the Second Local Currency  
129 BDIF3 BDIF3 WRTV7 CURR 13   2   Valuation Difference for the Third Local Currency  
130 BEWAR RMVCT RMVCT CHAR 3   0   Transaction type T856
131 DABRZ DABRBEZ DDAT DATS 8   0   Reference date for settlement  
132 DMBTR DMBTR_X8 WRTV8 CURR 15   2   Amount in Local Currency  
133 DOCNR BELNR_D_POS BELNR CHAR 10   0   Document Number of a General Ledger Document  
134 DOCLN DOCLN6_POS DOCLN6 CHAR 6   0   Six-Character Posting Item for Ledger  
135 FKBER FKBER_SHORT FKBER_SHORT CHAR 4   0   Functional Area  
136 FKBER_LONG FKBER FKBER CHAR 16   0   Functional Area TFKB
137 GLVOR GLVOR CHAR4 CHAR 4   0   Business Transaction  
138 IMKEY IMKEY IMKEY CHAR 8   0   Internal Key for Real Estate Object  
139 KOKRS KOKRS CACCD CHAR 4   0   Controlling Area TKA01
140 KSTAR KSTAR KSTAR CHAR 10   0   Cost Element CSKB
141 KUNNR KUNNR KUNNR CHAR 10   0   Customer Number KNA1
142 LIFNR LIFNR LIFNR CHAR 10   0   Account Number of Vendor or Creditor LFA1
143 MEINS MEINS MEINS UNIT 3   0   Base Unit of Measure T006
144 MENGE MENGE_D MENG13 QUAN 13   3   Quantity  
145 PARGB PARGB GSBER CHAR 4   0   Trading partner's business area TGSB
146 PERIO JAHRPER JAHRPER NUMC 7   0   Period/year  
147 PFKBER SFKBER FKBER CHAR 16   0   Partner Functional Area TFKB
148 PKOSTL PKOSTL KOSTL CHAR 10   0   Partner cost center CSKS
149 POPER POPER POPER NUMC 3   0   Posting period  
150 PPRCT PPRCTR PRCTR CHAR 10   0   Partner Profit Center CEPC
151 PSEGMENT FB_PSEGMENT FB_SEGMENT CHAR 10   0   Partner Segment for Segmental Reporting FAGL_SEGM
152 PS_PSP_PNR PS_PSP_PNR PS_POSNR NUMC 8   0   Work Breakdown Structure Element (WBS Element) *
153 RLDNR RLDNR RLDNR CHAR 2   0   Ledger V_FAGL_T881_DBAL
154 RYEAR GJAHR_POS GJAHR NUMC 4   0   General Ledger Fiscal Year  
155 SAKNR SAKNR SAKNR CHAR 10   0   G/L Account Number SKB1
156 SEGMENT FB_SEGMENT FB_SEGMENT CHAR 10   0   Segment for Segmental Reporting FAGL_SEGM
157 WRBTR WRBTR_X8 WRTV8 CURR 15   2   Amount in Document Currency  
158 XOPVW XOPVW XFELD CHAR 1   0   Indicator: Open Item Management?  
159 LDGRP FAGL_LDGRP FAGL_LDGRP CHAR 4   0   Ledger Group *
160 XLGCLR XLGCLR XFELD CHAR 1   0   Clearing Specific to Ledger Groups  
161 XREORG FAGL_R_XDOC_REORG FLAG CHAR 1   0   Doc. Contains Open Item that Was Transferred During Reorg.  
162 .INCLUDE       0   0    
163 AWKEY AWKEY AWKEY CHAR 20   0   Object key  
164 CPUDT CPUDT DATUM DATS 8   0   Accounting document entry date  
165 TIMESTAMP TIMESTAMP TZNTSTMPS DEC 15   0   UTC Time Stamp in Short Form (YYYYMMDDhhmmss)  
166 MWART MWART MWART CHAR 1   0   Tax Type  
167 .INCLUDE       0   0   BW Fields for LI Extractor: New General Ledger Accounting  
168 MANDT MANDT MANDT CLNT 3   0   Client *
169 UPMOD RODMUPDMOD RODMUPDMOD CHAR 1   0   BW Delta Process: Record Mode  
170 RRCTY RRCTY RRCTY CHAR 1   0   Record Type  
171 RVERS RVERS RVERS CHAR 3   0   Version *
172 FISCVAR RSFISCVAR RSFISCVAR CHAR 2   0   Fiscal year variant  
173 FISCPER RSFISCPER RSFISCPER NUMC 7   0   Fiscal year / period  
174 RFISCVAR RSFISCVAR RSFISCVAR CHAR 2   0   Fiscal year variant  
175 RFISCPER RSFISCPER RSFISCPER NUMC 7   0   Fiscal year / period  
176 KTOPL KTOPL KTOPL CHAR 4   0   Chart of Accounts *
177 PS_POSID PS_POSID PS_POSID CHAR 24   0   Work Breakdown Structure Element (WBS Element)  
178 CURT2 CURT2 CURTP CHAR 2   0   Currency Type of Second Local Currency  
179 CURT3 CURT3 CURTP CHAR 2   0   Currency Type of Third Local Currency  
180 DMHAB DMHAB WERT7 CURR 13   2   Credit Amount in Local Currency  
181 DMHA2 DMHA2 WERT7 CURR 13   2   Credit Amount in Second Local Currency  
182 DMHA3 DMHA3 WERT7 CURR 13   2   Credit Amount in Third Local Currency  
183 DMSOL DMSOL WERT7 CURR 13   2   Debit Amount in Local Currency  
184 DMSO2 DMSO2 WERT7 CURR 13   2   Debit Amount in Second Local Currency  
185 DMSO3 DMSO3 WERT7 CURR 13   2   Debit Amount in Third Local Currency  
186 DMSH2 DMSH2 WRTV7 CURR 13   2   Amount in Second Local Currency with +/- Sign  
187 DMSH3 DMSH3 WRTV7 CURR 13   2   Amount in Third Local Currency with +/- Sign  
188 WRHAB WRHAB WERT7 CURR 13   2   Credit Amount in Document Currency  
189 WRSOL WRSOL WERT7 CURR 13   2   Debit Amount in Document Currency  
190 PCGRP FAGL_SREP_PCGRP GRPNAME CHAR 15   0   Profit Center Group  
191 AUGST AUGST_SREP AUGST_SREP CHAR 1   0   Clearing Status of Line Item  
192 ALLGSTID ALLGSTID DATUM DATS 8   0   Open Items at Key Date  
193 BSTAT_S BSTAT_D_SREP BSTAT_SREP CHAR 1   0   Document Status  
194 BWSHB BWSHB_SREP WRTV7 CURR 13   2   Valuated Amount in Local Currency with Sign  
195 BWSH2 BWSH2_SREP WRTV7 CURR 13   2   Valuated Amount in Second Local Currency with Sign  
196 BWSH3 BWSH3_SREP WRTV7 CURR 13   2   Valuated Amount in Third Local Currency with Sign  
197 USNAM USNAM XUBNAME CHAR 12   0   User name *
198 STBLG STBLG BELNR CHAR 10   0   Reverse Document Number  
199 STJAH STJAH GJAHR NUMC 4   0   Reverse document fiscal year  
200 BKTXT BKTXT TEXT25 CHAR 25   0   Document Header Text  
201 KOTXT KOTXT_SREP TEXT50 CHAR 50   0   Account Name  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 FAGL_S_SREP_LINE_ITEMS AWSYS TBDLS LOGSYS    
2 FAGL_S_SREP_LINE_ITEMS AWTYP TTYP AWTYP    
3 FAGL_S_SREP_LINE_ITEMS BEWAR T856 TRTYP    
4 FAGL_S_SREP_LINE_ITEMS BLART T003 BLART    
5 FAGL_S_SREP_LINE_ITEMS BSCHL TBSL BSCHL    
6 FAGL_S_SREP_LINE_ITEMS BUKRS T001 BUKRS KEY 1 CN
7 FAGL_S_SREP_LINE_ITEMS CESSION_KZ TCESSION CESSION_KZ    
8 FAGL_S_SREP_LINE_ITEMS FKBER_LONG TFKB FKBER    
9 FAGL_S_SREP_LINE_ITEMS GSBER TGSB GSBER    
10 FAGL_S_SREP_LINE_ITEMS HWAER TCURC WAERS    
11 FAGL_S_SREP_LINE_ITEMS KKBER T014 KKBER REF 1 CN
12 FAGL_S_SREP_LINE_ITEMS KOKRS TKA01 KOKRS    
13 FAGL_S_SREP_LINE_ITEMS KOSTL CSKS KOSTL    
14 FAGL_S_SREP_LINE_ITEMS KSTAR CSKB KSTAR    
15 FAGL_S_SREP_LINE_ITEMS KUNNR KNA1 KUNNR    
16 FAGL_S_SREP_LINE_ITEMS LIFNR LFA1 LIFNR    
17 FAGL_S_SREP_LINE_ITEMS MABER T047M MABER    
18 FAGL_S_SREP_LINE_ITEMS MANSP T040S MANSP    
19 FAGL_S_SREP_LINE_ITEMS MEINS T006 MSEHI    
20 FAGL_S_SREP_LINE_ITEMS MSCHL T040 MSCHL    
21 FAGL_S_SREP_LINE_ITEMS PARGB TGSB GSBER    
22 FAGL_S_SREP_LINE_ITEMS PFKBER TFKB FKBER    
23 FAGL_S_SREP_LINE_ITEMS PKOSTL CSKS KOSTL    
24 FAGL_S_SREP_LINE_ITEMS PPRCT CEPC PRCTR    
25 FAGL_S_SREP_LINE_ITEMS PRCTR CEPC PRCTR    
26 FAGL_S_SREP_LINE_ITEMS PSEGMENT FAGL_SEGM SEGMENT    
27 FAGL_S_SREP_LINE_ITEMS PSWSL TCURC WAERS    
28 FAGL_S_SREP_LINE_ITEMS RLDNR V_FAGL_T881_DBAL RLDNR    
29 FAGL_S_SREP_LINE_ITEMS RSTGR T053R RSTGR    
30 FAGL_S_SREP_LINE_ITEMS SAKNR SKB1 SAKNR    
31 FAGL_S_SREP_LINE_ITEMS SEGMENT FAGL_SEGM SEGMENT    
32 FAGL_S_SREP_LINE_ITEMS UMSKZ T074U UMSKZ REF C CN
33 FAGL_S_SREP_LINE_ITEMS VBUND T880 RCOMP    
34 FAGL_S_SREP_LINE_ITEMS WAERS TCURC WAERS    
35 FAGL_S_SREP_LINE_ITEMS WERKS T001W WERKS    
36 FAGL_S_SREP_LINE_ITEMS ZLSCH T042Z ZLSCH    
37 FAGL_S_SREP_LINE_ITEMS ZLSPR T008 ZAHLS    
History
Last changed by/on SAP  20130529 
SAP Release Created in 603