Skip to Content
0
Former Member
May 14, 2010 at 08:55 AM

HOW TO MAKE INNERJOIN FOR THREE TABLES

333 Views

Fetch the data ( VBELN,POSNR,FKDAT ) from table VRPMA using condition of billing date (VRPMA-FKDAT) is less than 60 days from current Sales Order requested delivery date (if specified at header VBAK-VDATU or at the schedule line level (VBEP-EDATU) and based on tables VBAK (VKORG,VTWEG,SPART,VBELN),VBAP(MATNR,VBELN,POSNR,) & VBPA(KUNNR,VBELN,POSNR,PARVW,) using INNER JOIN condition

HOW TO ACHIEVE THIS?