BAPIE1MVKERT SAP (Retail Data Transfer: Sales Data) Structure details

Dictionary Type: Structure
Description: Retail Data Transfer: Sales Data




ABAP Code to SELECT data from BAPIE1MVKERT
Related tables to BAPIE1MVKERT
Access table BAPIE1MVKERT




Structure field list including key, data, relationships and ABAP select examples

BAPIE1MVKERT is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Retail Data Transfer: Sales Data" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_BAPIE1MVKERT TYPE BAPIE1MVKERT.

The BAPIE1MVKERT table consists of various fields, each holding specific information or linking keys about Retail Data Transfer: Sales Data data available in SAP. These include MATERIAL (Material Number), SALES_ORG (Sales Organization), DISTR_CHAN (Distribution Channel), DEL_FLAG (Ind.: Flag material for deletion at distribution chain level).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced


SAP BAPIE1MVKERT structure fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
FUNCTIONFunction MSGFNCHAR3MSGFN
MATERIALMaterial Number MATNRCHAR18MARAMATN1MATNRMATS_MAT1
SALES_ORGSales Organization VKORGCHAR4TVKOVKORGVKOC_VKORG
DISTR_CHANDistribution Channel VTWEGCHAR2TVTWVTWEGVTWC_VTWEG
DEL_FLAGInd.: Flag material for deletion at distribution chain level LVOVKCHAR1XFELD
MATL_STATSMaterial statistics group STGMACHAR1TVSMSTGMA
REBATE_GRPVolume rebate group BONUSCHAR2TVBOBONUS
COMM_GROUPCommission group PROVGCHAR2TVPRPROVG
CASH_DISCCash discount indicator SKTOFCHAR1XFELD
SAL_STATUSDistribution-chain-specific material status VMSTACHAR2TVMSVMSTA
VALID_FROMDate from which distr.-chain-spec. material status is valid VMSTDDATS8DATUM
MIN_ORDERMinimum order quantity in base unit of measure MINAUQUAN13(3) MENG13
MIN_DELYMinimum delivery quantity in delivery note processing MINLFQUAN13(3) MENG13
MIN_MTOMinimum make-to-order quantity MINEFQUAN13(3) MENG13
DELY_UNITDelivery unit SCHRTQUAN13(3) MENG13
DELY_UOMUnit of measure of delivery unit SCHMEUNIT3T006CUNITMEINS
DELY_UOM_ISOUnit of measure for delivery unit in ISO code SCHME_ISOCHAR3T006IISOCD_UNIT
SALES_UNITSales unit VRKMEUNIT3T006CUNITMEINS
SALES_UNIT_ISOSales unit in ISO code VRKME_ISOCHAR3T006IISOCD_UNIT
ITEM_CATItem category group from material master MTPOSCHAR4TPTMMTPOS
DELYG_PLNTDelivering Plant DWERKCHAR4T001WWERKS
PROD_HIERProduct hierarchy PRODH_DCHAR18T179PRODHVPR
PR_REF_MATPricing Reference Material PMATNCHAR18MARAMATN1MATNRMAT
MAT_PR_GRPMaterial Pricing Group KONDMCHAR2T178KONDMVKM
ACCT_ASSGTAccount assignment group for this material KTGRMCHAR2TVKMKTGRM
MATL_GRP_1Material group 1 MVGR1CHAR3TVM1MVGR1
MATL_GRP_2Material group 2 MVGR2CHAR3TVM2MVGR2
MATL_GRP_3Material group 3 MVGR3CHAR3TVM3MVGR3
MATL_GRP_4Material group 4 MVGR4CHAR3TVM4MVGR4
MATL_GRP_5Material group 5 MVGR5CHAR3TVM5MVGR5
ASSORT_LEVAssortment grade SSTUFCHAR2TWSSSSTUF
ASSORTPRIOExternal assortment priority PFLKSCHAR1TWSPPFLKS
LI_PROC_STListing procedure for store or other assortment categories LSTFLCHAR2TWLVLSTFLWLV
LI_PROC_DCListing procedure for distr. center assortment categories LSTVZCHAR2TWLVLSTFL
ASSORTLISTListing functions (assortments) are active LSTAKCHAR1LSTAK
PROD_ATT_1ID for product attribute 1 PRAT1CHAR1PRATA
PROD_ATT_2ID for product attribute 2 PRAT2CHAR1PRATA
PROD_ATT_3ID for product attribute 3 PRAT3CHAR1PRATA
PROD_ATT_4ID for product attribute 4 PRAT4CHAR1PRATA
PROD_ATT_5ID for product attribute 5 PRAT5CHAR1PRATA
PROD_ATT_6ID for product attribute 6 PRAT6CHAR1PRATA
PROD_ATT_7ID for product attribute 7 PRAT7CHAR1PRATA
PROD_ATT_8ID for product attribute 8 PRAT8CHAR1PRATA
PROD_ATT_9ID for product attribute 9 PRAT9CHAR1PRATA
PROD_ATT10ID for product attribute 10 PRATACHAR1PRATA
LIST_ST_FRDate from which listed in the store LDVFLDATS8DATS
LIST_ST_TODate to which listed in the store LDBFLDATS8DATS
LIST_DC_FRDate from which listed in the distribution center LDVZLDATS8DATS
LIST_DC_TODate to which listed in the central warehouse/distr. center LDBZLDATS8DATS
SELL_ST_FRDate from which sold in the store VDVFLDATS8DATS
SELL_ST_TODate to which sold in the store VDBFLDATS8DATS
SELL_DC_FRDate from which sold in the distribution center VDVZLDATS8DATS
SELL_DC_TODate to which sold in the distribution center VDBZLDATS8DATS
MAX_DELYMaximum delivery quantity in store order processing MAXLFQUAN13(3) MENG13
UNIT_GROUPUnit of Measure Group MEGRUCHAR4TWMEGMEGRU
ROUND_PROFRounding Profile RDPRFCHAR4RDPRRDPRF
PRICE_FIXINGIndicator for price fixing PBINDCHAR1PBIND
VAR_SALES_UNVariable Sales Unit Not Allowed VAVMECHAR1XFELD
COMPETITION_CHARCompetition characterization of a material MATKCCHAR1MATKC
MATERIAL_EXTERNALLong Material Number for MATERIAL Field MGV_MATERIAL_EXTERNALCHAR40MATNR_EXT
MATERIAL_GUIDExternal GUID for MATERIAL Field MGV_MATERIAL_GUIDCHAR32MATNR_EGUID
MATERIAL_VERSIONVersion Number for MATERIAL Field MGV_MATERIAL_VERSIONCHAR10MATNWMATNR_VERS
PR_REF_MAT_EXTERNALLong Material Number for PR_REF_MAT Field MGV_PR_REF_MAT_EXTERNALCHAR40MATNR_EXT
PR_REF_MAT_GUIDExternal GUID for PR_REF_MAT Field MGV_PR_REF_MAT_GUIDCHAR32MATNR_EGUID
PR_REF_MAT_VERSIONVersion Number for PR_REF_MAT Field MGV_PR_REF_MAT_VERSIONCHAR10MATNWMATNR_VERS
PRICE_BANDPrice Band Category WRF_PLGTPCHAR2Assigned to domainPLGTP

Key field Non-key field



How do I retrieve data from SAP structure BAPIE1MVKERT using ABAP code?

As BAPIE1MVKERT is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on BAPIE1MVKERT as there is no data to select.

How to access SAP table BAPIE1MVKERT

Within an ECC or HANA version of SAP you can also view further information about BAPIE1MVKERT and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!