SAP MCWDATAW table - Objects for shopping basket analysis (without time base) details in SAP


SAP MCWDATAW table summary

Object Name: MCWDATAW
Dictionary Type: Structure
Description: Objects for shopping basket analysis (without time base)


Field list for MCWDATAW table on an S/4 SAP system

Details
MCWDATAW-WAERK table field - SD Document Currency

Description: SD Document Currency
Field Name: WAERK
Data Element: WAERK
Data Type: CUKY
length (Dec): 5(0)
Check table: *
Conversion Routine:
Domain Name: WAERS
MemoryID: FWS
AppClass: FB
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field WAERK

MCWDATAW-MEINS table field - Base Unit of Measure

Description: Base Unit of Measure
Field Name: MEINS
Data Element: MEINS
Data Type: UNIT
length (Dec): 3(0)
Check table: *
Conversion Routine: CUNIT
Domain Name: MEINS
MemoryID:
AppClass: MG
SHLP:
SHLP Field:
ConvExit: CUNIT

See all SAP tables containing field MEINS

MCWDATAW-VRKME table field - Sales unit

Description: Sales unit
Field Name: VRKME
Data Element: VRKME
Data Type: UNIT
length (Dec): 3(0)
Check table: *
Conversion Routine: CUNIT
Domain Name: MEINS
MemoryID:
AppClass: MG
SHLP:
SHLP Field:
ConvExit: CUNIT

See all SAP tables containing field VRKME

MCWDATAW-BONNR table field - Transaction number (till receipt)

Description: Transaction number (till receipt)
Field Name: BONNR
Data Element: W_BONNR
Data Type: NUMC
length (Dec): 15(0)
Check table:
Conversion Routine:
Domain Name: W_BONNR
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field BONNR

MCWDATAW-WERKS table field - Plant

Description: Plant
Field Name: WERKS
Data Element: WERKS_D
Data Type: CHAR
length (Dec): 4(0)
Check table: *
Conversion Routine:
Domain Name: WERKS
MemoryID: WRK
AppClass: MG
SHLP: H_T001W_C
SHLP Field: WERKS
ConvExit:

See all SAP tables containing field WERKS

MCWDATAW-MATNR table field - Material Number

Description: Material Number
Field Name: MATNR
Data Element: MATNR
Data Type: CHAR
length (Dec): 40(0)
Check table: *
Conversion Routine: MATN1
Domain Name: MATNR
MemoryID: MAT
AppClass: MG
SHLP: S_MAT1
SHLP Field: MATNR
ConvExit: MATN1

See all SAP tables containing field MATNR

MCWDATAW-MATKL table field - Material Group

Description: Material Group
Field Name: MATKL
Data Element: MATKL
Data Type: CHAR
length (Dec): 9(0)
Check table: *
Conversion Routine:
Domain Name: MATKL
MemoryID: MKL
AppClass: MG
SHLP: S_WBWG
SHLP Field: MATKL
ConvExit:

See all SAP tables containing field MATKL

MCWDATAW-AKTNR table field - Promotion

Description: Promotion
Field Name: AKTNR
Data Element: WAKTION
Data Type: CHAR
length (Dec): 10(0)
Check table: *
Conversion Routine: ALPHA
Domain Name: WAKTION
MemoryID: WAK
AppClass:
SHLP:
SHLP Field:
ConvExit: ALPHA

See all SAP tables containing field AKTNR

MCWDATAW-AFLAG table field - Promotion indicator

Description: Promotion indicator
Field Name: AFLAG
Data Element: MCW_AFLAG
Data Type: NUMC
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: MCW_AFLAG
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field AFLAG

MCWDATAW-EAN11 table field - International Article Number (EAN/UPC)

Description: International Article Number (EAN/UPC)
Field Name: EAN11
Data Element: EAN11
Data Type: CHAR
length (Dec): 18(0)
Check table:
Conversion Routine: EAN11
Domain Name: EAN11
MemoryID: EAN
AppClass: MGW
SHLP:
SHLP Field:
ConvExit: EAN11

See all SAP tables containing field EAN11

MCWDATAW-PLGTP table field - Price Band Category

