table and field required

[Former Member]

Dear Experts,

I have maintain planned revenue through CJ42. Now we required to pull this value to a customized report. Can you please help me with table name and field for fetching planned revenue values.

Thanks in advance

Pabak kumar rout

[Former Member]

Hi,

In addition to our friends suggestion, you should be careful while selecting revenue because of you will find two type of revenues. from table RPSCO

1. Revenue from Quotation - Value type 28

2. Revenue from Sales Order - Value type 29.

Thanks,

Sudhakar

[Former Member]

Hi,

Use RPSCO table. Here use below fields:

OBJNR : i.e. WBS object no, you can get it from PRPS table

WRTTP : Value Type like Plan/Actual etc.

ACPOS : Value Category like revenue/income etc.

Regards

Shishir

[former_member252544]

Hi,

Check with table RPSCO. Here input the object number you get planned revenue for Value type 1(Plan) & budget type KSTR(Revenue planning).

Regards,

Sachin.

[panagiotis_papaspyridakos]

Hi

you can use tables coep for line items, or cosp and coss that holds totals per years...

Cheers

Panagiotis

ps Business transaction RKP5:Planning Revenues