SAP ABAP Table PSO01 (Payment Requests (Local Authority))

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	PSO01	Table Relationship Diagram
Short Description	Payment Requests (Local Authority)

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

Foreign Keys

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

History

Last changed by/on	SAP	20130529
SAP Release Created in