SAP PROJ Project definition Table data and field list

PROJ is a standard SAP Table which is used to store Project definition data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The PROJ table consists of various fields, each holding specific information or linking keys about Project definition data available in SAP. These include PSPNR (Project definition (internal)), PSPID (Project Definition), POST1 (PS: Short description (1st text line)), OBJNR (Object 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. .

PROJ 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 or numeric)

SAP PROJ 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 PROJ 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
PSPNR	Project definition (internal)	PS_INTNR	NUMC	8		KONPD	PS_PSPNR
PSPID	Project Definition	PS_PSPID	CHAR	24		ABPSN	PS_PSPID	PSP	PD_DUMMY
POST1	PS: Short description (1st text line)	PS_POST1	CHAR	40			TEXT40
OBJNR	Object number	J_OBJNR	CHAR	22	ONR00		J_OBJNR	ONR
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
KIMSK	Selection mask for WBS element short IDs	PS_KIMSK	CHAR	24			PS_PROID
AUTOD	Automatic value transfer from WBS element to project def.	PS_AUTOD	CHAR	1			XFELD
STSPD	Status profile for project definition	PS_STSPD	CHAR	8	TJ20		J_STSMA
STSPR	Status profile for WBS element	PS_STSPR	CHAR	8	TJ20		J_STSMA
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
VBUKR	Company code for the project	PS_VBUKR	CHAR	4	T001		BUKRS	BUK
VGSBR	Business area for the project	PS_VGSBR	CHAR	4	TGSB		GSBER	GSB
VKOKR	Controlling area for the project	PS_VKOKR	CHAR	4	TKA01		CACCD	CAC
PRCTR	Profit Center	PRCTR	CHAR	10	CEPC	ALPHA	PRCTR	PRC	PRCTR_EMPTY
PWHIE	WBS currency (project definition)	PS_PWHIE	CUKY	5	TCURC		WAERS
ZUORD	Network assignment	PS_ZUORD	NUMC	1			PS_ZUORD
TRMEQ	Indicator: WBS dates detailed by activity dates	PS_TRMEQ	CHAR	1			X
PLFAZ	Project planned start date	PS_PLFAZ	DATS	8			DATUM
PLSEZ	Project planned finish date	PS_PLSEZ	DATS	8			DATUM
WERKS	Plant	WERKS_D	CHAR	4	T001W		WERKS	WRK	H_T001W_C
KALID	Factory calendar key	FABKL	CHAR	2	TFACD		WFCID
VGPLF	Planning method for project basic dates	PS_VGPLF	NUMC	1			PSPLFRM
EWPLF	Planning method for project forecast dates	PS_EWPLF	NUMC	1			PSPLFRM
ZTEHT	Time unit in time scheduling	PS_ZTEHT	UNIT	3	T006	CUNIT	MEINS
NZANZ	Indicator: Network header visible to end user	NETZOBERFL	CHAR	1			X
PLNAW	Application of the task list	PLNAW	CHAR	1	TCA09		PLNAW
VPROF	Network profile	PROFIDNZPL	CHAR	7	TCN41		PROFILID	PNW
PROFL	Project Profile	PROFIDPROJ	CHAR	7	TCJ41		PROFIDPROJ	PWS
BPROF	Budget Profile	BP_BPROFIL	CHAR	6	TBP1C		BP_PROFIL	BP1
TXTSP	Language Key	SPRAS	LANG	1	T002	ISOLA	SPRAS	SPR	H_T002
KOSTL	Cost Center	KOSTL	CHAR	10	CSKS	ALPHA	KOSTL	KOS
KTRG	Cost Object	KSTRG	CHAR	12	CKPH		KSTRG	KTR
AEDTE	Date of last scheduling of the overall network (basic dates)	PS_AEDTE	DATS	8			DATUM
AEDTP	Date of last scheduling of the overall network (forecast)	PS_AEDTP	DATS	8			DATUM
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
SPSNR	Current number for standard project	PS_ISPSP	NUMC	8	PROJS	KONPS	PS_ISPSP
BESTA	Project stock	PS_BESTAND	CHAR	1			XFELD
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
SCPRF	Profile for WBS scheduling	PS_SCHDPRF	CHAR	12	TCXPS		PS_SCHDPRF
IMPRF	Investment measure profile	IM_PROFIL	CHAR	6	TAPRF		IM_PROFIL
FMPRF	Payment plan profile	PSFM_PRF	CHAR	6	TBP1C		BP_PROFIL	BP1
ABGSL	Results Analysis Key	ABGR_SCHL	CHAR	6	TKKAA		ABGR_SCHL	ACS
POSTU	PS: Short description (1st text line) in all caps	PS_POSTU	CHAR	40			CHAR40
PPROF	Planning profile	BP_PPROFIL	CHAR	6	TBP1C		BP_PROFIL	BP1
PLINT	Indicator for Integrated Planning	PLINT	CHAR	1			XFELD
LOEVM	Deletion Indicator	LOEVM	CHAR	1			XFELD
INACT	Indicator: Project definition inactive	PS_INACT	CHAR	1			XFELD
KZBWS	Valuation of Special Stock	KZBWS	CHAR	1			KZBWS
SMPRF	Simulation profile	SIM_PROFIL	CHAR	7	TCN54		SIM_PROFIL
FLGVRG	Indicator: Bottom-up calculation with activity dates	PS_FLGVRG	CHAR	1			PS_FLGVRG
GRTOP	Indicator: Automatic requirements grouping	GRONTOP	CHAR	1			XFELD
PGPRF	Distribution profile	PGPROFID	CHAR	6	TPGPRF		PGPROFID
STORT	Location	PS_STORT	CHAR	10	T499S		AP_STAND
LOGSYSTEM	Logical System	LOGSYSTEM	CHAR	10	Assigned to domain	ALPHA	LOGSYS
KZERB	Indicator: Project summarization via master data charact.	PS_KZERB	CHAR	1			XFELD
PARGR	Partner Determination Procedure	PARGR	CHAR	4	V_TVPG_S		PARGR
FUNC_AREA	Functional Area	FKBER	CHAR	16	TFKB		FKBER	FBE
VKORG	Sales Organization	VKORG	CHAR	4	TVKO		VKORG	VKO	C_VKORG
VTWEG	Distribution Channel	VTWEG	CHAR	2	TVKOV		VTWEG	VTW	C_VTWEG
SPART	Division	SPART	CHAR	2	TVTA		SPART	SPA	C_SPART
DPPPROF	Dynamic Item Processor Profile	AD01PROFNR	CHAR	8	AD01C_PROF		AD01PROFNR	AD0	DIP_PROFILE
VPKSTU	Node level	SEU_LEVEL	NUMC	2			SEU_LEVEL
PSPID_EDIT	Project Number (External) Edited	PS_PSPID_EDIT	CHAR	24			PS_PSPID_EDIT
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
ZFILEPATH	Character field of length 40	CHAR40	CHAR	40			CHAR40
ZFILE1NAME	Char 20	CHAR20	CHAR	20			CHAR20
ZFILE1EXTE	3-Byte field	CHAR3	CHAR	3			CHAR3
ZFILE2NAME	Char 20	CHAR20	CHAR	20			CHAR20
ZFILE2EXTE	3-Byte field	CHAR3	CHAR	3			CHAR3
ZFILE3NAME	Char 20	CHAR20	CHAR	20			CHAR20
ZFILE3EXTE	3-Byte field	CHAR3	CHAR	3			CHAR3
SCHTYP	Scheduling scenario	PS_SCHED_TYPE	CHAR	1			PS_SCHED_TYPE
SPROG	Forecast start date of project definition	PS_SPROG	DATS	8			DATE
EPROG	Forecast finish date for project definition	PS_EPROG	DATS	8			DATE
.INCLU--AP				0
CPD_UPDAT	Time Stamp	/CPD/PFP_TSTMP	DEC	15		TSTLC	/CPD/PFP_TSTMP
.INCLU--AP				0
FERC_IND	Regulatory indicator	FE_IND	CHAR	4	FERC_C7	ALPHA	FE_IND
.INCLU--AP				0
PROJ_STATUS	Status Combination	ACTCMB_DELE	INT1	3	ACTCMB_TAB		ACTCMB_DOM