Description: Price Band Category
Field Name: PLGTP
Data Element: PLGTP
Data Type: CHAR
length (Dec): 2(0)
Check table: *
Conversion Routine:
Domain Name: PLGTP
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PLGTP

MCWDATAW-ATTYP table field - Material Category

Description: Material Category
Field Name: ATTYP
Data Element: ATTYP
Data Type: CHAR
length (Dec): 2(0)
Check table:
Conversion Routine:
Domain Name: ATTYP
MemoryID: MTY
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ATTYP

MCWDATAW-MAKTX table field - Material Description

Description: Material Description
Field Name: MAKTX
Data Element: MAKTX
Data Type: CHAR
length (Dec): 40(0)
Check table:
Conversion Routine:
Domain Name: TEXT40
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field MAKTX

MCWDATAW-AKTYP table field - Promotion Category

Description: Promotion Category
Field Name: AKTYP
Data Element: W_AKTYP
Data Type: CHAR
length (Dec): 4(0)
Check table: *
Conversion Routine:
Domain Name: AKTTY
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field AKTYP

MCWDATAW-AKTHE table field - Promotion theme

Description: Promotion theme
Field Name: AKTHE
Data Element: W_AKTHE
Data Type: CHAR
length (Dec): 4(0)
Check table: *
Conversion Routine:
Domain Name: THEMA
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field AKTHE

MCWDATAW-WMINR table field - Product catalog number

Description: Product catalog number
Field Name: WMINR
Data Element: WMINR
Data Type: CHAR
length (Dec): 10(0)
Check table: *
Conversion Routine:
Domain Name: WMINR
MemoryID: WMI
AppClass:
SHLP: WPC1
SHLP Field: WMINR
ConvExit:

See all SAP tables containing field WMINR

MCWDATAW-KUNNR table field - Customer number

Description: Customer number
Field Name: KUNNR
Data Element: KUND1
Data Type: CHAR
length (Dec): 10(0)
Check table: *
Conversion Routine: ALPHA
Domain Name: KUNNR
MemoryID:
AppClass: V
SHLP:
SHLP Field:
ConvExit: ALPHA

See all SAP tables containing field KUNNR

MCWDATAW-CCNUM table field - Payment cards: Card number

Description: Payment cards: Card number
Field Name: CCNUM
Data Element: CCNUM
Data Type: CHAR
length (Dec): 25(0)
Check table: *
Conversion Routine:
Domain Name: CCNUM
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CCNUM

MCWDATAW-CCINS table field - Payment cards: Card type

Description: Payment cards: Card type
Field Name: CCINS
Data Element: CCINS
Data Type: CHAR
length (Dec): 4(0)
Check table: *
Conversion Routine:
Domain Name: CCINS
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CCINS

MCWDATAW-ZMTTL table field - Payment method as condition

Description: Payment method as condition
Field Name: ZMTTL
Data Element: W_ZAHLART
Data Type: CHAR
length (Dec): 4(0)
Check table: *
Conversion Routine:
Domain Name: KSCHL
MemoryID:
AppClass: VF
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ZMTTL

MCWDATAW-KUNDK table field - Customer ID

Description: Customer ID
Field Name: KUNDK
Data Element: W_KUNDK
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: W_KUNDK
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field KUNDK

MCWDATAW-VKMNG table field - Transaction sales - quantity in sales unit

Description: Transaction sales - quantity in sales unit
Field Name: VKMNG
Data Element: W_VKMNG
Data Type: QUAN
length (Dec): 15(3)
Check table:
Conversion Routine:
Domain Name: MENGV15_3
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field VKMNG

MCWDATAW-UMSMNG table field - Transaction sales - quantity in base unit of measure

Description: Transaction sales - quantity in base unit of measure
Field Name: UMSMNG
Data Element: W_UMSMNG
Data Type: QUAN
length (Dec): 15(3)
Check table:
Conversion Routine:
Domain Name: MENGV15_3
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field UMSMNG

MCWDATAW-UMSATZ table field - Sales POS

Description: Sales POS
Field Name: UMSATZ
Data Element: MCW_UMSATZ
Data Type: CURR
length (Dec): 19(2)
Check table:
Conversion Routine:
Domain Name: WERTV10
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field UMSATZ

