use of vbkd and vbpa table

[Former Member]

Hello Experts,

please tell me the use of tables vbkd and vbpa with an example,

thank you so much for all the replies.

[Former Member]

hi shiva,

v6rxmx/topic/com.ibm.wbia_adapters.doc/doc/mysap3/sap137.htm

v6rxmx/topic/com.ibm.wbia_adapters.doc/doc/mysap4/mysap4149.htm

h20219.www2.hp.com/ERC/downloads/4AA1-3290ENW.pdf

go through these link u will get the information regading these tables

reagards,

sindhu.

[Former Member]

hi,

VBPA is filled when a partner is in a document. As soon as you enter a partner (e.g. forwarding agent) into the shipment, you will have VBPA data. Most other document types have mandatory partners

Reading from Sales Documents: Business Data (VBKD)

If you use a table lookup to read characteristic values from table VBKD ("Sales document: business data"), note that data need not necessarily exist for each item of the sales document. If the item data is no different than the header data, the system does not store it in the item as well. In this case, you can find the valid values in the header data which is stored in table VBKD under the item number "000000".

Thus if you want to read characteristic values from VBKD, you always need to define two table lookups.

You want to read the "KDGRP" field (Customer group) from table VBKD and insert it in the temporary field "USERTEMP1", so that you can use the customer group to derive other characteristics.

To achieve this, you need to create the following two steps:

Step

Derivation type

1 Table lookup in table "VBKD" using the key "KAUFN" and "KDPOS";

Copy content of field "KDGRP" to characteristic "USERTEMP1"

2 Table lookup in table "VBKD" using the key "KAUFN" and "KDPOS".

For "KDPOS", you define field attributes stating that the constant "000000" should be used here. Then copy "KDGRP" to "USERTEMP1"

The result of this rule is that the system first tries to read the item data. But since this information is not stored explicitly, the field "USERTEMP1" remains blank. Then the system carries out step 2, which reads the header data.

If you have used the field "USERTEMP1" for other purposes earlier in the strategy, you should clear its value first.

reward if useful.

Edited by: Malvika Sharma on May 31, 2008 2:45 PM