topic Re: SAP DATA MODEL in QlikView https://community.qlik.com/t5/QlikView/SAP-DATA-MODEL/m-p/801209#M1034519 <HTML><HEAD></HEAD><BODY><P>It is done like this:</P><P></P><UL><LI>Read every record from MBEW.</LI><LI>Read every record from MBEWH and add them to the same table. Sort them on Product and on Date. To every record of the same product except for the first, add a FROM-DATE that is equal to the Date of the previous record.</LI><LI>Set the FROM-DATE of the first record to a date before SAP was installed or something.</LI><LI>Use INTERVALMATCH() to map your calendar to the stock values. </LI></UL><P></P><P>Note that MBEW contains stock valuations only. The actual stock situations are stored in MARD-MSKU-MSLB.</P><P></P><P>Peter</P></BODY></HTML> Fri, 16 Jan 2015 08:22:24 GMT Peter_Cammaert 2015-01-16T08:22:24Z SAP DATA MODEL https://community.qlik.com/t5/QlikView/SAP-DATA-MODEL/m-p/801208#M1034518 <HTML><HEAD></HEAD><BODY><P>Hi </P><P></P><P>kindly suggest on the below issues </P><P></P><P>I am using MSEG table to calculate the closing stock and opening stock where in for the same i need to fetch the data way back from 2007 so an alternative for the same the i am trying to use MBEW and MBEWH..</P><P></P><P>Please suggest the plant of executing the same </P><P></P><P>Thanking You</P><P>Vinayagam</P></BODY></HTML> Fri, 16 Jan 2015 07:31:45 GMT https://community.qlik.com/t5/QlikView/SAP-DATA-MODEL/m-p/801208#M1034518 Anonymous 2015-01-16T07:31:45Z Re: SAP DATA MODEL https://community.qlik.com/t5/QlikView/SAP-DATA-MODEL/m-p/801209#M1034519 <HTML><HEAD></HEAD><BODY><P>It is done like this:</P><P></P><UL><LI>Read every record from MBEW.</LI><LI>Read every record from MBEWH and add them to the same table. Sort them on Product and on Date. To every record of the same product except for the first, add a FROM-DATE that is equal to the Date of the previous record.</LI><LI>Set the FROM-DATE of the first record to a date before SAP was installed or something.</LI><LI>Use INTERVALMATCH() to map your calendar to the stock values. </LI></UL><P></P><P>Note that MBEW contains stock valuations only. The actual stock situations are stored in MARD-MSKU-MSLB.</P><P></P><P>Peter</P></BODY></HTML> Fri, 16 Jan 2015 08:22:24 GMT https://community.qlik.com/t5/QlikView/SAP-DATA-MODEL/m-p/801209#M1034519 Peter_Cammaert 2015-01-16T08:22:24Z