Functionality This method selects all data in SAP Retail suitable for external spacemanagement programs. You can transfer the following data to the ROP:
- Mater data:
Material number, material short text, unit of measure, EAN, materialtype, material group, material dimensions, sort sequence in shelf, shelfsection, horizontal facing, vertical facing (front), vendor, manufa cturer, generic material, purchase price, and sales price with variousadditional data.
- Movement data:
Stock, sales figures, business volume figures, optimum and maximum shelfquantity and presentation quantity.
- Header data:
Customer, plant, space management profile, purchasing organization,sales organization, distribution channel, layout, layout module, layoutarea, layout module version with additional data, layout module variant,document number of the assigned document, path for the layout document,period for the selection of movement data, key date for pricing orlisting check, reference customer, and date of last optimization. The required import parameters are the layout moduleSiteLayoutModule,> a date for pricing, the selection of themovement data, the listing check and possibly the selection of the validversion for a layout module Pricedate> and a layout moduleversion. Tables Stores> and Storegroups> are used to define for whichplants or plant groupings movement data or prices are to be selected. Table Fix_Asgmt> executes the fixture assignments for the layoutmodule version. Import structure Controls> defines the control data for dataselection. The following control data is available:
- Indicator for whether a listing check is to be carried out
- Indicator for whether a check on the layout module against layout and
plant is to be carried out
- Indicator specifying that the material movement data is to be read from
all plants to which the selected layout module is assigned
- Indicator specifying that no plant has been selected
- Space management profile used to control the data export for the
individual plants
- Mapping variant (the mapping variants are defined in the customer exit
of this method. As a result, they can access different mapping variantsfor each call. Thus one mapping variant can form the average movementdata, and another can aggregate this).
- Layout module variant
- Layout module version
- Indicator specifying that the version is to be determined via the
selection date The method first determines the additional header data for the selectiondata, such as the path of the planogram file belonging to the layoutmodule version. Depending on the control data settings, the system thencarries out various checks. The materials assigned to the layout moduleare selected on the basis of the control data. Finally, the materialmaster data, prices, and movement data for the individual materials areread from various tables. The master data and movement data is writtento table Items>, while the header data is made available forexport in structure Head_Data>. The materials with multiple placements are also flagged. Multipleplacement means that one material is assigned to several layout modulesfor one customer. The number of placements is also specified. thus amaterial can be placed on different shelves of a plant. A good exampleof this is batteries, which are often placed in the toys department, inthe household department, and near the POS. The concept for the assignment of materials to layout module versionsalso allows the multiple placement of a material in one shelf area. Thismeans a material can be placed on the lowest shelf with a facing of 2and also on the top shelf with a facing of 1. It is also necessary to ensure that when a plant is selected, and alayout module variant was assigned to this plant, the materials from thelayout module variant are read in addition to the materials of thelayout module version. A layout module variant maps regional or local specific factors in thematerial makeup of the layout module, i.e. a layout module variantcontains the material difference (delta) to the layout module. Thismeans that both material inclusions (additional materials in the layoutmodule that are placed in this plant and for which this layout modulevariant is assigned) and material exclusions (materials assigned to thelayout module but which are however not placed in this plant) can betaken into consideration in the layout module variant concept. In this context, it should be noted that SAP reads both placements, sothe placements of a material in the layout module version are removed byan exclusion in the corresponding layout module variant. If materialsare included, the materials read from the layout module variant must beadded to the materials from the layout module version. For example, the standard shelf for dairy products may contain SouthernDairy materials. However, a plant in the north want to place local dairyproducts instead of these Southern Dairy products. Thus the layoutmodule version is not changed, but instead, a layout module variant forthe dairy products shelf is assigned to this plant. In this layoutmodule variant, the Southern Dairy products are listed with an exclusionflag, and the additional dairy products are entered without an exclusionflag.Notes Consistency checks are carried out on the layout module, and possiblythe space management profile, and other checks are carried out dependingon the control parameters. INCLUDE BAPI_RET In order to prevent unnecessary data being read and to improveperformance, you can specify whether the prices, quantities, andbusiness volumes/sales are to be read and thus exported. Settings in Customizing for> the spacemanagement profile> Selection period for the movement data, the info structures used withthe relevant fields for stock, sales, and business volume, thedetermination of the function module relevant for export and (optional)the function module used to transfer data to SAP Retail Store. For the creation and maintenance of the selection variants, you usetransaction MCHD> or call the transaction fromCustomizing Maintain Selection Variants> . In addition, you can use the transactionCheck Space Management Profile> to checkwhether the space management profiles are consistent and complete. In the case of multiple placement, please note that the movement data isalways valid for the complete plant and not for an individual layoutmodule. If selection takes place for more than one plant, these fieldsare not filled, because the number of material placements may vary fromplant to plant. In the listing check, the system checks whether each material is listedand/or can be sold. The check period for the listing check thuscomprises the listing period and the sales period. If no space management profile is defined in the control data, theprofile of the reference plant for the layout module is used. The layout check determines whether the specified layout module isassigned to the plant(s), and whether the plants have a layout at all. If the indicator specifying that not plant is to be selected is set,only the material master data, and no movement data, is read. If plants/plant groupings are transferred and the indicator for readingall plants is also set when the method is called, the indicator hashigher priority, that is, the material movement data is read for allplants to which the selected layout module is assigned. If one or more plant groups were selected, these groups are madeavailable for export in table Stores>. If no valid entries were found for the selection of plants in a plantgroup, the system issues an error message. During the selection of prices and movement data for several plants, thestandard system uses the reference store value for the prices, butdetermines an average value for the stocks, sales, and business volumedata. In this case, this header data refers to the layout module'sreference plant. After selection of the data, the method has customer exit, which can beused to format the selected data and select additional data prior to theactual export. The material length in SAP Retail corresponds to the material depth inthe space management program. The document path can be no longer than 140 characters. GLOSSARY:> All the key terms are explained in brief below: Planogram: Graphical representation of a shelf in a space management program. Layout: Spatial arrangement of the goods on sale in a store or department. Alayout consists of layout modules and can be assigned to one or morestores. Layout area: A layout can be subdivided into layout areas, whereby a layout areacorresponds to exactly one layout module within the layout. Layout module: Grouping of materials that are to be presented together in the same areaof the store. A layout module can correspond to one or more salesshelves. Different layout module versions can exist for a layout module.Each of these versions is valid for a particular period. Differentmaterials can be assigned to the versions. Layout module variants areused to map differences to the currently valid version for individualstores. Fixture: A fixture is used to present the goods on the relevant sales area. Thismeans that the fixture holds the goods in order to encourage thecustomer to buy them. The fixture takes up a certain amount of space onthe sales area, so that only a limited number of fixtures can be placedin the sales area. Fixtures are assigned to layout module versions andinclude the following objects: shelf section, wall with hooks, wall withpins, container, round stand, freezer, and so on. Layout module version: Version of a layout module. The layout module version assigns materialsto a layout module for a specific period and thus enables layout modulesto be planned. At least one version exists for every layout module. Onlyone version can be valid at a given point in time. Layout module variant: Layout module variants are used to define slight differences to thecurrently valid version for individual stores. The variant can containextra materials or fewer materials than in the version. The currentlyvalid version is also known as the basic variant. Layout module variantsalways relate to a basic variant, and from a technical point of viewonly contain the delta, that is the differences to this basic variant.Further information For more information, see the SAP Library under Logistics -> SAP Retail. Description This structure contains all the header data relevant for export to thespace management program. INCLUDE BAPI_DATAELEMENT Description INCLUDE BAPI_TABLE Value range If an error occurs, the following messages are returned: Messages for input checks:> Type,, Code,, Number,, Message E,, WB,, 024,, Customer &1 does not exist E,, WB,, 121,, Layout module &1 does not exist E,, WB,, 801,, Data for customer &1 is incomplete E,, WB,, 808,, Layout module &1 is not assigned to customer &2 E,, WB,, 810,, No layout is assigned to customer & E,, WB,, 837,, No reference customer is assigned to layout module &1 E,, WB,, 852,, No valid version exists for layout module &1 E,, WB,, 857,, Do not select all customers and no customerssimultaneously Messages for internal error situations:> Type,, Code,, Number,, Message E,, WB,, 005,, No materials are assigned to the selected layout module E,, WB,, 797,, Field &1, field 2 and field &3 cannot be selectedin &4 E,, WB,, 811,, No data exists for selection variant &1 in infostructure &2 E,, WB,, 813,, No materials are listed or on sale E,, WB,, 819,, Errors occurred during dynamic reading of infostructure &1 E,, WB,, 820,, Space management profile &1 does not exist E,, WB,, 822,, Selection variant &1 for space management does not exist E,, WB,, 823,, No fields in selection variant &1 E,, WB,, 824,, Field &1 is not included as a return value inselection variant &2 E,, WB,, 825,, Field names are not maintained for business volumequantitiy or value E,, WB,, 829,, Field &1 is not included as a selection field inselection variant &2 E,, WB,, 836,, Fields &1 and &2 are not selection fields inselection variant &3 E,, WB,, 838,, No space management profile is assigned to customer &3 E,, WB,, 841,, No valid plants were selected E,, WB,, 873,, Function module &1 does not existDescription This structure contains all the control data needed for selectingmaterial data from SAP Retail for transfer to the space managementprogram. For more information, see the function module documentation. INCLUDE BAPI_DATAELEMENT Description Group of materials for the purposes of assortment management. Thematerials are assigned to the layout module in integrated materialmanagement. TransationMASS> can also be used for the mass assignment ofmaterials to a layout modules. All the materials that can be placed inthe planogram of the external space management program are assigned tothe layout module. INCLUDE BAPI_KEYFIELDValue range The system checks the agreement of the layout module to customer andlayout module to layout and records incorrect entries in the messageLayout module in not assigned to customer>.Description The key date for pricing specifies the date for which the purchasingand sales prices and movement data are determined. It also determines the key date for the listing check. In the listingcheck, the system checks whether the specified date falls in thelisting period and/or sales period for a material. This date is alsoused to select the layout module version. Value range The entry of invalid data is recorded in the message Enter date inthe format __.__.____ >.Default The default value is the system date. Description This structure is used for the additional selection and export ofheader and item data.
- In order to make additional header data available for the export, you
must create your additional fields in structureBAPI_TE_HEAD_DATA> and fill this stable accordingly withreference to the structure. The required parameter of the structure isthe layout module.
- In order to make additional item data available for the export, you must
create your additional fields in structure BAPI_TE_ITEMS>and fill this table accordingly with reference to the structure. Therequired parameters of the structure are the material and unit ofmeasure. This table suplies data to the customer exit of the method. INCLUDE BAPI_DATAELEMENTDescription Assignments of fixture to layout module version Description Table that contains all the materials assigned to the layout module. A lot of master data and movement data is transferred for each material.Required parameters are the material number, dimensions, unit of measureand EAN. INCLUDE BAPI_DATAELEMENT Description This table contains all plants for which movement data is to beselected from SAP Retail. INCLUDE BAPI_DATAELEMENT Notes If one or more plant groups were selected for the reading of materialmovement data, the plants of all groups are provided in this tableas information for the external space management program. Description This table contains all plant groups for which movement data can beselected from SAP Retail. INCLUDE BAPI_DATAELEMENT
|