SAP PSOSEC Recurring Request Document Segment, One-Time Data Table data and field list

PSOSEC is a standard SAP Table which is used to store Recurring Request Document Segment, One-Time Data data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The PSOSEC table consists of various fields, each holding specific information or linking keys about Recurring Request Document Segment, One-Time Data data available in SAP. These include LOTKZ (Lot Number for Documents), BUKRS (Company Code), ITABKEY (Internal key of internal table), GJAHR (Fiscal Year)... 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. .

PSOSEC 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 PSOSEC 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 PSOSEC 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
MANDT	Client	MANDT	CLNT	3	T000		MANDT
LOTKZ	Lot Number for Documents	LOTKZ	CHAR	10		ALPHA	LOTKZ	LOT
BUKRS	Company Code	BUKRS	CHAR	4	T001		BUKRS	BUK	C_T001
ITABKEY	Internal key of internal table	FM_ITABKEY	NUMC	10			FM_ITABKEY
GJAHR	Fiscal Year	GJAHR	NUMC	4		GJAHR	GJAHR	GJR
BUZEI	Number of Line Item Within Accounting Document	BUZEI	NUMC	3			BUZEI	BUZ
AUSBK	Source Company Code	AUSBK	CHAR	4	Assigned to domain		BUKRS
NAME1	Name 1	NAME1_GP	CHAR	35			NAME
NAME2	Name 2	NAME2_GP	CHAR	35			NAME
NAME3	Name 3	NAME3_GP	CHAR	35			NAME
NAME4	Name 4	NAME4_GP	CHAR	35			NAME
PSTLZ	Postal Code	PSTLZ	CHAR	10			PSTLZ
ORT01	City	ORT01_GP	CHAR	35			TEXT35
LAND1	Country Key	LAND1_GP	CHAR	3	T005		LAND1		C_LAND1
STRAS	House number and street	STRAS_GP	CHAR	35			TEXT35
PFACH	PO Box	PFACH	CHAR	10			PFACH
PSTL2	P.O. Box Postal Code	PSTL2	CHAR	10			PSTLZ
PSKTO	Account Number of Bank Account At Post Office	PSKTO	CHAR	16			PSKTO
BANKN	Bank account number	BANKN	CHAR	18			BANKN
BANKL	Bank Keys	BANKK	CHAR	15			BANKK	BNK
BANKS	Bank country key	BANKS	CHAR	3	T005		LAND1	BKL
STCD1	Tax Number 1	STCD1	CHAR	16			STCD1
STCD2	Tax Number 2	STCD2	CHAR	11			STCD2
STKZU	Liable for VAT	STKZU	CHAR	1			XFELD
STKZA	Indicator: Business Partner Subject to Equalization Tax?	STKZA	CHAR	1			STKZA
REGIO	STATE (State, Province, County)	REGIO	CHAR	3	T005S		REGIO
BKONT	Bank Control Key	BKONT	CHAR	2			BKONT
DTAWS	Instruction key for data medium exchange	DTAWS	CHAR	2	Assigned to domain		DTAWS
DTAMS	Indicator for Data Medium Exchange	DTAMS	CHAR	1			DTAMS
XCPDK	Indicator: Is the account a one-time account?	XCPDK	CHAR	1			XFELD
EMPFG	Payee code	EMPFG	CHAR	16			EMPFG
SPRAS	Language Key	SPRAS	LANG	1	T002	ISOLA	SPRAS	SPR	H_T002
FITYP	Tax type	J_1AFITP_D	CHAR	2	Assigned to domain		J_1AFITP
STCDT	Tax Number Type	J_1ATOID	CHAR	2	J_1ATODC		J_1ATOID
STKZN	Natural Person	STKZN	CHAR	1			STKZN
STCD3	Tax Number 3	STCD3	CHAR	18			CHAR18
STCD4	Tax Number 4	STCD4	CHAR	18			CHAR18
ANRED	Title	ANRED	CHAR	15			TEXT15
BKREF	Reference specifications for bank details	BKREF	CHAR	20			CHAR20
J_1KFREPRE	Name of Representative	REPRES	CHAR	10			REPRES
J_1KFTBUS	Type of Business	GESTYP	CHAR	30	Assigned to domain		GESTYP
J_1KFTIND	Type of Industry	INDTYP	CHAR	30	Assigned to domain		INDTYP

Key field

Non-key field

< PSOR_REORG - Object List for Reorganization of Orders for Projects PSOSEG - Document Parking Document Segment >

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

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

SELECT SINGLE *
FROM PSOSEC
INTO CORRESPONDING FIELDS OF WA_PSOSEC
WHERE...

How to access SAP table PSOSEC

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

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