Tuesday, April 30, 2013

Some Important PS Terms

Project Definition

Project Definition is general description of the project that you want to manage. It is a framework laid down for all the objects created within a project. It contains organizational data that is binding for the entire project.

Work Breakdown Structure (WBS)

WBS is a hierarchical model of the tasks to be performed in the project. It provides overview of the project and forms basis for the project organization and coordination.It shows work, time and money spent on the project. You can use it to plan dates & costs and allocate budget. The Work Breakdown Structure can be displayed according to:
                            · Phase
                            · Function
                            · Object
Individual tasks required to carry out the project is called WBS elements.

Network

The network describes project processing. Thus the Network contains instructions on how to carry out activities in a specific way, in a specific order and in a specific time period.Main elements of network are activities and relationships. It forms the basis for planning, analyzing and monitoring time schedules, costs, & resources.

Activities

Activities are used to plan project staffing, capacity, material, PRTs, and service requirements. When activities are assigned to WBS elements, detailed view of costs, dates, and capacities at WBS element could be obtained. It’s a task in a network which has a defined start and finish. An activity can be broken down into activity elements.Three categories of activities in the Project System:·
                               · Internal Activities 
                               · External Activities
                               · General Cost Activities

Activity element

Activity element is an activity which is subordinate to another activity. Activity elements contain the same information as activities.Three categories of activity elements in the Project System:
                               · Work elements
                               · External Elements
                               · General Cost Elements

Activity Type

It’s a physical measure of activity output of a cost center .e.g. hours, number of units produced, machine times, production times.

Milestones

Milestones are the events in the project to which particular importance is attached Or which trigger predefined functions. In general they indicate transition between different departments or phases. Milestones are assigned to activities and WBS elements:In PS milestones are used to:
               · Trigger predefined functions in network activities.
               · Carry out earned value analysis.
               · Determine dates in billing plan for sales orders.

Relationships

You use relationships to depict chronological and technical dependencies between activities. The relationship determines the nature of the link between the individual activities. :
              · FS Relationship : An activity does not start until the preceding activity is completed.
              · SS Relationship : An activity can not start unless another activity has started.
              · FF Relationship : An activity can not be completed until another activity has been completed.
              · SF Relationship : An activity can not be completed until another succeeding activity has stared.

Confirmations

It is a part of network control. It documents the state of processing for the network activities and activity elements. There are two types of confirmations Partial & Final.Confirmations are used to record:
            · The work center where the activity was carried out.
            · The person who carried out this activity.
            · The yield and scrap produced in an activity.
            · The actual values for the duration and dates.

Settlement

As a rule, projects are used to collect and monitor costs, but are not usually the final cost object. For this reason the costs in atypical project will be settled at the end of the period.To this end, you store settlement rules in the activity / WBS element requiring settlement. They contain information on settlement receivers, cost apportionment and control data. Settlement receivers could be cost centers, G/L accounts. Etc.

Budget

The budget is the approved cost structure for an action or project in a particular period.Budgeting differs from cost plan in that it is binding. In the approval phase you prescribe your project funds in the form of budget. It is possible to allocate overall and annual budget in parallel.

Work Centers

Work center represents the resources responsible for executing an activity. In a work center, you can enter the available capacity and an operating time. You can arrange the work centers in a hierarchy for capacity evaluation purposes. Internal activities are assigned to work centers (resources) to be completed.A work center is a physical unit within a company where an activity is performed.

Profit Center

It is subdivision of business organization which is set up for internal management control purposes. Profit centers divide business up on a management basis. The basic aim of profit center accounting is to present areas of the business as entities operating independently in the market.

Budget in Project System

Budget: Amount of resources allocated under a particular head in a financial year.

Budget Control: Having/ creating a control on the resources allocated in a financial year.

Original Budget: The initial budget that you have allocated to a WBS element.

Supplement of Budget: One time/ discrete increment in the original budget.

Return of Budget: Taking out the un-utilized portion of the budget.

