SAP ABAP View /BEV3/CHVGUMS (DB View of Visible AGCl/RI Combinations Total Sales)
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
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
Basic Data
| View Type | D | Database View |
| Database View | /BEV3/CHVGUMS | |
| Short Description | DB View of Visible AGCl/RI Combinations Total Sales | |
| 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/CHBGUMS |
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/CHBGUMS |
MANDT | JR | EQ | AND | 0 | 0 | |||
| 3 | /BEV3/CHBALLV |
YVWDNR | JL | EQ | 0 | 0 | ||||
| 4 | /BEV3/CHBGUMS |
YVWDNR | JR | EQ | AND | 0 | 0 | |||
| 5 | /BEV3/CHBALLV |
VBKL | JL | EQ | 0 | 0 | ||||
| 6 | /BEV3/CHBGUMS |
VBKL | JR | EQ | AND | 0 | 0 | |||
| 7 | /BEV3/CHBALLV |
RI | JL | EQ | 0 | 0 | ||||
| 8 | /BEV3/CHBGUMS |
RI | JR | EQ | AND | 0 | 0 | |||
| 9 | /BEV3/CHBALLV |
VBIN | JL | EQ | 0 | 0 | ||||
| 10 | /BEV3/CHBGUMS |
VBIN | JR | EQ | AND | 0 | 0 | |||
| 11 | /BEV3/CHBALLV |
VBNR | JL | EQ | 0 | 0 | ||||
| 12 | /BEV3/CHBGUMS |
VBNR | JR | EQ | 0 | 0 | ||||
View Fields
| # | View field | Table | Field | Maintenance Flag | Key | Data element | Mod | Short Description |
|---|---|---|---|---|---|---|---|---|
| 1 |  * |
/BEV3/CHBGUMS |
* | |||||
| 2 | MANDT |
/BEV3/CHBGUMS |
MANDT | MANDT | Client | |||
| 3 | YVWDNR |
/BEV3/CHBGUMS |
YVWDNR | /BEV3/CHDTWDNR | CHD Contract Number | |||
| 4 | VBKL |
/BEV3/CHBGUMS |
VBKL | /BEV3/CHBKL | Agreement Class | |||
| 5 | RI |
/BEV3/CHBGUMS |
RI | /BEV3/CHDTRI | Rule Identifier | |||
| 6 | VBIN |
/BEV3/CHBGUMS |
VBIN | /BEV3/CHBIN | Agreement Entity | |||
| 7 | VBNR |
/BEV3/CHBGUMS |
VBNR | /BEV3/CHBNR | Agreement Number in Sequential Time Order | |||
| 8 | VBKL_WL |
/BEV3/CHBGUMS |
VBKL_WL | /BEV3/CHBKL | Agreement Class | |||
| 9 | RI_WL |
/BEV3/CHBGUMS |
RI_WL | /BEV3/CHDTRI | Rule Identifier | |||
| 10 | VBIN_WL |
/BEV3/CHBGUMS |
VBIN_WL | /BEV3/CHBIN | Agreement Entity | |||
| 11 | SRTMNT |
/BEV3/CHBGUMS |
SRTMNT | /BEV3/CHDTSORT | CH Assortment | |||
| 12 | GPROZ |
/BEV3/CHBGUMS |
GPROZ | /BEV3/CHZNSTZ | Percentage | |||
| 13 | INDRKT_FLG |
/BEV3/CHBGUMS |
INDRKT_FLG | /BEV3/CHINDRKT | Indirect Sales | |||
| 14 | DRKT_FLG |
/BEV3/CHBGUMS |
DRKT_FLG | /BEV3/CHDRKT | Direct Sales | |||
| 15 | RMKONTR |
/BEV3/CHBGUMS |
RMKONTR | /BEV3/CHRMKONTR | Confirmation Control | |||
| 16 | BEDINGG1 |
/BEV3/CHBGUMS |
BEDINGG1 | /BEV3/CHBEDINGG | Condition identifier | |||
| 17 | BEDINGG2 |
/BEV3/CHBGUMS |
BEDINGG2 | /BEV3/CHBEDINGG | Condition identifier | |||
| 18 | BEDINGG3 |
/BEV3/CHBGUMS |
BEDINGG3 | /BEV3/CHBEDINGG | Condition identifier | |||
| 19 | VBDTA |
/BEV3/CHBALLV |
VBDTA | /BEV3/CHBDTAV | Period Visible from | |||
| 20 | VBDTB |
/BEV3/CHBALLV |
VBDTB | /BEV3/CHBDTBV | Date Visible to | |||
| 21 | ANZVBNR |
/BEV3/CHBALLV |
ANZVBNR | /BEV3/CHANZVBNR | Number of Visible AGNO for an Entity | |||
| 22 | 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 |
