SAP ABAP Table /POSDW/BW_RETAIL_CONTROL (Transfer to BW for Sales and Control Transactions)
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_RETAIL_CONTROL   Table Relationship Diagram
Short Description Transfer to BW for Sales and Control Transactions    
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   Transaction Header for BW  
2 RECORDQUALIFIER /POSDW/RECORDQUALIFIER /POSDW/RECORDQUALIFIER CHAR 4   0   Record Type of Transaction  
3 BWTRANSINDEX /POSDW/BWTRANSINDEX /POSDW/CHAR10ALPHA CHAR 10   0   Transaction Index for BW as Character Field  
4 .INCLUDE       0   0   Transaction  
5 .INCLUDE       0   0   Transaction - Database Fields  
6 .INCLUDE       0   0   Transaction - Database Fields (Key Fields)  
7 RETAILSTOREID /POSDW/RETAILSTOREID /POSDW/RETAILSTOREID CHAR 10   0   Store  
8 BUSINESSDAYDATE /POSDW/BUSINESSDAYDATE /POSDW/DATE DATS 8   0   Posting Date  
9 TRANSTYPECODE /POSDW/TRANSACTIONTYPECODE /POSDW/TRANSACTIONTYPECODE CHAR 4   0   Transaction Type /POSDW/TRANTY
10 WORKSTATIONID /POSDW/WORKSTATIONID /POSDW/WORKSTATIONID CHAR 10   0   POS Number  
11 TRANSNUMBER /POSDW/TRANSACTIONSEQUENCENUMB /POSDW/TRANSACTIONSEQUENCENUMB CHAR 20   0   Transaction Number  
12 BEGINTIMESTAMP /POSDW/BEGINDATETIMESTAMP /POSDW/TIMESTAMP CHAR 14   0   Second in Which Transaction Starts  
13 ENDTIMESTAMP /POSDW/ENDDATETIMESTAMP /POSDW/TIMESTAMP CHAR 14   0   Second in Which Transaction Ends  
14 DEPARTMENT /POSDW/DEPARTMENT /POSDW/CHAR10ALPHA CHAR 10   0   Department  
15 OPERATORQUAL /POSDW/OPERATORQUALIFIER /POSDW/OPERATORQUALIFIER CHAR 1   0   Operator Qualifier  
16 OPERATORID /POSDW/OPERATORID /POSDW/CHAR30ALPHA CHAR 30   0   Cashier Number or Name  
17 TRANSCURRENCY /POSDW/TRANSACTIONCURRENCY WAERS CUKY 5   0   Transaction Currency *
18 PARTNERQUALIFIER /POSDW/PARTNERQUALIFIER /POSDW/PARTNERQUALIFIER CHAR 1   0   Qualifier for Partner Number  
19 PARTNERID /POSDW/PARTNERID /POSDW/CHAR13ALPHA CHAR 13   0   Partner Number  
20 .INCLUDE       0   0   Transaction - Enhanced Fields  
21 TRANSINDEX /POSDW/TRANSINDEX /POSDW/TRANSINDEX INT4 10   0   Transaction Index  
22 NONCOMPFLAG /POSDW/NONCOMPFLAG /POSDW/FLAG CHAR 1   0   Indicator for Non-Comparable Sales  
23 TRANSTYPEGROUP /POSDW/TRANSACTIONTYPEGROUP /POSDW/TRANSACTIONTYPEGROUP CHAR 4   0   Transaction Type Group /POSDW/TRANTG
24 BUSINESSTYPE /POSDW/BUSINESSTYPE /POSDW/BUSINESSTYPE CHAR 1   0   Business Transaction  
25 REVERSALFLAG /POSDW/REVERSALFLAG /POSDW/FLAG CHAR 1   0   Reversal Indicator  
26 TRANSDEBITFLAG /POSDW/DEBITFLAG /POSDW/DEBITFLAG CHAR 1   0   Debit/Credit Indicator  
27 PLANT /POSDW/PLANT CHAR4 CHAR 4   0   Plant  
28 STORECURRENCY /POSDW/STORECURRENCY WAERS CUKY 5   0   Local Currency *
29 PLANTCUSTOMER /POSDW/PLANTCUSTOMER /POSDW/CHAR10ALPHA CHAR 10   0   Customer Number of Plant  
30 BUSINESSLOCATION /POSDW/BUSINESSLOCATION /POSDW/CHAR10ALPHA CHAR 10   0   Business Location Identifier (IS-OIL/MRN)  
31 TURNOVER /POSDW/TRANSTURNOVER /POSDW/CURRENCY CURR 15   2   Sales Totals Per Transaction  
32 INDEXCURRENCY /POSDW/INDEXCURRENCY WAERS CUKY 5   0   Currency for Sales Totals *
33 VERSION /POSDW/TRANSACTION_VERSION /POSDW/TRANSACTION_VERSION INT1 3   0   Version of POS Transaction  
34 .INCLUDE       0   0   Other Transaction Data  
35 .INCLUDE       0   0   Other Transaction Data - Database Fields  
36 TRAININGFLAG /POSDW/TRAININGFLAG /POSDW/FLAG CHAR 1   0   Training Transaction Indicator  
37 KEYEDOFFLINEFLAG /POSDW/KEYEDOFFLINEFLAG /POSDW/FLAG CHAR 1   0   Transaction at Cash Desk Without Connection to Cash Server  
38 TRANSREASONCODE /POSDW/TRANSACTIONREASONCODE /POSDW/REASONCODE CHAR 4   0   Reason for POS Transaction *
39 .INCLUDE       0   0   Sales Item Data  
40 .INCLUDE       0   0   Sales Item Data - Database Fields  
41 .INCLUDE       0   0   Salres Item Data - Database Fields (Key)  
42 RETAILNUMBER /POSDW/RETAILSEQUENCENUMBER /POSDW/SEQUENCENUMBER CHAR 10   0   Sales Item Number  
43 RETAILTYPECODE /POSDW/RETAILTYPECODE /POSDW/RETAILTYPECODE CHAR 4   0   Sales Item Type /POSDW/RETTY
44 RETAILREASONCODE /POSDW/RETAILREASONCODE /POSDW/REASONCODE CHAR 4   0   Reason for Sales Transaction *
45 ITEMIDQUALIFIER /POSDW/ITEMIDQUALIFIER /POSDW/ITEMIDQUALIFIER CHAR 1   0   Qualifier for Article Identifier  
46 ITEMID /POSDW/ITEMID /POSDW/ITEMID CHAR 18   0   Article Identifier  
47 RETAILQUANTITY /POSDW/RETAILQUANTITY /POSDW/QUANTITY QUAN 13   3   Quantity in Sales Unit  
48 SALESUOM /POSDW/SALESUNITOFMEASURE MEINS UNIT 3   0   Sales Unit T006
49 SALESAMOUNT /POSDW/SALESAMOUNT /POSDW/CURRENCY CURR 15   2   Actual Retail Value  
50 NORMALSALESAMT /POSDW/NORMALSALESAMOUNT /POSDW/CURRENCY CURR 15   2   Normal Sales Value  
51 COST /POSDW/COST /POSDW/CURRENCY CURR 15   2   Costs  
52 BATCHID /POSDW/BATCHID /POSDW/CHAR10ALPHA CHAR 10   0   Batch  
53 SERIALNUMBER /POSDW/SERIALNUMBER /POSDW/CHAR25ALPHA CHAR 25   0   Serial Number  
54 PROMOTIONID /POSDW/PROMOTIONID /POSDW/CHAR10ALPHA CHAR 10   0   Promotion Number  
55 ENTRYMETHODCODE /POSDW/ITEMIDENTRYMETHODCODE   CHAR 4   0   Entry Method  
56 ACTUALUNITPRICE /POSDW/ACTUALUNITPRICE /POSDW/CURRENCY CURR 15   2   Sales Price of Article per Unit  
57 UNITS /POSDW/UNITS /POSDW/QUANTITY QUAN 13   3   Sales Quantity  
58 SCANTIME /POSDW/SCANTIME /POSDW/TIMESTAMP CHAR 14   0   Timestamp of an retail line item scanned  
59 .INCLUDE       0   0   Sales Item Data - Enhanced Fields  
60 MATERIALNUMBER /POSDW/MATERIALNUMBER MATNR CHAR 18   0   Material Number  
61 MERCHANDISECAT /POSDW/MERCHANDISECATEGORY MATKL CHAR 9   0   Material Group *
62 BASEQUANTITY /POSDW/BASEQUANTITY /POSDW/QUANTITY QUAN 13   3   Quantity in Base Unit of Measure  
63 BASEUOM /POSDW/BASEUNITOFMEASURE MEINS UNIT 3   0   Base Unit of Measure T006
64 RETAILTYPEGROUP /POSDW/RETAILTYPEGROUP /POSDW/RETAILTYPEGROUP CHAR 4   0   Sales Item Type Group *
65 RETAILDEBITFLAG /POSDW/DEBITFLAG /POSDW/DEBITFLAG CHAR 1   0   Debit/Credit Indicator  
66 RETAILREASONGRP /POSDW/REASONGROUP /POSDW/REASONGROUP CHAR 4   0   Group for Reasons /POSDW/REASG
67 RETL_ITEM_CAT /POSDW/RETAIL_ITEM_CATEGORY /POSDW/ITEM_CATEGORY CHAR 1   0   Classification of Sales Item: Category *
68 RETL_ITEM_SCAT /POSDW/RETAIL_ITEM_SUBCATEGORY /POSDW/ITEM_SUBCATEGORY CHAR 1   0   Classification of Sales Item: Subcategory *
69 DISTDISC /POSDW/DISTDISC /POSDW/CURRENCY CURR 15   2   Distributed Header Discount  
70 DISTTAX /POSDW/DISTTAX /POSDW/CURRENCY CURR 15   2   Distributed Header Tax  
71 DISTTENDER /POSDW/DISTTENDER /POSDW/CURRENCY CURR 15   2   Distributed Means of Payment  
72 .INCLUDE       0   0   Discounts  
73 .INCLUDE       0   0   Discounts - Database Fields  
74 .INCLUDE       0   0   Discounts - Database Fields (Key Fields)  
75 DISCNUMBER /POSDW/DISCOUNTSEQUENCENUMBER /POSDW/SEQUENCENUMBER CHAR 10   0   Discount Item Number  
76 DISCTYPECODE /POSDW/DISCOUNTTYPECODE /POSDW/DISCOUNTTYPECODE CHAR 4   0   Discount Type /POSDW/DISCTY
77 DISCREASONCODE /POSDW/DISCOUNTREASONCODE /POSDW/REASONCODE CHAR 4   0   Discount Reason *
78 REDUCTIONAMOUNT /POSDW/REDUCTIONAMOUNT /POSDW/CURRENCY CURR 15   2   Discount Value  
79 DISCACCOUNT /POSDW/STFINLEDGERACCOUNTID /POSDW/ACCOUNT CHAR 10   0   Account  
80 DISCID /POSDW/DISCOUNTID /POSDW/CHAR32ALPHA CHAR 32   0   Discount Identification  
81 DISCIDQUALIFIER /POSDW/DISCIDQUALIFIER /POSDW/DISCIDQUALIFIER CHAR 1   0   Qualifier for Discount Indicator  
82 BONUSBUYID /POSDW/BONUSBUYID /POSDW/BONUSBUYID CHAR 20   0   Bonus Buy Indicator  
83 OFFERID /POSDW/OFFERID /POSDW/OFFERID CHAR 36   0   Offer ID  
84 .INCLUDE       0   0   Discounts - Enhanced Fields  
85 DISCTYPEGROUP /POSDW/DISCOUNTTYPEGROUP /POSDW/DISCOUNTTYPEGROUP CHAR 4   0   Discount Type Group /POSDW/DISCTG
86 DISCREASONGROUP /POSDW/DISCOUNTREASONGROUP /POSDW/REASONGROUP CHAR 4   0   Discount Reason Group /POSDW/REASG
87 DISCDEBITFLAG /POSDW/DEBITFLAG /POSDW/DEBITFLAG CHAR 1   0   Debit/Credit Indicator  
88 .INCLUDE       0   0   Taxes  
89 .INCLUDE       0   0   Taxes - Database Fields  
90 .INCLUDE       0   0   Taxes - Database Fields (Key Fields)  
91 TAXNUMBER /POSDW/TAXSEQUENCENUMBER /POSDW/SEQUENCENUMBER CHAR 10   0   Tax Item Number  
92 TAXTYPECODE /POSDW/TAXTYPECODE /POSDW/TAXTYPECODE CHAR 4   0   Tax Type *
93 TAXAMOUNT /POSDW/TAXAMOUNT /POSDW/CURRENCY CURR 15   2   Tax Amount  
94 .INCLUDE       0   0   Taxes - Enhanced Fields  
95 TAXINCLUDEDFLAG /POSDW/TAXINCLUDEDFLAG /POSDW/FLAG CHAR 1   0   Indicates Whether Taxes Are Included in Retail Value  
96 TAXTYPEGROUP /POSDW/TAXTYPEGROUP /POSDW/TAXTYPEGROUP CHAR 4   0   Tax Category Group /POSDW/TAXTG
97 TAXDEBITFLAG /POSDW/DEBITFLAG /POSDW/DEBITFLAG CHAR 1   0   Debit/Credit Indicator  
98 .INCLUDE       0   0   Commission  
99 .INCLUDE       0   0   Commission - Database Fields  
100 COMMNUMBER /POSDW/COMMISIONSEQUENCENUMBER /POSDW/SEQUENCENUMBER CHAR 10   0   Commission Item Number  
101 COMMEMPLOYEEQUAL /POSDW/COMMISSIONEMPLOYEEQUAL /POSDW/EMPLOYEEQUALIFIER CHAR 1   0   Salesperson Qualifier  
102 COMMEMPLOYEEID /POSDW/COMMISSIONEMPLOYEEID /POSDW/CHAR30ALPHA CHAR 30   0   Number or Name of Salesperson  
103 COMMAMOUNT /POSDW/COMMISSIONAMOUNT /POSDW/CURRENCY CURR 15   2   Commission Amount  
104 .INCLUDE       0   0   Means of Payment  
105 .INCLUDE       0   0   Means of Payment - Database Fields  
106 .INCLUDE       0   0   Means of Payment - Database Fields (Key Fields)  
107 TENDERNUMBER /POSDW/TENDERSEQUENCENUMBER /POSDW/SEQUENCENUMBER CHAR 10   0   Tender Item Number  
108 TENDERTYPECODE /POSDW/TENDERTYPECODE /POSDW/TENDERTYPECODE CHAR 4   0   Means of Payment *
109 TENDERAMOUNT /POSDW/TENDERAMOUNT /POSDW/CURRENCY CURR 15   2   Tender Value  
110 TENDERCURRENCY /POSDW/TENDERCURRENCY WAERS CUKY 5   0   Tender Currency *
111 TENDERID /POSDW/TENDERID /POSDW/CHAR32ALPHA CHAR 32   0   Tender Identifier  
112 ACCOUNTNUMBER /POSDW/ACCOUNTNUMBER /POSDW/ACCOUNT20 CHAR 20   0   Cash Account  
113 REFERENCEID /POSDW/REFERENCEID /POSDW/REFERENCEID CHAR 35   0   Reference Number  
114 .INCLUDE       0   0   Tender - Enhanced Fields  
115 TENDERTYPEGROUP /POSDW/TENDERTYPEGROUP /POSDW/TENDERTYPEGROUP CHAR 4   0   Payment Means Group /POSDW/TENDTG
116 TENDERDEBITFLAG /POSDW/DEBITFLAG /POSDW/DEBITFLAG CHAR 1   0   Debit/Credit Indicator  
117 TENDER_CAT /POSDW/TENDER_CATEGORY /POSDW/ITEM_CATEGORY CHAR 1   0   Classification of Tender: Category *
118 TENDER_SCAT /POSDW/TENDER_SUBCATEGORY /POSDW/ITEM_SUBCATEGORY CHAR 1   0   Classification of Tender: Subcategory *
119 .INCLUDE       0   0   Credit Card Settlement - Field Include  
120 .INCLUDE       0   0   Credit Card Settlement - Database Fields  
121 PAYMENTCARD /POSDW/PAYMENTCARD /POSDW/TYPECODE CHAR 4   0   Credit Card Identification  
122 CARDNUMBER /POSDW/CARDNUMBER /POSDW/CARDNUMBER CHAR 25   0   Card Number  
123 CARDNUMBERSUFFIX /POSDW/CARDNUMBERSUFFIX /POSDW/CARDNUMBERSUFFIX CHAR 6   0   Card Sequence Number  
124 EXPIRATIONDATE /POSDW/CARDEXPIRATIONDATE /POSDW/DATE DATS 8   0   Expiry Date of Card  
125 CARDHOLDERNAME /POSDW/CARDHOLDERNAME /POSDW/CARDHOLDERNAME CHAR 40   0   Card Holder  
126 ADJUDICATIONCODE /POSDW/ADJUDICATIONCODE /POSDW/ADJUDICATIONCODE CHAR 25   0   Authorization Number  
127 AUTHTERMID /POSDW/AUTHORIZINGTERMID CHAR25 CHAR 25   0   Terminal  
128 AUTHDATETIME /POSDW/AUTHORIZATIONDATETIME /POSDW/TIMESTAMP CHAR 14   0   Authorization Time  
129 AUTHMETHODCODE /POSDW/AUTHORIZATIONMETHODCODE /POSDW/TYPECODE CHAR 4   0   Authorization Method  
130 MEDIAISSUERID /POSDW/MEDIAISSUERID /POSDW/MEDIAISSUERID CHAR 25   0   Card Issuer  
131 REACTIONCODE /POSDW/REACTIONCODE   CHAR 1   0   Reaction Code for Authorization  
132 LIMITAMOUNT /POSDW/LIMITAMOUNT /POSDW/FLAG CHAR 1   0   Flag for Restricted Value  
133 CARDSWIPEDKEYED /POSDW/CARDNUMBERSWIPEDORKEYED /POSDW/CHAR04ALPHA CHAR 4   0   Input Method  
134 HOSTAUTHORIZED /POSDW/HOSTAUTHORIZED /POSDW/FLAG CHAR 1   0   Indicates Whether Settlement Is Complete  
135 AUTHCODE /POSDW/AUTHORIZATIONCODE CHAR15 CHAR 15   0   Reference Number of Clearing House  
136 PROVIDERID /POSDW/PROVIDERID /POSDW/CHAR10ALPHA CHAR 10   0   POS Transaction Point of Receipt  
137 FORCEONLINE /POSDW/FORCEONLINE /POSDW/FLAG CHAR 1   0   Flag Whether Authorization Should Be Transferred  
138 VALIDFROMDATE /POSDW/VALIDFROMDATE /POSDW/DATE DATS 8   0   Payment Cards: Valid From  
139 BLACKLISTVERSION /POSDW/BLACKLISTVERSION CHAR20 CHAR 20   0   Version of Black List  
140 BLACKLISTDATE /POSDW/BLACKLISTDATE /POSDW/DATE DATS 8   0   Date of Black List  
141 REQUESTEDAMOUNT /POSDW/REQUESTEDAMOUNT /POSDW/CURRENCY CURR 15   2   Payment Cards: Authorized Amount  
142 CARDTYPE /POSDW/CARDTYPE /POSDW/CHAR02ALPHA CHAR 2   0   Eurocheque Card Type  
143 CARDGUID /POSDW/CARDGUID SYSUUID RAW 16   0   GUID of a Payment Card  
144 ENCTYPE /POSDW/ENCTYPE /POSDW/ENCTYPE CHAR 1   0   Type of Encryption  
145 CRYPTICHASH /POSDW/CRYPTICHASH /POSDW/CRYPTICHASH CHAR 40   0   Hash Value of Payment Card Number  
146 .INCLUDE       0   0   Bank Details  
147 .INCLUDE       0   0   Bank Details - Database Fields  
148 ACCOUNTHOLDER /POSDW/ACCOUNTHOLDERNAME   CHAR 40   0   Account Holder Name  
149 BANKCODE /POSDW/BANKCODE /POSDW/CHAR15ALPHA CHAR 15   0   Bank Number  
150 BANKACCOUNT /POSDW/BANKACCOUNT /POSDW/ACCOUNT25 CHAR 25   0   Account Number  
151 INDUSTRYMAINKEY /POSDW/INDUSTRYMAINKEY /POSDW/CHAR02ALPHA CHAR 2   0   Industry Main Key  
152 ECSEPERATOR /POSDW/ECSEPERATOR   CHAR 1   0   Field Separator  
153 .INCLUDE       0   0   Fleet Information  
154 .INCLUDE       0   0   Fleet Information - Database Fields  
155 DRIVERID /POSDW/DRIVERID /POSDW/CHAR06ALPHA CHAR 6   0   Number of Driver (for Fleet Cards)  
156 VEHICLEID /POSDW/VEHICLEID /POSDW/CHAR06ALPHA CHAR 6   0   Number of Vehicle (Fleet Cards)  
157 ODOMETERREADING /POSDW/ODOMETERREADING   NUMC 6   0   Odometer Reading  
158 CARDINFORMATION /POSDW/CARDINFORMATION /POSDW/CHAR20ALPHA CHAR 20   0   Additional Data for Payment Cards  
159 LINEITEMCOUNT /POSDW/LINEITEMCOUNT /POSDW/COUNT INT4 10   0   Number of Sales Items  
160 TOTALSALESAMOUNT /POSDW/SALESTOTAL /POSDW/CURRENCY CURR 15   2   Actual Retail Value Total  
161 VOIDFLAG /POSDW/VOIDFLAG /POSDW/FLAG CHAR 1   0   Indicator for Cancelled Items  
162 REDUCTIONAMOUNTN /POSDW/REDUCTIONAMOUNT_NET /POSDW/CURRENCY CURR 15   2   Discount Value (Net)  
163 REDUCTIONAMOUNTG /POSDW/REDUCTIONAMOUNT_GROSS /POSDW/CURRENCY CURR 15   2   Discount Value (Gross)  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 /POSDW/BW_RETAIL_CONTROL BASEUOM T006 MSEHI KEY 1 CN
2 /POSDW/BW_RETAIL_CONTROL DISCREASONGROUP /POSDW/REASG REASONGROUP KEY 1 CN
3 /POSDW/BW_RETAIL_CONTROL DISCTYPECODE /POSDW/DISCTY DISCOUNTTYPECODE KEY 1 CN
4 /POSDW/BW_RETAIL_CONTROL DISCTYPEGROUP /POSDW/DISCTG DISCOUNTTYPEGROU KEY 1 CN
5 /POSDW/BW_RETAIL_CONTROL RETAILREASONGRP /POSDW/REASG REASONGROUP KEY 1 CN
6 /POSDW/BW_RETAIL_CONTROL RETAILTYPECODE /POSDW/RETTY RETAILTYPECODE KEY 1 CN
7 /POSDW/BW_RETAIL_CONTROL SALESUOM T006 MSEHI KEY    
8 /POSDW/BW_RETAIL_CONTROL TAXTYPEGROUP /POSDW/TAXTG TAXTYPEGROUP KEY 1 CN
9 /POSDW/BW_RETAIL_CONTROL TENDERTYPEGROUP /POSDW/TENDTG TENDERTYPEGROUP KEY 1 CN
10 /POSDW/BW_RETAIL_CONTROL TRANSTYPECODE /POSDW/TRANTY TRANSTYPECODE KEY 1 CN
11 /POSDW/BW_RETAIL_CONTROL TRANSTYPEGROUP /POSDW/TRANTG TRANSTYPEGROUP 1 CN
History
Last changed by/on SAP  20100820 
SAP Release Created in 30B