MCWDATAW-PRSNLS table field - Price reduction from sales as per receipts/aggregated sales

Description: Price reduction from sales as per receipts/aggregated sales
Field Name: PRSNLS
Data Element: W_PRSNLS
Data Type: CURR
length (Dec): 19(2)
Check table:
Conversion Routine:
Domain Name: WERTV10
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PRSNLS

MCWDATAW-ANZBON table field - Number of transactions (till receipts)

Description: Number of transactions (till receipts)
Field Name: ANZBON
Data Element: MCW_ANZBON
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: MCZAEHLINT
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ANZBON

MCWDATAW-ANZPOS table field - Number of transaction items (till receipts)

Description: Number of transaction items (till receipts)
Field Name: ANZPOS
Data Element: MCW_ANZPOS
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: MCZAEHLINT
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ANZPOS

MCWDATAW-DUPRSP table field - Average Cash register/POS price reduction

Description: Average Cash register/POS price reduction
Field Name: DUPRSP
Data Element: MCW_DUPRSP
Data Type: DEC
length (Dec): 6(2)
Check table:
Conversion Routine:
Domain Name: PRZ32V
MemoryID:
AppClass: KS
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DUPRSP

MCWDATAW-DUPRVE table field - Average price based on sales unit

Description: Average price based on sales unit
Field Name: DUPRVE
Data Element: MCW_DUPRVE
Data Type: CURR
length (Dec): 19(2)
Check table:
Conversion Routine:
Domain Name: WERTV10
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DUPRVE

MCWDATAW-DUPRBE table field - Average price based on base unit of measure

Description: Average price based on base unit of measure
Field Name: DUPRBE
Data Element: MCW_DUPRBE
Data Type: CURR
length (Dec): 19(2)
Check table:
Conversion Routine:
Domain Name: WERTV10
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DUPRBE

MCWDATAW-ANZWGR table field - Number of material groups in transaction (till receipt)

Description: Number of material groups in transaction (till receipt)
Field Name: ANZWGR
Data Element: MCW_ANZWGR
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: MCZAEHLINT
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ANZWGR

MCWDATAW-DUANZP table field - Average number of items

Description: Average number of items
Field Name: DUANZP
Data Element: MCW_DUANZP
Data Type: DEC
length (Dec): 7(2)
Check table:
Conversion Routine:
Domain Name: DEC5_2
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DUANZP

MCWDATAW-DUANZW table field - Average number of material groups in transaction

Description: Average number of material groups in transaction
Field Name: DUANZW
Data Element: MCW_DUANZW
Data Type: DEC
length (Dec): 7(2)
Check table:
Conversion Routine:
Domain Name: DEC5_2
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DUANZW

MCWDATAW-ANZAAR table field - Number of promotion items

Description: Number of promotion items
Field Name: ANZAAR
Data Element: MCW_ANZAAR
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: MCZAEHLINT
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ANZAAR

MCWDATAW-AKTANT table field - Proportion of promotion purchases

Description: Proportion of promotion purchases
Field Name: AKTANT
Data Element: MCW_AKTANT
Data Type: DEC
length (Dec): 6(2)
Check table:
Conversion Routine:
Domain Name: PRZ32V
MemoryID:
AppClass: KS
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field AKTANT

MCWDATAW-NUTZBE table field - Usage intensity (BUn) in market-basket analysis

Description: Usage intensity (BUn) in market-basket analysis
Field Name: NUTZBE
Data Element: MCW_NUTZBE
Data Type: QUAN
length (Dec): 15(3)
Check table:
Conversion Routine:
Domain Name: MENGV15_3
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NUTZBE

MCWDATAW-NUTZVE table field - Usage intensity (sales unit of measure) in basket analysis

Description: Usage intensity (sales unit of measure) in basket analysis
Field Name: NUTZVE
Data Element: MCW_NUTZVE
Data Type: QUAN
length (Dec): 15(3)
Check table:
Conversion Routine:
Domain Name: MENGV15_3
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NUTZVE

MCWDATAW-DUBUMS table field - Average sales per transaction (till receipt)

