doc-42205.pdf

16
Generated by Jive on 2015-01-19+01:00 1 Information Structures in SAP Information structures in SAP An information structure is a table of fields from operative applications like sales or purchases and forms the basis for analytics in Logistics information system. It consists of three main parameters – period unit, characteristics and key figures. A period unit gives is used to give reference of time like a week, month or year. Characteristics are used to specify the range of data viz. company code, plant, sales organization, sales office or material etc. for which data is compiled. Key figures are the data like sales volume, sales value etc. that is collected with reference to characteristics and period unit. Create Info Structure: 1. Go to IMG : Logistics General à LIS àLogistics Data Warehouse à Data basis àInformation Structures à Maintain self-defined information structures OR Use T-Code – MC21, Enter number & description for your information structure, choose application 01, type as standard, enable planning and continue.

Upload: sanjit-bhattacharya

Post on 18-Aug-2015

212 views

Category:

Documents


0 download

TRANSCRIPT

Generated by Jive on 2015-01-19+01:001Information Structures in SAPInformation structures in SAPAn information structure is a table of fields from operative applications like sales or purchasesand forms the basis for analytics in Logistics information system. It consists of three mainparameters period unit, characteristics and key figures. A period unit gives is used to give reference of time like a week, month or year. Characteristics are used to specify the range of data viz. company code, plant, sales organization,sales office or material etc. for which data is compiled. Key figures are the data like sales volume, sales value etc. that is collected with reference tocharacteristics and period unit. Create Info Structure:1.Go to IMG : Logistics General LIS Logistics Data Warehouse Data basis Information Structures Maintain self-defined information structures ORUse T-Code MC21, Enter number & description for your information structure, chooseapplication 01, type as standard, enable planning and continue. Information Structures in SAPGenerated by Jive on 2015-01-19+01:002 2. Choose characteristics from given field catalogs. Choose Sales Org, Distribution Channel, Division, Sold-to-party, Material and/or as required. Copy & Close.Information Structures in SAPGenerated by Jive on 2015-01-19+01:003 Similarly, choose key figures like order quantity, confirmed quantity, gross weight, Net Weight, Volume, BilledQuantity, Open Orders Quantity etc. as required.Information Structures in SAPGenerated by Jive on 2015-01-19+01:004 3. Save your information structure.Information Structures in SAPGenerated by Jive on 2015-01-19+01:005 4. Go to MC24 to create updating for your information structure. Choose update group 1 (SIS: sales document,delivery, billing document) or as required.Information Structures in SAPGenerated by Jive on 2015-01-19+01:006 5. Create update rules. Double-click on key figures and specify event, update type, source table source field.Choose table and date field for period determination or click on suggest rules. Copy.Click on rules for characteristics to create update rules of characteristics for each key figure. Specify sourcetables and fields for each characteristic. Copy.Information Structures in SAPGenerated by Jive on 2015-01-19+01:007 Information Structures in SAPGenerated by Jive on 2015-01-19+01:008 6. After creating rules for all your key figures, go to Environment in the menu bar and choose activate updating.Double-click your info structure to selectparameters as shown below. Set period split as required andasynchronous updating. Save.Information Structures in SAPGenerated by Jive on 2015-01-19+01:009 7. Use T-Code LBW0 to connect your info-structure to SAP BW. Input your info-structure, choose set-up LISenvironment and execute.-Next Choose generate data source and execute.-For Delta updating in LIS choose generate updating and execute. Information Structures in SAPGenerated by Jive on 2015-01-19+01:0010 8. Display your info-structure in MC23. Go to Environment in menu bar and choose update definitions. Statusof info-structure is Active.Information Structures in SAPGenerated by Jive on 2015-01-19+01:0011 Set up statistical data for your info structure Use T-Code > SBIW to go to IMG and go to Perform setup sales & distribution and runactivity Setup for Orders, deliveries, & billing.Information Structures in SAPGenerated by Jive on 2015-01-19+01:0012 9. Choose activity, enter the info structure (S898), give name of the run, date of termination, time oftermination, No. of tolerated faulty documents.Then execute.Information Structures in SAPGenerated by Jive on 2015-01-19+01:0013 10. Go to LBW0. Specify info structure and click generate data source.Information Structures in SAPGenerated by Jive on 2015-01-19+01:0014 -- Go to Data Source in the menu bar and click on generate.--Data Source 2LIS_01_S898 has been generated as shown below.Information Structures in SAPGenerated by Jive on 2015-01-19+01:0015 11. Display settings of your information structure in LBW0. Settings of info structure will be summarized as below:Information Structures in SAPGenerated by Jive on 2015-01-19+01:0016 *******Karuna Ravuri