Sales Information System

[Former Member]

Hi All,

I need to run Sales information system for my client urgently. Can some one help me how report should be configured please.

urgent , urgent.

regards,

guru prasad

[Former Member]

hi

for sis follow these T.codes or if you will gothrough the logistcs general-lis-sis.

create info structures by using MC21 selecting characteristics nad key figures

update by using MC24

T.code OMO1 Update group

T.code MCSI for running infostructures

if u want more details to create characteristics and key figures gothrough the navigation,you will get all details

hope this will help you

[Former Member]

hi ,

Created S999 information structure.

Menu path: logistics general, Data Basis, information structure, maintain self defined information structure, Create (or) Change (or) Display. T.Code: MC21

Update rules for information structure S999

Menu path: logistics general, Updating, Updating definition, Specific Definition Using Update Rules, Maintain Update Rules, T.Code:MC25

Updating rules for Information structure S999

Menu path: logistics general, Updating, Updating Control, Active updating, Sales and distribution .T.Code:OMO1

Maintained Customer statistic groups relevant for updating.

Menu path: logistics general, Updating, Updating Control, Setting: Sales ,Maintain Statistical group for customer .T.Code:OVRA

Maintained material statistic group.

Menu path: logistics general, Updating, Updating Control, Setting: Sales ,Maintain Statistical group for Material .T.Code : OVRF

Maintained statistics group for sales document.

Menu path: logistics general, Updating, Updating Control, Setting: Sales ,Maintain Statistical group for Sales Document type .T.Code : SPRO

Assigning statistics group for sales Document

Menu path: logistics general, Updating, Updating Control, Setting: Sales, Assigning Statistical group for Sales Document type .T.Code : spro

Flagging billing type f2 to relevant for statistics.

Menu path: logistics general, Updating, Updating Control, Setting: Sales ,Determine billing Document types Relevant to Statistics .T.Code : OVRF

.

Assign sales area to updating rule

Menu path: logistics general, Updating, Updating Control, Updating groups,Assign updating rule at item level, T.Code : OVRP

Assigning Sales area to Header Level

Menu path: logistics general, Updating, Updating Control, Updating groups, Assign updating rule at Header level, T.Code : OVRO

Checking all settings.

Menu path: logistics general, Updating, Updating Control, Updating groups, Checking Assignment for updating groups, T.Code : SPRO

Maintaining values in standard analyses.

Menu path: logistics general, Logistics information systems, Reporting,Standard analysis, change settings, Sales and distribution . T.Code: OMOJ

Maintaining customer statistics group in the customer master record.

T.Code:XD02

Maintaining material statistic group in the material master record.

T.Code:MM02

Menu path: Easy Access, logistics,Sales and Distribution, Sales information Systems, Reporting,Standard analysis, user defined analysis. T.Code: MCSI

Sales org: TSO1, Distribution Channel : T1, Division : T!

Step to Create Sales Information System

1. Create information structure by selecting the key figures and characteristics. After creating the information structure u must activate and generate.

2. Include updating rule for information structure. After including the updating rule the information structure u must activate and generate

3. Select the updating rule is whether for day, week, month, or year by double clicking on the information structure.

4.Maintaining all settings i.e.; customer statistics group, materialstatistics group, sales document, sales item, billing document, and assign all these to sales document type, sales item, billing type,

5. Assign sales area to updating rule.

6. Check the sales area whether all settings are maintained or not.

7. Maintained customer statistics group in the customer master record, and material statistics group in the material master record.

8. After all the settings use T.c. MCSI enter the sales area customer material and see the results, now u get the report or sales of a particular customer or organization.

Note: Before doing the last step create a sales order, delivery, AND billing.

SET UP STATISTICAL DATA

Menu path: logistics general, Logistics information systems, Data basis , tools ,Set up Statistical Data,Appilication specific set up of statistical data,Perform set up sales and distribution , copy and delete version, T.Code: OLIX

Menu path: logistics general, Logistics information systems, Data basis , tools ,Set up Statistical Data,Appilication specific set up of statistical data,Perform set up sales and distribution , set orders, T.Code: OL17

SET UP Statistical data by using Programs

1. T.Code: OLIX

2. T.Code: OLI7

3. T.Code: OLI8

4. T.Code: OLI9

5. T.Code: OLIX

Scenario : The company has 13 period in the calendar, now they want to upgrade to new version of SAP ,and there will be a change to the calendar year, which should have 12 periods. What happens to the sales information system, analysis based on week or month, will the sale information system will update the past data.

Step 1. go to T.Code: OMO1

The information structure S999 has period week and updating type is synchronous updating.

Step 2 : create the sales order. T.code: va01

Save the sales order, the net value is 5000.

Step 3. Run the information structure : T.Code: MCSI

Step 4: now change the period in T.Code:OMO1

Now when u change it the period the info structure say that the contains data is lost

Say yes

Save it

Step 5. create a sales order. The SAP always store the value in the 000 VERSION

T.CODE: VA01, and save it

Step 6: now again run the info structure T.Code.MCSI.

Step 7: now go for T.CODE. ovi7

Generate and save :

Step 8: again go for T.CODE:OMO1 and change the period from month to week

Initially the SIS will update the structure with the created value ie 15000, now u change that again into week because the SIS will delete and rerun the past data.

Step 9: again go for oli7 and update the info structure

Ster:10 Run the information structure : MCSI

I am unable to attach the screen shot

thanks,

Kuntla. rewards points