topic select query in Application Development and Automation Discussions

select query

Former Member — Wed, 17 Apr 2019 10:28:50 GMT

i have this requirement

s_vbeln is optional

from this input i have to show the output in alv as follows

sale id , division , customer name , sale item , material , qunatity, price, delivery number ,delivery date ,

shipment number , shipment quantity ,

invoice number , invoice price.

i have done my R n D about tables and fields like this

vbak-vbeln-----------sale id

vbak-spart-----------division

kna1-name1_gp--------customer name

vbap-posnr-----------sale item

vbap-matnr-----------imaterial

vbap-netwr-----------price

vbap-kwmeng----------quantity

likp-vbeln delivery number

likp-lfdat_v delivery date

lips-fkimg---del.qty,

vttk-tknum------shipment number

vttp-erdat------SHIPMENT QTY

vbrk-vbeln--------invoice number----

vbrp-fkimg--------invoice qty-------

vbrp-netwr_fp-----invoice price-----

up to vbak vbap kna1 likp lips i have linked with where clause.

but im failing to link with vttk vttp vbrk vbrp??

can anyone help me out??

RaymondGiuseppi — Thu, 18 Apr 2019 06:44:48 GMT

You should look at table VBFA too. (document flow)

NB: For performance, there are also some tables to use (aka secondary indexes) to link tables: e.g. vakpa, vapma, vlkpa, etc. (Alas ☹ OSS note Note 185530 - Performance Customer developments in SD is not longer available, but a note such as 128947 - Correction of SD document indexes with RVV05IVB is still available and will provide you a list of such indexes and a list of transaction that use those, so you can analyze them)

Former Member — Sat, 04 May 2019 07:03:10 GMT

thank you raymond.giuseppi