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

History

Last changed by/on	SAP	20130529
SAP Release Created in