SAP ABAP Table S120BIWS (S120BIWS * Sales as per Receipts)

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	S120BIWS	Table Relationship Diagram
Short Description	S120BIWS * Sales as per Receipts

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	STORNO	☐	STORNO	CHAR1_X	CHAR	1	0	Indicator: Data to Be Canceled
2	WRTTP	☐	RSVTYPE	RSVTYPE	NUMC	3	0	Value type for Reporting	*
3	VRSIO	☐	VRSIO	VRSIO	CHAR	3	0	Version number in the information structure	*
4	SPMON	☐	RSCALMONTH	RSCALMONTH	NUMC	6	0	Calendar year / month
5	SPTAG	☐	RSCALDAY	DATUM	DATS	8	0	Calendar day
6	SPWOC	☐	RSCALWEEK	RSCALWEEK	NUMC	6	0	Calendar year / week
7	SPBUP	☐	RSFISCPER	RSFISCPER	NUMC	7	0	Fiscal year / period
8	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
9	KSKRS	☐	W_KSKRS	W_KSKRS	NUMC	5	0	POS controller
10	KASNR	☐	W_KASNR	KASNR	NUMC	10	0	POS number
11	BONNR	☐	W_BONNR	W_BONNR	NUMC	15	0	Transaction number (till receipt)
12	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
13	EANNR	☐	EAN11	EAN11	CHAR	18	0	International Article Number (EAN/UPC)
14	KSCHL	☐	V_KSCHA	KSCHL	CHAR	4	0	Condition type, sales	*
15	KVORG	☐	POSUVORG	POSUVORG	CHAR	4	0	Transact. type	*
16	CONDNR	☐	MCW_CONDNR	NUMC6	NUMC	6	0	Consecutive condition number
17	PERIV	☐	PERIV	PERIV	CHAR	2	0	Fiscal Year Variant	*
18	VRKME	☐	VRKME	MEINS	UNIT	3	0	Sales unit	*
19	BASME	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
20	WAERK	☐	WAERK	WAERS	CUKY	5	0	SD document currency	*
21	VKMNG	☐	W_VKMNG	MENGV15_3	QUAN	15	3	Transaction sales - quantity in sales unit
22	UMSMNG	☐	W_UMSMNG	MENGV15_3	QUAN	15	3	Transaction sales - quantity in base unit of measure
23	UMSGVP	☐	W_UMSVPM	WERTV10	CURR	19	2	Retail price w/tax from sales as per receipts/aggreg.sales
24	UMSGVO	☐	W_UMSVPO	WERTV10	CURR	19	2	Rtl price from sales as per receipts/aggreg.sales
25	UMSGEO_01	☐	W_UMSEP	WERTV10	CURR	19	2	Sales transactions (till receipts) at cost
26	PRSNLS	☐	W_PRSNLS	WERTV10	CURR	19	2	Price reduction from sales as per receipts/aggregated sales
27	PDIFF	☐	W_PDIFF	WERTV10	CURR	19	2	Trnsctn price diff. between R/3 -> and sales price at POS
28	AZBON	☐	W_AZBON	BCSP6	DEC	11	0	Number of transactions from sales as per till receipts
29	BONPOS	☐	W_BONPOS	DEC9_3	DEC	12	3	No. of material items per transaction (till receipt)
30	AKTNR	☐	WAKTION	WAKTION	CHAR	10	0	Promotion	*
31	MATKL	☐	MATKL	MATKL	CHAR	9	0	Material Group	*
32	VKSTD	☐	W_VKSTD	W_VKSTD	NUMC	2	0	Hour of sale
33	ZMTTL	☐	W_ZAHLART	KSCHL	CHAR	4	0	Payment method as condition	*
34	KUNNR	☐	KUND1	KUNNR	CHAR	10	0	Customer No.	*
35	KTONR	☐	BANKN	BANKN	CHAR	18	0	Bank account number
36	BNKLZ	☐	BANKK	BANKK	CHAR	15	0	Bank Keys
37	CCINS	☐	CCINS	CCINS	CHAR	4	0	Payment cards: Card type	*
38	CCNUM	☐	CCNUM	CCNUM	CHAR	25	0	Payment cards: Card number	*
39	KRFNR	☐	POSKARFNR	CHAR15	CHAR	15	0	Card Sequence Number
40	BZIRK	☐	W_BEZIRK	BZIRK	CHAR	6	0	Sales district	*
41	EZEIT	☐	ERZET	UZEIT	TIMS	6	0	Entry time
42	KASNAM	☐	W_KASNAM	CHAR35	CHAR	35	0	Cashier name
43	KKENN	☐	W_KKENN	W_KKENN	CHAR	1	0	Condition type identification
44	ZMUMS	☐	W_ZMUMS	WERTV10	CURR	19	2	Means of payment sales from sales as per receipts/aggr.sales
45	SERNR	☐	W_SERNR	CHAR25	CHAR	25	0	BOM Explosion Number
46	KUNDK	☐	W_KUNDK	W_KUNDK	CHAR	1	0	Customer ID
47	ANZCOND	☐	W_ANZCOND	BCSP6	DEC	11	0	Number of conditions from sales as per receipt/aggregated
48	VKGRP	☐	VKGRP	VKGRP	CHAR	3	0	Sales group	*
49	VKFNR	☐	W_VKFNR	PERNR	NUMC	8	0	Salesperson number
50	PRVBT	☐	W_PRVBT	WERTV10	CURR	19	2	Commission amount, sales
51	UMART	☐	W_UMART	CHAR1	CHAR	1	0	Sales type (sales/returns/empties)
52	DUMMY1	☐	W_DUMMY1	CHAR6	CHAR	6	0	Dummy element 1 POS (10 characters)
53	DUMMY2	☐	W_DUMMY2	CHAR4	CHAR	4	0	Dummy element 2 POS (10 characters)
54	DUMMY3	☐	W_DUMMY3	CHAR4	CHAR	4	0	Dummy element 3 POS (10 characters)
55	DUMMY4	☐	W_DUMMY4	CHAR10	CHAR	10	0	Dummy element 4 POS (10 characters)
56	DUMMY5	☐	W_DUMMY5	CHAR10	CHAR	10	0	Dummy element 5 POS (10 characters)
57	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	*
58	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	*
59	KBDNR	☐	W_KBDNR	PERNR	NUMC	8	0	Cashier number
60	CONDID	☐	W_CONDID	CHAR20	CHAR	20	0	Condition Type Identification
61	PAYDIR	☐	W_PAYDIR	W_PAYDIR	CHAR	1	0	Direction of payment type (outbound/inbound)

History

Last changed by/on	SAP	20130529
SAP Release Created in