‎2008 Mar 07 10:37 AM
Hi,
I want to know on what basis entries are made in the table VBKD.
Even if a sales order has multiple line items, it is not having the data for those sale order and line items.
This is not the case with all the sale orders, but only some sale orders.
Why is it so.??
Regards.
‎2008 Mar 07 10:50 AM
‎2008 Mar 07 11:36 AM
Hi,
When you define a table lookup for the table VBKD (Sales document: Business data), data does not have to be present for every item in 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
check the related links
http://help.sap.com/saphelp_47x200/helpdata/en/7a/4c39084a0111d1894c0000e829fbbd/frameset.htm
regards
‎2008 Mar 07 5:54 PM
As per SAP documentation,
Table Lookup in Table VBKD
When you define a table lookup for the table VBKD (Sales
document: Business data), data does not have to be present
for every item in 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.
1. First look up against VBKD table using the corresponding
sales document number and item number.
2. If such an entry does not exist, look up using the
corresponding sales document number and item number
as '000000'.
This rule causes the system to first try to read the item data. If
this information is not stored explicitly in VBKD table step 2 is
carried out, which reads the header data.
Hope this helps.
Thanks,
Balaji