SAP ABAP Table /POSDW/LPA_VFNL (Generated Table for View)
Basic Data
Table Category VIEW    General view structure 
General view structure /POSDW/LPA_VFNL   Table Relationship Diagram
Short Description Generated Table for View    
Delivery and Maintenance
Pool/cluster      
Delivery Class      
Data Browser/Table View Maintenance X   Display/Maintenance Allowed 
Components
     
Field Key Data Element Domain Data
Type		 Length Decimal
Places		 Short Description Check
table
1 MANDT MANDT MANDT CLNT 3   0   Client  
2 PRF_TYPE /POSDW/PROFILETYPE /POSDW/PROFILETYPE CHAR 4   0   Customizing Profile Type /POSDW/PROF
3 PTN_ID /POSDW/LPA_PTN_ID /POSDW/CHAR10ALPHA CHAR 10   0   LPA : Pattern Identifier  
4 DESCRIPTION /POSDW/DESCRIPTION /POSDW/DESCRIPTION CHAR 50   0   Description  
5 PTN_STATUS /POSDW/LPA_PTNSTAT /POSDW/LPA_PTNSTAT CHAR 4   0   LPA : Pattern Status  
6 STORE_START_TIME /POSDW/LPA_STORE_STIM TIME TIMS 6   0   LPA : Store Start Time  
7 STORE_END_TIME /POSDW/LPA_STORE_ETIM TIME TIMS 6   0   LPA : Store End Time  
8 TRAN_TYPE /POSDW/TRANSACTIONTYPECODE /POSDW/TRANSACTIONTYPECODE CHAR 4   0   Transaction Type /POSDW/TRANTY
9 FL_MEASURE_TYP /POSDW/LPA_FL_MSTYP /POSDW/LPA_FL_MSTYP CHAR 6   0   LPA : First/Last Hour Template Measure Type  
10 FL_MEASURE_VAL /POSDW/LPA_FL_MSVAL /POSDW/TRANSINDEX INT4 10   0   LPA : First/Last Hour Template Measure Value  
11 TXNAMOUNT_FROM /POSDW/LPA_TXNAMOUNT_FROM /POSDW/CURRENCY CURR 15   2   LPA : Transaction Amount From  
12 TXNAMOUNT_TO /POSDW/LPA_TXNAMOUNT_TO /POSDW/CURRENCY CURR 15   2   LPA : Transaction Amount To  
13 TENDER_TYPE /POSDW/TENDERTYPECODE /POSDW/TENDERTYPECODE CHAR 4   0   Means of Payment /POSDW/TENDTY
14 CREATED_ON /POSDW/LPA_CRD_ON /POSDW/DATE DATS 8   0   LPA : Template/Pattern Created On Date  
15 CHANGED_ON /POSDW/LPA_CHD_ON /POSDW/DATE DATS 8   0   LPA : Template/Pattern Changed Date  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 /POSDW/LPA_VFNL PRF_TYPE /POSDW/PROF PROFILETYPE    
2 /POSDW/LPA_VFNL TENDER_TYPE /POSDW/TENDTY TENDERTYPECODE    
3 /POSDW/LPA_VFNL TRAN_TYPE /POSDW/TRANTY TRANSTYPECODE 1 CN
History
Last changed by/on SAP  20111123 
SAP Release Created in