SAP ABAP Table FPIA_S_IOA (Data transfer: Line Item documents)

Hierarchy

☛ SAP_FIN (Software Component) SAP_FIN
   ⤷ FI-LOC (Application Component) Localization
     ⤷ FPS_IOA_BI_FR (Package) Interest on Arreas France - BI reporting

Basic Data

Table Category	INTTAB	Structure
Structure	FPIA_S_IOA	Table Relationship Diagram
Short Description	Data transfer: Line Item documents

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	CLIENT	☐	MANDT	MANDT	CLNT	3	0	Client	*
2	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
3	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	*
4	FISCPER	☐	RSFISCPER	RSFISCPER	NUMC	7	0	Fiscal year / period
5	BELNR_FI	☐	BELNR_BIW	BELNR	CHAR	10	0	Accounting Document Number
6	BUZEI_FI	☐	BUZEI	BUZEI	NUMC	3	0	Number of Line Item Within Accounting Document
7	UPOSZ	☐	UPOSZ	SPOSN	CHAR	4	0	Subitem Number
8	LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	*
9	KKBER	☐	KKBER	KKBER	CHAR	4	0	Credit control area	*
10	KOART	☐	KOART	KOART	CHAR	1	0	Account type
11	UMSKZ	☐	UMSKZ	UMSKZ	CHAR	1	0	Special G/L Indicator	*
12	BLART	☐	BLART	BLART	CHAR	2	0	Document type	*
13	BSCHL	☐	BSCHL	BSCHL	CHAR	2	0	Posting Key	*
14	FISCVAR	☐	RSFISCVAR	RSFISCVAR	CHAR	2	0	Fiscal year variant
15	BLDAT	☐	BLDAT	DATUM	DATS	8	0	Document Date in Document
16	BUDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
17	CPUDT	☐	CPUDT	DATUM	DATS	8	0	Accounting document entry date
18	AUGDT	☐	AUGDT	DATUM	DATS	8	0	Clearing Date
19	NETDT	☐	NETDT	DATUM	DATS	8	0	Due Date for Net Payment
20	SK1DT	☐	SK1DT	DATUM	DATS	8	0	Due Date for Cash Discount 1
21	SK2DT	☐	SK2DT	DATUM	DATS	8	0	Due Date for Cash Discount 2
22	ZFBDT	☐	DZFBDT	DATUM	DATS	8	0	Baseline date for due date calculation
23	ZBD1T	☐	DZBD1T	ZBDXT	DEC	3	0	Cash discount days 1
24	ZBD2T	☐	DZBD2T	ZBDXT	DEC	3	0	Cash discount days 2
25	ZBD3T	☐	DZBD3T	ZBDXT	DEC	3	0	Net Payment Terms Period
26	ZBD1P	☐	DZBD1P	PRZ23	DEC	5	3	Cash discount percentage 1
27	ZBD2P	☐	DZBD2P	PRZ23	DEC	5	3	Cash Discount Percentage 2
28	LAND1	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
29	ZLSCH	☐	DZLSCH	ZLSCH	CHAR	1	0	Payment method	*
30	ZTERM	☐	DZTERM	ZTERM	CHAR	4	0	Terms of payment key
31	ZLSPR	☐	DZLSPR	ZAHLS	CHAR	1	0	Payment Block Key	*
32	RSTGR	☐	RSTGR	RSTGR	CHAR	3	0	Reason Code for Payments	*
33	LCURR	☐	LCURR	WAERS	CUKY	5	0	Currency key of the local currency	*
34	DMSOL	☐	DMSOL	WERT7	CURR	13	2	Debit Amount in Local Currency
35	DMHAB	☐	DMHAB	WERT7	CURR	13	2	Credit Amount in Local Currency
36	DMSHB	☐	DMSHB	WRTV7	CURR	13	2	Amount in Local Currency with +/- Signs
37	SKNTO	☐	SKNTO	WERT7	CURR	13	2	Cash discount amount in local currency
38	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
39	KTOPL	☐	KTOPL	KTOPL	CHAR	4	0	Chart of Accounts	*
40	HKONT	☐	HKONT	SAKNR	CHAR	10	0	General Ledger Account	*
41	SAKNR	☐	SAKNR	SAKNR	CHAR	10	0	G/L Account Number	*
42	FILKD	☐	FILKD	MAXKK	CHAR	10	0	Account Number of the Branch
43	AUGBL	☐	AUGBL	BELNR	CHAR	10	0	Document Number of the Clearing Document
44	XBLNR	☐	XBLNR	XBLNR	CHAR	16	0	Reference Document Number
45	BELNR_MM	☐	RE_BELNR	BELNR	CHAR	10	0	Document Number of an Invoice Document
46	BUZEI_MM	☐	RBLGP	NUMC6	NUMC	6	0	Document Item in Invoice Document
47	BUDAT_MM	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
48	REBZG	☐	REBZG	BELNR	CHAR	10	0	Number of the Invoice the Transaction Belongs to
49	REBZJ	☐	REBZJ	GJAHR	NUMC	4	0	Fiscal Year of the Relevant Invoice (for Credit Memo)
50	REBZZ	☐	REBZZ	BUZEI	NUMC	3	0	Line Item in the Relevant Invoice
51	VBELN	☐	VBELN	VBELN	CHAR	10	0	Sales and Distribution Document Number	*
52	XREF1	☐	XREF1	CHAR12	CHAR	12	0	Business partner reference key
53	XREF2	☐	XREF2	CHAR12	CHAR	12	0	Business partner reference key
54	XREF3	☐	XREF3	CHAR20	CHAR	20	0	Reference key for line item
55	SGTXT	☐	SGTXT	TEXT50	CHAR	50	0	Item Text
56	XNEGP	☐	XNEGP	XFELD	CHAR	1	0	Indicator: Negative posting
57	UMSKS	☐	UMSKS	UMSKS	CHAR	1	0	Special G/L Transaction Type
58	ZUONR	☐	DZUONR_AO	ZUONR	CHAR	18	0	Assignment number
59	.INCLUDE	☐				0	0
60	FIPOS	☐	FIPOS	FIPOS	CHAR	14	0	Commitment Item	*
61	MEASURE	☐	FM_MEASURE	FM_MEASURE	CHAR	24	0	Funded Program	*
62	FISTL	☐	FISTL	FISTL	CHAR	16	0	Funds Center	*
63	FIKRS	☐	FIKRS	FIKRS	CHAR	4	0	Financial Management Area	*
64	ANLN1	☐	ANLN1	ANLN1	CHAR	12	0	Main Asset Number	*
65	ANLN2	☐	ANLN2	ANLN2	CHAR	4	0	Asset Subnumber	*
66	AWTYP	☐	AWTYP	AWTYP	CHAR	5	0	Reference procedure	*
67	AWKEY	☐	AWKEY	AWKEY	CHAR	20	0	Object key
68	DMBTR	☐	DMBTR	WERT7	CURR	13	2	Amount in local currency
69	GJAHR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
70	HWAE2	☐	HWAE2	WAERS	CUKY	5	0	Currency Key of Second Local Currency	*
71	HWAE3	☐	HWAE3	WAERS	CUKY	5	0	Currency Key of Third Local Currency	*
72	MONAT	☐	MONAT	MONAT	NUMC	2	0	Fiscal period
73	PROJK	☐	PS_PSP_PNR	PS_POSNR	NUMC	8	0	Work Breakdown Structure Element (WBS Element)	*
74	SHKZG	☐	SHKZG	SHKZG	CHAR	1	0	Debit/Credit Indicator
75	WRBTR	☐	WRBTR	WERT7	CURR	13	2	Amount in document currency
76	REINDAT	☐	REINDAT	DATUM	DATS	8	0	Invoice Receipt Date
77	GEBER	☐	BP_GEBER	BP_GEBER	CHAR	10	0	Fund	*
78	FPIA_DTYPE	☐	FPIA_DTYPE	FPIA_DOCTYPE	CHAR	1	0	Document Type
79	WSKTO	☐	WSKTO	WERT7	CURR	13	2	Cash Discount Amount in Document Currency
80	FPIA_DOCN	☐	RE_BELNR	BELNR	CHAR	10	0	Document Number of an Invoice Document
81	FPIA_LITM	☐	BUZEI	BUZEI	NUMC	3	0	Number of Line Item Within Accounting Document
82	WRSOL	☐	WRSOL	WERT7	CURR	13	2	Debit Amount in Document Currency
83	WRSHB	☐	WRSHB	WRTV7	CURR	13	2	Foreign Currency Amount with Signs (+/-)
84	WRHAB	☐	WRHAB	WERT7	CURR	13	2	Credit Amount in Document Currency
85	DMSO2	☐	DMSO2	WERT7	CURR	13	2	Debit Amount in Second Local Currency
86	DMSO3	☐	DMSO3	WERT7	CURR	13	2	Debit Amount in Third Local Currency
87	DMSH2	☐	DMSH2	WRTV7	CURR	13	2	Amount in Second Local Currency with +/- Sign
88	DMHA2	☐	DMHA2	WERT7	CURR	13	2	Credit Amount in Second Local Currency
89	DMHA3	☐	DMHA3	WERT7	CURR	13	2	Credit Amount in Third Local Currency
90	DMSH3	☐	DMSH3	WRTV7	CURR	13	2	Amount in Third Local Currency with +/- Sign
91	DMBE2	☐	DMBE2	WERT7	CURR	13	2	Amount in Second Local Currency
92	DMBE3	☐	DMBE3	WERT7	CURR	13	2	Amount in Third Local Currency
93	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
94	AETIM	☐	FPIA_AETIM	CHAR04	CHAR	4	0	Uhrzeit der letzten Änderung
95	BSTA1	☐	BSTAS	CHAR1	CHAR	1	0	Requirements status key
96	BSTA2	☐	BSTAS	CHAR1	CHAR	1	0	Requirements status key
97	BSTA3	☐	BSTAS	CHAR1	CHAR	1	0	Requirements status key
98	LINE_TYPE	☐	FPIA_LINETYPE	FPIA_LINETYPE	CHAR	2	0	Line type of FI-documents

History

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