One time customer table in va01

[former_member381412]

Hi Experts,

In va01 when we create one time customer it ask for address which does'nt get stored in the kna1 table.. i have developed smartform where the address is coming but not the case of one customer...i have tried using table sadr and adr2,3,4,5 but not able to find as there is not data... can anyone help me its urgent.

Regards,

Richa

[Lakshmipathi]

Try passing the order number in VBPA where you take the value of ADRNR and pass it on to ADDRNUMBER in ADRC table

[former_member381412]

Dear G Lakshmipathi,

Can you share query

[Lakshmipathi]

Whenever you add any post to your original query, please do so under "Comment" and not under "Answer", as you were not answering to a query but only providing additional informations as required by the member. Meanwhile, I have converted your above post from Answer to Comment.

[Lakshmipathi]

Can you share query

Not sure what do you mean by this !!!!

If you know how to table join in SQVI, try with the tables suggested above. Else, first execute SE16 / SE16N, input VBPA table and take the value from ADRNR field. Now go back and input ADRC table and pass the ADRNR value in ADDRNUMBER field, so that, you will get the desired result.

[former_member381412]

Dear G Lakshmipathi,

Please check our query and give me idea how to print Address in ONE Time customer

READ TABLE IT_VBPA INTO WA_VBPA WITH KEY VBELN = WA_VBPA-ADRNR.
READ TABLE IT_ADRC INTO WA_ADRC WITH KEY ADDRNUMBER = WA_ADRC-ADDRNUMBER.

[Jelena]

This is not a "query". This is an ABAP code fragment that is reading some internal tables. SCN members can't possibly know what data is in those tables or even what they are. But unless you used a very odd definition it doesn't seem to make sense to me to expect an entry where VBELN = ADRNR.

Simply run the form in debugger and see for yourself what data is where. If you're not an ABAPerr then get an ABAPer locally to help with this.