SAP ABAP Table /RPM/TS_TEMPLATE_D_API (Item Template API structure)
Hierarchy
☛ CPRXRPM (Software Component) SAP Portfolio and Project Management 6.0
   ⤷ PPM-PFM (Application Component) Portfolio Management
     ⤷ /RPM/API (Package) xRPM External Interfaces
Basic Data
Table Category INTTAB    Structure 
Structure /RPM/TS_TEMPLATE_D_API   Table Relationship Diagram
Short Description Item Template API structure    
Delivery and Maintenance
Pool/cluster      
Delivery Class      
Data Browser/Table View Maintenance     Display/Maintenance Allowed with Restrictions 
Components
     
Field Key Data Element Domain Data
Type		 Length Decimal
Places		 Short Description Check
table
1 GUID /RPM/TV_GUID   RAW 16   0   Guid for application objects  
2 CREATED_ON CGPL_CREATED_ON DATUM DATS 8   0   Date on Which the Object was Created  
3 CREATED_BY CGPL_CREATED_BY USNAM CHAR 12   0   Name of Person Who Created Object  
4 .INCLUDE       0   0   Item/Initiative Detail Internal Attributes  
5 .INCLUDE       0   0   Portfolio object key attributes  
6 EXTERNAL_ID /RPM/TV_EXTID   CHAR 24   0   Business Object ID  
7 PORTFOLIO_GUID /RPM/TV_GUID   RAW 16   0   Guid for application objects  
8 PARENT_GUID /RPM/TV_GUID   RAW 16   0   Guid for application objects  
9 PROJ_DESCRIPTION RPM_TV_PROJ_DESCRIPTION TEXT40 CHAR 40   0   Item Name  
10 CHANGED_BY /RPM/TV_CHANGED_BY XUBNAME CHAR 12   0   Changed by user *
11 RPM_CHANGED_ON /RPM/TV_TIMESTAMP /RPM/TD_BCOS_TSTMP DEC 15   0   TimeStamp  
12 ITEM_TYPE /RPM/TV_ITEM_ID /RPM/TD_ITEM_TYPE CHAR 15   0   Type /RPM/ITEM_TYPE
13 .INCLUDE       0   0   Externally Modifiable Item Template Attributes  
14 FORECAST_START RPM_TV_FORECAST_START DATS DATS 8   0   Forecasted Start  
15 PLANNED_START RPM_TV_PLAN_START DATS DATS 8   0   Planned Start Date  
16 ACTUAL_START RPM_TV_ACTUAL_START   DATS 8   0   Actual Start Date  
17 FORECAST_FINISH RPM_TV_FORECAST_FINISH DATS DATS 8   0   Forecasted Finish Date  
18 PLANNED_FINISH RPM_TV_PLAN_FINISH DATS DATS 8   0   Planned Finish Date  
19 ACTUAL_FINISH RPM_TV_ACTUAL_FINISH   DATS 8   0   Actual Finish Date  
20 CATEGORY RPM_PROJECT_CATEGORY RPM_PROJECT_CATEGORY NUMC 4   0   Category RPM_PROJ_CAT
21 SUBCATEGORY RPM_PROJ_SUBCATEGORY RPM_SUBCATEGORY NUMC 4   0   Subcategory RPM_PROJ_SUBCAT
22 PTYPE RPM_PROJECTTYPE RPM_PROJECTTYPE NUMC 4   0   Group RPM_PROJ_TYPE
23 TTYPE RPM_PROJECT_TECHTYPE RPM_PROJECT_TECHTYPE NUMC 4   0   Technology Type RPM_PROJ_TTYPE
24 RISKA RPM_PROJECT_RISK_ASSESED NUMC3 NUMC 3   0   Assessed Project Risk  
25 PROBT RPM_PROJECT_PROB_TECH NUMC3 NUMC 3   0   Probability of Technical Success  
26 PROBC RPM_PROJECT_PROB_COMM NUMC3 NUMC 3   0   Probability of Commercial Success  
27 CURRENCY RPM_TV_CURRENCY WAERS CUKY 5   0   Currency key /RPM/CURRENCY
28 PERIODTYPE /RPM/TV_PERIOD_TYPE /RPM/TD_PERIOD_TYPE NUMC 2   0   Financial Period Breakdown /RPM/PERIOD_TYPE
29 UNIT /RPM/TV_TIME_UNIT MEINS UNIT 3   0   Time Unit /RPM/CAP_UNITS
30 ESCALATION RPM_TV_ESCALATION XFELD CHAR 1   0   Escalation Flag  
31 COSTD RPM_PROJECT_COST_DEVELOPMENT /RPM/CURR_16_2 CURR 16   2   Development Cost  
32 COSTL RPM_PROJECT_COST_LAUNCH /RPM/CURR_16_2 CURR 16   2   Launch Cost  
33 NPV RPM_PROJECT_NPV /RPM/CURR_16_2 CURR 16   2   Net Present Value (manual)  
34 PRIORITY_GROUP RPM_PRIORITY_GROUP RPM_PRIORITY_GROUP NUMC 2   0   Priority Group RPM_PROJ_PRGRP
35 CAP_PERIODTYPE /RPM/TV_CAP_PERIOD_TYPE /RPM/TD_PERIOD_TYPE NUMC 2   0   Capacity Period Breakdown /RPM/PERIOD_TYPE
36 HEADC /RPM/PROJECT_HEADCOUNT /RPM/DEC_10_2 DEC 10   2   Headcount  
37 DISCOUNT_RATE /RPM/TV_DISCOUNT_RATE /RPM/DEC_5_2 DEC 5   2   Discount Rate  
38 LOCATION DPR_TV_LOCATION DPR_LOCATION CHAR 4   0   Location DPR_LOCATION
39 GEOGRAPHY DPR_TV_AREA DPR_AREA CHAR 4   0   Area DPR_AREA
40 STATUS /RPM/TV_TEMPLATE_STATUS /RPM/TD_TEMPLATE_STATUS CHAR 5   0   Template Status  
41 FRCST_BGT_TOTAL /RPM/TV_FORECASTED_BUDGT_TOTAL /RPM/CURR_16_2 CURR 16   2   Portfolio Item Forecasted Budget Total  
42 FRCST_BGTANNUAL /RPM/TV_FORECASTED_BUDGT_ANNL /RPM/CURR_16_2 CURR 16   2   Portfolio Item Forecasted Budget Annual  
43 FRCST_COSTTOTAL /RPM/TV_FORECASTED_COST_TOTAL /RPM/CURR_16_2 CURR 16   2   Portfolio Item Forecasted Cost Total  
44 FRCST_COST_YTD /RPM/TV_FORECASTED_COST_YTD /RPM/CURR_16_2 CURR 16   2   Portfolio Item Forecasted Cost YTD  
45 IS_GLOBAL /RPM/TV_IS_GLOBAL XFELD CHAR 1   0   Global Template  
46 CPRO_TEMPLATE_ID DPR_TV_PROJECT_ID CGPL_EXTID CHAR 24   0   Project Number  
47 WORKEFFORT_TOTAL /RPM/TV_WORK_EFFORT_TOTAL /RPM/DEC_26_2 DEC 26   2   Actual Effort  
48 WORKEFFORT_YTD /RPM/TV_WORK_EFFORT_YTD /RPM/DEC_26_2 DEC 26   2   Actual Work Effort Year-To-Date  
49 PLANNED_EFFORT /RPM/TV_PLAN_EFFORT /RPM/DEC_26_2 DEC 26   2   Planned Effort  
50 PLANNED_EFFORT_YTD /RPM/TV_PLAN_EFFORT_YTD /RPM/DEC_26_2 DEC 26   2   Planned Effort Year-To-Date  
51 .INCLUDE       0   0   Item Template Non Modifiable Attributes  
52 RISK_GROUP RPM_RISK_GROUP RPM_RISK_GROUP NUMC 2   0   Risk Group Assessed *
53 RISK_GROUP_D RPM_RISK_GROUP RPM_RISK_GROUP NUMC 2   0   Risk Group Assessed *
54 DERIVED_RISK RPM_TV_RISK_DERIVED NUMC3 NUMC 3   0   Derived Risk  
55 BEGDA_DEM /RPM/TV_PP_START_DEM DATUM DATS 8   0   Demand Planning Start  
56 ENDDA_DEM /RPM/TV_PP_END_DEM DATUM DATS 8   0   Demand Planning Period Finish Date  
57 BEGDA_FIN /RPM/TV_PP_START_FIN DATUM DATS 8   0   Financial Planning Period Start  
58 ENDDA_FIN /RPM/TV_PP_END_FIN DATUM DATS 8   0   Financial Plan Period Finish Date  
59 PROPOSAL /RPM/TV_PROPOSAL XFELD CHAR 1   0   Proposal  
60 BUCKET_NAME /RPM/TV_BUCKET_NAME TEXT40 CHAR 40   0   Bucket Name  
61 BUCKET_ID /RPM/TV_BUCKET_ID   CHAR 24   0   Bucket ID  
62 .INCLUDE       0   0   Item Detail Customer Fields  
63 EA_DUMMY /RPM/TV_EA_DUMMY CHAR1 CHAR 1   0   Dummy Data Element for Enhanced xRPM Attributes  
64 .INCLUDE       0   0    
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 /RPM/TS_TEMPLATE_D_API CAP_PERIODTYPE /RPM/PERIOD_TYPE PERIODTYPE KEY 1 CN
2 /RPM/TS_TEMPLATE_D_API CATEGORY RPM_PROJ_CAT CATEGORY REF 1 CN
3 /RPM/TS_TEMPLATE_D_API CURRENCY /RPM/CURRENCY CURRENCY REF 1 CN
4 /RPM/TS_TEMPLATE_D_API GEOGRAPHY DPR_AREA AREA REF 1 CN
5 /RPM/TS_TEMPLATE_D_API ITEM_TYPE /RPM/ITEM_TYPE ITEM_TYPE KEY 1 CN
6 /RPM/TS_TEMPLATE_D_API LOCATION DPR_LOCATION LOCATION REF 1 CN
7 /RPM/TS_TEMPLATE_D_API PERIODTYPE /RPM/PERIOD_TYPE PERIODTYPE KEY 1 CN
8 /RPM/TS_TEMPLATE_D_API PRIORITY_GROUP RPM_PROJ_PRGRP PRIORITY_GROUP KEY 1 CN
9 /RPM/TS_TEMPLATE_D_API PTYPE RPM_PROJ_TYPE PTYPE KEY 1 CN
10 /RPM/TS_TEMPLATE_D_API SUBCATEGORY RPM_PROJ_SUBCAT SUBCATEGORY REF 1 CN
11 /RPM/TS_TEMPLATE_D_API TTYPE RPM_PROJ_TTYPE TTYPE REF 1 CN
12 /RPM/TS_TEMPLATE_D_API UNIT /RPM/CAP_UNITS UNIT REF    
History
Last changed by/on SAP  20141109 
SAP Release Created in 450