Ansicht
Dokumentation

BAPI_SITELAYMOD_GETITEMS3 - Layout Module: Read Material Data

BAPI_SITELAYMOD_GETITEMS3 - Layout Module: Read Material Data

Fill RESBD Structure from EBP Component Structure   Fill RESBD Structure from EBP Component Structure  
This documentation is copyright by SAP AG.
SAP E-Book

Functionality

This method selects all data in SAP Retail suitable for external space management programs.

You can transfer the following data to the ROP:

  • Mater data:
    Material number, material short text, unit of measure, EAN, material type, material group, material dimensions, sort sequence in shelf, shelf section, horizontal facing, vertical facing (front), vendor, manufacturer, generic material, purchase price, and sales price with various additional data.
  • Movement data:
    Stock, sales figures, business volume figures, optimum and maximum shelf quantity and presentation quantity.
  • Header data:
    Customer, plant, space management profile, purchasing organization, sales organization, distribution channel, layout, layout module, layout area, 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 or listing check, reference customer, and date of last optimization.

The required import parameters are the layout module SiteLayoutModule, a date for pricing, the selection of the movement data, the listing check and possibly the selection of the valid version for a layout module Pricedate and a layout module version.

Tables Stores and Storegroups are used to define for which plants or plant groupings movement data or prices are to be selected.

Table Fix_Asgmt executes the fixture assignments for the layout module version.
Import structure Controls defines the control data for data selection.

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 variants for each call. Thus one mapping variant can form the average movement data, 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 selection data, such as the path of the planogram file belonging to the layout module version. Depending on the control data settings, the system then carries out various checks. The materials assigned to the layout module are selected on the basis of the control data. Finally, the material master data, prices, and movement data for the individual materials are read from various tables. The master data and movement data is written to table Items, while the header data is made available for export in structure Head_Data.

The materials with multiple placements are also flagged. Multiple placement means that one material is assigned to several layout modules for one customer. The number of placements is also specified. thus a material can be placed on different shelves of a plant. A good example of this is batteries, which are often placed in the toys department, in the household department, and near the POS.

The concept for the assignment of materials to layout module versions also allows the multiple placement of a material in one shelf area. This means a material can be placed on the lowest shelf with a facing of 2 and also on the top shelf with a facing of 1.

It is also necessary to ensure that when a plant is selected, and a layout module variant was assigned to this plant, the materials from the layout module variant are read in addition to the materials of the layout module version.

A layout module variant maps regional or local specific factors in the material makeup of the layout module, i.e. a layout module variant contains the material difference (delta) to the layout module. This means that both material inclusions (additional materials in the layout module that are placed in this plant and for which this layout module variant is assigned) and material exclusions (materials assigned to the layout module but which are however not placed in this plant) can be taken into consideration in the layout module variant concept.

In this context, it should be noted that SAP reads both placements, so the placements of a material in the layout module version are removed by an exclusion in the corresponding layout module variant. If materials are included, the materials read from the layout module variant must be added to the materials from the layout module version.

For example, the standard shelf for dairy products may contain Southern Dairy materials. However, a plant in the north want to place local dairy products instead of these Southern Dairy products. Thus the layout module version is not changed, but instead, a layout module variant for the dairy products shelf is assigned to this plant. In this layout module variant, the Southern Dairy products are listed with an exclusion flag, and the additional dairy products are entered without an exclusion flag.

Notes

Consistency checks are carried out on the layout module, and possibly the space management profile, and other checks are carried out depending on the control parameters.

Messages are returned in the Return parameter. The parameter documentation shows the return codes and their meanings.

In order to prevent unnecessary data being read and to improve performance, you can specify whether the prices, quantities, and business volumes/sales are to be read and thus exported.

Settings in Customizing for the space management profile

Selection period for the movement data, the info structures used with the relevant fields for stock, sales, and business volume, the determination 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, call the transaction from Customizing Maintain Selection Variants .

In addition, you can use the transaction Check Space Management Profile to check whether the space management profiles are consistent and complete.

In the case of multiple placement, please note that the movement data is always valid for the complete plant and not for an individual layout module. If selection takes place for more than one plant, these fields are not filled, because the number of material placements may vary from plant to plant.

In the listing check, the system checks whether each material is listed and/or can be sold. The check period for the listing check thus comprises the listing period and the sales period.

If no space management profile is defined in the control data, the profile of the reference plant for the layout module is used.

The layout check determines whether the specified layout module is assigned 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 reading all plants is also set when the method is called, the indicator has higher priority, that is, the material movement data is read for all plants to which the selected layout module is assigned.

If one or more plant groups were selected, these groups are made available for export in table Stores.

If no valid entries were found for the selection of plants in a plant group, the system issues an error message.

During the selection of prices and movement data for several plants, the standard system uses the reference store value for the prices, but determines an average value for the stocks, sales, and business volume data. In this case, this header data refers to the layout module's reference plant.

After selection of the data, the method has customer exit, which can be used to format the selected data and select additional data prior to the actual export.

The material length in SAP Retail corresponds to the material depth in the 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. A layout consists of layout modules and can be assigned to one or more stores.

Layout area:
A layout can be subdivided into layout areas, whereby a layout area corresponds to exactly one layout module within the layout.

Layout module:
Grouping of materials that are to be presented together in the same area of the store. A layout module can correspond to one or more sales shelves. Different layout module versions can exist for a layout module. Each of these versions is valid for a particular period. Different materials can be assigned to the versions. Layout module variants are used to map differences to the currently valid version for individual stores.

Fixture:
A fixture is used to present the goods on the relevant sales area. This means that the fixture holds the goods in order to encourage the customer to buy them. The fixture takes up a certain amount of space on the sales area, so that only a limited number of fixtures can be placed in the sales area. Fixtures are assigned to layout module versions and include the following objects: shelf section, wall with hooks, wall with pins, container, round stand, freezer, and so on.

Layout module version:
Version of a layout module. The layout module version assigns materials to a layout module for a specific period and thus enables layout modules to be planned. At least one version exists for every layout module. Only one version can be valid at a given point in time.

Layout module variant:
Layout module variants are used to define slight differences to the currently valid version for individual stores. The variant can contain extra materials or fewer materials than in the version. The currently valid version is also known as the basic variant. Layout module variants always relate to a basic variant, and from a technical point of view only contain the delta, that is the differences to this basic variant.

Further information

For more information, see the SAP Library under Logistics -> SAP Retail.





Parameters

CONTROLS
EXTENSIONOUT
FIX_ASGMT
HEAD_DATA
ITEMS
LAYOUTMODULE
PRICEDATE
RETURN
STORES
STORE_CLASSES

Exceptions

Function Group

WRF_WPLG

General Material Data   TXBHW - Original Tax Base Amount in Local Currency  
This documentation is copyright by SAP AG.

Length: 13048 Date: 20240523 Time: 173027     sap01-206 ( 239 ms )