SAP ABAP View /POSDW/LPA_VFNL (LPA : First/Last Hour)
Hierarchy
☛
BI_CONT (Software Component) Business Intelligence Content
⤷ BW-BCT-ISR-LPA (Application Component) Loss Prevention Analytics
⤷ /POSDW/LPA_CUSTOMIZING (Package) LPA Customizing
⤷ BW-BCT-ISR-LPA (Application Component) Loss Prevention Analytics
⤷ /POSDW/LPA_CUSTOMIZING (Package) LPA Customizing
Basic Data
View Type | C | Maintenance View |
Maintenance View | /POSDW/LPA_VFNL | |
Short Description | LPA : First/Last Hour | |
Root table | /POSDW/LPA_EXDET | LPA : Exception Template Details (Parameters) |
Table
# | Table Name | Foreign Table | Foreign Field | Foreign DIR |
---|---|---|---|---|
1 | /POSDW/LPA_EXDET | /POSDW/LPA_EXDET | ||
2 | /POSDW/LPA_PTNT | /POSDW/LPA_EXDET | PTN_ID | I |
Join Conditions
# | Table Name | Field Name | Negation | Operator | Constants | Cont. line | AND/OR | Offset | F Length | Mco Field |
---|---|---|---|---|---|---|---|---|---|---|
1 | /POSDW/LPA_EXDET | TMPL_ID | EQ | 'T015' | 0 | 0 | ||||
View Fields
# | View field | Table | Field | Maintenance Flag | Key | Data element | Mod | Short Description |
---|---|---|---|---|---|---|---|---|
1 | MANDT | /POSDW/LPA_EXDET | MANDT | MANDT | Client | |||
2 | PRF_TYPE | /POSDW/LPA_EXDET | PRF_TYPE | /POSDW/PROFILETYPE | Customizing Profile Type | |||
3 | PTN_ID | /POSDW/LPA_EXDET | PTN_ID | /POSDW/LPA_PTN_ID | LPA : Pattern Identifier | |||
4 | DESCRIPTION | /POSDW/LPA_PTNT | DESCRIPTION | /POSDW/DESCRIPTION | Description | |||
5 | PTN_STATUS | /POSDW/LPA_EXDET | PTN_STATUS | /POSDW/LPA_PTNSTAT | LPA : Pattern Status | |||
6 | STORE_START_TIME | /POSDW/LPA_EXDET | STORE_START_TIME | /POSDW/LPA_STORE_STIM | LPA : Store Start Time | |||
7 | STORE_END_TIME | /POSDW/LPA_EXDET | STORE_END_TIME | /POSDW/LPA_STORE_ETIM | LPA : Store End Time | |||
8 | TRAN_TYPE | /POSDW/LPA_EXDET | TRAN_TYPE | /POSDW/TRANSACTIONTYPECODE | Transaction Type | |||
9 | FL_MEASURE_TYP | /POSDW/LPA_EXDET | FL_MEASURE_TYP | /POSDW/LPA_FL_MSTYP | LPA : First/Last Hour Template Measure Type | |||
10 | FL_MEASURE_VAL | /POSDW/LPA_EXDET | FL_MEASURE_VAL | /POSDW/LPA_FL_MSVAL | LPA : First/Last Hour Template Measure Value | |||
11 | TXNAMOUNT_FROM | /POSDW/LPA_EXDET | TXNAMOUNT_FROM | /POSDW/LPA_TXNAMOUNT_FROM | LPA : Transaction Amount From | |||
12 | TXNAMOUNT_TO | /POSDW/LPA_EXDET | TXNAMOUNT_TO | /POSDW/LPA_TXNAMOUNT_TO | LPA : Transaction Amount To | |||
13 | TENDER_TYPE | /POSDW/LPA_EXDET | TENDER_TYPE | /POSDW/TENDERTYPECODE | Means of Payment | |||
14 | CREATED_ON | /POSDW/LPA_EXDET | CREATED_ON | H | /POSDW/LPA_CRD_ON | LPA : Template/Pattern Created On Date | ||
15 | CHANGED_ON | /POSDW/LPA_EXDET | CHANGED_ON | H | /POSDW/LPA_CHD_ON | LPA : Template/Pattern Changed Date | ||
Maintenance Status
read only |
read and change |
Time-dependent views: like U, validity data like ' ' |
read, change, delete and insert |
Delivery Class | E | Control table, SAP and customer have separate key areas |
Data Browser/Table View Maintenance | X | Display/Maintenance Allowed |
History
Last changed by/on | SAP | 20111123 |
SAP Release Created in | 705 |