SAP ABAP Table MCCPOS (Cash external: Receipt items (LIS))

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ LO-RIS (Application Component) Retail Information System (RIS)
     ⤷ MCW (Package) R/3 application development: Retail Information System

Basic Data

Table Category	INTTAB	Structure
Structure	MCCPOS	Table Relationship Diagram
Short Description	Cash external: Receipt items (LIS)

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	T000
2	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
3	KSKRS	☐	W_KSKRS	W_KSKRS	NUMC	5	0	POS controller
4	KASNR	☐	W_KASNR	KASNR	NUMC	10	0	POS number
5	BUDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
6	BONNR	☐	W_BONNR	W_BONNR	NUMC	15	0	Transaction number (till receipt)
7	LFDNR	☐	MCW_POSNR	NUMC6	NUMC	6	0	Consecutive item number
8	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
9	MATKL	☐	MATKL	MATKL	CHAR	9	0	Material Group	T023
10	VKFNR	☐	W_VKFNR	PERNR	NUMC	8	0	Salesperson number
11	AKTNR	☐	WAKTION	WAKTION	CHAR	10	0	Promotion	WAKH
12	KVORG	☐	POSUVORG	POSUVORG	CHAR	4	0	Transact. type	TWPPB
13	UMSGVP	☐	W_UMSVPM	WERTV10	CURR	19	2	Retail price w/tax from sales as per receipts/aggreg.sales
14	UMSGVC	☐	W_UMSVPC	WERTV10	CURR	19	2	Retail price from sales without manufacturer's coupons
15	UMSGVO	☐	W_UMSVPO	WERTV10	CURR	19	2	Rtl price from sales as per receipts/aggreg.sales
16	UMSGEO	☐	W_UMSEP	WERTV10	CURR	19	2	Sales transactions (till receipts) at cost
17	PRSNLS	☐	W_PRSNLS	WERTV10	CURR	19	2	Price reduction from sales as per receipts/aggregated sales
18	PRVBT	☐	W_PRVBT	WERTV10	CURR	19	2	Commission amount, sales
19	UMSMNG	☐	W_UMSMNG	MENGV15_3	QUAN	15	3	Transaction sales - quantity in base unit of measure
20	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
21	VKMNG	☐	W_VKMNG	MENGV15_3	QUAN	15	3	Transaction sales - quantity in sales unit
22	VRKME	☐	VRKME	MEINS	UNIT	3	0	Sales unit	T006
23	SUPKZ	☐	SUPKZ	SUPKZ	CHAR	1	0	Statistics update indicator (post in/post out)
24	EANNR	☐	EAN11	EAN11	CHAR	18	0	International Article Number (EAN/UPC)
25	UMART	☐	W_UMART	CHAR1	CHAR	1	0	Sales type (sales/returns/empties)
26	VKGRP	☐	VKGRP	VKGRP	CHAR	3	0	Sales group	TVKGR
27	PDIFF	☐	W_PDIFF	WERTV10	CURR	19	2	Trnsctn price diff. between R/3 -> and sales price at POS
28	ANZPOS	☐	W_ANZPOS	BCSP6	DEC	11	0	Number of items from sales as per receipts/aggregated sales
29	ANZCOND	☐	W_ANZCOND	BCSP6	DEC	11	0	Number of conditions from sales as per receipt/aggregated
30	SERNR	☐	W_SERNR	CHAR25	CHAR	25	0	BOM Explosion Number
31	.INCLUDE	☐				0	0	User Structure: external POS interface
32	DUMMY	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
33	TABIX	☐	POS_TABIX	POS_TABIX	INT4	10	0	Index in an internal table
34	.INCLUDE	☐				0	0	User Structure: external POS interface
35	DUMMY_ENTRY	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
36	VORGA	☐	W_KVORG	W_VKPVOR	CHAR	2	0	Procedure in sales price calculations
37	FRBNR	☐	W_FRBNR	W_FRBNR	CHAR	10	0	Ext. Doc. No. of Application Calling Up Sales Price Calc.

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	MCCPOS	AKTNR	WAKH	AKTNR
2	MCCPOS	KVORG	TWPPB	UVORG	KEY	1	1
3	MCCPOS	MANDT	T000	MANDT
4	MCCPOS	MATKL	T023	MATKL
5	MCCPOS	MATNR	MARA	MATNR
6	MCCPOS	MEINS	T006	MSEHI
7	MCCPOS	VKGRP	TVKGR	VKGRP		C	1
8	MCCPOS	VRKME	T006	MSEHI
9	MCCPOS	WERKS	T001W	WERKS

History

Last changed by/on	SAP	20020219
SAP Release Created in