SAP ABAP View /SPE/CP_STL (View for storage locations of SPE contract packagers)
Hierarchy
☛
SAP_APPL (Software Component) Logistics and Accounting
⤷
LO-SPM-INB (Application Component) Goods Receipt Process
⤷
/SPE/ID_HANDLING (Package) Inbound delivery handling
SAP_APPL (Software Component) Logistics and Accounting⤷
LO-SPM-INB (Application Component) Goods Receipt Process⤷
/SPE/ID_HANDLING (Package) Inbound delivery handling
Basic Data
| View Type | D | Database View |
| Database View | /SPE/CP_STL | |
| Short Description | View for storage locations of SPE contract packagers | |
| Root table | MDLV | Customizing MRP Area |
Table
| # | Table Name | Foreign Table | Foreign Field | Foreign DIR |
|---|---|---|---|---|
| 1 | MDLV |
MDLV | ||
| 2 | T001L |
|||
| 3 | T320 |
Join Conditions
| # | Table Name | Field Name | Negation | Operator | Constants | Cont. line | AND/OR | Offset | F Length | Mco Field |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | MDLV |
MANDT | JL | EQ | 0 | 0 | ||||
| 2 | T001L |
MANDT | JR | EQ | AND | 0 | 0 | |||
| 3 | MDLV |
WERZG | JL | EQ | 0 | 0 | ||||
| 4 | T001L |
WERKS | JR | EQ | AND | 0 | 0 | |||
| 5 | MDLV |
ORTZG | JL | EQ | 0 | 0 | ||||
| 6 | T001L |
LGORT | JR | EQ | AND | 0 | 0 | |||
| 7 | T001L |
MANDT | JL | EQ | 0 | 0 | ||||
| 8 | T320 |
MANDT | JR | EQ | AND | 0 | 0 | |||
| 9 | T001L |
WERKS | JL | EQ | 0 | 0 | ||||
| 10 | T320 |
WERKS | JR | EQ | AND | 0 | 0 | |||
| 11 | T001L |
LGORT | JL | EQ | 0 | 0 | ||||
| 12 | T320 |
LGORT | JR | EQ | AND | 0 | 0 | |||
| 13 | MDLV |
SPE_BNTYP | EQ | '1' | 0 | 0 | ||||
View Fields
| # | View field | Table | Field | Maintenance Flag | Key | Data element | Mod | Short Description |
|---|---|---|---|---|---|---|---|---|
| 1 |  MANDT |
T001L |
MANDT | MANDT | Client | |||
| 2 | WERKS |
T001L |
WERKS | WERKS_D | Plant | |||
| 3 | LGORT |
T001L |
LGORT | LGORT_D | Storage location | |||
| 4 | BERID |
MDLV |
BERID | BERID | MRP Area | |||
| 5 | SPE_BNTYP |
MDLV |
SPE_BNTYP | /SPE/BNTYP | Business Types of MRP Area | |||
| 6 | LGNUM |
T320 |
LGNUM | LGNUM | Warehouse Number / Warehouse Complex | |||
| 7 | LGOBE |
T001L |
LGOBE | LGOBE | Description of Storage Location | |||
Maintenance Status
| 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 | 20110901 |
| SAP Release Created in | 600 |
