Day 7: How to install datasources

Hi ,

About Me	Topics
This is Rahul Bindroo SAP Netweaver Certified Professional  and Certified Project Management Professional.  rahulbindru@gmail.com	Day 1 : Overview Day 2 :SAP SD Overview Day 3: Basic Settings Day4 : Advanced Basic Settings

I welcome you to 7th day of my blog....

Alright Guys I am sorry for being so late in writing this page...!

Lets first try a approach where we are using the datasources which are delivered by SAP as part of SAP Content.

There are few important steps we should keep in mind while starting the developments:-

A.      IN ECC source system

a.       Login SAP ECC source system

b.      Activate the datasources from dormant to activate state

c.       Generate datasources and their extraction programs in case of logistics transaction data sources

Lets take them once by one :-

1.       Login SAP ECC source system: You should have valid authorisation in SAP ECC system with access to work in tcodes, SBIW,RSA5,RSA6,RSA3 etc.

2.       Activate the datasources from dormant to activate state:-

a.       Tcode RSA5àfind the datasources (lets say we are working 2LIS_11_VAHDR SD Sales: Document Header) in the hiearachy. Keep your cursor on the datasource and click at activate datasource.

b.      RSA6à Check in the hieararchy whether new datasource(2LIS_11_VAHDR) is visible.If yes then go ahead with next step.

3.       Generate datasources and their extraction programs in case of logistics transaction data sources

a.       Tcode LBWEàGenerate extraction structure and  extraction program and select job control as direct update. I will talk about the job controls later but at this moment use it as direct update. Guys this place helps us to select fields for our datasources, generate extracton program and secondly whether we want something for selection field or hidden field.

b.      Now you are through with the creation of structure and tables infact a table is generated which is called as set up table.

c.       Lets take data loading activity later at this moment lets have the data flow in place.

Alright guys now login SAP BI system we need to do the following activities:-

B.      IN BI system

a.       Login SAP ECC source system

b.      Replicate datasources

c.       Generate datasources and their extraction programs in case of logistics transaction data sources

Lets talk about them tomorrow...

Bye
Your Rahul

Day 6: SAP BI Content for SAP BI SD

Hi ,

This is Rahul Bindroo

SAP Netweaver Certified Professional 

and Certified Project Management Professional. 

rahulbindru@gmail.com

I welcome you to 6 th day of this training  before you start reading this page i request you to go through the earlier 5 days of training .


Now lets see what is first available in terms of cubes, ideally when we check we should check the roles which are available in SAP BI content for Sales

Sales-Sales:Overview
we have sales overview cube for sales 0sd_c03. This has data sources which bring data from sales,billing and delivery to give the final picture of sales.     

2LIS_11_VAHDR SD Sales: Document Header

2LIS_11_VAITM Sales Document Item Data

2LIS_13_VDITM Billing Document – Item Data

2LIS_13_VDHDR Billing Document-Header Data

2LIS_12_VCHDR delivery header

2LIS_12_VCITM  delivery item data

Sales-Quotation 

DataStore Object (technical name)
0SD_C05 Offers/Orders)

Day 5: SAP BI Content for SD Sales And Distribution

Hi ,

This is Rahul Bindroo

SAP Netweaver Certified Professional 

and Certified Project Management Professional. 

rahulbindru@gmail.com

I welcome you to 5th day of this training




Before i talk about what is available in SAP BI content,i would like to share with you some functional part of Sales and Distribution. I request you to first go through the Day 2 lesson. Then I would also request you to through what is Business content in my blog.




To make things easy ,  i would like to classify the SD module in three major areas.

1. Sales 
2. Distribution and
3. Transportation

Lets understand Sales first

Sales:-This focuses on Quotation/orders , delivery , invoice and returns their quantities,values and numbers.

Distribution: 

The focus for this area is fulfillment rate,delivery performance to customer requested date,delivery performance to Scheduled commitment date,number of orders items quantities not delivered . Backlogs for customer , material and time frame is also a focus for this area.A delivery note indicates that goods have been shipped. A delivery note is sometimes referred to as a packing slip.

Transportation:-

