Data extraction from Structure.

[Former Member]

Hi All,

Could you please tell the steps for extracting data from Structure.

Thanks in Advance!!

[JL23 · Accepted solution]

you can only extract data from a table.

structures holding data only temporarily during run time of a program.

A structure is a combination of fields from one or more tables.

A program reads the data from the tables and holds it for later use temporarily in a structure.

If the program has finished, no data is left in the structure, its like a television without recording device.

[raghavan_iyengar3]

Preeti,

you can extract data from SAP by MC23. also please check these options

Steps in LIS EXTRACTION:

T.code u2013 :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 infostructure

Example u2013

Inforstructure : 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

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 u20131)No updating,2)Synchronous updating (V1), 3)As synchronous updating (V2), 4)As synchronous updating (V3),

T.code u2013 LBW0 u2013 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 infostructure (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 infosource u2013 Create infocube u2013 Create update rules u2013 create infopackage 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 u2013 create infopackage and schedule the package with delta update.

First time if your scheduling the infopackage -in R/3 side T.code :MC25 -Udating set to No update,insted 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 infopackage with delta update.

Modules for LIS : SD,MM, PP,QM.

Deltas for LIS:

After setting up the LIS environment, 2 transparent tables and 1 extract structure is generated for this particular info structure. Within transaction SE11 you can view the tables u2018SnnnBIW1u2019, u2018SnnnBIW2u2019 and the structure u2018SnnnBIWSu2019 and the InfoStructure itself u201ASnnnu2018

The tables S5nnnBIW1 & SnnnnBIW2 are used to assist the delta update process within BW.

Extract structure u2018SnnnnBIWCu2019 is used as an interface structure between OLTP InfoStructure and BW

The OLTP system has automatically created an entry in the control table u2018TMCBIWu2019. Within transaction u2018SE16u2019 youu2019ll see, that for your particular InfoStructure the field u2018BIW activeu2019 has the value u2018Xu2019 and the field u2018BIW statusu2019 is filled with value u20181u2019 (refers to table SnnnBIW1).

The orgininal LIS update program u201ARMCX#### will be enhanced within the form routines u201Aform Snnnbiw1_update_u2026.u2018 and u201Aform Snnnbiw2_update

With the transaction u2018SE38u2019 youu2019ll see at the end of the program starting at line 870 / 1006, that the program is enhanced within a u2018BIW delta updateu2019 coding

Within the flag u201AActivate/Deactivateu2018 the update process into the delta tables (SnnnBIW1/Sn5nnBIW2) is swichted on/off. In the table u201ATMCBIWu2018 is defined, which table is active for delta update.

Note: The delta updating is client dependent !