Validations

[Former Member]

Hi,

I wrote validations for select-options.

1.For validating MINDK , i want the vendors with mindk with 'ex' need to be excluded.

2.for validating aedat only those with aedat which is 'A' need to be taken.

3. where shall i write the Hide statement in this program.

plz check whether it is correct.(it is in bold letters)

REPORT ZFS_TAB1.

TYPES:

BEGIN OF TY_LFB1,

MINDK TYPE LFB1-MINDK,

END OF TY_LFB1,

BEGIN OF TY_EKKO,

EKGRP TYPE EKKO-EKGRP,

AEDAT TYPE EKKO-AEDAT,

EBELN TYPE EKKO-EBELN,

SUBMI TYPE EKKO-SUBMI,

BSART TYPE EKKO-BSART,

KTWRT TYPE EKKO-KTWRT,

LIFNR TYPE EKKO-LIFNR,

END OF TY_EKKO,

BEGIN OF TY_LFA1,

KTOKK TYPE LFA1-KTOKK,

NAME1 TYPE LFA1-NAME1,

ORT01 TYPE LFA1-ORT01,

REGIO TYPE LFA1-REGIO,

PSTLZ TYPE LFA1-PSTLZ,

TELF1 TYPE LFA1-TELF1,

TELFX TYPE LFA1-TELFX,

END OF TY_LFA1,

BEGIN OF TY_ADRC,

HOUSE_NUM1 TYPE ADRC-HOUSE_NUM1,

STREET TYPE ADRC-STREET,

PO_BOX TYPE ADRC-PO_BOX,

END OF TY_ADRC,

BEGIN OF TY_ADR6,

SMTP_ADDR TYPE ADR6-SMTP_ADDR,

END OF TY_ADR6,

BEGIN OF TY_WYT3,

LIFN2 TYPE WYT3-LIFN2,

END OF TY_WYT3.

• D A T A

DATA:

ST_LFB1 TYPE TY_LFB1,

IT_LFB1 TYPE TABLE OF TY_LFB1,

ST_EKKO TYPE TY_EKKO,

IT_EKKO TYPE TABLE OF TY_EKKO,

ST_LFA1 TYPE TY_LFA1,

IT_LFA1 TYPE TABLE OF TY_LFA1,

ST_ADRC TYPE TY_ADRC,

IT_ADRC TYPE TABLE OF TY_ADRC,

ST_ADR6 TYPE TY_ADR6,

IT_ADR6 TYPE TABLE OF TY_ADR6,

ST_WYT3 TYPE TY_WYT3,

IT_WYT3 TYPE TABLE OF TY_WYT3.

• S E L E C T O P T I O N S.

SELECT-OPTIONS:

<b>SMINDK FOR ST_LFB1-MINDK,

SAEDAT FOR ST_EKKO-AEDAT,

SEKGRP FOR ST_EKKO-EKGRP,

SLIFNR FOR ST_EKKO-LIFNR.</b>

• A T S E L E C T I O N S C R E E N

AT SELECTION-SCREEN.

PERFORM VALIDATE_MINDK.

PERFORM VALIDATE_AEDAT.

PERFORM VALIDATE_EKGRP.

PERFORM VALIDATE_LIFNR.

• S T A R T O F S E L E C T I O N.

START-OF-SELECTION.

PERFORM GETDATA_EKKO.

PERFORM GETMIND_LFB1.

PERFORM GET_VENDORMASTERDATA.

PERFORM GET_VENDORADDRESS.

PERFORM GET_VENDOREMAIL.

PERFORM GET_INVOICEPARTY.

&----

---

*& Form GETDATA_EKKO

&----

---

• text

----

---

• --> p1 text

• <-- p2 text

----

---

FORM GETDATA_EKKO .

SELECT EKGRP "PURCHASING GROUP

AEDAT "DATE ON WHICH RECORD WAS CREATED

