PSO01 SAP (Payment Requests (Local Authority)) Structure details
Description: Payment Requests (Local Authority)
Structure field list including key, data, relationships and ABAP select examples
PSO01 is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Payment Requests (Local Authority)" Information within sap ABAP programs.
This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.
i.e. DATA: wa_PSO01 TYPE PSO01.
The PSO01 table consists of various fields, each holding specific information or linking keys about Payment Requests (Local Authority) data available in SAP. These include ITABKEY (Internal key of internal table), AUSBK (Source Company Code), BUKRS (Company Code), BELNR (Accounting Document Number).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP PSO01 structure fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
ITABKEY | Internal key of internal table | FM_ITABKEY | NUMC | 10 | FM_ITABKEY | ||||
AUSBK | Source Company Code | AUSBK | CHAR | 4 | T001 | BUKRS | |||
BUKRS | Company Code | BUKRS | CHAR | 4 | T001 | BUKRS | BUK | C_T001 | |
BELNR | Accounting Document Number | BELNR_D | CHAR | 10 | ALPHA | BELNR | BLN | ||
GJAHR | Fiscal Year | GJAHR | NUMC | 4 | GJAHR | GJAHR | GJR | ||
BSTAT | Document Status | BSTAT_D | CHAR | 1 | BSTAT | ||||
BLART | Document Type | BLART | CHAR | 2 | T003 | BLART | BAR | ||
BLDAT | Document Date in Document | BLDAT | DATS | 8 | DATUM | ||||
BUDAT | Posting Date in the Document | BUDAT | DATS | 8 | DATUM | ||||
VATDATE | Tax Reporting Date | VATDATE | DATS | 8 | DATUM | ||||
MONAT | Fiscal Period | MONAT | NUMC | 2 | MONAT | ||||
WWERT | Translation Date | WWERT_D | DATS | 8 | DATUM | ||||
CPUDT | Day On Which Accounting Document Was Entered | CPUDT | DATS | 8 | DATUM | ||||
CPUTM | Time of Entry | CPUTM | TIMS | 6 | UZEIT | ||||
AEDAT | Date of the Last Document Change | AEDT_VBKPF | DATS | 8 | DATUM | ||||
UPDDT | Date of the Last Document Update | UPDDT | DATS | 8 | DATUM | ||||
USNAM | User Name | USNM_VBKPF | CHAR | 12 | USNAM | USR | |||
TCODE | Transaction Code | TCODE | CHAR | 20 | Assigned to domain | TCODE | TCD | ||
BVORG | Number of Cross-Company Code Posting Transaction | BVORG | CHAR | 16 | BVORG | ||||
XBLNR | Reference Document Number | XBLNR1 | CHAR | 16 | XBLNR1 | ||||
STBLG | Reverse Document Number | STBLG | CHAR | 10 | ALPHA | BELNR | |||
STJAH | Reverse document fiscal year | STJAH | NUMC | 4 | GJAHR | GJAHR | |||
BKTXT | Document Header Text | BKTXT | CHAR | 25 | TEXT25 | ||||
FIKRS | Financial Management Area | FIKRS | CHAR | 4 | FM01 | FIKRS | FIK | ||
KOARS | Account Types Allowed | KOARS_003 | CHAR | 5 | CHAR5 | ||||
XBSET | Tax information exists in the document | XBSET | CHAR | 1 | XFELD | ||||
XSNET | G/L account amounts entered exclude tax | XSNET | CHAR | 1 | XFELD | ||||
XBWAE | Only transfer document in document currency when posting | FM_XBWAE | CHAR | 1 | XFELD | ||||
WAERS | Currency Key | WAERS | CUKY | 5 | TCURC | WAERS | FWS | ||
HWAER | Local Currency | HWAER | CUKY | 5 | TCURC | WAERS | |||
KURSF | Exchange rate | KURSF | DEC | 9(5) | EXCRT | KURSF | |||
XMWST | Indicator: Calculate tax? | PSO_XMWST | CHAR | 1 | XFELD | ||||
VBLNR | Accounting Document Number | BELNR_D | CHAR | 10 | ALPHA | BELNR | BLN | ||
VGJHR | Fiscal Year | GJAHR | NUMC | 4 | GJAHR | GJAHR | GJR | ||
XFRGE | Released | XFRGE | CHAR | 1 | XFELD | ||||
XPRFG | Document complete | XPRFG | CHAR | 1 | XFELD | ||||
XWFFR | Release necessary | XWFFR | CHAR | 1 | XFELD | ||||
LOTKZ | Lot Number for Requests | PSO_LOTKZ | CHAR | 10 | ALPHA | LOTKZ | LOT | ||
FRWEG | Release Approv. Path | FRWEG | CHAR | 4 | Assigned to domain | FRWEG | |||
BUZEI | Number of Line Item Within Accounting Document | BUZEI | NUMC | 3 | BUZEI | BUZ | |||
BZKEY | Number of Line Item Within Accounting Document | BUZEI | NUMC | 3 | BUZEI | BUZ | |||
KOART | Account Type | KOART | CHAR | 1 | KOART | ||||
BZALT | Old Line Item (Internal Usage) | BZALT | NUMC | 3 | BUZEI | ||||
BSCHL | Posting Key | BSCHL | CHAR | 2 | Assigned to domain | BSCHL | |||
UMSKZ | Special G/L Indicator | UMSKZ | CHAR | 1 | T074U | UMSKZ | |||
UMSKS | Special G/L Transaction Type | UMSKS | CHAR | 1 | UMSKS | ||||
SHKZG | Debit/Credit Indicator | SHKZG | CHAR | 1 | SHKZG | ||||
GSBER | Business Area | GSBER | CHAR | 4 | Assigned to domain | GSBER | GSB | ||
PARGB | Trading partner's business area | PARGB | CHAR | 4 | Assigned to domain | GSBER | GSB | ||
MWSKZ | Tax on sales/purchases code | MWSKZ | CHAR | 2 | Assigned to domain | MWSKZ | |||
DMBTR | Amount in Local Currency | DMBTR | CURR | 13(2) | WERT7 | ||||
WRBTR | Amount in document currency | WRBTR | CURR | 13(2) | WERT7 | ||||
HWMET | Method with Which the Local Currency Amount Was Determined | HWMET | CHAR | 1 | HWMET | ||||
MWSTS | Tax Amount in Local Currency | MWSTS | CURR | 13(2) | WERT7 | ||||
WMWST | Tax amount in document currency | WMWST | CURR | 13(2) | WERT7 | ||||
HWBAS | Tax Base Amount in Local Currency | HWBAS | CURR | 13(2) | WERT7 | ||||
FWBAS | Tax Base Amount in Document Currency | FWBAS | CURR | 13(2) | WERT7 | ||||
MWART | Tax Type | MWART | CHAR | 1 | MWART | ||||
KURSR | Hedged Exchange Rate | KURSR | DEC | 9(5) | KURSP | ||||
GBETR | Hedged Amount in Foreign Currency | GBETR | CURR | 13(2) | WERT7 | ||||
VALUT | Value date | VALUT | DATS | 8 | DATUM | ||||
ZUONR | Assignment Number | DZUONR | CHAR | 18 | ZUONR | ||||
SGTXT | Item Text | SGTXT | CHAR | 50 | TEXT50 | ||||
ZINKZ | Exempted from interest calculation | DZINKZ | CHAR | 2 | ZINKZ | ||||
FDLEV | Planning level | FDLEV | CHAR | 2 | Assigned to domain | FDLEV | FFE | ||
FDGRP | Planning Group | FDGRP | CHAR | 10 | Assigned to domain | ALPHA | FDGRP | FFG | |
FDWBT | Planning amount in document currency | FDWBT | CURR | 13(2) | WERTV7 | ||||
FDTAG | Planning date | FDTAG | DATS | 8 | DATUM | FDT | |||
GEBER | Fund | BP_GEBER | CHAR | 10 | FMFINCODE | BP_GEBER | FIC | ||
FISTL | Funds Center | FISTL | CHAR | 16 | Assigned to domain | FISTL | FIS | ||
XUMSW | Indicator: Sales-related item ? | XUMSW | CHAR | 1 | XFELD | ||||
XCPDD | Indicator: Address and bank data set individually | XCPDD | CHAR | 1 | XFELD | ||||
XZEMP | Indicator: Alternative payee in document allowed ? | XZEMP | CHAR | 1 | XFELD | ||||
XINVE | Indicator: Capital Goods Affected? | XINVE | CHAR | 1 | XFELD | ||||
HKONT | General Ledger Account | HKONT | CHAR | 10 | SKB1 | ALPHA | SAKNR | ||
KUNNR | Customer Numbers | KUNNR | CHAR | 10 | KNA1 | ALPHA | KUNNR | KUN | C_KUNNR |
LIFNR | Account Number of Vendor or Creditor | LIFNR | CHAR | 10 | LFA1 | ALPHA | LIFNR | LIF | KRED_C |
FILKD | Account Number of the Branch | FILKD | CHAR | 10 | ALPHA | MAXKK | |||
HZUON | Assignment Number for Special G/L Accounts | HZUON | CHAR | 18 | ZUONR | ||||
ZFBDT | Baseline Date for Due Date Calculation | DZFBDT | DATS | 8 | DATUM | ||||
ZTERM | Terms of Payment Key | DZTERM | CHAR | 4 | ZTERM | ||||
ZBD1T | Cash discount days 1 | DZBD1T | DEC | 3 | ZBDXT | ||||
ZBD2T | Cash discount days 2 | DZBD2T | DEC | 3 | ZBDXT | ||||
ZBD3T | Net Payment Terms Period | DZBD3T | DEC | 3 | ZBDXT | ||||
ZBD1P | Cash Discount Percentage 1 | DZBD1P | DEC | 5(3) | PRZ23 | ||||
ZBD2P | Cash Discount Percentage 2 | DZBD2P | DEC | 5(3) | PRZ23 | ||||
XSKFB | Indicator: Calculate amounts qualifying for cash discount ? | XSKFB | CHAR | 1 | XFELD | ||||
SKFBT | Amount Eligible for Cash Discount in Document Currency | SKFBT | CURR | 13(2) | WERT7 | ||||
SKNTO | Cash discount amount in local currency | SKNTO | CURR | 13(2) | WERT7 | ||||
WSKTO | Cash discount amount in document currency | WSKTO | CURR | 13(2) | WERT7 | ||||
ZLSCH | Payment Method | SCHZW_BSEG | CHAR | 1 | T042Z | ZLSCH | |||
ZLSPR | Payment Block Key | DZLSPR | CHAR | 1 | T008 | ZAHLS | SPE | ||
UZAWE | Payment Method Supplement | UZAWE | CHAR | 2 | T042F | UZAWE | |||
HBKID | Short Key for a House Bank | HBKID | CHAR | 5 | T012 | HBKID | |||
BVTYP | Partner Bank Type | BVTYP | CHAR | 4 | BVTYP | ||||
REBZG | Number of the Invoice the Transaction Belongs to | REBZG | CHAR | 10 | ALPHA | BELNR | |||
REBZJ | Fiscal Year of the Relevant Invoice (for Credit Memo) | REBZJ | NUMC | 4 | GJAHR | GJAHR | |||
REBZZ | Line Item in the Relevant Invoice | REBZZ | NUMC | 3 | BUZEI | ||||
REBZT | Follow-On Document Type | REBZT | CHAR | 1 | REBZT | ||||
ZOLLT | Customs Tariff Number | DZOLLT | CHAR | 8 | ZOLLT | ||||
ZOLLD | Customs Date | DZOLLD | DATS | 8 | DATUM | ||||
LZBKZ | State Central Bank Indicator | LZBKZ | CHAR | 3 | Assigned to domain | LZBKZ | |||
LANDL | Supplying Country | LANDL | CHAR | 3 | T005 | LAND1 | |||
DIEKZ | Service Indicator (Foreign Payment) | DIEKZ | CHAR | 1 | DIEKZ | ||||
SAMNR | Invoice List Number | SAMNR | NUMC | 8 | SAMNR | ||||
VRSKZ | Insurance indicator | VRSKZ | CHAR | 1 | CHAR1 | ||||
VRSDT | Insurance date | VRSDT | DATS | 8 | DATUM | ||||
MSCHL | Dunning key | MSCHL | CHAR | 1 | T040 | MSCHL | |||
MANSP | Dunning block | MANSP | CHAR | 1 | T040S | MANSP | |||
MABER | Dunning Area | MABER | CHAR | 2 | T047M | MABER | |||
REWRT | Invoice Value Entered (in Local Currency) | REEWR | CURR | 13(2) | WRTV7 | ||||
REWWR | Invoice value in foreign currency | REFWR | CURR | 13(2) | WRTV7 | ||||
STCEG | VAT Registration Number | STCEG | CHAR | 20 | STCEG | ||||
XHKOM | Indicator: G/L account assigned manually ? | XHKOM | CHAR | 1 | XFELD | ||||
VERTT | Contract Type | RANTYP | CHAR | 1 | RANTYP | ||||
VERTN | Contract Number | RANL | CHAR | 13 | ALPHA | RANL | RAN | ||
VBEWA | Flow Type | SBEWART | CHAR | 4 | Assigned to domain | SBEWART | |||
DABRZ | Reference Date for Settlement | DABRBEZ | DATS | 8 | DDAT | ||||
BTYPE | Payroll Type | JV_BILIND | CHAR | 2 | Assigned to domain | ALPHA | JV_BILIND | ||
XEGDR | Indicator: Triangular deal within the EU ? | XEGDR | CHAR | 1 | XFELD | ||||
FIPOS | Commitment Item | FIPOS | CHAR | 14 | Assigned to domain | FIPOS | FIP | ||
ZBFIX | Fixed Payment Terms | DZBFIX | CHAR | 1 | ZBFIX | ||||
REPRF | Check Flag for Double Invoices or Credit Memos | REPRF | CHAR | 1 | XFELD | ||||
SWAER | Currency Key | WAERS | CUKY | 5 | TCURC | WAERS | FWS | ||
MADAT | Last dunned on | MADAT | DATS | 8 | DATUM | ||||
MANST | Dunning level | MAHNS_D | NUMC | 1 | MAHNS | ||||
ANFBN | Document Number of the Bill of Exchange Payment Request | ANFBN | CHAR | 10 | ALPHA | BELNR | |||
ANFBJ | Fiscal Year of the Bill of Exchange Payment Request Document | ANFBJ | NUMC | 4 | GJAHR | GJAHR | |||
ANFBU | Company Code in Which Bill of Exch.Payment Request Is Posted | ANFBU | CHAR | 4 | Assigned to domain | BUKRS | |||
ANFAE | Bill of Exchange Payment Request Due Date | ANFAE | DATS | 8 | DATUM | ||||
EGMLD | Reporting Country for Delivery of Goods within the EU | EGMLD_BSEZ | CHAR | 3 | Assigned to domain | LAND1 | |||
XEGMD | EC reporting country deleted | XEGMD | CHAR | 1 | XFELD | ||||
XREF1 | Business partner reference key | XREF1 | CHAR | 12 | CHAR12 | ||||
XREF2 | Business partner reference key | XREF2 | CHAR | 12 | CHAR12 | ||||
XZANF | Indicator: Payment demand | XZANF | CHAR | 1 | XFELD | ||||
XFDIS | Indicator: Cash Management activated? | XFDIS | CHAR | 1 | XFELD | ||||
AWTYP | Reference Transaction | AWTYP | CHAR | 5 | Assigned to domain | AWTYP | |||
AWREF | Reference Document Number | AWREF | CHAR | 10 | ALPHA | AWREF | |||
AWORG | Reference Organizational Units | AWORG | CHAR | 10 | AWORG | ||||
AWKEY | Reference Key | AWKEY | CHAR | 20 | AWKEY | ||||
AWSYS | Logical System | LOGSYSTEM | CHAR | 10 | Assigned to domain | ALPHA | LOGSYS | ||
AUGDT | Clearing Date | AUGDT | DATS | 8 | DATUM | ||||
AUGCP | Clearing Entry Date | AUGCP | DATS | 8 | DATUM | ||||
AUGBL | Document Number of the Clearing Document | AUGBL | CHAR | 10 | ALPHA | BELNR | |||
PPNAM | Name of User Who Parked this Document | PPNAM | CHAR | 12 | Assigned to domain | XUBNAME | |||
PSOXWF | Release via request Workflow required | PSOXWF | CHAR | 1 | XFELD | ||||
EMPFB | Payee/Payer | EMPFB | CHAR | 10 | ALPHA | MAXKK | |||
MEASURE | Funded Program | FM_MEASURE | CHAR | 24 | Assigned to domain | FM_MEASURE | FM_MEASURE | ||
PSOTY | Document category payment requests | PSOTY_D | CHAR | 2 | PSOTP | PSOTY | |||
PSOAK | Reason | PSOAK | CHAR | 10 | PSO12 | PSOAK | |||
PSOKS | Region | PSOKS | CHAR | 10 | Assigned to domain | PSOKS | |||
PSOSG | Reason for reversal - IS-PS requests | PSOSG | CHAR | 1 | PSOSG | ||||
PSOFN | IS-PS: File number | PSOFN | CHAR | 30 | CHAR30 | ||||
INTFORM | Interest Formula | FM_INTFORM | CHAR | 4 | CHAR4 | ||||
INTDATE | Interest Calc. Date | FM_INTDATE | DATS | 8 | DATUM | ||||
PSOBT | Posting Day | PSOBT | DATS | 8 | DATUM | ||||
PSOZL | Actual posting | PSOZL | CHAR | 1 | XFELD | ||||
PSODT | Changed On | AEDAT | DATS | 8 | DATUM | ||||
PSOTM | Last changed at | PSOTM | TIMS | 6 | UZEIT | ||||
DBMON | Run Frequency (Recurring Entry) | DBMON | NUMC | 2 | DBMON | ||||
DBTAG | Run Date (Recurring Entry) | DBTAG | NUMC | 2 | KTAG | ||||
DBBDT | Recurring Entry Starting Date | DBBDT | DATS | 8 | DATUM | ||||
DBATR | Next Calculation Date of the Recurring Entry | DBATR | DATS | 8 | DATUM | ||||
DBEDT | Recurring Entry End Date | DBEDT | DATS | 8 | DATUM | ||||
XDELT | Indicator: Recurring request complete (can be deleted)? | PSOXD | CHAR | 1 | XFELD | ||||
DBZHL | Number of Runs (Recurring Entries) | DBZHL | DEC | 5 | PACK3 | ||||
DBAKZ | Run Schedule for Recurring Entries | DBAKZ_T054 | CHAR | 4 | T054 | DBAKZ_T054 | |||
XFWHW | Indicator: Transfer FC and LC amounts in original document | XFWHW_BKDF | CHAR | 1 | XFELD | ||||
XSFHW | Indicator: Also transfer tax amounts in local currency | XSFHW_BKDF | CHAR | 1 | XFELD | ||||
XBLLT | Copy texts | XBLLT | CHAR | 1 | XFELD | ||||
BUDGET_PD | FM: Budget Period | FM_BUDGET_PERIOD | CHAR | 10 | Assigned to domain | FM_BUDGET_PERIOD | BUDPER | ||
PBUDGET_PD | FM: Partner Budget Period | FM_PBUDGET_PERIOD | CHAR | 10 | Assigned to domain | FM_BUDGET_PERIOD | BUDPER |
Key field | Non-key field |
How do I retrieve data from SAP structure PSO01 using ABAP code?
As PSO01 is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on PSO01 as there is no data to select.How to access SAP table PSO01
Within an ECC or HANA version of SAP you can also view further information about PSO01 and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects