topic Re: code for validating the sales order in Application Development and Automation Discussions

code for validating the sales order

Former Member — Sat, 30 Jun 2007 08:19:23 GMT

Hi,

can any body can send the code for validating sales order and shipment,when we enter the sales order or shipment as input in the selection screen.

It is very urgent....................

Thanks in advance.

Re: code for validating the sales order

kiran_k8 — Sat, 30 Jun 2007 08:23:57 GMT

Sudarsan,

data: begin of itab occurs 0.

include structure tablename.

data:end of itab.

parameters:p_vbeln like vbak-vblen,

p_ship like vbak-fieldname.

select * from tablename into table itab where vbeln = p_vbeln and

fieldname = p_ship.

Note:- fieldname is the field for shipment,get it from the concerned table.

tablename is the table from which you are selecting the data.

K.Kiran.

Message was edited by:

Kiran K

Re: code for validating the sales order

Former Member — Sat, 30 Jun 2007 08:28:47 GMT

hi,

You need write the select statment in the AT SELECTION SCREEN event to chekc the fields which you declared in the Selection screen.

parameters: P_VBELN like VBAK-VBELN.

AT SELECTION-SCREEN.

Select single * from VBAK where VBELN eq P_VBELN.

IF SY-SUBRC <> 0.

MESSAGE E000 with 'no sales order'

endif.

Do the same way for Shipment also.

or

you provide the logic for validate the user entered sales order number and shipment.

AT SELECTION-SCREEN ON P_VBELN.

Select single * from VBAK where VBELN eq P_VBELN.

IF SY-SUBRC <> 0.

MESSAGE E000 with 'no sales order'

endif.

AT SELECTION-SCREEN ON <SHIPMENT>.

Regards

Ashok

Message was edited by:

Ashok Reddy

Re: code for validating the sales order

Former Member — Sat, 30 Jun 2007 08:29:06 GMT

HI,

SEE TO THIS CODE.

TABLE DECLARATION--

TABLES : VBAK,VBAP.

TYPE-POOLS : SLIS.

STRUCTURE DECLARATION--

TYPES : BEGIN OF TY_VBAK,

VBELN TYPE VBELN_VA,

ERDAT TYPE ERDAT,

ERZET TYPE ERZET,

ERNAM TYPE ERNAM,

END OF TY_VBAK.

SELECT OPTIONS--

SELECT-OPTIONS : S_VBAK FOR VBAK-VBELN.

START OF SELECTION--

START-OF-SELECTION.

SELECT VBELN

ERDAT

ERZET

ERNAM

FROM VBAK

INTO TABLE IT_VBAK

WHERE VBELN IN S_VBAK.