SAP ABAP Table IFMEPAO (Reporting: Structure for Request Documents)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ FI-FM-IS (Application Component) Information System
     ⤷ FMRP (Package) ISPS reporting

Basic Data

Table Category	INTTAB	Structure
Structure	IFMEPAO	Table Relationship Diagram
Short Description	Reporting: Structure for Request 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	.INCLUDE	☐				0	0	Document Header for Document Parking
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	*
3	AUSBK	☐	AUSBK	BUKRS	CHAR	4	0	Source Company Code	*
4	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
5	BELNR	☐	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
6	GJAHR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
7	BSTAT	☐	BSTAT_D	BSTAT	CHAR	1	0	Document Status
8	BLART	☐	BLART	BLART	CHAR	2	0	Document type	T003
9	BLDAT	☐	BLDAT	DATUM	DATS	8	0	Document Date in Document
10	BUDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
11	MONAT	☐	MONAT	MONAT	NUMC	2	0	Fiscal period
12	WWERT	☐	WWERT_D	DATUM	DATS	8	0	Translation date
13	CPUDT	☐	CPUDT	DATUM	DATS	8	0	Accounting document entry date
14	CPUTM	☐	CPUTM	UZEIT	TIMS	6	0	Time of data entry
15	AEDAT	☐	AEDT_VBKPF	DATUM	DATS	8	0	Date of the Last Document Change
16	UPDDT	☐	UPDDT	DATUM	DATS	8	0	Date of the Last Document Update
17	USNAM	☐	USNM_VBKPF	USNAM	CHAR	12	0	User Name
18	TCODE	☐	TCODE	TCODE	CHAR	20	0	Transaction Code	*
19	BVORG	☐	BVORG	BVORG	CHAR	16	0	Number of Cross-Company Code Posting Transaction
20	XBLNR	☐	XBLNR1	XBLNR1	CHAR	16	0	Reference Document Number
21	BKTXT	☐	BKTXT	TEXT25	CHAR	25	0	Document Header Text
22	FIKRS	☐	FIKRS	FIKRS	CHAR	4	0	Financial Management Area	*
23	KOARS	☐	KOARS_003	CHAR5	CHAR	5	0	Account Types Allowed
24	XBSET	☐	XBSET	XFELD	CHAR	1	0	Tax information exists in the document
25	XSNET	☐	XSNET	XFELD	CHAR	1	0	G/L account amounts entered exclude tax
26	XBWAE	☐	XBWAE	XFELD	CHAR	1	0	Only transfer document in document currency when posting
27	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
28	HWAER	☐	HWAER	WAERS	CUKY	5	0	Local Currency	*
29	HWAE2	☐	HWAE2	WAERS	CUKY	5	0	Currency Key of Second Local Currency	*
30	HWAE3	☐	HWAE3	WAERS	CUKY	5	0	Currency Key of Third Local Currency	*
31	KURSF	☐	KURSF	KURSF	DEC	9	5	Exchange rate
32	KURS2	☐	KURS2	KURSF	DEC	9	5	Exchange Rate for the Second Local Currency
33	KURS3	☐	KURS3	KURSF	DEC	9	5	Exchange Rate for the Third Local Currency
34	BASW2	☐	CURSR	CURSR	CHAR	1	0	Source Currency for Currency Translation
35	BASW3	☐	CURSR	CURSR	CHAR	1	0	Source Currency for Currency Translation
36	UMRD2	☐	UMRD2	CURDT	CHAR	1	0	Translation Date Type for Second Local Currency
37	UMRD3	☐	UMRD3	CURDT	CHAR	1	0	Translation Date Type for Third Local Currency
38	CURT2	☐	CURT2	CURTP	CHAR	2	0	Currency Type of Second Local Currency
39	CURT3	☐	CURT3	CURTP	CHAR	2	0	Currency Type of Third Local Currency
40	KUTY2	☐	KURST	KURST	CHAR	4	0	Exchange Rate Type	*
41	KUTY3	☐	KURST	KURST	CHAR	4	0	Exchange Rate Type	*
42	XMWST	☐	XMWST	XFELD	CHAR	1	0	Calculate tax automatically
43	PARGB	☐	PGBVW	GSBER	CHAR	4	0	Partner Business Area Default Value	TGSB
44	VBLNR	☐	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
45	VGJHR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
46	XFRGE	☐	XFRGE	XFELD	CHAR	1	0	Released
47	XPRFG	☐	XPRFG	XFELD	CHAR	1	0	Document complete
48	FRATH	☐	FRATH	WERT7	CURR	13	2	Unplanned Delivery Costs
49	XWFFR	☐	XWFFR	XFELD	CHAR	1	0	Release necessary
50	LOTKZ	☐	PSO_LOTKZ	LOTKZ	CHAR	10	0	Lot Number for Requests
51	FRWEG	☐	FRWEG	FRWEG	CHAR	4	0	Release Approv. Path	VBWF03
52	UPDTM	☐	CPUTM	UZEIT	TIMS	6	0	Time of data entry
53	RELDT	☐	CPUDT	DATUM	DATS	8	0	Accounting document entry date
54	RELTM	☐	CPUTM	UZEIT	TIMS	6	0	Time of data entry
55	VBUND	☐	RASSC	RCOMP	CHAR	6	0	Company ID of trading partner	*
56	SUBN1_LVL	☐	SUBN1_LVL	NUM02	NUMC	2	0	Amount Release Approval Levels
57	BRNCH	☐	J_1ABRNCH	J_1BBRANCH	CHAR	4	0	Branch number	J_1BBRANCH
58	NUMPG	☐	J_1ANOPG	J_1ANOPG	NUMC	3	0	Number of pages of invoice
59	USCMP	☐	USCMP	USNAM	CHAR	12	0	Completed By
60	USREL	☐	USREL	USNAM	CHAR	12	0	Released By
61	USUPD	☐	USUPD	USNAM	CHAR	12	0	Changed By
62	XINVR_CURV	☐	XINVR_CURV	XFELD	CHAR	1	0	Indicator: Calculation allowed with inverted exchange rate ?
63	AWTYP	☐	AWTYP	AWTYP	CHAR	5	0	Reference procedure	*
64	AWKEY	☐	AWKEY	AWKEY	CHAR	20	0	Object key
65	AWSYS	☐	LOGSYSTEM	LOGSYS	CHAR	10	0	Logical System	*
66	REINDAT	☐	REINDAT	DATUM	DATS	8	0	Invoice Receipt Date
67	TXKRS	☐	TXKRS_BKPF	KURSF	DEC	9	5	Exchange Rate for Taxes
68	PROPMANO	☐	RE_MANDAT	RE_MANDAT	CHAR	13	0	Real Estate Management Mandate
69	LDGRP	☐	FAGL_LDGRP	FAGL_LDGRP	CHAR	4	0	Ledger Group	*
70	VATDATE	☐	VATDATE	DATUM	DATS	8	0	Tax Reporting Date
71	KURSX	☐	GLE_FXR_DTE_RATEX28	GLE_FXR_RATEX28	DEC	28	14	Market Data Exchange Rate
72	KUR2X	☐	GLE_FXR_DTE_RATE2X28	GLE_FXR_RATEX28	DEC	28	14	Market Data Exchange Rate 2
73	KUR3X	☐	GLE_FXR_DTE_RATE3X28	GLE_FXR_RATEX28	DEC	28	14	Market Data Exchange Rate 3
74	XMCA	☐	GLE_DTE_MCA_XMCA	XFELD	CHAR	1	0	Document Originates from Multi Currency Accounting
75	.INCLU--AP	☐				0	0	US federal
76	EXCLUDE_FLAG	☐	EXCLUDE_FLG	XFELD	CHAR	1	0	PPA Exclude Indicator
77	.INCLU--AP	☐				0	0	IS-PS: Append Structure VBKPF for Payment Requests
78	.INCLUDE	☐				0	0	IS-PS: Include for Append Parked Payment Request Doc.Header
79	PSOTY	☐	PSOTY_D	PSOTY	CHAR	2	0	Document category payment requests	PSOTP
80	PSOAK	☐	PSOAK	PSOAK	CHAR	10	0	Reason	PSO12
81	PSOKS	☐	PSOKS	PSOKS	CHAR	10	0	Region	*
82	PSOSG	☐	PSOSG	PSOSG	CHAR	1	0	Reason for reversal - IS-PS requests
83	PSOFN	☐	PSOFN	CHAR30	CHAR	30	0	IS-PS: File number
84	INTFORM	☐	FM_INTFORM	CHAR4	CHAR	4	0	Interest Formula
85	INTDATE	☐	FM_INTDATE	DATUM	DATS	8	0	Interest Calc. Date
86	PSODT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
87	PSOTM	☐	PSOTM	UZEIT	TIMS	6	0	Last changed at
88	DBBLG	☐	DBBLG	BELNR	CHAR	10	0	Recurring Entry Document Number
89	STGRD	☐	STGRD	STGRD	CHAR	2	0	Reason for Reversal	*
90	PSOXWF	☐	PSOXWF	XFELD	CHAR	1	0	Release via request Workflow required
91	.INCLU--AP	☐				0	0	Credit Card: Append for VBKPF
92	.INCLUDE	☐				0	0	Credit Card: Include for Appends for BKPF, VBKPF
93	CCINS	☐	CCINS_30F	CCINS_30F	CHAR	4	0	Payment cards: Card type	TCRIN
94	CCNUM	☐	CCNUM_30F	CCNUM_30F	CHAR	25	0	Payment cards: Card number
95	BUZEI	☐	BUZEI	BUZEI	NUMC	3	0	Number of Line Item Within Accounting Document
96	BSCHL	☐	BSCHL	BSCHL	CHAR	2	0	Posting Key	*
97	ZUONR	☐	DZUONR	ZUONR	CHAR	18	0	Assignment number
98	HKONT	☐	HKONT	SAKNR	CHAR	10	0	General Ledger Account	*
99	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	*
100	SHKZG	☐	SHKZG	SHKZG	CHAR	1	0	Debit/Credit Indicator
101	SGTXT	☐	SGTXT	TEXT50	CHAR	50	0	Item Text
102	MWART	☐	MWART	MWART	CHAR	1	0	Tax Type
103	MWSKZ	☐	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code	*
104	DMBTR	☐	DMBTR	WERT7	CURR	13	2	Amount in local currency
105	DMBE2	☐	DMBE2	WERT7	CURR	13	2	Amount in Second Local Currency
106	DMBE3	☐	DMBE3	WERT7	CURR	13	2	Amount in Third Local Currency
107	WRBTR	☐	WRBTR	WERT7	CURR	13	2	Amount in document currency
108	HWBAS	☐	HWBAS	WERT7	CURR	13	2	Tax Base Amount in Local Currency
109	FWBAS	☐	FWBAS	WERT7	CURR	13	2	Tax Base Amount in Document Currency
110	KOART	☐	KOART	KOART	CHAR	1	0	Account type
111	GEBER	☐	BP_GEBER	BP_GEBER	CHAR	10	0	Fund	*
112	LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	*
113	KUNNR	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	*
114	SAKNR	☐	SAKNR	SAKNR	CHAR	10	0	G/L Account Number	*
115	FINCODE	☐	BP_GEBER	BP_GEBER	CHAR	10	0	Fund	*
116	FNAME	☐	FM_FNAME	TEXT20	CHAR	20	0	Fund name
117	FDSCR	☐	FM_BESCHR	TEXT40	CHAR	40	0	Description
118	SPONSOR	☐	FM_SPONSOR	KUNNR	CHAR	10	0	Customer account number for fund	*
119	FISTL	☐	FISTL	FISTL	CHAR	16	0	Funds Center	*
120	CNAME	☐	FM_CNAME	TEXT20	CHAR	20	0	Funds center name
121	FIPEX	☐	FIPEX	FIPEX	CHAR	24	0	Commitment item (No longer in use -> FM_FIPEX)
122	PNAME	☐	FM_PNAME	TEXT20	CHAR	20	0	Commitment item name
123	EFICTR	☐	FM_SDFICTR	FISTL	CHAR	16	0	Balance Funds Center	*
124	EFIPEX1	☐	FM_SDFIPEX	FM_FIPEX	CHAR	24	0	Balance Cmmt Item	*
125	EFIPEX2	☐	FM_SDFIPX2	FM_FIPEX	CHAR	24	0	Balance commitment item plan year+1	*
126	EFIPEX3	☐	FM_SDFIPX3	FM_FIPEX	CHAR	24	0	Balance commitment item plan year+2	*
127	EFIPEX4	☐	FM_SDFIPX4	FM_FIPEX	CHAR	24	0	Balance commitment item plan year+3	*
128	EFIPEX5	☐	FM_SDFIPX5	FM_FIPEX	CHAR	24	0	Balance commitment item plan year+4	*
129	XDELT	☐	XDELT	XFELD	CHAR	1	0	Indicator: Recurring entry carried out (can be deleted) ?
130	.INCLUDE	☐				0	0	Include for Appends for VBSE*
131	CHWRB	☐	CHWRB	CHAR1	CHAR	1	0	Document Parking: Amount not Modifiable
132	ERLKZ	☐	KBLERLKZ	CHAR1_X	CHAR	1	0	Completion indicator for line item
133	KOKRS	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	*
134	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	*
135	AUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	*
136	ANLN1	☐	ANLN1	ANLN1	CHAR	12	0	Main Asset Number	*
137	ANLN2	☐	ANLN2	ANLN2	CHAR	4	0	Asset Subnumber	*
138	PS_PSP_PNR	☐	PS_PSP_PNR	PS_POSNR	NUMC	8	0	Work Breakdown Structure Element (WBS Element)	*
139	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	*
140	PPRCTR	☐	PPRCTR	PRCTR	CHAR	10	0	Partner Profit Center	*
141	KBLNR	☐	KBLNR_FI	KBLNR	CHAR	10	0	Document number for earmarked funds	*
142	KBLPOS	☐	KBLPOS	KBLPOS	NUMC	3	0	Earmarked Funds: Document Item	*
143	EBELN	☐	EBELN	EBELN	CHAR	10	0	Purchasing Document Number	*
144	EBELP	☐	EBELP	EBELP	NUMC	5	0	Item Number of Purchasing Document	*
145	REBZG	☐	REBZG	BELNR	CHAR	10	0	Number of the Invoice the Transaction Belongs to
146	REBZJ	☐	REBZJ	GJAHR	NUMC	4	0	Fiscal Year of the Relevant Invoice (for Credit Memo)
147	REBZZ	☐	REBZZ	BUZEI	NUMC	3	0	Line Item in the Relevant Invoice
148	REBZT	☐	REBZT	REBZT	CHAR	1	0	Follow-On Document Type
149	XREF1	☐	XREF1	CHAR12	CHAR	12	0	Business partner reference key
150	XREF2	☐	XREF2	CHAR12	CHAR	12	0	Business partner reference key
151	XREF3	☐	XREF3	CHAR20	CHAR	20	0	Reference key for line item
152	UMSKZ	☐	UMSKZ	UMSKZ	CHAR	1	0	Special G/L Indicator	*
153	UMSKS	☐	UMSKS	UMSKS	CHAR	1	0	Special G/L Transaction Type
154	SKNTO	☐	SKNTO	WERT7	CURR	13	2	Cash discount amount in local currency
155	WSKTO	☐	WSKTO	WERT7	CURR	13	2	Cash Discount Amount in Document Currency
156	ZLSCH	☐	SCHZW_BSEG	ZLSCH	CHAR	1	0	Payment Method	*
157	ZLSPR	☐	DZLSPR	ZAHLS	CHAR	1	0	Payment Block Key	*
158	ZFBDT	☐	DZFBDT	DATUM	DATS	8	0	Baseline date for due date calculation
159	ZBD1T	☐	DZBD1T	ZBDXT	DEC	3	0	Cash discount days 1
160	ZBD2T	☐	DZBD2T	ZBDXT	DEC	3	0	Cash discount days 2
161	ZBD3T	☐	DZBD3T	ZBDXT	DEC	3	0	Net Payment Terms Period
162	UZAWE	☐	UZAWE	UZAWE	CHAR	2	0	Payment method supplement	*
163	MSCHL	☐	MSCHL	MSCHL	CHAR	1	0	Dunning key	*
164	MANSP	☐	MANSP	MANSP	CHAR	1	0	Dunning block	*
165	EMPFB	☐	EMPFB	MAXKK	CHAR	10	0	Payee/Payer
166	BVTYP	☐	BVTYP	BVTYP	CHAR	4	0	Partner bank type
167	MABER	☐	MABER	MABER	CHAR	2	0	Dunning Area	*
168	ZINKZ	☐	DZINKZ	ZINKZ	CHAR	2	0	Exempted from Interest Calculation
169	ZSCHL	☐	SCHZW_BSEG	ZLSCH	CHAR	1	0	Payment Method	*
170	ZTERM	☐	DZTERM	ZTERM	CHAR	4	0	Terms of payment key
171	KIDNO	☐	KIDNO	CHAR30	CHAR	30	0	Payment Reference
172	NAME1	☐	NAME1_GP	NAME	CHAR	35	0	Name 1
173	NAME2	☐	NAME2_GP	NAME	CHAR	35	0	Name 2
174	NAME3	☐	NAME3_GP	NAME	CHAR	35	0	Name 3
175	NAME4	☐	NAME4_GP	NAME	CHAR	35	0	Name 4
176	PSTLZ	☐	PSTLZ	PSTLZ	CHAR	10	0	Postal Code
177	ORT01	☐	ORT01_GP	TEXT35	CHAR	35	0	City
178	LAND1	☐	LAND1_GP	LAND1	CHAR	3	0	Country Key	*
179	STRAS	☐	STRAS_GP	TEXT35	CHAR	35	0	House number and street
180	PFACH	☐	PFACH	PFACH	CHAR	10	0	PO Box
181	PSTL2	☐	PSTL2	PSTLZ	CHAR	10	0	P.O. Box Postal Code
182	PSKTO	☐	PSKTO	PSKTO	CHAR	16	0	Account Number of Bank Account At Post Office
183	BANKN	☐	BANKN	BANKN	CHAR	18	0	Bank account number
184	BANKL	☐	BANKK	BANKK	CHAR	15	0	Bank Keys
185	BANKS	☐	BANKS	LAND1	CHAR	3	0	Bank country key	*
186	STCD1	☐	STCD1	STCD1	CHAR	16	0	Tax Number 1
187	STCD2	☐	STCD2	STCD2	CHAR	11	0	Tax Number 2
188	REGIO	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	*
189	DBMON	☐	DBMON	DBMON	NUMC	2	0	Run Frequency (Recurring Entry)
190	DBTAG	☐	DBTAG	KTAG	NUMC	2	0	Run Date (Recurring Entry)
191	DBBDT	☐	DBBDT	DATUM	DATS	8	0	Recurring Entry Starting Date
192	DBATR	☐	DBATR	DATUM	DATS	8	0	Next Calculation Date of the Recurring Entry
193	DBEDT	☐	DBEDT	DATUM	DATS	8	0	Recurring Entry End Date
194	DBAKZ	☐	DBAKZ_T054	DBAKZ_T054	CHAR	4	0	Run Schedule for Recurring Entries	*
195	ITABKEY	☐	FM_ITABKEY	FM_ITABKEY	NUMC	10	0	Internal key of internal table

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	IFMEPAO	BLART	T003	BLART	REF	1	CN
2	IFMEPAO	BRNCH	J_1BBRANCH	BRANCH		1	CN
3	IFMEPAO	CCINS	TCRIN	CCINS
4	IFMEPAO	FRWEG	VBWF03	FRWEG
5	IFMEPAO	PARGB	TGSB	GSBER
6	IFMEPAO	PSOAK	PSO12	PSOAK
7	IFMEPAO	PSOTY	PSOTP	PSOTYP

History

Last changed by/on	SAP	20130529
SAP Release Created in