SAP ABAP Table RSBCT_RPA_TRAN_FIN_MOV (PIPE Extraction: POS Transaction - Financial Transactions)
Hierarchy
☛ BI_CONT (Software Component) Business Intelligence Content
   ⤷ BW-BCT-ISR (Application Component) Retail and Consumer Goods
     ⤷ RS_BCT_RETAIL_POSDW (Package) BW: Content POS Analytics
Basic Data
Table Category INTTAB    Structure 
Structure RSBCT_RPA_TRAN_FIN_MOV   Table Relationship Diagram
Short Description PIPE Extraction: POS Transaction - Financial 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   Transfer to BW for Totals Transactions  
2 .INCLUDE       0   0   Transaction Header for BW  
3 RECORDQUALIFIER /POSDW/RECORDQUALIFIER /POSDW/RECORDQUALIFIER CHAR 4   0   Record Type of Transaction  
4 BWTRANSINDEX /POSDW/BWTRANSINDEX /POSDW/CHAR10ALPHA CHAR 10   0   Transaction Index for BW as Character Field  
5 .INCLUDE       0   0   Transaction  
6 .INCLUDE       0   0   Transaction - Database Fields  
7 .INCLUDE       0   0   Transaction - Database Fields (Key Fields)  
8 RETAILSTOREID /POSDW/RETAILSTOREID /POSDW/RETAILSTOREID CHAR 10   0   Store  
9 BUSINESSDAYDATE /POSDW/BUSINESSDAYDATE /POSDW/DATE DATS 8   0   Posting Date  
10 TRANSTYPECODE /POSDW/TRANSACTIONTYPECODE /POSDW/TRANSACTIONTYPECODE CHAR 4   0   Transaction Type /POSDW/TRANTY
11 WORKSTATIONID /POSDW/WORKSTATIONID /POSDW/WORKSTATIONID CHAR 10   0   POS Number  
12 TRANSNUMBER /POSDW/TRANSACTIONSEQUENCENUMB /POSDW/TRANSACTIONSEQUENCENUMB CHAR 20   0   Transaction Number  
13 BEGINTIMESTAMP /POSDW/BEGINDATETIMESTAMP /POSDW/TIMESTAMP CHAR 14   0   Second in Which Transaction Starts  
14 ENDTIMESTAMP /POSDW/ENDDATETIMESTAMP /POSDW/TIMESTAMP CHAR 14   0   Second in Which Transaction Ends  
15 DEPARTMENT /POSDW/DEPARTMENT /POSDW/CHAR10ALPHA CHAR 10   0   Department  
16 OPERATORQUAL /POSDW/OPERATORQUALIFIER /POSDW/OPERATORQUALIFIER CHAR 1   0   Operator Qualifier  
17 OPERATORID /POSDW/OPERATORID /POSDW/CHAR30ALPHA CHAR 30   0   Cashier Number or Name  
18 TRANSCURRENCY /POSDW/TRANSACTIONCURRENCY WAERS CUKY 5   0   Transaction Currency *
19 PARTNERQUALIFIER /POSDW/PARTNERQUALIFIER /POSDW/PARTNERQUALIFIER CHAR 1   0   Qualifier for Partner Number  
20 PARTNERID /POSDW/PARTNERID /POSDW/CHAR13ALPHA CHAR 13   0   Partner Number  
21 .INCLUDE       0   0   Transaction - Enhanced Fields  
22 TRANSINDEX /POSDW/TRANSINDEX /POSDW/TRANSINDEX INT4 10   0   Transaction Index  
23 NONCOMPFLAG /POSDW/NONCOMPFLAG /POSDW/FLAG CHAR 1   0   Indicator for Non-Comparable Sales  
24 TRANSTYPEGROUP /POSDW/TRANSACTIONTYPEGROUP /POSDW/TRANSACTIONTYPEGROUP CHAR 4   0   Transaction Type Group /POSDW/TRANTG
25 BUSINESSTYPE /POSDW/BUSINESSTYPE /POSDW/BUSINESSTYPE CHAR 1   0   Business Transaction  
26 REVERSALFLAG /POSDW/REVERSALFLAG /POSDW/FLAG CHAR 1   0   Reversal Indicator  
27 TRANSDEBITFLAG /POSDW/DEBITFLAG /POSDW/DEBITFLAG CHAR 1   0   Debit/Credit Indicator  
28 PLANT /POSDW/PLANT CHAR4 CHAR 4   0   Plant  
29 STORECURRENCY /POSDW/STORECURRENCY WAERS CUKY 5   0   Local Currency *
30 PLANTCUSTOMER /POSDW/PLANTCUSTOMER /POSDW/CHAR10ALPHA CHAR 10   0   Customer Number of Plant  
31 BUSINESSLOCATION /POSDW/BUSINESSLOCATION /POSDW/CHAR10ALPHA CHAR 10   0   Business Location Identifier (IS-OIL/MRN)  
32 TURNOVER /POSDW/TRANSTURNOVER /POSDW/CURRENCY CURR 15   2   Sales Totals Per Transaction  
33 INDEXCURRENCY /POSDW/INDEXCURRENCY WAERS CUKY 5   0   Currency for Sales Totals *
34 VERSION /POSDW/TRANSACTION_VERSION /POSDW/TRANSACTION_VERSION INT1 3   0   Version of POS Transaction  
35 .INCLUDE       0   0   Sales Totals  
36 .INCLUDE       0   0   Total Sales - Database Fields  
37 .INCLUDE       0   0   Sales Totals - Database Fields (Key Fields)  
38 RETAILTYPECODE /POSDW/RETAILTYPECODE /POSDW/RETAILTYPECODE CHAR 4   0   Sales Item Type *
39 SALESAMOUNT /POSDW/SALESTOTAL /POSDW/CURRENCY CURR 15   2   Actual Retail Value Total  
40 LINEITEMCOUNT /POSDW/LINEITEMCOUNT /POSDW/COUNT INT4 10   0   Number of Sales Items  
41 .INCLUDE       0   0   Sales Totals - Enhanced Fields  
42 RETAILTYPEGROUP /POSDW/RETAILTYPEGROUP /POSDW/RETAILTYPEGROUP CHAR 4   0   Sales Item Type Group /POSDW/RETTG
43 RETAILDEBITFLAG /POSDW/DEBITFLAG /POSDW/DEBITFLAG CHAR 1   0   Debit/Credit Indicator  
44 RETL_ITEM_CAT /POSDW/RETAIL_ITEM_CATEGORY /POSDW/ITEM_CATEGORY CHAR 1   0   Classification of Sales Item: Category *
45 RETL_ITEM_SCAT /POSDW/RETAIL_ITEM_SUBCATEGORY /POSDW/ITEM_SUBCATEGORY CHAR 1   0   Classification of Sales Item: Subcategory *
46 .INCLUDE       0   0   Total Discounts  
47 .INCLUDE       0   0   Total Discounts - Database Fields  
48 .INCLUDE       0   0   Total Discounts - Database Fields (Key Fields)  
49 DISCTYPECODE /POSDW/DISCOUNTTYPECODE /POSDW/DISCOUNTTYPECODE CHAR 4   0   Discount Type *
50 REDUCTIONAMOUNT /POSDW/REDUCTIONTOTAL /POSDW/CURRENCY CURR 15   2   Discount Value Total  
51 DISCCOUNT /POSDW/DISCOUNTCOUNT /POSDW/COUNT INT4 10   0   Number of Discount Items  
52 .INCLUDE       0   0   Total Discounts - Enhanced Fields  
53 DISCTYPEGROUP /POSDW/DISCOUNTTYPEGROUP /POSDW/DISCOUNTTYPEGROUP CHAR 4   0   Discount Type Group /POSDW/DISCTG
54 DISCDEBITFLAG /POSDW/DEBITFLAG /POSDW/DEBITFLAG CHAR 1   0   Debit/Credit Indicator  
55 .INCLUDE       0   0   Total Taxes  
56 .INCLUDE       0   0   Total Taxes - Database Fields  
57 .INCLUDE       0   0   Total Taxes - Database Fields (Key Fields)  
58 TAXTYPECODE /POSDW/TAXTYPECODE /POSDW/TAXTYPECODE CHAR 4   0   Tax Type *
59 TAXAMOUNT /POSDW/TAXTOTAL /POSDW/CURRENCY CURR 15   2   Total Tax Amount  
60 TAXCOUNT /POSDW/TAXCOUNT /POSDW/COUNT INT4 10   0   Number of Tax Items  
61 .INCLUDE       0   0   Total Taxes - Enhanced Fields  
62 TAXINCLUDEDFLAG /POSDW/TAXINCLUDEDFLAG /POSDW/FLAG CHAR 1   0   Indicates Whether Taxes Are Included in Retail Value  
63 TAXTYPEGROUP /POSDW/TAXTYPEGROUP /POSDW/TAXTYPEGROUP CHAR 4   0   Tax Category Group /POSDW/TAXTG
64 TAXDEBITFLAG /POSDW/DEBITFLAG /POSDW/DEBITFLAG CHAR 1   0   Debit/Credit Indicator  
65 .INCLUDE       0   0   Total Means of Payment  
66 .INCLUDE       0   0   Total Means of Payment - Database Fields  
67 .INCLUDE       0   0   Total Means of Payment - Database Fields (Key Fields)  
68 TENDERTYPECODE /POSDW/TENDERTYPECODE /POSDW/TENDERTYPECODE CHAR 4   0   Means of Payment *
69 TENDERAMOUNT /POSDW/TENDERTOTAL /POSDW/CURRENCY CURR 15   2   Total of Means of Payment Values  
70 TENDERCOUNT /POSDW/TENDERCOUNT /POSDW/COUNT INT4 10   0   Number of Means of Payment Items  
71 ACTUALAMOUNT /POSDW/ACTUALAMOUNT /POSDW/CURRENCY CURR 15   2   Actual Amount  
72 SHORTAMOUNT /POSDW/SHORTAMOUNT /POSDW/CURRENCY CURR 15   2   Short Amount  
73 OVERAMOUNT /POSDW/OVERAMOUNT /POSDW/CURRENCY CURR 15   2   Over Amount  
74 REMOVALAMOUNT /POSDW/REMOVALAMOUNT /POSDW/CURRENCY CURR 15   2   Value Removed  
75 REMOVALCOUNT /POSDW/REMOVALCOUNT /POSDW/COUNT INT4 10   0   Number of Cash Removals  
76 BANKAMOUNT /POSDW/BANKAMOUNT /POSDW/CURRENCY CURR 15   2   Amount Transferred to Bank  
77 .INCLUDE       0   0   Total Tender - Enhanced Fields  
78 TENDERTYPEGROUP /POSDW/TENDERTYPEGROUP /POSDW/TENDERTYPEGROUP CHAR 4   0   Payment Means Group /POSDW/TENDTG
79 TENDERDEBITFLAG /POSDW/DEBITFLAG /POSDW/DEBITFLAG CHAR 1   0   Debit/Credit Indicator  
80 TENDER_CAT /POSDW/TENDER_CATEGORY /POSDW/ITEM_CATEGORY CHAR 1   0   Classification of Tender: Category *
81 TENDER_SCAT /POSDW/TENDER_SUBCATEGORY /POSDW/ITEM_SUBCATEGORY CHAR 1   0   Classification of Tender: Subcategory *
82 .INCLUDE       0   0   Cashier Totals  
83 .INCLUDE       0   0   Total Cashiers - Database Fields  
84 TRANSCNT /POSDW/TRANSACTIONCOUNT /POSDW/COUNT INT4 10   0   Number of Transactions  
85 NOSALETRANSCNT /POSDW/NOSALETRANSACTIONCOUNT /POSDW/COUNT INT4 10   0   Number of Void Receipts  
86 IMMEDIATEVOIDCNT /POSDW/IMMEDIATEVOIDCOUNT /POSDW/COUNT INT4 10   0   Number of Immediate Cancellations  
87 IMMEDIATEVOIDAMT /POSDW/IMMEDIATEVOIDAMOUNT /POSDW/CURRENCY CURR 15   2   Value of Immediate Cancellations  
88 LINEITEMVOIDCNT /POSDW/LINEITEMVOIDCOUNT /POSDW/COUNT INT4 10   0   Number of Line Cancellations  
89 LINEITEMVOIDAMT /POSDW/LINEITEMVOIDAMOUNT /POSDW/CURRENCY CURR 15   2   Value of Line Cancellations  
90 POSTVOIDCNT /POSDW/POSTVOIDCOUNT /POSDW/COUNT INT4 10   0   Number of Transaction Cancellations  
91 POSTVOIDAMT /POSDW/POSTVOIDAMOUNT /POSDW/CURRENCY CURR 15   2   Value of Transaction Cancellations  
92 TERMINATIONCNT /POSDW/TERMINATIONCOUNT /POSDW/COUNT INT4 10   0   Number of Terminations  
93 TERMINATIONAMT /POSDW/TERMINATIONAMOUNT /POSDW/CURRENCY CURR 15   2   Value of Terminations  
94 REPORTCNT /POSDW/REPORTCOUNT /POSDW/COUNT INT4 10   0   Number of Reports  
95 FAILEDLOGONCNT /POSDW/FAILEDLOGONCOUNT /POSDW/COUNT INT4 10   0   Number of Unsuccessful Attempts to Log On  
96 LOGONTIME /POSDW/LOGONTIME /POSDW/COUNT INT4 10   0   Logon Time  
97 RINGTIME /POSDW/RINGTIME /POSDW/COUNT INT4 10   0   Cashier Time  
98 LOCKTIME /POSDW/LOCKTIME /POSDW/COUNT INT4 10   0   Time When Cash Desk Was Locked  
99 IDLETIME /POSDW/IDLETIME /POSDW/COUNT INT4 10   0   Time When Nothing Cashed  
100 SCANNEDITEMCNT /POSDW/SCANNEDITEMCOUNT /POSDW/COUNT INT4 10   0   Number of Scanned Items  
101 SCANNEDITEMAMT /POSDW/SCANNEDITEMAMOUNT /POSDW/CURRENCY CURR 15   2   Value of Scanned Items  
102 OPENDEPARTMNTCNT /POSDW/OPENDEPARTMENTCOUNT /POSDW/COUNT INT4 10   0   Number of Material Group Sales  
103 OPENDEPARTMNTAMT /POSDW/OPENDEPARTMENTAMOUNT /POSDW/CURRENCY CURR 15   2   Value of Material Group Sales  
104 CHECKSOVERCNT /POSDW/CHECKSOVERLIMITCOUNT /POSDW/COUNT INT4 10   0   Number of Checks Over the Limit  
105 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 RSBCT_RPA_TRAN_FIN_MOV DISCTYPEGROUP /POSDW/DISCTG DISCOUNTTYPEGROU KEY 1 CN
2 RSBCT_RPA_TRAN_FIN_MOV RETAILTYPEGROUP /POSDW/RETTG RETAILTYPEGROUP KEY 1 CN
3 RSBCT_RPA_TRAN_FIN_MOV TAXTYPEGROUP /POSDW/TAXTG TAXTYPEGROUP KEY 1 CN
4 RSBCT_RPA_TRAN_FIN_MOV TENDERTYPEGROUP /POSDW/TENDTG TENDERTYPEGROUP KEY 1 CN
5 RSBCT_RPA_TRAN_FIN_MOV TRANSTYPECODE /POSDW/TRANTY TRANSTYPECODE KEY 1 CN
6 RSBCT_RPA_TRAN_FIN_MOV TRANSTYPEGROUP /POSDW/TRANTG TRANSTYPEGROUP 1 CN
History
Last changed by/on SAP  20100326 
SAP Release Created in 30B