2 Replies Latest reply: May 22, 2015 6:56 AM by Lucky Hendriksen RSS

    Used tables to create KSB1

    micro win

      Hello,

       

      I'm trying to find the tables that are used to create the transaction KSB1, but I can't get all the data.

       

      Do you know what tables should I use in order to get the cost centers and other information from KSB1?

       

      Thanks.

        • Re: Used tables to create KSB1
          Friedrich Hofmann

          Hi,

           

          I guess you're talking about SAP?

          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.

          Anyway, there's the DataDictionary - the tables with DD - where you can look up meta_infos about all the tables available in SAP.

          HTH

          • Re: Used tables to create KSB1

            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).

             

            Other users might have better ideas.