LinkTable Question?

[MuraliPrasath]

Hi,

I have 3 tables with two common fields. I have to create one LinkTable for %MATNR_WERKS and  MATNR and  WERKS.

Need Help.

MSKU:

LOAD

    MATNR &'/'& WERKS as %MATNR_WERKS,

   MATNR,

   WERKS,

    KULAB

FROM [..\30_QVD\MSKU.qvd](qvd);

MSLB:

LOAD

    MATNR &'/'& WERKS as %MATNR_WERKS,

   MATNR,

   WERKS,

    CHARG,

    SOBKZ,

FROM [..\30_QVD\MSLB.qvd](qvd);

RESB:

LOAD

    MATNR &'/'& WERKS as %MATNR_WERKS,

   MATNR,

   WERKS,

    ERFMG,

    AUFNR,

FROM [..\30_QVD\RESB.qvd](qvd);

[surendraj · Accepted solution]

MSKU:

LOAD

    MATNR &'/'& WERKS as %MATNR_WERKS,

   //MATNR,

   //WERKS,

    KULAB

FROM [..\30_QVD\MSKU.qvd](qvd);

MSLB:

LOAD

    MATNR &'/'& WERKS as %MATNR_WERKS,

   //MATNR,

   //WERKS,

    CHARG,

    SOBKZ,

FROM [..\30_QVD\MSLB.qvd](qvd);

RESB:

LOAD

    MATNR &'/'& WERKS as %MATNR_WERKS,

   //MATNR,

   //WERKS,

    ERFMG,

    AUFNR,

FROM [..\30_QVD\RESB.qvd](qvd);

link table:

LOAD

    MATNR &'/'& WERKS as %MATNR_WERKS,

    MATNR,

    WERKS,

    //KULAB

FROM [..\30_QVD\MSKU.qvd](qvd);

concatinate

MSLB:

LOAD

    MATNR &'/'& WERKS as %MATNR_WERKS,

   MATNR,

   WERKS,

    //CHARG,

    //SOBKZ,

FROM [..\30_QVD\MSLB.qvd](qvd);

conacatinate

RESB:

LOAD

    MATNR &'/'& WERKS as %MATNR_WERKS,

   MATNR,

   WERKS,

    //ERFMG,

    //AUFNR,

FROM [..\30_QVD\RESB.qvd](qvd);

By concatinating above 3 tables.Link Table have the only 3  feilds.

MATNR &'/'& WERKS as %MATNR_WERKS(key)

MATNR,

WERKS

Note:if you want another feilds except these,you can extract from separete tables which are located above.

--Surendra