topic Error on PA infotypes in Application Development and Automation Discussions

Error on PA infotypes

Former Member — Tue, 25 Sep 2007 07:35:10 GMT

Hi,

I got some errors while doing PA infotypes creation.please help me.

Short text

A table name, specified in an SQL command, is unknown.

What happened?

Error in the ABAP Application Program

The current ABAP program "SAPFP50P" had to be terminated because it has

come across a statement that unfortunately cannot be executed.

What can you do?

Note down which actions and inputs caused the error.

To process the problem further, contact you SAP system

administrator.

Using Transaction ST22 for ABAP Dump Analysis, you can look

at and manage termination messages, and you can also

keep them for a long time.

Error analysis

An exception occurred that is explained in detail below.

The exception, which is assigned to class 'CX_SY_DYNAMIC_OSQL_SEMANTICS', was

not caught in

procedure "READ_DATABASE" "(FORM)", nor was it propagated by a RAISING clause.

Since the caller of the procedure could not have anticipated that the

exception would occur, the current program is terminated.

The reason for the exception is:

An invalid table name "PA9667" was specified in an Open SQL command:

Due to one of the following reasons, the error occurs only at runtime:

- the table name was specified dynamically, or

- the SELECT clause, WHERE clause, GROUP-BY clause, HAVING clause, or

ORDER-BY clause was specified dynamically.

Re: Error on PA infotypes

amit_khare — Tue, 25 Sep 2007 07:38:36 GMT

You did some error while creating Infotype.Its hard to say from this Dump. Just check you followed the steps given in link while creating infotypes -

http://sap-img.com/human/how-to-create-a-hr-infotype.htm

Regards,

Amit

Reward all helpful replies.

Re: Error on PA infotypes

Former Member — Tue, 25 Sep 2007 07:50:24 GMT

Do the creation with the following steps correctly

Steps to create a HR Infotype:

1) Go to Transaction PM01.

2) Enter the custom Infotype number which you want to create (Should be a 4 digit number, start with 9).

3) Select the 'Employee Infotype' radio button.

4) Select the 'PS Structure Infotype'.

5) Click on Create... A separate table maintenance window appears...

6) Create a PS structure with all the fields you want on the Infotype

7) Save and Activate the PS structure

😎 Go back to the initial screen of PM01.

9) Click on 'All' push button. It takes a few moments.

10) Click on 'Technical Characteristics'. Infotype list screen appears

11) Click on 'Change'(pencil) button

12) Select your Infotype and click on 'Detail' (magnifying glass) button

13) Give 'T591A' as subtype table

14) Give 'T591S' as subtype txt tab

15) Give your subtype field as subtype field

16) Save and come back to PM01 initial screen

17) Click on 'Infotype Characteristics' ... Infotype list screen appears

18) Click on 'Change' (pencil) button

19) Click on 'New Entries'

20) Enter your Infotype number and short text

21) Here we have to set different Infotype Characteristics as per the requirement. (Better open another session with some standard Infotype's infotype characteristics screen and use as the reference to fill yours)

22) Save your entries.

23) Now the Infotype is created and ready to use.

24) If you want to change the layout of the Infotype as per your requirement...

25) In the PM01 initial screen...Select 'Screen' radio button and give 2000 as the screen name, then click on edit.

26) In the next screen.. Select 'Layout Editor' and click 'Change'.

27) Screen default layout appears...here you can design/modify the screen..change the attributes of the fields..etc.

28) Save and activate. (Don't forget to 'Activate at every level)

Subtype Creation :

Transaction PM01 Goto Subtype Characteristics. Click on Append and then subtype. Enter the name and description of subtype on screen.

Then goto technical Characteristics and maintain the details of subtype there. I.e name of subtype i.e. component name defined in PSnnnn. Subtype table is T591A.

Subty.text tab is T591S and time const tab is T591A.

See:

http://help.sap.com/saphelp_46c/helpdata/en/4f/d5268a575e11d189270000e8322f96/content.htm

Enhancement of Infotype

Check the following

http://help.sap.com/printdocu/core/Print46c/en/data/pdf/PAXX/PYINT_INFOTYP.pdf

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/60a7586d-edd9-2910-68a8-8204303835a1

Regards

Anji

Re: Error on PA infotypes

Former Member — Thu, 12 Nov 2009 01:30:09 GMT

solved the problem

Re: Error on PA infotypes

Former Member — Thu, 12 Nov 2009 01:30:55 GMT

problem solved