topic select without key fields in Application Development and Automation Discussions

select without key fields

Former Member — Mon, 20 Nov 2006 23:40:51 GMT

Hi,

I have a question, How to select documents when we dont have key fields in the selection

Sales orders

eg If we have 3 fields Material , Customer and Sales Org, which are not key fields in table VBAK, What is the best approach to select Sales Documents based on these 3 fields.

please let me know

Thanks

Re: select without key fields

venkata_ramisetti — Mon, 20 Nov 2006 23:44:21 GMT

Use logic like below.

SELECT vbak_{VBELN vbak}VKORG vbap_{MATNR vbak}KUNNR

INTO TABLE T_VBAK

FROM VBAK INNER JOIN VBAP

ON VBAK_{VBELN = VBAP}VBELN

WHERE VBAK~VKROG IN S_VKORG AND

VBAP~MATNR IN S_MATNR AND

VBAK~KUNNR IN S_KUNNR.

Thanks

Ramakrishna

Message was edited by:

Ramakrishna Ramisetti

Re: select without key fields

Former Member — Mon, 20 Nov 2006 23:44:48 GMT

Providing FIELDS in the WHERE condition normally makes sure that you make a limited and required selection. Even though the fields Material , Customer and Sales Org are not key fields in VBAK, placing then in the where condition of the select query will definitely help.

Hope this clarifies.

Regards

Kathirvel

Re: select without key fields

Former Member — Mon, 20 Nov 2006 23:45:17 GMT

Hi,

Use the table VAPMA...

SELECT MATNR VKORG KUNNR

INTO TABLE T_VAPMA

FROM VAPMA

WHERE MATNR = '1212'

AND VKORG = '0100'

AND KUNNR = '212'.

Thanks,

Naren