06-21-2007 9:51 AM
06-21-2007 9:55 AM
Hi,
Here is some lite reading...
http://help.sap.com/saphelp_46c/helpdata/en/c1/37544e449a11d188fe0000e8322f96/frameset.htm
As for any business content datasources you have to install the content in RSA5 in R/3 and then use TCODE: LBW0 to reach LIS structures screen. You have to set up LIS environment if it is not in SAP number range otherwise it is not necessary. After that you have to generate it. Then activate the delta there. The process of deleting setup tables also is applicable for LIS.
The process in BW is common for any Data Source
Steps in LIS EXTRACTION:
T.code - :MC18 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 create infostructure
Example
Inforstructure : S789
Application 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 MC24 create updating
Infostructure : 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 infostructure set periodic split 1. Daily, 2. Week, 3. Month, 4. Posting period Updating 1)No updating,2)Synchronous updating (V1), 3)As synchronous updating (V2), 4)As synchronous updating (V3),
T.code 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 SBIW Display IMG (implementation guide) Setting for applications specific data source logistics Managing transfer information structure setup of statistical data applications specific setup of statistical data perform statistical setup sales.
Choose activity
Setup Orders, deliveries, billing
Choose the activities enter the infostructure (S789), give name of the run, date of termination, time of termination, No. of tolerated faulty documents. Then execute
T.code RSA3 Extractor checker
Give the data source name eg. 2LIS 01S789 and execute, result will get some records Go to BW side replicate data source Assign infosource Create infocube Create update rules create infopackage and schedule the package with initialize delta process.
<b>Reward points</b>
Regards
Message was edited by:
skk
06-21-2007 9:54 AM
06-21-2007 9:55 AM
Hi
LIS means Logistics Information Systems
see the link
<b>http://help.sap.com/saphelp_46c/helpdata/en/c1/37544e449a11d188fe0000e8322f96/frameset.htm</b>
Reward points for useful Answers
Regards
Anji
06-21-2007 9:55 AM
Hi,
Here is some lite reading...
http://help.sap.com/saphelp_46c/helpdata/en/c1/37544e449a11d188fe0000e8322f96/frameset.htm
As for any business content datasources you have to install the content in RSA5 in R/3 and then use TCODE: LBW0 to reach LIS structures screen. You have to set up LIS environment if it is not in SAP number range otherwise it is not necessary. After that you have to generate it. Then activate the delta there. The process of deleting setup tables also is applicable for LIS.
The process in BW is common for any Data Source
Steps in LIS EXTRACTION:
T.code - :MC18 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 create infostructure
Example
Inforstructure : S789
Application 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 MC24 create updating
Infostructure : 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 infostructure set periodic split 1. Daily, 2. Week, 3. Month, 4. Posting period Updating 1)No updating,2)Synchronous updating (V1), 3)As synchronous updating (V2), 4)As synchronous updating (V3),
T.code 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 SBIW Display IMG (implementation guide) Setting for applications specific data source logistics Managing transfer information structure setup of statistical data applications specific setup of statistical data perform statistical setup sales.
Choose activity
Setup Orders, deliveries, billing
Choose the activities enter the infostructure (S789), give name of the run, date of termination, time of termination, No. of tolerated faulty documents. Then execute
T.code RSA3 Extractor checker
Give the data source name eg. 2LIS 01S789 and execute, result will get some records Go to BW side replicate data source Assign infosource Create infocube Create update rules create infopackage and schedule the package with initialize delta process.
<b>Reward points</b>
Regards
Message was edited by:
skk
06-21-2007 10:26 AM
Hi
LIS means Logistics Information Systems.
http://help.sap.com/saphelp_46c/helpdata/en/c1/37544e449a11d188fe0000e8322f96/frameset.htm
Go thru the following PDF:
http://help.sap.com/printdocu/core/Print46c/en/data/pdf/LOLIS/LOLIS.pdf
http://help.sap.com/printdocu/core/Print46c/en/data/pdf/LOLIS/LOLIS_KOMPONENTEN%20DES%20LIS.pdf
Go through this WEBLOG
/people/sap.user72/blog/2004/12/16/logistic-cockpit-delta-mechanism--episode-one-v3-update-the-145serializer146
Regards,
Padmam.