SAP ABAP View /POSDW/V_AGGRTI (View for Transaction Index)
Hierarchy
BI_CONT (Software Component) Business Intelligence Content
   BW-BCT-ISR-PIP (Application Component) Point of Sales Inbound Processing Engine
     /POSDW/COMMON (Package) PIPE Commonly Used Objects
Basic Data
View Type D Database View 
Database View /POSDW/V_AGGRTI  
Short Description View for Transaction Index    
Root table /POSDW/AGGRTB   Conversion of Aggregate Record and Posting Date to Index 
Table
# Table Name Foreign Table Foreign Field Foreign DIR
1 /POSDW/AGGRTB /POSDW/AGGRTB
2 /POSDW/AGGRTI  
Join Conditions
# Table Name Field Name Negation Operator Constants Cont. line AND/OR Offset F Length Mco Field
1 /POSDW/AGGRTB MANDT JL EQ 0 0
2 /POSDW/AGGRTI MANDT JR EQ AND 0 0
3 /POSDW/AGGRTB AGGR_NO JL EQ 0 0
4 /POSDW/AGGRTI AGGR_NO JR EQ AND 0 0
5 /POSDW/AGGRTB INDEX_NO JL EQ 0 0
6 /POSDW/AGGRTI INDEX_NO JR EQ 0 0
                     
View Fields
# View field Table Field Maintenance Flag Key Data element Mod Short Description
1 MANDT /POSDW/AGGRTB MANDT   MANDT Client
2 AGGR_NO /POSDW/AGGRTB AGGR_NO   /POSDW/AGGREGATE_NUMBER POS Aggregate Number
3 GROUP_NO /POSDW/AGGRTB GROUP_NO   /POSDW/AGGR_GROUP_NUMBER Number of Aggregation Group
4 RECORD_NO /POSDW/AGGRTB RECORD_NO   /POSDW/AGGR_REC_NUMBER Number of Aggregation Record Within Group
5 BUSINESSDAYDATE /POSDW/AGGRTB BUSINESSDAYDATE   /POSDW/BUSINESSDAYDATE Posting Date
6 TRANSINDEX /POSDW/AGGRTI TRANSINDEX   /POSDW/TRANSINDEX Transaction Index
7 REVERSAL /POSDW/AGGRTI REVERSAL   /POSDW/REVERSAL_INDICATOR Indicator for Reversed Lines in Aggregate
8 VERSION /POSDW/AGGRTI VERSION   /POSDW/TRANSACTION_VERSION Version of POS Transaction
                 
Maintenance Status
Access
  read only
  read and change
  Time-dependent views: like U, validity data like ' '
  read, change, delete and insert
Delivery Class      
Data Browser/Table View Maintenance    Display/Maintenance Allowed with Restrictions  
History
Last changed by/on SAP  20100326 
SAP Release Created in 712