For business this area is also important from analytical point of view to see vehicle utilisation,loading time, transporation time, delays and costs.

Hey friends , i am sure you are not finding it very clear.. Don't worry I am coming  back tomorrow with an example . Now i need to sleep now. Will have to for a trekking in morning...Till then enjoy your time.

Hi Welcome back..lets take one by one using an example:-


Lets say you own a IT company XYZ and you want 60 laptops , you are calling the vendor www.globalbsc.com to buy these laptops from them.

1.  XYZ-->globalbsc : Please let us know the prices at what you can deliver 60 laptops
2. globalbsc--> XYZ:  Sends a document which is called Quotation
3.  XYZ-->globalbsc :We agree to the prices at which you are selling and they confirm .
4. globalbsc  : Creates a document which is called sales order The sales order is an important document - it tells everyone to get busy filling that order. As such, this document is important for planning production, creating purchase orders, and scheduling resources.

All the above steps cover the Sales .

SAP HANA By Rahul Bindroo Session 1

SAP HANA for SAP BI 7.3

Hi ,


Welcome to this video blog edition of HANA by Rahul Bindroo.
I have tried to put the basic concept in place without making it too technical to understand the appliance .


Thank you once again for visiting this blog.

Regards
Rahul Bindroo
rahulbindru@gmail.com

Day 4: Basic settings for BI sever before starting Developements

Hi ,

This is Rahul Bindroo

SAP Netweaver Certified Professional 

and Certified Project Management Professional. 

rahulbindru@gmail.com

I welcome you to 4 day of this training

We have discussed about following points last time, let us take them one by one:-

1. Is our BI System is connected to Source system?
2. Are global settings completed?
3. Are exchange rates transferred?
4. Are permitted characters added?
5. Is material number format added?
6. Is wait time for monitor set?
7. Is source system id assigned to source system?
8. Is conversion of logical system for transports completed?
9. Is report setting done?
10. Are new webtemplates attached and are workbook templated designed?
11. Are webservices configured and activated?

TOPIC 1:-Is our BI System is connected to Source system?

Please check what all are you source systems out following points last time, let us take them one by one:- YOu may be connecting to SAP ECC system , flat file or third party. We have different options of connecting to these source systems based on the available connectors . Let us consider SAP ECC first.

This activity is majory done by basis consultant but it may be required that you may also have to do this in some implementations.

a: ECC

You need to do following:-

1. Create logical systems and assign them to Clients with whom you want to connect
2. Create a user id for with the correct roles in ECC and BI system
3. Create a RFC connection
4. Set user id as a communication user id in BW.

B: FILE

Incase you want file its very simple just add word FILE in logical system name in BW while creating a source system in tcode RSA1--->Source systems

C) Third party

Say you want to connect to SQL or ORACLE  based database you can do it easily using DB and UDI connet. I will discussion these in more detail in next sessions.

TOPIC 2:-Are global settings completed?

you may need currencies,unit of measurement,fiscal year variants and factory calender details from your source system for that you need to load data from the source system tables and need to update that to BI Tables. This can be done by

IN BW-RSA1-Source system-->Rtclick newly created source system name-->transfer global settings

TOPIC 3:Are exchange rates transferred?

Say you are in system where you need to report in multiple currencies and you know for that you need to convert data using the exchange rate. In case you have tables updated in BI with this data this can be handled directly in reports or while data load. Now the question is how to  bring this data to these SAP BI tables.

IN BW-RSA1-Source system-->Rtclick newly created source system name-->Transfer exchange rate

TOPIC 4:Are permitted characters added?

Now once we start loaded the data we get a very big problem that is the source data is having few special characters like '#,@,%,!) etc and while loading we get a error. What to do..Guys we just need to check if special characters are added in system to be allowed.

Now how can we do this:-

There are various ways to handle this think but at this moment lets keep simple thing with us

In BW-tcode RSKC -- add ' !"%&''()*+,-./:;<=>?_0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ' 

TOPIC 5 :Is material number format added?


You may get a error setting for material conversion not found if you dont go for this setting.
Remember go to source system first and check the Material number length and end then add same length for material in BI system.


You can go through SPRO or OMSL transaction code.