Key field

Non-key field

< PROH - Basic Values (for Forecast): Consumption or Actual Number PROJ2_INC - PS: Data portion of project definition include >

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

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

SELECT SINGLE *
FROM PROJ
INTO CORRESPONDING FIELDS OF WA_PROJ
WHERE...

How to access SAP table PROJ

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

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

Related SAP tables and the relationships to PROJ

    STREENODE - Description of a Hierarchy Node
        RAIPATTR - Attributes for item, measure or appropriation req.
    PRPS - PSP (project structure plan) element master data
    IMAK - Appropriation requests - general data
        RIMAKPGES - Appropriation request: Percentage distribution (t)
        RAIPWI - Key figs for preinvestment analysis per plan ver.
        RAIPPASC - Data for partner determination procedure
        AUFKV_REQ - Order for appropriation request
        PROJ_REQ - Project definition for appropriation request
            PRPS_REQ - WBS element for appropriation request
        RIPASW - Values for Reporting for Programs
        BPGE_IM - Budgeting/planning: total values
        BPJA_IM - Budgeting/planning: annual values
        RAIMACT - Actual values
        IMTP - Investment programs
            IMPR - Investment Program Positions
                AUFKV - Table Generated for View AUFKV
                PROJ - Project definition

    ARKOPF - Archiving run header data
        VSKOPF - Version: Header - general data for a
    VBUP - Sales Document: Item Status
    CKIP1 - Periodic Values for Unit Costing Item
    COSP1 - CO Object: Cost Totals for External Postings
        COVP11 - CO object: Line items with doc. header (by period)
            COEPD11 - CO object: Unvaluated ln. item settlement w/status
                COEPBR11 - CO Object: Valuated Line Item Settlement
        COVJ11 - CO object: Line items with doc header (by year)
        COVO1 - CO Object: Open Items for Line Items (w/o doc.Hdr)
    COSPD1 - CO object: External cost totals - calculated
    COSPP - Transfer of Order in the COSP Table to the Project
    COKS1 - CO Object: Control Data for Secondary Planning
    VBKDPO - Sales document: Business item data (POSNR > 0)
    HEAD13 - SAPscript: Text Header
        LINE13 - SAPscript: Text Lines
    COSS1 - CO Object: Cost Totals for Internal Postings
        COVP12 - CO object: Line items with doc. header (by period)
            COEPD12 - CO object: Unvaluated ln. item settlement w/status
                COEPBR12 - CO Object: Valuated Line Item Settlement
        COVJ12 - CO object: Line items with doc header (by year)
        COVO12 - CO object: Fxd price agreement commitment ln items
    COSSD1 - CO object: Internal cost totals - calculated
    COSSP - Transfer of the Order COSS Table to the Project
    FPLA - Billing plan
    COKR1 - CO Object: Control Data for Statistical Key Figs
        HEAD14 - SAPscript: Text Header
            LINE14 - SAPscript: Text Lines
    COSR1 - CO Object: Statistical Key Figure Totals
        COVPR1 - CO object: Stat. key figure line items by period
        COVJR1 - CO object: Line items stat. key figures (by year)
    COSL1 - CO Object: Activity Type Totals
        COVPL1 - CO object: Activity type line items by period
        COVJL1 - CO object: Line items for acty types (by year)
    COSLD - CO object: Activity type sums - calculated
    FPLT - Billing Plan: Dates
    COSB1 - CO Object: Total Variances/Results Analyses
        COVPB1 - CO object: Variance/accrual line items by period
    COSBD1 - CO object: Sums of variance/accrual - calculated
    ANIA1 - Depr. simulation for invest. projects
        ANIB1 - Invest. projects: Depr. simulation analysis report
    ANLI1 - Link table for capital investment measure -> AuC
    FMSU1 - FM totals records for financial data
        COVFP1 - CO object: Financial data line items with doc. hdr
    TPI031 - CO Objects: Date of Last Interest Run
    EKKO - Purchasing Document Header
    PSDYVB - LDB PSJ: Dummy structure under VBAP
    EKPO - Purchasing Document Item
        EKET - Scheduling Agreement Schedule Lines
        EKKN - Account Assignment in Purchasing Document
        EKBE - Purchasing Document History
    EBAN - Purchase requisition
        EBKN - Purchase Requisition Account Assignment
    FPLAPS - Billing plan for PSP network plan
        FPLTPS - Billing plan for PSP/network (dates)
    LIKP - SD Document: Delivery Header Data
        LIPS - SD document: Delivery: Item data
    PSDYVK - LDB PSJ: Dummy structure under VBAK
    PSMERK - Characteristics for summarization wo.classificatn
    DRAD - Document-object link
    PRPS_R - Project Hierarchy Reporting Structure
        PRTE - Scheduling Data for Project Item
        PSMLST - Milestone I/O Table
        PSTX - PS Texts (Header)
    RSTHIE - BRST structure of the hierarchy table
        PLAF - Planned order
        PSMERK_PRPS - Characteristics for Summarization for WBS Elements
    KBED04 - Capacity Requirement Recs for Planned Orders (LDB)
    RESB04 - Reservation/dependent reqs for plan order (LDB)
        PSDYPR - LDB PSJ: Dummy structure under PRPS_R
    AUFK - Order master data
        AFKO - Order Header Data PP Orders
            AFPO - Order Item
            AFFL - Work order sequence
                ACT01 - Activity for LDB 01
    PSDYRH - LDB PSJ: Dummy structure under RSTHIE
    AFAB01 - Network Relationship (for LDB) - 01
    MLSTD - Milestone I/O Table
    PSTX1 - PS Texts (Header) for Activity (1)
    AFFH01 - Order PRT Data (for LDB) - 01
    KBED01 - Capacity Requirement Records (for LDB) - 01
        KBEZ - Additional data for table KBED (for ind.req/split)
            KPER - Additional data for KBEZ (person split in days)
        AFRU02 - Order Confirmations (for LDB) -02
    RESB01 - Reservation/Dependent Requirement for LDB-01
        PSDYOK - LDB PSJ: Dummy structure under RESB01
    PROJ - Project definition
    AFRU01 - Order Confirmations (for LDB) - 01
    PSMERK_ACT - Charactersitics for Summarization for Activity
    PSDYNV - LDB PSJ: Dummy structure under ACT01
        AFIH - Maintenance order header
        PSDYNP - LDB PSJ: Dummy structure under AUFK
    IMTP - Investment programs
        IMPR - Investment Program Positions
            PSDYIP - LDB PSJ: Dummy structure under IMPR
        PSDYPG - LDB PSJ: Dummy structure under IMTP
    PEGOB - Peg (master data of the CO object)
    PSDYPD - LDB PSJ: Dummy structure under PROJ
    PEGQTY - Assigned pegging object quantities
    PSDYPEG - LDB PSJ: Dummy Structure Under PEGOB
    ELM_PS - Additional data for hierarchy nodes (LDB PSJ)
        JSTO - Status object information
            PSTAT - Condensed status display
            JCDO - Change Documents for Status Object (Table JSTO)
            JEST - Individual Status per Object
                JCDS - Change docs. for system/user status (table JEST)
        ONR00 - General Object Number
            RPSCO1 - Summarization Table for Project Reporting
    VBAK - Sales Document: Header Data
            RPSQT - Summarization table for project reporting (quants)
            EV_PARAM - Object parameters for earned value analysis
            EV_POC - Earned value analysis: percentage of completion
            EV_VAL - Earned value analysis: earned value
            COBRA - Settlement Rule for Order Settlement
                COBRB - Distribution rules for sett. rule for order sett.
            BPHI1 - Cross-hierarchy data Control
            BPTR1 - Object Data Control
                BPGE1 - Totals record total value Control
                    BPVG1 - Table Generated for View BPVG1
    VBUK - Sales Doc.: Header Status and Administrative Data
                    BKHS1 - Header - Unit Costing (Control + Totals)
                        HEAD10 - SAPscript: Text Header
                            LINE10 - SAPscript: Text Lines
                        BKHT1 - Texts for CKHS
                        BKIS1 - Individual calculation/verification item gen.
                            BKIT1 - Texts for CKIS
                        BKIP1 - Periodic Values for Unit Costing Item
                BPJA1 - Totals record for total year value Control
                    BPVJ1 - Table Generated for View BPVJ1
                    BKHS2 - Header - Unit Costing (Control + Totals)
    VBKD - Sales Document: Business Data
    HEAD20 - SAPscript: Text Header
        LINE20 - SAPscript: Text Lines
    BKHT2 - Texts for CKHS
    BKIS2 - Individual calculation/verification item gen.
        BKIT2 - Texts for CKIS
    BKIP2 - Periodic Values for Unit Costing Item
                BPPE1 - Totals Record for Period Values Control
                    BPVP1 - Table Generated for View BPVP1
                BPIG1 - Budget Object Index (Overall Budget)
                BPIJ1 - Budget Object Index (Annual Budget)
    VBAP - Sales Document: Item Data
            COKA1 - CO Object: Cost Element Control Data
            COKP1 - CO Object: Primary Planning Control Data
                HEAD11 - SAPscript: Text Header
                    LINE11 - SAPscript: Text Lines
                CKHS1 - Header - Unit Costing (Control + Totals)
                    CKHT1 - Texts for CKHS
                    HEAD12 - SAPscript: Text Header
                        LINE12 - SAPscript: Text Lines
                    CKIS1 - Individual calculation/verification item gen.
                        CKIT1 - Texts for CKIS