InfoProvider Identification
| ||||||||||
InfoProvider Name:
|
InfoCube: 0SD_C03 – Sales: Overview
| |||||||||
Standard/Custom:
|
Standard
Business Content
|
Std.Business Content
w/ Modifications
|
Custom
| |||||||
Module(s):
|
CO
|
FI
|
HR
|
PP
|
SD
|
PS
| ||||
Other (specify):
| ||||||||||
Document History
| |||||||
Created By:
|
Date Created:
| ||||||
Approved by:
|
Date Approved:
| ||||||
Change History (To track changes to Request spec. after the specifications have been approved)
| |||||||
Date Modified
|
Modified by
|
Brief Description of Change
|
Approved by
|
Date Approved
| |||
Sample Data Flow
1. Business Content Installation
1.1. R/3: Data Transfer to the SAP Business Information Warehouse
1.1.1. Classification:
Standard Business Content
Standard Business Content w/ Modifications Refer to: __________
Custom Refer to: __________
1.1.2. In each of the designated source systems, transfer the following DataSource(s):
DataSources: 2LIS_11_VAHDR
2LIS_11_VAITM
2LIS_11_V_ITM
2LIS_12_VCITM
2LIS_12_VCHDR
2LIS_13_VDITM
2LIS_13_VDHDR
Source System:
F Box (Development Client TBD)
G Box (Development Client TBD)
E Box (Development Client TBD)
Note: This assignment has been activated per standard business content. No modifications have been made.
Use R/3 Menu Path:
Data Transfer to the SAP Business Information Warehouse à Business Content DataSources à Transfer Business Content DataSources
1.2. BW: Set up InfoSource / DataSource Assignment
1.2.1. Classification:
Standard Business Content
Standard Business Content w/ Modifications Refer to: __________
Custom Refer to: __________
1.1.1. Modeling: Source Systems: Replicate the DataSources of the following Application Components:
Application Component(s): Sales & Distribution
1.1.2. In each of the designated source systems, assign the following DataSource - InfoSource relationships:
DataSource InfoSource
2LIS_11_VAHDR 2LIS_11_VAHDR
2LIS_11_VAITM 2LIS_11_VAITM
2LIS_11_V_ITM 2LIS_11_V_ITM
2LIS_12_VCITM 2LIS_12_VCITM
2LIS_12_VCHDR 2LIS_12_VCHDR
2LIS_13_VDITM 2LIS_13_VDITM
2LIS_13_VDHDR 2LIS_13_VDHDR
Source System:
F Box (Development Client TBD)
G Box (Development Client TBD)
E Box (Development Client TBD)
1.1.3. Install the Transfer Rules and Communication Structure.
Note: This assignment has been activated per standard business content. No modifications have been made.
1.2. Activate InfoCube: 0SD_C03
1.2.1. Classification:
Standard Business Content
Standard Business Content w/ Modifications Refer to: __________
Custom Refer to: __________
1.1.1. From the Business Content area of the Administrator Workbench:
1.1.1.1. Set ‘Grouping’ to:
Only Necessary Objects
In Data Flow Before
In Data Flow Afterwards
In Data Flow Before & Afterwards
1.1.1.2. Set ‘Collection Mode’ to:
Collect Autmatically
Start Manual Collection Refer to: __________
1.1.1.3. Insert the following object(s) for Collection:
Object: 0SD_C03
1.1.1.4. Install
Note: This object has been activated per standard business content. No modifications have been made.
Dimensional Model (Include InfoProvider, master data, related ODS, and related aggregated cubes)
Thanks for the nice info.
ReplyDeleteBut can you illustrate more about the steps for activating the setup tables corresponding to the cube 0SD_C03.
Correct me if I'm wrong:
1) RSA5 - Activate all related Data Sources mentioned above
2) RSA3 - Check DS
3) RSA7 - Make sure no delta activated
4) SBIW - Fill in setup tables and select everything related to SD to fill 0SD_C03
5) BI site...
I'm not sure exactly whats in step 4
please specify more
Thanks
Hi Heba,
DeletePlease follow this document
http://scn.sap.com/docs/DOC-12007
It explains LO extraction in detail.
Regards,
Anjali
Thanks so much
DeleteRegards,
Hi Anjali again,
ReplyDeleteI'm wondering if you have a documentation for COPA cubes like the great one you've uploaded for SD?
Thanks
Hi Heba,
DeleteI only have the documention published in SDN
http://scn.sap.com/thread/1243577
Regards,
Anjali
Hi Anjali,
ReplyDeleteGreat initiative I am really surprised after seeing your blog on SAP BI, I had gone lot of blogs but the information you are given in the site is awesome. I was searching for the 0SD_C03 installation in google none of them had given the proper information. I found this info is very useful.
Thanks
Hi Anjali,
ReplyDeleteI am trying activate the ddata sources as given in the digram and is there any sequence of data load should I follow. Ex: 2lis_11_vaitm....vcitm
I mean should I follow any sequence of data source loading to the targets in the BW
Hi Bala,
ReplyDeleteThanks!!! As far as I know, you need to follow a sequence while loading Inventory DataSources only....So go ahead!
Regards,
Anjali
Hi Anjali,
ReplyDeleteDo you have any SAP BI business scenario's or any demo models to do some practice.
Thanks,
Prince
Hi Anjali,
ReplyDeleteThanks for sharing your knowledge and i have a question on Data flow shown on above.
1.Do we have standard BI Content Info providers for Delivery
Document, Billing Documents.
Thanks
Vijay