I have recently connected to our SAP system and am using the BexConnector for one of the first times, the issue I am running into is that when I am trying to pull from a query it is trying to pull to much data and it errors out.
Is there a way in the loading script below that I could preset a filter to a "Where AS" the calendar/monthyear is set to a specific timeframe?
Any insight or help on this would be greatly appreciated.
Thank you,
Matt
LIB CONNECT TO 'SapBEx_SAPP92ASXXXXX;
[P_VKASLNM02_Q0001]: LOAD [MATNR_APP] as [Product], [ZAP_SHT] as [Customer (Ship-to)], [ZAP_WSP1] as [WH Ship-to], [ZASL_DINF] as [Direct/Indirect], [ZCR_CNTRT] as [Contract GPO], [0CALMONTH] as [Calendar Year/Month], [6H8F1RDH7OGDTT3576KZI36QP] as [Contract Sales], [70EYDR0TK44F4CQ743YP2ZZ6P] as [Unit Sales], [CURRENCY005] as [CURRENCY005 Contract Sales], [UNIT005] as [UNIT005 Contract Sales], [CURRENCY014] as [CURRENCY014 Unit Sales], [UNIT014] as [UNIT014 Unit Sales], [MATNR_APP__TEXT] as [Product TEXT], [ZAP_SHT__TEXT] as [Customer (Ship-to) TEXT], [ZAP_WSP1__TEXT] as [WH Ship-to TEXT], [ZASL_DINF__TEXT] as [Direct/Indirect TEXT], [ZCR_CNTRT__TEXT] as [Contract GPO TEXT], [0CALMONTH__TEXT] as [Calendar Year/Month TEXT];