Joins help

[Former Member]

Hi All,

Please help me, I want some Join help,

I have VBLN and Matnr in my Itab.

I want get the values of

<b>Sales Backorder qty</b>

Sales Backorder qty = SUM( VBAP-KWMENG ) minus SUM( VBFA-RFMNG where VBTYP_N = ‘J’)

Where VBUP-LFSTA ne ‘C’

<b>Zero Stock Date</b>

MKPF-BLDAT

If MBEW-LBKUM gt zero, select maximum MKPF-BLDAT where MSEG-SHKZG = ‘H’

*<b>Outstanding value</b>

*EKPO-NETWR minus ( SUM( EKBE-DMBTR where BWART = ‘103’ ) minus

*SUM( EKBE-DMBTR where BWART = ‘104’ ) )

*<b>Outstanding quantity</b>

*EKPO-MENGE minus

*( SUM( EKBE-MENGE where BWART = ‘103’ ) minus

*SUM( EKBE-MENGE where BWART = ‘104’ ) )

Thanks

Message was edited by:

claim system

[Former Member]

Hi Claim

Check this example of inner joining and convert it accordingly to your requirement

  Select single Vbrk~Bukrs Vbrk~Kunrg    Vbrk~Vbeln  
                   Vbrk~Fkdat Vbrk~Bstnk_Vf Vbrk~Zterm  
                   Tvzbt~Vtext  
                   Vbak~Vbeln Vbak~Bstdk  
                   Likp~Vbeln Likp~lfdat    Likp~Lfuhr  
       into w_vbrk  
       from vbrk  
      inner join       Tvzbt on Tvzbt~Zterm        = Vbrk~Zterm      and  
                                Tvzbt~Spras        = sy-langu  
      Inner join       Vbfa  as SalesLnk  
                             on SalesLnk~vbeln     = pu_vbeln        and  
                                SalesLnk~vbtyp_v   = c_order  
            inner join Vbak  on Vbak~Vbeln           = SalesLnk~Vbelv 
      Inner join       Vbfa  as DeliveryLnk  
                             on DeliveryLnk~vbeln   = pu_vbeln       and  
                                DeliveryLnk~vbtyp_v = c_Delivery  
            inner join Likp  on Likp~Vbeln          = DeliveryLnk~Vbelv  
      where vbrk~vbeln = pu_Vbeln.  

Reward all helpfull answers

Regards

Pavan