SAP ABAP View /BEV3/CHVTMVKTG (DB View of Visible AgCl/RI Combinations Date Concatenation)
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/CHVTMVKTG | |
| Short Description | DB View of Visible AgCl/RI Combinations Date Concatenation | |
| 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/CHBTMVKTG |
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/CHBTMVKTG |
MANDT | JR | EQ | AND | 0 | 0 | |||
| 3 | /BEV3/CHBALLV |
YVWDNR | JL | EQ | 0 | 0 | ||||
| 4 | /BEV3/CHBTMVKTG |
YVWDNR | JR | EQ | AND | 0 | 0 | |||
| 5 | /BEV3/CHBALLV |
VBKL | JL | EQ | 0 | 0 | ||||
| 6 | /BEV3/CHBTMVKTG |
VBKL | JR | EQ | AND | 0 | 0 | |||
| 7 | /BEV3/CHBALLV |
RI | JL | EQ | 0 | 0 | ||||
| 8 | /BEV3/CHBTMVKTG |
RI | JR | EQ | AND | 0 | 0 | |||
| 9 | /BEV3/CHBALLV |
VBIN | JL | EQ | 0 | 0 | ||||
| 10 | /BEV3/CHBTMVKTG |
VBIN | JR | EQ | AND | 0 | 0 | |||
| 11 | /BEV3/CHBALLV |
VBNR | JL | EQ | 0 | 0 | ||||
| 12 | /BEV3/CHBTMVKTG |
VBNR | JR | EQ | 0 | 0 | ||||
View Fields
| # | View field | Table | Field | Maintenance Flag | Key | Data element | Mod | Short Description |
|---|---|---|---|---|---|---|---|---|
| 1 |  * |
/BEV3/CHBTMVKTG |
* | |||||
| 2 | MANDT |
/BEV3/CHBTMVKTG |
MANDT | MANDT | Client | |||
| 3 | YVWDNR |
/BEV3/CHBTMVKTG |
YVWDNR | /BEV3/CHDTWDNR | CHD Contract Number | |||
| 4 | VBKL |
/BEV3/CHBTMVKTG |
VBKL | /BEV3/CHBKL | Agreement Class | |||
| 5 | RI |
/BEV3/CHBTMVKTG |
RI | /BEV3/CHDTRI | Rule Identifier | |||
| 6 | VBIN |
/BEV3/CHBTMVKTG |
VBIN | /BEV3/CHBIN | Agreement Entity | |||
| 7 | VBNR |
/BEV3/CHBTMVKTG |
VBNR | /BEV3/CHBNR | Agreement Number in Sequential Time Order | |||
| 8 | VERKKRS |
/BEV3/CHBTMVKTG |
VERKKRS | /BEV3/CHERKKRS | Concatenation Code Identifier | |||
| 9 | VERKINST |
/BEV3/CHBTMVKTG |
VERKINST | /BEV3/CHTMINSTANZ | Identification of the individual date parts | |||
| 10 | VBKL_VKTM |
/BEV3/CHBTMVKTG |
VBKL_VKTM | /BEV3/CHBKL | Agreement Class | |||
| 11 | RI_VKTM |
/BEV3/CHBTMVKTG |
RI_VKTM | /BEV3/CHDTRI | Rule Identifier | |||
| 12 | VBIN_VKTM |
/BEV3/CHBTMVKTG |
VBIN_VKTM | /BEV3/CHBIN | Agreement Entity | |||
| 13 | TMBEDVERW1 |
/BEV3/CHBTMVKTG |
TMBEDVERW1 | ANKREUZ | Field for Selecting an Entry | |||
| 14 | VBKL_VKTL1 |
/BEV3/CHBTMVKTG |
VBKL_VKTL1 | /BEV3/CHBKL | Agreement Class | |||
| 15 | RI_VKTL1 |
/BEV3/CHBTMVKTG |
RI_VKTL1 | /BEV3/CHDTRI | Rule Identifier | |||
| 16 | VBIN_VKTL1 |
/BEV3/CHBTMVKTG |
VBIN_VKTL1 | /BEV3/CHBIN | Agreement Entity | |||
| 17 | BEDINGG43 |
/BEV3/CHBTMVKTG |
BEDINGG43 | /BEV3/CHBEDINGG | Condition identifier | |||
| 18 | VBKL_VKTL2 |
/BEV3/CHBTMVKTG |
VBKL_VKTL2 | /BEV3/CHBKL | Agreement Class | |||
| 19 | RI_VKTL2 |
/BEV3/CHBTMVKTG |
RI_VKTL2 | /BEV3/CHDTRI | Rule Identifier | |||
| 20 | VBIN_VKTL2 |
/BEV3/CHBTMVKTG |
VBIN_VKTL2 | /BEV3/CHBIN | Agreement Entity | |||
| 21 | BEDINGG44 |
/BEV3/CHBTMVKTG |
BEDINGG44 | /BEV3/CHBEDINGG | Condition identifier | |||
| 22 | VBKL_VKTL3 |
/BEV3/CHBTMVKTG |
VBKL_VKTL3 | /BEV3/CHBKL | Agreement Class | |||
| 23 | RI_VKTL3 |
/BEV3/CHBTMVKTG |
RI_VKTL3 | /BEV3/CHDTRI | Rule Identifier | |||
| 24 | VBIN_VKTL3 |
/BEV3/CHBTMVKTG |
VBIN_VKTL3 | /BEV3/CHBIN | Agreement Entity | |||
| 25 | BEDINGG45 |
/BEV3/CHBTMVKTG |
BEDINGG45 | /BEV3/CHBEDINGG | Condition identifier | |||
| 26 | ABRINF6 |
/BEV3/CHBTMVKTG |
ABRINF6 | /BEV3/CHABRINF | Settlement Information Identifier | |||
| 27 | BEDINGG46 |
/BEV3/CHBTMVKTG |
BEDINGG46 | /BEV3/CHBEDINGG | Condition identifier | |||
| 28 | ABRINF7 |
/BEV3/CHBTMVKTG |
ABRINF7 | /BEV3/CHABRINF | Settlement Information Identifier | |||
| 29 | BEDINGG47 |
/BEV3/CHBTMVKTG |
BEDINGG47 | /BEV3/CHBEDINGG | Condition identifier | |||
| 30 | ABRINF8 |
/BEV3/CHBTMVKTG |
ABRINF8 | /BEV3/CHABRINF | Settlement Information Identifier | |||
| 31 | BEDINGG48 |
/BEV3/CHBTMVKTG |
BEDINGG48 | /BEV3/CHBEDINGG | Condition identifier | |||
| 32 | ABRINF9 |
/BEV3/CHBTMVKTG |
ABRINF9 | /BEV3/CHABRINF | Settlement Information Identifier | |||
| 33 | VBKL_AVVRK1 |
/BEV3/CHBTMVKTG |
VBKL_AVVRK1 | /BEV3/CHBKL | Agreement Class | |||
| 34 | RI_AVVRK1 |
/BEV3/CHBTMVKTG |
RI_AVVRK1 | /BEV3/CHDTRI | Rule Identifier | |||
| 35 | VBIN_AVVRK1 |
/BEV3/CHBTMVKTG |
VBIN_AVVRK1 | /BEV3/CHBIN | Agreement Entity | |||
| 36 | VBKL_AVVRK2 |
/BEV3/CHBTMVKTG |
VBKL_AVVRK2 | /BEV3/CHBKL | Agreement Class | |||
| 37 | RI_AVVRK2 |
/BEV3/CHBTMVKTG |
RI_AVVRK2 | /BEV3/CHDTRI | Rule Identifier | |||
| 38 | VBIN_AVVRK2 |
/BEV3/CHBTMVKTG |
VBIN_AVVRK2 | /BEV3/CHBIN | Agreement Entity | |||
| 39 | BEDINGG49 |
/BEV3/CHBTMVKTG |
BEDINGG49 | /BEV3/CHBEDINGG | Condition identifier | |||
| 40 | BEDINGG50 |
/BEV3/CHBTMVKTG |
BEDINGG50 | /BEV3/CHBEDINGG | Condition identifier | |||
| 41 | BEDINGG51 |
/BEV3/CHBTMVKTG |
BEDINGG51 | /BEV3/CHBEDINGG | Condition identifier | |||
| 42 | BEDINGG52 |
/BEV3/CHBTMVKTG |
BEDINGG52 | /BEV3/CHBEDINGG | Condition identifier | |||
| 43 | VBDTA |
/BEV3/CHBALLV |
VBDTA | /BEV3/CHBDTAV | Period Visible from | |||
| 44 | VBDTB |
/BEV3/CHBALLV |
VBDTB | /BEV3/CHBDTBV | Date Visible to | |||
| 45 | ANZVBNR |
/BEV3/CHBALLV |
ANZVBNR | /BEV3/CHANZVBNR | Number of Visible AGNO for an Entity | |||
| 46 | 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 |
