SAP ABAP View V_QALS_SEL (Selection view for inspection lot search)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷
CRM (Application Component) Customer Relationship Management
⤷
CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
⤷
QL (Package) QM inspection lots
⤷
⤷
⤷
Basic Data
| View Type | P | Projection View |
| Projection View | V_QALS_SEL | |
| Short Description | Selection view for inspection lot search | |
| Root table | QALS | Inspection lot record |
Table
| # | Table Name | Foreign Table | Foreign Field | Foreign DIR |
|---|---|---|---|---|
| 1 | QALS |
Join Conditions
| # | Table Name | Field Name | Negation | Operator | Constants | Cont. line | AND/OR | Offset | F Length | Mco Field |
|---|---|---|---|---|---|---|---|---|---|---|
View Fields
| # | View field | Table | Field | Maintenance Flag | Key | Data element | Mod | Short Description |
|---|---|---|---|---|---|---|---|---|
| 1 | MANDANT | MANDT | Client | |||||
| 2 | PRUEFLOS | QPLOS | Inspection Lot Number | |||||
| 3 | WERK | WERKS_D | Plant | |||||
| 4 | ART | QPART | Inspection Type | |||||
| 5 | HERKUNFT | QHERK | Inspection Lot Origin | |||||
| 6 | OBJNR | J_OBJNR | Object number | |||||
| 7 | OBTYP | J_OBTYP | Object Category | |||||
| 8 | STAT14 | QSTAT14 | Completion of Short-Term Inspection | |||||
| 9 | STAT35 | QSTAT35 | Usage Decision Has Been Made | |||||
| 10 | ENSTEHDAT | QENTST | Date of Lot Creation | |||||
| 11 | ERSTELDAT | QDATUMERST | Date on Which the Data Record Was Created | |||||
| 12 | AUFNR | AUFNR | Order Number | |||||
| 13 | VERID | VERID | Production Version | |||||
| 14 | KUNNR | QKUNWE | Customer (Ship-To Party) | |||||
| 15 | LIFNR | ELIFN | Vendor's account number | |||||
| 16 | HERSTELLER | QLIFNR | Number of Manufacturer | |||||
| 17 | MATNR | MATNR | Material Number | |||||
| 18 | CHARG | CHARG_D | Batch Number | |||||
| 19 | LAGORTCHRG | LGORT_D | Storage location | |||||
| 20 | SOBKZ | SOBKZ | Special Stock Indicator | |||||
| 21 | EKORG | EKORG | Purchasing organization | |||||
| 22 | EBELN | EBELN | Purchasing Document Number | |||||
| 23 | EBELP | EBELP | Item Number of Purchasing Document | |||||
| 24 | MJAHR | MJAHR | Year of material document | |||||
| 25 | MBLNR | MBLNR | Number of Material Document | |||||
| 26 | ZEILE | MBLPO | Item in material document | |||||
| 27 | LS_VBELN | VBELN_VL | Delivery | |||||
| 28 | LS_POSNR | POSNR_VL | Delivery Item | |||||
| 29 | KTEXTLOS | QKURZTEXT | Short Text | |||||
| 30 | KTEXTMAT | QKTEXTOBJ | Short Text for Inspection Object | |||||
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 | 20130529 |
| SAP Release Created in |