Transfer of Budget: Transferring the budget among two or more expense heads.

Project Definition: A framework for a business undertaking with a fixed goal to achieve with given resources. The project definition contains dates and organizational information that are binding for the entire project. WBS Element: Individual structural element in a work breakdown structure (WBS) representing the hierarchical organization of an R/3 project. Describes either a concrete task or a partial one that can be further subdivided.

Proposed Business Process : Assume there are seven expense heads in maintenance department. There may be addition of expense head in near future. Based on the maintenance heads, maintenance department will create a project in project system. This project will be used for statistical purpose only & will not have any financial implication.

Upon creation of a project, WBS elements will be created as per the expense heads. So for each expense head, there will be one top level WBS element. Again these WBS elements will be divided in twelve WBS elements. These twelve WBS elements represent twelve calendar months. Budget will be allocated to each WBS element & the WBS element will be released from the project.

Maintenance department will create maintenance orders as per their work requirements. These orders will be settled to cost centre, which is maintained in the settlement rule. Also WBS element will have to be mentioned in each order so that the budget control can take place. So as to capture cost from each maintenance order, the WBS element field will be made ?mandatory field? in maintenance order.

So when a maintenance order is released, system will do a budget check against the WBS element mentioned. If the budget check status is OK, order is released or else it will stopped from release. If the order is stopped from release, maintenance department will have to supplement the budget. Upon supplementing, the order is released again & the maintenance cost such as, labour, material costs can be booked on the order. Again the order cost is settled to cost centre & at the same time, budget is consumed from the respective WBS element.

Every year, maintenance department will copy the previous years project so as to save time & efforts to create project & WBS elements. And the maintenance department will assign the budget allocated to each WBS element in a financial year. It is also possible to return the un-utilised budget or, transfer of budget from one WBS element to another. 

- Create a project CJ20N
- Create WBS element CJ20N
- Assign Budget to WBS elementsKO22
- Display assigned Budget KO23
- Supplement Budget KO24
- Display Supplement budget KO25
- Return Budget KO26
- Display Return budget KO27
- Transfer of budget CJ34

Project Functionality in SAP

The Project System module of SAP (PS) is specifically designed to provide comprehensive and fully integrated project management functionality for SAP customers. When it was originally designed and developed its core functionality was borrowed from and shared with the PP and CO modules.

So most of the PS objects (WBS elements, networks, activities, activity elements) are cost objects similar to cost centers in CO, while networks have scheduling and resource management capabilities that are very similar to PP. Whenever you need flexibility and frequent user interaction for resource loaded scheduling activities, you still feel the remnants of an architecture and user interface that was originally designed for the more static context of PP.

Shortcomings include user-friendliness since SAP did not manage to satisfactorily put the end user in control to easily manipulate the data. In that respect, SAP's unsurpassed enterprise functionality often is perceived as an issue by end-users. Also, and somewhat ironically, PS and PP are not seamlessly integrated. This means that costs or dates do not roll up or cannot be pushed down between PS &PP.

What is SAP PS?

Projects are generally part of the internal processes of a company. To be able to control all tasks in project execution, you need an organizational form that is specific to the project and which is shared by all departments involved. Before you can carry out a project in its entirety, the project goals must be precisely described and the project activities to be carried out must be structured. A clear, unambiguous project structure is the basis for successful project planning, monitoring, and control.

The high degree of integration between the Project System (PS) and other R/3 application components means that you can plan, execute, and account for projects as part of your normal commercial procedures. This means the Project System has constant access to data in all the departments involved in the project.

The R/3 PS guarantees close and constant monitoring of all aspects of your project including both technical and commercial aspects of the project.

Project Functionality of SAP-PM (Plant Maintenance)

