Question:
hi, i created a view on vbak, vbap and vbkd.
it woks, but some datasets are missing ...
ich joined them on mandt, vbeln and vbap/vbkd addtional with posnr.
i recognized that positionnumber 10 is missing always except a few times ...
i can't use the v3 extractor!
what can i do, to fix this prob ?
greetz,
toadward
Answer:
ask this question in the abap forum
Answer:
or show us your join conditions... if I have time, I'll have a look
cheers,
El Belgio
Answer:
A problem might be that you are not using left join;
Example
SO 1 item number 10 has an entry in VBAP but not in VBKD
When you use regular joins, only the records available in all tables are shown, in this case, no record for SO 1 item 10.
Using a left join means you select all fields from the basic table and the fields from the next table that have a common key.
Answer:
Frank is right (he's Belgian?). Table VBKD has header (position 0000) and position items in one table. Usually you only see header items in table VBKD, unless you specify special position conditions. In that case a position entry is added.
Answer:
Using a left join...
in that case you need to have a report or query in stead of an ordinary view.
cheers,
El Belgio
Answer:
Yes - your problem is that VBKD is both header and item level. From an SQL standpoint, It could be joined twice with an alias but I am not sure if SAP supports such coding.
Otherwise, you are stuck with programming.
_________________
Mitchell Lehr
BW - Share the love ><
Answer:
hi,
i code this view not in abap.
i use the se11 to make the view ....
i already checked if the position number is in vbak and vbkd....
i have an idea , but i can try it next week ...
thx for suggestions !!!
nice weekend,
toadward