+++ 7.Generic Extraction - Info-set Query



STEP 1: In R/3 Go to command bar use T-code ‘SQ02′
Give a Info set name and press create button

https://lh3.googleusercontent.com/Cxe-EGRLiMqJLqHxAHLt1AUieLhoWce6vh9SZqEwtdYAQ5SdHc-OQciCDpIhfB4AQGOtxEUF8G6ixdyUVmCA9qDgBGHeEK2tlAv3ai4GZE6yVinnIf2BozlEmnWxlNCKnTMWfSjHRLP6M2bozQ

A new window pops up, gives name and selects the check box direct read table and give table name (Example VBAP) to extract as shown and press continue button.

https://lh5.googleusercontent.com/JfylPNWEZt3L_LDq-qxAdlEiZo5lZVOeA89T6-lgZ6oXmVJIcfqjygdEB8Le4NoThN4EuPwNxzCMoTMIdPr6034lQx-P2__eqw5iol0p3uog0PY9SyeoMH6rIDXEpyLxofEtpyemW-oRdJtehA


STEP 3:
A small window pops up check the box create empty field groups and press continue.

https://lh6.googleusercontent.com/nr6Fuft_4pJtvWGfr6ewYa0GkVJMTECHjQMQnVflhU-H4OolNqEnrohZ01B5K5TLsZMHNPmJZB4g2E7OB97YgvSlpxeYd45Si5qh7Yh5Rd2WO0lH4Z9rfLe4i2rhzS0jZZB7FyIk_GCgT1-M-A


STEP 4:
Here a new window pops up; Drag the table fields you want to extract from left to right folder. (Here we are creating extraction structure of the info set adding field at right side). Then press generate button.

https://lh3.googleusercontent.com/WLHq3vUrI2puxKk0LGpwbwS1F5rx4RwYrTtcB9WMjzUfrpAbhoiaaLYFkJQ-QlN6gDlPLohEe6VYfkkyg6tq8VSm0E46ymJypOj7hnDySx9qirJa_1fAQRkOKVoWCzeCS3kmZYYpvPqeiCIIxw


STEP 5:
window pops up give package name and press local object.( after pressing local object Info set generated was see at the bottom)

https://lh3.googleusercontent.com/yXOmk-j0CVYmIW9kDJIovQRE1lOZE8XUL1tRegZChDmSRcefgMxyl5kwz6qJ0xsYUg9SslEcqn4HHMP79qTVrtv-5nBV76LMCzGgaZInc-wpWyR2v7K-WxmN7lhS9CF4aIVueX4cQY7JdZv10g


STEP 6:
Now Create the Data Source using Tcode -RSO2
Check the check box create transaction data and give any name and press create.

https://lh4.googleusercontent.com/UBMf023GS8uHuShqJuIdg-fqvYo79nEkobY-CEHHly098UuBcUwYuVienWsBZ5ChING0Y8VWQ8MxxJaBFLunhYyIOOTkUCPYRVKEwSp6IEU6gSfGp0HlKFcCj1PR0nwNZ7b8IWyIlO1IcqJGyA


STEP 7
: Below data source window pop’s up, give application component name related to table and give text description , then press Extraction from Querybutton, Info set window enables give table name of info set table name Example vbap, then press save button and press Generic Delta.

https://lh5.googleusercontent.com/diEfcRlncTdCoyUTqPW4VqwMiXKf6a51VgTQP9w_MtSd5Ecqb2T3keZnpryph1h7019Bf_9mlq96WjW0h-Yt_P7PqaoYt4eUwjSG_nrLcIIOyoqfqgRcw3j_TIT79QD0dszVt9Z-VfvnaI6Q3Q


STEP 8
: A new window pops up select the fields by checking box’s then SAVE it and close the window.

https://lh6.googleusercontent.com/BkfJAlv4eDCNhug7l5M3VoXHpAVh7tlyG2S2ZEJmgJ_qbPjxRM_Go-W3ugnFlvaCCNfxXGzz4TqGcHmNmbUzYGlu0ZkV8PSwq_j4JmFju7DEgqrE7edO0KuxBVZ-R93qsRtcJmT5qBD81csiIA


STEP 9:
Open new window, in command bar use T-Code RSA3 below window pops up
Now enter data source name and press extraction button below and now in selection field give value, and press again extraction and display list button.

https://lh4.googleusercontent.com/jTQMSd9HxSRBj_HDHh8LhPam_7Oej5pts8sATvnR_usrY4KAQI9ctH4Rm3pdvQelygU_FFlCsb111BuI5eevECv6Oti29DyJ9pJyPfCdbssg6VcMTcF_fVWMWJzfXFS71sKC6x_6RRwpziNyIg

 

*****************************