Quelltext anzeigen

  <PARM>
    <PATH>\\192.168.5.8\SAP\Datentransfer\ShopAbo-Transfer\WebOut\product</PATH>     
    <GROUP>VOLL</GROUP>
    <ACTIVE>*YES</ACTIVE>
    <FILENRKOBJ></FILENRKOBJ>
    <FILE>01_{DATE}_{JobTime}_shop3_product.xml</FILE>
    <SQL>         
       select
          OITM.ItemCode 	AS 'sku',
	   OITM.SuppCatNum 	AS 'id',
          OITM.ItemName 	AS 'name',
          OITM.U_Internet	AS 'itemtype',
	   -- OITM.PicturName	AS 'image',
	   OITM.SWeight1 	AS 'weight',
	   OITM.SHeight1 	AS 'hight',
	   OITM.SWidth1  	AS 'width',
	   OITM.SLength1 	AS 'length',
	   ITM1.Price  	AS 'price',
         OITM.VatGourpSa	AS 'taxcode',
	   OITM.ValidFrom	AS 'vdate',
	   OITM.UpdateDate	AS 'mdate',
	   -- OITM.QryGroup11	AS 'abo_std',
	   -- OITM.QryGroup12 	AS 'abo_present',
	   -- OITM.QryGroup13	AS 'rechnungsShop',
	   -- OITM.QryGroup14 	AS 'freundesShop',
	   OITM.QryGroup15	AS 'limitedItem',
	   -- OITM.QryGroup16 	AS 'activeItem',
	   isnull(OITM.U_BOB_KurzBesch,'') AS 'sdesc',
	   -- isnull(OITM.U_BOB_Shop_Hinweis,'') AS 'info',
	   [@SHOP_WARENGRUP].Name	AS 'category_id_1',
	   [@SHOP_UNTERGRUP].Name	AS 'category_id_2',
         OITM.U_SMM_Sh_Verfueg AS 'product_availibility_flag'
       from OITM, ITM1, [@SHOP_WARENGRUP], [@SHOP_UNTERGRUP]
       where 	OITM.ItemCode = ITM1.ItemCode AND 
              OITM.U_Warengrup = [@SHOP_WARENGRUP].code AND
		OITM.U_Untergrup = [@SHOP_UNTERGRUP].code AND
		ITM1.Pricelist = '1' AND 
              OITM.U_Internet &gt; '0' and
              OITM.FrozenFor = 'N'
    </SQL>
    <FMT>*XML</FMT>
    <OVERWRITE>*YES</OVERWRITE>
    <XMLROOT>shop3_product</XMLROOT>
  </PARM>