BDC - TABLE CONTROL PROBLEM

[srajendran]

Hi,

I am working on a table control, currently i am facing a scenario.

While doing BDC in change mode, at the run time how to read the values which are going to be populated on table control?

For example in VA02 , if i want to change the quantity of a particular material that is to be displayed, then how to edit the value's that are to be displayed on the table control ?

Thanks & Regards,

Senthil Kumar . R

[Former Member]

Hi Senthil,

You can get material details by querying on table <b>VBAP</b>.This will gives you line item details for given sales document number.

<b>If you observe clearly in VA02</b>, the transactin wont allow to edit values of material details and its grayed out. So you cant edit quantity of a material. Once an entry is posted via VA01, you cant edit the values through VA02.If you need to edit the values then delete the same row and edit with new values.

Thanks,

Vinay

[Former Member]

Hi Senthil.

You can use OK-code '=POPO' to position a specific order item to the top of the table control. Then you can easily change the quantity of the material.

Regards,

John.

[srajendran]

Hi John,

Can u Pls expain briefly. If you have any code regarding this pls post it in this thread .

Thanks & Regards,

Senthil Kumar.R

[Former Member]

Hi Senthil,

Before you start the BDC read table VBAP to determine the order position you want to change.

Then from the main screen of the VA02 add a BDC-step for:

=POPO. This triggers a pop-up screen (SAPMV45A screen 0251, the field is RV45A-POSNR) on which you can enter the position number to be moved to the top of the table control. If you return on the main screen the first entry is the line you want to change (eq. quantity RV45A-KWMENG(01). )

Regards,

John.

[Former Member]

Hi senthil,

1. at the run time how to read the values which are going to be populated on table control?

Unfortunately this is not possile in bdc program.

2. We have to make our own logic,

and write a select query,

to determine, which line-item records,

will be filled in the table control.

(and in which sequence, they will be populated)

3. Then based upon that,

we have to SIMULATE the Modification/Edit

of that line item.

4. Its always better to use BADI

in such cases,

which are specifically designed

for sales order.

eg. BAPI_SALESORDER_CHANGE

regards,

amit m.