SAP ABAP Table /POSDW/BW_TOTAL (Transfer to BW for Totals 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_TOTAL   Table Relationship Diagram
Short Description Transfer to BW for Totals 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   Sales Totals  
35 .INCLUDE       0   0   Total Sales - Database Fields  
36 .INCLUDE       0   0   Sales Totals - Database Fields (Key Fields)  
37 RETAILTYPECODE /POSDW/RETAILTYPECODE /POSDW/RETAILTYPECODE CHAR 4   0   Sales Item Type *
38 SALESAMOUNT /POSDW/SALESTOTAL /POSDW/CURRENCY CURR 15   2   Actual Retail Value Total  
39 LINEITEMCOUNT /POSDW/LINEITEMCOUNT /POSDW/COUNT INT4 10   0   Number of Sales Items  
40 .INCLUDE       0   0   Sales Totals - Enhanced Fields  
41 RETAILTYPEGROUP /POSDW/RETAILTYPEGROUP /POSDW/RETAILTYPEGROUP CHAR 4   0   Sales Item Type Group /POSDW/RETTG
42 RETAILDEBITFLAG /POSDW/DEBITFLAG /POSDW/DEBITFLAG CHAR 1   0   Debit/Credit Indicator  
43 RETL_ITEM_CAT /POSDW/RETAIL_ITEM_CATEGORY /POSDW/ITEM_CATEGORY CHAR 1   0   Classification of Sales Item: Category *
44 RETL_ITEM_SCAT /POSDW/RETAIL_ITEM_SUBCATEGORY /POSDW/ITEM_SUBCATEGORY CHAR 1   0   Classification of Sales Item: Subcategory *
45 .INCLUDE       0   0   Total Discounts  
46 .INCLUDE       0   0   Total Discounts - Database Fields  
47 .INCLUDE       0   0   Total Discounts - Database Fields (Key Fields)  
48 DISCTYPECODE /POSDW/DISCOUNTTYPECODE /POSDW/DISCOUNTTYPECODE CHAR 4   0   Discount Type *
49 REDUCTIONAMOUNT /POSDW/REDUCTIONTOTAL /POSDW/CURRENCY CURR 15   2   Discount Value Total  
50 DISCCOUNT /POSDW/DISCOUNTCOUNT /POSDW/COUNT INT4 10   0   Number of Discount Items  
51 .INCLUDE       0   0   Total Discounts - Enhanced Fields  
52 DISCTYPEGROUP /POSDW/DISCOUNTTYPEGROUP /POSDW/DISCOUNTTYPEGROUP CHAR 4   0   Discount Type Group /POSDW/DISCTG
53 DISCDEBITFLAG /POSDW/DEBITFLAG /POSDW/DEBITFLAG CHAR 1   0   Debit/Credit Indicator  
54 .INCLUDE       0   0   Total Taxes  
55 .INCLUDE       0   0   Total Taxes - Database Fields  
56 .INCLUDE       0   0   Total Taxes - Database Fields (Key Fields)  
57 TAXTYPECODE /POSDW/TAXTYPECODE /POSDW/TAXTYPECODE CHAR 4   0   Tax Type *
58 TAXAMOUNT /POSDW/TAXTOTAL /POSDW/CURRENCY CURR 15   2   Total Tax Amount  
59 TAXCOUNT /POSDW/TAXCOUNT /POSDW/COUNT INT4 10   0   Number of Tax Items  
60 .INCLUDE       0   0   Total Taxes - Enhanced Fields  
61 TAXINCLUDEDFLAG /POSDW/TAXINCLUDEDFLAG /POSDW/FLAG CHAR 1   0   Indicates Whether Taxes Are Included in Retail Value  
62 TAXTYPEGROUP /POSDW/TAXTYPEGROUP /POSDW/TAXTYPEGROUP CHAR 4   0   Tax Category Group /POSDW/TAXTG
63 TAXDEBITFLAG /POSDW/DEBITFLAG /POSDW/DEBITFLAG CHAR 1   0   Debit/Credit Indicator  
64 .INCLUDE       0   0   Total Means of Payment  
65 .INCLUDE       0   0   Total Means of Payment - Database Fields  
66 .INCLUDE       0   0   Total Means of Payment - Database Fields (Key Fields)  
67 TENDERTYPECODE /POSDW/TENDERTYPECODE /POSDW/TENDERTYPECODE CHAR 4   0   Means of Payment *
68 TENDERAMOUNT /POSDW/TENDERTOTAL /POSDW/CURRENCY CURR 15   2   Total of Means of Payment Values  
69 TENDERCOUNT /POSDW/TENDERCOUNT /POSDW/COUNT INT4 10   0   Number of Means of Payment Items  
70 ACTUALAMOUNT /POSDW/ACTUALAMOUNT /POSDW/CURRENCY CURR 15   2   Actual Amount  
71 SHORTAMOUNT /POSDW/SHORTAMOUNT /POSDW/CURRENCY CURR 15   2   Short Amount  
72 OVERAMOUNT /POSDW/OVERAMOUNT /POSDW/CURRENCY CURR 15   2   Over Amount  
73 REMOVALAMOUNT /POSDW/REMOVALAMOUNT /POSDW/CURRENCY CURR 15   2   Value Removed  
74 REMOVALCOUNT /POSDW/REMOVALCOUNT /POSDW/COUNT INT4 10   0   Number of Cash Removals  
75 BANKAMOUNT /POSDW/BANKAMOUNT /POSDW/CURRENCY CURR 15   2   Amount Transferred to Bank  
76 .INCLUDE       0   0   Total Tender - Enhanced Fields  
77 TENDERTYPEGROUP /POSDW/TENDERTYPEGROUP /POSDW/TENDERTYPEGROUP CHAR 4   0   Payment Means Group /POSDW/TENDTG
78 TENDERDEBITFLAG /POSDW/DEBITFLAG /POSDW/DEBITFLAG CHAR 1   0   Debit/Credit Indicator  
79 TENDER_CAT /POSDW/TENDER_CATEGORY /POSDW/ITEM_CATEGORY CHAR 1   0   Classification of Tender: Category *
80 TENDER_SCAT /POSDW/TENDER_SUBCATEGORY /POSDW/ITEM_SUBCATEGORY CHAR 1   0   Classification of Tender: Subcategory *
81 .INCLUDE       0   0   Cashier Totals  
82 .INCLUDE       0   0   Total Cashiers - Database Fields  
83 TRANSCNT /POSDW/TRANSACTIONCOUNT /POSDW/COUNT INT4 10   0   Number of Transactions  
84 NOSALETRANSCNT /POSDW/NOSALETRANSACTIONCOUNT /POSDW/COUNT INT4 10   0   Number of Void Receipts  
85 IMMEDIATEVOIDCNT /POSDW/IMMEDIATEVOIDCOUNT /POSDW/COUNT INT4 10   0   Number of Immediate Cancellations  
86 IMMEDIATEVOIDAMT /POSDW/IMMEDIATEVOIDAMOUNT /POSDW/CURRENCY CURR 15   2   Value of Immediate Cancellations  
87 LINEITEMVOIDCNT /POSDW/LINEITEMVOIDCOUNT /POSDW/COUNT INT4 10   0   Number of Line Cancellations  
88 LINEITEMVOIDAMT /POSDW/LINEITEMVOIDAMOUNT /POSDW/CURRENCY CURR 15   2   Value of Line Cancellations  
89 POSTVOIDCNT /POSDW/POSTVOIDCOUNT /POSDW/COUNT INT4 10   0   Number of Transaction Cancellations  
90 POSTVOIDAMT /POSDW/POSTVOIDAMOUNT /POSDW/CURRENCY CURR 15   2   Value of Transaction Cancellations  
91 TERMINATIONCNT /POSDW/TERMINATIONCOUNT /POSDW/COUNT INT4 10   0   Number of Terminations  
92 TERMINATIONAMT /POSDW/TERMINATIONAMOUNT /POSDW/CURRENCY CURR 15   2   Value of Terminations  
93 REPORTCNT /POSDW/REPORTCOUNT /POSDW/COUNT INT4 10   0   Number of Reports  
94 FAILEDLOGONCNT /POSDW/FAILEDLOGONCOUNT /POSDW/COUNT INT4 10   0   Number of Unsuccessful Attempts to Log On  
95 LOGONTIME /POSDW/LOGONTIME /POSDW/COUNT INT4 10   0   Logon Time  
96 RINGTIME /POSDW/RINGTIME /POSDW/COUNT INT4 10   0   Cashier Time  
97 LOCKTIME /POSDW/LOCKTIME /POSDW/COUNT INT4 10   0   Time When Cash Desk Was Locked  
98 IDLETIME /POSDW/IDLETIME /POSDW/COUNT INT4 10   0   Time When Nothing Cashed  
99 SCANNEDITEMCNT /POSDW/SCANNEDITEMCOUNT /POSDW/COUNT INT4 10   0   Number of Scanned Items  
100 SCANNEDITEMAMT /POSDW/SCANNEDITEMAMOUNT /POSDW/CURRENCY CURR 15   2   Value of Scanned Items  
101 OPENDEPARTMNTCNT /POSDW/OPENDEPARTMENTCOUNT /POSDW/COUNT INT4 10   0   Number of Material Group Sales  
102 OPENDEPARTMNTAMT /POSDW/OPENDEPARTMENTAMOUNT /POSDW/CURRENCY CURR 15   2   Value of Material Group Sales  
103 CHECKSOVERCNT /POSDW/CHECKSOVERLIMITCOUNT /POSDW/COUNT INT4 10   0   Number of Checks Over the Limit  
104 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_TOTAL DISCTYPEGROUP /POSDW/DISCTG DISCOUNTTYPEGROU KEY 1 CN
2 /POSDW/BW_TOTAL RETAILTYPEGROUP /POSDW/RETTG RETAILTYPEGROUP KEY 1 CN
3 /POSDW/BW_TOTAL TAXTYPEGROUP /POSDW/TAXTG TAXTYPEGROUP KEY 1 CN
4 /POSDW/BW_TOTAL TENDERTYPEGROUP /POSDW/TENDTG TENDERTYPEGROUP KEY 1 CN
5 /POSDW/BW_TOTAL TRANSTYPECODE /POSDW/TRANTY TRANSTYPECODE KEY 1 CN
6 /POSDW/BW_TOTAL TRANSTYPEGROUP /POSDW/TRANTG TRANSTYPEGROUP 1 CN
History
Last changed by/on SAP  20100326 
SAP Release Created in 30B