SAP ABAP Table /POSDW/BW_POSCAS (Interface Structure for Old POS Content in BW)
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_POSCAS   Table Relationship Diagram
Short Description Interface Structure for Old POS Content in BW    
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_43_POSCAS from Retail  
2 ASCAR /POSDW/RETAILSTOREID /POSDW/RETAILSTOREID CHAR 10   0   Store  
3 BNKBVOL /POSDW/BANKAMOUNT /POSDW/CURRENCY CURR 15   2   Amount Transferred to Bank  
4 CMPCODE BUKRS BUKRS CHAR 4   0   Company Code *
5 CONDTYI /POSDW/BWO_CONDTYI /POSDW/BWO_CONDTYI CHAR 1   0   Condition Type Identification  
6 CONDTYS /POSDW/DISCOUNTTYPECODE /POSDW/DISCOUNTTYPECODE CHAR 4   0   Discount Type *
7 CONTTAX /POSDW/TAXINCLUDEDFLAG /POSDW/FLAG CHAR 1   0   Indicates Whether Taxes Are Included in Retail Value  
8 CSHRNM /POSDW/BWO_CSHRNM CHAR35 CHAR 35   0   Cashier Name  
9 CSHRNO /POSDW/BWO_CSHRNO PERNR NUMC 8   0   Cashier Number  
10 EXCHANG /POSDW/BWO_EXCHANG DEC9 DEC 9   0   Exchange Rate for Price Determination  
11 LOCCUR /POSDW/STORECURRENCY WAERS CUKY 5   0   Local Currency *
12 LOGTIM /POSDW/LOGONTIME /POSDW/COUNT INT4 10   0   Logon Time  
13 MOPAAM /POSDW/ACTUALAMOUNT /POSDW/CURRENCY CURR 15   2   Actual Amount  
14 MOPTAM /POSDW/TENDERTOTAL /POSDW/CURRENCY CURR 15   2   Total of Means of Payment Values  
15 NOCHOL /POSDW/CHECKSOVERLIMITCOUNT /POSDW/COUNT INT4 10   0   Number of Checks Over the Limit  
16 NOCON /POSDW/DISCOUNTCOUNT /POSDW/COUNT INT4 10   0   Number of Discount Items  
17 NOCSHREM /POSDW/REMOVALCOUNT /POSDW/COUNT INT4 10   0   Number of Cash Removals  
18 NOCTRA /POSDW/POSTVOIDCOUNT /POSDW/COUNT INT4 10   0   Number of Transaction Cancellations  
19 NOFLOGAT /POSDW/FAILEDLOGONCOUNT /POSDW/COUNT INT4 10   0   Number of Unsuccessful Attempts to Log On  
20 NOICANC /POSDW/IMMEDIATEVOIDCOUNT /POSDW/COUNT INT4 10   0   Number of Immediate Cancellations  
21 NOLCANC /POSDW/LINEITEMVOIDCOUNT /POSDW/COUNT INT4 10   0   Number of Line Cancellations  
22 NOMGRSAL /POSDW/OPENDEPARTMENTCOUNT /POSDW/COUNT INT4 10   0   Number of Material Group Sales  
23 NOPOS /POSDW/LINEITEMCOUNT /POSDW/COUNT INT4 10   0   Number of Sales Items  
24 NOREC /POSDW/BWO_NOREC INT1 INT1 3   0   Number of POS Receipts (Extractor)  
25 NOREP /POSDW/REPORTCOUNT /POSDW/COUNT INT4 10   0   Number of Reports  
26 NOSCANA /POSDW/SCANNEDITEMCOUNT /POSDW/COUNT INT4 10   0   Number of Scanned Items  
27 NOTDRWOP /POSDW/NOSALETRANSACTIONCOUNT /POSDW/COUNT INT4 10   0   Number of Void Receipts  
28 NOTERM /POSDW/TERMINATIONCOUNT /POSDW/COUNT INT4 10   0   Number of Terminations  
29 POSCTR /POSDW/DEPARTMENT /POSDW/CHAR10ALPHA CHAR 10   0   Department  
30 POSCUR /POSDW/TRANSACTIONCURRENCY WAERS CUKY 5   0   Transaction Currency *
31 POSDAT /POSDW/BUSINESSDAYDATE /POSDW/DATE DATS 8   0   Posting Date  
32 POSNO /POSDW/WORKSTATIONID /POSDW/WORKSTATIONID CHAR 10   0   POS Number  
33 POSPAYM /POSDW/TENDERTYPECODE /POSDW/TENDERTYPECODE CHAR 4   0   Means of Payment *
34 POSTIM /POSDW/BEGINDATETIMESTAMP /POSDW/TIMESTAMP CHAR 14   0   Second in Which Transaction Starts  
35 REGTIM /POSDW/RINGTIME /POSDW/COUNT INT4 10   0   Cashier Time  
36 SALCPR /POSDW/BWO_SALCPR WERTV10 CURR 19   2   Trnsctn price diff. between R/3 -> and sales price at POS  
37 SALES /POSDW/SALESTOTAL /POSDW/CURRENCY CURR 15   2   Actual Retail Value Total  
38 SALGRP VKGRP VKGRP CHAR 3   0   Sales group *
39 SALPRR /POSDW/REDUCTIONTOTAL /POSDW/CURRENCY CURR 15   2   Discount Value Total  
40 SALTAX /POSDW/TAXTOTAL /POSDW/CURRENCY CURR 15   2   Total Tax Amount  
41 STORE /POSDW/PLANT CHAR4 CHAR 4   0   Plant  
42 TATYPE /POSDW/RETAILTYPECODE /POSDW/RETAILTYPECODE CHAR 4   0   Sales Item Type *
43 TAXCODE MWSKZ MWSKZ CHAR 2   0   Tax on sales/purchases code *
44 TDIFFM /POSDW/SHORTAMOUNT /POSDW/CURRENCY CURR 15   2   Short Amount  
45 TDIFFP /POSDW/OVERAMOUNT /POSDW/CURRENCY CURR 15   2   Over Amount  
46 VALCHOL /POSDW/CHECKSOVERLIMITAMOUNT /POSDW/CURRENCY CURR 15   2   Value of checks over the limit  
47 VALCSHREM /POSDW/REMOVALAMOUNT /POSDW/CURRENCY CURR 15   2   Value Removed  
48 VALCTRA /POSDW/POSTVOIDAMOUNT /POSDW/CURRENCY CURR 15   2   Value of Transaction Cancellations  
49 VALICANC /POSDW/IMMEDIATEVOIDAMOUNT /POSDW/CURRENCY CURR 15   2   Value of Immediate Cancellations  
50 VALLCANC /POSDW/LINEITEMVOIDAMOUNT /POSDW/CURRENCY CURR 15   2   Value of Line Cancellations  
51 VALMGRSAL /POSDW/OPENDEPARTMENTAMOUNT /POSDW/CURRENCY CURR 15   2   Value of Material Group Sales  
52 VALSCANA /POSDW/SCANNEDITEMAMOUNT /POSDW/CURRENCY CURR 15   2   Value of Scanned Items  
53 VALTERM /POSDW/TERMINATIONAMOUNT /POSDW/CURRENCY CURR 15   2   Value of Terminations  
54 WEEKDAY /POSDW/BWO_WEEKDAY DAYS17 NUMC 1   0   Day of Week  
55 .INCLUDE       0   0   Transfer to BW for Totals Transactions  
56 .INCLUDE       0   0   Transaction Header for BW  
57 RECORDQUALIFIER /POSDW/RECORDQUALIFIER /POSDW/RECORDQUALIFIER CHAR 4   0   Record Type of Transaction  
58 BWTRANSINDEX /POSDW/BWTRANSINDEX /POSDW/CHAR10ALPHA CHAR 10   0   Transaction Index for BW as Character Field  
59 .INCLUDE       0   0   Transaction  
60 .INCLUDE       0   0   Transaction - Database Fields  
61 .INCLUDE       0   0   Transaction - Database Fields (Key Fields)  
62 RETAILSTOREID /POSDW/RETAILSTOREID /POSDW/RETAILSTOREID CHAR 10   0   Store  
63 BUSINESSDAYDATE /POSDW/BUSINESSDAYDATE /POSDW/DATE DATS 8   0   Posting Date  
64 TRANSTYPECODE /POSDW/TRANSACTIONTYPECODE /POSDW/TRANSACTIONTYPECODE CHAR 4   0   Transaction Type /POSDW/TRANTY
65 WORKSTATIONID /POSDW/WORKSTATIONID /POSDW/WORKSTATIONID CHAR 10   0   POS Number  
66 TRANSNUMBER /POSDW/TRANSACTIONSEQUENCENUMB /POSDW/TRANSACTIONSEQUENCENUMB CHAR 20   0   Transaction Number  
67 BEGINTIMESTAMP /POSDW/BEGINDATETIMESTAMP /POSDW/TIMESTAMP CHAR 14   0   Second in Which Transaction Starts  
68 ENDTIMESTAMP /POSDW/ENDDATETIMESTAMP /POSDW/TIMESTAMP CHAR 14   0   Second in Which Transaction Ends  
69 DEPARTMENT /POSDW/DEPARTMENT /POSDW/CHAR10ALPHA CHAR 10   0   Department  
70 OPERATORQUAL /POSDW/OPERATORQUALIFIER /POSDW/OPERATORQUALIFIER CHAR 1   0   Operator Qualifier  
71 OPERATORID /POSDW/OPERATORID /POSDW/CHAR30ALPHA CHAR 30   0   Cashier Number or Name  
72 TRANSCURRENCY /POSDW/TRANSACTIONCURRENCY WAERS CUKY 5   0   Transaction Currency *
73 PARTNERQUALIFIER /POSDW/PARTNERQUALIFIER /POSDW/PARTNERQUALIFIER CHAR 1   0   Qualifier for Partner Number  
74 PARTNERID /POSDW/PARTNERID /POSDW/CHAR13ALPHA CHAR 13   0   Partner Number  
75 .INCLUDE       0   0   Transaction - Enhanced Fields  
76 TRANSINDEX /POSDW/TRANSINDEX /POSDW/TRANSINDEX INT4 10   0   Transaction Index  
77 NONCOMPFLAG /POSDW/NONCOMPFLAG /POSDW/FLAG CHAR 1   0   Indicator for Non-Comparable Sales  
78 TRANSTYPEGROUP /POSDW/TRANSACTIONTYPEGROUP /POSDW/TRANSACTIONTYPEGROUP CHAR 4   0   Transaction Type Group /POSDW/TRANTG
79 BUSINESSTYPE /POSDW/BUSINESSTYPE /POSDW/BUSINESSTYPE CHAR 1   0   Business Transaction  
80 REVERSALFLAG /POSDW/REVERSALFLAG /POSDW/FLAG CHAR 1   0   Reversal Indicator  
81 TRANSDEBITFLAG /POSDW/DEBITFLAG /POSDW/DEBITFLAG CHAR 1   0   Debit/Credit Indicator  
82 PLANT /POSDW/PLANT CHAR4 CHAR 4   0   Plant  
83 STORECURRENCY /POSDW/STORECURRENCY WAERS CUKY 5   0   Local Currency *
84 PLANTCUSTOMER /POSDW/PLANTCUSTOMER /POSDW/CHAR10ALPHA CHAR 10   0   Customer Number of Plant  
85 BUSINESSLOCATION /POSDW/BUSINESSLOCATION /POSDW/CHAR10ALPHA CHAR 10   0   Business Location Identifier (IS-OIL/MRN)  
86 TURNOVER /POSDW/TRANSTURNOVER /POSDW/CURRENCY CURR 15   2   Sales Totals Per Transaction  
87 INDEXCURRENCY /POSDW/INDEXCURRENCY WAERS CUKY 5   0   Currency for Sales Totals *
88 VERSION /POSDW/TRANSACTION_VERSION /POSDW/TRANSACTION_VERSION INT1 3   0   Version of POS Transaction  
89 .INCLUDE       0   0   Sales Totals  
90 .INCLUDE       0   0   Total Sales - Database Fields  
91 .INCLUDE       0   0   Sales Totals - Database Fields (Key Fields)  
92 RETAILTYPECODE /POSDW/RETAILTYPECODE /POSDW/RETAILTYPECODE CHAR 4   0   Sales Item Type *
93 SALESAMOUNT /POSDW/SALESTOTAL /POSDW/CURRENCY CURR 15   2   Actual Retail Value Total  
94 LINEITEMCOUNT /POSDW/LINEITEMCOUNT /POSDW/COUNT INT4 10   0   Number of Sales Items  
95 .INCLUDE       0   0   Sales Totals - Enhanced Fields  
96 RETAILTYPEGROUP /POSDW/RETAILTYPEGROUP /POSDW/RETAILTYPEGROUP CHAR 4   0   Sales Item Type Group /POSDW/RETTG
97 RETAILDEBITFLAG /POSDW/DEBITFLAG /POSDW/DEBITFLAG CHAR 1   0   Debit/Credit Indicator  
98 RETL_ITEM_CAT /POSDW/RETAIL_ITEM_CATEGORY /POSDW/ITEM_CATEGORY CHAR 1   0   Classification of Sales Item: Category *
99 RETL_ITEM_SCAT /POSDW/RETAIL_ITEM_SUBCATEGORY /POSDW/ITEM_SUBCATEGORY CHAR 1   0   Classification of Sales Item: Subcategory *
100 .INCLUDE       0   0   Total Discounts  
101 .INCLUDE       0   0   Total Discounts - Database Fields  
102 .INCLUDE       0   0   Total Discounts - Database Fields (Key Fields)  
103 DISCTYPECODE /POSDW/DISCOUNTTYPECODE /POSDW/DISCOUNTTYPECODE CHAR 4   0   Discount Type *
104 REDUCTIONAMOUNT /POSDW/REDUCTIONTOTAL /POSDW/CURRENCY CURR 15   2   Discount Value Total  
105 DISCCOUNT /POSDW/DISCOUNTCOUNT /POSDW/COUNT INT4 10   0   Number of Discount Items  
106 .INCLUDE       0   0   Total Discounts - Enhanced Fields  
107 DISCTYPEGROUP /POSDW/DISCOUNTTYPEGROUP /POSDW/DISCOUNTTYPEGROUP CHAR 4   0   Discount Type Group /POSDW/DISCTG
108 DISCDEBITFLAG /POSDW/DEBITFLAG /POSDW/DEBITFLAG CHAR 1   0   Debit/Credit Indicator  
109 .INCLUDE       0   0   Total Taxes  
110 .INCLUDE       0   0   Total Taxes - Database Fields  
111 .INCLUDE       0   0   Total Taxes - Database Fields (Key Fields)  
112 TAXTYPECODE /POSDW/TAXTYPECODE /POSDW/TAXTYPECODE CHAR 4   0   Tax Type *
113 TAXAMOUNT /POSDW/TAXTOTAL /POSDW/CURRENCY CURR 15   2   Total Tax Amount  
114 TAXCOUNT /POSDW/TAXCOUNT /POSDW/COUNT INT4 10   0   Number of Tax Items  
115 .INCLUDE       0   0   Total Taxes - Enhanced Fields  
116 TAXINCLUDEDFLAG /POSDW/TAXINCLUDEDFLAG /POSDW/FLAG CHAR 1   0   Indicates Whether Taxes Are Included in Retail Value  
117 TAXTYPEGROUP /POSDW/TAXTYPEGROUP /POSDW/TAXTYPEGROUP CHAR 4   0   Tax Category Group /POSDW/TAXTG
118 TAXDEBITFLAG /POSDW/DEBITFLAG /POSDW/DEBITFLAG CHAR 1   0   Debit/Credit Indicator  
119 .INCLUDE       0   0   Total Means of Payment  
120 .INCLUDE       0   0   Total Means of Payment - Database Fields  
121 .INCLUDE       0   0   Total Means of Payment - Database Fields (Key Fields)  
122 TENDERTYPECODE /POSDW/TENDERTYPECODE /POSDW/TENDERTYPECODE CHAR 4   0   Means of Payment *
123 TENDERAMOUNT /POSDW/TENDERTOTAL /POSDW/CURRENCY CURR 15   2   Total of Means of Payment Values  
124 TENDERCOUNT /POSDW/TENDERCOUNT /POSDW/COUNT INT4 10   0   Number of Means of Payment Items  
125 ACTUALAMOUNT /POSDW/ACTUALAMOUNT /POSDW/CURRENCY CURR 15   2   Actual Amount  
126 SHORTAMOUNT /POSDW/SHORTAMOUNT /POSDW/CURRENCY CURR 15   2   Short Amount  
127 OVERAMOUNT /POSDW/OVERAMOUNT /POSDW/CURRENCY CURR 15   2   Over Amount  
128 REMOVALAMOUNT /POSDW/REMOVALAMOUNT /POSDW/CURRENCY CURR 15   2   Value Removed  
129 REMOVALCOUNT /POSDW/REMOVALCOUNT /POSDW/COUNT INT4 10   0   Number of Cash Removals  
130 BANKAMOUNT /POSDW/BANKAMOUNT /POSDW/CURRENCY CURR 15   2   Amount Transferred to Bank  
131 .INCLUDE       0   0   Total Tender - Enhanced Fields  
132 TENDERTYPEGROUP /POSDW/TENDERTYPEGROUP /POSDW/TENDERTYPEGROUP CHAR 4   0   Payment Means Group /POSDW/TENDTG
133 TENDERDEBITFLAG /POSDW/DEBITFLAG /POSDW/DEBITFLAG CHAR 1   0   Debit/Credit Indicator  
134 TENDER_CAT /POSDW/TENDER_CATEGORY /POSDW/ITEM_CATEGORY CHAR 1   0   Classification of Tender: Category *
135 TENDER_SCAT /POSDW/TENDER_SUBCATEGORY /POSDW/ITEM_SUBCATEGORY CHAR 1   0   Classification of Tender: Subcategory *
136 .INCLUDE       0   0   Cashier Totals  
137 .INCLUDE       0   0   Total Cashiers - Database Fields  
138 TRANSCNT /POSDW/TRANSACTIONCOUNT /POSDW/COUNT INT4 10   0   Number of Transactions  
139 NOSALETRANSCNT /POSDW/NOSALETRANSACTIONCOUNT /POSDW/COUNT INT4 10   0   Number of Void Receipts  
140 IMMEDIATEVOIDCNT /POSDW/IMMEDIATEVOIDCOUNT /POSDW/COUNT INT4 10   0   Number of Immediate Cancellations  
141 IMMEDIATEVOIDAMT /POSDW/IMMEDIATEVOIDAMOUNT /POSDW/CURRENCY CURR 15   2   Value of Immediate Cancellations  
142 LINEITEMVOIDCNT /POSDW/LINEITEMVOIDCOUNT /POSDW/COUNT INT4 10   0   Number of Line Cancellations  
143 LINEITEMVOIDAMT /POSDW/LINEITEMVOIDAMOUNT /POSDW/CURRENCY CURR 15   2   Value of Line Cancellations  
144 POSTVOIDCNT /POSDW/POSTVOIDCOUNT /POSDW/COUNT INT4 10   0   Number of Transaction Cancellations  
145 POSTVOIDAMT /POSDW/POSTVOIDAMOUNT /POSDW/CURRENCY CURR 15   2   Value of Transaction Cancellations  
146 TERMINATIONCNT /POSDW/TERMINATIONCOUNT /POSDW/COUNT INT4 10   0   Number of Terminations  
147 TERMINATIONAMT /POSDW/TERMINATIONAMOUNT /POSDW/CURRENCY CURR 15   2   Value of Terminations  
148 REPORTCNT /POSDW/REPORTCOUNT /POSDW/COUNT INT4 10   0   Number of Reports  
149 FAILEDLOGONCNT /POSDW/FAILEDLOGONCOUNT /POSDW/COUNT INT4 10   0   Number of Unsuccessful Attempts to Log On  
150 LOGONTIME /POSDW/LOGONTIME /POSDW/COUNT INT4 10   0   Logon Time  
151 RINGTIME /POSDW/RINGTIME /POSDW/COUNT INT4 10   0   Cashier Time  
152 LOCKTIME /POSDW/LOCKTIME /POSDW/COUNT INT4 10   0   Time When Cash Desk Was Locked  
153 IDLETIME /POSDW/IDLETIME /POSDW/COUNT INT4 10   0   Time When Nothing Cashed  
154 SCANNEDITEMCNT /POSDW/SCANNEDITEMCOUNT /POSDW/COUNT INT4 10   0   Number of Scanned Items  
155 SCANNEDITEMAMT /POSDW/SCANNEDITEMAMOUNT /POSDW/CURRENCY CURR 15   2   Value of Scanned Items  
156 OPENDEPARTMNTCNT /POSDW/OPENDEPARTMENTCOUNT /POSDW/COUNT INT4 10   0   Number of Material Group Sales  
157 OPENDEPARTMNTAMT /POSDW/OPENDEPARTMENTAMOUNT /POSDW/CURRENCY CURR 15   2   Value of Material Group Sales  
158 CHECKSOVERCNT /POSDW/CHECKSOVERLIMITCOUNT /POSDW/COUNT INT4 10   0   Number of Checks Over the Limit  
159 CHECKSOVERAMT /POSDW/CHECKSOVERLIMITAMOUNT /POSDW/CURRENCY CURR 15   2   Value of checks over the limit  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 /POSDW/BW_POSCAS DISCTYPEGROUP /POSDW/DISCTG DISCOUNTTYPEGROU KEY 1 CN
2 /POSDW/BW_POSCAS RETAILTYPEGROUP /POSDW/RETTG RETAILTYPEGROUP KEY 1 CN
3 /POSDW/BW_POSCAS TAXTYPEGROUP /POSDW/TAXTG TAXTYPEGROUP KEY 1 CN
4 /POSDW/BW_POSCAS TENDERTYPEGROUP /POSDW/TENDTG TENDERTYPEGROUP KEY 1 CN
5 /POSDW/BW_POSCAS TRANSTYPECODE /POSDW/TRANTY TRANSTYPECODE KEY 1 CN
6 /POSDW/BW_POSCAS TRANSTYPEGROUP /POSDW/TRANTG TRANSTYPEGROUP 1 CN
History
Last changed by/on SAP  20100326 
SAP Release Created in 351