SAP ABAP Table MC44RB0REC (Extraction Retail BW: Sales Receipt Data)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ LO-LIS (Application Component) Logistics Information System (LIS)
     ⤷ MCEX (Package) Extraction Interface LIS-BW

Basic Data

Table Category	INTTAB	Structure
Structure	MC44RB0REC	Table Relationship Diagram
Short Description	Extraction Retail BW: Sales Receipt Data

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	ROCANCEL	☐	ROCANCEL	BOOLE	CHAR	1	0	Indicator: Cancel Data Record
2	.INCLUDE	☐				0	0	Extraction Retail BW: Sales Receipt Data
3	ARTICLE	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
4	ARTNO	☐	POSBW_ARTNO	NUMC6	NUMC	6	0	Number of Materials
5	ASCAR	☐	FILIALE	KUNNR	CHAR	10	0	Assortment owner	*
6	BANKAN	☐	BANKN	BANKN	CHAR	18	0	Bank account number
7	BANKKEY	☐	BANKK	BANKK	CHAR	15	0	Bank Keys
8	BASUNI	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
9	CARDNO	☐	CCNUM	CCNUM	CHAR	25	0	Payment cards: Card number	*
10	CARDNXT	☐	POSKARFNR	CHAR15	CHAR	15	0	Card Sequence Number
11	CARDTY	☐	CCINS	CCINS	CHAR	4	0	Payment cards: Card type	*
12	COMACC	☐	W_PRVBT	WERTV10	CURR	19	2	Commission amount, sales
13	CONDID	☐	W_CONDID	CHAR20	CHAR	20	0	Condition Type Identification
14	CONDNO	☐	MCW_CONDNR	NUMC6	NUMC	6	0	Consecutive condition number
15	CONDTYI	☐	W_KKENN	W_KKENN	CHAR	1	0	Condition type identification
16	CONDTYS	☐	V_KSCHA	KSCHL	CHAR	4	0	Condition type, sales	*
17	CONTTAX	☐	W_CONTTAX	W_CONTTAX	CHAR	1	0	Flag: Tax Contained in Sales (Receipt)
18	CSHRNM	☐	W_KASNAM	CHAR35	CHAR	35	0	Cashier name
19	CSHRNO	☐	W_KBDNR	PERNR	NUMC	8	0	Cashier number
20	CUSTOM	☐	KUND1	KUNNR	CHAR	10	0	Customer No.	*
21	DSCDCL	☐	POSBW_BBYNR	POSBW_BBYNR	CHAR	12	0	Bonus Buy Description
22	EANUPC	☐	EAN11	EAN11	CHAR	18	0	International Article Number (EAN/UPC)
23	EXCHANG	☐	KURSK	KURRF	DEC	9	5	Exchange Rate for Pricing and Statistics
24	LOCCUR	☐	HWAER	WAERS	CUKY	5	0	Local Currency	*
25	MRCHGR	☐	MATKL	MATKL	CHAR	9	0	Material Group	*
26	NOART	☐	POSBW_NOART	INT1	INT1	3	0	Number of Materials (Extractor)
27	NOCON	☐	POSBW_NOCON	INT1	INT1	3	0	Number of Conditions (Extractor)
28	NOMGR	☐	POSBW_NOMGR	INT1	INT1	3	0	Number of Material Groups (Extractor)
29	NOPAY	☐	POSBW_NOPAY	INT1	INT1	3	0	Number of Means of Payment (Extractor)
30	NOPOS	☐	POSBW_NOPOS	INT1	INT1	3	0	Number of Items (Extractor)
31	NOREC	☐	POSBW_NOREC	INT1	INT1	3	0	Number of Receipts (Extractor)
32	NOUPC	☐	POSBW_NOUPC	INT1	INT1	3	0	Number of EAN/UPC (Extractor)
33	PAYDIR	☐	W_PAYDIR	W_PAYDIR	CHAR	1	0	Direction of payment type (outbound/inbound)
34	PAYMETH	☐	W_ZAHLART	KSCHL	CHAR	4	0	Payment method as condition	*
35	PAYSAL	☐	W_ZMUMS	WERTV10	CURR	19	2	Means of payment sales from sales as per receipts/aggr.sales
36	POSCTR	☐	W_KSKRS	W_KSKRS	NUMC	5	0	POS controller
37	POSCUR	☐	WAERK	WAERS	CUKY	5	0	SD document currency	*
38	POSDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
39	POSNO	☐	W_KASNR	KASNR	NUMC	10	0	POS number
40	POSTIM	☐	ERZET	UZEIT	TIMS	6	0	Entry time
41	PROMNO	☐	WAKTION	WAKTION	CHAR	10	0	Promotion	*
42	PROMOFL	☐	POSBW_AFLAG	MCW_AFLAG	NUMC	1	0	Action Identifier: Receipt
43	RECNO	☐	W_BONNR	W_BONNR	NUMC	15	0	Transaction number (till receipt)
44	RECSIGN	☐	POSBW_RECSIGN	POSBW_RECSIGN	CHAR	1	0	Debit/Credit Sign on Receipt
45	RECVAL	☐	POSBW_RECVAL	NUMC10	NUMC	10	0	Receipt Value
46	SALCPR	☐	W_PDIFF	WERTV10	CURR	19	2	Trnsctn price diff. between R/3 -> and sales price at POS
47	SALES	☐	W_UMSATZ	WERTV10	CURR	19	2	Receipt Sales Volume
48	SALGRP	☐	VKGRP	VKGRP	CHAR	3	0	Sales group	*
49	SALNO	☐	W_VKFNR	PERNR	NUMC	8	0	Salesperson number
50	SALPP	☐	W_UMSEP	WERTV10	CURR	19	2	Sales transactions (till receipts) at cost
51	SALPRR	☐	W_PRSNLS	WERTV10	CURR	19	2	Price reduction from sales as per receipts/aggregated sales
52	SALQTY	☐	W_VKMNG	MENGV15_3	QUAN	15	3	Transaction sales - quantity in sales unit
53	SALQTYB	☐	W_UMSMNG	MENGV15_3	QUAN	15	3	Transaction sales - quantity in base unit of measure
54	SALTAX	☐	W_UMSTAX	WERTV10	CURR	19	2	Receipt for Sales Tax
55	SALTYPE	☐	W_UMART	CHAR1	CHAR	1	0	Sales type (sales/returns/empties)
56	SALUNI	☐	VRKME	MEINS	UNIT	3	0	Sales unit	*
57	SCFLAG	☐	POSBW_SCFLAG	POSBW_SCFLAG	NUMC	1	0	Scan Flag
58	SERNO	☐	W_SERNR	CHAR25	CHAR	25	0	BOM Explosion Number
59	STORE	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
60	TATYPE	☐	POSUVORG	POSUVORG	CHAR	4	0	Transact. type	*
61	VALWOC	☐	POSBW_VALWOC	WERTV10	CURR	19	2	Retail price from sales without manufacturer's coupons
62	WEEKDAY	☐	MCW_WOCHTG	DAYS17	NUMC	1	0	Weekday

History

Last changed by/on	SAP	20130529
SAP Release Created in