SEM tables start with UPC_

I am trying to learn BPS in the following steps :1) Create all the planning objects ( without going into every TAB detail )2) Explore each tab ( some could take a long time )3) Do Fox Programming4) Do Abap User Exits and FM for Characteristics Relationship5) Do WEB development 6) Try to do a Real Life Project to see why do we need these objects and how do we really put this to work ( this will be a tough one )

Start SEM with BPS0

1) Create Planning Area. There are many tabs on this Screen but first we will do an overview and then as I progress my learning will add more details

On Popup Enter name and Desc and click Create ( with standard Radio Button )Here for now all we will do is put in our Transactional Cube and click save.So basically BPS Planning Area = BW Cube

The Next step is to create a Level under this Area … A level is a “slice” of a cube . BSP Level = BEX Query Design - Just like how we selection Chars and KFs and Selections in a Bex Query Design - here we do the same in Level … although the Planning Area ( Cube ) has many Chars and KF – at this Level we may be interested in Planning only of a few Chars ( this will become clear when we have multiple Levels )

Right Click on Planning Area ( henceforth referred as PA ) and Create Level ( referred as PL )

Give a name and Desc in PopUpIn the next screen move the Chars you want to plan on from Lower Part of the screen to Upper Part ( again just like pulling Chars in Bex )

Note : I have not pulled Prodt Group or Summary Product Code for a reason – we will explore this when we do Characteristic Relationship . Next on Selection Screen ( same as Filter in Bex ) For now we will leave it open ..ie we can plan on all Brand , Materials for all Period

Now Clikc KeyFigures and select both the KFs

Will come back later to next 2 tabsClick Save

Expand the PL and we will see a 0-ADHOC Package ( don’t know much about his now , all I know is that we are not required to use this )

Right click on PL and Create Package

Now Package is nothing more than further subset of a Level …look at the second field “selection in Package “ … now scroll up few pages to Selection in PL ..you will see the same field ( partially visible ) … if we had selected this CheckBox , say for Material, then we would have allowed us to select material at Package . For Example we want to plan on all materials ( PL Material Selection is Open ) , but Employee1 using Package1 is responsible for Materials 1 thru 10 and Employee2 for Package2 Material 11thru 20 ..that means we could create multiple packages under a PL , but for now we will deal with only one package .

Next is Manual Planning ( Layout where we manually type in the values for Planning )Note make sure to double click on Package on the top part of the screen , before doing this step .

Enter name and desc in popup

If you see Layout Category …there are 3 types of layouts – we will just do the first one now ( need to explore the others later )This first type of Layout is “Key Figs in Data Columns” is just like any normal ABAP or BEX we do .. like all the Chars like Cust or Document in Left Columns followed by KF in right columns. So on this screen Header is Header ? / Filter , Lead is Chars or Left and then KF in Data Columns .. it is easy to understand this just by clicking Continue rather that all this writing.So we will put Brand and Material in Lead Column and click continue

Click Continue and in next screen pull both KFs ( will explore other check boxes later )

Click Continue

All the values in the columns above don’t mean anything…just showing us the Layout format that will be available to us.

Click on the Save Button ( see above )

Now we are ready to enter data .

The First time we go in the it will ask us to enter Header values

Click ok , it will always come up with Excel error box , just click END

Now you are in Excel where we can enter plan data ( obviously , there are many detail items which we are not covering now – as I have not explored them yet )

In the next screen enter plan data , we can use the little BOOK icon as F4

Enter valid data , click on SAVE and go and see the entries in listcube

Note how ZPRODH1 and ZPRODH2 fields are empty … this is because we did not select them in LEVEL and did not plan for them .. will revisit these when doing Characteristic Relationship

Now go back and ENTER PLAN DATA ..this time it will bring up the entry we saved .Don’t enter anything new , just change the amount and Save and go and see entriesYou will notice a new entry with -50 . this is just like our BW “E” Fact table ( I think )

Next – Create Planning Function – there are many built in functions , we will do a few which I am familiar with

Next popup but name and Desc and select a Function – in our example COPY

On the next screen – we need to select Fields to be Changed Based on Fields for Conditions.For Example : On Condition Brand is WHR – copy records from Period1 to Period2 .

Then we Create a Parametar Group - this is where we define , in our case .. what brands we use for Condition and what Period we are going to change .

Enter a Brand and click on Detail Button

We will copy period 3/2008 to period 5/2008

Here is a Before image of data before we execute the copy function.

Execute Planning Function and Save Data

After Image below it copied one record to a new period 008

There are many functions some are complex and some require Fox Programming ( Function Formula ) and some require ABAP ( Function – Exit )

Now we have complete one simple process of all the BPS Planning Objects. Of course like any other SAP module , we can go into a lot of detail under each step .Let me continue writing as many steps as I cover them.

So lets go back to step one and explore PA a little more .Look at the data screen above and note how ZPRODH1 and ZPRODH2 fields are not filled in.Now we will set it to fill automatically .Right click on PA , Change and click on Characteristic RelationshipIn Type pick up Attribute and click Detail Button ( see below )

