Open order returns

[Former Member]

Hi All,

A report is needed for open return orders that do not have a credit memo issued or a goods receipt processed against the delivery

The Validation requires

Credit not issued (may be default because of billing block) orders.

can anyone help in the following

1)what are open return orders

2)open return orders that do not have a credit memo

3)goods receipts processed against the delivery

what are the transaction codes and fields related to it

[Former Member]

hi for open orders ,

Transaction Code: VA05

Select Open Orders.

first get the sd flow ...

SD FLOW

SD Flow Cycle:

INQUIRY ( VA11)

QUOTATION (VA21)

PURCHASE ORDER (ME21)

ORDER CONFIRMATION (VA01)

PICKING LIST – (VL36)

PACKING LIST - (VL02, VL01)

SHIPPING – (VT01)

INVOICE – (VF21, VF01)

AR

Enquiry - Customer enquires about the Products services that were sold by a company - VA11

Quotation - Company Gives a Quotation for the products and Services to a Customer

Sales Order - Customer gives a Purchase order to the company agaionst which a Sales order will be raised to Customer in SAP.

VBAK: Sales Document(Header Data) (VBELN)

VBAP: Sales Document(Item Data) (VBELN,POSNR,MATNR,ARKTX,CHARG)

Enquiry, Quotation, Sales Order are differentiated based on Doc.

Type(VBTYP field) in VBAK,VBAP Tables( for Enquiry VBTYP = A,

for Quotation 'B' & for Order it is 'C'.)

Delivery(Picking, Packing, Post Goods Issue and Shipment)->

Company sends the material after picking it from Godown and Packing it in a Handling Unit(box) and Issues the goods

LIKP: Delivery Table (Header Data)(VBELN,LFART,KUNNR,WADAT,INCO1)

LIPS: Delivery Table (Item Data)(VBELN,POSNR,WERKS,LGORT,MATNR,VGBEL)

(LIPS-VGBEL = VBAK-VBELN, LIPS-VGPOS = VBAP-POSNR)

Billing - Also company bills to the customer for those deliveries

And in FI against this billing Accounting doc is created.

VBRK: Billing Table(Header Data)(VBELN,FKART,BELNR)

VBRP: Billing Table(Item Data)(VBELN,POSNR,FKIMG,NETWR,VGBEL,VGPOS)

(VBRP-AUBEL = VBAK-VBELN, VBRP-VGBEL = LIKP-VBELN)

Apart from these tables there are lot of other tables which starts with

‘V’, but we use the following tables frequently.

VBUK: All Sales Documents status & Admn. Data(Header)(VBELN,VBTYP)

VBTYP= ‘C’(Sales Order) VBTYP=’J’(Delivery) VBTYP=’M’(Invoice)

VBUP: Sales Documents status & Admn. Data(Item)(VBELN,POSNR)

VBEP: Sales Doc. Schedule Lines Data(VBELN,POSNR,EDATU,WMENG)

VBKD: To get sales related Business data like Payment terms etc.(VBELN,ZTERM)

VBFA: sales document flow data(VBELV,VBELN,POSNV,VBTYP)

VBPA: Partner functions Data(VBELN,PARVW,KUNNR,LIFNR)

VEDA: Contract Data(VBELN,VPOSN)

VEDAPO: Contract Data(VBELN,VPOSN)

KONA: Rebate Agreements (KNUMA,VKORG,VTWEG,SPART)

http://www.sapgenie.com/abap/tables_sd.htm

Please check this SD online documents.

http://help.sap.com/printdocu/core/Print46c/en/data/pdf/CAARCSD/CAARCSD.pdf

http://help.sap.com/printdocu/core/Print46c/en/data/pdf/MYSAP/SR_SD.pdf

http://help.sap.com/printdocu/core/Print46c/en/data/pdf/BCBMTWFMSD/BCBMTWFMSD.pdf

http://help.sap.com/printdocu/core/Print46c/en/data/pdf/LOLISPLN/LOLISPLN.pdf

Also please check this SD links as well.

http://help.sap.com/saphelp_47x200/helpdata/en/92/df293581dc1f79e10000009b38f889/frameset.htm

http://help.sap.com/saphelp_erp2005/helpdata/en/dd/55f33e545a11d1a7020000e829fd11/frameset.htm

http://www.sap-basis-abap.com/sapsd.htm

http://www.sap-img.com/sap-sd.htm

http://www.sapgenie.com/abap/tables_sd.htm

http://searchsap.techtarget.com/featuredTopic/0,290042,sid21_gci961718,00.html

http://www.sapbrain.com/TUTORIALS/FUNCTIONAL/SD_tutorial.html

All help ebooks are in PDF format here

http://www.easymarketplace.de/online-pdfs.php

regards,

venkat.