06-11-2009 8:11 PM
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
06-11-2009 10:53 PM
06-11-2009 10:53 PM
06-11-2009 11:29 PM
Dipesh,
Thanks for your reply but b001 does not hold the data I am looking for though. I checked many other B tables as well to no avail.
None of the Bxxx tables showed any Partner information or the Output Type I am looking for (a Z type...ZASN).
Does someone know the specific Bxxx table that houses Shipping Records and the table that stores Partner information?
Thanks,
Dan
06-12-2009 12:00 AM
Try as below:
Go to SPRO --> Logistics Execution --> Shipping >Basic Shipping Functions>Output Control --> Output Determination --
Then select appropirate option (Outbound/inbound... ).
Then select "Maintain/Define Output Type" - Select your output type ZASN and see what is the access sequence assigned to it.
Now go back and select "Define/Maintain Access sequence" and check what condition tables (XXX) are assigned to that access sequence. That will be the number for BXXX.
Hope it helps.
You will see the record in this table - only if condition records are maintained for your output type using VV21.
06-12-2009 12:01 AM
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.