Now fill in Material and Basic Char and the Attributes we want to fill acutomatically

Click Save

Now enter some data manually ( see above for instructions on how to enter Plan data thru Manual Planning

Just add a new Record and change value on existing one Always remember to save the data

See the result in table – notice how the two attributes are now filled in automatically

Variables :

Go To Change PA and Create a Variable Next screen for Char , pick my BrandAnd put WHR for brand ( see below )

Now change Level and for Brand use this Variable ( see below )

Now go to Enter Plan data , you will notice the Brand is restricted only to WHR – because of this variable

Go back and change the variable and add another brand EST

Again try entering Plan data with brand AMA … you will get error since AMA is not part of the variable

Following above steps create another Variable for 0CALMONTH , restrict form 01/2008 to 06/2008 and include it in a LevelNext change Layout ( Manual Planning ) and put 0CALMONTH as Dynamic ( Under Additional Settings ( see below )

Click Continue and Click on Dynamic and Enter 0CALMONTH in Heading with Some Desc

Continue and SaveAnd then Enter Plan Data.. the columns are generated automatically based on the range restriction in the Variable

Enter data and save and view in listcube

UPSPM – this is basically putting together all the objects which we create above for easy user interface .

Then use UPSPL to execute this user interface ( PLANNING FOLDER )

In the next screen drag all Variables , functions , layout to corresponding folders

Once the above is set us transaction UPSPL to run the planning folderAgain, planning folder in the user interface to run planning .Output layout is display only.Input layout for manual input

Next we will build the web interfaceEnter Transaction BPS_WB - Click on WizardClick ContinueGive name and DescContinueSelect PA / PL / Functions / Layout etc ,Continue / Save / GenerateDid not print screen by screen as the Wizard is self explainatory

Then use trans BPS_WIF0 to start the WebInterfaceSee below ( at this point the output layout is also taking input …don’t know why )

3/21/08 – started FOX

Best way to start on Fox Formula is by reading SAP Helphttp://help.sap.com/saphelp_nw04/helpdata/en/d3/8057f830a911d4b2be0050dadfb23f/frameset.htm

This could be a lengthy lesson as we are trying to learn the entire Fox Language .

Fox Formula is a type of Planning Function – type Formula . We will try to understand this Programming Language by creating several Examples

Ok.. I deleted all data in the cube to understand this Fox clearly.

Entered one record for Jan 2008 . And using fox will copy this complete record to Feb 2008See the next several screen prints.

First Create a Planning Function as described earlier - of type FormulaFor Fields to be Changed just use Fiscal Period.

Then for Parameter Group , enter the following Simple code .

Note there are many things to cover on this screen , but we will not explore all areas at this time , rather , each are as we com along.Note the following : On top of the Editor Fox displays the Expected Syntax , in our case we just had one field , and it shows as that field on top .Also the ‘I’ button gives is Complete help on all the buttons an Fox FunctionalityAlso within the Curley Bracket you could use F4 key .

Data before executing Fox

Data copied to Feb2008 after Fox.

Next we will learn KEYFIGURE_NAME .KEYFIGURE_NAME is a generic terms for ‘all KFs .Again F1 while in Fox Editor or the Sap help link above explains this very well .

Now go back and change the PF and put KEYFIGURE_NAME in field to be changed.Only after you do this go to PG and click on DATATYPES push button and one of the types will be KEYFIGURE_NAME .Enter the code as shown below . Trying to understand this KEYFIGURE_NAME – what we are doing is ..take Each KF (KEYFIGURE_NAME ) and multiply by 2 . In order to use KEYFIGURE_NAME we need to declare a variable of TYPE KEYFIGURE_NAME .Looking at the code below , we can easily understand the use of this .

See Before and After screens below

AFTER - all KF multiplied by 2 .

Now lets do the same exercise as above , however we will change the KFs based on 0CALMONTH criteria

We will change the KF only for Feb 2008

See Before and After …

Note : Basic things which are already described above will not be repeated .Example , How to create a PF , or to SAVE data after running the PF/PG .

Next we will have two fields in “fields to be changed “ ie. We will copy brand from WHR to EST and then multiply KFs by 2

See before and after data below

BEFORE

AFTER

Exploring Fox Function OBJV() .

OBJV() give the value of a Characteristic . OBJV can only be used with Fields for Condition .Still don’t know exact use of this , for example if we can put this within some loop then we can say ..for example if Materil = xx …do .. if Material = yy do ….But still need to test how to put within a loop .See Below – Also with MESSAGE , you can print the actual values … see code belowAnd the output

Notice is written only once ( correctly so , as OBJV is not with the loop ) Even within the loop does not make a difference as we are not looping at every material … so still don’t know the effective use of this.

>>>>>the Fiscal Year for Condition I was putting had only one material.Increasing the range and moving VMAT = OBJV() into the loop , correctly displayed the values of each material …so the above problem is now solved. See below