Database table

[Former Member]

Hi,

What is the database table used in the Tcode S_ALR_87013326 - Profit Center Group: Plan/Actual/Variance.

I have to develope a report to show the data as Plan Vs Actual..

Thanks & Regards,

Dhanunjaya Reddy

[Former Member]

Hi

These are the table name which iis used in that T code.

SHDTV Transaction variants

SREPOLIST Reporting: Lists

SREPOVARI Reporting: Reports and Variants

TMENU01 Node Table for General Structure Storage

TSTC SAP Transaction Codes

TSTCP Parameters for Transactions

TSTCT Transaction Code Texts

TTREE Definition table for structures

Regards

Prajwal K.

[Former Member]

Hi Prajwal,

Thanks for your quick reply.

I need the database tables of Plan data and Actual data.

Regards,

Dhanunjaya Reddy

[Former Member]

Check the tables.

TKA01 Controlling Areas

GLTPC Profit Center Accounting

GLPPC Profit Center Accounting: Plan line items

Edited by: Mahalakshmi Padmanaban on Feb 2, 2008 6:00 AM

[Former Member]

Hi Dhanunjaya Reddy

Have you found the field and table for plan and actual amount?

Can you share with me the information here, I need the actual only.

In case you still didnt get the info, I found out the plan amount is from table GLPCT, field HSL01 - HSL12...If Im not mistaken.

Thanks & Regards

[Former Member]

Thanks to all of you.