Quelltext anzeigen
Aus Marburger Medien
für
BOB-SBOToWeb-Artikel-Stand-20130725
Wechseln zu:
Navigation
,
Suche
<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 > '0' and OITM.FrozenFor = 'N' </SQL> <FMT>*XML</FMT> <OVERWRITE>*YES</OVERWRITE> <XMLROOT>shop3_product</XMLROOT> </PARM>
Zurück zur Seite
BOB-SBOToWeb-Artikel-Stand-20130725
.
Ansichten
Seite
Diskussion
Quelltext anzeigen
Versionen/Autoren
Persönliche Werkzeuge
Anmelden
Navigation
Hauptseite
Gemeinschafts-Portal
Aktuelle Ereignisse
Letzte Änderungen
Zufällige Seite
Hilfe
Suche
Werkzeuge
Links auf diese Seite
Änderungen an verlinkten Seiten
Spezialseiten