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

History

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