SAP ABAP Table FAGLPOSA (Basic Data for Line Items: 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	FAGLPOSA	Table Relationship Diagram
Short Description	Basic Data for Line Items: 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	ANLN1	☐	ANLN1	ANLN1	CHAR	12	0	Main Asset Number	*
2	ANLN2	☐	ANLN2_4	ANLN2_4	CHAR	4	0	New asset subnumber, 4 characters
3	AUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	*
4	AUGBL	☐	AUGBL	BELNR	CHAR	10	0	Document Number of the Clearing Document
5	AUGDT	☐	AUGDT	DATUM	DATS	8	0	Clearing Date
6	BELNR	☐	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
7	BLART	☐	BLART	BLART	CHAR	2	0	Document type	T003
8	BLDAT	☐	BLDAT	DATUM	DATS	8	0	Document Date in Document
9	BSCHL	☐	BSCHL	BSCHL	CHAR	2	0	Posting Key	TBSL
10	BSTAT	☐	BSTAT_D	BSTAT	CHAR	1	0	Document Status
11	BUDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
12	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
13	BUZEI	☐	BUZEI	BUZEI	NUMC	3	0	Number of Line Item Within Accounting Document
14	BWWRT	☐	BWWRT_X8	WRTV8	CURR	15	2	Valuated Amount in Local Currency
15	BWWR2	☐	BWWR2_X8	WRTV8	CURR	15	2	Amount Valuated in Local Currency 2
16	BWWR3	☐	BWWR3_X8	WRTV8	CURR	15	2	Amount Valuated in Local Currency 3
17	DMSHB	☐	DMSHB_X8	WRTV8	CURR	15	2	Amount in Local Currency with +/- Signs
18	HWAER	☐	HWAER	WAERS	CUKY	5	0	Local Currency	TCURC
19	DMBE2	☐	DMBE2_X8	WRTV8	CURR	15	2	Amount in Second Local Currency
20	HWAE2	☐	HWAE2	WAERS	CUKY	5	0	Currency Key of Second Local Currency	*
21	DMBE3	☐	DMBE3_X8	WRTV8	CURR	15	2	Amount in Third Local Currency
22	HWAE3	☐	HWAE3	WAERS	CUKY	5	0	Currency Key of Third Local Currency	*
23	EBELN	☐	EBELN	EBELN	CHAR	10	0	Purchasing Document Number	*
24	EBELP	☐	EBELP	EBELP	NUMC	5	0	Item Number of Purchasing Document	*
25	ETEN2	☐	ETENR	ETENR	NUMC	4	0	Schedule line	*
26	FAEDT	☐	FAEDT_FPOS	DATUM	DATS	8	0	Net Due Date
27	FILKD	☐	FILKD	MAXKK	CHAR	10	0	Account Number of the Branch
28	GJAHR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
29	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
30	JAMON	☐	JAMON_XPO	JAMON_XPO	CHAR	7	0	Fiscal Year/Posting Period from Posting Date
31	KOART	☐	KOART	KOART	CHAR	1	0	Account type
32	KONTO	☐	KTONR_AV	KTONR	CHAR	10	0	Account Number
33	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	CSKS
34	MABER	☐	MABER	MABER	CHAR	2	0	Dunning Area	T047M
35	MADAT	☐	MADAT	DATUM	DATS	8	0	Date of Last Dunning Notice
36	MANSP	☐	MANSP	MANSP	CHAR	1	0	Dunning block	T040S
37	MANST	☐	MAHNS_D	MAHNS	NUMC	1	0	Dunning Level
38	MONAT	☐	MONAT	MONAT	NUMC	2	0	Fiscal period
39	MSCHL	☐	MSCHL	MSCHL	CHAR	1	0	Dunning key	T040
40	MWSKZ	☐	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code	*
41	POSN2	☐	POSNR_VA	POSNR	NUMC	6	0	Sales Document Item	*
42	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	CEPC
43	QBSHB	☐	QBSHB_X8	WRTV8	CURR	15	2	Withholding Tax Amount in Document Currency
44	QSFBT	☐	QSFBT_X8	WRTV8	CURR	15	2	Withholding Tax Exempt Amount in Document Currency
45	QSSHB	☐	QSSHB_X8	WRTV8	CURR	15	2	Withholding Tax Base Amount in Document Currency
46	REBZG	☐	REBZG	BELNR	CHAR	10	0	Number of the Invoice the Transaction Belongs to
47	SAMNR	☐	SAMNR	SAMNR	NUMC	8	0	Invoice List Number
48	SGTXT	☐	SGTXT	TEXT50	CHAR	50	0	Item Text
49	SHKZG	☐	SHKZG	SHKZG	CHAR	1	0	Debit/Credit Indicator
50	SKFBT	☐	SKFBT_X8	WRTV8	CURR	15	2	Amount Eligible for Cash Discount in Document Currency
51	WSKTO	☐	WSKTO_X8	WRTV8	CURR	15	2	Cash Discount Amount in Document Currency
52	SKNTO	☐	SKNTO_X8	WRTV8	CURR	15	2	Cash Discount Amount in Local Currency
53	STAKZ	☐	XSTKZ	XFELD	CHAR	1	0	Indicator: Statistical document ?
54	UMSKS	☐	UMSKS	UMSKS	CHAR	1	0	Special G/L Transaction Type
55	UMSKZ	☐	UMSKZ	UMSKZ	CHAR	1	0	Special G/L Indicator	T074U
56	UZAWE	☐	UZAWE	UZAWE	CHAR	2	0	Payment method supplement	*
57	VALUT	☐	VALUT	DATUM	DATS	8	0	Fixed Value Date
58	VBEL2	☐	VBELN_VA	VBELN	CHAR	10	0	Sales Document	*
59	VBELN	☐	VBELN_VF	VBELN	CHAR	10	0	Billing document	*
60	VBEWA	☐	SBEWART	SBEWART	CHAR	4	0	Flow Type	*
61	VBUND	☐	RASSC	RCOMP	CHAR	6	0	Company ID of trading partner	T880
62	VERTN	☐	RANL	RANL	CHAR	13	0	Contract Number
63	VERTT	☐	RANTYP	RANTYP	CHAR	1	0	Contract Type
64	VERZ1	☐	VERZ1	WRTV3	DEC	5	0	Days in Arrears for Cash Discount Terms 1
65	VERZN	☐	VERZN	WRTV3	DEC	5	0	Days in Arrears by Net Due Date
66	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
67	WRSHB	☐	WRSHB_X8	WRTV8	CURR	15	2	Amount in Document Currency (Foreign Currency)
68	WAERS	☐	WAER_DOC	WAERS	CUKY	5	0	Document Currency (Key)	TCURC
69	WVERW	☐	WVERW	WVERW	CHAR	1	0	Bill of Exchange Usage Type
70	XBLNR	☐	XBLNR1	XBLNR1	CHAR	16	0	Reference Document Number
71	XSTRP	☐	XSTRP	XFELD	CHAR	1	0	Indicator: Disputed item?
72	XZAHL	☐	XZAHL	XFELD	CHAR	1	0	Indicator: Is Posting Key Used in a Payment Transaction?
73	ZALDT	☐	DZALDT	DATUM	DATS	8	0	Probable Payment Date (Cash Discount 1 Due)
74	ZBD1P	☐	DZBD1P	PRZ23	DEC	5	3	Cash discount percentage 1
75	ZBD1T	☐	DZBD1T	ZBDXT	DEC	3	0	Cash discount days 1
76	ZBD2P	☐	DZBD2P	PRZ23	DEC	5	3	Cash Discount Percentage 2
77	ZBD2T	☐	DZBD2T	ZBDXT	DEC	3	0	Cash discount days 2
78	ZBD3T	☐	DZBD3T	ZBDXT	DEC	3	0	Net Payment Terms Period
79	ZFBDT	☐	DZFBDT	DATUM	DATS	8	0	Baseline date for due date calculation
80	ZINSZ	☐	DZINSZ	WRTV8	CURR	15	2	Interest Calculation Numerator (Days in Arrears * Amount)
81	ZLSCH	☐	DZLSCH	ZLSCH	CHAR	1	0	Payment method	T042Z
82	ZLSPR	☐	DZLSPR	ZAHLS	CHAR	1	0	Payment Block Key	T008
83	ZTERM	☐	DZTERM	ZTERM	CHAR	4	0	Terms of payment key
84	ZUONR	☐	DZUONR	ZUONR	CHAR	18	0	Assignment number
85	XREF1	☐	XREF1	CHAR12	CHAR	12	0	Business partner reference key
86	XREF2	☐	XREF2	CHAR12	CHAR	12	0	Business partner reference key
87	XARCH	☐	XARCH	XFELD	CHAR	1	0	Indicator: Document already archived ?
88	RSTGR	☐	RSTGR	RSTGR	CHAR	3	0	Reason Code for Payments	T053R
89	ASKTO	☐	ASKTO_X8	WRTV8	CURR	15	2	Current Cash Discount Amount in Document Currency
90	KURSE	☐	KURSE	KURSF	DEC	9	5	Effective Exchange Rate in the Line Item
91	REBZT	☐	REBZT	REBZT	CHAR	1	0	Follow-On Document Type
92	PSWSL	☐	PSWSL	WAERS	CUKY	5	0	Update Currency for General Ledger Transaction Figures	TCURC
93	PSWBT	☐	PSWBT_X8	WERT8	CURR	15	2	Amount for General Ledger Update (Absolute)
94	HKONT	☐	HKONT	SAKNR	CHAR	10	0	General Ledger Account	*
95	XNEGP	☐	XNEGP	XFELD	CHAR	1	0	Indicator: Negative posting
96	ZBFIX	☐	DZBFIX	ZBFIX	CHAR	1	0	Fixed Payment Terms
97	RFZEI	☐	RFZEI_CC	NUM03	NUMC	3	0	Payment Card Item
98	CCBTC	☐	CCBTC	CCBTC	CHAR	10	0	Payment cards: Settlement run
99	KKBER	☐	KKBER	KKBER	CHAR	4	0	Credit control area	T014
100	XREF3	☐	XREF3	CHAR20	CHAR	20	0	Reference key for line item
101	DTWS1	☐	DTAT16	DTWSX	NUMC	2	0	Instruction key 1	*
102	DTWS2	☐	DTAT17	DTWSX	NUMC	2	0	Instruction key 2	*
103	DTWS3	☐	DTAT18	DTWSX	NUMC	2	0	Instruction key 3	*
104	DTWS4	☐	DTAT19	DTWSX	NUMC	2	0	Instruction key 4	*
105	ABSBT	☐	ABSBT_X8	WERT8	CURR	15	2	Credit Management: Hedged Amount (Absolute)
106	KKBWR	☐	KKBWR	WAERS	CUKY	5	0	Currency of Credit Control Area	*
107	PROJK	☐	PROJK_EXT	CHAR24	CHAR	24	0	Individual Structural Element (WBS Element) in Ext. Format
108	XPYPR	☐	XPYPR	XFELD	CHAR	1	0	Indicator: Items from Payment Program Blocked
109	KIDNO	☐	KIDNO	CHAR30	CHAR	30	0	Payment Reference
110	XAUGP	☐	XAUGP	XFELD	CHAR	1	0	Indicator: Item has been cleared?
111	BUPLA	☐	BUPLA	J_1BBRANCH	CHAR	4	0	Business Place	*
112	SECCO	☐	SECCO	SECCO	CHAR	4	0	Section Code	*
113	GKART	☐	GKART	GKART	CHAR	1	0	Offsetting Account Type
114	GKONT	☐	GKONT	GKONT	CHAR	10	0	Offsetting Account Number
115	PYCUR	☐	PYCUR	WAERS	CUKY	5	0	Currency for Automatic Payment	*
116	PYAMT	☐	PYAMT_X8	WERT8	CURR	15	2	Amount in Automatic Payment Currency (Absolute)
117	PYORD	☐	PYORD	PYORD	CHAR	10	0	Payment Order
118	XRAGL	☐	XRAGL	XFELD	CHAR	1	0	Indicator: Clearing was Reversed
119	CESSION_KZ	☐	CESSION_KZ	CESSION_KZ	CHAR	2	0	Accounts Receivable Pledging Indicator	TCESSION
120	BUZID	☐	BUZID	CHAR1	CHAR	1	0	Identification of the Line Item
121	AUGGJ	☐	AUGGJ	GJAHR	NUMC	4	0	Fiscal Year of Clearing Document
122	AGZEI	☐	AGZEI	AGZEI	DEC	5	0	Clearing Item
123	LONGNUM	☐	/SAPPSPRO/LONGNUM	/SAPPSPRO/LONGNUM	CHAR	40	0	Smart Number

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	FAGLPOSA	BLART	T003	BLART
2	FAGLPOSA	BSCHL	TBSL	BSCHL
3	FAGLPOSA	BUKRS	T001	BUKRS	KEY	1	CN
4	FAGLPOSA	CESSION_KZ	TCESSION	CESSION_KZ
5	FAGLPOSA	GSBER	TGSB	GSBER
6	FAGLPOSA	HWAER	TCURC	WAERS
7	FAGLPOSA	KKBER	T014	KKBER	REF	1	CN
8	FAGLPOSA	KOSTL	CSKS	KOSTL
9	FAGLPOSA	MABER	T047M	MABER
10	FAGLPOSA	MANSP	T040S	MANSP
11	FAGLPOSA	MSCHL	T040	MSCHL
12	FAGLPOSA	PRCTR	CEPC	PRCTR
13	FAGLPOSA	PSWSL	TCURC	WAERS
14	FAGLPOSA	RSTGR	T053R	RSTGR
15	FAGLPOSA	UMSKZ	T074U	UMSKZ	REF	C	CN
16	FAGLPOSA	VBUND	T880	RCOMP
17	FAGLPOSA	WAERS	TCURC	WAERS
18	FAGLPOSA	WERKS	T001W	WERKS
19	FAGLPOSA	ZLSCH	T042Z	ZLSCH
20	FAGLPOSA	ZLSPR	T008	ZAHLS

History

Last changed by/on	SAP	20130529
SAP Release Created in	600