SAP ABAP View /BEV3/CHVUMSP (DB view of visible AGCl/RI combinations sales scale %)
Hierarchy
☛
EA-APPL (Software Component) SAP Enterprise Extension PLM, SCM, Financials
⤷ SD-SLS-PLL-OBS (Application Component) Remaining Beverage - Obsolete Objects
⤷ /BEV3/CH (Package) Contract Handling
⤷ SD-SLS-PLL-OBS (Application Component) Remaining Beverage - Obsolete Objects
⤷ /BEV3/CH (Package) Contract Handling
Basic Data
View Type | D | Database View |
Database View | /BEV3/CHVUMSP | |
Short Description | DB view of visible AGCl/RI combinations sales scale % | |
Root table | /BEV3/CHBALLV | Agreements Administration Table: Visibility Index |
Table
# | Table Name | Foreign Table | Foreign Field | Foreign DIR |
---|---|---|---|---|
1 | /BEV3/CHBALLV | /BEV3/CHBALLV | ||
2 | /BEV3/CHBUMSP |
Join Conditions
# | Table Name | Field Name | Negation | Operator | Constants | Cont. line | AND/OR | Offset | F Length | Mco Field |
---|---|---|---|---|---|---|---|---|---|---|
1 | /BEV3/CHBALLV | MANDT | JL | EQ | 0 | 0 | ||||
2 | /BEV3/CHBUMSP | MANDT | JR | EQ | AND | 0 | 0 | |||
3 | /BEV3/CHBALLV | YVWDNR | JL | EQ | 0 | 0 | ||||
4 | /BEV3/CHBUMSP | YVWDNR | JR | EQ | AND | 0 | 0 | |||
5 | /BEV3/CHBALLV | VBKL | JL | EQ | 0 | 0 | ||||
6 | /BEV3/CHBUMSP | VBKL | JR | EQ | AND | 0 | 0 | |||
7 | /BEV3/CHBALLV | RI | JL | EQ | 0 | 0 | ||||
8 | /BEV3/CHBUMSP | RI | JR | EQ | AND | 0 | 0 | |||
9 | /BEV3/CHBALLV | VBIN | JL | EQ | 0 | 0 | ||||
10 | /BEV3/CHBUMSP | VBIN | JR | EQ | AND | 0 | 0 | |||
11 | /BEV3/CHBALLV | VBNR | JL | EQ | 0 | 0 | ||||
12 | /BEV3/CHBUMSP | VBNR | JR | EQ | 0 | 0 | ||||
View Fields
# | View field | Table | Field | Maintenance Flag | Key | Data element | Mod | Short Description |
---|---|---|---|---|---|---|---|---|
1 | * | /BEV3/CHBUMSP | * | |||||
2 | MANDT | /BEV3/CHBUMSP | MANDT | MANDT | Client | |||
3 | YVWDNR | /BEV3/CHBUMSP | YVWDNR | /BEV3/CHDTWDNR | CHD Contract Number | |||
4 | VBKL | /BEV3/CHBUMSP | VBKL | /BEV3/CHBKL | Agreement Class | |||
5 | RI | /BEV3/CHBUMSP | RI | /BEV3/CHDTRI | Rule Identifier | |||
6 | VBIN | /BEV3/CHBUMSP | VBIN | /BEV3/CHBIN | Agreement Entity | |||
7 | VBNR | /BEV3/CHBUMSP | VBNR | /BEV3/CHBNR | Agreement Number in Sequential Time Order | |||
8 | STAFF_RA | /BEV3/CHBUMSP | STAFF_RA | /BEV3/CHSTAF_RA | Scale ID | |||
9 | RUMPF_RA | /BEV3/CHBUMSP | RUMPF_RA | /BEV3/CHRUMP_RA | Short period | |||
10 | VBKL_WL | /BEV3/CHBUMSP | VBKL_WL | /BEV3/CHBKLA_WL | Agreement Class | |||
11 | VBIN_WL | /BEV3/CHBUMSP | VBIN_WL | /BEV3/CHBINS_WL | Agreement Entity | |||
12 | RI_WL | /BEV3/CHBUMSP | RI_WL | /BEV3/CHREGID_WL | Rule Identifier | |||
13 | BEDINGG1 | /BEV3/CHBUMSP | BEDINGG1 | /BEV3/CHBEDINGG | Condition identifier | |||
14 | BEDINGG2 | /BEV3/CHBUMSP | BEDINGG2 | /BEV3/CHBEDINGG | Condition identifier | |||
15 | BEDINGG3 | /BEV3/CHBUMSP | BEDINGG3 | /BEV3/CHBEDINGG | Condition identifier | |||
16 | VBDTA | /BEV3/CHBALLV | VBDTA | /BEV3/CHBDTAV | Period Visible from | |||
17 | VBDTB | /BEV3/CHBALLV | VBDTB | /BEV3/CHBDTBV | Date Visible to | |||
18 | ANZVBNR | /BEV3/CHBALLV | ANZVBNR | /BEV3/CHANZVBNR | Number of Visible AGNO for an Entity | |||
19 | ANZWIND | /BEV3/CHBALLV | ANZWIND | /BEV3/CHANZWIND | Number of Time Windows for an AGNO | |||
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 | 20040210 |
SAP Release Created in | 461 |