New search help created for VA03 but pool table not populated

[Former Member]

A new search help has been created for VA03- Sales Orders, based on VMVAH, to add two fields.

However this does not bring any results, as the new pool table does not contain data.

What is required to populate the new pool table?

Note - this is for SAP version 45B.

[christian_wohlfahrt]

Hi Chris!

I had a look at VMVAH, this has a data selection with view V_VMVAH and some coded logic for VBUK (and VBAK, but they are both transparent tables).

So you took this and added an additional table? Which table did you add, that would be crucial to tell how it is filled?

Or did I get something wrong?

Regards,

Christian

[Former Member]

Hi Christian,

1. The requirement is to have a Search Help under /VA03 (Sales Orders) like ‘Blocked / Released Orders (Credit Control)’ but with 2 extra fields added – Sales office (VBAK-VKBUR), and Created By (VBAK-ERNAM).

2. /VA03 uses collective search help VMVA.

Current processing:

3. ‘Blocked / Released Orders (Credit Control)’ uses elementary search help VMVAH.

This uses selection method M_VMVAH, which is a pool table, pool/cluster M_VMVA.

4. Table M_VMVAH contains data.

New processing:

5. Under collective search help VMVA, new elementary search help ZVMVAH was created.

This has the 2 new fields added – VKBUR and ERNAM.

It uses selection method ZSDM_VMVAH, a pool table with pool/cluster M_VMVA.

6. Table ZSDM_VMVAH is empty. Consequently the search help does not return any results.

7. The problem is how to get data into table ZSDM_VMVAH. Do we have to run something, or amend some code somewhere?

Regards,

Chris

[christian_wohlfahrt]

Hi Chris!

Looks like there was a big change in some release. Maybe you should copy 'my' version (from ERP 5.0).

When you have a pool table as data source, then you would need user-exits to fill/delete entries with each status change. From process point of view, it's not important if it's a pool or transparent table: it will be empty, unless you (because of Z...) will make insert / delete somewhere explicit.

But why making this additional work, just go for database views: they are selecting data out of multiple tables, so they are always up to date.

In my system elementary search help VMVAH uses selection method V_VMVAH, which is linked directly to a database view V_VMVAH.

This is defined in the following way:

<b>Table/join conditions</b>

VBAK MANDT = VBUK MANDT

VBAK VBELN = VBUK VBELN

<b>View fields</b>

MANDT

KKBER

CMGST

SBGRP

CMNGV

KNKLI

CTLPC

GRUPP

CMFRE

CMNUP

VKORG

VTWEG

SPART

VBELN

<b>Selection Conditions</b>

VBUK VBOBJ EQ 'A' AND

VBUK GBSTK NE 'C' AND

VBUK GBSTK NE ' ' AND

VBUK CMGST NE 'A' AND

VBUK CMGST NE ' '

I would propose a new database view like this plus the view fields vkbur and ernam.

Regards,

Christian

[Former Member]

Hi Christian,

Thank you very much for looking at this.

You are correct in saying there is a big change at some release. Your VMVAH uses selection method V_VMVAH which points to a view. My VMVAH uses selection method M_VMVAH which points to a pool table. Standard code (fm) MC_UPDATE_VMVA would need to be amended to update the new table.

Or the user can just wait until SAP is upgraded.

Thanks again.

Happy New Year to you.

Chris