SAP ABAP Table /POSDW/V_NAVX_GR (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	/POSDW/V_NAVX_GR	Table Relationship Diagram
Short Description	Generated Table for View

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	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client
2	RETAILSTOREID	☑	/POSDW/RETAILSTOREID	/POSDW/RETAILSTOREID	CHAR	10	0	Store
3	STORE_GROUP	☑	/POSDW/RETAILSTORE_GROUP	/POSDW/RETAILSTORE_GROUP	CHAR	4	0	Store Group	/POSDW/STOGR
4	BUSINESSDAYDATE	☑	/POSDW/BUSINESSDAYDATE	/POSDW/DATE	DATS	8	0	Posting Date
5	STORE_CLASS	☑	/POSDW/RETAILSTORE_CLASS	/POSDW/RETAILSTORE_CLASS	CHAR	4	0	Store Class	/POSDW/STOC
6	TRANSINDEXHIGH	☐	/POSDW/TRANSINDEXHIGH	/POSDW/TRANSINDEX	INT4	10	0	Highest Transaction Index for Store and Day
7	TRANSSTATUS	☐	/POSDW/TR_STATUS	/POSDW/TR_STATUS	CHAR	1	0	Transaction Status
8	CURRENCY	☐	/POSDW/INDEXCURRENCY	WAERS	CUKY	5	0	Currency for Sales Totals
9	VALIDSTATUS	☐	/POSDW/INDEXVALIDSTATUS	XFELD	CHAR	1	0	Indicates if Status Totals in Index Record Are Still Correct
10	VALIDTURNOVER	☐	/POSDW/INDEXVALIDTURNOVER	XFELD	CHAR	1	0	Indicates if Sales Totals in Index Record Are Still Correct
11	VERSION	☐	/POSDW/DBVERSION		INT1	3	0	Version for Deep Structures in the Database Tables
12	LENGTH	☐	/POSDW/LRAWLENGTH		INT2	5	0	Length Field for Subsequent LRAW Field
13	NAVINDEXDATA	☐	/POSDW/LRAW		LRAW	32000	0	LRAW Field for Deep Structures

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	/POSDW/V_NAVX_GR	STORE_CLASS	/POSDW/STOC	STORE_CLASS	KEY	1	CN
2	/POSDW/V_NAVX_GR	STORE_GROUP	/POSDW/STOGR	STORE_GROUP	KEY	1	CN

History

Last changed by/on	SAP	20100326
SAP Release Created in