How can you determine what the Key fields are in a standard extractor?

[Former Member]

Hi there,

I am doing some analysis on standard extractors. Please can you let me know what the key fields are of Extractor PM_TASKLIST_ATTR? And how can I find this for other extractors?

Many thanks

Michelle

[RamanKorrapati · Accepted solution]

Hi Michelle,

Above extractor was master data attributes one.

Your main primary field will task list(think so).

for ex: we have 0MATERIAL_ATTR. in this extractor i primary field was Material.

Material at ecc side as MATNR and at bw side as 0MATERIAL.

http://help.sap.com/saphelp_nw70/helpdata/en/c2/2764403899980ae10000000a155106/content.htm

Thanks

[Former Member · Accepted solution]

Many thanks Ramanjaneyulu for your answer...

Perhaps I should not have given 0PM_TASKLIST_ATTR as my example since it is a masterdata extractor...

If I take a transactional extractor, how can I tell which fields, for example 2LIS_17_I0ACTY.

Please can you let me know where in the system I should check which fields in this Extractor are Key Fields?

Many thanks

Michelle

[RamanKorrapati · Accepted solution]

Hi Michellye,

Extractors which are startes with 2LIS* you can check at Tx - LBWE(ECC system).

All SAP Defined data source can display at Tx -  RSA5(ECC system) and for custom defined data source visible at Tx - RSA6(along sap defined data soucre once they are in active)..

You can check data source individually at Tx - RSA2.

Extrcators always build by using  tables. once we know the base tables thru that also we can find primary.

For your data source , these are the base tables - QMEL,QMFE, QMMA

Primay field - QMNUM - Notification Number

http://help.sap.com/saphelp_nw70/helpdata/en/ed/af2b85984646589130f0b8cbd28cb0/content.htm

Thanks

[Former Member · Accepted solution]

Many thanks again Ramanjaneyulu for your reply..

It's becoming a bit clearer now.

So, just to confirm, have you have found what tables are used in this extractor using a google search, per the SAP Help link you provided or is there a way to check in the system?

Now that you have the 3 tables QMEL, QMFE and QMMA (eventhough in the link to SAP Help, they are listed MCQMEL, MCQMFE and MCQMMA, why is that?)...Did you then check SE16N to see what the key fields for these tables are?

In this case...

QMEL - QMNUM

QMFE - QMNUM & FENUM

QMMA - QMNUM & MANUM

Why is the primary field only QMNUM and not all 3 fields, QMNUM, FENUM &b MANUM?

Many thanks

Michelle

[RamanKorrapati · Accepted solution]

Hi,

To find out the base tables of extractors i searched on google or as well Tx -  LBWE.

as you said, "they are listed MCQMEL, MCQMFE and MCQMMA" these are communications structure. forming with tables names prefix of MC.

From that you can take Table names: QMEL,QMFE and QMMA. these same info we can get to LBWE.

Go to Tx - LBWE, go to respective application, data source, there you may see two hyper links like

maintenance and your data source name.

click on maintenance link, it may give one pop with two tables kind left and right.

Left side have fields which are part of your data source and not possible remove(which are in blue colors). Right side objects are form communication structure. from top you may see ALL or comm. str names like MCXXXX,MCXXXX. those are base tables(XXXX) for respective data source.

if you google about Communication and extract structure you may get useful info. these are basics for extraction concept.

Thanks

[RamanKorrapati · Accepted solution]

Hi,

once you know the base tables form their also we can take which was the primary keys(from all source tables). other wise  with help function team also we can conclude which are primary keys.

Thanks

[former_member202718]

Hi Michelle,

The standard-SAP defined will be having standard Flow in BW as well,most of them will have the SAP defined DSO with proper Keys..only few have direclty to cube flow.

rgds

SVU123

[anshu_lilhori]

Hi,

For 0PM_TASKLIST_ATTR

The infoobject will be 0TASKLIST

As far as masterdata infoobject is concerned if any field is compounded in it then it becomes the keyfield otherwise the one which is the main infobject will be keyfield.

So in your case it will be the field which will be mapped to 0TASKLIST .

check this as well.

http://help.sap.com/saphelp_crm60/helpdata/en/2b/62d57358d04c5c97bb3df58743dbd4/RN_7036_en_v4.pdf

Hope this helps.

Regards.

AL

[Former Member]

Many thanks Anshu for your answer...

Please can you let me know where in the system I should check which fields in a extractor are Key Fields? eg 2LIS_17_I0ACTY

Many thanks

Michelle

[former_member213275]

Hi,

The base table for 2LIS_17_10ACTY is "QMEL" and the primary key for this is QMNUM-Notification No.

Srikanth.

[Former Member]

Thank you Srikanth,

I have many many extractors to check therefore I need to know 'how' you know this?

What are the steps you have taken to find out what the table or tables are?

What are the steps you have taken to find out what the primary key fields are?

Many thanks

Michelle