SAP ABAP View /BEV3/CHVSORT (DB View of Visible AgCl/RI Combinations Assortment)
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/CHVSORT | |
| Short Description | DB View of Visible AgCl/RI Combinations Assortment | |
| 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/CHBSORT |
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/CHBSORT |
MANDT | JR | EQ | AND | 0 | 0 | |||
| 3 | /BEV3/CHBALLV |
YVWDNR | JL | EQ | 0 | 0 | ||||
| 4 | /BEV3/CHBSORT |
YVWDNR | JR | EQ | AND | 0 | 0 | |||
| 5 | /BEV3/CHBALLV |
VBKL | JL | EQ | 0 | 0 | ||||
| 6 | /BEV3/CHBSORT |
VBKL | JR | EQ | AND | 0 | 0 | |||
| 7 | /BEV3/CHBALLV |
RI | JL | EQ | 0 | 0 | ||||
| 8 | /BEV3/CHBSORT |
RI | JR | EQ | AND | 0 | 0 | |||
| 9 | /BEV3/CHBALLV |
VBIN | JL | EQ | 0 | 0 | ||||
| 10 | /BEV3/CHBSORT |
VBIN | JR | EQ | AND | 0 | 0 | |||
| 11 | /BEV3/CHBALLV |
VBNR | JL | EQ | 0 | 0 | ||||
| 12 | /BEV3/CHBSORT |
VBNR | JR | EQ | 0 | 0 | ||||
View Fields
| # | View field | Table | Field | Maintenance Flag | Key | Data element | Mod | Short Description |
|---|---|---|---|---|---|---|---|---|
| 1 |  * |
/BEV3/CHBSORT |
* | |||||
| 2 | MANDT |
/BEV3/CHBSORT |
MANDT | MANDT | Client | |||
| 3 | YVWDNR |
/BEV3/CHBSORT |
YVWDNR | /BEV3/CHDTWDNR | CHD Contract Number | |||
| 4 | VBKL |
/BEV3/CHBSORT |
VBKL | /BEV3/CHBKL | Agreement Class | |||
| 5 | RI |
/BEV3/CHBSORT |
RI | /BEV3/CHDTRI | Rule Identifier | |||
| 6 | VBIN |
/BEV3/CHBSORT |
VBIN | /BEV3/CHBIN | Agreement Entity | |||
| 7 | VBNR |
/BEV3/CHBSORT |
VBNR | /BEV3/CHBNR | Agreement Number in Sequential Time Order | |||
| 8 | SORTIMENT1 |
/BEV3/CHBSORT |
SORTIMENT1 | /BEV3/CHDTSORT | CH Assortment | |||
| 9 | SORTIMENT2 |
/BEV3/CHBSORT |
SORTIMENT2 | /BEV3/CHDTSORT | CH Assortment | |||
| 10 | SORTIMENT3 |
/BEV3/CHBSORT |
SORTIMENT3 | /BEV3/CHDTSORT | CH Assortment | |||
| 11 | SORTIMENT4 |
/BEV3/CHBSORT |
SORTIMENT4 | /BEV3/CHDTSORT | CH Assortment | |||
| 12 | SORTIMENT5 |
/BEV3/CHBSORT |
SORTIMENT5 | /BEV3/CHDTSORT | CH Assortment | |||
| 13 | SORTIMENT6 |
/BEV3/CHBSORT |
SORTIMENT6 | /BEV3/CHDTSORT | CH Assortment | |||
| 14 | SORTIMENT7 |
/BEV3/CHBSORT |
SORTIMENT7 | /BEV3/CHDTSORT | CH Assortment | |||
| 15 | SORTIMENT8 |
/BEV3/CHBSORT |
SORTIMENT8 | /BEV3/CHDTSORT | CH Assortment | |||
| 16 | SORTIMENT9 |
/BEV3/CHBSORT |
SORTIMENT9 | /BEV3/CHDTSORT | CH Assortment | |||
| 17 | SORTIMENT10 |
/BEV3/CHBSORT |
SORTIMENT10 | /BEV3/CHDTSORT | CH Assortment | |||
| 18 | SORTIMENT11 |
/BEV3/CHBSORT |
SORTIMENT11 | /BEV3/CHDTSORT | CH Assortment | |||
| 19 | SORTIMENT12 |
/BEV3/CHBSORT |
SORTIMENT12 | /BEV3/CHDTSORT | CH Assortment | |||
| 20 | SORTIMENT13 |
/BEV3/CHBSORT |
SORTIMENT13 | /BEV3/CHDTSORT | CH Assortment | |||
| 21 | SORTIMENT14 |
/BEV3/CHBSORT |
SORTIMENT14 | /BEV3/CHDTSORT | CH Assortment | |||
| 22 | SORTIMENT15 |
/BEV3/CHBSORT |
SORTIMENT15 | /BEV3/CHDTSORT | CH Assortment | |||
| 23 | BEDINGG1 |
/BEV3/CHBSORT |
BEDINGG1 | /BEV3/CHBEDINGG | Condition identifier | |||
| 24 | BEDINGG2 |
/BEV3/CHBSORT |
BEDINGG2 | /BEV3/CHBEDINGG | Condition identifier | |||
| 25 | BEDINGG3 |
/BEV3/CHBSORT |
BEDINGG3 | /BEV3/CHBEDINGG | Condition identifier | |||
| 26 | VBDTA |
/BEV3/CHBALLV |
VBDTA | /BEV3/CHBDTAV | Period Visible from | |||
| 27 | VBDTB |
/BEV3/CHBALLV |
VBDTB | /BEV3/CHBDTBV | Date Visible to | |||
| 28 | ANZVBNR |
/BEV3/CHBALLV |
ANZVBNR | /BEV3/CHANZVBNR | Number of Visible AGNO for an Entity | |||
| 29 | 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 |