The SAP Plant Maintenance module (PM) is designed to handle the management and execution of integrated maintenance processes. Such processes include preventative, routine and turnaround maintenance, all fully integrated with purchasing, MRP, controlling and financial accounting performed in SAP. The main objects used in PM are work orders, a series of which (often grouped by revisions) are what typically is thought of as a "project". Such maintenance projects are planned by describing the estimated work effort per "operation" (activity) and work center performing that work effort. By linking operations inside work orders or across them a generic project schedule is created.

Unfortunately SAP-PM has only limited scheduling capabilities. Therefore effective enterprise project scheduling for maintenance purposes requires either the use of the SAP PS module, the integration with external scheduling tools like Primavera or MS Project, or for less complex projects the use of external tools like GWOS (for more information about these tools please search this web site).

The basic master records used by Plant Maintenance are:

- Maintenance Notifications;
- Maintenance Orders;
- Functional Locations;
- Equipments;
- Materials; and
- Work Centers (Resources).

Functional Locations and Equipments contain fields that allow grouping by units, locations, or plant locations.

Project Functionality of SAP-CO (Controlling)

There are several important touchpoints between SAP projects and the SAP Controlling module (CO). All SAP cost planning and budgeting (in SAP terminology: budget = approved cost plan) functions are handled using standard CO functionality. Objects relevant to project management in SAP are cost objects. This means that planned, committed and actual costs can be charged to them like to a cost center or an internal order in CO. Among these cost objects are WBS elements, networks, activities, activity elements, maintenance orders, operations and suboperations.

Costs may be planned on many levels and in many ways, starting as investment management (IM) level or WBS structure level cost planning, through primary cost element planning, and going on to purchase requisitions, planned allocations, planned hourly use of resources with associated standard cost rates, and many more.

Actual costs may be charged to SAP project objects in many ways, typically through goods or service receipts, accounts payable invoices, general ledger (GL) postings, cost allocations or settlements. The SAP system will automatically perform the relevant controlling postings in the background so that CO plan-actual or plan-commitment-actual reports can be run in PS or PM.

Standard costing using standard cost rates associated with work centers (resources) are defined in SAP CO, either internally calculated or manually assigned. This then means that cost center-based controlling transactions have a direct impact on project costing. The moment you say "costs" in SAP, you say "CO" automatically, even when dealing with projects in PS or PM.

Project Functionality of SAP-PP (Production Planning)

Production planning and project management in SAP have many touchpoints. They intersect particularly in a make-to-order environment involving sales-driven projects. In principle there are a lot of similarities between the production planning module (PP) of SAP and the Project System (PS) or even Plant Maintenance (PM). Production orders are very similar to networks or maintenance orders/work orders.

The main difference is that PP deals with ongoing operational aspects while PS and PM deal with projects. Projects are defined as a series of activities with a start and finish date in order to complete clearly specified deliverables at a high quality standard. From that perspective the main conceptual difference to PP is the limitation in time. PP, PS and PM all define a series of tasks, link them through relationships with each other, assign work centers to them to define where and by whom the tasks are supposed to be completed, and then schedule and cost these tasks out.

Even the tools used in SAP are very similar or often the same (like work centers, definition of relationships, resource leveling). This should not be surprising as particularly the PS module, and also to some degree PM, has been built by combining PP and controlling (CO) functionality. It does indeed seem that one reason why project management in SAP often is perceived as not user-friendly is due to that fact. Many of the "logistics" functions of the dynamically changing PS and PM modules are rooted in the much more static PP module. The result is great functional power but often clumsy screens and transactions.

The assignment of internally produced materials (components) to projects in PS or PM reflects another area where these modules intersect. In that case PP provides input to PS or PM, and the timing of this input is synchronized through scheduling and MRP (materials requirements planning) transactions.

There are a number of limitations in the way PP on the one side and PS and PM on the other side interact. At least in the standard SAP R/3 system costs and dates are not naturally rolling up or synchronizing between these modules.

Project Functionality of SAP-SD (Sales & Distribution)

