SAP ABAP Table PSO02 (Payment Request Structure (Local Government Screen))

Hierarchy

☛ EA-PS (Software Component) SAP Enterprise Extension Public Services
   ⤷ PSM-FM-PO (Application Component) Funds Management-Specific Postings
     ⤷ FMFI (Package) IS-PS: FI Basics for Funds Management

Basic Data

Table Category	INTTAB	Structure
Structure	PSO02	Table Relationship Diagram
Short Description	Payment Request Structure (Local Government Screen)

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	Payment Requests (Local Authority)
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	ITABKEY	☐	FM_ITABKEY	FM_ITABKEY	NUMC	10	0	Internal key of internal table
4	AUSBK	☐	AUSBK	BUKRS	CHAR	4	0	Source Company Code	T001
5	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
6	BELNR	☐	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
7	GJAHR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
8	BSTAT	☐	BSTAT_D	BSTAT	CHAR	1	0	Document Status
9	BLART	☐	BLART	BLART	CHAR	2	0	Document type	T003
10	BLDAT	☐	BLDAT	DATUM	DATS	8	0	Document Date in Document
11	BUDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
12	VATDATE	☐	VATDATE	DATUM	DATS	8	0	Tax Reporting Date
13	MONAT	☐	MONAT	MONAT	NUMC	2	0	Fiscal period
14	WWERT	☐	WWERT_D	DATUM	DATS	8	0	Translation date
15	CPUDT	☐	CPUDT	DATUM	DATS	8	0	Accounting document entry date
16	CPUTM	☐	CPUTM	UZEIT	TIMS	6	0	Time of data entry
17	AEDAT	☐	AEDT_VBKPF	DATUM	DATS	8	0	Date of the Last Document Change
18	UPDDT	☐	UPDDT	DATUM	DATS	8	0	Date of the Last Document Update
19	USNAM	☐	USNM_VBKPF	USNAM	CHAR	12	0	User Name
20	TCODE	☐	TCODE	TCODE	CHAR	20	0	Transaction Code	*
21	BVORG	☐	BVORG	BVORG	CHAR	16	0	Number of Cross-Company Code Posting Transaction
22	XBLNR	☐	XBLNR1	XBLNR1	CHAR	16	0	Reference Document Number
23	STBLG	☐	STBLG	BELNR	CHAR	10	0	Reverse Document Number
24	STJAH	☐	STJAH	GJAHR	NUMC	4	0	Reverse document fiscal year
25	BKTXT	☐	BKTXT	TEXT25	CHAR	25	0	Document Header Text
26	FIKRS	☐	FIKRS	FIKRS	CHAR	4	0	Financial Management Area	FM01
27	KOARS	☐	KOARS_003	CHAR5	CHAR	5	0	Account Types Allowed
28	XBSET	☐	XBSET	XFELD	CHAR	1	0	Tax information exists in the document
29	XSNET	☐	XSNET	XFELD	CHAR	1	0	G/L account amounts entered exclude tax
30	XBWAE	☐	FM_XBWAE	XFELD	CHAR	1	0	Only transfer document in document currency when posting
31	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
32	HWAER	☐	HWAER	WAERS	CUKY	5	0	Local Currency	TCURC
33	KURSF	☐	KURSF	KURSF	DEC	9	5	Exchange rate
34	XMWST	☐	PSO_XMWST	XFELD	CHAR	1	0	Indicator: Calculate tax?
35	VBLNR	☐	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
36	VGJHR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
37	XFRGE	☐	XFRGE	XFELD	CHAR	1	0	Released
38	XPRFG	☐	XPRFG	XFELD	CHAR	1	0	Document complete
39	XWFFR	☐	XWFFR	XFELD	CHAR	1	0	Release necessary
40	LOTKZ	☐	PSO_LOTKZ	LOTKZ	CHAR	10	0	Lot Number for Requests
41	FRWEG	☐	FRWEG	FRWEG	CHAR	4	0	Release Approv. Path	*
42	BUZEI	☐	BUZEI	BUZEI	NUMC	3	0	Number of Line Item Within Accounting Document
43	BZKEY	☐	BUZEI	BUZEI	NUMC	3	0	Number of Line Item Within Accounting Document
44	KOART	☐	KOART	KOART	CHAR	1	0	Account type
45	BZALT	☐	BZALT	BUZEI	NUMC	3	0	Old Line Item (Internal Usage)
46	BSCHL	☐	BSCHL	BSCHL	CHAR	2	0	Posting Key	*
47	UMSKZ	☐	UMSKZ	UMSKZ	CHAR	1	0	Special G/L Indicator	T074U
48	UMSKS	☐	UMSKS	UMSKS	CHAR	1	0	Special G/L Transaction Type
49	SHKZG	☐	SHKZG	SHKZG	CHAR	1	0	Debit/Credit Indicator
50	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	*
51	PARGB	☐	PARGB	GSBER	CHAR	4	0	Trading partner's business area	*
52	MWSKZ	☐	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code	*
53	DMBTR	☐	DMBTR	WERT7	CURR	13	2	Amount in local currency
54	WRBTR	☐	WRBTR	WERT7	CURR	13	2	Amount in document currency
55	HWMET	☐	HWMET	HWMET	CHAR	1	0	Method with Which the Local Currency Amount Was Determined
56	MWSTS	☐	MWSTS	WERT7	CURR	13	2	Tax Amount in Local Currency
57	WMWST	☐	WMWST	WERT7	CURR	13	2	Tax amount in document currency
58	HWBAS	☐	HWBAS	WERT7	CURR	13	2	Tax Base Amount in Local Currency
59	FWBAS	☐	FWBAS	WERT7	CURR	13	2	Tax Base Amount in Document Currency
60	MWART	☐	MWART	MWART	CHAR	1	0	Tax Type
61	KURSR	☐	KURSR	KURSP	DEC	9	5	Hedged Exchange Rate
62	GBETR	☐	GBETR	WERT7	CURR	13	2	Hedged Amount in Foreign Currency
63	VALUT	☐	VALUT	DATUM	DATS	8	0	Fixed Value Date
64	ZUONR	☐	DZUONR	ZUONR	CHAR	18	0	Assignment number
65	SGTXT	☐	SGTXT	TEXT50	CHAR	50	0	Item Text
66	ZINKZ	☐	DZINKZ	ZINKZ	CHAR	2	0	Exempted from Interest Calculation
67	FDLEV	☐	FDLEV	FDLEV	CHAR	2	0	Planning Level	*
68	FDGRP	☐	FDGRP	FDGRP	CHAR	10	0	Planning Group	*
69	FDWBT	☐	FDWBT	WERTV7	CURR	13	2	Planned Amount in Document or G/L Account Currency
70	FDTAG	☐	FDTAG	DATUM	DATS	8	0	Planning Date
71	GEBER	☐	BP_GEBER	BP_GEBER	CHAR	10	0	Fund	FMFINCODE
72	FISTL	☐	FISTL	FISTL	CHAR	16	0	Funds Center	*
73	XUMSW	☐	XUMSW	XFELD	CHAR	1	0	Indicator: Sales-Related Item ?
74	XCPDD	☐	XCPDD	XFELD	CHAR	1	0	Indicator: Address and Bank Data Set Individually
75	XZEMP	☐	XZEMP	XFELD	CHAR	1	0	Indicator: Alternative payee in document allowed ?
76	XINVE	☐	XINVE	XFELD	CHAR	1	0	Indicator: Capital Goods Affected?
77	HKONT	☐	HKONT	SAKNR	CHAR	10	0	General Ledger Account	SKB1
78	KUNNR	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	KNA1
79	LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	LFA1
80	FILKD	☐	FILKD	MAXKK	CHAR	10	0	Account Number of the Branch
81	HZUON	☐	HZUON	ZUONR	CHAR	18	0	Assignment Number for Special G/L Accounts
82	ZFBDT	☐	DZFBDT	DATUM	DATS	8	0	Baseline date for due date calculation
83	ZTERM	☐	DZTERM	ZTERM	CHAR	4	0	Terms of payment key
84	ZBD1T	☐	DZBD1T	ZBDXT	DEC	3	0	Cash discount days 1
85	ZBD2T	☐	DZBD2T	ZBDXT	DEC	3	0	Cash discount days 2
86	ZBD3T	☐	DZBD3T	ZBDXT	DEC	3	0	Net Payment Terms Period
87	ZBD1P	☐	DZBD1P	PRZ23	DEC	5	3	Cash discount percentage 1
88	ZBD2P	☐	DZBD2P	PRZ23	DEC	5	3	Cash Discount Percentage 2
89	XSKFB	☐	XSKFB	XFELD	CHAR	1	0	Indicator: Calculate amounts qualifying for cash discount ?
90	SKFBT	☐	SKFBT	WERT7	CURR	13	2	Amount Eligible for Cash Discount in Document Currency
91	SKNTO	☐	SKNTO	WERT7	CURR	13	2	Cash discount amount in local currency
92	WSKTO	☐	WSKTO	WERT7	CURR	13	2	Cash Discount Amount in Document Currency
93	ZLSCH	☐	SCHZW_BSEG	ZLSCH	CHAR	1	0	Payment Method	T042Z
94	ZLSPR	☐	DZLSPR	ZAHLS	CHAR	1	0	Payment Block Key	T008
95	UZAWE	☐	UZAWE	UZAWE	CHAR	2	0	Payment method supplement	T042F
96	HBKID	☐	HBKID	HBKID	CHAR	5	0	Short key for a house bank	T012
97	BVTYP	☐	BVTYP	BVTYP	CHAR	4	0	Partner bank type
98	REBZG	☐	REBZG	BELNR	CHAR	10	0	Number of the Invoice the Transaction Belongs to
99	REBZJ	☐	REBZJ	GJAHR	NUMC	4	0	Fiscal Year of the Relevant Invoice (for Credit Memo)
100	REBZZ	☐	REBZZ	BUZEI	NUMC	3	0	Line Item in the Relevant Invoice
101	REBZT	☐	REBZT	REBZT	CHAR	1	0	Follow-On Document Type
102	ZOLLT	☐	DZOLLT	ZOLLT	CHAR	8	0	Customs Tariff Number
103	ZOLLD	☐	DZOLLD	DATUM	DATS	8	0	Customs Date
104	LZBKZ	☐	LZBKZ	LZBKZ	CHAR	3	0	State central bank indicator	*
105	LANDL	☐	LANDL	LAND1	CHAR	3	0	Supplying Country	T005
106	DIEKZ	☐	DIEKZ	DIEKZ	CHAR	1	0	Service indicator (foreign payment)
107	SAMNR	☐	SAMNR	SAMNR	NUMC	8	0	Invoice List Number
108	VRSKZ	☐	VRSKZ	CHAR1	CHAR	1	0	Insurance Indicator
109	VRSDT	☐	VRSDT	DATUM	DATS	8	0	Insurance Date
110	MSCHL	☐	MSCHL	MSCHL	CHAR	1	0	Dunning key	T040
111	MANSP	☐	MANSP	MANSP	CHAR	1	0	Dunning block	T040S
112	MABER	☐	MABER	MABER	CHAR	2	0	Dunning Area	T047M
113	REWRT	☐	REEWR	WRTV7	CURR	13	2	Invoice Value Entered (in Local Currency)
114	REWWR	☐	REFWR	WRTV7	CURR	13	2	Invoice Value in Foreign Currency
115	STCEG	☐	STCEG	STCEG	CHAR	20	0	VAT Registration Number
116	XHKOM	☐	XHKOM	XFELD	CHAR	1	0	Indicator: G/L Account Assigned Manually?
117	VERTT	☐	RANTYP	RANTYP	CHAR	1	0	Contract Type
118	VERTN	☐	RANL	RANL	CHAR	13	0	Contract Number
119	VBEWA	☐	SBEWART	SBEWART	CHAR	4	0	Flow Type	*
120	DABRZ	☐	DABRBEZ	DDAT	DATS	8	0	Reference date for settlement
121	BTYPE	☐	JV_BILIND	JV_BILIND	CHAR	2	0	Payroll Type	*
122	XEGDR	☐	XEGDR	XFELD	CHAR	1	0	Indicator: Triangular deal within the EU ?
123	FIPOS	☐	FIPOS	FIPOS	CHAR	14	0	Commitment Item	*
124	ZBFIX	☐	DZBFIX	ZBFIX	CHAR	1	0	Fixed Payment Terms
125	REPRF	☐	REPRF	XFELD	CHAR	1	0	Check Flag for Double Invoices or Credit Memos
126	SWAER	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
127	MADAT	☐	MADAT	DATUM	DATS	8	0	Date of Last Dunning Notice
128	MANST	☐	MAHNS_D	MAHNS	NUMC	1	0	Dunning Level
129	ANFBN	☐	ANFBN	BELNR	CHAR	10	0	Document Number of the Bill of Exchange Payment Request
130	ANFBJ	☐	ANFBJ	GJAHR	NUMC	4	0	Fiscal Year of the Bill of Exchange Payment Request Document
131	ANFBU	☐	ANFBU	BUKRS	CHAR	4	0	Company Code in Which Bill of Exch.Payment Request Is Posted	*
132	ANFAE	☐	ANFAE	DATUM	DATS	8	0	Bill of Exchange Payment Request Due Date
133	EGMLD	☐	EGMLD_BSEZ	LAND1	CHAR	3	0	Reporting Country for Delivery of Goods within the EU	*
134	XEGMD	☐	XEGMD	XFELD	CHAR	1	0	EC reporting country deleted
135	XREF1	☐	XREF1	CHAR12	CHAR	12	0	Business partner reference key
136	XREF2	☐	XREF2	CHAR12	CHAR	12	0	Business partner reference key
137	XZANF	☐	XZANF	XFELD	CHAR	1	0	Indicator: Payment demand
138	XFDIS	☐	XFDIS	XFELD	CHAR	1	0	Indicator: Cash Management activated?
139	AWTYP	☐	AWTYP	AWTYP	CHAR	5	0	Reference procedure	*
140	AWREF	☐	AWREF	AWREF	CHAR	10	0	Reference document number
141	AWORG	☐	AWORG	AWORG	CHAR	10	0	Reference organisational units
142	AWKEY	☐	AWKEY	AWKEY	CHAR	20	0	Object key
143	AWSYS	☐	LOGSYSTEM	LOGSYS	CHAR	10	0	Logical System	*
144	AUGDT	☐	AUGDT	DATUM	DATS	8	0	Clearing Date
145	AUGCP	☐	AUGCP	DATUM	DATS	8	0	Clearing Entry Date
146	AUGBL	☐	AUGBL	BELNR	CHAR	10	0	Document Number of the Clearing Document
147	PPNAM	☐	PPNAM	XUBNAME	CHAR	12	0	Name of User Who Parked this Document	*
148	PSOXWF	☐	PSOXWF	XFELD	CHAR	1	0	Release via request Workflow required
149	EMPFB	☐	EMPFB	MAXKK	CHAR	10	0	Payee/Payer
150	.INCLUDE	☐				0	0	IS-PS: Include Structure BKPF Payment Request Doc.Header
151	.INCLUDE	☐				0	0	IS-PS: Include for Append Parked Payment Request Doc.Header
152	PSOTY	☐	PSOTY_D	PSOTY	CHAR	2	0	Document category payment requests	PSOTP
153	PSOAK	☐	PSOAK	PSOAK	CHAR	10	0	Reason	PSO12
154	PSOKS	☐	PSOKS	PSOKS	CHAR	10	0	Region	PSO14
155	PSOSG	☐	PSOSG	PSOSG	CHAR	1	0	Reason for reversal - IS-PS requests
156	PSOFN	☐	PSOFN	CHAR30	CHAR	30	0	IS-PS: File number
157	INTFORM	☐	FM_INTFORM	CHAR4	CHAR	4	0	Interest Formula
158	INTDATE	☐	FM_INTDATE	DATUM	DATS	8	0	Interest Calc. Date
159	PSOBT	☐	PSOBT	DATUM	DATS	8	0	Posting Day
160	PSOZL	☐	PSOZL	XFELD	CHAR	1	0	Actual posting
161	PSODT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
162	PSOTM	☐	PSOTM	UZEIT	TIMS	6	0	Last changed at
163	.INCLUDE	☐				0	0
164	.INCLUDE	☐				0	0	IS-PS: Include Structure Document Header, Payment Requests
165	DBMON	☐	DBMON	DBMON	NUMC	2	0	Run Frequency (Recurring Entry)
166	DBTAG	☐	DBTAG	KTAG	NUMC	2	0	Run Date (Recurring Entry)
167	DBBDT	☐	DBBDT	DATUM	DATS	8	0	Recurring Entry Starting Date
168	DBATR	☐	DBATR	DATUM	DATS	8	0	Next Calculation Date of the Recurring Entry
169	DBEDT	☐	DBEDT	DATUM	DATS	8	0	Recurring Entry End Date
170	XDELT	☐	PSOXD	XFELD	CHAR	1	0	Indicator: Recurring request complete (can be deleted)?
171	DBZHL	☐	DBZHL	PACK3	DEC	5	0	Number of Runs (Recurring Entries)
172	DBAKZ	☐	DBAKZ_T054	DBAKZ_T054	CHAR	4	0	Run Schedule for Recurring Entries	T054
173	XFWHW	☐	XFWHW_BKDF	XFELD	CHAR	1	0	Indicator: Transfer FC and LC amounts in original document
174	XSFHW	☐	XSFHW_BKDF	XFELD	CHAR	1	0	Indicator: Also transfer tax amounts in local currency
175	XBLLT	☐	XBLLT	XFELD	CHAR	1	0	Copy texts
176	XMARK	☐	MARK	XFELD	CHAR	1	0	Indicator: posting line selected?
177	XABSE	☐	XABSE	BOOLE	CHAR	1	0	Indicator: Deduction
178	XPOST	☐	FM_XPOST	XFELD	CHAR	1	0	Indicator: FI Document is Posted
179	XUMVZ	☐	PSO_XUMVZ	XFELD	CHAR	1	0	Indicator: Posting with inverted +/- sign
180	XMORE	☐	FM_XMORE	XFELD	CHAR	1	0	Indicator: More G/L Account Items Exist
181	XNEWP	☐	XNEWP	XFELD	CHAR	1	0	Indicator: New subledger account
182	XNEWC	☐	XNEWC	XFELD	CHAR	1	0	Indicator: Read master data again
183	XCPDK	☐	XCPDK	XFELD	CHAR	1	0	Indicator: Is the account a one-time account?
184	KTOCD	☐	KTOCD	KTOKD	CHAR	4	0	Reference Account Group for One-Time Account (Customer)	*
185	KTOCK	☐	KTOCK	KTOKK	CHAR	4	0	Reference Account Group for One-Time Account (Vendor)	*
186	PSOEA	☐	PSOEA	PSOEA	CHAR	8	0	Revnue Type	PSO04
187	PSOOB	☐	PSOOB	PSOOB	CHAR	12	0	Object	PSO27
188	CPDID	☐	CPDID	TEXT100	CHAR	100	0	Name of the payer
189	NAMID	☐	PSO_NAME	TEXT100	CHAR	100	0	Name of a Subledger Account
190	PSTLZ	☐	PSTLZ	PSTLZ	CHAR	10	0	Postal Code
191	ORT01	☐	ORT01	TEXT25	CHAR	25	0	City
192	PSOSF	☐	PSOSF	FM_FIPEX	CHAR	24	0	Tax commitment item	*
193	BNKID	☐	PSO_BNK	TEXT100	CHAR	100	0	Bank key and bank account of the payer
194	ANLID	☐	PSO_ANL	CHAR50	CHAR	50	0	Asset description
195	STGRD	☐	STGRD	STGRD	CHAR	2	0	Reason for Reversal	T041C
196	DBBLG	☐	DBBLG	BELNR	CHAR	10	0	Recurring Entry Document Number
197	KONTT	☐	KONTT_FI	KONTT_FI	CHAR	2	0	Account Assignment Category for Industry Solution
198	KONTL	☐	KONTL_FI	CHAR50	CHAR	50	0	Acct assignment string for industry-specific acct assignmnts
199	TEMP_ID	☐	FM_ITABKEY	FM_ITABKEY	NUMC	10	0	Internal key of internal table
200	GMVKZ	☐	FM_GMVKZ	FM_GMVKZ	CHAR	1	0	Item is in Execution
201	SRTYPE	☐	FM_SRTYPE	FM_SRTYPE	CHAR	2	0	Type of Additional Receivable

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	PSO02	AUSBK	T001	BUKRS
2	PSO02	BLART	T003	BLART		C	CN
3	PSO02	BUKRS	T001	BUKRS	KEY	C	CN
4	PSO02	DBAKZ	T054	DBAKZ
5	PSO02	FIKRS	FM01	FIKRS		C	CN
6	PSO02	GEBER	FMFINCODE	FINCODE	REF	C	CN
7	PSO02	HBKID	T012	HBKID	REF	C	CN
8	PSO02	HKONT	SKB1	SAKNR	KEY	1	CN
9	PSO02	HWAER	TCURC	WAERS		C	CN
10	PSO02	KUNNR	KNA1	KUNNR	REF	C	CN
11	PSO02	LANDL	T005	LAND1
12	PSO02	LIFNR	LFA1	LIFNR	REF	C	CN
13	PSO02	MABER	T047M	MABER
14	PSO02	MANDT	T000	MANDT	KEY	C	CN
15	PSO02	MANSP	T040S	MANSP
16	PSO02	MSCHL	T040	MSCHL
17	PSO02	PSOAK	PSO12	PSOAK
18	PSO02	PSOEA	PSO04	PSOEA
19	PSO02	PSOKS	PSO14	PSOKS
20	PSO02	PSOOB	PSO27	PSOOB
21	PSO02	PSOTY	PSOTP	PSOTYP
22	PSO02	STGRD	T041C	STGRD
23	PSO02	SWAER	TCURC	WAERS		C	CN
24	PSO02	UMSKZ	T074U	UMSKZ
25	PSO02	UZAWE	T042F	UZAWE	REF	C	CN
26	PSO02	WAERS	TCURC	WAERS		C	CN
27	PSO02	ZLSCH	T042Z	ZLSCH		C	CN
28	PSO02	ZLSPR	T008	ZAHLS	REF	C	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in