topic Re: Used tables to create KSB1 in QlikView https://community.qlik.com/t5/QlikView/Used-tables-to-create-KSB1/m-p/906018#M657096 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I guess you're talking about SAP?</P><P>It's been a while since I have worked with SAP, but I think all tables with cost center information start with 'KS' or 'KST', not sure.</P><P>Anyway, there's the DataDictionary - the tables with DD - where you can look up meta_infos about all the tables available in SAP.</P><P>HTH</P></BODY></HTML> Thu, 21 May 2015 13:39:08 GMT datanibbler 2015-05-21T13:39:08Z Used tables to create KSB1 https://community.qlik.com/t5/QlikView/Used-tables-to-create-KSB1/m-p/906017#M657095 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I'm trying to find the tables that are used to create the transaction KSB1, but I can't get all the data.</P><P></P><P>Do you know what tables should I use in order to get the cost centers and other information from KSB1?</P><P></P><P>Thanks.</P></BODY></HTML> Thu, 21 May 2015 13:35:55 GMT https://community.qlik.com/t5/QlikView/Used-tables-to-create-KSB1/m-p/906017#M657095 microwin88x 2015-05-21T13:35:55Z Re: Used tables to create KSB1 https://community.qlik.com/t5/QlikView/Used-tables-to-create-KSB1/m-p/906018#M657096 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I guess you're talking about SAP?</P><P>It's been a while since I have worked with SAP, but I think all tables with cost center information start with 'KS' or 'KST', not sure.</P><P>Anyway, there's the DataDictionary - the tables with DD - where you can look up meta_infos about all the tables available in SAP.</P><P>HTH</P></BODY></HTML> Thu, 21 May 2015 13:39:08 GMT https://community.qlik.com/t5/QlikView/Used-tables-to-create-KSB1/m-p/906018#M657096 datanibbler 2015-05-21T13:39:08Z Re: Used tables to create KSB1 https://community.qlik.com/t5/QlikView/Used-tables-to-create-KSB1/m-p/906019#M657097 <HTML><HEAD></HEAD><BODY><P>Seems complicated due to relations with vendors and headers in this view. You might also need BKPF (G/L document header) or BSEG (G/L document details). And in addition to that BSIK (Open vendor items) and BSAK (Cleared vendor items).</P><P></P><P>Other users might have better ideas.</P></BODY></HTML> Fri, 22 May 2015 10:56:42 GMT https://community.qlik.com/t5/QlikView/Used-tables-to-create-KSB1/m-p/906019#M657097 2015-05-22T10:56:42Z