topic Re: link between VBRP and KONV in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/link-between-vbrp-and-konv/m-p/5359483#M1233740 <HTML><HEAD></HEAD><BODY><P>Hi for this u have to link 3 tables </P><P>vbrk vbrp and knov.</P><P></P><P>as bellow.</P><P></P><P>VBRK-VBELN = VBRP-VBELN.</P><P>VBRK-KNUMV = KONV-KNUMV</P><P></P><P>Regards</P></BODY></HTML> Thu, 02 Apr 2009 06:01:00 GMT Former Member 2009-04-02T06:01:00Z link between VBRP and KONV https://community.sap.com/t5/application-development-and-automation-discussions/link-between-vbrp-and-konv/m-p/5359476#M1233733 <HTML><HEAD></HEAD><BODY><P>hello,</P><P></P><P> any idea for the link between VBRP and KONV tables ? </P><P>I am fetching vbeln from vbak and based on that i am getting matnr and quantity details from vbrp now i want to get condition type and tax code details from konv.how to link it?</P><P></P><P>regards</P><P>Soniya.</P></BODY></HTML> Thu, 02 Apr 2009 05:10:29 GMT https://community.sap.com/t5/application-development-and-automation-discussions/link-between-vbrp-and-konv/m-p/5359476#M1233733 Former Member 2009-04-02T05:10:29Z Re: link between VBRP and KONV https://community.sap.com/t5/application-development-and-automation-discussions/link-between-vbrp-and-konv/m-p/5359477#M1233734 <HTML><HEAD></HEAD><BODY><P>you can get it form VBRK table.</P></BODY></HTML> Thu, 02 Apr 2009 05:13:36 GMT https://community.sap.com/t5/application-development-and-automation-discussions/link-between-vbrp-and-konv/m-p/5359477#M1233734 Former Member 2009-04-02T05:13:36Z Re: link between VBRP and KONV https://community.sap.com/t5/application-development-and-automation-discussions/link-between-vbrp-and-konv/m-p/5359478#M1233735 <HTML><HEAD></HEAD><BODY><P>VBRK-KNUMV = KONV-KNUMV</P><P>VBRK-VBELN = VBRP-VBELN.</P></BODY></HTML> Thu, 02 Apr 2009 05:14:34 GMT https://community.sap.com/t5/application-development-and-automation-discussions/link-between-vbrp-and-konv/m-p/5359478#M1233735 GauthamV 2009-04-02T05:14:34Z Re: link between VBRP and KONV https://community.sap.com/t5/application-development-and-automation-discussions/link-between-vbrp-and-konv/m-p/5359479#M1233736 <HTML><HEAD></HEAD><BODY><P>Hi Soniya,</P><P></P><P>For this you have to go through VBRK(Billing Header Data).</P><P></P><P>VBRK-KNUMV = KONV-KNUMV </P><P>VBRK-VBELN = VBRP-VBELN.</P><P></P><P>Amresh</P></BODY></HTML> Thu, 02 Apr 2009 05:22:11 GMT https://community.sap.com/t5/application-development-and-automation-discussions/link-between-vbrp-and-konv/m-p/5359479#M1233736 Former Member 2009-04-02T05:22:11Z Re: link between VBRP and KONV https://community.sap.com/t5/application-development-and-automation-discussions/link-between-vbrp-and-konv/m-p/5359480#M1233737 <HTML><HEAD></HEAD><BODY><P>Check this:</P><P></P><PRE><CODE>1. Use SQVI transaction, 2. Create a View 3. Enter title, 4. Choose the Data source as Table Join 5. Now use Insert table option. 6. And insert the tables which you want. It will propose the relation between them.</CODE></PRE><P></P></BODY></HTML> Thu, 02 Apr 2009 05:34:25 GMT https://community.sap.com/t5/application-development-and-automation-discussions/link-between-vbrp-and-konv/m-p/5359480#M1233737 Former Member 2009-04-02T05:34:25Z Re: link between VBRP and KONV https://community.sap.com/t5/application-development-and-automation-discussions/link-between-vbrp-and-konv/m-p/5359481#M1233738 <HTML><HEAD></HEAD><BODY><P>This message was moderated.</P></BODY></HTML> Thu, 02 Apr 2009 05:41:07 GMT https://community.sap.com/t5/application-development-and-automation-discussions/link-between-vbrp-and-konv/m-p/5359481#M1233738 Former Member 2009-04-02T05:41:07Z Re: link between VBRP and KONV https://community.sap.com/t5/application-development-and-automation-discussions/link-between-vbrp-and-konv/m-p/5359482#M1233739 <HTML><HEAD></HEAD><BODY><P>KONV (condition table) is linked to VBRK (Billing: Header data) by the following</P><P>VBRK-KNUMV = KONV-KNUMV</P><P></P><P>and VBRK (Billing: Header data) is linked to VBRP (Billing: Item data) by the following</P><P>VBRK-VBELN = VBRP-VBELN</P><P></P><P>I believe you can can fetch data from VBRP using <STRONG>for all entries</STRONG>.</P><P>Then fetch the data from KNOV table using the above given link and then modify the required internal table to retrieve the required result.</P><P>Hope it helps</P></BODY></HTML> Thu, 02 Apr 2009 05:57:56 GMT https://community.sap.com/t5/application-development-and-automation-discussions/link-between-vbrp-and-konv/m-p/5359482#M1233739 Former Member 2009-04-02T05:57:56Z Re: link between VBRP and KONV https://community.sap.com/t5/application-development-and-automation-discussions/link-between-vbrp-and-konv/m-p/5359483#M1233740 <HTML><HEAD></HEAD><BODY><P>Hi for this u have to link 3 tables </P><P>vbrk vbrp and knov.</P><P></P><P>as bellow.</P><P></P><P>VBRK-VBELN = VBRP-VBELN.</P><P>VBRK-KNUMV = KONV-KNUMV</P><P></P><P>Regards</P></BODY></HTML> Thu, 02 Apr 2009 06:01:00 GMT https://community.sap.com/t5/application-development-and-automation-discussions/link-between-vbrp-and-konv/m-p/5359483#M1233740 Former Member 2009-04-02T06:01:00Z Re: link between VBRP and KONV https://community.sap.com/t5/application-development-and-automation-discussions/link-between-vbrp-and-konv/m-p/5359484#M1233741 <HTML><HEAD></HEAD><BODY><P>VBRP-VBELN = VBRK-VBELN</P><P></P><P></P><P>THEN </P><P></P><P>VBRK-KNUMV = KONV-KNUMV</P><P>VBRP-POSNR = KONV-KPOSN</P><P></P><P>IF WANT MOREHELP, PLZ ASK.</P></BODY></HTML> Thu, 02 Apr 2009 06:09:57 GMT https://community.sap.com/t5/application-development-and-automation-discussions/link-between-vbrp-and-konv/m-p/5359484#M1233741 Former Member 2009-04-02T06:09:57Z