SAP ABAP View /SAPSLL/V_PREVDW (Preference: DB View for Table /SAPSLL/PREVDWL)
Hierarchy
☛
SLL-LEG (Software Component) SLL-LEG 901: Add-On Installation
⤷
SLL-LEG (Application Component) Global Trade Services
⤷
/SAPSLL/LEGAL_PRE_VDEC (Package) Legal Services: Preference Handling - Vendor Declarations
SLL-LEG (Software Component) SLL-LEG 901: Add-On Installation⤷
SLL-LEG (Application Component) Global Trade Services⤷
/SAPSLL/LEGAL_PRE_VDEC (Package) Legal Services: Preference Handling - Vendor Declarations
Basic Data
| View Type | D | Database View |
| Database View | /SAPSLL/V_PREVDW | |
| Short Description | Preference: DB View for Table /SAPSLL/PREVDWL | |
| Root table | /SAPSLL/PREVDWL | SLL: Preference: Long-Term Vendor Declaration - Worklist |
Table
| # | Table Name | Foreign Table | Foreign Field | Foreign DIR |
|---|---|---|---|---|
| 1 | /SAPSLL/PREVDWL |
/SAPSLL/PREVDWL | ||
| 2 | /SAPSLL/PNTBP |
|||
| 3 | /SAPSLL/PNTPR |
|||
| 4 | /SAPSLL/MODGROBJ |
Join Conditions
| # | Table Name | Field Name | Negation | Operator | Constants | Cont. line | AND/OR | Offset | F Length | Mco Field |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | /SAPSLL/PREVDWL |
GUID_MODEL | JL | EQ | 0 | 0 | ||||
| 2 | /SAPSLL/MODGROBJ |
GUID_MODEL | JR | EQ | AND | 0 | 0 | |||
| 3 | /SAPSLL/PREVDWL |
PARTNER | JL | EQ | 0 | 0 | ||||
| 4 | /SAPSLL/PNTBP |
PARTNER | JR | EQ | AND | 0 | 0 | |||
| 5 | /SAPSLL/PREVDWL |
PRNUM | JL | EQ | 0 | 0 | ||||
| 6 | /SAPSLL/PNTPR |
PRNUM | JR | EQ | 0 | 0 | ||||
View Fields
| # | View field | Table | Field | Maintenance Flag | Key | Data element | Mod | Short Description |
|---|---|---|---|---|---|---|---|---|
| 1 |  MANDT |
/SAPSLL/PREVDWL |
MANDT | MANDT | Client | |||
| 2 | GUID_PREVDWL |
/SAPSLL/PREVDWL |
GUID_PREVDWL | /SAPSLL/GUID_16 | Primary Key as GUID in 'RAW' Format | |||
| 3 | GUID_MODEL |
/SAPSLL/PREVDWL |
GUID_MODEL | /SAPSLL/GUID_MODEL | GUID for Table Entry of Preference Model | |||
| 4 | PARTNER |
/SAPSLL/PREVDWL |
PARTNER | BU_PARTNER | Business Partner Number | |||
| 5 | PRNUM |
/SAPSLL/PREVDWL |
PRNUM | /SAPSLL/PRNUM | Internal Product Number | |||
| 6 | MODEL |
/SAPSLL/PREVDWL |
MODEL | /SAPSLL/MODEL | Preference Model | |||
| 7 | SELDA |
/SAPSLL/PREVDWL |
SELDA | /SAPSLL/SELDAT | Selection Date | |||
| 8 | IDNLF |
/SAPSLL/PREVDWL |
IDNLF | /SAPSLL/IDNLF | Preference: Material Number of Vendor | |||
| 9 | IDNLF_TXT1 |
/SAPSLL/PREVDWL |
IDNLF_TXT1 | /SAPSLL/TEXT40 | Text 40 Characters Long | |||
| 10 | IDNLF_TXT2 |
/SAPSLL/PREVDWL |
IDNLF_TXT2 | /SAPSLL/TEXT40 | Text 40 Characters Long | |||
| 11 | RELTY |
/SAPSLL/PREVDWL |
RELTY | /SAPSLL/PRE_RELTY | Preference: Type of Vendor/Material Relationship | |||
| 12 | LABST |
/SAPSLL/PREVDWL |
LABST | /SAPSLL/DIMEN | Dimension (Quantity, Weight, Height, Width, Length) | |||
| 13 | GRVSY |
/SAPSLL/PNTBP |
GRVSY | /SAPSLL/GRVSY | Logical System Group | |||
| 14 | BPTYP |
/SAPSLL/PNTBP |
BPTYP | /SAPSLL/BPTYP | Business Partner Category in Feeder System | |||
| 15 | BPVSY |
/SAPSLL/PNTBP |
BPVSY | /SAPSLL/BPVSY | External Business Partner Number | |||
| 16 | PRVSY |
/SAPSLL/PNTPR |
PRVSY | /SAPSLL/PRVSY | Product Number | |||
| 17 | PRTYP |
/SAPSLL/PNTPR |
PRTYP | /SAPSLL/PRTYP | Prod. Cat. fr. Backend System for Legal and Logistics Serv. | |||
| 18 | MODELGRP |
/SAPSLL/MODGROBJ |
MODELGRP | /SAPSLL/MODELGRP | Administrative Unit | |||
| 19 | GUID_PR |
/SAPSLL/PNTPR |
GUID_PR | /SAPSLL/GUID_16 | Primary Key as GUID in 'RAW' Format | |||
| 20 | GUID_PRTN |
/SAPSLL/PNTBP |
GUID_PRTN | /SAPSLL/PRTN_GUID_16 | Primary Key of Business Partner | |||
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 | 20141106 |
| SAP Release Created in | 2.00 |
