cancel
Showing results for 
Search instead for 
Did you mean: 

Onetime Customer Table

Former Member
0 Kudos

Hi All

I have a one time ship to party

During creation of sales order one time ship to party address will be filled

During print out of Delivery document and Invoice document one time address is not appearing delivery and invoice output

Please suggest the logic to get one time customer address and also the table where it gets stored

Accepted Solutions (0)

Answers (4)

Answers (4)

0 Kudos

In table BSEC you will find the address belonging to a one-time customer in a financial document.

Former Member
0 Kudos

You need to fetch the address from LIKP-KUNNR, now your output must be showing address from KNA1. Take address number from VBPA with partner function WE, then put that adress number in ADR6 to get the details of address

Former Member
0 Kudos

HI Srinath

Thankyou for the reply

But in KNA1 we cannot get one time customers address

former_member217082
Active Contributor
0 Kudos

Hi GS

Check in KNVS, KNVK,KNVP tables also

Regards

Srinath

Former Member
0 Kudos

Dear GS,

At present, I can't check at my end (No SAP Access), but you may check:

VBPA-ADRNR from ADRC;

for Account Group: CPDA - One time Customer

If the value in VBPA-ADRDA is:

'D' = SAP goes to the table ADRC for the address. 'A' = SAP goes to the table SADR for the address.

Best Regards,

Amit

former_member217082
Active Contributor
0 Kudos

Hi GS

Check the following tables

KNA1 , KNVV , LIKP ,LIPS , VBRK , VBRP

Regards

Srinath