SAP ABAP Table MCPOSREC (External Cash Register: Receipt Data (SAP BW Extractor))

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ BC-BW (Application Component) BW Service API
     ⤷ MCPOSBW (Package) Retail POS Extractors for SAP BW, Non-Release-Specific

Basic Data

Table Category	INTTAB	Structure
Structure	MCPOSREC	Table Relationship Diagram
Short Description	External Cash Register: Receipt Data (SAP BW Extractor)

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

History

Last changed by/on	SAP	20130529
SAP Release Created in