General Data for Retailers

: DataSource: 0ME_RETAILER_ATTR

The system provides the classifying point of sale data for the retailer in the General Data for Retailers DataSource. The DataSource transfers all the attributes relevant for the POS, as well as the POS opening hours, to SAP BI.

Technical Data

Application Component	Component Name 0IS_ME_MPS-IO
Available as of Release	ERP 2004s
Shipment	BI Content Add-On 7.0.3 SP06
Content Versions	No content versions exist.
RemoteCube-Capable	No
Delta-Capable	No
Extraction from Archives	No
Verifiable	No

Data Modeling

Fields of Origin for the Extract Structure
Fields in the Extract Structure	Description of the Field in the Extract Structure	Table of Origin	Field in the Table of Origin
`EWKUN`	IS-M: Retailers	`JGTEUWV`	`EWKUN`
`ERFUSER`	Created by	`JGTEUWV`	`ERFUSER`
`ERFDATE`	Created On	`JGTEUWV`	`ERFDATE`
`ERFTIME`	Created at	`JGTEUWV`	`ERFTIME`
`AENUSER`	Last changed by	`JGTEUWV`	`AENUSER`
`AENDATE`	Date of last change	`JGTEUWV`	`AENTIME`
`XEUWLOE`	IS-M: Deletion indicator (role-specific)	`JGTEUWV`	`XEUWLOE`
`ANZMIT`	IS-M: Number of employees	`JGTEUWV`	`ANZMIT`
`EVKSTART`	POS category	`JGTEUWV`	`EVKSTART`
`EVKSTBEZ`	POS type	`JGTEUWV`	`EVKSTBEZ`
`SEASON`	Season indicator	`JGTEUWV`	`SEASON`
`CHAINCODE`	Retail chain to which POS belongs	`JGTEUWV`	`CHAINCODE`
`CHAINCHANNEL`	Distribution chain of retail chain to which POS belongs	`JGTEUWV`	`CHAINCHANNEL`
`CHAINID`	POS ID with retail chain	`JGTEUWV`	`CHAINID`
`SHOPINSHOP`	IS-M: Shop in shop indicator	`JGTEUWV`	`SHOPINSHOP`
`SHOPINSHOP_AREA`	POS area key for shop in shop	`JGTEUWV`	`SHOPINSHOP_AREA`
`SHOP_CATEGORY`	Main business category (for shop in shop)	`JGTEUWV`	`SHOP_CATEGORY`
`EVKFLAECHE`	POS area key	`JGTEUWV`	`EVKFLAECHE`
`ISMGEOKATEGORIE`	Geography category (geo. location) for POS	`JGTEUWV`	`ISMGEOKATEGORIE`
`NO_OF_POS`	Number of POS with same address	`JGTEUWV`	`NO_OF_POS`
`NO_OF_SUPPLIERS`	Number of press suppliers for a point of sale	`JGTEUWV`	`NO_OF_SUPPLIERS`
`PRESS_SALESCAT`	Type of press products	`JGTEUWV`	`PRESS_SALESCAT`
`PRESS_SALESVOL`	Weekly press sales volume	`JGTEUWV`	`PRESS_SALESVOL`
`IUMSEINFL`	Internal sales influence for POS (primary)	`JGTEUWV`	`IUMSEINFL`
`IUMSEINFL2`	Internal sales influence for POS (secondary)	`JGTEUWV`	`IUMSEINFL2`
`IUMSEINFL3`	External sales influence for POS (tertiary)	`JGTEUWV`	`IUMSEINFL3`
`EUMSEINFL`	POS: Customer frequency per week	`JGTEUWV`	`EUMSEINFL`
`EUMSEINFL2`	POS: Origin of customer frequency	`JGTEUWV`	`EUMSEINFL2`
`EUMSEINFL3`	Scanner cash desk at point of sale	`JGTEUWV`	`EUMSEINFL3`
`EFREQUENZ`	Sales counter at point of sale	`JGTEUWV`	`EFREQUENZ`
`EFREQUENCE_ORIG`	Service type at point of sale	`JGTEUWV`	`EFREQUENCE_ORIG`
`CASH_SCANNER`	Number of advertising spaces at point of sale	`JGTEUWV`	`CASH_SCANNER`
`SALES_COUNTER`	Planning calendar for point of sale	`JGTEUWV`	`SALES_COUNTER`
`EBEDIENART`	Opening hours ID (default number)	`JGTEUWV`	`EBEDIENART`
`ISMNUMBERPOSTERS`	Opening hours: Monday mornings from	`JGTEUWV`	`ISMNUMBERPOSTERS`
`EWKUN`	Opening hours: Monday mornings to	`JGTEUWV`	`EWKUN`
`ISMPLANCALENDER`	Opening hours: Monday afternoons from	`JGTEUWV`	`ISMPLANCALENDER`
`BUSINESSHOURS_ID`	Opening hours: Monday afternoons to	`JGTEUWV`	`BUSINESSHOURS_ID`
`OPEN_MOR_MO`	Opening hours: Tuesday mornings from	`JGTEUWV`	`OPEN_MOR_MO`
`CLOSE_MOR_MO`	Opening hours: Tuesday mornings to	`JGTEUWV`	`CLOSE_MOR_MO`
`OPEN_AFT_MO`	Opening hours: Tuesday afternoons from	`JGTEUWV`	`OPEN_AFT_MO`
`CLOSE_AFT_MO`	Opening hours: Tuesday afternoons to	`JGTEUWV`	`CLOSE_AFT_MO`
`OPEN_MOR_TU`	Opening hours: Wednesday mornings from	`JGTEUWV`	`OPEN_MOR_TU`
`CLOSE_MOR_TU`	Opening hours: Wednesday mornings to	`JGTEUWV`	`CLOSE_MOR_TU`
`OPEN_AFT_TU`	Opening hours: Wednesday afternoons from	`JGTEUWV`	`OPEN_AFT_TU`
`CLOSE_AFT_TU`	Opening hours: Wednesday afternoons to	`JGTEUWV`	`CLOSE_AFT_TU`
`OPEN_MOR_WE`	Opening hours: Thursday mornings from	`JGTEUWV`	`OPEN_MOR_WE`
`CLOSE_MOR_WE`	Opening hours: Thursday mornings to	`JGTEUWV`	`CLOSE_MOR_WE`
`OPEN_AFT_WE`	Opening hours: Thursday afternoons from	`JGTEUWV`	`OPEN_AFT_WE`
`CLOSE_AFT_WE`	Opening hours: Thursday afternoons to	`JGTEUWV`	`CLOSE_AFT_WE`
`OPEN_MOR_TH`	Opening hours: Friday mornings from	`JGTEUWV`	`OPEN_MOR_TH`
`CLOSE_MOR_TH`	Opening hours: Friday mornings to	`JGTEUWV`	`CLOSE_MOR_TH`
`OPEN_AFT_TH`	Opening hours: Friday afternoons from	`JGTEUWV`	`OPEN_AFT_TH`
`CLOSE_AFT_TH`	Opening hours: Friday afternoons to	`JGTEUWV`	`CLOSE_AFT_TH`
`OPEN_MOR_FR`	Opening hours: Saturday mornings from	`JGTEUWV`	`OPEN_MOR_FR`
`CLOSE_MOR_FR`	Opening hours: Saturday mornings to	`JGTEUWV`	`CLOSE_MOR_FR`
`OPEN_AFT_FR`	Opening hours: Saturday afternoons from	`JGTEUWV`	`OPEN_AFT_FR`
`CLOSE_AFT_FR`	Opening hours: Saturday afternoons to	`JGTEUWV`	`CLOSE_AFT_FR`
`OPEN_MOR_SA`	External sales influence for POS (tertiary)	`JGTEUWV`	`OPEN_MOR_SA`
`CLOSE_MOR_SA`	POS: Customer frequency per week	`JGTEUWV`	`CLOSE_MOR_SA`
`OPEN_AFT_SA`	POS: Origin of customer frequency	`JGTEUWV`	`OPEN_AFT_SA`
`CLOSE_AFT_SA`	Scanner cash desk at point of sale	`JGTEUWV`	`CLOSE_AFT_SA`
`OPEN_MOR_SU`	Opening hours: Sunday mornings from	`JGTEUWV`	`OPEN_MOR_SU`
`CLOSE_MOR_SU`	Opening hours: Sunday mornings to	`JGTEUWV`	`CLOSE_MOR_SU`
`OPEN_AFT_SU`	Opening hours: Sunday afternoons from	`JGTEUWV`	`OPEN_AFT_SU`
`CLOSE_AFT_SU`	Opening hours: Sunday afternoons to	`JGTEUWV`	`CLOSE_AFT_SU`
`OEFFZT`	IS-M: Point of sale opening time (obsolete)	`JGTEUWV`	`OEFFZT`
`SCHLZT`	IS-M: POS closing time (obsolete)	`JGTEUWV`	`SCHLZT`
`OEFFMO`	IS-M: Opening type Monday (obsolete)	`JGTEUWV`	`OEFFMO`
`OEFFDI`	IS-M: Opening type Tuesday (obsolete)	`JGTEUWV`	`OEFFDI`
`OEFFMI`	IS-M: Opening type Wednesday (obsolete)	`JGTEUWV`	`OEFFMI`
`OEFFDO`	IS-M: Opening type Thursday (obsolete)	`JGTEUWV`	`OEFFDO`
`OEFFFR`	IS-M: Opening type Friday (obsolete)	`JGTEUWV`	`OEFFFR`
`OEFFSA`	IS-M: Opening type Saturday (obsolete)	`JGTEUWV`	`OEFFSA`
`OEFFSO`	IS-M: Opening type Sunday (obsolete)	`JGTEUWV`	`OEFFSO`
`XLOTTO`	IS-M: Lottery outlet indicator (obsolete)	`JGTEUWV`	`XLOTTO`
`MBRSYS`	IS-M: AP system	`JGTEUWV`	`MBRSYS`
`BAGNR`	IS-M: BAG collection number	`JGTEUWV`	`BAGNR`
`ISPCNR`	IS-M: ISPC number	`JGTEUWV`	`ISPCNR`
`XISPCTEILN`	IS-M: Indicator: Business partner EDI participant	`JGTEUWV`	`XISPCTEILN`
`ISPCTEILN`	IS-M: EDI participant number	`JGTEUWV`	`ISPCTEILN`
`ISPCART`	IS-M: EDI participant type	`JGTEUWV`	`ISPCART`
`VDZNR`	IS-M: GMP number	`JGTEUWV`	`VDZNR`
`RECALLCALENDER`	Recall calendar	`JGTEUWV`	`RECALLCALENDER`
`RC_ALLOWED_MO`	Recall on Monday allowed	`JGTEUWV`	`RC_ALLOWED_MO`
`RC_ALLOWED_TU`	Recall on Tuesday allowed	`JGTEUWV`	`RC_ALLOWED_TU`
`RC_ALLOWED_WD`	Recall on Wednesday allowed	`JGTEUWV`	`RC_ALLOWED_WD`
`RC_ALLOWED_TH`	Recall on Thursday allowed	`JGTEUWV`	`RC_ALLOWED_TH`
`RC_ALLOWED_FR`	Recall on Friday allowed	`JGTEUWV`	`RC_ALLOWED_FR`
`RC_ALLOWED_SA`	Recall on Saturday allowed	`JGTEUWV`	`RC_ALLOWED_SA`
`RC_ALLOWED_SU`	Recall on Sunday allowed	`JGTEUWV`	`RC_ALLOWED_SU`
`VERKGB`	IS-M: Sales district	`JGTEUWV`	`VERKGB`
`VGEINW`	IS-M: Number of residents in sales district	`JGTEUWV`	`VGEINW`
`XREMRECHT`	IS-M: Right of return	`JGTEUWV`	`XREMRECHT`
`REMART`	Return Type	`JGTEUWV`	`REMART`
`REMWEISE`	Return Method	`JGTEUWV`	`REMWEISE`
`REMSP`	IS-M: Billing lock for return notification	`JGTEUWV`	`REMSP`
`KOMMENT`	IS-M: Comment 50 chars in length	`JGTEUWV`	`KOMMENT`
`RETURNGPNR`	Returning retailer	`JGTEUWV`	`RETURNGPNR`