List of Open Sales Orders

[Former Member]

Hi All,

I am in need of a report to display list of open Sales orders, Requirement Date or Requested Delivery Date and Requirement Qty for given Materials (Multiple Input) and Plant.

Please guide me, Is there any Standard Report Available to display the above information except VA05.

Or else

Please guide me, the list of tables to fetch those information.

[former_member196530 · Accepted solution]

Did you try in VA05N ?

How ever , you will not get the requirement date oir requested delivery date here .You can get only Document date or creation date .

I suggest you to try to build a report with the below SAP field and data element :

VBELN VBAK-VBELN, "SALES ORDER

POSNR VBAP-POSNR, "ITEM

MATKL VBAP-MATKL, "Material Group

AUART VBAK-AUART, "ORDER TYPE

AUDAT VBAK-AUDAT, "ORDER DATE

BSTNK VBAK-BSTNK, "CUSTOMER PO NO.

BSTDK VBAK-BSTDK, "CUSTOMER PO DATE

WAERK VBAK-WAERK, "Currency

PSTYV VBAP-PSTYV, "Sales document item category

ZMENG VBAP-ZMENG, "TARGET QTY.

KWMENG VBAP-KWMENG, "SO QTY

OPENQTY VBAP-KWMENG, "OPEN QTY

LFIMG LIPS-LFIMG, "DELIVERY QTY

LFIMG1 LIPS-LFIMG,

SHKZG VBRP-SHKZG,

NETPR VBAP-NETPR, "UNIT PRICE

NETWR VBAP-NETWR, "NET VALUE

BALWR VBAP-NETWR, "NET VALUE FOR BALANCE QTY.

BALLOC VBAP-NETWR, "BALANCE VALUE IN LOCAL CURRENCY

KURSK VBKD-KURSK, "EXCHANGE RATE

FPLNR VBKD-FPLNR, "BILLING PLAN NO.

FKSAF FPLT-FKSAF, "BILLING STATUS

LOCVAL VBAP-NETWR, "AMT. IN LOCAL CURRENCY

KUNNR VBAK-KUNNR, "CUSTOMER

VKORG VBAK-VKORG, "SALES ORG.

VKBUR VBAK-VKBUR, "SALES OFF.

VDATU VBAK-VDATU, "Req.Del.Date

MATNR MARA-MATNR, "MATERIAL NO

ARKTX VBAP-ARKTX, "MATERIAL DESC

WERKS VBAP-WERKS, "PLANT

LFSTA VBUP-LFSTA, "Item Delivery Status

FKARA TVAK-FKARA,

GBSTA VBUP-GBSTA, "Overall Status

FKSAA VBUP-FKSAA, "Item billing statuS

NAME1 KNA1-NAME1, "CUSTOMER NAME

VBTYP VBAK-VBTYP, "Doc. Category

LFARV TVAK-LFARV, "Delivery type

LIFNR LFA1-LIFNR, "Vendor Number

SPSTG VBUK-SPSTG, "Overall blkd status

COST KONV-KWERT, "COST

DISC KONV-KBETR, "DISCOUNT

SPRICE VBAP-NETWR, "SELLING PRICE

The above field are similiar kind of report .But I feel you have to keep two opetion one will be Open Sales Order and other All the sales order .Discuss with your abaper in this regard in line with VA05N and VA05

Hope this will be useful

Regards

JH

Edited by: Jiaul Haque on Jun 20, 2010 9:07 AM