Skip to Content
0
Former Member
Jul 02, 2007 at 11:35 AM

Joins help

11 Views

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