Shopping cart for TYPO3

I want to add more information from my db to be displayed in the shopping cart.

I have a table 'tx_hebest_artikel' containing the basic rticle data and a related table 'tx_hebest_hersteller' that contains producers of articles.

Here is my typoscript to get the things available in the corresponding template:

plugin.tx_wtcart_pi1.settings {
  fields {
# change the garbe-icon
    delete.file = EXT:he_best/res/garbage.gif

# get the article number
# the first field exists in the main database table: 'tx_hebest_artikel.artikelnummer'
    artikelnummer = CONTENT
    artikelnummer {
# My database table
      table = tx_hebest_artikel

      select {
# You have to define the pid of the sysfolder containing the article data here or 
# as I did in the example define them as typoscript constant
        pidInList = {$plugin.he_best.daten.warenkorb}

        andWhere {
# get the uid of the current article, taken from session data
          data = field:puid
          wrap = uid=|
        }
      }
# select the value of database field 'artikelnummer' for display
      renderObj = COA
      renderObj {
        10 = TEXT
        10.field = artikelnummer
        10.wrap = |
      }
    }

# get the producer title
# the second field exists in table 'tx_hebest_hersteller' and is related to 'tx_hebest_artikel' by join
# the sql select would be:
#   SELECT tx_hebest_hersteller.title FROM tx_hebest_hersteller JOIN tx_hebest_artikel ON tx_hebest_artikel.hersteller=tx_hebest_hersteller.uid
#   WHERE tx_hebest_artikel.uid = puid

    hersteller = CONTENT
    hersteller {
      table = tx_hebest_hersteller
      select {
        pidInList = {$plugin.he_best.daten.warenkorb}
        selectFields = tx_hebest_hersteller.title
        join = tx_hebest_artikel ON (tx_hebest_artikel.hersteller=tx_hebest_hersteller.uid)
        andWhere {
          data = field:puid
          wrap = tx_hebest_artikel.uid=|
        }
      }
      renderObj = COA
      renderObj {
        10 = TEXT
        10.field = title
        10.wrap = |
      }
    }
  }
}

# To apply these settings to the powermailCart when you insert ###POWERMAIL_TYPOSCRIPT_CART### you have to copy 'settings.fields' to 'settings.powermailCart.fields''

plugin.tx_wtcart_pi1.settings.powermailCart {
  fields < plugin.tx_wtcart_pi1.settings.fields
}

You can use these fields inside the template by writing them marcers uppercase letters:
###ARTIKELNUMMER###
and
###HERSTELLER###

Hope this helps somebody else,
greetings from Esslingen,
Manfred