8 Replies Latest reply: Feb 28, 2017 2:07 AM by swarnendu haldar RSS

    Problem in fetching Data sap(vbak table) to qlikview

    swarnendu haldar

      Hello Every body,

      please help me who know this

      I will try to fetching data from sap to qlikview but when i will try then i show a scripting error..error also give in screen shots 1.jpg

      There is the script..

      [VBAK]:

      Load

         //MANDT & VBELN AS %KEY_VBAK_MANDT_VBELN,

         [MANDT] as [Client_MANDT],

         [KNUMA] as [Agreement_KNUMA],

         [VKORG] as [Sales Org._VKORG],

         [VTWEG] as [Distr. Channel_VTWEG],

         [SPART] as [Division_SPART],

         [ERNAM] as [Created by_ERNAM],

         [ERZET] as [Time_ERZET],

         [ERDAT] as [Created on_ERDAT],

         [AEDAT] as [Changed on_AEDAT],

         [VBTYP] as [Document cat._VBTYP],

         [AUART] as [Sales Doc. Type_AUART],

         [VGBEL] as [Reference doc._VGBEL],

         [KURST] as [Exch. Rate Type_KURST],

         [VBELN] as [Sales Document_VBELN],

         [KUNNR] as [Sold-to party_KUNNR],

         [BSTNK] as [PO Number_BSTNK],

         [VKBUR] as [Sales Office_VKBUR],

         [VKGRP] as [Sales Group_VKGRP],

         [BSTDK] as [PO date_BSTDK],

         [AUFNR] as [Order_AUFNR],

         [STAFO] as [Update group_STAFO],

         [ANGDT] as [Valid from_ANGDT],

         [BNDDT] as [Valid to_BNDDT],

         [AUDAT] as [Document Date_AUDAT],

         [TRVOG] as [Transact.group_TRVOG],

         [AUGRU] as [Order reason_AUGRU],

         [GWLDT] as [Begin guarantee_GWLDT],

         [SUBMI] as [Collective no._SUBMI],

         [LIFSK] as [Delivery block_LIFSK],

         [FAKSK] as [Billing block_FAKSK],

         [NETWR] as [Net value_NETWR],

         [WAERK] as [Doc. Currency_WAERK],

         [GSBER] as [Business Area_GSBER],

         [GSKST] as [Business area_GSKST],

         [GUEBG] as [Valid from_GUEBG],

         [GUEEN] as [Valid to_GUEEN],

         [KNUMV] as [Doc. condition_KNUMV],

         [VDATU] as [Request.dlv.dt_VDATU],

         [VPRGR] as [Prop.date type_VPRGR],

         [AUTLF] as [Complete dlv._AUTLF],

         [VBKLA] as [Original system_VBKLA],

         [VBKLT] as [Indicator_VBKLT],

         [KALSM] as [Pric. procedure_KALSM],

         [VSBED] as [Shipping Cond._VSBED],

         [FKARA] as [Ord-rel.bill.ty_FKARA],

         [AWAHR] as [Probability_AWAHR],

         [KTEXT] as [Description_KTEXT],

         [BSARK] as [Pur. ord. type_BSARK],

         [BSTZD] as [Supplement_BSTZD],

         [IHREZ] as [Your Reference_IHREZ],

         [BNAME] as [Name_BNAME],

         [TELF1] as [Telephone_TELF1],

         [MAHZA] as [No.of contacts_MAHZA],

         [MAHDT] as [Last contact dt_MAHDT],

         [KOSTL] as [Cost Center_KOSTL],

         [STWAE] as [Stats Currency_STWAE],

         [KVGR1] as [Customer grp 1_KVGR1],

         [KVGR2] as [Customer grp 2_KVGR2],

         [KVGR3] as [Customer grp 3_KVGR3],

         [KVGR4] as [Customer grp 4_KVGR4],

         [KVGR5] as [Customer grp 5_KVGR5],

         [KOKRS] as [CO Area_KOKRS],

         [PS_PSP_PNR] as [WBS Element_PS_PSP_PNR],

         [KKBER] as [Cred.contr.area_KKBER],

         [KNKLI] as [Credit account_KNKLI],

         [GRUPP] as [Cust.cred.grp_GRUPP],

         [SBGRP] as [Cred.rep.grp_SBGRP],

         [CTLPC] as [Risk category_CTLPC],

         [CMWAE] as [Currency_CMWAE],

         [CMFRE] as [Release date_CMFRE],

         [CMNUP] as [Next check_CMNUP],

         [CMNGV] as [Next date_CMNGV],

         [AMTBL] as [Credit value_AMTBL],

         [HITYP_PR] as [HierTypePricing_HITYP_PR],

         [ABRVW] as [Usage_ABRVW],

         [ABDIS] as [MRP for DS type_ABDIS],

         [OBJNR] as [Object no. hdr_OBJNR],

         [BUKRS_VF] as [CCodeToBeBilled_BUKRS_VF],

         [TAXK1] as [Alt.tax class._TAXK1],

         [TAXK2] as [TaxClass2-Cust._TAXK2],

         [TAXK3] as [TaxClass3-Cust._TAXK3],

         [TAXK4] as [TaxClass4-Cust._TAXK4],

         [TAXK5] as [TaxClass5-Cust._TAXK5],

         [TAXK6] as [TaxClass6-Cust._TAXK6],

         [TAXK7] as [TaxClass7-Cust._TAXK7],

         [TAXK8] as [TaxClass8-Cust._TAXK8],

         [TAXK9] as [TaxClass9-Cust._TAXK9],

         [XBLNR] as [Reference_XBLNR],

         [ZUONR] as [Assignment_ZUONR],

         [VGTYP] as [Prec.doc.categ._VGTYP],

         [KALSM_CH] as [Search proced._KALSM_CH],

         [AGRZR] as [Accrual period_AGRZR],

         [QMNUM] as [Notification_QMNUM],

         [VBELN_GRP] as [Master contract_VBELN_GRP],

         [SCHEME_GRP] as [Ref.procedure_SCHEME_GRP],

         [ABRUF_PART] as [Check partner_ABRUF_PART],

         [ABHOD] as [Pick up date_ABHOD],

         [ABHOV] as [Pick up time_ABHOV],

         [ABHOB] as [Pick up time_ABHOB],

         [RPLNR] as [Paym.ca.pl.no._RPLNR],

         [VZEIT] as [Req. dely time_VZEIT],

         [STCEG_L] as [Tax dest. cntry_STCEG_L],

         [LANDTX] as [Tax depart. cty_LANDTX],

         [XEGDR] as [EU triang. deal_XEGDR],

         [ENQUEUE_GRP] as [_ENQUEUE_GRP],

         [DAT_FZAU] as [CmlQtyDate_DAT_FZAU],

         [FMBDAT] as [Mat.Avail.Date_FMBDAT],

         [VSNMR_V] as [Version_VSNMR_V],

         [EQUNR] as [Equipment_EQUNR],

         [ZZAUART] as [Sales Doc. Type_ZZAUART],

         [ZZSUPTYP] as [Supply Type_ZZSUPTYP],

         [ZZOFFERTYP] as [Offer Type_ZZOFFERTYP],

         [ZZSTATUS] as [Status_ZZSTATUS],

         [ZZINQTYP] as [Inquiry Type_ZZINQTYP],

         [ZZCHANNEL] as [Channel_ZZCHANNEL],

         [ZZBSTNK] as [PO Number_ZZBSTNK],

         [ZZBGTYPE1] as [_ZZBGTYPE1],

         [ZZBGDATE1] as [_ZZBGDATE1],

         [ZZBGNUMBER1] as [BG Number_ZZBGNUMBER1],

         [ZZBGOPTION1] as [_ZZBGOPTION1],

         [ZZBGTYPE2] as [_ZZBGTYPE2],

         [ZZBGDATE2] as [_ZZBGDATE2],

         [ZZBGNUMBER2] as [BG Number_ZZBGNUMBER2],

         [ZZBGOPTION2] as [_ZZBGOPTION2],

         [ZZBGTYPE3] as [_ZZBGTYPE3],

         [ZZBGDATE3] as [_ZZBGDATE3],

         [ZZBGNUMBER3] as [BG Number_ZZBGNUMBER3],

         [ZZBGOPTION3] as [_ZZBGOPTION3],

         [TPLNR] as [Functional loc._TPLNR],

         [CONT_DG] as [Contains DG_CONT_DG],

         [PROLI] as [DG mgmt profile_PROLI],

         [MTLAUR] as [Target Incom_MTLAUR],

         [PHASE] as [Sal. Phase_PHASE],

         [HANDLE] as [Int.ID_HANDLE],

         [KALCD] as [Proc. Camp.Det._KALCD],

         [LOGSYSB] as [Logical system_LOGSYSB],

         [CRM_GUID] as [Char 70_CRM_GUID],

         [SWENR] as [Bus. entity_SWENR],

         [SMENR] as [Sales Unit_SMENR],

         [STAGE] as [Construction stage_STAGE],

         [HB_CONT_REASON] as [Contingency_HB_CONT_REASON],

         [HB_EXPDATE] as [Expiration date_HB_EXPDATE],

         [HB_RESDATE] as [Resolution date_HB_RESDATE],

         [MULTI] as [Multiple Promotions_MULTI],

         [ZAPPL_CARD] as [_ZAPPL_CARD],

         [ZZEQTYP] as [Equipment Type_ZZEQTYP],

         [ZZEQCODE] as [Equipment Code_ZZEQCODE],

         [ZZEQSIZE] as [Equipment Size_ZZEQSIZE],

         [ZZORDEXP] as [Order Exp By_ZZORDEXP],

         [ZZORDREV] as [Last Rev on_ZZORDREV],

         [ZZOFFDUE] as [Offer Due Date_ZZOFFDUE],

         [ZZTOTWT] as [Total Weight_ZZTOTWT],

         [ZZOFFPRICE] as [Offer Price_ZZOFFPRICE],

         [ZZWAERS1] as [Currency 1_ZZWAERS1],

         [ZZDMBTR] as [Amount in LC_ZZDMBTR],

         [ZZKURSF] as [Exchange rate_ZZKURSF],

         [ZZCPNAME] as [Lost Comp Name_ZZCPNAME],

         [ZZCPPRICE] as [Comp Price_ZZCPPRICE],

         [ZZWAERS2] as [Currency 2_ZZWAERS2],

         [ZZCOST] as [Cost_ZZCOST],

         [ZZREASON] as [Reason Code_ZZREASON],

         [ZZFACTOR] as [Factor_ZZFACTOR],

         [ZZDRST] as [Drawing status_ZZDRST],

         [ZZDRDT] as [Drawing release date_ZZDRDT],

         [ZZDRRL] as [Drawing Released by_ZZDRRL],

         [ZZBGVALUE1] as [BG Value_ZZBGVALUE1],

         [ZZBGPER1] as [_ZZBGPER1],

         [ZZBGVALUE2] as [BG Value_ZZBGVALUE2],

         [ZZBGPER2] as [_ZZBGPER2],

         [ZZBGVALUE3] as [BG Value_ZZBGVALUE3],

         [ZZBGPER3] as [_ZZBGPER3];

       

      SQL Select  MANDT KNUMA VKORG VTWEG SPART VBELN ERNAM ERZET ERDAT AEDAT VBTYP AUART AUFNR KUNNR TELF1 VGBEL KURST BSTNK VKBUR VKGRP BSTDK STWAE STAFO ANGDT BNDDT AUDAT TRVOG AUGRU GWLDT SUBMI LIFSK FAKSK NETWR WAERK GSBER GSKST GUEBG GUEEN KNUMV VDATU VPRGR AUTLF VBKLA VBKLT KALSM VSBED FKARA AWAHR KTEXT BSARK BSTZD IHREZ BNAME MAHZA MAHDT KOSTL KVGR1 KVGR2 KVGR3 KVGR4 KVGR5 KOKRS PS_PSP_PNR KKBER KNKLI GRUPP SBGRP CTLPC CMWAE CMFRE CMNUP CMNGV AMTBL HITYP_PR ABRVW ABDIS OBJNR BUKRS_VF TAXK1 TAXK2 TAXK3 TAXK4 TAXK5 TAXK6 TAXK7 TAXK8 TAXK9 XBLNR ZUONR VGTYP KALSM_CH AGRZR QMNUM VBELN_GRP SCHEME_GRP ABRUF_PART ABHOD ABHOV ABHOB RPLNR VZEIT STCEG_L LANDTX XEGDR ENQUEUE_GRP DAT_FZAU FMBDAT VSNMR_V EQUNR HANDLE ZZAUART ZZSUPTYP ZZOFFERTYP ZZSTATUS ZZINQTYP ZZCHANNEL ZZBSTNK ZZBGTYPE1 ZZBGDATE1 ZZBGNUMBER1 ZZBGOPTION1 ZZBGVALUE1 ZZBGTYPE2 ZZBGDATE2 ZZBGNUMBER2 ZZBGOPTION2 ZZBGVALUE2 ZZBGTYPE3 ZZBGDATE3 ZZBGNUMBER3 ZZBGOPTION3 ZZBGVALUE3 TPLNR CONT_DG STAGE PROLI CRM_GUID PHASE MTLAUR SWENR MULTI SMENR KALCD LOGSYSB HB_CONT_REASON HB_EXPDATE HB_RESDATE ZAPPL_CARD ZZEQTYP ZZEQCODE ZZEQSIZE ZZORDEXP ZZORDREV ZZOFFDUE ZZTOTWT ZZOFFPRICE ZZWAERS1 ZZDMBTR ZZKURSF ZZCPNAME ZZCPPRICE ZZWAERS2 ZZCOST ZZREASON ZZFACTOR ZZDRST ZZDRDT ZZDRRL ZZBGPER1 ZZBGPER2 ZZBGPER3  from VBAK

      ;

      STORE * FROM [VBAK] INTO VBAK.QVD;

        • Re: Problem in fetching Data sap(vbak table) to qlikview
          sasi k

          Is the below part from Qlikview Script?, FieldNames  should be delimited by comma RT?


          SQL Select  MANDT KNUMA VKORG VTWEG SPART VBELN ERNAM ERZET ERDAT AEDAT VBTYP AUART AUFNR KUNNR TELF1 VGBEL KURST BSTNK VKBUR VKGRP BSTDK STWAE STAFO ANGDT BNDDT AUDAT TRVOG AUGRU GWLDT SUBMI LIFSK FAKSK NETWR WAERK GSBER GSKST GUEBG GUEEN KNUMV VDATU VPRGR AUTLF VBKLA VBKLT KALSM VSBED FKARA AWAHR KTEXT BSARK BSTZD IHREZ BNAME MAHZA MAHDT KOSTL KVGR1 KVGR2 KVGR3 KVGR4 KVGR5 KOKRS PS_PSP_PNR KKBER KNKLI GRUPP SBGRP CTLPC CMWAE CMFRE CMNUP CMNGV AMTBL HITYP_PR ABRVW ABDIS OBJNR BUKRS_VF TAXK1 TAXK2 TAXK3 TAXK4 TAXK5 TAXK6 TAXK7 TAXK8 TAXK9 XBLNR ZUONR VGTYP KALSM_CH AGRZR QMNUM VBELN_GRP SCHEME_GRP ABRUF_PART ABHOD ABHOV ABHOB RPLNR VZEIT STCEG_L LANDTX XEGDR ENQUEUE_GRP DAT_FZAU FMBDAT VSNMR_V EQUNR HANDLE ZZAUART ZZSUPTYP ZZOFFERTYP ZZSTATUS ZZINQTYP ZZCHANNEL ZZBSTNK ZZBGTYPE1 ZZBGDATE1 ZZBGNUMBER1 ZZBGOPTION1 ZZBGVALUE1 ZZBGTYPE2 ZZBGDATE2 ZZBGNUMBER2 ZZBGOPTION2 ZZBGVALUE2 ZZBGTYPE3 ZZBGDATE3 ZZBGNUMBER3 ZZBGOPTION3 ZZBGVALUE3 TPLNR CONT_DG STAGE PROLI CRM_GUID PHASE MTLAUR SWENR MULTI SMENR KALCD LOGSYSB HB_CONT_REASON HB_EXPDATE HB_RESDATE ZAPPL_CARD ZZEQTYP ZZEQCODE ZZEQSIZE ZZORDEXP ZZORDREV ZZOFFDUE ZZTOTWT ZZOFFPRICE ZZWAERS1 ZZDMBTR ZZKURSF ZZCPNAME ZZCPPRICE ZZWAERS2 ZZCOST ZZREASON ZZFACTOR ZZDRST ZZDRDT ZZDRRL ZZBGPER1 ZZBGPER2 ZZBGPER3  from VBAK

          • Re: Problem in fetching Data sap(vbak table) to qlikview
            Anil Babu Samineni

            Try like below

             

            [VBAK]:

            Load

               //MANDT & VBELN AS %KEY_VBAK_MANDT_VBELN,

               [MANDT] as [Client_MANDT],

               [KNUMA] as [Agreement_KNUMA],

               [VKORG] as [Sales Org._VKORG],

               [VTWEG] as [Distr. Channel_VTWEG],

               [SPART] as [Division_SPART],

               [ERNAM] as [Created by_ERNAM],

               [ERZET] as [Time_ERZET],

               [ERDAT] as [Created on_ERDAT],

               [AEDAT] as [Changed on_AEDAT],

               [VBTYP] as [Document cat._VBTYP],

               [AUART] as [Sales Doc. Type_AUART],

               [VGBEL] as [Reference doc._VGBEL],

               [KURST] as [Exch. Rate Type_KURST],

               [VBELN] as [Sales Document_VBELN],

               [KUNNR] as [Sold-to party_KUNNR],

               [BSTNK] as [PO Number_BSTNK],

               [VKBUR] as [Sales Office_VKBUR],

               [VKGRP] as [Sales Group_VKGRP],

               [BSTDK] as [PO date_BSTDK],

               [AUFNR] as [Order_AUFNR],

               [STAFO] as [Update group_STAFO],

               [ANGDT] as [Valid from_ANGDT],

               [BNDDT] as [Valid to_BNDDT],

               [AUDAT] as [Document Date_AUDAT],

               [TRVOG] as [Transact.group_TRVOG],

               [AUGRU] as [Order reason_AUGRU],

               [GWLDT] as [Begin guarantee_GWLDT],

               [SUBMI] as [Collective no._SUBMI],

               [LIFSK] as [Delivery block_LIFSK],

               [FAKSK] as [Billing block_FAKSK],

               [NETWR] as [Net value_NETWR],

               [WAERK] as [Doc. Currency_WAERK],

               [GSBER] as [Business Area_GSBER],

               [GSKST] as [Business area_GSKST],

               [GUEBG] as [Valid from_GUEBG],

               [GUEEN] as [Valid to_GUEEN],

               [KNUMV] as [Doc. condition_KNUMV],

               [VDATU] as [Request.dlv.dt_VDATU],

               [VPRGR] as [Prop.date type_VPRGR],

               [AUTLF] as [Complete dlv._AUTLF],

               [VBKLA] as [Original system_VBKLA],

               [VBKLT] as [Indicator_VBKLT],

               [KALSM] as [Pric. procedure_KALSM],

               [VSBED] as [Shipping Cond._VSBED],

               [FKARA] as [Ord-rel.bill.ty_FKARA],

               [AWAHR] as [Probability_AWAHR],

               [KTEXT] as [Description_KTEXT],

               [BSARK] as [Pur. ord. type_BSARK],

               [BSTZD] as [Supplement_BSTZD],

               [IHREZ] as [Your Reference_IHREZ],

               [BNAME] as [Name_BNAME],

               [TELF1] as [Telephone_TELF1],

               [MAHZA] as [No.of contacts_MAHZA],

               [MAHDT] as [Last contact dt_MAHDT],

               [KOSTL] as [Cost Center_KOSTL],

               [STWAE] as [Stats Currency_STWAE],

               [KVGR1] as [Customer grp 1_KVGR1],

               [KVGR2] as [Customer grp 2_KVGR2],

               [KVGR3] as [Customer grp 3_KVGR3],

               [KVGR4] as [Customer grp 4_KVGR4],

               [KVGR5] as [Customer grp 5_KVGR5],

               [KOKRS] as [CO Area_KOKRS],

               [PS_PSP_PNR] as [WBS Element_PS_PSP_PNR],

               [KKBER] as [Cred.contr.area_KKBER],

               [KNKLI] as [Credit account_KNKLI],

               [GRUPP] as [Cust.cred.grp_GRUPP],

               [SBGRP] as [Cred.rep.grp_SBGRP],

               [CTLPC] as [Risk category_CTLPC],

               [CMWAE] as [Currency_CMWAE],

               [CMFRE] as [Release date_CMFRE],

               [CMNUP] as [Next check_CMNUP],

               [CMNGV] as [Next date_CMNGV],

               [AMTBL] as [Credit value_AMTBL],

               [HITYP_PR] as [HierTypePricing_HITYP_PR],

               [ABRVW] as [Usage_ABRVW],

               [ABDIS] as [MRP for DS type_ABDIS],

               [OBJNR] as [Object no. hdr_OBJNR],

               [BUKRS_VF] as [CCodeToBeBilled_BUKRS_VF],

               [TAXK1] as [Alt.tax class._TAXK1],

               [TAXK2] as [TaxClass2-Cust._TAXK2],

               [TAXK3] as [TaxClass3-Cust._TAXK3],

               [TAXK4] as [TaxClass4-Cust._TAXK4],

               [TAXK5] as [TaxClass5-Cust._TAXK5],

               [TAXK6] as [TaxClass6-Cust._TAXK6],

               [TAXK7] as [TaxClass7-Cust._TAXK7],

               [TAXK8] as [TaxClass8-Cust._TAXK8],

               [TAXK9] as [TaxClass9-Cust._TAXK9],

               [XBLNR] as [Reference_XBLNR],

               [ZUONR] as [Assignment_ZUONR],

               [VGTYP] as [Prec.doc.categ._VGTYP],

               [KALSM_CH] as [Search proced._KALSM_CH],

               [AGRZR] as [Accrual period_AGRZR],

               [QMNUM] as [Notification_QMNUM],

               [VBELN_GRP] as [Master contract_VBELN_GRP],

               [SCHEME_GRP] as [Ref.procedure_SCHEME_GRP],

               [ABRUF_PART] as [Check partner_ABRUF_PART],

               [ABHOD] as [Pick up date_ABHOD],

               [ABHOV] as [Pick up time_ABHOV],

               [ABHOB] as [Pick up time_ABHOB],

               [RPLNR] as [Paym.ca.pl.no._RPLNR],

               [VZEIT] as [Req. dely time_VZEIT],

               [STCEG_L] as [Tax dest. cntry_STCEG_L],

               [LANDTX] as [Tax depart. cty_LANDTX],

               [XEGDR] as [EU triang. deal_XEGDR],

               [ENQUEUE_GRP] as [_ENQUEUE_GRP],

               [DAT_FZAU] as [CmlQtyDate_DAT_FZAU],

               [FMBDAT] as [Mat.Avail.Date_FMBDAT],

               [VSNMR_V] as [Version_VSNMR_V],

               [EQUNR] as [Equipment_EQUNR],

               [ZZAUART] as [Sales Doc. Type_ZZAUART],

               [ZZSUPTYP] as [Supply Type_ZZSUPTYP],

               [ZZOFFERTYP] as [Offer Type_ZZOFFERTYP],

               [ZZSTATUS] as [Status_ZZSTATUS],

               [ZZINQTYP] as [Inquiry Type_ZZINQTYP],

               [ZZCHANNEL] as [Channel_ZZCHANNEL],

               [ZZBSTNK] as [PO Number_ZZBSTNK],

               [ZZBGTYPE1] as [_ZZBGTYPE1],

               [ZZBGDATE1] as [_ZZBGDATE1],

               [ZZBGNUMBER1] as [BG Number_ZZBGNUMBER1],

               [ZZBGOPTION1] as [_ZZBGOPTION1],

               [ZZBGTYPE2] as [_ZZBGTYPE2],

               [ZZBGDATE2] as [_ZZBGDATE2],

               [ZZBGNUMBER2] as [BG Number_ZZBGNUMBER2],

               [ZZBGOPTION2] as [_ZZBGOPTION2],

               [ZZBGTYPE3] as [_ZZBGTYPE3],

               [ZZBGDATE3] as [_ZZBGDATE3],

               [ZZBGNUMBER3] as [BG Number_ZZBGNUMBER3],

               [ZZBGOPTION3] as [_ZZBGOPTION3],

               [TPLNR] as [Functional loc._TPLNR],

               [CONT_DG] as [Contains DG_CONT_DG],

               [PROLI] as [DG mgmt profile_PROLI],

               [MTLAUR] as [Target Incom_MTLAUR],

               [PHASE] as [Sal. Phase_PHASE],

               [HANDLE] as [Int.ID_HANDLE],

               [KALCD] as [Proc. Camp.Det._KALCD],

               [LOGSYSB] as [Logical system_LOGSYSB],

               [CRM_GUID] as [Char 70_CRM_GUID],

               [SWENR] as [Bus. entity_SWENR],

               [SMENR] as [Sales Unit_SMENR],

               [STAGE] as [Construction stage_STAGE],

               [HB_CONT_REASON] as [Contingency_HB_CONT_REASON],

               [HB_EXPDATE] as [Expiration date_HB_EXPDATE],

               [HB_RESDATE] as [Resolution date_HB_RESDATE],

               [MULTI] as [Multiple Promotions_MULTI],

               [ZAPPL_CARD] as [_ZAPPL_CARD],

               [ZZEQTYP] as [Equipment Type_ZZEQTYP],

               [ZZEQCODE] as [Equipment Code_ZZEQCODE],

               [ZZEQSIZE] as [Equipment Size_ZZEQSIZE],

               [ZZORDEXP] as [Order Exp By_ZZORDEXP],

               [ZZORDREV] as [Last Rev on_ZZORDREV],

               [ZZOFFDUE] as [Offer Due Date_ZZOFFDUE],

               [ZZTOTWT] as [Total Weight_ZZTOTWT],

               [ZZOFFPRICE] as [Offer Price_ZZOFFPRICE],

               [ZZWAERS1] as [Currency 1_ZZWAERS1],

               [ZZDMBTR] as [Amount in LC_ZZDMBTR],

               [ZZKURSF] as [Exchange rate_ZZKURSF],

               [ZZCPNAME] as [Lost Comp Name_ZZCPNAME],

               [ZZCPPRICE] as [Comp Price_ZZCPPRICE],

               [ZZWAERS2] as [Currency 2_ZZWAERS2],

               [ZZCOST] as [Cost_ZZCOST],

               [ZZREASON] as [Reason Code_ZZREASON],

               [ZZFACTOR] as [Factor_ZZFACTOR],

               [ZZDRST] as [Drawing status_ZZDRST],

               [ZZDRDT] as [Drawing release date_ZZDRDT],

               [ZZDRRL] as [Drawing Released by_ZZDRRL],

               [ZZBGVALUE1] as [BG Value_ZZBGVALUE1],

               [ZZBGPER1] as [_ZZBGPER1],

               [ZZBGVALUE2] as [BG Value_ZZBGVALUE2],

               [ZZBGPER2] as [_ZZBGPER2],

               [ZZBGVALUE3] as [BG Value_ZZBGVALUE3],

               [ZZBGPER3] as [_ZZBGPER3];

             

            SQL Select  MANDT, KNUMA, VKORG, VTWEG, SPART ,VBELN ,ERNAM ,ERZET ,ERDAT ,AEDAT ,VBTYP ,AUART ,AUFNR ,KUNNR ,TELF1 ,VGBEL ,KURST ,BSTNK ,VKBUR, ,VKGRP ,BSTDK ,STWAE ,STAFO ,ANGDT ,BNDDT ,AUDAT ,TRVOG ,AUGRU ,GWLDT ,SUBMI ,LIFSK ,FAKSK ,NETWR ,WAERK ,GSBER ,GSKST ,GUEBG ,GUEEN ,KNUMV ,VDATU ,VPRGR ,AUTLF ,VBKLA ,VBKLT ,KALSM ,VSBED ,FKARA ,AWAHR ,KTEXT ,BSARK ,IHREZ ,BNAME ,MAHZA ,MAHDT ,KOSTL ,KVGR1 ,KVGR2 ,KVGR3 ,KVGR4 ,KVGR5 ,KOKRS ,PS_PSP_PNR ,KKBER ,KNKLI ,GRUPP, SBGRP ,CTLPC ,CMWAE ,CMFRE ,CMNUP ,CMNGV ,AMTBL ,HITYP_PR ,ABRVW ,ABDIS ,OBJNR ,BUKRS_VF ,TAXK1 ,TAXK2, TAXK3 ,TAXK4 ,TAXK5 ,TAXK6 ,TAXK7 ,TAXK8 ,TAXK9 ,XBLNR ,ZUONR ,VGTYP ,KALSM_CH ,AGRZR ,QMNUM ,VBELN_GRP, SCHEME_GRP ,ABRUF_PART ,ABHOD ,ABHOV ,ABHOB ,RPLNR ,VZEIT ,STCEG_L ,LANDTX ,XEGDR ,ENQUEUE_GRP ,DAT_FZAU, FMBDAT ,VSNMR_V ,EQUNR ,HANDLE ,ZZAUART ,ZZSUPTYP ,ZZOFFERTYP ,ZZSTATUS ,ZZINQTYP ,ZZCHANNEL ,ZZBSTNK, ZZBGTYPE1 ,ZZBGDATE1 ,ZZBGNUMBER1 ,ZZBGOPTION1 ,ZZBGVALUE1 ,ZZBGTYPE2 ,ZZBGDATE2 ,ZZBGNUMBER2 ,ZZBGOPTION2, ZZBGVALUE2 ,ZZBGTYPE3 ,ZZBGDATE3 ,ZZBGNUMBER3 ,ZZBGOPTION3 ,ZZBGVALUE3 ,TPLNR ,CONT_DG ,STAGE ,PROLI, CRM_GUID, PHASE ,MTLAUR ,SWENR ,MULTI ,SMENR ,KALCD ,LOGSYSB ,HB_CONT_REASON ,HB_EXPDATE ,HB_RESDATE ,ZAPPL_CARD ,ZZEQTYP ,ZZEQCODE ,ZZEQSIZE ,ZZORDEXP ,ZZORDREV ,ZZOFFDUE ,ZZTOTWT ,ZZOFFPRICE ,ZZWAERS1 ,ZZDMBTR ,ZZKURSF ,ZZCPNAME ,ZZCPPRICE ,ZZWAERS2 ,ZZCOST ,ZZREASON ,ZZFACTOR ,ZZDRST ,ZZDRDT ,ZZDRRL ,ZZBGPER1 ,ZZBGPER2 ,ZZBGPER3  from VBAK

            ;

            STORE * FROM VBAK INTO 'C:/Users/VBAK.qvd (qvd);

            • Re: Problem in fetching Data sap(vbak table) to qlikview
              Nav Pienaar

              Hi Swarnendu

               

              Try to run it with out the ZZ custom fields first and see if it works.

              It might be a specific custom field that is screwing you over ... ??

               

              Nav

               

              SD_VBAK_Sales_Document_Header_Data:

              Load

                [MANDT] as [Client],

                [VKORG] as [Sales Organization],

                [ERDAT] as [Created On],

                [ERNAM] as [Created By],

                [ERZET] as [Time],

                [VBELN] as [Sales Document],

                [VTWEG] as [Distribution Channel],

                [ZUONR] as [Assignment],

                [XBLNR] as [Reference],

                [VBTYP] as [Sd Document Categ],

                [KURST] as [Exchange Rate Type],

                [KNUMA] as [Agreement],

                [AEDAT] as [Changed On],

                [SPART] as [Division],

                [AUART] as [Sales Document Type],

                [VGBEL] as [Reference Document],

                [KUNNR] as [Sold-To Party],

                [BSTDK] as [Purchase Order Date],

                [BSTNK] as [Purchase Order No],

                [VKBUR] as [Sales Office],

                [VKGRP] as [Sales Group],

                [AUFNR] as [Order],

                [STAFO] as [Update Group (Stats)],

                [ABDIS] as [Mrp For Dlvschtype],

                [ABHOB] as [Pick Up Time 2],

                [ABHOD] as [Pick Up Date],

                [ABHOV] as [Pick Up Time 1],

                [ABRUF_PART] as [Check Partner Auth],

                [ABRVW] as [Usage],

                [AGRZR] as [Accrual Period],

                [AMTBL] as [Rel Credit Value],

                [ANGDT] as [Quotation Valid From],

                [AUDAT] as [Document Date],

                [AUGRU] as [Order Reason],

                [AUTLF] as [Complete Delivery],

                [AWAHR] as [Probability],

                [BNAME] as [Name],

                [BNDDT] as [Quotation Valid To],

                [BSARK] as [Purchase Order Type],

                [BSTZD] as [Supplement],

                [BUKRS_VF] as [Ccode To Be Billed],

                [CMFRE] as [Release Date],

                [CMNGV] as [Next Date],

                [CMNUP] as [Next Check],

                [CMWAE] as [Currency],

                [CTLPC] as [Risk Category],

                [DAT_FZAU] as [Cmlqtydate],

                [ENQUEUE_GRP] as [ENQUEUE_GRP],

                [FAKSK] as [Billing Block],

                [FKARA] as [Order-Rel Bill Type],

                [FMBDAT] as [Material Avail Date],

                [GRUPP] as [Cust Cred Group],

                [GUEBG] as [Valid-From Date],

                [GUEEN] as [Valid-To Date],

                [GWLDT] as [Warranty],

                [HITYP_PR] as [Hierarchytypepricing],

                [IHREZ] as [Your Reference],

                [KALSM] as [Pricing Procedure],

                [KALSM_CH] as [Search Procedure],

                [KKBER] as [Credit Control Area],

                [KNKLI] as [Credit Account],

                [KNUMV] as [Doc Condition No],

                [KOKRS] as [Controlling Area],

                [KOSTL] as [Cost Center],

                [KTEXT] as [Description],

                [KVGR1] as [Customer Group 1],

                [KVGR2] as [Customer Group 2],

                [KVGR3] as [Customer Group 3],

                [KVGR4] as [Customer Group 4],

                [KVGR5] as [Customer Group 5],

                [LANDTX] as [Tax Depart Country],

                [LIFSK] as [Delivery Block],

                [MAHDT] as [Last Contact Date],

                [MAHZA] as [Number Of Contacts],

                [NETWR] as [Net Value],

                [OBJNR] as [Object No Header],

                [PS_PSP_PNR] as [Wbs Element],

                [QMNUM] as [Notification],

                [RPLNR] as [Paym Card Plan No],

                [SBGRP] as [Credit Rep Group],

                [SCHEME_GRP] as [Group Ref Procedure],

                [STCEG_L] as [Tax Dest Country],

                [STWAE] as [Statistics Currency],

                [SUBMI] as [Collective Number],

                [TAXK1] as [Alt Tax Classific],

                [TAXK2] as [Taxclass2-Cust],

                [TAXK3] as [Taxclass3-Cust],

                [TAXK4] as [Taxclass4-Cust],

                [TAXK5] as [Taxclass5-Cust],

                [TAXK6] as [Taxclass6-Cust],

                [TAXK7] as [Taxclass7-Cust],

                [TAXK8] as [Taxclass8-Cust],

                [TAXK9] as [Taxclass9-Cust],

                [TELF1] as [Telephone],

                [TRVOG] as [Transaction Group],

                [VBELN_GRP] as [Master Contract],

                [VBKLA] as [Original System],

                [VBKLT] as [Indicator],

                [VDATU] as [Requested Deliv Date],

                [VGTYP] as [Preceding Doc Categ],

                [VPRGR] as [Prop Date Type],

                [VSBED] as [Shipping Conditions],

                [VSNMR_V] as [Version],

                [VZEIT] as [Requested Dely Time],

                [WAERK] as [Document Currency],

                [XEGDR] as [Eu Triangular Deal],

                [SWENR] as [Business Entity],

                [CONT_DG] as [Contains Dg],

                [MSR_ID] as [Process Id No],

                [PROLI] as [Dg Mgmt Profile],

                [TM_CTRL_KEY] as [Control Key],

                [MTLAUR] as [Target Incom],

                [GSBER] as [Business Area 1],

                [PHASE] as [Sales Phase],

                [GSKST] as [Business Area 2],

                [HANDLE] as [Int Id],

                [KALCD] as [Proc Camp Determin],

                [CRM_GUID] as [Char 70],

                [HB_CONT_REASON] as [Contingency Reason],

                [HB_EXPDATE] as [Expiration Date],

                [HB_RESDATE] as [Resolution Date],

                [LOGSYSB] as [Logical System],

                [MULTI] as [Multiple Promotions],

                [PSM_BUDAT] as [Posting Date],

                [SMENR] as [Unit  Number],

                [SPPAYM] as [Payment Method],

                [STAGE] as [Construction Stage],

                [UPD_TMSTMP] as [Time Stamp];

              SQL Select MANDT VKORG ERDAT ERNAM ERZET VBELN KUNNR TELF1 VTWEG VGTYP KTEXT ZUONR XBLNR VBTYP KURST AEDAT KNUMA SPART AUART AUFNR VGBEL BSTDK BSTNK VKBUR VKGRP STAFO STWAE ABDIS ABHOB ABHOD ABHOV ABRUF_PART ABRVW AGRZR AMTBL ANGDT AUDAT AUGRU AUTLF AWAHR BNAME BNDDT BSARK BSTZD BUKRS_VF CMFRE CMNGV CMNUP CMWAE CTLPC DAT_FZAU ENQUEUE_GRP FAKSK FKARA FMBDAT GRUPP GSBER GSKST GUEBG GUEEN GWLDT HITYP_PR IHREZ KALSM KALSM_CH KKBER KNKLI KNUMV KOKRS KOSTL KVGR1 KVGR2 KVGR3 KVGR4 KVGR5 LANDTX LIFSK MAHDT MAHZA NETWR OBJNR PS_PSP_PNR QMNUM RPLNR SBGRP SCHEME_GRP STCEG_L SUBMI TAXK1 TAXK2 TAXK3 TAXK4 TAXK5 TAXK6 TAXK7 TAXK8 TAXK9 TRVOG VBELN_GRP VBKLA VBKLT VDATU VPRGR VSBED VSNMR_V VZEIT WAERK XEGDR SWENR HANDLE CONT_DG SMENR MSR_ID PROLI TM_CTRL_KEY CRM_GUID PHASE MTLAUR MULTI STAGE KALCD HB_CONT_REASON HB_EXPDATE HB_RESDATE LOGSYSB PSM_BUDAT SPPAYM UPD_TMSTMP  from VBAK;