Shop Umstellung 2013 SAP
Aus Marburger Medien
(→Die 4 Anwendungsfälle der Schnittstelle) |
(→BOB-SBOToWeb Datenübertragung aus dem Cockpit zum Shop) |
||
Zeile 40: | Zeile 40: | ||
[[BOB-SBOToWeb-Stand-20130725]] | [[BOB-SBOToWeb-Stand-20130725]] | ||
+ | |||
+ | |||
+ | Artikel | ||
+ | |||
+ | <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> | ||
=BOB-XMLToSBO Webshopdateien verarbeiten= | =BOB-XMLToSBO Webshopdateien verarbeiten= |