What does Sales and Distribution (SD) functionality have to do with the management of enterprise projects? It does for more companies than may seem obvious at a first glance. For contractors using their own SAP system to manage and deliver capital investment projects the SD module is where the billable deliverables of their projects are defined. The same is true for everybody who uses the SAP project system (PS) to manage the make-to-order production of complex products, whether they are powerplants, aircraft parts, or the concrete bridges.

SAP has functionality that allows to tie reference (template) project structures to product codes so that at the time of sales order creation the setup of a project structure can automatically be triggered. This does then link SD and PS seamlessly, at least on a high level. As the project progresses, milestone billing set up in SAP-PS can then trigger payments in SD, which again results in revenue postings in the SAP financial accounting module (FI). There are a number of other reasons where SD can interact with projects managedf in SAP. Mostly, however, it does so only when you take a comprehensive look at the overall process, trying to ensure full integration. Not doing so may lead to inconsistencies between what sales people or customer relationship personnel sees in SD and the actual status of the delivery of products. One may just consider a situation where SD data from a suppliers' system needs to be tied into a project master schedule managed by a general contractor. To overcome the latter it is helpful to mirror and match purchase orders and sales orders between supplier and customer, also in line with the way the general project is managed.

Project Functionality of SAP-IM (Investment Management)

The potential significance of SAP's Investment Management module (IM) is too often overlooked when considering the management of complex enterprise projects. Nevertheless it should in most cases be considered when designing scalable project management solution that center around SAP.

SAP IM is a tool designed to enable program management in SAP. Program management as defined by SAP in that context means the process of defining a hierarchy on top of many projects with the purpose of planning and controlling costs, including project appropriation management and budget authorizations. Its strongest integration points, besides PS, are with the SAP Controlling (CO) and Asset Management (AM) modules.

While IM was originally developed for the budgeting and high-level management of capital investment initiatives, its functionality has been extended to allow its use for similar functions. It simply is a tool that can perform such functions on top of any kind of PS projects.

Preferred Project Management Tool is...

SAP Project System (PS)
Primavera Enterprise/P3e
Microsoft Project
SAP with Primavera

Difference between SAP PS and PM?

The SAP world makes an important distinction between "PS" and "PM". The acronym "PM" is a source of frequent confusion. For many project management professionals it simply stands for "Project Management", while in the SAP community it is the abbreviation for the "Plant Maintenance" module of SAP.

The SAP PM module was not designed as a project management module. It still contains a lot of components very similar to the SAP PS module, which is the project management module called "Project System". SAP define their modules by function more so than by the process they cover.

The Process Building Blocks for Projects with SAP

Forget about technology and do not pay attention to modules: The key process blocks of Enterprise Projects deal with functional aspects! To set up an effective project management system, these functional aspects need to be clearly defined. If multiple tools are used, responsibilities per functional aspect and project management layer need to be assigned to one tool only, for each layer of the enterprise project (enterprise, project, and contractor).

Key process blocks or functions are:

1. Structures (WBS in SAP-PS)
2. Schedule (Network) 3. Cost Plan (Budgeting)
4. Resources (Work Centers)
5. Actuals / T&E
6. Progress / Completion

SAP Security Tables

Table Description
USR02 Logon data
USR04 User master authorization (one row per user)
UST04 User profiles (multiple rows per user)
USR10 Authorisation profiles (i.e. &_SAP_ALL)
UST10C Composit profiles (i.e. profile has sub profile)
USR11 Text for authorisation profiles
USR12 Authorisation values
USR13 Short text for authorisation
USR40 Tabl for illegal passwords
USGRP User groups
USGRPT Text table for USGRP
USH02 Change history for logon data
USR01 User Master (runtime data)
USER_ADDR Address Data for users
AGR_1016 Name of the activity group profile
AGR_1016B Name of the activity group profile
AGR_1250 Authorization data for the activity group
AGR_1251 Authorization data for the activity group
AGR_1252 Organizational elements for authorizations
AGR_AGRS Roles in Composite Roles
AGR_DEFINE Role definition
AGR_HIER2 Menu structure information - Customer vers
AGR_HIERT Role menu texts
AGR_OBJ Assignment of Menu Nodes to Role
AGR_PROF Profile name for role
AGR_TCDTXT Assignment of roles to Tcodes
AGR_TEXTS File Structure for Hierarchical Menu - Cus
AGR_TIME Time Stamp for Role: Including profile
AGR_USERS Assignment of roles to users
USOBT Relation transaction to authorization object (SAP)
USOBT_C Relation Transaction to Auth. Object (Customer)
USOBX Check table for table USOBT
USOBXFLAGS Temporary table for storing USOBX/T* chang
USOBX_C Check Table for Table USOBT_C

