SAP ABAP View /POSDW/LPA_VSPSK (LPA : SKU Matching Amount)
Hierarchy
☛
BI_CONT (Software Component) Business Intelligence Content
⤷
BW-BCT-ISR-LPA (Application Component) Loss Prevention Analytics
⤷
/POSDW/LPA_CUSTOMIZING (Package) LPA Customizing
BI_CONT (Software Component) Business Intelligence Content⤷
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_VSPSK | |
| Short Description | LPA : SKU Matching Amount | |
| 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 | 'T020' | 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 | TRAN_TYPE |
/POSDW/LPA_EXDET |
TRAN_TYPE | /POSDW/TRANSACTIONTYPECODE | Transaction Type | |||
| 7 | SKUID_FROM |
/POSDW/LPA_EXDET |
SKUID_FROM | /POSDW/LPA_SKUID_FROM | LPA : SKU ID From | |||
| 8 | SKUID_TO |
/POSDW/LPA_EXDET |
SKUID_TO | /POSDW/LPA_SKUID_TO | LPA : SKU ID To | |||
| 9 | SPLSKU_MSTYP |
/POSDW/LPA_EXDET |
SPLSKU_MSTYP | /POSDW/LPA_SKUMSTYP | LPA : SKU Matching Amount Template Measure Type | |||
| 10 | REL_OPER |
/POSDW/LPA_EXDET |
REL_OPER | /POSDW/LPA_REL_OPER | LPA : Relational Operator | |||
| 11 | SPLSKU_MSVAL |
/POSDW/LPA_EXDET |
SPLSKU_MSVAL | /POSDW/LPA_SKUMSVAL | LPA : SKU Matching Amount Template Measure Value | |||
| 12 | CHANGED_ON |
/POSDW/LPA_EXDET |
CHANGED_ON | H | /POSDW/LPA_CHD_ON | LPA : Template/Pattern Changed Date | ||
| 13 | CREATED_ON |
/POSDW/LPA_EXDET |
CREATED_ON | H | /POSDW/LPA_CRD_ON | LPA : Template/Pattern Created On 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 |
