| # Archive Projects (tppdm7820m000) Path:// Project / Project Definition / Project Data / Archive Projects Session objective In LN Project, you can use the Archive Projects (tppdm7820m000) session to delete projects or archive projects to an archive company. How to use this session Select the projects you want to archive. You can make a choice as to what type of data must be archived. If you selected the Archive & Delete run type, the Delete Projects (tppdm7810m000) session will be started after the archive process has been completed. General Project data You can archive all required master data (non-transactional data) for project, so that transaction data in the archive company can be used for reporting. A separate option allows you to archive all project specific master data only once, therefore reducing the overhead of transferring the general project master data in the subsequent archive run until there are new changes or additions. Note All entities listed in the following table can insert and update the data in the archive company. To archive and delete tables, select the General Project Data check box. Prerequisites Before you can archive a project, it must have the status Closed, and the financial result of the project must be determined. To do this, complete the following steps: In the Project Status (tppdm6107s000) session, change the status of the project to Finished. Change the financial result status to Determine Result. In the Process Transactions (tpppc4802m000) session, select the Final Result check box; and optionally select: Interim Result WIP Balance Click Process. After you run this session, the project status is Closed and the financial result status is Result Determined. A project can also be archived when its status is Free. Note The first time you archive a project, you must also archive the general data. If texts are linked to the data in the tables that must be archived (for projects), a default text group must be defined for the user in the archive project.
Companies | ttccom000 | Archive
Employees | ttccom001 | Archive
Business Partners | ttccom100 | Archive
Sold-to Business Partners | ttccom110 | Archive
Ship-to Business Partners | ttccom111 | Archive
List Groups | ttcibd301 | Archive
Business Partner Types | ttcmcs029 | Archive
Channels | ttcmcs066 | Archive
Priorities | ttcmcs070 | Archive
Invoice-to Business Partners | ttccom112 | Archive
Addresses | ttccom130 | Archive
Contacts by Business Partner | ttccom145 | Archive
Buy-from Business Partners | ttccom120 | Archive
Ship-from Business Partners | ttccom121 | Archive
Invoice-from Business Partners | ttccom122 | Archive
Units | ttcmcs001 | Archive
Currencies | ttcmcs002 | Archive
Warehouses | ttcmcs003 | Archive
Routes | ttcmcs004 | Archive
Reasons | ttcmcs005 | Archive
Units by Language | ttcmcs007 | Archive
Countries | ttcmcs010 | Archive
Late Payment Surcharges | ttcmcs011 | Archive
Terms of Payment | ttcmcs013 | Archive
Product Types | ttcmcs015 | Archive
Seasonal Patterns | ttcmcs016 | Archive
Item Signals | ttcmcs018 | Archive
Titles | ttcmcs019 | Archive
Selection Codes | ttcmcs022 | Archive
Item Groups | ttcmcs023 | Archive
Price Groups | ttcmcs024 | Archive
Lines of Business | ttcmcs031 | Archive
Single Tax Rates | ttcmcs032 | Archive
Price Lists | ttcmcs034 | Archive
Tax Codes by Country | ttcmcs036 | Archive
Tax Codes | ttcmcs037 | Archive
Signals | ttcmcs039 | Archive
Terms of Delivery | ttcmcs041 | Archive
Statistics Groups | ttcmcs044 | Archive
Areas | ttcmcs045 | Archive
Languages | ttcmcs046 | Archive
Rounding Codes | ttcmcs053 | Archive
Invoicing Methods | ttcmcs055 | Archive
Carriers | ttcmcs080 | Archive
Parameters | ttcmcs095 | Archive
Statuses | ttcmcs096 | Archive
General Project Parameters | tppdm000 | Archive
Parameters Project Production Control | tpppc000 | Archive
Project Planning Parameters | tppss000 | Archive
Project Budgeting Parameters | tpptc000 | Archive
Item Project Data | tppdm005 | Archive
Item Project Data (Defaults) | tppdm006 | Archive
Labor | tppdm015 | Archive
Trade Groups | tppdm016 | Archive
Equipment | tppdm025 | Archive
Subcontracting | tppdm035 | Archive
Sundry Costs | tppdm040 | Archive
Revenues | tppdm043 | Archive
Third Party Types | tppdm045 | Archive
Third Parties | tppdm046 | Archive
Responsibilities | tppdm048 | Archive
Employees by Responsibility | tppdm049 | Archive
Competitors | tppdm051 | Archive
Appointment Types | tppdm053 | Archive
Business Sector | tppdm055 | Archive
Sufferance Tax | tppdm057 | Archive
Financing Methods | tppdm059 | Archive
Project Acquiring Methods | tppdm063 | Archive
Project Groups | tppdm065 | Archive
Document Types | tppdm069 | Archive
Categories | tppdm075 | Archive
Phases | tppdm085 | Archive
Standard Elements | tppdm090 | Archive
User Defined Structures | tppdm095 | Archive
User Defined Structure Elements | tppdm096 | Archive
Standard Activities | tppdm110 | Archive
Revenue Codes of Standard Activities | tppdm139 | Archive
Revenue Codes for Progress Invoicing Activities | tppdm140 | Archive
Revenue Codes of Standard Elements | tppdm141 | Archive
Revenue Codes of Progress Invoicing Elements | tppdm142 | Archive
Revenue Codes Cost Plus (General and by Cost Type) | tppdm143 | Archive
Revenue Codes Cost Plus (Material) | tppdm144 | Archive
Revenue Codes Cost Plus (Labor) | tppdm145 | Archive
Revenue Codes Cost Plus (Equipment) | tppdm146 | Archive
Revenue Codes Cost Plus (Subcontracting) | tppdm147 | Archive
Revenue Codes Cost Plus (Sundry Costs) | tppdm148 | Archive
Price Fluctuations | tppdm151 | Archive
Index Tables of Price Fluctuations | tppdm152 | Archive
Index Tables of Material Price Fluctuations | tppdm153 | Archive
Financial Result Types | tpdm155 | Archive
Standard Surcharges (General and by Cost Type) | tppdm170 | Archive
Standard Surcharges by Cost Component | tppdm171 | Archive
Standard Surcharges by Material | tppdm172 | Archive
Standard Surcharges by Labor | tppdm173 | Archive
Standard Surcharges by Equipment | tppdm174 | Archive
Standard Surcharges by Subcontracting | tppdm175 | Archive
Standard Surcharges by Sundry Cost | tppdm176 | Archive
Standard Surcharges by Revenue | tppdm177 | Archive
Project Template | tppdm500 | Archive
Project Data Template | tppdm501 | Archive
Element Relations Template | tppdm502 | Archive
Activity Relations Template | tppdm503 | Archive
Buy-from Items | tppdm750 | Archive
Buy-from Diskette Layouts | tppdm751 | Archive
Discount Groups by Buy-from | tppdm752 | Archive
Units by Buy-from | tppdm754 | Archive
Items by Buy-from's Discount Group | tppdm758 | Archive
Archived Projects | tppdm790 | Archive
Employee Project Data | tppdm801 | Archive
Project definition data You can archive all project specific non-transaction data. To archive and delete tables, select the Project General Data check box.
Project | tppdm600 | Archive/Delete
Cost Control Levels by Project | tppdm601 | Archive/Delete
Contracts by Project Item | tppdm606 | Archive/Delete
Contracts by Project Price Group | tppdm607 | Archive/Delete
Project Labor | tppdm615 | Archive/Delete
Project Equipment | tppdm625 | Archive/Delete
Project Subcontracting | tppdm635 | Archive/Delete
Project Sundry Cost Codes | tppdm640 | Archive/Delete
Project Revenues | tppdm643 | Archive/Delete
Third Parties by Project | tppdm646 | Archive/Delete
Employees Responsible by Project | tppdm649 | Archive/Delete
Project Relations PCS | tppdm650 | Archive/Delete
Appointments by Project | tppdm653 | Archive/Delete
Project Documents | tppdm669 | Archive/Delete
Project Business Partners | tppdm740 | Archive/Delete
Contract Amounts by Business Partner | tppdm741 | Archive/Delete
Locations by Project | tppdm742 | Archive/Delete
Labor Rates by Project and Business Partner | tcppl092 | Delete
Project Items | tcibd001 | Delete
Estimating data You can archive all data related to the estimating phase of the project. To archive and delete tables, select the Project Estimating Data check box.
User Defined Statuses by Estimate Version | tpest087 | Archive/Delete
Estimate Versions | tpest100 | Archive/Delete
Estimate Structures | tpest110 | Archive/Delete
Structural Elements | tpest120 | Archive/Delete
Estimate Lines | tpest200 | Archive/Delete
Totals by Primary Structure | tpest210 | Archive/Delete
Bid Header | tpest300 | Archive/Delete
Bid Lines | tpest310 | Archive/Delete
Budgeting data You can archive and delete budget transaction data, including element, activity, extension, element and activity budget, top-down budget data, and budget surcharges. Budget cost analysis details breakups entities are not archived. To view the budget cost analysis splitup, after archiving, perform the generate budget cost analysis in the archive company.
Project Budget Parameters (PTC) | tpptc000 | Archive/Delete
Cost Surcharges by Project | tpptc030 | Archive/Delete
Cost Surcharges by Cost Type | tpptc031 | Archive/Delete
Cost Surcharges by Cost Component | tpptc032 | Archive/Delete
Cost Surcharges by Item | tpptc040 | Archive/Delete
Cost Surcharges by Labor | tpptc041 | Archive/Delete
Cost Surcharges by Equipment | tpptc042 | Archive/Delete
Cost Surcharges by Subcontracting | tpptc043 | Archive/Delete
Cost Surcharges by Sundry Cost Code | tpptc044 | Archive/Delete
Extensions | tpptc050 | Archive/Delete
Budget Adjustments | tpptc070 | Archive/Delete
Budget Adjustment Detail Lines | tpptc071 | Archive/Delete
Elements | tpptc100 | Archive
Element Relations | tpptc101 | Archive
Auxiliary Table to Display Budget Structure | tpptc109 | Archive
Material Budget Lines | tpptc120 | Archive/Delete
Control Data Material Lines | tpptc127 | Archive/Delete
Control Data Material Lines for Physical Progress | tpptc128 | Archive/Delete
Labor Budget Lines | tpptc130 | Archive/Delete
Control Data Labor Lines | tpptc137 | Archive/Delete
Control Data Labor Lines for Physical Progress | tpptc138 | Archive/Delete
Equipment Budget Lines | tpptc140 | Archive/Delete
Control Data Equipment Lines | tpptc147 | Archive/Delete
Control Data Equipment Lines for Physical Progress | tpptc148 | Archive/Delete
Subcontracting Budget Lines | tpptc150 | Archive/Delete
Control Data Subcontracting Lines | tpptc157 | Archive/Delete
Control Data Subcontracting Lines for Physical Progress | tpptc158 | Archive/Delete
Sundry Costs Budget Lines | tpptc160 | Archive/Delete
Control Data Sundry Costs Lines | tpptc167 | Archive/Delete
Control Data Sundry Costs Lines for Physical Progress | tpptc168 | Archive/Delete
Material Budget Lines by Activity | tpptc220 | Archive/Delete
Labor Budget Lines by Activity | tpptc230 | Archive/Delete
Equipment Budget Lines by Activity | tpptc240 | Archive/Delete
Subcontracting Budget Lines by Activity | tpptc250 | Archive/Delete
Sundry Costs Budget Lines by Activity | tpptc260 | Archive/Delete
Budget Cost Analysis Codes by Project | tpptc300 | Archive/Delete
Budgeted Elements by Cost Type | tpptc305 | Delete
Budgeted Elements by Cost Component | tpptc306 | Delete
Budgeted Cost Surcharges by Element | tpptc307 | Delete
Budgeted Cost Surcharges by Activity | tpptc308 | Delete
Actual Budget by Activity/Cost Type | tpptc315 | Delete
Actual Budget by Activity/Cost Component | tpptc316 | Delete
Actual Budget by Extension / Cost Type | tpptc325 | Delete
Actual Budget by Extension / Cost Component | tpptc326 | Delete
Actual Budget by Extension / Item | tpptc330 | Delete
Actual Budget by Extension / Labor | tpptc331 | Delete
Actual Budget by Extension / Equipment | tpptc332 | Delete
Actual Budget by Extension / Subcontracting | tpptc333 | Delete
Actual Budget by Extension / Sundry Cost | tpptc334 | Delete
Actual Budget by Extension / Material Control Code | tpptc335 | Delete
Actual Budget by Extension / Labor Control Code | tpptc336 | Delete
Actual Budget by Extension / Equipment Control Code | tpptc337 | Delete
Actual Budget by Extension / Subcontracting Control Code | tpptc338 | Delete
Actual Budget by Extension / Sundry Cost Control Code | tpptc339 | Delete
Actual Budget by Cost Type | tpptc340 | Delete
Actual Budget by Cost Component | tpptc341 | Delete
Actual Budget by Item | tpptc345 | Delete
Actual Budget by Labor | tpptc346 | Delete
Actual Budget by Equipment | tpptc347 | Delete
Actual Budget by Subcontracting Code | tpptc348 | Delete
Actual Budget by Sundry Cost Code | tpptc349 | Delete
Actual Budget by Material Control Code | tpptc350 | Delete
Actual Budget by Labor Control Code | tpptc351 | Delete
Actual Budget by Equipment Control Code | tpptc352 | Delete
Actual Budget by Subcontracting Control Code | tpptc353 | Delete
Actual Budget by Sundry Cost Control Code | tpptc354 | Delete
Purchase Budget | tpptc400 | Archive/Delete
Purchase Budget Parts | tpptc410 | Archive/Delete
Purchase Budget Lines | tpptc420 | Archive/Delete
Budget Version | tpptc500 | Archive/Delete
Budget Amounts of Activities by Version | tpptc510 | Archive/Delete
EV Method Related Data | tpptc515 | Archive/Delete
Budget Analysis Code by Project | tpptc520 | Archive/Delete
Time Phased Budget | tpptc521 | Archive/Delete
Budget history You can archive and delete budget history transaction data, including history of budget lines, history of budget surcharges, and element relationship history. Tables are archived or deleted if the Project Budget History Data check box is selected.
History of Cost Surcharges by Project | tpptc035 | Archive/Delete
History of Cost Surcharges by Cost Type | tpptc036 | Archive/Delete
History of Cost Surcharges by Cost Component | tpptc037 | Archive/Delete
History of Cost Surcharges by Material | tpptc045 | Archive/Delete
History of Cost Surcharges by Labor | tpptc046 | Archive/Delete
History of Cost Surcharges by Equipment | tpptc047 | Archive/Delete
History of Cost Surcharges by Subcontracting | tpptc048 | Archive/Delete
History of Cost Surcharges by Sundry | tpptc049 | Archive/Delete
Element Relationship History | tpptc105 | Archive/Delete
History of Material Budget Lines | tpptc125 | Archive/Delete
History of Labor Budget Lines | tpptc135 | Archive/Delete
History of Equipment Budget Lines | tpptc145 | Archive/Delete
History of Subcontracting Budget Lines | tpptc155 | Archive/Delete
History of Sundry Budget Lines | tpptc165 | Archive/Delete
History of Material Budget Lines by Activity | tpptc225 | Archive/Delete
History of Labor Budget Lines by Activity | tpptc235 | Archive/Delete
History of Equipment Budget Lines by Activity | tpptc245 | Archive/Delete
History of Subcontracting Budget Lines by Activity | tpptc255 | Archive/Delete
History of Sundry Cost Budget Lines by Activity | tpptc265 | Archive/Delete
Planning data You can archive and delete project planning transaction data, including activities, baseline, and external schedule links. Tables are archived or deleted if the Project Planning Data check box is selected.
Project Plans | tppss010 | Archive
Baseline | tppss020 | Archive
Activity Relationships | tppss210 | Archive
Activities | tppss200 | Archive
Activity Baseline | tppss220 | Archive/Delete
External Schedule Links | tppss230 | Archive/Delete
Material Budget lines [Activities] | tpptc220 | Archive
Labor Budget lines [Activities] | tpptc230 | Archive
Equipment Budget lines [Activities] | tpptc240 | Archive
Subcontracting Budget lines [Activities] | tpptc250 | Archive
Sundry Budget Lines [Activities] | tpptc260 | Archive
Project Extensions | tpptc050 | Archive
Elements | tpptc100 | Archive
Locations by Project | tppdm742 | Archive
Cost registration You can archive and delete cost transaction data, including cost and commitment history, progress, forecast, invoicing, and interim result data. Build actual cost control and performance measurement details breakups entities are not archived. To have the project monitoring and performance measurement details, after archiving, perform the build actual cost control and generate performance measurement in the archive company. Tables are archived or deleted if the Project Cost Registration Data check box is selected.
Advance Payment Requests | tppin010 | Archive/Delete
Settled Advance Payment Request lines | tppin011 | Archive/Delete
Installments | tppin020 | Archive/Delete
Progress Invoice Specifications | tppin030 | Archive/Delete
Holdback | tppin040 | Archive/Delete
Transferred Unit Rate Invoice Lines | tppin050 | Archive/Delete
Invoice Text by Document | tppin105 | Archive/Delete
Processing Runs | tpppc005 | Archive/Delete
Messages for Approve and Posting | tpppc007 | Archive/Delete
Physical Progress by Element / Material | tpppc110 | Archive/Delete
Physical Progress by Element / Labor | tpppc111 | Archive/Delete
Physical Progress by Element / Equipment | tpppc112 | Archive/Delete
Physical Progress by Element / Subcontracting | tpppc113 | Archive/Delete
Physical Progress by Element / Sundry Cost | tpppc115 | Archive/Delete
Physical Progress by Element/Cost Type | tpppc116 | Archive/Delete
Physical Progress by Activity / Material | tpppc120 | Archive/Delete
Physical Progress by Activity / Labor | tpppc121 | Archive/Delete
Physical Progress by Activity / Equipment | tpppc122 | Archive/Delete
Physical Progress by Activity / Subcontracting | tpppc123 | Archive/Delete
Physical Progress by Activity / Sundry Cost | tpppc124 | Archive/Delete
Physical Progress by Activity / Cost Type | tpppc126 | Archive/Delete
Physical Progress by Extension / Material | tpppc130 | Archive/Delete
Physical Progress by Extension / Labor | tpppc131 | Archive/Delete
Physical Progress by Extension / Equipment | tpppc132 | Archive/Delete
Physical Progress by Extension / Subcontracting | tpppc133 | Archive/Delete
Physical Progress by Extension / Sundry Cost | tpppc134 | Archive/Delete
Physical Progress by Extension/Cost Type | tpppc136 | Archive/Delete
Element Physical Progress | tpppc150 | Archive/Delete
Activity Physical Progress | tpppc160 | Archive/Delete
Material Cost History | tpppc215 | Archive/Delete
Material Cost Forecast | tpppc216 | Archive/Delete
Cost Forecast by Activity/Cost type | tpppc226 | Archive/Delete
Labor Cost History | tpppc235 | Archive/Delete
Labor Cost Forecast | tpppc236 | Archive/Delete
Equipment Cost History | tpppc255 | Archive/Delete
Equipment Cost Forecast | tpppc256 | Archive/Delete
Cost Surcharges by Material | tpppc260 | Archive/Delete
Cost Surcharges Labor | tpppc261 | Archive/Delete
Cost Surcharges by Equipment | tpppc262 | Archive/Delete
Cost Surcharges by Subcontracting | tpppc263 | Archive/Delete
Cost Surcharges by Sundry Cost | tpppc264 | Archive/Delete
Revenue Surcharges by Revenue Code | tpppc265 | Archive/Delete
Subcontracting Cost History | tpppc275 | Archive/Delete
Subcontracting Cost Forecast | tpppc276 | Archive/Delete
Cost Surcharges by Project | tpppc280 | Archive/Delete
Cost Surcharges by Cost Type | tpppc281 | Archive/Delete
Cost Surcharges by Cost Component | tpppc282 | Archive/Delete
Revenue Surcharges by Project | tpppc285 | Archive/Delete
Revenue Surcharges by Cost Component | tpppc286 | Archive/Delete
Sundry Cost History | tpppc295 | Archive/Delete
Sundry Cost Forecast | tpppc296 | Archive/Delete
Revenue History | tpppc305 | Archive/Delete
Forecast Extra Revenues | tpppc306 | Archive/Delete
Price-Fluctuation Settlements by Project | tpppc320 | Archive/Delete
Structural Materials to be Settled by Project | tpppc330 | Archive/Delete
Items to be Settled by Element | tpppc332 | Archive/Delete
Material Quantities to be Settled | tpppc340 | Archive/Delete
Labor Quantities to be Settled | tpppc341 | Archive/Delete
Equipment Quantities to be Settled | tpppc342 | Archive/Delete
Subcontracting Quantities to be Settled | tpppc343 | Archive/Delete
Sundry-Cost Quantities to be Settled | tpppc344 | Archive/Delete
Financial Interim Results | tpppc350 | Archive/Delete
Cost Control by Project | tpppc400 | Delete
Cost Control by Project/Cost Type | tpppc401 | Delete
Cost Control by Project/Cost Component | tpppc402 | Delete
Cost Control by Project / Material Control Code | tpppc410 | Delete
Cost Control by Project / Labor Control Code | tpppc411 | Delete
Cost Control by Project / Equipment Control Code | tpppc412 | Delete
Cost Control by Project / Subcontracting Control Code | tpppc413 | Delete
Cost Control by Project / Sundry Cost Control Code | tpppc414 | Delete
Cost Control by Project / Element | tpppc420 | Delete
Cost Control by Project/Element/Cost Type | tpppc421 | Delete
Cost Control by Project / Element / Cost Component | tpppc422 | Delete
Cost Control by Project / Element / Material Control Code | tpppc430 | Delete
Cost Control by Project / Element / Labor Control Code | tpppc431 | Delete
Cost Control by Project / Element / Equipment Control Code | tpppc432 | Delete
Cost Control by Project / Element / Subcontracting Control Code | tpppc433 | Delete
Cost Control by Project / Element / Sundry Cost Control Code | tpppc434 | Delete
Cost Control by Project / Activity | tpppc440 | Delete
Cost Control by Project/Activity/Cost Type | tpppc441 | Delete
Cost Control by Project / Activity / Cost Component | tpppc442 | Delete
Cost Control by Project / Activity / Material Control Code | tpppc450 | Delete
Cost Control by Project / Activity / Labor Control Code | tpppc451 | Delete
Cost Control by Project / Activity / Equipment Control Code | tpppc452 | Delete
Cost Control by Project / Activity / Subcontracting Control | tpppc453 | Delete
Cost Control by Project / Activity / Sundry Cost Control Code | tpppc454 | Delete
Cost Control by Project / Extension | tpppc470 | Delete
Cost Control by Project/Extension/Cost Type | tpppc471 | Delete
Cost Control by Project / Extension / Cost Component | tpppc472 | Delete
Cost Control by Project / Extension / Material Control Code | tpppc475 | Delete
Cost Control by Project / Extension / Labor Control Code | tpppc476 | Delete
Cost Control by Project / Extension / Equipment Control Code | tpppc477 | Delete
Cost Control by Project / Extension / Subcontracting Control | tpppc478 | Delete
Cost Control by Project / Extension / Sundry Cost Control Co | tpppc479 | Delete
Performance-Measurement Generate Codes | tpppc500 | Archive/Delete
Performance Measurement Activity | tpppc540 | Delete
Performance Measurement Activity/Cost Type | tpppc541 | Delete
Performance Measurement OBS | tpppc560 | Delete
Performance Measurement OBS / Cost Type | tpppc561 | Delete