SAP VSPRPSB Versions: Doc. table structure for VSPRPS_CN Table data and field list

VSPRPSB 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 "Versions: Doc. table structure for VSPRPS_CN" 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_VSPRPSB TYPE VSPRPSB.

The VSPRPSB table consists of various fields, each holding specific information or linking keys about Versions: Doc. table structure for VSPRPS_CN data available in SAP. These include MANDT (Client), VSNMR (Number or description of a version), PSPNR (WBS Element), POSID (Work Breakdown Structure Element (WBS Element))... 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. .

VSPRPSB structure Technical Details:

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)

SAP VSPRPSB structure 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 VSPRPSB 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
VSNMR	Number or description of a version	VSNMR	CHAR	12			VSNMR	VS2
PSPNR	WBS Element	PS_POSNR	NUMC	8	Assigned to domain	ABPSP	PS_POSNR
POSID	Work Breakdown Structure Element (WBS Element)	PS_POSID	CHAR	24		PROJN	PS_POSID	PRO
POST1	PS: Short description (1st text line)	PS_POST1	CHAR	40			TEXT40
OBJNR	Object number	J_OBJNR	CHAR	22	ONR00		J_OBJNR	ONR
PSPHI	Current number of the appropriate project	PS_PSPHI	NUMC	8	VSPROJ_CN	KONPD	PS_PSPNR
POSKI	WBS element short identification	PS_POSKI	CHAR	16			PS_PROKI
ERNAM	Name of Person who Created the Object	ERNAM	CHAR	12			USNAM
ERDAT	Date on Which Record Was Created	ERDAT	DATS	8			DATUM
AENAM	Name of Person Who Changed Object	AENAM	CHAR	12			USNAM
AEDAT	Date on which object was last changed	UPDAT	DATS	8			DATUM
VERNR	Number of the responsible person (project manager)	PS_VERNR	NUMC	8	TCJ04		PS_VERNR
VERNA	Name of responsible person (Project manager)	PS_VERNA	CHAR	25			PS_VERNA
ASTNR	Applicant number	PS_ASTNR	NUMC	8	TCJ05		PS_ASTNR
ASTNA	Applicant	PS_ASTNA	CHAR	25			PS_ASTNA
PBUKR	Company code for WBS element	PS_PBUKR	CHAR	4	T001		BUKRS	BUK
PGSBR	Business area for WBS element	PS_PGSBR	CHAR	4	TGSB		GSBER	GSB
PKOKR	Controlling area for WBS element	PS_PKOKR	CHAR	4	TKA01		CACCD	CAC
PRCTR	Profit Center	PRCTR	CHAR	10	CEPC	ALPHA	PRCTR	PRC	PRCTR_EMPTY
PRART	Project type	PS_PRART	CHAR	2	TCJ1		PS_PRART
STUFE	Level in Project Hierarchy	PS_STUFE	INT1	3			INT1
PLAKZ	Indicator: Planning element	PS_PLAKZ	CHAR	1			XFELD
BELKZ	Indicator: Account assignment element	PS_BELKZ	CHAR	1			XFELD
FAKKZ	Indicator: Billing element	PS_FAKKZ	CHAR	1			XFELD
NPFAZ	Relationship of network activity to production order	PS_NPFAR	CHAR	1			XFELD
ZUORD	Network assignment	PS_ZUORD	NUMC	1			PS_ZUORD
TRMEQ	Indicator: WBS dates detailed by activity dates	PS_TRMEQ	CHAR	1			X
KVEWE	Usage of the condition table	KVEWE	CHAR	1	T681V		KVEWE	KVW
KAPPL	Application	KAPPL	CHAR	2	T681A		KAPPL	KAP
KALSM	Costing Sheet	AUFKALSM	CHAR	6	T683		KALSM
ZSCHL	Overhead key	AUFZSCHL	CHAR	6			CHAR6
ABGSL	Results Analysis Key	ABGR_SCHL	CHAR	6	TKKAA		ABGR_SCHL	ACS
AKOKR	Controlling area of requesting cost center	PS_AKOKR	CHAR	4	TKA01		CACCD	CAC
AKSTL	Requesting cost center	PS_AKSTL	CHAR	10	CSKS	ALPHA	KOSTL	KOS
FKOKR	Controlling area of responsible cost center	PS_FKOKR	CHAR	4	TKA01		CACCD	CAC
FKSTL	Responsible cost center	PS_FKSTL	CHAR	10	CSKS	ALPHA	KOSTL	KOS
FABKL	Factory calendar key	FABKL	CHAR	2	TFACD		WFCID
PSPRI	Priority	NW_PRIO	CHAR	1	TCN07		NW_PRIO
EQUNR	Equipment Number	EQUNR	CHAR	18	EQUI	ALPHA	EQUNR	EQN	EQUI
TPLNR	Functional Location	TPLNR	CHAR	30	IFLOT	TPLNR	TPLNR	IFL	IFLM
PWPOS	WBS element currency	PS_PWPOS	CUKY	5	TCURC		WAERS
WERKS	Plant	WERKS_D	CHAR	4	T001W		WERKS	WRK	H_T001W_C
TXTSP	Language Key	SPRAS	LANG	1	T002	ISOLA	SPRAS	SPR	H_T002
SLWID	Key word ID for user-defined fields	SLWID	CHAR	7	TCN00		SLWID
USR00	1st user field for 20 characters - WBS element-	USR00PRPS	CHAR	20			USRCHAR20
USR01	2nd user field 20 digits - WBS element	USR01PRPS	CHAR	20			USRCHAR20
USR02	3rd user-defined field 10 digits -WBS element	USR02PRPS	CHAR	10			USRCHAR10
USR03	4th user-defined field 10 digits -WBS element	USR03PRPS	CHAR	10			USRCHAR10
USR04	1st user-defined field for quantity(length 10,3) WBS element	USR04PRPS	QUAN	13(3)			USRQUAN13
USE04	1st user defined field for quantity field unit - WBS element	USE04PRPS	UNIT	3	T006	CUNIT	MEINS
USR05	2nd use field for quantity (length 10,3) WBS element	USR05PRPS	QUAN	13(3)			USRQUAN13
USE05	2nd user defined field for quantity field unit - WBS element	USE05PRPS	UNIT	3	T006	CUNIT	MEINS
USR06	1st user field for values (length 10,3) WBS element	USR06PRPS	CURR	13(3)			USRCURR13
USE06	1st user defined field for value field unit - WBS element	USE06PRPS	CUKY	5	TCURC		WAERS
USR07	2nd user field for values (length 10,3) -WBS element	USR07PRPS	CURR	13(3)			USRCURR13
USE07	2nd user defined field for value field unit - WBS element	USE07PRPS	CUKY	5	TCURC		WAERS
USR08	1st user field for date -WBS element	USR08PRPS	DATS	8			USRDATE
USR09	2nd user field for date -WBS element	USR09PRPS	DATS	8			USRDATE
USR10	1st user field for 'Ind. for evaluations' WBS elem.	USR10PRPS	CHAR	1			FLAG
USR11	2nd user field for 'Indicator for eval.s' WBS elemnt	USR11PRPS	CHAR	1			FLAG
KOSTL	Cost center to which costs are actually posted	PS_KOSTL	CHAR	10	CSKS	ALPHA	KOSTL
KTRG	Cost Object	KSTRG	CHAR	12	CKPH		KSTRG	KTR
BERST	Authorization key for project master data	PS_BERST	CHAR	16			CHAR16
BERTR	Authorization key for project dates (WBS)	PS_BERTR	CHAR	16			CHAR16
BERKO	Authorization key for costs and revenues	PS_BERKO	CHAR	16			CHAR16
BERBU	Authorization key for project budget	PS_BERBU	CHAR	16			CHAR16
CLASF	Indicator: WBS element used in project summarization	PS_CLASF	CHAR	1			XFELD
SPSNR	Std WBS: Internal project item number (w/exit on ID)	PS_SPSNR	NUMC	8	PRPSS	KONPT	PS_SPSNR
SCOPE	Object Class	SCOPE_CV	CHAR	2		SCOPE	SCOPE_CV	PCO
XSTAT	Statistical WBS element	PS_XSTAT	CHAR	1			XFELD
TXJCD	Tax Jurisdiction	TXJCD	CHAR	15	TTXJ		TXJCD	TXJ
ZSCHM	Interest Profile for Project/Order Interest Calculation	PS_ZSCHM	CHAR	7	TPI01		PS_ZSCHM
IMPRF	Investment measure profile	IM_PROFIL	CHAR	6	TAPRF		IM_PROFIL
EVGEW	Aggregation weight for POC (PS progress)	EV_WEIGHTD	DEC	8			DEC8
AENNR	Change Number	AENNR	CHAR	12	AENR	AENNR	AENNR	AEN
SUBPR	Sub-project in work breakdown structure	PS_SUBPR	CHAR	12	PRTP		PS_SUBPR
POSTU	PS: Short description (1st text line) in all caps	PS_POSTU	CHAR	40			CHAR40
PLINT	Indicator for Integrated Planning	PLINT	CHAR	1			XFELD
LOEVM	Deletion Indicator	LOEVM	CHAR	1			XFELD
KZBWS	Valuation of Special Stock	KZBWS	CHAR	1			KZBWS
FPLNR	Billing plan number / invoicing plan number	FPLNR	CHAR	10	Assigned to domain		FPLNR
TADAT	Technically complete date	TABGDAT	DATS	8			DATUM
IZWEK	Reason for investment	IZWEK	CHAR	2	T087I		IZWEK
ISIZE	Scale of investment objects	IM_SIZECL	CHAR	2	TAIF5	ALPHA	SIZECL
IUMKZ	Reason for environmental investment	AM_UMWKZ	CHAR	5	T087K		AM_UMWKZ
ABUKR	Requesting company code	IM_ABUKRS	CHAR	4	T001		BUKRS	BUK
GRPKZ	Indicator: Grouping WBS element	GRPSPKZ	CHAR	1			GRPSPKZ
PGPRF	Distribution profile	PGPROFID	CHAR	6	TPGPRF		PGPROFID
LOGSYSTEM	Logical System	LOGSYSTEM	CHAR	10	Assigned to domain	ALPHA	LOGSYS
PSPNR_LOGS	Numeric field length 8	NUM08	NUMC	8			NUM08
STORT	Location	PS_STORT	CHAR	10	T499S		AP_STAND
FUNC_AREA	Functional Area	FKBER	CHAR	16	TFKB		FKBER	FBE
KLVAR	Costing Variant	CK_KLVAR	CHAR	4	Assigned to domain		KLVAR	KRT
KALNR	Cost Estimate Number for Cost Est. w/o Qty Structure	CK_KALNR	NUMC	12	Assigned to domain		CK_KALNR	KNR
POSID_EDIT	Work Breakdown Structure Element (WBS Element) Edited	PS_POSID_EDIT	CHAR	24			PS_POSID_EDIT
PSPKZ	Indicator: WBS element for production lot	PL_PSPKZ	CHAR	1			XFELD
MATNR	Material Number	MATNR	CHAR	18	Assigned to domain	MATN1	MATNR	MAT	S_MAT1
VLPSP	WBS: Reference work breakdown structure element	PL_PSP_PNR	NUMC	8	Assigned to domain	KONPR	PS_POSNR
VLPKZ	Indicator: Reference WBS element for production lot	PL_VLPKZ	CHAR	1			XFELD
SORT1	Sort string 1 for production lot	PL_SORT1	CHAR	10			CHAR10
SORT2	Sort string 2 for production lot	PL_SORT2	CHAR	10			CHAR10
SORT3	Sort string 3 for production lot	PL_SORT3	CHAR	10			CHAR10
VNAME	Joint Venture	JV_NAME	CHAR	6	T8JV	ALPHA	JV_NAME	JVV
RECID	Recovery Indicator	JV_RECIND	CHAR	2	T8JJ	ALPHA	JV_RECIND
ETYPE	Equity type	JV_ETYPE	CHAR	3	T8JE	ALPHA	JV_ETYPE
OTYPE	Joint Venture Object Type	JV_OTYPE	CHAR	4		ALPHA	JV_OTYPE
JIBCL	JIB/JIBE Class	JV_JIBCL	CHAR	3	T8J6A		JV_JIBCL	JIB
JIBSA	JIB/JIBE Subclass A	JV_JIBSA	CHAR	5	T8J6C		JV_JIBSA	JBS
CGPL_GUID16	Generic project planning: GUID from external R/3 system	CGPL_GUID16_R3	RAW	16			SYSUUID
CGPL_LOGSYS	Generic project planning: Log. system for CGPL_GUID16_R3	CGPL_LOGSYS	CHAR	10	Assigned to domain	ALPHA	LOGSYS
CGPL_OBJTYPE	Generic project planning: object type from ext. R/3 system	CGPL_OBJECT_TYPE_R3	CHAR	3			CHAR3
ADPSP	Reference Element PM/PS	ADDCOMPARE_CORE	CHAR	40	Assigned to domain		ADDCOMPARE_CORE		ADCP
RFIPPNT	Reference Point for Relationship Between iPPE and PS	CN_RPIP	CHAR	20	TCNRPIP		CN_RFPNT
ORGKEY	Project definition (internal)	PS_INTNR	NUMC	8	Assigned to domain	KONPD	PS_PSPNR
INCAT	Version inactive indicator	VSINACT	CHAR	1			XFELD
PRPS_STATUS	Status Combination	ACTCMB_DELE	INT1	3	ACTCMB_TAB		ACTCMB_DOM
.INCLU--AP				0
FERC_IND	Regulatory indicator	FE_IND	CHAR	4	FERC_C7	ALPHA	FE_IND
VBUKZ	Update indicator	VBKZ	CHAR	1			VERBUCHER

Key field

Non-key field

< VSPROL - Change document structure; generated by RSSCD000 VSPRPSINF - Versions-include for PRPS >

How do I retrieve data from SAP structure VSPRPSB using ABAP code?

As VSPRPSB 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 VSPRPSB as there is no data to select.

How to access SAP table VSPRPSB

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

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