First in ECC Source System :tcode OMSL -- CHECK Material No. Lenght, for example  if we see 14 there  then
Go to BW - TCODE-OMSL-ENTER same length (say in our example 14) and click save button.

Day 3: Basic Settings

Hi ,

For any question contact  Rahul Bindroo ,SAP Netweaver Certified Professional , Certified Project Management Professional at rahulbindru@gmail.com




Hey welcome guys..! Now lets now connect to our new system and check the following

1. Is our BI System is connected to Source system?
2. Are global settings completed?
3. Are exchange rates transferred?
4. Are permitted characters added?
5. Is material number format added?
6. Is wait time for monitor set?
7. Is source system id assigned to source system?
8. Is conversion of logical system for transports completed?
9. Is report setting done?
10. Are new webtemplates attached and are workbook templated designed?
11. Are webservices configured and activated?

In my next day block i will try to take them one by one...

Till then good night ...

Day 2 :SAP SD Module For BI

For any question contact  Rahul Bindroo ,SAP Netweaver Certified Professional , Certified Project Management Professional at rahulbindru@gmail.com

I welcome you to my blog....




We need to have some basic understand of the modules before we start the implementation for the module. Let me try to give you some basic overview of Sales module of SAP ECC which will help you to gather requirements. First thing remember for every module do understand the business flow . this is important. Guys Please note....!

I have given above a small picture to help you understand the module.

A small Example: Let us say you our www.globalbsc.com which manufactures Laptop bags.
You get orders from companies and you deliver the same in those schools. Now lets see where sales process starts. There is xyz company which calls you and says that they have requirement for 300 bags. Now how this sales process begins:-

1. They ask you to send a document which will carry prices for the bags and discounts and mail the same. This document is initially produce by us( www.globalbsc.com) and shared with the xyz company. THIS IS CALLED QUOTATION.
2. This quotation is received by xyz company and approved by their Purchasing team . They send you a order to buy the 300 bags . This document is called Purchase order
3. This purchase order will become a base for you to process sales. You book a entry in your ERP system or other system to keep a track this is called 'Sales Order'. 
4. Once this process is completed you start a Selecting bags and packing them this is a sales process called as PICKING.
5. Once this is completed you pack the bags and send them to the xyz company. you will also create a entry in system updating that bags are sent. There is a document which is sent to xyz company which will carry the information what is sent .This is a document which may be called as BILLING DOCUMENT.(say we call this as Invoice ). This process in SD Is called BILLING.
6. Now in system you should also track what money you need to receive from xyz company. This is a process which gets connected to finance and is called ACCOUNTS RECEIVABLE..

Broadly if you observe sales and distribution is comprised of 4 basic process steps:-

1. Sales- Involes quotation (ABOVE 1-3)
2. Shipping-Picking
3. Billing-step 5 
4. FIAR-6

I would suggest if you still want to read more then do find my new blogs but at this moment i will say this is sufficient as a beginner.

So lets meet in our next class for understand the basic settings we have to make in ECC and SAP BI system

You can post your questions directly to me at

rahulbindru@gmail.com

Day 1: SAP Business Intelligence : Free training

Hi ,

About Me	Topics
This is Rahul Bindroo SAP Netweaver Certified Professional  and Certified Project Management Professional.  rahulbindru@gmail.com	Day 1 : Overview Day 2 :SAP SD Overview Day 3: Basic Settings Day4 : Advanced Basic Settings

I welcome you to my blog....

My intension behind writing this blog is sharing my knowledge to the beginners to SAP BI or the ones who want to learn SAP BI. For

I have seen lot of stuff available in form of good books and internet pages and all other places but it seems that the flow is missing in all of them and i thought to give you all a step by step flow for SAP BI SD implementation. This is purely based on my work I have done in around 13 full Cycle implementations.


I am here to deliver this SAP BI Training free of charge for all of you...


Lets go strait to first chapter:-

1. Day 1 : Overview
2. Day 2 :SAP SD Overview
3. Day 3: Basic Settings
4. Day4 : Advanced Basic Settings

Other Topics

SAP HANA Overview By Rahul Bindroo




You can post your questions directly to me at

rahulbindru@gmail.com