Skip to Content
0
Former Member
Sep 08, 2011 at 04:32 AM

Issue with Extracting from Preceding item field (POSNV) in Table VBFA

65 Views

Hi,

We are creating Sales Order with the copy functionality and used the concept of Preceding Document and Follow on documents from Table VBFA.

Quotation: VBTYP_N = B

Contract: VBTYP_N=G

Sales Order: VBTYP_N=C

For every Preceding Document, Follow on Document is created with Preceding Item (Technical Name: POSNV) as u201C0u201D and u201C1u201D.

We have built the logic as for every Subsequent Document Category (VBTYP_N) it will take Preceding Item (POSNV) as u201C0u201D and capture in the report. Thus help us to identify Sales Order Tracking.

For Example: Inquire No. 34 have following subsequent documents:

Output from VBFA:

Preceding Doc. Preceding Item Follow On doc Subseq. Item Subseq. Doc Cate.

34 (Inquire) 200039 B

34 1 200039 1 B

34 1 300241 1 G

34 1 400466 1 C

Preceding Doc. Preceding Item Follow On doc Subseq. Item Subseq. Doc Cate.

200039 (Quotation) 300241 G

200039 1 300241 1 G

200039 1 400466 1 C

And so onu2026

u2003

Preceding Doc. Preceding Item Follow On doc Subseq. Item Subseq. Doc Cate.

50 (Inquire) 200046 B

50 1 200046 1 B

50 1 300240 1 G

50 1 400465 1 C

Preceding Doc. Preceding Item Follow On doc Subseq. Item Subseq. Doc Cate.

200046 (Quotation) 1 300240 1 G

200046 1 400465 1 C

Here for Quotation 200046 Preceding Item u201C0u201D is not getting created. I have checked Order also but unable to find the cause for the same.

Can you please help me out in finding the cause of this problem.

Thanks,

Rajat Bhargava