VSPROJ_CN

Version: Project definition | #masterdata | #language | Component: Simulation

🔑 Keys (3)
💰 Amounts (2)
∑ Quantities (2)
📅 Dates (10)
☰ Categorical (21)
Other (24)
🔗 Relations (47)

Column Name	Description
MANDT FK	Client
VSNMR	Number or description of a version
PSPNR	Project (internal)

Column Name	Description
💲 User field: Unit for value fields (PROJ.USE06):
USR06	User-defined field for values (length 10,3)
💲 User field: Unit for value fields (PROJ.USE07):
USR07	User-defined field for values (length 10,3)

Column Name	Description
📏 User field: Unit for quantity fields (PROJ.USE04):
USR04	User field for quantity (length 10.3)
📏 User field: Unit for quantity fields (PROJ.USE05):
USR05	User field for quantity (length 10.3)

Column Name	Description
ERDAT	Date on which the record was created
AEDAT	Date on which object was last changed
PLFAZ	Project planned start date
PLSEZ	Project planned finish date
AEDTE	Date of last scheduling of the overall network (basic dates)
AEDTP	Date of last scheduling of the overall network (forecast)
SPROG	Forecast start date of project definition
EPROG	Forecast finish date for project definition
USR08	User field for date
USR09	User field for date

Column Name	Description
AUTOD	Automatic value transfer from WBS element to project def.	Show values
ZUORD	Network assignment	Show values
TRMEQ	Indicator: WBS dates detailed by activity dates	Show values
VGPLF	Planning method for project basic dates	Show values
EWPLF	Planning method for project forecast dates	Show values
NZANZ	Indicator: Network header visible to end user	Show values
BESTA	Project stock	Show values
SCOPE	Object Class	Show values
XSTAT	Statistical WBS element	Show values
PLINT	Indicator for Integrated Planning	Show values
LOEVM	Deletion Indicator	Show values
INACT	Indicator: Project definition inactive	Show values
KZBWS	Valuation of Special Stock	Show values
FLGVRG	Indicator: Bottom-up calculation with activity dates	Show values
GRTOP	Indicator: Automatic requirements grouping	Show values
KZERB	Indicator: Project summarization via master data charact.	Show values
SCHTYP	Scheduling scenario	Show values
INCAT	Version inactive indicator	Show values
USR10	User-defined field: Indicator for reports	Show values
USR11	User-defined field: Indicator for reports	Show values
AVC_ACTIVE	Availability control indicator(AVC)	Show values

Column Name	Description	Domain name
PSPID	Project definition	PS_PSPID
POST1	PS: Short description (1st text line)	TEXT40
ERNAM	Name of Person Responsible for Creating the Object	USNAM
AENAM	Name of Person Who Changed Object	USNAM
KIMSK	Selection mask for WBS element short IDs	PS_PROID
VERNA	Name of responsible person (Project manager)	PS_VERNA
ASTNA	Applicant	PS_ASTNA
BERST	Authorization key for project master data	CHAR16
BERTR	Authorization key for project dates (WBS)	CHAR16
BERKO	Authorization key for costs and revenues	CHAR16
BERBU	Authorization key for project budget	CHAR16
POSTU	PS: Short description (1st text line) in all caps	CHAR40
LOGSYSTEM	Logical System	LOGSYS
VPKSTU	Node level	SEU_LEVEL
PSPID_EDIT	Project Number (External) Edited	PS_PSPID_EDIT
OTYPE	Joint Venture Object Type	JV_OTYPE
EEW_PROJ_PS_DUMMY	Dummy function in length 1	DUMMY
ORGKEY	Project (internal)	PS_PSPNR
USR00	User field with 20 characters	USRCHAR20
USR01	User field with 20 characters	USRCHAR20
USR02	User Field with 10 Characters	USRCHAR10
USR03	User Field with 10 Characters	USRCHAR10
CPD_UPDAT	Time Stamp	/CPD/PFP_SC_TSTMP
AVC_PROFILE	Budget Availability Control: Profile	FCO_AVC_PROFILE

