SAP ABAP Table /POSDW/NAVIGATOR_INDEX (Index Table for Navigator)
Hierarchy
☛
BI_CONT (Software Component) Business Intelligence Content
⤷
BW-BCT-ISR-PIP (Application Component) Point of Sales Inbound Processing Engine
⤷
/POSDW/SALES_AUDIT_DATA (Package) Classes for Manipulation of Data and API Connection
BI_CONT (Software Component) Business Intelligence Content⤷
BW-BCT-ISR-PIP (Application Component) Point of Sales Inbound Processing Engine⤷
/POSDW/SALES_AUDIT_DATA (Package) Classes for Manipulation of Data and API Connection
Basic Data
| Table Category | INTTAB | Structure |
| Structure | /POSDW/NAVIGATOR_INDEX |
Table Relationship Diagram 
|
| Short Description | Index Table for Navigator |
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 | Index Record with Internal Format | |||||
| 2 | RETAILSTOREID |
/POSDW/RETAILSTOREID | /POSDW/RETAILSTOREID | CHAR | 10 | 0 | Store | ||
| 3 | BUSINESSDAYDATE |
/POSDW/BUSINESSDAYDATE | /POSDW/DATE | DATS | 8 | 0 | Posting Date | ||
| 4 | BUSINESSTYPE |
/POSDW/BUSINESSTYPE_TOTAL | /POSDW/BUSINESSTYPE_TOTAL | CHAR | 1 | 0 | Business Transaction or Over/Short Line in Navigation Index | ||
| 5 | NAVINDEXTYPE |
/POSDW/NAVIGATIONINDEXTYPE | /POSDW/NAVIGATIONINDEXTYPE | CHAR | 1 | 0 | Type of Navigation Index Record | ||
| 6 | .INCLUDE |
0 | 0 | Index Record, All Totals Fields, Internal Format | |||||
| 7 | CURRENCY |
/POSDW/INDEXCURRENCY | WAERS | CUKY | 5 | 0 | Currency for Sales Totals | TCURC | |
| 8 | .INCLU-1 |
0 | 0 | Totals per Business Transaction and Transaction Status | |||||
| 9 | TRANSCOUNT1 |
/POSDW/INDEXTRANSCOUNT | /POSDW/TRANSCOUNT | INT4 | 10 | 0 | Number of POS Transactions for Site and Day | ||
| 10 | TRANSTURNOVER1 |
/POSDW/INDEXTURNOVER | /POSDW/CURRENCY | CURR | 15 | 2 | Sales Totals Per Plant and Day | ||
| 11 | .INCLU-2 |
0 | 0 | Totals per Business Transaction and Transaction Status | |||||
| 12 | TRANSCOUNT2 |
/POSDW/INDEXTRANSCOUNT | /POSDW/TRANSCOUNT | INT4 | 10 | 0 | Number of POS Transactions for Site and Day | ||
| 13 | TRANSTURNOVER2 |
/POSDW/INDEXTURNOVER | /POSDW/CURRENCY | CURR | 15 | 2 | Sales Totals Per Plant and Day | ||
| 14 | .INCLU-3 |
0 | 0 | Totals per Business Transaction and Transaction Status | |||||
| 15 | TRANSCOUNT3 |
/POSDW/INDEXTRANSCOUNT | /POSDW/TRANSCOUNT | INT4 | 10 | 0 | Number of POS Transactions for Site and Day | ||
| 16 | TRANSTURNOVER3 |
/POSDW/INDEXTURNOVER | /POSDW/CURRENCY | CURR | 15 | 2 | Sales Totals Per Plant and Day | ||
| 17 | .INCLU-4 |
0 | 0 | Totals per Business Transaction and Transaction Status | |||||
| 18 | TRANSCOUNT4 |
/POSDW/INDEXTRANSCOUNT | /POSDW/TRANSCOUNT | INT4 | 10 | 0 | Number of POS Transactions for Site and Day | ||
| 19 | TRANSTURNOVER4 |
/POSDW/INDEXTURNOVER | /POSDW/CURRENCY | CURR | 15 | 2 | Sales Totals Per Plant and Day | ||
| 20 | .INCLUDE |
0 | 0 | Totals for Overs/Shorts / Outbound Processing | |||||
| 21 | COUNT_NOT_CALC |
/POSDW/INDEXTRANSCOUNT | /POSDW/TRANSCOUNT | INT4 | 10 | 0 | Number of POS Transactions for Site and Day | ||
| 22 | COUNT_CALC |
/POSDW/INDEXTRANSCOUNT | /POSDW/TRANSCOUNT | INT4 | 10 | 0 | Number of POS Transactions for Site and Day | ||
| 23 | COUNT_CHECK |
/POSDW/INDEXTRANSCOUNT | /POSDW/TRANSCOUNT | INT4 | 10 | 0 | Number of POS Transactions for Site and Day | ||
| 24 | COUNT_COMP |
/POSDW/INDEXTRANSCOUNT | /POSDW/TRANSCOUNT | INT4 | 10 | 0 | Number of POS Transactions for Site and Day | ||
| 25 | COUNT_OK |
/POSDW/INDEXTRANSCOUNT | /POSDW/TRANSCOUNT | INT4 | 10 | 0 | Number of POS Transactions for Site and Day | ||
| 26 | COUNT_NOT_CUST |
/POSDW/INDEXTRANSCOUNT | /POSDW/TRANSCOUNT | INT4 | 10 | 0 | Number of POS Transactions for Site and Day | ||
| 27 | COUNT_NOT_OK |
/POSDW/INDEXTRANSCOUNT | /POSDW/TRANSCOUNT | INT4 | 10 | 0 | Number of POS Transactions for Site and Day | ||
| 28 | SO_AMOUNT |
/POSDW/SO_AMOUNT_STORE | /POSDW/CURRENCY | CURR | 15 | 2 | Total Over/Short Amount for a Store for all Tender/Currency | ||
| 29 | A |
CHAR1 | CHAR1 | CHAR | 1 | 0 | Single-Character Flag |
Foreign Keys
| |
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right |
|---|---|---|---|---|---|---|---|
 |
|
|
|
|
|
|
|
| 1 | /POSDW/NAVIGATOR_INDEX | CURRENCY |  TCURC |
WAERS |
KEY | 1 | CN |
History
| Last changed by/on | SAP | 20100326 |
| SAP Release Created in | 30B |
