SAP ABAP Table /POSDW/2LIS_43_POSCAS (Extraction Analogous to 2LIS_43_POSCAS from Retail)

Hierarchy

☛ BI_CONT (Software Component) Business Intelligence Content
   ⤷ BW-BCT-ISR-PIP (Application Component) Point of Sales Inbound Processing Engine
     ⤷ /POSDW/OUTPUT_CONVERSION (Package) PIPE Tasks and Output Conversion

Basic Data

Table Category	INTTAB	Structure
Structure	/POSDW/2LIS_43_POSCAS	Table Relationship Diagram
Short Description	Extraction Analogous to 2LIS_43_POSCAS from Retail

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	ASCAR	☐	/POSDW/RETAILSTOREID	/POSDW/RETAILSTOREID	CHAR	10	0	Store
2	BNKBVOL	☐	/POSDW/BANKAMOUNT	/POSDW/CURRENCY	CURR	15	2	Amount Transferred to Bank
3	CMPCODE	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
4	CONDTYI	☐	/POSDW/BWO_CONDTYI	/POSDW/BWO_CONDTYI	CHAR	1	0	Condition Type Identification
5	CONDTYS	☐	/POSDW/DISCOUNTTYPECODE	/POSDW/DISCOUNTTYPECODE	CHAR	4	0	Discount Type	*
6	CONTTAX	☐	/POSDW/TAXINCLUDEDFLAG	/POSDW/FLAG	CHAR	1	0	Indicates Whether Taxes Are Included in Retail Value
7	CSHRNM	☐	/POSDW/BWO_CSHRNM	CHAR35	CHAR	35	0	Cashier Name
8	CSHRNO	☐	/POSDW/BWO_CSHRNO	PERNR	NUMC	8	0	Cashier Number
9	EXCHANG	☐	/POSDW/BWO_EXCHANG	DEC9	DEC	9	0	Exchange Rate for Price Determination
10	LOCCUR	☐	/POSDW/STORECURRENCY	WAERS	CUKY	5	0	Local Currency	*
11	LOGTIM	☐	/POSDW/LOGONTIME	/POSDW/COUNT	INT4	10	0	Logon Time
12	MOPAAM	☐	/POSDW/ACTUALAMOUNT	/POSDW/CURRENCY	CURR	15	2	Actual Amount
13	MOPTAM	☐	/POSDW/TENDERTOTAL	/POSDW/CURRENCY	CURR	15	2	Total of Means of Payment Values
14	NOCHOL	☐	/POSDW/CHECKSOVERLIMITCOUNT	/POSDW/COUNT	INT4	10	0	Number of Checks Over the Limit
15	NOCON	☐	/POSDW/DISCOUNTCOUNT	/POSDW/COUNT	INT4	10	0	Number of Discount Items
16	NOCSHREM	☐	/POSDW/REMOVALCOUNT	/POSDW/COUNT	INT4	10	0	Number of Cash Removals
17	NOCTRA	☐	/POSDW/POSTVOIDCOUNT	/POSDW/COUNT	INT4	10	0	Number of Transaction Cancellations
18	NOFLOGAT	☐	/POSDW/FAILEDLOGONCOUNT	/POSDW/COUNT	INT4	10	0	Number of Unsuccessful Attempts to Log On
19	NOICANC	☐	/POSDW/IMMEDIATEVOIDCOUNT	/POSDW/COUNT	INT4	10	0	Number of Immediate Cancellations
20	NOLCANC	☐	/POSDW/LINEITEMVOIDCOUNT	/POSDW/COUNT	INT4	10	0	Number of Line Cancellations
21	NOMGRSAL	☐	/POSDW/OPENDEPARTMENTCOUNT	/POSDW/COUNT	INT4	10	0	Number of Material Group Sales
22	NOPOS	☐	/POSDW/LINEITEMCOUNT	/POSDW/COUNT	INT4	10	0	Number of Sales Items
23	NOREC	☐	/POSDW/BWO_NOREC	INT1	INT1	3	0	Number of POS Receipts (Extractor)
24	NOREP	☐	/POSDW/REPORTCOUNT	/POSDW/COUNT	INT4	10	0	Number of Reports
25	NOSCANA	☐	/POSDW/SCANNEDITEMCOUNT	/POSDW/COUNT	INT4	10	0	Number of Scanned Items
26	NOTDRWOP	☐	/POSDW/NOSALETRANSACTIONCOUNT	/POSDW/COUNT	INT4	10	0	Number of Void Receipts
27	NOTERM	☐	/POSDW/TERMINATIONCOUNT	/POSDW/COUNT	INT4	10	0	Number of Terminations
28	POSCTR	☐	/POSDW/DEPARTMENT	/POSDW/CHAR10ALPHA	CHAR	10	0	Department
29	POSCUR	☐	/POSDW/TRANSACTIONCURRENCY	WAERS	CUKY	5	0	Transaction Currency	*
30	POSDAT	☐	/POSDW/BUSINESSDAYDATE	/POSDW/DATE	DATS	8	0	Posting Date
31	POSNO	☐	/POSDW/WORKSTATIONID	/POSDW/WORKSTATIONID	CHAR	10	0	POS Number
32	POSPAYM	☐	/POSDW/TENDERTYPECODE	/POSDW/TENDERTYPECODE	CHAR	4	0	Means of Payment	*
33	POSTIM	☐	/POSDW/BEGINDATETIMESTAMP	/POSDW/TIMESTAMP	CHAR	14	0	Second in Which Transaction Starts
34	REGTIM	☐	/POSDW/RINGTIME	/POSDW/COUNT	INT4	10	0	Cashier Time
35	SALCPR	☐	/POSDW/BWO_SALCPR	WERTV10	CURR	19	2	Trnsctn price diff. between R/3 -> and sales price at POS
36	SALES	☐	/POSDW/SALESTOTAL	/POSDW/CURRENCY	CURR	15	2	Actual Retail Value Total
37	SALGRP	☐	VKGRP	VKGRP	CHAR	3	0	Sales group	*
38	SALPRR	☐	/POSDW/REDUCTIONTOTAL	/POSDW/CURRENCY	CURR	15	2	Discount Value Total
39	SALTAX	☐	/POSDW/TAXTOTAL	/POSDW/CURRENCY	CURR	15	2	Total Tax Amount
40	STORE	☐	/POSDW/PLANT	CHAR4	CHAR	4	0	Plant
41	TATYPE	☐	/POSDW/RETAILTYPECODE	/POSDW/RETAILTYPECODE	CHAR	4	0	Sales Item Type	*
42	TAXCODE	☐	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code	*
43	TDIFFM	☐	/POSDW/SHORTAMOUNT	/POSDW/CURRENCY	CURR	15	2	Short Amount
44	TDIFFP	☐	/POSDW/OVERAMOUNT	/POSDW/CURRENCY	CURR	15	2	Over Amount
45	VALCHOL	☐	/POSDW/CHECKSOVERLIMITAMOUNT	/POSDW/CURRENCY	CURR	15	2	Value of checks over the limit
46	VALCSHREM	☐	/POSDW/REMOVALAMOUNT	/POSDW/CURRENCY	CURR	15	2	Value Removed
47	VALCTRA	☐	/POSDW/POSTVOIDAMOUNT	/POSDW/CURRENCY	CURR	15	2	Value of Transaction Cancellations
48	VALICANC	☐	/POSDW/IMMEDIATEVOIDAMOUNT	/POSDW/CURRENCY	CURR	15	2	Value of Immediate Cancellations
49	VALLCANC	☐	/POSDW/LINEITEMVOIDAMOUNT	/POSDW/CURRENCY	CURR	15	2	Value of Line Cancellations
50	VALMGRSAL	☐	/POSDW/OPENDEPARTMENTAMOUNT	/POSDW/CURRENCY	CURR	15	2	Value of Material Group Sales
51	VALSCANA	☐	/POSDW/SCANNEDITEMAMOUNT	/POSDW/CURRENCY	CURR	15	2	Value of Scanned Items
52	VALTERM	☐	/POSDW/TERMINATIONAMOUNT	/POSDW/CURRENCY	CURR	15	2	Value of Terminations
53	WEEKDAY	☐	/POSDW/BWO_WEEKDAY	DAYS17	NUMC	1	0	Day of Week

History

Last changed by/on	SAP	20100326
SAP Release Created in	351