Select Subtype Fields from PA0105 Infotype

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

Hi Amit,

Thank you by Answer.I solved my problem.

Srinivas