Change Documents in SAP Project

In the Customising for Create Project Profile (OPSA) there are 2 fields for "Change Documents".

Where and how is this useful during implementation?

There are 2 outcomes for change documents and they should both be implemented if it's important that you keep track of changes made to a project:

General changes (the one at the top under Basic data) 

- any field content changes made to a project WBS after it was first saved will be recorded in a file. eg. if you changes the WBS description, the old value and the new value will be recorded, or if you changed a person responsible, it would also be recorded etc. This information can be reviewed in Info Systems report CN60 to old/new values and who/when.

Status Managment (the one under in Status Management) 

- any changes to System and User Status will be recorded, including the status history and who/when. Changes can be seen in any project maintenance transaction (eg. CJ02, CJ20N) by clicking on the "i" icon for a PD or WBS, then following the internal pull-down menu path: Extras>Change Documents> For Status/All.You can then drill-down on the satus to see its history.

Tuesday, April 23, 2013

Understanding Results Analysis for WIP



Understanding Results Analysis Key for Calculating WIP
Introduction and Configuration Guide

Work in process (WIP) inventory forms a part of the working capital or current assets of a firm appearing in their balance sheet. Work in process or progress  are  partially completed goods, parts, or subassemblies that are no longer part of the raw materials inventory and not yet part of the finished products inventory. Fundamental Principle of International Accounting Standard 2 states that Inventories are required to be stated at the lower of cost and net realisable value (NRV).  
 The guidance on measurement of cost of inventories is that, cost should include all:
 a)     costs of purchase (including taxes, transport, and handling) net of trade discounts received
 b)     costs of conversion (including fixed and variable manufacturing overheads) and
 c)     other costs incurred in bringing the inventories to their present location and condition
With SAP, the raw materials gets transferred to finished goods via production orders or process order. In this process, typically, the production order is created to which raw materials are issued, all activities performed in the process are charged along with any overheads that is apporopriate the production order.  Production is ongoing, and it is quite natural that at month end, we end up with some open production orders. SAP in its product costing functionality, provides the feature to calculate the value of WIP. This will be derived based on the careful definition of Line IDs in line with the cost components. The WIP shall be the total debits cost in the order as reduced by the credits for goods receipt.

Key elements of WIP Results Analysis Configuration.

Step 1         Define Results Analysis Key OKG1.
Here you just give a name, four letter key with its description.
Step 2         Create cost elements of type 31 the following minimum
        1.  Valuated Actual cost, say for eg. 990001.
        2. Calculated Costs, say 990002.
        3. WIP account 990003
        4. WIP Reserve 990004
        5. WIP Reserve 990005

Step 3         Define RA version, OKG9, Enable Transfer to Financial Accounting (checkbox)
Under extended control, you may enable checkboxes relating to  
 
  • Generate line items
  • Assignment/RAkey
  • Update / RAkeyEnter the cutoff period for actual RA/WIP, the effective date before which any WIP data if existed, will not be altered.
Step 4         In OKGC, define the valuation method for WIP.
Here, you specify that WIP calculation mode is one when the order has the staus REL.
The calculated WIP shall be cancelled when the order status changes to DLV or TECO. You maintain this data for CO area, RA version and RA key combination.