EBELN "PURCHASING DOCUMENT NUMBER

SUBMI "COLLECTIVE NUMBER

BSART "PURCHASE DOCUMENT TYPE

KTWRT "CUMULATIVE PLANNED VALUE

LIFNR "VENDOR ACCOUNT NUMBER

FROM EKKO INTO TABLE IT_EKKO

WHERE EKGRP IN SEKGRP AND LIFNR IN SLIFNR AND AEDAT IN SAEDAT.

IF SY-SUBRC EQ 0.

LOOP AT IT_EKKO INTO ST_EKKO.

WRITE:/ ST_EKKO-EKGRP,ST_EKKO-AEDAT,ST_EKKO-EBELN,ST_EKKO-SUBMI,ST_EKKO-BSART,ST_EKKO-KTWRT,ST_EKKO-KTWRT,ST_EKKO-LIFNR.

ENDLOOP.

ENDIF.

ENDFORM. " GETDATA_EKKO

&----

---

*& Form GETMIND_LFB1

&----

---

• text

----

---

• --> p1 text

• <-- p2 text

----

---

FORM GETMIND_LFB1 .

SELECT MINDK "MINORIY INDICATORS

FROM LFB1 INTO TABLE IT_LFB1 WHERE MINDK IN SMINDK.

IF SY-SUBRC EQ 0.

LOOP AT IT_LFB1 INTO ST_LFB1.

WRITE:/ ST_LFB1-MINDK.

ENDLOOP.

ENDIF.

ENDFORM. " GETMIND_LFB1

&----

---

*& Form GET_VENDORMASTERDATA

&----

---

• text

----

---

• --> p1 text

• <-- p2 text

----

---

FORM GET_VENDORMASTERDATA .

SELECT KTOKK "VENDOR ACCOUNT NUMBER

NAME1 "NAME1

ORT01 "CITY

REGIO "REGION

PSTLZ "POSTAL CODE

TELF1 "FIRST TELEPHONE NUMBER

TELFX "FAX NUMBER

FROM LFA1 INTO TABLE IT_LFA1.

IF SY-SUBRC EQ 0.

LOOP AT IT_LFA1 INTO ST_LFA1.

WRITE:/ ST_LFA1-KTOKK,ST_LFA1-NAME1,ST_LFA1-ORT01,ST_LFA1-REGIO,ST_LFA1-PSTLZ,ST_LFA1-TELF1,ST_LFA1-TELFX.

ENDLOOP.

ENDIF.

ENDFORM. " GET_VENDORMASTERDATA

&----

---

*& Form GET_VENDORADDRESS

&----

---

• text

----

---

• --> p1 text

• <-- p2 text

----

---

FORM GET_VENDORADDRESS .

SELECT HOUSE_NUM1 "HOUSE NUMBER1

STREET "STREET

PO_BOX "PO BOX

FROM ADRC INTO TABLE IT_ADRC.

IF SY-SUBRC EQ 0.

LOOP AT IT_ADRC INTO ST_ADRC.

WRITE:/ ST_ADRC-HOUSE_NUM1,ST_ADRC-STREET,ST_ADRC-PO_BOX.

ENDLOOP.

ENDIF.

ENDFORM. " GET_VENDORADDRESS

&----

---

*& Form GET_VENDOREMAIL

&----

---

• text

----

---

• --> p1 text

• <-- p2 text

----

---

FORM GET_VENDOREMAIL .

SELECT SMTP_ADDR "VENDOR EMAIL ADDRESS

FROM ADR6 INTO TABLE IT_ADR6.

IF SY-SUBRC EQ 0.

LOOP AT IT_ADR6 INTO ST_ADR6.

WRITE:/ ST_ADR6-SMTP_ADDR.

ENDLOOP.

ENDIF.

ENDFORM. " GET_VENDOREMAIL

&----

---

*& Form GET_INVOICEPARTY

&----

---

• text

----

---

• --> p1 text

