topic Re: Database table in Application Development and Automation Discussions

Database table

Former Member — Sat, 02 Feb 2008 04:44:02 GMT

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 — Sat, 02 Feb 2008 04:53:13 GMT

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 — Sat, 02 Feb 2008 04:59:18 GMT

Hi Prajwal,

Thanks for your quick reply.

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

Regards,

Dhanunjaya Reddy

Former Member — Sat, 02 Feb 2008 04:59:43 GMT

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 — Tue, 11 Mar 2008 06:41:20 GMT

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 — Wed, 16 Jul 2008 04:19:05 GMT

Thanks to all of you.