VSPRPS_CN

Version: WBS Element (Work Breakdwn Struc. Elem.) Mast. Data | #masterdata | #language | Component: Simulation

🔑 Keys (3)
💰 Amounts (2)
∑ Quantities (2)
📅 Dates (5)
☰ Categorical (21)
Other (43)
🔗 Relations (53)

Column Name	Description
MANDT FK	Client
VSNMR	Number or description of a version
PSPNR	WBS Element

Column Name	Description
💲 1st user defined field for value field unit - WBS element (PRPS.USE06):
USR06	1st user field for values (length 10,3) WBS element
💲 2nd user defined field for value field unit - WBS element (PRPS.USE07):
USR07	2nd user field for values (length 10,3) -WBS element

Column Name	Description
📏 1st user defined field for quantity field unit - WBS element (PRPS.USE04):
USR04	1st user-defined field for quantity(length 10,3) WBS element
📏 2nd user defined field for quantity field unit - WBS element (PRPS.USE05):
USR05	2nd use field for quantity (length 10,3) WBS element

Column Name	Description
ERDAT	Date on which the record was created
AEDAT	Date on which object was last changed
USR08	1st user field for date -WBS element
USR09	2nd user field for date -WBS element
TADAT	Technically complete date

Column Name	Description
PLAKZ	Indicator: Planning element	Show values
BELKZ	Indicator: Account assignment element	Show values
FAKKZ	Indicator: Billing element	Show values
NPFAZ	Relationship of network activity to production order	Show values
ZUORD	Network assignment	Show values
TRMEQ	Indicator: WBS dates detailed by activity dates	Show values
USR10	1st user field for 'Ind. for evaluations' WBS elem.	Show values
USR11	2nd user field for 'Indicator for eval.s' WBS elemnt	Show values
CLASF	Indicator: WBS element used in project summarization	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
KZBWS	Valuation of Special Stock	Show values
GRPKZ	Indicator: Grouping WBS element	Show values
PSPKZ	Indicator: WBS element for production lot	Show values
VLPKZ	Indicator: Reference WBS element for production lot	Show values
FUND_FIX_ASSIGN	Indicator for Fund with Fixed Assignment	Show values
GRANT_FIX_ASSIGNED	Indicator for Grant with Fixed Assignment	Show values
FUNC_AREA_FIX_ASSIGNED	Indicator for Functional Area with Fixed Assignment	Show values
INCAT	Version inactive indicator	Show values

Column Name	Description	Domain name
POSID	Work Breakdown Structure Element (WBS Element)	PS_POSID
POST1	PS: Short description (1st text line)	TEXT40
POSKI	WBS element short identification	PS_PROKI
ERNAM	Name of Person Responsible for Creating the Object	USNAM
AENAM	Name of Person Who Changed Object	USNAM
VERNA	Name of responsible person (Project manager)	PS_VERNA
ASTNA	Applicant	PS_ASTNA
STUFE	Level in Project Hierarchy	INT1
ZSCHL	Overhead key	CHAR6
USR00	1st user field for 20 characters - WBS element-	USRCHAR20
USR01	2nd user field 20 digits - WBS element	USRCHAR20
USR02	3rd user-defined field 10 digits -WBS element	USRCHAR10
USR03	4th user-defined field 10 digits -WBS element	USRCHAR10
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
EVGEW	Aggregation weight for POC (PS progress)	DEC8
POSTU	PS: Short description (1st text line) in all caps	CHAR40
FPLNR	Billing plan number / invoicing plan number	FPLNR
LOGSYSTEM	Logical System	LOGSYS
PSPNR_LOGS	Numeric field length 8	NUM08
KLVAR	Costing Variant	KLVAR
KALNR	Cost Estimate Number for Cost Est. w/o Qty Structure	CK_KALNR
POSID_EDIT	Work Breakdown Structure Element (WBS Element) Edited	PS_POSID_EDIT
MATNR	Material Number	MATNR
VLPSP	WBS: Reference work breakdown structure element	PS_POSNR
SORT1	Sort string 1 for production lot	CHAR10
SORT2	Sort string 2 for production lot	CHAR10
SORT3	Sort string 3 for production lot	CHAR10
OTYPE	Joint Venture Object Type	JV_OTYPE
CGPL_GUID16	Generic project planning: GUID from external R/3 system	SYSUUID
CGPL_LOGSYS	Generic project planning: Log. system for CGPL_GUID16_R3	LOGSYS
CGPL_OBJTYPE	Generic project planning: object type from ext. R/3 system	CHAR3
ADPSP	Reference Element PM/PS	ADDCOMPARE_CORE
EEW_PRPS_PS_DUMMY	Dummy function in length 1	DUMMY
RFUND	Fund	BP_GEBER
RGRANT_NBR	Grant	GM_GRANT_NBR
SPONSOREDPROG	Sponsored Program	GM_SPONSORED_PROG
ORGKEY	Project (internal)	PS_PSPNR
POSNR_PRPS	Sales Document Item	POSNR
VBELN_PRPS	Sales Document	VBELN
CPD_UPDAT	Time Stamp	/CPD/PFP_TSTMP

