cancel
Showing results for 
Search instead for 
Did you mean: 

How to create a New SD flow in SAP BI

Former Member
0 Kudos

Hi Experts,

I want to create new SD flow where all data will be going to Standard Cube : 0SD_C03.

Our dataflow is like this : Datasource --> DSO --> Cube (0SD_C03).

There are many datasource for which Standard DSO is not available and we need to create Custom DSO. Is there any way to know which fields from Datasource will be mapped to Custom DSO.

Below are the datasource used and there Standard DSO.

1. Datasource ( 2LIS_11_VAHDR) ---> Standard DSO : 0SD_O03 (Orders)

2. Datasource ( 2LIS_11_VAITM) ---> Standard DSO : 0SD_O01 (Order Items)

3. Datasource ( 2LIS_11_V_I_TM) ---> Not able to find Standard DSO.

4. Datasource ( 2LIS_12_VCITM) ---> Not able to find Standard DSO.

5. Datasource ( 2LIS_12_VCHDR) ---> Not able to find Standard DSO.

6. Datasource ( 2LIS_13_VDITM) ---> Not able to find Standard DSO.

7. Datasource ( 2LIS_13_VDIHR) ---> Not able to find Standard DSO.

Please let me know if there is any Standard DSO available for the above datasource. If not then how we will be able to map the Datasource Fields to Custom DSO? Is there any table which will provide or something like that?

Thanks !!!

Regards,

Girish

Accepted Solutions (0)

Answers (2)

Answers (2)

former_member976
Active Contributor
0 Kudos

HI,

form business content drag the data source form the left side to right side

select the before and after words form the grouping option

it will collect the total form of related data source.

fallow the raman replay as well as the find the below link form help.sap

Enterprise Sales and Distribution - SAP Library

Thanks,

Phani.

Former Member
0 Kudos

Hi Phani,

Your document is really helpful. One more question I have is ther any similar documet which shows Standard DSO related to Datasources. This would make this task much easier.

Thanks!!!

former_member183012
Active Contributor
0 Kudos

Hi Girish,

For Lo extraction you will got lot manystep by step documents please search on google.

For SD data flow search with "LO extraction part 6".

Please read this documets.hope it will helpful to set up SD dataflow.

Regards,

Ganesh Bothe

RamanKorrapati
Active Contributor
0 Kudos

Hi,

ECC field and related info objects you can find with helo of below table.

Table - RSOSFIELDMAP - it will help you find the related info objects(for mapping also).

About standard DSO,  With help of BI content you can find the the dso's if existed.

Use grouping option as data flow before and after, drag cube or data source to right side at RSA1--> BI content, you will see the all connected flow. form there you can find dso names.

Thanks

Former Member
0 Kudos

Hi Raman,

Thanks for your reply. I found mapping for most of the Datasources with the help of table : RSOSFIELDMAP.

But i am not able to find mapping for Datrasource : 2LIS_13_VDITM, 2LIS_13_VDIHR, and 2LIS_11_V_I_TM.

Except Datsource 2LIS_13_VDITM all otehr datasource are in 3.x flow. Can this be the reason?

In BI content I can only find two DSO for the respective datasource as provided in post.

Please provide if there are any Standard DSO for the corresponding Datasources.

Thanks.

Girish

former_member976
Active Contributor
0 Kudos

Hi,

Except Datsource 2LIS_13_VDITM all otehr datasource are in 3.x flow. Can this be the reason?

A. you can migrate the data source form 3.x to 7.x

     select the data source  -> right click -> migrate -> with export.

     note : - don't click with out export - roll back not possible.

Former Member
0 Kudos

Hi,

If I migrate it from 3.x to 7.x will it be affected to other flows. Because there are already other flows created on that Datasource and this we are creating completely new.

Thanks

RamanKorrapati
Active Contributor
0 Kudos

Yes, Above table will shows the data sources which are in 7.x only.

but you can just pass field name only, it will shows bw objects.

data source what ever no issues. same info objects can be used at multiple data sources.

So at above table just you can pass FIELDNM - and see the data . it will shows related bw objects.

former_member976
Active Contributor
0 Kudos

Hi,

before migrating inform to them you created the data flows

then you can migrate form 3.x to 7.x

test in the dev system.

Former Member
0 Kudos

All the datasource are in 3.x. adn they are displaying the field mapping for Infoobject in table.

The one which is in 7.x is 2LIS_13_VDITM is not showing in that table. I am trying to find the fields suggested by you.

Is there any other way this can be done or any standard DSO that you might know for the datasources?

Thanks.

RamanKorrapati
Active Contributor
0 Kudos

Hi,

SD Dso's

I think below 2 dso's might be known to you.

0SD_O06 - Billing Condition Data

0SD_O05 -  Order: Condition Data

0SD_O01,0SD_O02,0SD_O03 and 0SD_O04.

Thanks

Former Member
0 Kudos

Hi,

Yes but these DSO apply to which datasource? I think only O01 and O03 are applicable for the 2 Datasources which mentioned in Post, but not sure for others.

RamanKorrapati
Active Contributor
0 Kudos

Please explore your self on Google search with dso names,

You may get use full information.