SAP ABAP Table /POSDW/BW_2LIS_44_POSREC (2LIS_44_POSREC for Interface for Old POS Content)

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/BW_2LIS_44_POSREC	Table Relationship Diagram
Short Description	2LIS_44_POSREC for Interface for Old POS Content

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	.INCLUDE	☐				0	0	Extraction Analogous to 2LIS_44_POSREC from Retail
2	ARTICLE	☐	/POSDW/MATERIALNUMBER	MATNR	CHAR	18	0	Material Number
3	ARTNO	☐	/POSDW/BWO_ARTNO	NUMC6	NUMC	6	0	Number of Materials
4	ASCAR	☐	/POSDW/RETAILSTOREID	/POSDW/RETAILSTOREID	CHAR	10	0	Store
5	BANKAN	☐	/POSDW/BANKACCOUNT	/POSDW/ACCOUNT25	CHAR	25	0	Account Number
6	BANKKEY	☐	/POSDW/BANKCODE	/POSDW/CHAR15ALPHA	CHAR	15	0	Bank Number
7	BASUNI	☐	/POSDW/BASEUNITOFMEASURE	MEINS	UNIT	3	0	Base Unit of Measure	*
8	CARDNO	☐	/POSDW/CARDNUMBER	/POSDW/CARDNUMBER	CHAR	25	0	Card Number
9	CARDNXT	☐	/POSDW/CARDNUMBERSUFFIX	/POSDW/CARDNUMBERSUFFIX	CHAR	6	0	Card Sequence Number
10	CARDTY	☐	/POSDW/PAYMENTCARD	/POSDW/TYPECODE	CHAR	4	0	Credit Card Identification
11	COMACC	☐	/POSDW/BWO_COMACC	WERTV10	CURR	19	2	Commission amount, sales
12	CONDID	☐	/POSDW/DISCOUNTID	/POSDW/CHAR32ALPHA	CHAR	32	0	Discount Identification
13	CONDNO	☐	/POSDW/DISCOUNTSEQUENCENUMBER	/POSDW/SEQUENCENUMBER	CHAR	10	0	Discount Item Number
14	CONDTYI	☐	/POSDW/BWO_CONDTYI	/POSDW/BWO_CONDTYI	CHAR	1	0	Condition Type Identification
15	CONDTYS	☐	/POSDW/DISCOUNTTYPECODE	/POSDW/DISCOUNTTYPECODE	CHAR	4	0	Discount Type	*
16	CONTTAX	☐	/POSDW/TAXINCLUDEDFLAG	/POSDW/FLAG	CHAR	1	0	Indicates Whether Taxes Are Included in Retail Value
17	CSHRNM	☐	/POSDW/BWO_CSHRNM	CHAR35	CHAR	35	0	Cashier Name
18	CSHRNO	☐	/POSDW/BWO_CSHRNO	PERNR	NUMC	8	0	Cashier Number
19	CUSTOM	☐	/POSDW/BWO_CUSTOM	CHAR10	CHAR	10	0	Customer Number
20	DSCDCL	☐	/POSDW/BWO_DSCDCL	CHAR12	CHAR	12	0	Bonus Buy Description
21	EANUPC	☐	EAN11	EAN11	CHAR	18	0	International Article Number (EAN/UPC)
22	EXCHANG	☐	/POSDW/BWO_EXCHANG	DEC9	DEC	9	0	Exchange Rate for Price Determination
23	LOCCUR	☐	/POSDW/STORECURRENCY	WAERS	CUKY	5	0	Local Currency	*
24	MRCHGR	☐	/POSDW/MERCHANDISECATEGORY	MATKL	CHAR	9	0	Material Group	*
25	NOART	☐	/POSDW/BWO_NOART	INT1	INT1	3	0	Number of Materials (Extractor)
26	NOCON	☐	/POSDW/BWO_NOCON	INT1	INT1	3	0	Number of Conditions (Extractor)INT1
27	NOMGR	☐	/POSDW/BWO_NOMGR	INT1	INT1	3	0	Number of Material Groups (Extractor)
28	NOPAY	☐	/POSDW/BWO_NOPAY	INT1	INT1	3	0	Number of Means of Payment (Extractor)
29	NOPOS	☐	/POSDW/BWO_NOPOS	INT1	INT1	3	0	Number of Items (Extractor)
30	NOREC	☐	/POSDW/BWO_NOREC	INT1	INT1	3	0	Number of POS Receipts (Extractor)
31	NOUPC	☐	/POSDW/BWO_NOUPC	INT1	INT1	3	0	Number or EAN/UPC Codes (Extractor)
32	PAYDIR	☐	/POSDW/DEBITFLAG	/POSDW/DEBITFLAG	CHAR	1	0	Debit/Credit Indicator
33	PAYMETH	☐	/POSDW/TENDERTYPECODE	/POSDW/TENDERTYPECODE	CHAR	4	0	Means of Payment	*
34	PAYSAL	☐	/POSDW/TENDERAMOUNT	/POSDW/CURRENCY	CURR	15	2	Tender Value
35	POSCTR	☐	/POSDW/DEPARTMENT	/POSDW/CHAR10ALPHA	CHAR	10	0	Department
36	POSCUR	☐	/POSDW/TRANSACTIONCURRENCY	WAERS	CUKY	5	0	Transaction Currency	*
37	POSDAT	☐	/POSDW/BUSINESSDAYDATE	/POSDW/DATE	DATS	8	0	Posting Date
38	POSNO	☐	/POSDW/WORKSTATIONID	/POSDW/WORKSTATIONID	CHAR	10	0	POS Number
39	POSTIM	☐	/POSDW/BEGINDATETIMESTAMP	/POSDW/TIMESTAMP	CHAR	14	0	Second in Which Transaction Starts
40	PROMNO	☐	/POSDW/PROMOTIONID	/POSDW/CHAR10ALPHA	CHAR	10	0	Promotion Number
41	PROMOFL	☐	/POSDW/BWO_PROMOFL	NUMC1	NUMC	1	0	POS Receipt Promotion Flag
42	RECNO	☐	/POSDW/TRANSACTIONSEQUENCENUMB	/POSDW/TRANSACTIONSEQUENCENUMB	CHAR	20	0	Transaction Number
43	RECSIGN	☐	/POSDW/BWO_RECSIGN	CHAR1	CHAR	1	0	Receipt Sign
44	RECVAL	☐	/POSDW/BWO_RECVAL	NUMC10	NUMC	10	0	POS Receipt Value
45	SALCPR	☐	/POSDW/BWO_SALCPR	WERTV10	CURR	19	2	Trnsctn price diff. between R/3 -> and sales price at POS
46	SALES	☐	/POSDW/SALESAMOUNT	/POSDW/CURRENCY	CURR	15	2	Actual Retail Value
47	SALGRP	☐	VKGRP	VKGRP	CHAR	3	0	Sales group	*
48	SALNO	☐	/POSDW/COMMISSIONEMPLOYEEID	/POSDW/CHAR30ALPHA	CHAR	30	0	Number or Name of Salesperson
49	SALPP	☐	/POSDW/COST	/POSDW/CURRENCY	CURR	15	2	Costs
50	SALPRR	☐	/POSDW/REDUCTIONAMOUNT	/POSDW/CURRENCY	CURR	15	2	Discount Value
51	SALQTY	☐	/POSDW/RETAILQUANTITY	/POSDW/QUANTITY	QUAN	13	3	Quantity in Sales Unit
52	SALQTYB	☐	/POSDW/BASEQUANTITY	/POSDW/QUANTITY	QUAN	13	3	Quantity in Base Unit of Measure
53	SALTAX	☐	/POSDW/TAXAMOUNT	/POSDW/CURRENCY	CURR	15	2	Tax Amount
54	SALTYPE	☐	/POSDW/BWO_SALGRP	CHAR1	CHAR	1	0	Sales type (sales/returns/empties)
55	SALUNI	☐	/POSDW/SALESUNITOFMEASURE	MEINS	UNIT	3	0	Sales Unit	*
56	SCFLAG	☐	/POSDW/ITEMIDENTRYMETHODCODE		CHAR	4	0	Entry Method
57	SERNO	☐	/POSDW/SERIALNUMBER	/POSDW/CHAR25ALPHA	CHAR	25	0	Serial Number
58	STORE	☐	/POSDW/PLANT	CHAR4	CHAR	4	0	Plant
59	TATYPE	☐	/POSDW/RETAILTYPECODE	/POSDW/RETAILTYPECODE	CHAR	4	0	Sales Item Type	*
60	VALWOC	☐	/POSDW/BWO_VALWOC	WERTV10	CURR	19	2	Retail price from sales without manufacturer's coupons
61	WEEKDAY	☐	/POSDW/BWO_WEEKDAY	DAYS17	NUMC	1	0	Day of Week

History

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