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

History

Last changed by/on	SAP	20130529
SAP Release Created in