SAP PSO31 Allocation of customer/objects Table data and field list

PSO31 is a standard SAP Table which is used to store Allocation of customer/objects data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The PSO31 table consists of various fields, each holding specific information or linking keys about Allocation of customer/objects data available in SAP. These include KUNNR (Customer Numbers), PSOOB (Object), BANKS (Bank country key), BANKL (Bank Keys)... 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. .

PSO31 table Technical Details:

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type)


SAP PSO31 table fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the PSO31 table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.
Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3T000MANDT
KUNNRCustomer Numbers KUNNRCHAR10KNA1ALPHAKUNNRKUNC_KUNNR
PSOOBObject PSOOBCHAR12PSO27ALPHAPSOOBPSO
BANKSBank country key BANKSCHAR3T005LAND1BKL
BANKLBank Keys BANKKCHAR15BNKABANKKBNK
BANKNBank account number BANKNCHAR18BANKN
BKONTBank Control Key BKONTCHAR2BKONT
XEZERIndicator: Is there collection authorization ? XEZERCHAR1XFELD
BKREFReference specifications for bank details BKREFCHAR20CHAR20
KOINHAccount Holder Name KOINH_FICHAR60KOINH
KOVONBank Details Valid From KOVONDATS8DATUM
KOBISBank details valid to KOBISDATS8DATUM

Key field Non-key field



How do I retrieve data from SAP table PSO31 using ABAP code

The following ABAP code Example will allow you to do a basic selection on PSO31 to SELECT all data from the table
DATA: WA_PSO31 TYPE PSO31.

SELECT SINGLE *
FROM PSO31
INTO CORRESPONDING FIELDS OF WA_PSO31
WHERE...

How to access SAP table PSO31

Within an ECC or HANA version of SAP you can also view further information about PSO31 and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).