on 01-12-2021 9:54 AM
Hello experts,
In sales order, there’re different partner functions, for example, ZZ stands for customer contact. ZZ has a telephone number. I tried to fetch this telephone number from sales order but failed. It seems the same number in VBPA-ADRNR for different partner functions in a sales order.
Is it possible to fetch this telephone number from sales order? If yes, how to meet it? which table stores it?
Pass Sales order Number into VBPA-VBELN and fetch both ADRNR (Address No.) and ADRNP (Person No.) for the PARVW= "ZZ" (since in your case ZZ is you partner function) and pass it into ADR2-ADDRNUMBER (Address No.) and ADR2-PERSNUMBER (Person No.) respectively and fetch ADR2-TEL_NUMBER. ADR2 Table stores data of Telephone Numbers.
In case your contact person is maintained in Sales Order Item you have to pass POSNR along with VBELN in VBPA.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Cathy - for us, the phone number is in KNA1-TELF1
From your partner functions, the partner number equals the customer number
Link via VBPA-KUNNR to KNA1-KUNNR and then obtain field KNA1-TELF1
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
91 | |
9 | |
8 | |
7 | |
7 | |
3 | |
3 | |
3 | |
2 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.