vbkd

[Former Member]

Hi friends,

In table VBKD you have a POSNR 000000 for header data and then POSNR e.g. 000001 for item 1 on the sales order. According to me a POSNR not equal to 000000 will only be created when you have different purchase order data per item. When does the system update field IHREZ_E in table VBKD? And what is the meaning of the values in the field? We now get different entries in VBKD an this has something to do with field IHREZ_E.

Any ideas.

Thanks

[Former Member]

hi, some ideas please.

[Former Member]

Hi,

Let me try to understand the problem:

"According to me a POSNR not equal to 000000 will only be created when you have different purchase order data per item."

No, it will be created when you made the first change to item purchase order data, equal or not to the header data.

Initialy, the header information will be visible in the item view (but in vbkd it will only exists for posnr = 00000), but only if you made a change (you can even put the same value again) to the purchase order data per item, the vbkd for posnr = 00001 will be inserted.

"When does the system update field IHREZ_E in table VBKD?"

The system will update IHREZ_E for posnr = 0000 every time you change IHREZ_E in the Header purchase order data (GoTo-header-purchaseData).

The system will update IHREZ_E for posnr = 0001 every time you change IHREZ_E in the Item purchase order data (GoTo-item-purchaseData).

"And what is the meaning of the values in the field?"

According to SAP "The reference number generally identifies the person who is responsible for the document at the end customer. (The reference number can, for example, be taken from the employee's initials.)

"

but it's not a very important field, im my case, we used to hold a value for external system identification.

I hope i helped,

Regards,

[Former Member]

Hi,

I appreciate your help. As well any other inputs would be appreciated.

Thank you.

[Former Member]

Hello,

U can select like this>

select * from vbkd ... where posnr eq ebelp+1(5).