COPA, how to derive Profit Segment as a characteristic

[Former Member]

In COPA I created a characteristic u201CSegmentu201D to report on the Profit Center Segment. I am trying to use Define Characteristic Derivation, T-code KEDR to derive and populate the Profit Center Segment characteristic.

I did the following: use u201CTable Lookupu201D and link it to table CEPC.

1) In the source field the following 3 fields appear and I mapped them to COPA fields:

CEPC-PRCTR Profit Center

CEPC-DATBI Valid To Date

CEPC-KOKRS Controlling Area

2) In the "Assignment of table fields to target fields" section I mapped the CEPC-Segment field to the COPA "Segment" characteristic .

The problem is it does not derive the Segment!

Am I doing something wrong?

Is this the best way to determine the Profit Segment?

Have you seen this before?

Any help will be highly appreciated!!

[ajaycwa1981 · Accepted solution]

Hi

Select the Derivation rule and Press F8 to test it

Enter the Profit Center and Click on "Derivate".... Then Click on "Analyze Derivation"... Now go to your derivation step

You will come to know why your Derivation rule is not successful

I think the valid to date is not supplied during the transaction... May be you can map CEPC-DATBI to Global - UserTemp1

Regards

Ajay M

[Former Member · Accepted solution]

Ajay, thanks for your reply.

The setup is exactly as you suggested, playing more with it I also added some fixed conditions and it is still not working. I did the analysis before and did it again upon your recomendation but unfortunately no sucess. The profit center=segment entries are in CEPC (checked with se16)......

Here is the log from the analysis.

0067 Table lookup Determine Profit Center Segment

Derivation was not carried out. Reason: Source field contains no value.

Check condition for step

Origin Field Name Description Content Op. Constant Result

GLOBAL USERTEMP1 Temporary field 1 (user-de < 12/31/9999 Fulfilled

CO-PA KOKRS Controlling Area GLOB = GLOB Fulfilled

CO-PA PRCTR Profit Center 0000010111 = 0000010111 Fulfilled

Source fields

Origin Field Name Description Content Comments

CO-PA PRCTR Profit Center 0000010111

GLOBAL USERTEMP1 Temporary field 1 (user-de Source field contains no value

[ajaycwa1981 · Accepted solution]

Hi

I could not understand your Log...

Can you write it clearly mapping each field to field between CEPC and COPA

SOURCE FIELDS

CEPC KOKRS TO COPA-KOKRS - VALUE BEFORE/AFTER - FULFILLED OR NOT

CEPC - DATE TO COPA-USERTEMP1 AND so on

TARGET FIELDS

CEPC TO COPA

or paste screenshot here.. You can host your screenshot on imageshack.us and give us the link here

Regards

Ajay M

[Former Member · Accepted solution]

I am not able to provide you with screen prints, letu2019s see if I can describe:

1) The CHARACTERISTIC DERIVATION is set up as follows:

a) Source Filed for Table Lookup

CEPC-Profit Center = CO-PA u2013 PRCTR

CEPC-Valid To Date = GLOBAL-USERTEMP1

CEPC-Controlling Area = CO-PA-KOKRS

b) Assignment of Table Fields to Target Fields

CEPC-SEGMENT = CO-PA-WWSEG

2) After running ANALYZE DERIVATION STEPS the following two lines appeared:

a) Line 1:

Origin = CO-PA

Field Name = PRCTR

Description = Profit Center

Content = 0000010111

Comments = u201CBlanku201D

b) Line 2:

Origin = GLOBAL

Field Name = USERTEMP1

Description = Temporary field 1 (user-de fined)

Content = u201CBlanku201D

Comments = Source field contains no value

[ajaycwa1981 · Accepted solution]

Hi

That means the GLOBAL-USERTEMP1 is unable to get the value.. Is that understanding correct?

Can you try to define it as a constant of 31.12.9999 or the VALID TO date of your profit centers.... I hope you would have same validity date for all pr ctrs

If this does not work, then create a derivation step using "Enhancement", instead of table lookup and use exit COPA0001.. Ask your ABAP guy to write the code

Regards

Ajay M

[Former Member · Accepted solution]

ThanX for your help Ajay!

I was hoping not to do the "coding" solution. I am still surprised that Segment can not derived via Table Lookup.

Andre

[Former Member · Accepted solution]

Hi All,

I have a similar kind of issue and I am getting the same log while analyzing derivation. Please help with the step adopted to solve the issue.

Thanks

PM

[Former Member · Accepted solution]

Dear Ajay

Is there anyway that we can derive a characterisitc from the field functional area FKBER ??

Thank you

Gayani