topic Re: PROVIDE SYNTAX? in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/provide-syntax/m-p/2619607#M601488 <HTML><HEAD></HEAD><BODY><P>Hi ,</P><P> check the below syntax.</P><P></P><P> SELECT SINGLE VORNA NACHN ANRED GESCH</P><P> INTO S_P0002</P><P> FROM PA0002 WHERE PERNR = 1.</P><P></P><P> W_VORNA = S_P0002-VORNA.</P><P> W_NACHN = S_P0002-NACHN.</P><P></P><P> SELECT SINGLE ANREX INTO W_ANREX FROM T522</P><P> WHERE ANRED = S_P0002-ANRED AND GESCH = S_P0002-GESCH.</P><P></P><P> SELECT SINGLE ORT01 STATE LAND1 INTO S_P0006</P><P> FROM PA0006 WHERE PERNR = 1.</P><P></P><P> W_ORT01 = S_P0006-ORT01.</P><P></P><P> SELECT SINGLE BEZEI INTO W_BEZEI FROM T005U</P><P> WHERE BLAND = S_P0006-STATE AND LAND1 = S_P0006-LAND1.</P><P></P><P> SELECT SINGLE INTERVIEW_DATE INTERVIEW_TIME</P><P> INTERVIEW_VENUE VACANCY_ID</P><P> INTO S_P9010 FROM PB9010 WHERE PERNR = 1.</P><P></P><P> W_INTERVIEW_DATE = S_P9010-INTERVIEW_DATE.</P><P> W_INTERVIEW_TIME = S_P9010-INTERVIEW_TIME.</P><P> W_INTERVIEW_VENUE = S_P9010-INTERVIEW_VENUE.</P><P></P><P> SELECT SINGLE PLSTX INTO W_PLSTX FROM T528T</P><P> WHERE PLANS = S_P9010-VACANCY_ID.</P></BODY></HTML> Wed, 01 Aug 2007 11:23:54 GMT Former Member 2007-08-01T11:23:54Z PROVIDE SYNTAX? https://community.sap.com/t5/application-development-and-automation-discussions/provide-syntax/m-p/2619606#M601487 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>If i take one infotype data we are taking like this...</P><P></P><P>PROVIDE * FROM P0002 BETWEEN PN-BEGDA AND PN-ENDDA.</P><P>WRITE: P0002-PERNR, P0002-NACHN, P0002-VORNA.</P><P>ENDPROVIDE.</P><P></P><P>But i want multiple infotypes data like 0000,0006,0008....?Give me the syntax of that provide stmt with multiple infotypes?</P><P></P><P>Thanks</P><P>Sree</P></BODY></HTML> Wed, 01 Aug 2007 11:16:10 GMT https://community.sap.com/t5/application-development-and-automation-discussions/provide-syntax/m-p/2619606#M601487 Former Member 2007-08-01T11:16:10Z Re: PROVIDE SYNTAX? https://community.sap.com/t5/application-development-and-automation-discussions/provide-syntax/m-p/2619607#M601488 <HTML><HEAD></HEAD><BODY><P>Hi ,</P><P> check the below syntax.</P><P></P><P> SELECT SINGLE VORNA NACHN ANRED GESCH</P><P> INTO S_P0002</P><P> FROM PA0002 WHERE PERNR = 1.</P><P></P><P> W_VORNA = S_P0002-VORNA.</P><P> W_NACHN = S_P0002-NACHN.</P><P></P><P> SELECT SINGLE ANREX INTO W_ANREX FROM T522</P><P> WHERE ANRED = S_P0002-ANRED AND GESCH = S_P0002-GESCH.</P><P></P><P> SELECT SINGLE ORT01 STATE LAND1 INTO S_P0006</P><P> FROM PA0006 WHERE PERNR = 1.</P><P></P><P> W_ORT01 = S_P0006-ORT01.</P><P></P><P> SELECT SINGLE BEZEI INTO W_BEZEI FROM T005U</P><P> WHERE BLAND = S_P0006-STATE AND LAND1 = S_P0006-LAND1.</P><P></P><P> SELECT SINGLE INTERVIEW_DATE INTERVIEW_TIME</P><P> INTERVIEW_VENUE VACANCY_ID</P><P> INTO S_P9010 FROM PB9010 WHERE PERNR = 1.</P><P></P><P> W_INTERVIEW_DATE = S_P9010-INTERVIEW_DATE.</P><P> W_INTERVIEW_TIME = S_P9010-INTERVIEW_TIME.</P><P> W_INTERVIEW_VENUE = S_P9010-INTERVIEW_VENUE.</P><P></P><P> SELECT SINGLE PLSTX INTO W_PLSTX FROM T528T</P><P> WHERE PLANS = S_P9010-VACANCY_ID.</P></BODY></HTML> Wed, 01 Aug 2007 11:23:54 GMT https://community.sap.com/t5/application-development-and-automation-discussions/provide-syntax/m-p/2619607#M601488 Former Member 2007-08-01T11:23:54Z Re: PROVIDE SYNTAX? https://community.sap.com/t5/application-development-and-automation-discussions/provide-syntax/m-p/2619608#M601489 <HTML><HEAD></HEAD><BODY><P><A class="jive_macro jive_macro_thread" href="https://community.sap.com/" __jive_macro_name="thread" modifiedtitle="true" __default_attr="500112"></A></P><P><A class="jive_macro jive_macro_message" href="https://community.sap.com/" __jive_macro_name="message" modifiedtitle="true" __default_attr="3858043"></A></P></BODY></HTML> Wed, 01 Aug 2007 14:05:53 GMT https://community.sap.com/t5/application-development-and-automation-discussions/provide-syntax/m-p/2619608#M601489 Former Member 2007-08-01T14:05:53Z Re: PROVIDE SYNTAX? https://community.sap.com/t5/application-development-and-automation-discussions/provide-syntax/m-p/2619609#M601490 <HTML><HEAD></HEAD><BODY><P>Hi Sree,</P><P></P><P>The infotype records are imported to internal tables Pnnnn (for example, P0006 for infotype 0006).These tables are then processed in a PROVIDE-ENDPROVIDE loop.</P><P></P><P>Syntax for retrieving data from multiple infotypes using PROVIDE:</P><P></P><P>GET PERNR.</P><P>PROVIDE * FROM P0002</P><P> </P><UL><LI level="1" type="ul"><P>FROM P0006</P></LI></UL><P>BETWEEN PN-BEGDA AND PN-ENDDA</P><P>WHERE P0006-SUBTY = '1'.</P><P>IF P0006_VALID = 'X'.</P><P>WRITE...</P><P>ENDIF.</P><P>ENDPROVIDE.</P><P></P><P></P><P>PROVIDE STELL</P><P>ENAME FROM P0001</P><P>GBDAT FROM P0002</P><P>BETWEEN PN-BEGDA AND PN-ENDDA.</P><P>WRITE: P0001-ENAME,</P><P> P0002-GBDAT.</P><P>ENDPROVIDE.</P><P></P><P></P><P>&lt;b&gt;reward points if found useful.&lt;/b&gt;</P></BODY></HTML> Wed, 01 Aug 2007 14:25:24 GMT https://community.sap.com/t5/application-development-and-automation-discussions/provide-syntax/m-p/2619609#M601490 Former Member 2007-08-01T14:25:24Z Re: PROVIDE SYNTAX? https://community.sap.com/t5/application-development-and-automation-discussions/provide-syntax/m-p/2619610#M601491 <HTML><HEAD></HEAD><BODY><P>Thanks Prem Raj , its helpfull.</P></BODY></HTML> Mon, 05 Nov 2007 07:58:01 GMT https://community.sap.com/t5/application-development-and-automation-discussions/provide-syntax/m-p/2619610#M601491 Former Member 2007-11-05T07:58:01Z