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