Pending order status

[Former Member]

Hi all,

my requrirement is this :

user input :

customer code (mandatory)

customer order reference (optional)

customer order date(optional)

material number (optional)

i need to display the pending status for the given input

output

-

---

order number

order date

material

order quantity

order value

pending quantity (which is nothing but order qty - invoice qty)

what tables should be taken ?

logic or program coding would be useful.

regards

Geetha

[Former Member]

Hi all,

my requrirement is this :

user input :

customer code (mandatory)

customer order reference (optional)

customer order date(optional)

material number (optional)

i need to display the pending status for the given input

output

-

---

order number

order date

material

order quantity

order value

pending quantity (which is nothing but order qty - invoice qty)

what tables should be taken ?

logic or program coding would be useful.

regards

Geetha

[Former Member]

Hi,

Please check this bapi

BAPI_SALESORDER_GETLIST.

It has all the parameter as required by you.

Regards

Hiren K.Chitalia

[Former Member]

Hi,

Try to link VBUK with the vbeln of VBAK, u can get the status hederwise. ]

For example refer this code, where its Showing overall status of sales order:

CONSTANTS: c_vbuk(4)

TYPE c VALUE 'VBUK', c_gbstk(5) TYPE c VALUE 'GBSTK' , c_abstk(5) TYPE c VALUE 'ABSTK', c_lfstk(5) TYPE c VALUE 'LFSTK', c_cmgst(5) TYPE c VALUE 'CMGST', c_spstg(5) TYPE c VALUE 'SPSTG'.

*entries from vbak table SELECT vbeln audat auart spart kunnr FROM vbak INTO TABLE it_vbak WHERE audat IN so_date AND auart IN so_auart AND spart IN so_spart AND kunnr IN so_kunnr.

IF it_vbak IS NOT INITIAL. *entries from vbap SELECT vbeln posnr matnr abgru spart netwr kwmeng werks mwsbp FROM vbap INTO TABLE it_vbap FOR ALL ENTRIES IN it_vbak WHERE vbeln = it_vbak-vbeln AND matnr IN so_matnr AND abgru = c_99 AND spart IN so_spart AND werks IN so_werks. *entries from kna1 SELECT kunnr name1 FROM kna1 INTO TABLE it_kna1 FOR ALL ENTRIES IN it_vbak WHERE kunnr = it_vbak-kunnr. *entries from vbuk SELECT vbeln lfstk abstk gbstk cmgst spstg FROM vbuk INTO TABLE it_vbuk FOR ALL ENTRIES IN it_vbak WHERE vbeln = it_vbak-vbeln. ENDIF. IF it_vbuk IS NOT INITIAL. *entries from tvbst SELECT spras tbnam fdnam statu bezei FROM tvbst INTO TABLE it_gbstk FOR ALL ENTRIES IN it_vbuk WHERE spras = 'EN' AND tbnam = c_vbuk AND fdnam = c_gbstk AND statu = it_vbuk-gbstk.. SELECT spras tbnam fdnam statu bezei FROM tvbst INTO TABLE it_abstk FOR ALL ENTRIES IN it_vbuk WHERE spras = 'EN' AND tbnam = c_vbuk AND fdnam = c_abstk AND statu = it_vbuk-abstk. endif.

This shows status headerwise.