Step 5        SPRO>Controlling>Product Cost Controlling>Cost Object Controlling>Product cost by order>Period End Closing>Work in process>Define Line IDs.
The line IDs are similar to cost component, that you create during cost estimates like a) 010 for Material b) 020 for Labor and c) 030 for Overhead to say the least. 
Besides these, create one more line ID say 999 for the Settled Cost, which appear as credit when you make a goods receipt.
                 
Create additional WIP type 31 cost elements and their corresponding Reserve account for the above#### WIP Material 990006
        1. WIP Material Reserve 990007
        2. WIP Labor 990008
        3. WIP Labor Reserve 990009
        4. WIP Overhead 990010
        5. WIP Overhead Reserve 990011  
Step 6        Now you assign the source cost elements OKGB, that are expected in the production order to various line ID as created above.
You maintain this data for CO area, RA version and RA key combination.  You use masking when you mention which cost element to be assigned to various IDs. You can also direct various cost element, if it comes with a combination of particular cost center and activity type  to a particular Line ID. If you need to keep it simple, just enter +++++++ for cost centers, activity types and Business processes. Cost elements can be masked as follows; for eg. All cost primray cost elements for materials, if they start from 210001 to 219999, the you can mask them like 00021+++++.   Give the line ID in the column Required to Capitailze.

Step 7       Define the update. OKGA You maintain this data for CO area, RA version and RA key combination.
Here you specify which line IDs are to be grouped under which cost elements and their reserve account. You connect the cost elements created in step 5 to the line IDs. The category for the line IDs for material, labor and overhead shall be K, that stand for cost. The line ID 999 settled cost shall be maintained as category A,  (settled cost). When you assign A, you won't have to maintain any cost elements for WIP and reserve creation.

Step 8       Define posting rules for WIP calculation OKG8
You do this for Controlling area, company code, RA version. Maintain this for RA category WIPR (WIP cost, Required to be capitalized) and RUCR (Reserve for unrealized cost).  You maintain the P& L account (changes to stock)  and the balance sheet (WIP)account.These G/L accounts are posted in Financial Accounting.


Step 9        Ensure number range assignment for the WIP transactions under appropriate head OKG6:
KABG Automat. WIP/results analysis
KABM Manual WIP/results analysis
KSWP Prim. Target Cost Calc. (WIP)
KSWS Sec. Target Cost Calc. (WIP)

Period end WIP calculation Process
The process of running WIP is the t-code KKAX for individual order processing  and KKAO for collective order processing. The system debits the WIP account and credits Inventory Change account. This entire WIP is reversed and a new entry is passed the following month. When the order is fully delivered no additional WIP entries are passed.
Note:
The RA Key shall be entered in the production order, under the control tab. This can be defaulted through order type.

Milestone Billing

Milestone billing means distributing the total amount to be billed over multiple billing dates in the billing plan. As each milestone is successfully reached, the customer is billed either a percentage of the entire project cost or simply a pre-defined amount. During sales order processing, the system determines from the item category whether a billing plan is required and, if so, which type of plan. The type of billing plan that is determined at this point is set up in Customizing and cannot be changed in the sales document. Milestone billing is typically used for billing projects, such as plant engineering and construction projects. Such projects often include a series of milestones that mark the completion of different stages of the work. In the SAP R/3 System, milestones are defined in a network along with planned and actual dates for the completion of work. The milestones are also assigned to the billing dates in the billing plan. Each milestone-related billing date is blocked for processing until the Project System confirms that the milestone is completed.

Configuration required for Milestone Billing Plan:

1) Billing Plan Type:

The billing plan type defines the basic control data for the billing plan. For example, the billing plan contains rules for date determination. These rules determine, for example, the beginning and end dates for the schedule of billing dates. The billing plan type also contains a date rule for determining the horizon for the billing plan. The horizon calculates the last billing date in the billing plan, based on the current date plus a specified time period (for example: today’s date plus one year). The standard version of the SAP R/3 System includes the following billing plan types:
·       Milestone billing: For example, billing dates determined by the percentage of  project completion
·       Periodic billing :For example, monthly fees for a rental contract

 The billing plan type is displayed in the sales document but cannot be changed.

 Sales and distribution -->Billing-->Billing Plan-->Define Billing Plan Types-->Maintain billing plan types for milestone billing-->New Entries 

