LO Extraction

Enabling

Goto Tcode RSA5 in ECC

Select the datasource we are going to enable....and click on Activate Datasource

Now goto Tcode RSA6 to check whether the activated datasource is available there

Customizing

In ECC datasource have 2 structures..

Transfer Structure (TS) and Extract Structure(ES)....

Extract structure is the super set having all fields of datasource... and transfer structure is the selected and customized fields which is replicated to BW..

Extract structure have all the must have fields of the underlying tables..

If any new field is to be added to Extract structure... we can add it from Communication structure, which is having all the fields of underlying tables..

Drag and drop the extra fields from communication structure to extract structure

All the must have fields already residing in Extract structure will be in Blue color... and the new fields added from Communication Structure will be in Black color...

Adding new fields to the Extract Structure is called Customizing..  

Goto Tcode LBWE (LO Data Extraction Customizing Cockpit)

All the Modules under Logistics will be listed here

we can find the extract structure of our datasource here...

To do Customization... we have to turn it into Inactive mode...

The one in left side is the Extract Structure and in right is Communication structure...

To add new fields ,

Newly added field is black in color..

Data Loading

Transaction is getting posted in DB tables.... Communication Structure has all the fields of DB tables..

All the necessary fields are selected in Datasource...

In LO extraction we have an intermediate table called Setup table.... During the first load... data will be pulled to setup table first... and when full load package is executed... data is pulled from setup tables...

every data source will be having individual setup table... 

filling of setup table is called statistical setup run...

After the successful completion  INIT infopackage, delta queue is created in ECC...

every new record created in ECC will be appeared in delta queue...

Note: while filling setup table, Users should be locked. No posting should be done at that time..

Goto Tcode SBIW

now Goto RSA3 to check the availability of data..

now replicate datasource to BW

create Infopackage and pull using full load...

Now create INIT Infopackage to create Delta Queue..

after completion of INIT ... delta queue will be created... now you can unlock users...

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