Define Templates for Data Screens

Use

For the construction progress report and valuation you use MS Excel for the input and output screen. The structure of the data screens (input and output screens) is defined in the templates. You can adjust the structure to suit your customer-specific requirements. To be able to use templates, you must store them in the Business Document Service. In Customizing assign the templates to the appropriate transactions for the Construction Progress Report and Remaining Plan, for example, define which template is used for which controlling area.

Sample templates are delivered as input and output screens for the construction progress report and remaining plan. You can edit these templates to suit your requirements. You can find the sample templates in the Business Document Service.

Caution Caution

Sample templates are not intended for live implementation and are not maintained by SAP.

End of the caution.

Prerequisites

If you want to use sample template you must do the following:

Install Microsoft Excel 2000
Define the following cost element groups under Define Cost Elements for Work Values and Planning Data :

1Main contract
2Hourly wage
3From third party
4Invoice deduction

5Planned revenues
6Planned costs

Procedure

You store documents that you want to use as templates in the SAP system database using the Business Document Navigator (BDN).

The BDN is available centrally via menu path Office Business Documents Documents Search (transaction OAOR). It can also be reached via the administration menu for Business Documents: Tools Business Documents Miscellaneous Business Documents (Transaction OAER).

Start of the navigation path In Customizing for Project System under Revenues and Earnings Next navigation step Automatic and Periodic Allocations Construction Progress Report and Valuation Assign Templates (BDS Documents) for Construction Progress Report End of the navigation path , define the template for the construction progress reports that are to be used for communication with the SAP System.In doing so you assign each a BDS document to the combination of controlling area and project profile.

If you use the sample templates, enter the following data for the BDS document:

Creating and Changing Construction Progress Reports	Name	ALVLAYOUTTEMPLATES
	Class type	Other objects
	Activity	Create/change
	ID	BDS_LOC16 3D8CA39E8CD7544EB41426F393EE46A5
	Start macro	SHEET1.START
Displaying Construction Progress Reports	Name	ALVLAYOUTTEMPLATES
	Class type	Other objects
	Activity	Display
	ID	BDS_LOC16 6926A4B748711841B41263DBFCFF9D94
	Start macro	SHEET1.START

In Customizing for Project System, define the template for the remaining plan under Start of the navigation path Revenues and Earnings Next navigation step Automatic and Periodic Allocations Construction Progress Report and Valuation Assign Templates (BDS Documents) for Planning Data End of the navigation path .In doing so you assign a BDS document to the combination of controlling area, language and project profile.

If you use the sample template, enter the following data for the BDS document:

Remaining Plan	Name	ALVLAYOUTTEMPLATES
	Class type	Other objects
	Activity
	ID	BDS_LOC16 72A39C64F2008B47AF3C7D69444BEC3F
	Start macro	SHEET1.START