Filtering data at the Source based on Document Type for 2LIS_02_ITM

[Former Member]

Hello All:

I am trying to filter data based on certain purchasing document type for 2LIS_02_ITM and _SCL datasources.

I want to filter in R/3 instead of in BW

Any ideas on how to go about ?

Regards

Vijay

[Former Member · Accepted solution]

Hello All:

Document type is 'greyed' out in DS so, i can't enable it in RSA6. For the same reason it is not selectable in the infopackage.

Basis here don't want us to modify ROOSFIELD table.

so, my options are write a start routine in BW which might affect the load performance OR filter it in R/3 which is what i am leaning towards ...

Regards

Vijay

[Former Member · Accepted solution]

Vijay,

you have 3 options.

1. you write this in the User Exit on SAP Side.

2. you can write in Transfer Rules( Start Routine)

3. You can write in Update Rules(Start routine).

All the best.

Regards,

Nagesh Ganisetti.

[Former Member · Accepted solution]

Hi

I am leaning towards the user exit

In the user exit do i have to loop thru whole data set to get certain document types or

Can i do a SELECT * WHERE BSART = 'A', 'B', 'C'

I am not an ABAPper so, excuse the syntax

regards

Vijay

Message was edited by: Vijay U

[Former Member · Accepted solution]

Vijay,

you are getting data for all the Document Types, so no need of any select Statements.

use this code in your User Exit. and let me know if you have any questions.

CASE I_DATASOURCE.

WHEN '2LIS_02_SCL'.

Delete C_T_DATA where BSART eq ‘C’.

ENDCASE.

Note: you need to give Document types which r not required fro BW extraction in EQ.

'C' i gave for test... give the document types which r not required for you.

all the best.

Regards,

Nagesh Ganisetti.

[Former Member]

Hi Vijay,

you can put the restrictions in the infopackage and extract the data. If you do not find the field that you want to restrict in the selection of infopackage, make it a selection field in RSA6. This might help you.

Thanks and Regards

Subray Hegde

[Former Member]

Vijay,

i got your point. you want to filter the Data vefore filling into Setup tables. if that is the case, if you have any field on the selection screen of the Fill Setup tables. you can do that. even if you restrict that.. still you need to restrict in IP for both initalizations and Delta.

All the best.

Reagrds,

Nagesh Ganisetti.

[sachin_kulshrestha2]

Hi,

on R/3 you can use RSA3 Extractor Checker where you can filter the data based on selection and can see the output.

If you require to bring the data in BW based on purchasing doucment type then you can use the selection options of infopackage to accomplish it.

Hope this helps!!!

[Former Member]

Hi,

If you want to extract the data only purchasing doucment type then you can hide all the fields in the data source in bu using the T.Code LBWE --- maintaining data source.

Thanks & regards,

Venkata Sharma.

[Former Member]

hi,

What about the selection in the Info Package?

Regards,