SAP ABAP View /BEV3/CHVPART (DB View of Visible AgCl/RI Combinations AG Partner)
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/CHVPART | |
| Short Description | DB View of Visible AgCl/RI Combinations AG Partner | |
| 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/CHBPART |
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/CHBPART |
MANDT | JR | EQ | AND | 0 | 0 | |||
| 3 | /BEV3/CHBALLV |
YVWDNR | JL | EQ | 0 | 0 | ||||
| 4 | /BEV3/CHBPART |
YVWDNR | JR | EQ | AND | 0 | 0 | |||
| 5 | /BEV3/CHBALLV |
VBKL | JL | EQ | 0 | 0 | ||||
| 6 | /BEV3/CHBPART |
VBKL | JR | EQ | AND | 0 | 0 | |||
| 7 | /BEV3/CHBALLV |
RI | JL | EQ | 0 | 0 | ||||
| 8 | /BEV3/CHBPART |
RI | JR | EQ | AND | 0 | 0 | |||
| 9 | /BEV3/CHBALLV |
VBIN | JL | EQ | 0 | 0 | ||||
| 10 | /BEV3/CHBPART |
VBIN | JR | EQ | AND | 0 | 0 | |||
| 11 | /BEV3/CHBALLV |
VBNR | JL | EQ | 0 | 0 | ||||
| 12 | /BEV3/CHBPART |
VBNR | JR | EQ | 0 | 0 | ||||
View Fields
| # | View field | Table | Field | Maintenance Flag | Key | Data element | Mod | Short Description |
|---|---|---|---|---|---|---|---|---|
| 1 |  * |
/BEV3/CHBPART |
* | |||||
| 2 | MANDT |
/BEV3/CHBPART |
MANDT | MANDT | Client | |||
| 3 | YVWDNR |
/BEV3/CHBPART |
YVWDNR | /BEV3/CHDTWDNR | CHD Contract Number | |||
| 4 | VBKL |
/BEV3/CHBPART |
VBKL | /BEV3/CHBKL | Agreement Class | |||
| 5 | RI |
/BEV3/CHBPART |
RI | /BEV3/CHDTRI | Rule Identifier | |||
| 6 | VBIN |
/BEV3/CHBPART |
VBIN | /BEV3/CHBIN | Agreement Entity | |||
| 7 | VBNR |
/BEV3/CHBPART |
VBNR | /BEV3/CHBNR | Agreement Number in Sequential Time Order | |||
| 8 | KUNNR_RG |
/BEV3/CHBPART |
KUNNR_RG | /BEV3/CHKUNNR_RG | Customer Number of Payer | |||
| 9 | VKORG_RG |
/BEV3/CHBPART |
VKORG_RG | /BEV3/CHKORG_RG | Post Sales Organzation | |||
| 10 | VTWEG_RG |
/BEV3/CHBPART |
VTWEG_RG | /BEV3/CHTWEG_RG | Distribution Channel Post | |||
| 11 | SPART_RG |
/BEV3/CHBPART |
SPART_RG | /BEV3/CHSPART_RG | Division Post | |||
| 12 | KUNNR_WE |
/BEV3/CHBPART |
KUNNR_WE | /BEV3/CHKUNNR_WE | Customer Number of Ship-to Party | |||
| 13 | VKORG_WE |
/BEV3/CHBPART |
VKORG_WE | /BEV3/CHKORG_WE | Sales Organization Performance | |||
| 14 | VTWEG_WE |
/BEV3/CHBPART |
VTWEG_WE | /BEV3/CHTWEG_WE | Distribution Channel Performance | |||
| 15 | SPART_WE |
/BEV3/CHBPART |
SPART_WE | /BEV3/CHSPART_WE | Division Performance | |||
| 16 | KUNNR_FI |
/BEV3/CHBPART |
KUNNR_FI | /BEV3/CHKUNNR_FI | Customer | |||
| 17 | BUKRS_FI |
/BEV3/CHBPART |
BUKRS_FI | /BEV3/CHBUKRS | Company Code | |||
| 18 | KUNNR_AG |
/BEV3/CHBPART |
KUNNR_AG | /BEV3/CHKUNNR_AG | Customer Number of Sold-to Party | |||
| 19 | KUNNR_RE |
/BEV3/CHBPART |
KUNNR_RE | /BEV3/CHKUNNR_RE | Customer Number of Bill-to Party | |||
| 20 | KUNVE |
/BEV3/CHBPART |
KUNVE | /BEV3/CHKUNVE | Distributor | |||
| 21 | VBDTA |
/BEV3/CHBALLV |
VBDTA | /BEV3/CHBDTAV | Period Visible from | |||
| 22 | VBDTB |
/BEV3/CHBALLV |
VBDTB | /BEV3/CHBDTBV | Date Visible to | |||
| 23 | ANZVBNR |
/BEV3/CHBALLV |
ANZVBNR | /BEV3/CHANZVBNR | Number of Visible AGNO for an Entity | |||
| 24 | 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 |
