Hello Experts,
I am there in a confusion for the the data entries between VBAK (Sales document header) and VBUK (Header Status and Administrative Data Table). I was in the assumption that # of entries and content (Sales document #) in both of the table would be the same as one is for Sales doc header and other is for its status,while this was not there, some of the entries were there in VBUK which were not in VBAK. I know this seems to be pretty basic question but can anyone please comment over here.
Regards,
VBUK is used for SD documents in general, which includes deliveries and billing documents.
In VBUK there is a field VBOBJ, which can help you find out to which object the entry refers to - e.g. 'L' is for delivery, 'F' is for billing.
Apart from the field already suggested, you can also validate with VBTYP in VBUK which would show C - for sale order, J - for Delivery
Data inconsistency can also happen if there is a programming error (either in standard or custom code) and not all records are updated/deleted in the same transaction. I believe there are SAP notes that address the "ghost" record issues, search in SAP Support Portal.
Yes I think, I have found my answer which I expect should be correct. VBAK stores data only for VBTYP= A to I and K, L(i.e. Inquiry to Order w/o charge and credit & Debit memo request). Sales document of other type are stored in different table like for ex VBTYP = J(Delivery) is stored in LIKP. However the status table stores all of the document in the Sales Flow from Inquiry to Invoice and hence have more data than VBAK.
Thanks all of you for your support...
My undersanding is though both are highly correlated, the main difference is that once holds only data regarding the order (VBAK), while the other is concerned with the status of the particular document (VBUK). Hence, not every document type will update status in the same manner and also there might be document types that have multiple status updates. So, that could be a reason why you find inconsisitency.