04-17-2019 11:28 AM
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??
04-18-2019 7:44 AM
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)
04-18-2019 7:44 AM
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)
05-04-2019 8:03 AM