Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Database table

Former Member
0 Kudos
315

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

5 REPLIES 5

Former Member
0 Kudos
100

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.

0 Kudos
100

Hi Prajwal,

Thanks for your quick reply.

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

Regards,

Dhanunjaya Reddy

Former Member
0 Kudos
100

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
0 Kudos
100

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
0 Kudos
100

Thanks to all of you.