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)