cancel
Showing results for 
Search instead for 
Did you mean: 

Abap report for budget/actual/commitment

Former Member
0 Kudos

Hi Guru..

Please help me.

Im in urgent

I wanna write an abap program for budget/actual/commitment.

I try to trace prgram s_alr_87013019, but only one table found.

Please let me know which table is using for budget/actual/commitment

report..

Please guru..

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hello Mohd

The budget, actual and commitment are all in one table COSP.

The entries for actual has the parameter COSP-VRGNG = 'COIN',

for commitment: 'RMBE' and 'RMBA' and for the budget (plan) it is 'RKP1'

Hope this helps

Marta

Former Member
0 Kudos

Hi Marta,

Thanks for the answer.

But im have a little confuse.

Which field is use for actual,budget and coomitment?

And how to differentiate which one is use?

Please help

Former Member
0 Kudos

This is not normal ABAP report...It is created using Report Painter and drill-down reporting.

Former Member
0 Kudos

Hello Mohd,

The actual,budget and commitment values are stored in the one table COSP.

The values differentiate with field <b>VRGNG</b> - "CO Business Transaction".

If the record has in this field text '<b>COIN</b>' it means that values are "actual".

For example:

OBJNR PR00000101

GJAHR 2005

KSTAR 101101

VRGNG <b>COIN</b>

TWEAR USD

WTG001 100,00

WTG002 200,00

...

It means that the element PR0000101 has the '<b>actual'</b> operations refering

the cost element 101101, with values: 100,00 USD in january 2005 and

200,00 USD in february 2005.

The next row in the table COSP, clould look like this:

OBJNR PR00000101

GJAHR 2005

KSTAR 101101

VRGNG <b>RMBA</b>

TWEAR USD

WTG001 100,00

WTG002 0,00

...

This means that there was a <b>'Purchase requisition'</b> in january 2005

with decretation on object PR0000101.

And the next row, could be:

OBJNR PR00000101

GJAHR 2005

KSTAR 101101

VRGNG <b>RMBE</b>

TWEAR USD

WTG001 0,00

WTG002 150,00

And that means that in february 2005 there was a <b>'Purchase order'</b>

with value 150,00 USD decretated on this object.

I hope, that my explanation is now clear and accurate.

- Marta

Former Member
0 Kudos

Hi Marta,

Can i ask little question regarding this issue?

Can you explain on field VRNGN such as RKP1,RMBE,RMBA and others?

Is it RMBE and RMBA same?

Please help

Former Member
0 Kudos

Hello Mohd,

RMBA is the "Purchase Requisition" (created in transaction ME51n)

RMBE is the "Purchase Order" (created in transaction ME21n).

But both of these operations sum into commitment.

RKP1 stands for "Plan", but <b>depending on configuration</b>,

one of plan's versions can be the budget.

For example you can say, that plan in version 0 is the budget.

The best it would be, if you perform the check on <b>your</b> system:

1. Choose one order that you know it has represetaives data in your raport s_alr...

2. Open table AUFK, and write down the 'object number'- field OBJNR.

3. Open table COSP, and select data for OBJNR, that you recived in previous step.

4. Check what values do you have in the field VRGNG.

This should give you all information that you need.

Regards

- Marta

Former Member
0 Kudos

Hi Marta,

I think you still can help me and I can give you more points.

What is the table regarding budget/planning activity such as KBN0/KBUD/KBR0 and much more..

I hope you can help me..

Thanks guru..

Former Member
0 Kudos

Hello Mohd,

The full list of Business Transactions is in the table <b>TJ01</b>.

It has the structure like follows:

<i>VRGNG</i> - this is Bussines Transaction we disscussed before.

<i>XCOEP</i>

<i>XCOEJ</i>

<i>XCOOI</i>

<i>XCOSP</i>

<i>XCOSS</i> - 'X' in these fields indicates, that values of this kind of

transactions are stored in table COEP, COEJ, COOI, COSP, COSS

and so on.

...

It is possible that one Business Trans. is stored in more than one table.

For example:

VRGNG - 'RMBE'

XCOEP - ''

XCOEJ - ''

XCOOI - 'X'

XCOSP - 'X'

XCOSS - ''

It means that values of 'Purchse Order' are stored in tables COOI and COSP.

This is possible because COOI stores values of line items , and COSP

stores the sum value of items in one document.

Thanks for compliment (and for points )

Regards

- Marta<b></b>

Former Member
0 Kudos

Hi Marta

Thanks for the solution..

Former Member
0 Kudos

Hello Mohd, Marta,

I have a very urgent requirement to write a report to list Budget/Actual/Commitment of all the internal orders related to a given company code. I am using ECC 5.0.

I found very usefull information in your discussions in this thread. Could please send me the logic of your program . .. Please.. It will really help me..

Thanks in advance.

Helen.

Answers (0)