SE11 ABAP Dictionary SE11 PROJ

Popular:

VBAK VBAP MARA MAKT BKPF BSEG BVOR EKKO EKPO KNA1 LFA1 LIKP VBRK

PROJ

Project definition

SAP SAP Transparent Table 94 Fields

Primary Key:

MANDT PSPNR

#	Field Name	Key	Field Label	Type	Length	Dec	Check Table	Short Description
1	MANDT	KEY	Client	CLNT	3	-	T000	Client
2	PSPNR	KEY	Proj. def.	NUMC	8	-	-	Project definition (internal)
3	PSPID	-	Proj. Def.	CHAR	24	-	-	Project Definition
4	POST1	-	Descr.	CHAR	40	-	-	PS: Short description (1st text line)
5	OBJNR	-	Obj. no.	CHAR	22	-	-	Object number
6	ERNAM	-	Created	CHAR	12	-	-	Name of Person who Created the Object
7	ERDAT	-	On	DATS	8	-	-	Date on Which Record Was Created
8	AENAM	-	By	CHAR	12	-	-	Name of Person Who Changed Object
9	AEDAT	-	Changed On	DATS	8	-	-	Date on which object was last changed
10	KIMSK	-	Mask ID	CHAR	24	-	-	Selection mask for WBS element short IDs
11	AUTOD	-	Tfr defn	CHAR	1	-	-	Automatic value transfer from WBS element to project def.
12	STSPD	-	PD StsProf	CHAR	8	-	-	Status profile for project definition
13	STSPR	-	WBS StsPrf	CHAR	8	-	-	Status profile for WBS element
14	VERNR	-	Respons.	NUMC	8	-	-	Number of the responsible person (project manager)
15	VERNA	-	Resp.persn	CHAR	25	-	-	Name of responsible person (Project manager)
16	ASTNR	-	Appl.no.	NUMC	8	-	-	Applicant number
17	ASTNA	-	Applicant	CHAR	25	-	-	Applicant
18	VBUKR	-	CoCd	CHAR	4	-	-	Company code for the project
19	VGSBR	-	Bus.area	CHAR	4	-	-	Business area for the project
20	VKOKR	-	COAr	CHAR	4	-	-	Controlling area for the project
21	PRCTR	-	Profit Ctr	CHAR	10	-	-	Profit Center
22	PWHIE	-	Proj.curr.	CUKY	5	-	-	WBS currency (project definition)
23	ZUORD	-	Ntwk asst	NUMC	1	-	-	Network assignment
24	TRMEQ	-	Act. dates	CHAR	1	-	-	Indicator: WBS dates detailed by activity dates
25	PLFAZ	-	Start date	DATS	8	-	-	Project planned start date
26	PLSEZ	-	Finish	DATS	8	-	-	Project planned finish date
27	WERKS	-	Plant	CHAR	4	-	T001W	Plant
28	KALID	-	Calendar	CHAR	2	-	-	Factory calendar key
29	VGPLF	-	Plan/basic	NUMC	1	-	-	Planning method for project basic dates
30	EWPLF	-	Plan. fcst	NUMC	1	-	-	Planning method for project forecast dates
31	ZTEHT	-	Time unit	UNIT	3	-	-	Time unit in time scheduling
32	NZANZ	-	NetworkHdr	CHAR	1	-	-	Indicator: Network header visible to end user
33	PLNAW	-	Applicatn	CHAR	1	-	-	Application of the task list
34	VPROF	-	Profile	CHAR	7	-	-	Network profile
35	PROFL	-	Proj.Prof.	CHAR	7	-	-	Project Profile
36	BPROF	-	Profile	CHAR	6	-	-	Budget Profile
37	TXTSP	-	Language	LANG	1	-	-	Language Key
38	KOSTL	-	Cost Ctr	CHAR	10	-	-	Cost Center
39	KTRG	-	CostObject	CHAR	12	-	-	Cost Object
40	AEDTE	-	on	DATS	8	-	-	Date of last scheduling of the overall network (basic dates)
41	AEDTP	-	on	DATS	8	-	-	Date of last scheduling of the overall network (forecast)
42	BERST	-	Mstr data	CHAR	16	-	-	Authorization key for project master data
43	BERTR	-	Date auth.	CHAR	16	-	-	Authorization key for project dates (WBS)
44	BERKO	-	Cost auth	CHAR	16	-	-	Authorization key for costs and revenues
45	BERBU	-	Budg. auth	CHAR	16	-	-	Authorization key for project budget
46	SPSNR	-	Curr. proj	NUMC	8	-	-	Current number for standard project
47	BESTA	-	Proj.stock	CHAR	1	-	-	Project stock
48	SCOPE	-	Obj. class	CHAR	2	-	-	Object Class
49	XSTAT	-	Stat.	CHAR	1	-	-	Statistical WBS element
50	TXJCD	-	Tax Jur.	CHAR	15	-	-	Tax Jurisdiction
51	ZSCHM	-	Int. Prof.	CHAR	7	-	-	Interest Profile for Project/Order Interest Calculation
52	SCPRF	-	Profile	CHAR	12	-	-	Profile for WBS scheduling
53	IMPRF	-	InvProfile	CHAR	6	-	-	Investment measure profile
54	FMPRF	-	PPlan prof	CHAR	6	-	-	Payment plan profile
55	ABGSL	-	RA Key	CHAR	6	-	-	Results Analysis Key
56	POSTU	-	Descr.	CHAR	40	-	-	PS: Short description (1st text line) in all caps
57	PPROF	-	Profile	CHAR	6	-	-	Planning profile
58	PLINT	-	Int.plan.	CHAR	1	-	-	Indicator for Integrated Planning
59	LOEVM	-	Delete	CHAR	1	-	-	Deletion Indicator
60	INACT	-	inactive	CHAR	1	-	-	Indicator: Project definition inactive
61	KZBWS	-	Valuation	CHAR	1	-	-	Valuation of Special Stock
62	SMPRF	-	Simulation	CHAR	7	-	-	Simulation profile
63	FLGVRG	-	with act.	CHAR	1	-	-	Indicator: Bottom-up calculation with activity dates
64	GRTOP	-	RqmntGrp.	CHAR	1	-	-	Indicator: Automatic requirements grouping
65	PGPRF	-	DistriProf	CHAR	6	-	-	Distribution profile
66	STORT	-	Location	CHAR	10	-	-	Location
67	LOGSYSTEM	-	Log.System	CHAR	10	-	-	Logical System
68	KZERB	-	ProjS MsD	CHAR	1	-	-	Indicator: Project summarization via master data charact.
69	PARGR	-	PartDetPrc	CHAR	4	-	-	Partner Determination Procedure
70	FUNC_AREA	-	Func. Area	CHAR	16	-	-	Functional Area
71	VKORG	-	Sales org.	CHAR	4	-	-	Sales Organization
72	VTWEG	-	Distr. Chl	CHAR	2	-	-	Distribution Channel
73	SPART	-	Division	CHAR	2	-	-	Division
74	DPPPROF	-	Profile	CHAR	8	-	-	Dynamic Item Processor Profile
75	VPKSTU	-	Level	NUMC	2	-	-	Node level
76	PSPID_EDIT	-	Proj. def.	CHAR	24	-	-	Project Number (External) Edited
77	VNAME	-	Venture	CHAR	6	-	-	Joint Venture
78	RECID	-	Rec.Indic.	CHAR	2	-	-	Recovery Indicator
79	ETYPE	-	Equity Ty.	CHAR	3	-	-	Equity type
80	OTYPE	-	JV_ObjType	CHAR	4	-	-	Joint Venture Object Type
81	JIBCL	-	Class	CHAR	3	-	-	JIB/JIBE Class
82	JIBSA	-	Subclass A	CHAR	5	-	-	JIB/JIBE Subclass A
83	ZFILEPATH	-	Char	CHAR	40	-	-	Character field of length 40
84	ZFILE1NAME	-	Char20	CHAR	20	-	-	Char 20
85	ZFILE1EXTE	-	3-Byte field	CHAR	3	-	-	3-Byte field
86	ZFILE2NAME	-	Char20	CHAR	20	-	-	Char 20
87	ZFILE2EXTE	-	3-Byte field	CHAR	3	-	-	3-Byte field
88	ZFILE3NAME	-	Char20	CHAR	20	-	-	Char 20
89	ZFILE3EXTE	-	3-Byte field	CHAR	3	-	-	3-Byte field
90	SCHTYP	-	SchedScen	CHAR	1	-	-	Scheduling scenario
91	SPROG	-	FcstStart	DATS	8	-	-	Forecast start date of project definition
92	EPROG	-	Fcst fin.	DATS	8	-	-	Forecast finish date for project definition
93	FERC_IND	-	Reg. ind.	CHAR	4	-	-	Regulatory indicator
94	PROJ_STATUS	-	Status Com	INT1	3	-	-	Status Combination

Related References & SQL

Diagram ERD, T-Code standar, tabel terkait, dan contoh query untuk PROJ.

Interactive ERD Diagrams

SAP PP - Project Planning → SAP PP / PS - Project Systems Table Mapping →

Standard T-Codes

CJ20N CJ03 CJ01

Related Tables

T001W PRPS PRTE PRHIS PRTX PSTX PSTT

ANSI SQL Query

SELECT a.PSPNR,
       a.PSPID,
       a.POST1,
       a.OBJNR,
       a.ERNAM,
       a.ERDAT
FROM PROJ AS a
WHERE a.PSPNR = '0001';

ABAP OpenSQL (7.40+)

SELECT a~pspnr,
       a~pspid,
       a~post1,
       a~objnr,
       a~ernam,
       a~erdat
  FROM proj AS a
  WHERE a~pspnr = '0001'
  INTO TABLE @DATA(lt_proj)
  UP TO 100 ROWS.

SE11 ABAP Dictionary SE11 PROJ

PROJ

Dictionary Fields Fields

Related References & SQL