Skip to Content
0
Former Member
May 27, 2008 at 03:57 AM

How To Join Internal tablr

25 Views

I try to join 4 internal tables to move valut to t_output

DATA: BEGIN OF t_inv_header OCCURS 0,

vbeln TYPE vbrk-vbeln, "Billing No.

xblnr TYPE vbrk-xblnr, "Tax Invoice.

vkorg TYPE vbrk-vkorg, "Sales Org.

vtweg TYPE vbrk-vtweg, "Distribute Channel

spart TYPE vbrk-spart, "Division

kunag TYPE vbrk-kunag, "Sold to Party

fkdat TYPE vbrk-fkdat, "Billing Date.

erdat TYPE vbrk-erdat, "Create On

erzet TYPE vbrk-erzet, "Create Time

name1 TYPE adrc-name1, "Sales Org name1

datum TYPE sy-datum, "Date

uzeit TYPE sy-uzeit, "Time

pagno(4) TYPE c, "Page qty.

END OF t_inv_header.

DATA: BEGIN OF t_inv_item OCCURS 0,

vkorg TYPE vbrk-vkorg, "Sales Org.

vtweg TYPE vbrk-vtweg, "Distribute Channel

vbeln TYPE vbrk-vbeln, "Billing No.

posnr TYPE vbrp-posnr, "Billing Item.

werks TYPE vbrp-werks, "Plant

kvgr1 TYPE vbrp-kvgr1, "Customer Group.

fkimg TYPE vbrp-fkimg, "Billing Quantity.

arktx TYPE vbrp-arktx, "Customer Material.

matnr TYPE vbrp-matnr, "Material No.

vgbel TYPE vbrp-vgbel, "Outbound delivery no.

vgpos TYPE vbrp-vgpos, "Outbound delivery item.

aubel TYPE vbrp-aubel, "Sale Order no.

aupos TYPE vbrp-aupos, "Sale Order Item.

END OF t_inv_item.

DATA: BEGIN OF t_so OCCURS 0,

vbeln TYPE vbkd-vbeln, "Sale Order No.

posnr TYPE vbkd-posnr, "Sale Order Item.

bstkd TYPE vbkd-bstkd, "PO Sold-to [PO Header].

bstkd_e TYPE vbkd-bstkd_e, "PO Ship-To

END OF t_so.

DATA: BEGIN OF t_outb OCCURS 0,

vbeln TYPE likp-vbeln, "Outbound delivery no.

kunnr TYPE likp-kunnr, "Ship-to party

vstel TYPE likp-vstel, "Shipping Point

lfdat TYPE likp-lfdat, "Delivery date

posnr TYPE lips-posnr, "Outbound Delivery Item.

matnr TYPE lips-matnr, "Mat no.

END OF t_outb.

DATA: BEGIN OF t_output OCCURS 0,

vbeln TYPE vbrk-vbeln, "Billing No.

posnr TYPE vbrp-posnr, "Billing Item.

kvgr1 TYPE vbrp-kvgr1, "Customer Group.

fkimg TYPE vbrp-fkimg, "Billing Quantity.

arktx TYPE vbrp-arktx, "Customer Material.

matnr TYPE vbrp-matnr, "Material No.

vgbel TYPE vbrp-vgbel, "Outbound delivery no.

vgpos TYPE vbrp-vgpos, "Outbound delivery item.

aubel TYPE vbrp-aubel, "Sale Order no.

aupos TYPE vbrp-aupos, "Sale Order Item.

bstkd TYPE vbkd-bstkd, "PO Sold-to [PO Header].

bstkd_e TYPE vbkd-bstkd_e, "PO Ship-To

lfdat TYPE likp-lfdat, "Delivery date

END OF t_output.

How can I do it? or do you have better solution. please suggest.

-


And other question I try to filter Billing Type by using this code

SELECT vbrkvbeln vbrkxblnr vbrk~vkorg

vbrkvtweg vbrkspart vbrk~kunag

vbrkfkdat vbrkerdat

vbrk~erzet

INTO TABLE t_inv_header

FROM vbrk

WHERE vbrk~vkorg IN s_vkorg

AND vbrk~fkart NOT IN

('ZB50','ZB54','ZB60','ZB64','ZB70','ZB71','ZC++')

AND vbrk~erdat IN s_erdat

AND vbrk~erzet IN s_erzet

AND vbrk~vbeln IN s_vbeln

AND vbrk~kunag IN s_kunag

AND vbrk~fkdat IN s_fkdat.

But It does not work, How can I filter Billing Type all ZC++ out (for excample, ZC01 ZC02 ZC03 ZC04 ZC05)