cancel
Showing results for 
Search instead for 
Did you mean: 

How to choose key field in ODS for extractor 0ec_pca_3 Line items

Former Member
0 Kudos

I need to build a ods for PCA (profit Centre Accounting)Line items. My Extractor and infosource is 0ec_pca_3. it picks up data from glpca table and in glpca table the primary key is record number and client, which doesnt appear in my data source.

> how do i choose the key fields for my line items ods ?

> i connected the infosource directly to cube for testing. it worked , but when i move to production i want to feed the cubes through ods to prevent problems later with deltas and others. what could be the possible other problems of direct update to cube ?

> i saw suggestion on forum to create a counter infoobject that you would feed with something like request_id+record number in request,

plz give me a procedure and code to do that if there is no other way

plz help me out .....

thanks in advance

Points will be assigned for inputs

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

The ODS Key I have used is as below. It works fine.

Document Number of Profit Center Accounting

Time Created

Time Stamp

Line Item of Profit Center Accounting

Document Type of Profit Center Accounting

Document Line

Accounting document number

Fiscal year variant

Currency Type

Value Type for Reporting

Former Member
0 Kudos

Hi sailesh,

Thanks for your reply

when i look at my infosource it is associating

document number of profit centre accounting infoobject with DOCNR which in turn is account document number in data source.

so plz give me the field name for

profit centre accounting infoobject ?

and can you plz confirm the following field names, <b>atleast the first five plz</b>

Document Number of Profit Center Accounting - dont know

Line Item of Profit Center Accounting - DOCLN

Document Type of Profit Center Accounting - DOCCT

Document Line - REFDOCLN

Accounting document number - DOCNR

Fiscal year variant - FISCVAR

Currency Type CURTYPE

Value Type for Reporting -VALUE TYPE

Time Created - CPUTM

Time Stamp - TIMESTAMP

Message was edited by: ravi a

Former Member
0 Kudos

Here You Go

Document Number of Profit Center Accounting - DOCNR

Line Item of Profit Center Accounting - DOCLN

Document Type of Profit Center Accounting - DOCCT

Document Line - REFDOCLN

Accounting document number - REFDOCNR

Shailesh

Answers (4)

Answers (4)

udayabhanupattabhiram_cha
Active Contributor
0 Kudos

Hi Ravi:

Since all of your records will be unique, your Update Mode (Aggragation or Overwrite) doesn't matter right.

So, you can use it. When you move data from ODS to Cube, etc, then its aggragation anyway, so your totals should always be right.

If you want to use other methods to get unique records, you can as well use this SAP deleivered one rather than write your own code.

Ofcourse if you find the combination of keys, use them.

Ram C.

Former Member
0 Kudos

Hi Ram,

I will try loading the way you told ...

udayabhanupattabhiram_cha
Active Contributor
0 Kudos

Hi:

Write the Code in Updare Rule. Since that is the only key field, it will not ask you th eusual question like you get in a Cube.

The Code will work.

What you wrote is correct. you don't need result =....

beacuse the function module will directly update the result.

As a note, use this only if you cannot get the key FIELDS and there should be no aggregation OR if there are Too Many Key FIELDS (which may affect the performance).

Ram Chamarty

Former Member
0 Kudos

Hi Ram

Thanks for note....i have Fields like total credit posting and debit positng , cumulative balance...i modified update method to add..as it is additive delta and is giving warning if i use move type in update rules that it wont update the data ...

based on the above i can't use your method..is that right?

can you also comment on use the other method of combining request id and record id in this case..will that work ?

-((

I need to wait for shailesh to help me out...

udayabhanupattabhiram_cha
Active Contributor
0 Kudos

Hi:

1) Try a search by Technical Name.

2) Go to Cube change mode and there, in Characteristics Tab, select All infoObjects and do a search here too.

Also, check in Unassigned Nodes manually

Ram C.

Former Member
0 Kudos

Hi Ram,

I added the infoobject manually in the ods and it worked.

I placed you code in the program and then i removed the line

Result = . given in the code..did i do it right?

thanks

Message was edited by: ravi a

Message was edited by: ravi a

udayabhanupattabhiram_cha
Active Contributor
0 Kudos

Hi Ravi:

If the keys doesn't work and you want a unique number, try my suggestion. it is better and faster than tryng to combine Request ID and Serial Number.

Look for this InfoObject - 0BBP_OBGUID

If its not available, install it from Businedd COntent.

THen, add this to the ODS as Key Field. Move all others to Data Fields.

In the Update Rules for thsi InfoObject, write this Code:

CALL FUNCTION 'SDOK_UNIQUE_ID_GET'

IMPORTING

unique_id = RESULT.

Ram Chamarty

Former Member
0 Kudos

Hi Ram

Thanks for your quick reply,

I installed the object from business content with collection mode only required object.it said installation sucessful but with warning saying it should be only used as key figure with no master data.

but when i come back i dont see it in infoobject tree in modelling area, even after refreshing..can you help me there?