Master Data Relations	Join Conditions
Results Analysis Key	`VSPROJ_CN.MANDT == TKKAA.MANDT` `VSPROJ_CN.ABGSL == TKKAA.ABGSL`
Applicant number	`VSPROJ_CN.MANDT == TCJ05.MANDT` `VSPROJ_CN.ASTNR == TCJ05.ASTNR`
Budget Profile ? ? Client Budget Profile	`VSPROJ_CN.[column in domain "BP_APPLIK"] == TBP1C.APPLIK` `VSPROJ_CN.[column in domain "CO_WRTTP"] == TBP1C.WRTTP` `VSPROJ_CN.MANDT == TBP1C.MANDT` `VSPROJ_CN.BPROF == TBP1C.PROFIL`
Equity type Equity type Client Company code for the project	`VSPROJ_CN.ETYPE == T8JE.ETYPE` `VSPROJ_CN.MANDT == T8JE.MANDT` `VSPROJ_CN.VBUKR == T8JE.BUKRS`
Regulatory indicator Regulatory indicator Client	`VSPROJ_CN.FERC_IND == FERC_C7.IND` `VSPROJ_CN.MANDT == FERC_C7.MANDT`
Payment plan profile ? ? Client Payment plan profile	`VSPROJ_CN.[column in domain "BP_APPLIK"] == TBP1C.APPLIK` `VSPROJ_CN.[column in domain "CO_WRTTP"] == TBP1C.WRTTP` `VSPROJ_CN.MANDT == TBP1C.MANDT` `VSPROJ_CN.FMPRF == TBP1C.PROFIL`
Functional Area	`VSPROJ_CN.MANDT == TFKB.MANDT` `VSPROJ_CN.FUNC_AREA == TFKB.FKBER`
Investment Measure Profile	`VSPROJ_CN.MANDT == TAPRF.MANDT` `VSPROJ_CN.IMPRF == TAPRF.IVPRO`
JIB/JIBE Class JIB/JIBE Class Client Company code for the project	`VSPROJ_CN.JIBCL == T8J6A.CLASS` `VSPROJ_CN.MANDT == T8J6A.MANDT` `VSPROJ_CN.VBUKR == T8J6A.BUKRS`
JIB/JIBE Subclass A Company code for the project JIB/JIBE Subclass A JIB/JIBE Class	`VSPROJ_CN.MANDT == T8J6C.MANDT` `VSPROJ_CN.VBUKR == T8J6C.BUKRS` `VSPROJ_CN.JIBSA == T8J6C.SUBCLASS` `VSPROJ_CN.JIBCL == T8J6C.CLASS`
Factory calendar key	`VSPROJ_CN.KALID == TFACD.IDENT`
Cost Center Project planned finish date Cost Center Controlling area for the project	`VSPROJ_CN.MANDT == CSKS.MANDT` `VSPROJ_CN.PLSEZ == CSKS.DATBI` `VSPROJ_CN.KOSTL == CSKS.KOSTL` `VSPROJ_CN.VKOKR == CSKS.KOKRS`
Cost Object Cost Object Project planned finish date Client	`VSPROJ_CN.KTRG == CKPH.KSTRG` `VSPROJ_CN.PLSEZ == CKPH.DATBI` `VSPROJ_CN.MANDT == CKPH.MANDT`
Client	`VSPROJ_CN.MANDT == T000.MANDT`
Distribution profile Distribution profile Client	`VSPROJ_CN.PGPRF == TPGPRF.PROFID` `VSPROJ_CN.MANDT == TPGPRF.MANDT`
Application of the task list Application of the task list Client	`VSPROJ_CN.PLNAW == TCA09.PLNAW` `VSPROJ_CN.MANDT == TCA09.MANDT`
Planning Profile ? ? Client Planning Profile	`VSPROJ_CN.[column in domain "BP_APPLIK"] == TBP1C.APPLIK` `VSPROJ_CN.[column in domain "CO_WRTTP"] == TBP1C.WRTTP` `VSPROJ_CN.MANDT == TBP1C.MANDT` `VSPROJ_CN.PPROF == TBP1C.PROFIL`
Profit Center Date on which object was last changed ? Profit Center	`VSPROJ_CN.MANDT == CEPC.MANDT` `VSPROJ_CN.AEDAT == CEPC.DATBI` `VSPROJ_CN.[column in domain "KOKRS"] == CEPC.KOKRS` `VSPROJ_CN.PRCTR == CEPC.PRCTR`
Project Profile	`VSPROJ_CN.MANDT == TCJ41.MANDT` `VSPROJ_CN.PROFL == TCJ41.PROFIDPROJ`
Status Combination	`VSPROJ_CN.MANDT == ACTCMB_TAB.MANDT` `VSPROJ_CN.PROJ_STATUS == ACTCMB_TAB.ACTCMB`
WBS currency (project definition)	`VSPROJ_CN.MANDT == TCURC.MANDT` `VSPROJ_CN.PWHIE == TCURC.WAERS`
Recovery Indicator Company code for the project Recovery Indicator	`VSPROJ_CN.MANDT == T8JJ.MANDT` `VSPROJ_CN.VBUKR == T8JJ.BUKRS` `VSPROJ_CN.RECID == T8JJ.RECID`
Profile for WBS scheduling Profile for WBS scheduling Client	`VSPROJ_CN.SCPRF == TCXPS.PROFIL` `VSPROJ_CN.MANDT == TCXPS.MANDT`
Key word ID for user-defined fields	`VSPROJ_CN.MANDT == TCN00.MANDT` `VSPROJ_CN.SLWID == TCN00.SLWID`
Simulation profile Simulation profile Client	`VSPROJ_CN.SMPRF == TCN54.VER_PROFIL` `VSPROJ_CN.MANDT == TCN54.MANDT`
Division Sales Organization Distribution Channel Division Client	`VSPROJ_CN.VKORG == TVTA.VKORG` `VSPROJ_CN.VTWEG == TVTA.VTWEG` `VSPROJ_CN.SPART == TVTA.SPART` `VSPROJ_CN.MANDT == TVTA.MANDT`
Current number for standard project	`VSPROJ_CN.MANDT == PROJS.MANDT` `VSPROJ_CN.SPSNR == PROJS.PSPNR`
Location Location Client Plant	`VSPROJ_CN.STORT == T499S.STAND` `VSPROJ_CN.MANDT == T499S.MANDT` `VSPROJ_CN.WERKS == T499S.WERKS`
Status profile for project definition	`VSPROJ_CN.MANDT == TJ20.MANDT` `VSPROJ_CN.STSPD == TJ20.STSMA`
Status profile for WBS element	`VSPROJ_CN.MANDT == TJ20.MANDT` `VSPROJ_CN.STSPR == TJ20.STSMA`
Tax Jurisdiction ? Tax Jurisdiction	`VSPROJ_CN.MANDT == TTXJ.MANDT` `VSPROJ_CN.[column in domain "TAX_KALSM"] == TTXJ.KALSM` `VSPROJ_CN.TXJCD == TTXJ.TXJCD`
Language Key	`VSPROJ_CN.TXTSP == T002.SPRAS`
User field: Unit for value fields	`VSPROJ_CN.MANDT == TCURC.MANDT` `VSPROJ_CN.USE06 == TCURC.WAERS`
User field: Unit for value fields	`VSPROJ_CN.MANDT == TCURC.MANDT` `VSPROJ_CN.USE07 == TCURC.WAERS`
Company code for the project	`VSPROJ_CN.MANDT == T001.MANDT` `VSPROJ_CN.VBUKR == T001.BUKRS`
Number of the Responsible Person (Project Manager) Number of the Responsible Person (Project Manager) Client	`VSPROJ_CN.VERNR == TCJ04.VERNR` `VSPROJ_CN.MANDT == TCJ04.MANDT`
Business area for the project	`VSPROJ_CN.MANDT == TGSB.MANDT` `VSPROJ_CN.VGSBR == TGSB.GSBER`
Controlling area for the project	`VSPROJ_CN.MANDT == TKA01.MANDT` `VSPROJ_CN.VKOKR == TKA01.KOKRS`
Sales Organization	`VSPROJ_CN.MANDT == TVKO.MANDT` `VSPROJ_CN.VKORG == TVKO.VKORG`
Joint venture Company code for the project Joint venture Client	`VSPROJ_CN.VBUKR == T8JV.BUKRS` `VSPROJ_CN.VNAME == T8JV.VNAME` `VSPROJ_CN.MANDT == T8JV.MANDT`
Network Profile Application of the task list Network Profile Client	`VSPROJ_CN.PLNAW == TCN41.PLNAW` `VSPROJ_CN.VPROF == TCN41.PROFIDNETZ` `VSPROJ_CN.MANDT == TCN41.MANDT`
Distribution Channel Sales Organization Client Distribution Channel	`VSPROJ_CN.VKORG == TVKOV.VKORG` `VSPROJ_CN.MANDT == TVKOV.MANDT` `VSPROJ_CN.VTWEG == TVKOV.VTWEG`
Plant	`VSPROJ_CN.MANDT == T001W.MANDT` `VSPROJ_CN.WERKS == T001W.WERKS`
Interest Profile for Project/Order Interest Calculation Interest Profile for Project/Order Interest Calculation Client	`VSPROJ_CN.ZSCHM == TPI01.ZSCHM` `VSPROJ_CN.MANDT == TPI01.MANDT`
Time unit in time scheduling	`VSPROJ_CN.MANDT == T006.MANDT` `VSPROJ_CN.ZTEHT == T006.MSEHI`

Other Relations \| to Master Data Relations ↑	Join Conditions
Dynamic Item Processor Profile ? Client Dynamic Item Processor Profile	`VSPROJ_CN.[column in domain "AD01USAGE"] == AD01C_PROF.DPUS` `VSPROJ_CN.MANDT == AD01C_PROF.MANDT` `VSPROJ_CN.DPPPROF == AD01C_PROF.PROFNR`