Skip to Content
-2
Jul 05 at 11:47 AM

How to combine multiple internal table into one final internal table without header line and joins?

95 Views Last edit Jul 07 at 04:40 AM 3 rev

Hello experts,

I am stuck at a place where I am able to pull out the data from 5 different tables but not able to put all the data into one final internal table without a header line for the creation of the ALV report? Those five tables are- KNA1, VBRK, VBRP, MARA & MAKT.

KNA1- Customer no(kunnr), Name1(name1), City(Ort01), Company code(Bukrs), Date of record(Erdat), Name of person(Ernam).

VBRK- Customer no(Kunag), Billing document(Vbeln), Billing type(Fkart), Customer group(Kdgrp).

VBRP- Billing document(Vbeln), Material Number(Matnr), Billing item(Posnr).

MARA- Material Number(Matnr), Material group(Matkl), Material type(Mtart).

MAKT- Material Number(Matnr), Material description(Maktx).

On the basis of customer no I have to find a billing document, based on the billing document I need its material number, based on material number need its material group, and based on the material number the material description.

I am able to pull out the data, the only help I want is to put all these internal tables data into one final internal table which is.

BEGIN OF TP_FINAL,
KUNNR TYPE KUNNR,
NAME1 TYPE NAME1,
ORT01 TYPE ORT01,
BUKRS TYPE BUKRS,
ERDAT TYPE ERDAT,
ERNAM TYPE ERNAM,
VBELN TYPE VBELN,
FKART TYPE FKART,
FKTYP TYPE FKTYP,
KDGRP TYPE KDGRP,
POSNR TYPE POSNR,
MATNR TYPE MATNR,
MATKL TYPE MATKL,
MTART TYPE MTART,
MAKTX TYPE MAKTX,
MAKTG TYPE MAKTG,
END OF TP_FINAL.

Please help me out with this?