Update Rules for Info Structures

[Former Member]

Hi,

I have created one info structure with key figures incoming orders qty, open orders qty and delivered qty to the customers.

Whenever I create a sales order, that order qty should get updated for that particular material and customer combination in the info structure and should be visible in the flexible planning table.

Similarly whenener there is a delivery happened to a particular customer, that delivered qty also should get updated in the info structure.I know to get the values updated in the info structure, we need to maintain update rules for this info structure.

Can anybody please tell me the procedure for maintaining the update rules for an info structure?

Thanks in advance

Rajarao.

[Former Member · Accepted solution]

T code OMO1 - To define how the structure should be updated. May be Asynchronous.

T Code MC24 - Assign Update rules.

MCVR - Verifyto check info structure can be updated for every document.

Hope this helps

[Former Member]

LIS Steps:

T.code - :MC18 u2013 create field catalog

1. Characteristic Catalog

Application-01-Sales and Distribution, 02-Purchasing, 03-Inventory Controlling, etc..

Catalog category 1. Characteristic catalog, 2. Key figures catalog 3. Date catalog Select characteristic catalog and enter, click on characteristic select the source table and it will be display the relevant source field and select the source field, copy + close, copy.

Save, similarly create key figures catalog

T.code : MC21 u2013 create info structure

Example u2013

Infrastructure : S789

Application u2013 01

Choose characteristic select the catalog, select the fields, copy + close Choose key figures catalog select the key figures ,copy + close, save and generate

T.code u2013 MC24 u2013 create updating

Info structure : S789

Update group : 01- Sales document, delivery, billing document ,enter Select the key figures click on rules for key figures give suggest rules, copy save and generate Click on updating (activate updating) Select the info structure set periodic split 1. Daily, 2. Week, 3. Month, 4. Posting period Updating u20131)No updating,2)Synchronous updating (V1), 3)As synchronous updating (V2), 4)As synchronous updating (V3),

T.code u2013 LBW0 - Connection of LIS Information structures to SAPBW Information structure : S786 Select the radio button-Setup LIS environment and Execute.

Select the radio button-Generate data source and Execute.

For Delta update:

Select the radio button-Generate updating and Execute Select the radio button -Activate / deactivate and Execute.

T.code u2013 SBIW u2013 Display IMG (implementation guide) Setting for applications specific data source u2013 logistics u2013 Managing transfer information structure u2013 setup of statistical data u2013 applications specific setup of statistical data u2013perform statistical setup u2013 sales.

Choose activity

Setup u2013 Orders, deliveries, billing

Choose the activities enter the info structure (S789), give name of the run, date of termination, time of termination, No. of tolerated faulty documents. Then execute

T.code u2013 RSA3 u2013 Extractor checker

Give the data source name eg. 2LIS 01S789 and execute, result will get some records Go to BW side replicate data source u2013 Assign info source u2013 Create info cube u2013 Create update rules u2013 create info package and schedule the package with initialize delta process.

For delta update :

In R/3 side

T.code u2013 MC25, set update (V1) or (V2) or (V3)

T.code u2013 LBW0, choose generate updating and execute then choose activate / deactivate and execute

BW side - create info package and schedule the package with delta update.

First time if your scheduling the info package -in R/3 side T.code :MC25 -Updating set to No update, instead of selecting the update V1,V2,V3.

If your doing the Delta update:in R/3 side T.code :MC25-Updating set to either V1 or V2 or V3. and the to T.code :LBW0 - Select the radio button Active/deactivate and Execute.

and schedule the info package with delta update.

award points if helpful

[Former Member]

Hi,

Please review SAP Note No. 64636 to update Info structures.

Ramesh