Master Data Relations	Join Conditions
Results Analysis Key	`VSPRPS_CN.MANDT == TKKAA.MANDT` `VSPRPS_CN.ABGSL == TKKAA.ABGSL`
Requesting company code	`VSPRPS_CN.MANDT == T001.MANDT` `VSPRPS_CN.ABUKR == T001.BUKRS`
Change Number Change Number Client	`VSPRPS_CN.AENNR == AENR.AENNR` `VSPRPS_CN.MANDT == AENR.MANDT`
Controlling area of requesting cost center	`VSPRPS_CN.MANDT == TKA01.MANDT` `VSPRPS_CN.AKOKR == TKA01.KOKRS`
Requesting cost center ? Requesting cost center Controlling area of requesting cost center	`VSPRPS_CN.MANDT == CSKS.MANDT` `VSPRPS_CN.[column in domain "DATBI"] == CSKS.DATBI` `VSPRPS_CN.AKSTL == CSKS.KOSTL` `VSPRPS_CN.AKOKR == CSKS.KOKRS`
Applicant number	`VSPRPS_CN.MANDT == TCJ05.MANDT` `VSPRPS_CN.ASTNR == TCJ05.ASTNR`
Equipment Number Equipment Number Client	`VSPRPS_CN.EQUNR == EQUI.EQUNR` `VSPRPS_CN.MANDT == EQUI.MANDT`
Equity type Equity type Client Company code for WBS element	`VSPRPS_CN.ETYPE == T8JE.ETYPE` `VSPRPS_CN.MANDT == T8JE.MANDT` `VSPRPS_CN.PBUKR == T8JE.BUKRS`
Factory calendar key	`VSPRPS_CN.FABKL == TFACD.IDENT`
Regulatory indicator Regulatory indicator Client	`VSPRPS_CN.FERC_IND == FERC_C7.IND` `VSPRPS_CN.MANDT == FERC_C7.MANDT`
Responsible Cost Center Controlling Area	`VSPRPS_CN.MANDT == TKA01.MANDT` `VSPRPS_CN.FKOKR == TKA01.KOKRS`
Responsible Cost Center ? Responsible Cost Center Responsible Cost Center Controlling Area	`VSPRPS_CN.MANDT == CSKS.MANDT` `VSPRPS_CN.[column in domain "DATBI"] == CSKS.DATBI` `VSPRPS_CN.FKSTL == CSKS.KOSTL` `VSPRPS_CN.FKOKR == CSKS.KOKRS`
Functional Area	`VSPRPS_CN.MANDT == TFKB.MANDT` `VSPRPS_CN.FUNC_AREA == TFKB.FKBER`
Investment Measure Profile	`VSPRPS_CN.MANDT == TAPRF.MANDT` `VSPRPS_CN.IMPRF == TAPRF.IVPRO`
Scale	`VSPRPS_CN.MANDT == TAIF5.MANDT` `VSPRPS_CN.ISIZE == TAIF5.SIZECL`
Reason for Environmental Investment	`VSPRPS_CN.MANDT == T087K.MANDT` `VSPRPS_CN.IUMKZ == T087K.UMWKZ`
Reason for investment	`VSPRPS_CN.MANDT == T087I.MANDT` `VSPRPS_CN.IZWEK == T087I.IZWEK`
JIB/JIBE Class JIB/JIBE Class Client Company code for WBS element	`VSPRPS_CN.JIBCL == T8J6A.CLASS` `VSPRPS_CN.MANDT == T8J6A.MANDT` `VSPRPS_CN.PBUKR == T8J6A.BUKRS`
JIB/JIBE Subclass A Company code for WBS element JIB/JIBE Subclass A JIB/JIBE Class	`VSPRPS_CN.MANDT == T8J6C.MANDT` `VSPRPS_CN.PBUKR == T8J6C.BUKRS` `VSPRPS_CN.JIBSA == T8J6C.SUBCLASS` `VSPRPS_CN.JIBCL == T8J6C.CLASS`
Costing Sheet Application Costing Sheet Usage of the condition table	`VSPRPS_CN.MANDT == T683.MANDT` `VSPRPS_CN.KAPPL == T683.KAPPL` `VSPRPS_CN.KALSM == T683.KALSM` `VSPRPS_CN.KVEWE == T683.KVEWE`
Application	`VSPRPS_CN.KAPPL == T681A.KAPPL`
Cost center to which costs are actually posted Date on which object was last changed Cost center to which costs are actually posted Responsible Cost Center Controlling Area	`VSPRPS_CN.MANDT == CSKS.MANDT` `VSPRPS_CN.AEDAT == CSKS.DATBI` `VSPRPS_CN.KOSTL == CSKS.KOSTL` `VSPRPS_CN.FKOKR == CSKS.KOKRS`
Cost Object Cost Object Date on which object was last changed Client	`VSPRPS_CN.KTRG == CKPH.KSTRG` `VSPRPS_CN.AEDAT == CKPH.DATBI` `VSPRPS_CN.MANDT == CKPH.MANDT`
Usage of the condition table	`VSPRPS_CN.KVEWE == T681V.KVEWE`
Client	`VSPRPS_CN.MANDT == T000.MANDT`
Company code for WBS element	`VSPRPS_CN.MANDT == T001.MANDT` `VSPRPS_CN.PBUKR == T001.BUKRS`
Distribution profile Distribution profile Client	`VSPRPS_CN.PGPRF == TPGPRF.PROFID` `VSPRPS_CN.MANDT == TPGPRF.MANDT`
Business area for WBS element	`VSPRPS_CN.MANDT == TGSB.MANDT` `VSPRPS_CN.PGSBR == TGSB.GSBER`
Controlling area for WBS element	`VSPRPS_CN.MANDT == TKA01.MANDT` `VSPRPS_CN.PKOKR == TKA01.KOKRS`
Project Type ? Project Type	`VSPRPS_CN.[column in domain "MANDT"] == TCJ1.MANDT` `VSPRPS_CN.PRART == TCJ1.PRART`
Profit Center ? ? Profit Center	`VSPRPS_CN.MANDT == CEPC.MANDT` `VSPRPS_CN.[column in domain "DATBI"] == CEPC.DATBI` `VSPRPS_CN.[column in domain "KOKRS"] == CEPC.KOKRS` `VSPRPS_CN.PRCTR == CEPC.PRCTR`
Status Combination	`VSPRPS_CN.MANDT == ACTCMB_TAB.MANDT` `VSPRPS_CN.PRPS_STATUS == ACTCMB_TAB.ACTCMB`
Current number of the appropriate project	`VSPRPS_CN.MANDT == VSPROJ_CN.MANDT` `VSPRPS_CN.PSPHI == VSPROJ_CN.VSNMR`
Priority	`VSPRPS_CN.MANDT == TCN07.MANDT` `VSPRPS_CN.PSPRI == TCN07.NPRIO`
WBS element currency	`VSPRPS_CN.MANDT == TCURC.MANDT` `VSPRPS_CN.PWPOS == TCURC.WAERS`
Recovery Indicator Company code for WBS element Recovery Indicator	`VSPRPS_CN.MANDT == T8JJ.MANDT` `VSPRPS_CN.PBUKR == T8JJ.BUKRS` `VSPRPS_CN.RECID == T8JJ.RECID`
Reference Point for Relationship Between iPPE and PS	`VSPRPS_CN.MANDT == TCNRPIP.MANDT` `VSPRPS_CN.RFIPPNT == TCNRPIP.RFPNT`
Key word ID for user-defined fields	`VSPRPS_CN.MANDT == TCN00.MANDT` `VSPRPS_CN.SLWID == TCN00.SLWID`
Std WBS: Internal project item number (w/exit on ID)	`VSPRPS_CN.MANDT == PRPSS.MANDT` `VSPRPS_CN.SPSNR == PRPSS.PSPNR`
Location Location Client Plant	`VSPRPS_CN.STORT == T499S.STAND` `VSPRPS_CN.MANDT == T499S.MANDT` `VSPRPS_CN.WERKS == T499S.WERKS`
Sub-project in work breakdown structure	`VSPRPS_CN.MANDT == PRTP.MANDT` `VSPRPS_CN.SUBPR == PRTP.SUBPR`
Functional Location	`VSPRPS_CN.MANDT == IFLOT.MANDT` `VSPRPS_CN.TPLNR == IFLOT.TPLNR`
Tax Jurisdiction Costing Sheet Tax Jurisdiction	`VSPRPS_CN.MANDT == TTXJ.MANDT` `VSPRPS_CN.KALSM == TTXJ.KALSM` `VSPRPS_CN.TXJCD == TTXJ.TXJCD`
Language Key	`VSPRPS_CN.TXTSP == T002.SPRAS`
1st user defined field for quantity field unit - WBS element	`VSPRPS_CN.MANDT == T006.MANDT` `VSPRPS_CN.USE04 == T006.MSEHI`
2nd user defined field for quantity field unit - WBS element	`VSPRPS_CN.MANDT == T006.MANDT` `VSPRPS_CN.USE05 == T006.MSEHI`
1st user defined field for value field unit - WBS element	`VSPRPS_CN.MANDT == TCURC.MANDT` `VSPRPS_CN.USE06 == TCURC.WAERS`
2nd user defined field for value field unit - WBS element	`VSPRPS_CN.MANDT == TCURC.MANDT` `VSPRPS_CN.USE07 == TCURC.WAERS`
Number of the Responsible Person (Project Manager) Number of the Responsible Person (Project Manager) Client	`VSPRPS_CN.VERNR == TCJ04.VERNR` `VSPRPS_CN.MANDT == TCJ04.MANDT`
Joint venture Company code for WBS element Joint venture Client	`VSPRPS_CN.PBUKR == T8JV.BUKRS` `VSPRPS_CN.VNAME == T8JV.VNAME` `VSPRPS_CN.MANDT == T8JV.MANDT`
Plant	`VSPRPS_CN.MANDT == T001W.MANDT` `VSPRPS_CN.WERKS == T001W.WERKS`
Interest Profile for Project/Order Interest Calculation Interest Profile for Project/Order Interest Calculation Client	`VSPRPS_CN.ZSCHM == TPI01.ZSCHM` `VSPRPS_CN.MANDT == TPI01.MANDT`