Skip to Content
author's profile photo Former Member
Former Member

Problem with Budget / Period/year

Hello All,

I have generate a Report with the Report Painter ( logical Database PRJ). The result should be exportet in MS-Excel.

I'm looking for the Tables.

He are the tables from the generates Report.

TABLES: RPSCO_X, COIX, COIX_DATA40, RKB1X, RKB1F, RKB1D.

<b>Could anybody tell me the table for Budget per Period/year ?????</b>

The Result is:

Period/year Budget Actual Commitments

Displayed in 1 EUR 1 EUR 1 EUR 1 EUR 1 EUR 1 EUR 1

  • * * * * * *

,001.2006 1. Period 2006 10.000 10.000 0 0 0 10.000 100,00

,002.2006 2. Period 2006 10.000 10.000 0 0 0 10.000 100,00

,003.2006 3. Period 2006 10.000 10.000 0 0 0 10.000 100,00

,004.2006 4. Period 2006 10.000 10.000 0 0 0 10.000 100,00

,005.2006 5. Period 2006 35.000 35.000 200.000 100.000 100.000 65.000- 185,71-

,006.2006 6. Period 2006 10.000 10.000 0 0 0 10.000 100,00

,007.2006 7. Period 2006 10.000 10.000 0 0 0 10.000 100,00

,008.2006 8. Period 2006 10.000 10.000 0 0 0 10.000 100,00

,009.2006 9. Period 2006 10.000 10.000 0 0 0 10.000 100,00

,010.2006 10. Period 2006 10.000 10.000 0 0 0 10.000 100,00

,011.2006 11. Period 2006 10.000 10.000 0 0 0 10.000 100,00

,012.2006 12. Period 2006 10.000 10.000 0 0 0 10.000 100,00

+Result 145.000 145.000 200.000 100.000 100.000 45.000 31,03

<b></b>

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jan 08, 2007 at 03:46 AM

    Following are the tables of budget

    <b>Table Name</b> <b>Short text</b>

    BPBK Doc.Header Controlling Obj.

    BPCG Controlling Object, by Year

    BPCJ Controlling Object, by Year

    BPCK Controlling objects, activated objects

    BPEG Line Item Total Values Controlling Obj.

    BPEJ Line Item Annual Values Controlling Obj.

    BPEP Line Item Period Vale Controlling Obj.

    BPGE Totals Record for Total Value Controlling obj.

    BPGV Prel.entry, overall

    BPHI Cross-hierarchy Data Controlling obj.

    BPIG Budget Object Index (Overall Budget)

    BPIJ Budget Object Index (Annual Budget)

    BPJA Totals Record for Annual Total Controlling Obj.

    BPJV Prel.entry - annual values

    BPPE Totals Record for Period Values Controlling Obj.

    BPTR Object Data Controlling Obj.

    BPTX Budgeting Text

    BPUM Conversion: Tables/Fields to be Converted

    BPVK Document header preliminary entry

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 07, 2007 at 04:05 PM

    Hi

    Budget information will be stores in BPJA Table. You please try the same.

    reg.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 08, 2007 at 06:53 AM

    Hi Christian,

    it's table <b>RPSCO</b>

    and field WRTTP EQ <b>41</b>

    A.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.