a)    Create New Billing Plan-->BA
b)    Start date --> 01 (today’s date)
c)    Online order --> Deadlines Created Automatically
d)    FCode-OvervScrn-->0003 (Milestone Billing)

2) Date Description:
Date descriptions are defined to describe the various purposes for which billing plans can be used. Depending on the date category you use, the system proposes a date description for the billing dates in the billing plan. The descriptions are for information purposes only and do not affect processing.

Sales and distribution-->Billing-->Billing Plan-->Define date descriptions-->New Entries

a)    B001 - Signing the Task Order  
b)    B002 - Completion of Clinical Period Of Study
c)    B003 - Completion of Analytical Period Of Study
d)    B004 - After Draft report Submission
e)    B005 - After Final report Submission

3) Date category:

The date category defines data for each billing date that appears in the billing plan.For example, the date category determines the following data:
·         Billing rule: Determines whether the billing date is based on, for example, the percentage of project completion or a monthly periodic payment for a service contract, and so on.
·         Date description: specifies, for example, whether the billing date is for a rental contract, maintenance contract, and so on.
·         Billing block: The billing date may be blocked, for example, if a project milestone has not been confirmed
·         Whether the date is fixed or not: In milestone, you may want the system to use the actual date of the milestone, for example.
·         Billing type: proposes the type of billing document to be used during billing: invoice, pro forma, and so on.

Sales and distribution-->Billing-->Billing Plan-->Define & Assign Date Categories-->Maintain Date Category for Billing Plan Type-->New Entries

a)    Billing Plan Type-->BA
b)    Date category-->BA
c)    Billing rule-->2 (Milestone Billing on Value Basis)
d)    Fixed date-->1 (Planning actual date of Milestone)
e)    Billing block -->AB (Accounts Block)
f)     Billing type-->ZCI

4) Proposed date category:

For every billing plan type, you can assign a date category. During sales order processing, the system then automatically proposes the date category and its corresponding data for each billing date in the plan.

Sales and distribution-->Billing-->Billing Plan-->Define & Assign Date Categories-->Allocated date categories
·         Put date categories against billing plan type

5) Proposed date:

The date proposal function is used only for milestone billing. This function enables you to create a standard billing plan as a reference. This billing plan can be used during order processing. The dates can be used as the basis for an actual billing plan and changed if required.

Sales and distribution-->Billing-->Billing Plan-->Maintain date proposal for billing plan types-->Maintain Date

a)    Start date-->today’s date 
b)    Put Billing date as per your requirement
c)    Put Date Description & Percentage against billing date

Please Note that - Table Entries of FPLA, FPLT & TPFLA to be copied separately because Billing plan references cannot be transported

6) Assign Billing Plan types to Item categories:

Billing Plans are controlled by item category. In customizing for sales, you can specify that individual item categories are relevant for order related billing by means of  billing plan. You can also specify billing plan types of each item category.

Sales and distribution-->Billing-->Billing Plan-->Assign Billing Plan types to Item categories
 Enter following details against Item categories

a)    Billing Relevant-->I (Order relevant Billing – Billing plan ) 
b)    Billing Plan type-->BA

Integration Between Sales and the Project System

The connection between the project and the sales document item is made in the individual schedule lines of the item. Each schedule item can be assigned to a network in a project.
To display the project-related data for a schedule line, proceed as follows:
       1.      In one of the overview screens of the sales document, select Item ® Schedule lines.
       2.      Mark the schedule line and select Procurement details

Suggested T Codes:
  • CN11
  • CJ20N
  • CJ27
  • CJ2D
  • CNMT