• <-- p2 text

----

---

FORM GET_INVOICEPARTY .

SELECT LIFN2

FROM WYT3 INTO TABLE IT_WYT3.

IF SY-SUBRC EQ 0.

LOOP AT IT_WYT3 INTO ST_WYT3.

WRITE:/ ST_WYT3-LIFN2.

ENDLOOP.

ENDIF.

ENDFORM. " GET_INVOICEPARTY

&----

---

*& Form VALIDATE_MINDK

&----

---

• text

----

---

• --> p1 text

• <-- p2 text

----

---

<b>FORM VALIDATE_MINDK .

DATA:

LW_MINDK TYPE LFB1-MINDK,

W_INPUT TYPE C.

IF SMINDK NE 'EX'.

SELECT MINDK FROM LFB1 INTO LW_MINDK

WHERE MINDK IN SMINDK.

ENDSELECT.

ENDIF.

IF SY-SUBRC NE 0.

MESSAGE E000(0) WITH 'NO MINORITY INDICATOR FOR THIS CUSTOMER'.

ELSE.

W_INPUT = 'X'.

ENDIF.

ENDFORM. " VALIDATE_MINDK

&----

---

*& Form VALIDATE_AEDAT

&----

---

• text

----

---

• --> p1 text

• <-- p2 text

----

---

FORM VALIDATE_AEDAT .

DATA:

LW_AEDAT TYPE EKKO-AEDAT,

W_INPUT TYPE C.

IF SAEDAT EQ 'A'.

SELECT AEDAT FROM EKKO INTO LW_AEDAT

WHERE AEDAT IN SAEDAT.

ENDSELECT.

ENDIF.

IF SY-SUBRC NE 0.

MESSAGE E000(0) WITH 'DOCUMENT TYPE INVALID'.

ELSE.

W_INPUT = 'X'.

ENDIF.

ENDFORM. " VALIDATE_AEDAT

&----

---

*& Form VALIDATE_EKGRP

&----

---

• text

----

---

• --> p1 text

• <-- p2 text

----

---

FORM VALIDATE_EKGRP .

DATA:

LW_EKGRP TYPE EKKO-EKGRP,

W_INPUT TYPE C.

IF SAEDAT IS NOT INITIAL.

SELECT EKGRP FROM EKKO INTO LW_EKGRP

WHERE EKGRP IN SEKGRP.

ENDSELECT.

ENDIF.

IF SY-SUBRC NE 0.

MESSAGE E000(0) WITH 'INVALID PURCHASE GROUP RANGE'.

ELSE.

W_INPUT = 'X'.

ENDIF.

ENDFORM. " VALIDATE_EKGRP

&----

---

*& Form VALIDATE_LIFNR

&----

---

• text

----

---

• --> p1 text

• <-- p2 text

----

---

FORM VALIDATE_LIFNR .

DATA:

LW_LIFNR TYPE EKKO-LIFNR,

W_INPUT TYPE C.

IF SLIFNR IS NOT INITIAL.

SELECT LIFNR FROM EKKO INTO LW_LIFNR

WHERE LIFNR IN SLIFNR.

ENDSELECT.

ENDIF.

IF SY-SUBRC NE 0.

MESSAGE E000(0) WITH 'INVALID VENDOR GROUP RANGE'.

ELSE.

W_INPUT = 'X'.

ENDIF.

ENDFORM. " VALIDATE_LIFNR</b>

[Former Member]

Hi

1.Validate the select options with their master tables

declare them as TABLES and do

LIFNR -with LFA1 table, EKGRP with T024 table

MINDK with T059M table etc

2. No need to validate any date field AEDAT, just if you wants to keep some data restriction put that.

3. What for you need HIDE statement? You have to write it in the LOOP...ENDLOOP of the basic list display.

Then for secondary list when you click on that field it displays the related other values in secondary list

<b>Reward points for useful Answers</b>

Regards

Anji