Hi All,
So I have two Tables
MKDP & MDTB
I need to take all of the rows of field DTNUM in MKDP and get all of the Matching rows in MDTB, and then use the remaining columns from MDTB to build the data set.
The below is the code thus far
However when used the fields such as PLUMI from MDTB are blank
Any Help is greatly received
LIB CONNECT TO [VAR_REV_TRACKER:Snowflake_Sco_Prd];
[MKDP]:
LOAD
HVR_ROWID,
SHSTOVAR_SYNC_TIMESTAMP,
MANDT,
DTART,
MATNR,
PLWRK,
PLSCN,
DTNUM,
DSDAT,
BDBKZ,
SLKZ1,
SLKZ2,
SLKZ3,
SLKZ4,
SLKZ5,
SLKZ6,
SLKZ7,
SLKZ8,
VRKZ1,
VRKZ2,
VRKZ3,
MTART,
MEINS,
DISST,
BESKZ,
SOBSL,
SOBES,
WRK02,
DISMM,
DISVF,
DISPO,
PLDIS,
EKGRP,
MTWZT,
WEBAZ,
BEAZT,
FIXTR,
MFHKZ,
DISLS,
LOSVF,
LOSKZ,
PERAZ,
EISBE,
MINBE,
HOEBE,
BSTMI,
BSTMA,
BSTFX,
BSTRF,
SUM01,
SUM02,
SUM03,
SUM04,
SUM05,
NEGBS,
MSGID,
MSGAR,
MSGNR,
MSGV1,
MSGV2,
MSGV3,
MSGV4,
DISGR,
PERIV,
MRPPP,
BDARF,
LFRHY,
RDPRF,
BERW1,
BERW2,
KZAUS,
AUSDT,
NFMAT,
AUSZ1,
AUSZ2,
AUSZ3,
AUSZ4,
AUSZ5,
AUSZ6,
AUSZ7,
AUSZ8,
BEADA,
NAUKZ,
SAUFT,
KZPROMO,
SHFLG,
SHZET,
FABKZ,
MFXDT,
BSKFL,
MAABC,
CFLAG,
GRREL,
RWPRO,
SHPRO,
AHDIS,
BERW4,
BADON,
SGT_STATC,
HANAON,
GLCHANGETIME,
ZHDCLTIMESTAMP;
[MDKP]:
SELECT "HVR_ROWID",
"SHSTOVAR_SYNC_TIMESTAMP",
"MANDT",
"DTART",
"MATNR",
"PLWRK",
"PLSCN",
"DTNUM",
"DSDAT",
"BDBKZ",
"SLKZ1",
"SLKZ2",
"SLKZ3",
"SLKZ4",
"SLKZ5",
"SLKZ6",
"SLKZ7",
"SLKZ8",
"VRKZ1",
"VRKZ2",
"VRKZ3",
"MTART",
"MEINS",
"DISST",
"BESKZ",
"SOBSL",
"SOBES",
"WRK02",
"DISMM",
"DISVF",
"DISPO",
"PLDIS",
"EKGRP",
"MTWZT",
"WEBAZ",
"BEAZT",
"FIXTR",
"MFHKZ",
"DISLS",
"LOSVF",
"LOSKZ",
"PERAZ",
"EISBE",
"MINBE",
"HOEBE",
"BSTMI",
"BSTMA",
"BSTFX",
"BSTRF",
"SUM01",
"SUM02",
"SUM03",
"SUM04",
"SUM05",
"NEGBS",
"MSGID",
"MSGAR",
"MSGNR",
"MSGV1",
"MSGV2",
"MSGV3",
"MSGV4",
"DISGR",
"PERIV",
"MRPPP",
"BDARF",
"LFRHY",
"RDPRF",
"BERW1",
"BERW2",
"KZAUS",
"AUSDT",
"NFMAT",
"AUSZ1",
"AUSZ2",
"AUSZ3",
"AUSZ4",
"AUSZ5",
"AUSZ6",
"AUSZ7",
"AUSZ8",
"BEADA",
"NAUKZ",
"SAUFT",
"KZPROMO",
"SHFLG",
"SHZET",
"FABKZ",
"MFXDT",
"BSKFL",
"MAABC",
"CFLAG",
"GRREL",
"RWPRO",
"SHPRO",
"AHDIS",
"BERW4",
"BADON",
"SGT_STATC",
"HANAON",
"GLCHANGETIME",
"ZHDCLTIMESTAMP"
FROM "SCO_PRD"."RAW_SAP"."MDKP"
WHERE "PLWRK" IN ('0600', '0602', '5440', '5442', '4980', '3930', '544E');
MDTB:
LIB CONNECT TO [VAR_REV_TRACKER:Snowflake_Sco_Prd];
Left Join ([MDKP])
LOAD
HVR_ROWID,
SHSTOVAR_SYNC_TIMESTAMP,
MANDT,
DTNUM,
DTPOS,
PLAKZ,
PLANR,
DAT00,
SORT1,
SORT2,
DELKZ,
VSTAT,
VRFKZ,
PLUMI,
MNG01,
MNG02,
MNG03,
DAT01,
DAT02,
DAT03,
PERKZ,
PRPER,
WEBAZ,
FIX01,
FIX02,
BAART,
BESKZ,
SOBES,
UMSKZ,
PLART,
AUSSL,
WRK02,
LGORT,
DELNR,
DELPS,
DELET,
AUFVR,
POSVR,
EINVR,
UKZ01,
UMDAT,
DEL12,
BAUGR,
DELVR,
VERSB,
OLDSL,
RDMNG,
PLAAB,
TAG00,
ABEKZ,
MDFST,
MDMNG,
VERID,
WRK01,
SERNR,
REVLV,
DBSKZ,
EXTNL,
ADINF,
RESLO,
PRIO_URG,
PRIO_REQ,
MPNMT,
GLCHANGETIME,
ZHDCLTIMESTAMP;
[MDTB]:
SELECT "HVR_ROWID",
"SHSTOVAR_SYNC_TIMESTAMP",
"MANDT",
"DTNUM",
"DTPOS",
"PLAKZ",
"PLANR",
"DAT00",
"SORT1",
"SORT2",
"DELKZ",
"VSTAT",
"VRFKZ",
"PLUMI",
"MNG01",
"MNG02",
"MNG03",
"DAT01",
"DAT02",
"DAT03",
"PERKZ",
"PRPER",
"WEBAZ",
"FIX01",
"FIX02",
"BAART",
"BESKZ",
"SOBES",
"UMSKZ",
"PLART",
"AUSSL",
"WRK02",
"LGORT",
"DELNR",
"DELPS",
"DELET",
"AUFVR",
"POSVR",
"EINVR",
"UKZ01",
"UMDAT",
"DEL12",
"BAUGR",
"DELVR",
"VERSB",
"OLDSL",
"RDMNG",
"PLAAB",
"TAG00",
"ABEKZ",
"MDFST",
"MDMNG",
"VERID",
"WRK01",
"SERNR",
"REVLV",
"DBSKZ",
"EXTNL",
"ADINF",
"RESLO",
"PRIO_URG",
"PRIO_REQ",
"MPNMT",
"GLCHANGETIME",
"ZHDCLTIMESTAMP"
FROM "SCO_PRD"."RAW_SAP"."MDTB";
