topic Re: Select Subtype Fields from PA0105 Infotype in Application Development and Automation Discussions

Select Subtype Fields from PA0105 Infotype

Former Member — Mon, 24 Nov 2008 04:25:10 GMT

Hi Experts,

Please tell me how can we select Subtype fields from PA0105 infotype.my requirement is Select subtype fields from PA0105-USRTY(Subtype Fields:Primary Work Phone,Secondary Work Phone,Work Fax,Voice Mail,Pager,Email Address.) and PA0006 infotype(Fields:Mailcode,Building,Floor,Address1,City,State,Zip).how can we combined these two infotype fields please reply .

Thanks,

SPreddy

Re: Select Subtype Fields from PA0105 Infotype

Former Member — Mon, 24 Nov 2008 04:27:48 GMT

select * from pa0105 into .... where subty = '0001' and endda = '99991231'.

select * from pa0006 into .... where subty = '2' and endda = '99991231'.

Edited by: Amit Gupta on Nov 24, 2008 5:40 AM

Re: Select Subtype Fields from PA0105 Infotype

Former Member — Mon, 24 Nov 2008 05:40:18 GMT

Hi Amit,

Thank you by Answer.I solved my problem.

Srinivas