Skip to Content
avatar image
Former Member

Database tables for VV23 Display Output Conditions Records: Shipping

Hello,

I am looking for the database tables where the following information is being stored. If I F1 on the desired fields I am only getting structures and doing a "where used" is not getting me what I am looking for.

Please see the following logic flow...

Go To-->  VV23 

Do a SELECT on  Output Type Field ( Field Name = KSCHL) 

From Output Type Field  get Sales Org. ( Field Name = VKORG) 

From Sales Org. get Bill To (Field Name = KUNRE) and Partner (Field Name = PARNR). 

Essentially the same flow as VV23. I am just looking for the 3 (assuming) table names.

It is unnecessary to provide any SELECT statements etc.

Thanks in advance,

Dan

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Jun 11, 2009 at 09:53 PM

    Try B001

    If this is not -- then check BXXX (B002, B003 .. etc)

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Found an answer...

      SELECT TNAPN WHERE KSCHL = 'zasn'

      select * from NACH KSCHL = 'zasn'.

      Get KOTBNR field...

      NACH-KOTBNR = '904'

      CONCAT B + 904

      select * from B904.