Description: Average sales per transaction (till receipt)
Field Name: DUBUMS
Data Element: MCW_DUBUMS
Data Type: CURR
length (Dec): 19(2)
Check table:
Conversion Routine:
Domain Name: WERTV10
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DUBUMS

MCWDATAW-MTART table field - Material type

Description: Material type
Field Name: MTART
Data Element: MTART
Data Type: CHAR
length (Dec): 4(0)
Check table: *
Conversion Routine:
Domain Name: MTART
MemoryID: MTA
AppClass: MG
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field MTART

MCWDATAW-SATNR table field - Cross-Plant Configurable Material

Description: Cross-Plant Configurable Material
Field Name: SATNR
Data Element: SATNR
Data Type: CHAR
length (Dec): 40(0)
Check table: *
Conversion Routine: MATN1
Domain Name: MATNR
MemoryID:
AppClass: MG
SHLP:
SHLP Field:
ConvExit: MATN1

See all SAP tables containing field SATNR

MCWDATAW-SAISO table field - Season Category

Description: Season Category
Field Name: SAISO
Data Element: SAISO
Data Type: CHAR
length (Dec): 4(0)
Check table: *
Conversion Routine:
Domain Name: SAISO
MemoryID: SAISO
AppClass: MW
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SAISO

MCWDATAW-SAISJ table field - Season Year

Description: Season Year
Field Name: SAISJ
Data Element: SAISJ
Data Type: CHAR
length (Dec): 4(0)
Check table:
Conversion Routine: GJAHR
Domain Name: CJAHR
MemoryID: WMSAISJ
AppClass:
SHLP:
SHLP Field:
ConvExit: GJAHR

See all SAP tables containing field SAISJ

MCWDATAW-WERTUM table field - Sales value POS (exact value)

Description: Sales value POS (exact value)
Field Name: WERTUM
Data Element: MCW_WERTUM
Data Type: CURR
length (Dec): 19(2)
Check table:
Conversion Routine:
Domain Name: WERTV10
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field WERTUM

MCWDATAW-SCANGR table field - Scanning level during shopping basket analysis

Description: Scanning level during shopping basket analysis
Field Name: SCANGR
Data Element: MCW_SCANGR
Data Type: DEC
length (Dec): 6(2)
Check table:
Conversion Routine:
Domain Name: PRZ32V
MemoryID:
AppClass: KS
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SCANGR

MCWDATAW-ANZBKK table field - Number of known customers

Description: Number of known customers
Field Name: ANZBKK
Data Element: MCW_ANZBKK
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: MCZAEHLINT
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ANZBKK

MCWDATAW-ANZAKM table field - Number of anonymous customers (with payment card)

Description: Number of anonymous customers (with payment card)
Field Name: ANZAKM
Data Element: MCW_ANZAKM
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: MCZAEHLINT
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ANZAKM

MCWDATAW-ANZAKO table field - Number of anonymous customers

Description: Number of anonymous customers
Field Name: ANZAKO
Data Element: MCW_ANZAKO
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: MCZAEHLINT
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ANZAKO

MCWDATAW-BKKANT table field - Proportion of known customers

Description: Proportion of known customers
Field Name: BKKANT
Data Element: MCW_BKKANT
Data Type: DEC
length (Dec): 6(2)
Check table:
Conversion Routine:
Domain Name: PRZ32V
MemoryID:
AppClass: KS
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field BKKANT

MCWDATAW-AKMANT table field - Proportion of anonymous customers (with card payment)

Description: Proportion of anonymous customers (with card payment)
Field Name: AKMANT
Data Element: MCW_AKMANT
Data Type: DEC
length (Dec): 6(2)
Check table:
Conversion Routine:
Domain Name: PRZ32V
MemoryID:
AppClass: KS
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field AKMANT

MCWDATAW-AKOANT table field - Proportion of anonymous customers

Description: Proportion of anonymous customers
Field Name: AKOANT
Data Element: MCW_AKOANT
Data Type: DEC
length (Dec): 6(2)
Check table:
Conversion Routine:
Domain Name: PRZ32V
MemoryID:
AppClass: KS
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field AKOANT


  



View list of all SAP tables(S4H/ECC)

Select data from SAP table