Extraction Using View

Posted by on







The data of a view is derived from one or more tables, but not stored physically. 

for Knowing more about table relations in SAP , http://www.recercat.cat/bitstream/handle/2072/5419/PFCLopezRuizAnnex3.pdf?sequence=4


Lets create a view from 2 MM tables

 EINE - Purchasing Info Record: Purchasing Organization Data
EINA - Purchasing Info Record: General Data

 To create view, Goto Tcode SE11( ABAP Data dictionary)


































Now we have few fields selected from both tables...
Activate view..



Now create Datasource for this view..

 Goto TCode RSO2











check data through extractor checker..


So we have data in out data source..

 now replicate it to BW...



















We have data is PSA.... now take it to the corresponding target...
Best SAP training in Kerala
Best SAP training in Kochi
Best SAP training in Ernakulam
SAP FICO, SAP MM, SAP SD, SAP PP, SAP ABAP, SAP Basis, SAP SAC, S4Hana

Comments

  1. DADAMay 15, 2014 at 2:29 AM

    good description, can u please add text description to starting screen shots, that might useful for beginners like me.
    great effort, appreciate u

    ReplyDelete
  2. AnonymousAugust 27, 2014 at 5:01 AM

    can we extract data from ecc to bi if the data package is """$tmp

    ReplyDelete

Post a Comment