SAP ABAP Table /POSDW/TRANSACTION_INT (POS Transaction)
Hierarchy
BI_CONT (Software Component) Business Intelligence Content
   BW-BCT-ISR-PIP (Application Component) Point of Sales Inbound Processing Engine
     /POSDW/CORE (Package) PIPE Processing Control
Basic Data
Table Category INTTAB    Structure 
Structure /POSDW/TRANSACTION_INT   Table Relationship Diagram
Short Description POS Transaction    
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  
2 .INCLUDE       0   0   Transaction  
3 .INCLUDE       0   0   Transaction - Database Fields  
4 .INCLUDE       0   0   Transaction - Database Fields (Key Fields)  
5 RETAILSTOREID /POSDW/RETAILSTOREID /POSDW/RETAILSTOREID CHAR 10   0   Store  
6 BUSINESSDAYDATE /POSDW/BUSINESSDAYDATE /POSDW/DATE DATS 8   0   Posting Date  
7 TRANSTYPECODE /POSDW/TRANSACTIONTYPECODE /POSDW/TRANSACTIONTYPECODE CHAR 4   0   Transaction Type /POSDW/TRANTY
8 WORKSTATIONID /POSDW/WORKSTATIONID /POSDW/WORKSTATIONID CHAR 10   0   POS Number  
9 TRANSNUMBER /POSDW/TRANSACTIONSEQUENCENUMB /POSDW/TRANSACTIONSEQUENCENUMB CHAR 20   0   Transaction Number  
10 BEGINTIMESTAMP /POSDW/BEGINDATETIMESTAMP /POSDW/TIMESTAMP CHAR 14   0   Second in Which Transaction Starts  
11 ENDTIMESTAMP /POSDW/ENDDATETIMESTAMP /POSDW/TIMESTAMP CHAR 14   0   Second in Which Transaction Ends  
12 DEPARTMENT /POSDW/DEPARTMENT /POSDW/CHAR10ALPHA CHAR 10   0   Department  
13 OPERATORQUAL /POSDW/OPERATORQUALIFIER /POSDW/OPERATORQUALIFIER CHAR 1   0   Operator Qualifier  
14 OPERATORID /POSDW/OPERATORID /POSDW/CHAR30ALPHA CHAR 30   0   Cashier Number or Name  
15 TRANSCURRENCY /POSDW/TRANSACTIONCURRENCY WAERS CUKY 5   0   Transaction Currency *
16 PARTNERQUALIFIER /POSDW/PARTNERQUALIFIER /POSDW/PARTNERQUALIFIER CHAR 1   0   Qualifier for Partner Number  
17 PARTNERID /POSDW/PARTNERID /POSDW/CHAR13ALPHA CHAR 13   0   Partner Number  
18 .INCLUDE       0   0   Transaction - Enhanced Fields  
19 TRANSINDEX /POSDW/TRANSINDEX /POSDW/TRANSINDEX INT4 10   0   Transaction Index  
20 NONCOMPFLAG /POSDW/NONCOMPFLAG /POSDW/FLAG CHAR 1   0   Indicator for Non-Comparable Sales  
21 TRANSTYPEGROUP /POSDW/TRANSACTIONTYPEGROUP /POSDW/TRANSACTIONTYPEGROUP CHAR 4   0   Transaction Type Group /POSDW/TRANTG
22 BUSINESSTYPE /POSDW/BUSINESSTYPE /POSDW/BUSINESSTYPE CHAR 1   0   Business Transaction  
23 REVERSALFLAG /POSDW/REVERSALFLAG /POSDW/FLAG CHAR 1   0   Reversal Indicator  
24 TRANSDEBITFLAG /POSDW/DEBITFLAG /POSDW/DEBITFLAG CHAR 1   0   Debit/Credit Indicator  
25 PLANT /POSDW/PLANT CHAR4 CHAR 4   0   Plant  
26 STORECURRENCY /POSDW/STORECURRENCY WAERS CUKY 5   0   Local Currency *
27 PLANTCUSTOMER /POSDW/PLANTCUSTOMER /POSDW/CHAR10ALPHA CHAR 10   0   Customer Number of Plant  
28 BUSINESSLOCATION /POSDW/BUSINESSLOCATION /POSDW/CHAR10ALPHA CHAR 10   0   Business Location Identifier (IS-OIL/MRN)  
29 TURNOVER /POSDW/TRANSTURNOVER /POSDW/CURRENCY CURR 15   2   Sales Totals Per Transaction  
30 INDEXCURRENCY /POSDW/INDEXCURRENCY WAERS CUKY 5   0   Currency for Sales Totals *
31 VERSION /POSDW/TRANSACTION_VERSION /POSDW/TRANSACTION_VERSION INT1 3   0   Version of POS Transaction  
32 .INCLUDE       0   0   Table Fields for the Transaction Header  
33 POSTVOIDDETAILS /POSDW/TT_POSTVOIDDETAILS   TTYP 0   0    
34 ADDITIONALS /POSDW/TT_ADDITIONALS   TTYP 0   0    
35 CUSTOMERDETAILS /POSDW/TT_CUSTOMERDETAILS   TTYP 0   0    
36 RETAILLINEITEM /POSDW/TT_RETAILLINEITEM   TTYP 0   0    
37 DISCOUNT /POSDW/TT_DISCOUNT   TTYP 0   0    
38 TAX /POSDW/TT_TAX   TTYP 0   0    
39 TENDER /POSDW/TT_TENDER   TTYP 0   0    
40 RETAILTOTALS /POSDW/TT_RETAILTOTALS   TTYP 0   0    
41 DISCOUNTTOTALS /POSDW/TT_DISCOUNTTOTALS   TTYP 0   0    
42 TAXTOTALS /POSDW/TT_TAXTOTALS   TTYP 0   0    
43 TENDERTOTALS /POSDW/TT_TENDERTOTALS   TTYP 0   0    
44 CASHIERTOTALS /POSDW/TT_CASHIERTOTALS   TTYP 0   0    
45 FINANCIALMOVEMENT /POSDW/TT_FINANCIALMOVEMENT   TTYP 0   0    
46 GOODSMOVEMENT /POSDW/TT_GOODSMOVEMENT   TTYP 0   0    
47 EXTENSIONS /POSDW/TT_EXTENSIONS   TTYP 0   0    
48 LOYALTY /POSDW/TT_LOYALTY   TTYP 0   0    
49 SECUREBINDATA /POSDW/TT_SECUREBINDATA   TTYP 0   0    
50 .INCLUDE       0   0   For Transaction Data Enhanced with User Interface  
51 TIME_INTERVAL /POSDW/TIMEINTV_INT INT4 INT4 10   0   Number of a Time Interval (Internal Field)  
52 UPDKZ /POSDW/UPDKZ CHAR1 CHAR 1   0   Update Indicator  
53 .INCLUDE       0   0   Additional Information at Segment Level  
54 NAV_ITEM_QUAL /POSDW/NAV_ITEM_QUAL INT4 INT4 10   0   Item Qualifier for Navigation in Raw Editor  
55 MESSAGE /POSDW/TT_NAVI_MESSAGE   TTYP 0   0    
56 .INCLUDE       0   0   Internal Fields for Processing Control  
57 TASKSTATUS /POSDW/TT_TASKSTATUS   TTYP 0   0    
58 CHANGEFLAG /POSDW/CHANGEFLAG /POSDW/CHANGEFLAG CHAR 1   0   Change Indicator for Transaction Data  
59 TRANSSTATUS /POSDW/TR_STATUS /POSDW/TR_STATUS CHAR 1   0   Transaction Status  
60 TRANSSOURCE /POSDW/TT_TRANSSOURCE   TTYP 0   0    
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 /POSDW/TRANSACTION_INT TRANSTYPECODE /POSDW/TRANTY TRANSTYPECODE KEY 1 CN
2 /POSDW/TRANSACTION_INT TRANSTYPEGROUP /POSDW/TRANTG TRANSTYPEGROUP 1 CN
History
Last changed by/on SAP  20111123 
SAP Release Created in 30B