SAP ABAP Table /BEV3/CH_ALV_CONTRACTLIST (CH: ALV Structure for Contract List (Evaluation Structure))
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
Basic Data
Table Category INTTAB    Structure 
Structure /BEV3/CH_ALV_CONTRACTLIST   Table Relationship Diagram
Short Description CH: ALV Structure for Contract List (Evaluation Structure)    
Delivery and Maintenance
Pool/cluster      
Delivery Class      
Data Browser/Table View Maintenance     Display/Maintenance Allowed with Restrictions 
Components
     
Field Key Data Element Domain Data
Type
Length Decimal
Places
Short Description Check
table
1 .INCLUDE       0   0   CDP: Contract Data 1 - General Contract Data  
2 MANDT MANDT MANDT CLNT 3   0   Client *
3 YVWDNR /BEV3/CHDTWDNR /BEV3/CHDOWDNR NUMC 13   0   CHD Contract Number  
4 DATE_TO DATBI DATUM DATS 8   0   Valid To Date  
5 DATE_FROM DATAB DATUM DATS 8   0   Valid-From Date  
6 CHORG /BEV3/CHOE /BEV3/CHDOVORGE NUMC 4   0   CH Organizational Unit /BEV3/CHTBVORGE
7 VWDART /BEV3/CHDTVWDART /BEV3/CHDOVWDART NUMC 4   0   Contract Handling Document Type /BEV3/CHTVWDART
8 MUSTER /BEV3/CHMUSTER /BEV3/CHTXT01 CHAR 1   0   Model Indicator  
9 CTR_BUKRS /BEV3/CHCTR_BUKRS BUKRS CHAR 4   0   CH: Contract Company Code T001
10 CTR_VIEW /BEV3/CHERTSI /BEV3/CHERTSI CHAR 1   0   Contract view  
11 CLASS1 /BEV3/CHCTR_CLASS1 /BEV3/CHKLASS NUMC 5   0   CH: Classification 1 for Contract /BEV3/CHCTKLAS1
12 CLASS2 /BEV3/CHCTR_CLASS2 /BEV3/CHKLASS NUMC 5   0   CH: Classification 2 for Contract /BEV3/CHCTKLAS2
13 CLASS3 /BEV3/CHCTR_CLASS3 /BEV3/CHKLASS NUMC 5   0   CH: Classification 3 for Contract /BEV3/CHCTKLAS3
14 CLASS4 /BEV3/CHCTR_CLASS4 /BEV3/CHKLASS NUMC 5   0   CH: Classification 4 for Contract /BEV3/CHCTKLAS4
15 CLASS5 /BEV3/CHCTR_CLASS5 /BEV3/CHKLASS NUMC 5   0   CH: Classification 5 for Contract /BEV3/CHCTKLAS5
16 LANGU_ORIGINAL /BEV3/CHCTR_LANGU_ORIGINAL SPRAS LANG 1   0   CH: Original Language of Contract T002
17 OLD_CONTRACT /BEV3/CHWDNRALT /BEV3/CHWDNRALT CHAR 18   0   CHD number from existing system or reference number  
18 PERIOD_FROM /BEV3/CHCTR_PERIOD_FROM   DATS 8   0   CH: Start of Contract  
19 PERIOD_TO /BEV3/CHCTR_PERIOD_TO   DATS 8   0   CH: End of Contract  
20 PERIOD_FROM_OP /BEV3/CHCTR_PERIOD_FROM_OP   DATS 8   0   CH: Operative Start of Contract  
21 PERIOD_TO_OP /BEV3/CHCTR_PERIOD_TO_OP   DATS 8   0   CH: Operative End of Contract  
22 PERIOD_MONTH /BEV3/CHPERIOD_MONTH /BEV3/CHMONTH NUMC 3   0   CH: Contract Validity Period in Months  
23 FLAG_PERIODEND /BEV3/CHFLAG_PERIODEND /BEV3/CHANKREUZ CHAR 1   0   CH: Flag Fixed-Term Contract  
24 CTR_CURRENCY /BEV3/CHCTR_CURRENCY WAERS CUKY 5   0   CH: Contract Currency TCURC
25 CTR_ACC_PARTY /BEV3/CHCTR_PARTY_R KUNNR CHAR 10   0   Ch: Contract Partner (Contractee) *
26 VKORG_RG /BEV3/CHKORG_RG VKORG CHAR 4   0   Post Sales Organzation TVKO
27 VTWEG_RG /BEV3/CHTWEG_RG VTWEG CHAR 2   0   Distribution Channel Post TVTW
28 SPART_RG /BEV3/CHSPART_RG SPART CHAR 2   0   Division Post TSPA
29 CTR_OBJECT /BEV3/CH_OBJECT KUNNR CHAR 10   0   CH: Object Number (Sales Outlet) *
30 VKORG_WE /BEV3/CHKORG_WE VKORG CHAR 4   0   Sales Organization Performance TVKO
31 VTWEG_WE /BEV3/CHTWEG_WE VTWEG CHAR 2   0   Distribution Channel Performance TVTW
32 SPART_WE /BEV3/CHSPART_WE SPART CHAR 2   0   Division Performance TSPA
33 DEBITOR /BEV3/CHKUNNR_FI KUNNR CHAR 10   0   Customer *
34 BUKRS_DEBITOR /BEV3/CHBUKRS BUKRS CHAR 4   0   Company Code T001
35 ADRESS_CUSTOMER /BEV3/CHCUSTADRESS /BEV3/CHADRESS CHAR 50   0   CH: Customer Address  
36 ADRESS_OBJ /BEV3/CHOBJADRESS /BEV3/CHADRESS CHAR 50   0   CH: Object Address  
37 WHOLESALER1 /BEV3/CHKUNVE KUNNR CHAR 10   0   Distributor *
38 WHOLESALER2 /BEV3/CHKUNVE KUNNR CHAR 10   0   Distributor *
39 WHOLESALER3 /BEV3/CHKUNVE KUNNR CHAR 10   0   Distributor *
40 ADRESS_WHOLES1 /BEV3/CHWSADRESS /BEV3/CHADRESS CHAR 50   0   CH: Distributor's Address  
41 ADRESS_WHOLES2 /BEV3/CHWSADRESS /BEV3/CHADRESS CHAR 50   0   CH: Distributor's Address  
42 ADRESS_WHOLES3 /BEV3/CHWSADRESS /BEV3/CHADRESS CHAR 50   0   CH: Distributor's Address  
43 DEPEND_CTR1 /BEV3/CHWDNR_ABW /BEV3/CHDOWDNR NUMC 13   0   Deviating contract number  
44 DEPEND_CTR2 /BEV3/CHWDNR_ABW /BEV3/CHDOWDNR NUMC 13   0   Deviating contract number  
45 DEPEND_CTR3 /BEV3/CHWDNR_ABW /BEV3/CHDOWDNR NUMC 13   0   Deviating contract number  
46 DEPEND_CTR4 /BEV3/CHWDNR_ABW /BEV3/CHDOWDNR NUMC 13   0   Deviating contract number  
47 BZV_PERIOD_FROM /BEV3/CHBZV_DATE_FROM   DATS 8   0   CH: Purchase Commitment From Date  
48 BZV_PERIOD_TO /BEV3/CHBZV_DATE_TO   DATS 8   0   CH: Purchase Commitment To Date  
49 BZV_ABS_CTR /BEV3/CHCTR_ABS /BEV3/CHMNGE QUAN 15   5   CH: Total Purchases (Contract)  
50 BZV_ABS_YEAR /BEV3/CHYEAR_ABS /BEV3/CHMNGE QUAN 15   5   CH: Annual Quantity-Related Sales (Target Purchases)  
51 BZV_ABS_MONTH /BEV3/CHMONTH_ABS /BEV3/CHMNGE QUAN 15   5   CH: Monthly Quantity-Related Sales (Target Purchase)  
52 BZV_ABS_UNIT /BEV3/CH_BZV_MEINH MEINS UNIT 3   0   CH: Unit of Measure of Purchase Commitment T006
53 BZV_ABS_SRTMNT /BEV3/CHBZV_SORT_ABS /BEV3/CHDOSORT CHAR 18   0   CH: Quantity-Related Sales Assortment Purchase Commitment  
54 BZV_ABS_STAF_BON /BEV3/CHBZV_STAF_ABS_BON /BEV3/CHSTAFID CHAR 6   0   CH: Quantity-Related Sales Scale ID Rebate /BEV3/CHCTSTAF
55 BZV_ABS_STAF_MAL /BEV3/CHBZV_STAF_ABS_MAL /BEV3/CHSTAFID CHAR 6   0   CH: Quantity-Related Sales Scale ID Penalty /BEV3/CHCTSTAF
56 BZV_ABS_WERT_BON /BEV3/CHBZV_WERT_ABS_BON /BEV3/CHDOCUR17_5 CURR 17   5   CH: Valuation Quantity-Related Sales Rebate per UoM  
57 BZV_ABS_WERT_MAL /BEV3/CHBZV_WERT_ABS_MAL /BEV3/CHDOCUR17_5 CURR 17   5   CH: Valuation Quantity-Related Sales Penalty per UoM  
58 BZV_ABS_WERT_WA /BEV3/CHBZV_WERT_ABS_WA /BEV3/CHDOCUR17_5 CURR 17   5   CH: Valuation Quantity-Related Sales Value Clearing per UoM  
59 BZV_ABS_CURR /BEV3/CH_BZV_ABS_CURRENCY WAERS CUKY 5   0   CH: Currency Indicator of Purchase Commitment (Sales) TCURC
60 BZV_ABS_TOL_BON /BEV3/CHBZV_TOL_ABS_BON /BEV3/CHPRZ43 DEC 7   3   Ch: % Tolerance Quantity-Related Sales Rebate  
61 BZV_ABS_TOL_MAL /BEV3/CHBZV_TOL_ABS_MAL /BEV3/CHPRZ43 DEC 7   3   CH: % Tolerance Quantity-Related Sales Penalty  
62 BZV_ABS_TOL_WA /BEV3/CHBZV_TOL_ABS_WA /BEV3/CHPRZ43 DEC 7   3   CH: % Tolerance Quantity-Related Sales Value Clearing  
63 BZV_UMS_CTR /BEV3/CHCTR_UMS CURR16 CURR 16   2   CH: Total Sales (Contract)  
64 BZV_UMS_YEAR /BEV3/CHYEAR_UMS CURR16 CURR 16   2   CH: Annual Sales (Target)  
65 BZV_UMS_MONTH /BEV3/CHMONTH_UMS CURR16 CURR 16   2   CH: Monthly Sales (Target)  
66 BZV_UMS_CURR /BEV3/CH_BZV_CURRENCY WAERS CUKY 5   0   CH: Currency Indicator of Purchase Commitment TCURC
67 BZV_UMS_SRTMNT /BEV3/CHBZV_SORT_UMS /BEV3/CHDOSORT CHAR 18   0   CH: Value-Related Sales Assortment Purchase Commitment  
68 BZV_UMS_STAF_BON /BEV3/CHBZV_STAF_UMS_BON /BEV3/CHSTAFID CHAR 6   0   CH: Value-Related Sales Scale ID Rebate /BEV3/CHCTSTAF
69 BZV_UMS_STAF_MAL /BEV3/CHBZV_STAF_UMS_MAL /BEV3/CHSTAFID CHAR 6   0   CH: Value-Related Sales Scale ID Penalty /BEV3/CHCTSTAF
70 BZV_UMS_PRZ_BON /BEV3/CHBZV_PRZ_UMS_BON /BEV3/CHPRZ43 DEC 7   3   CH: % Valuation Value-Related Sales Rebate  
71 BZV_UMS_PRZ_MAL /BEV3/CHBZV_PRZ_UMS_MAL /BEV3/CHPRZ43 DEC 7   3   CH: % Valuation Value-Related Sales Penalty  
72 BZV_UMS_PRZ_WA /BEV3/CHBZV_PRZ_UMS_WA /BEV3/CHPRZ43 DEC 7   3   CH: % Valuation Value-Related Sales Value Clearing  
73 BZV_UMS_TOL_BON /BEV3/CHBZV_TOL_UMS_BON /BEV3/CHPRZ43 DEC 7   3   CH: % Tolerance Value-Related Sales Rebate  
74 BZV_UMS_TOL_MAL /BEV3/CHBZV_TOL_UMS_MAL /BEV3/CHPRZ43 DEC 7   3   CH: % Tolerance Value-Related Sales Penalty  
75 BZV_UMS_TOL_WA /BEV3/CHBZV_TOL_UMS_WA /BEV3/CHPRZ43 DEC 7   3   CH: % Tolerance Value-Related Sales Value Clearing  
76 AUS_DATE_FROM /BEV3/CHAUS_DATE_FROM   DATS 8   0   CH: Suspension From-Date  
77 AUS_DATE_TO /BEV3/CHAUS_DATE_TO   DATS 8   0   CH: Suspension To Date  
78 AUS_PERIOD_MONTH /BEV3/CHAUS_PERIOD_MONTH /BEV3/CHMONTH NUMC 3   0   CH: Suspension Period in Months  
79 AUS_COUNT /BEV3/CHAUS_COUNT   NUMC 3   0   CH: Number of Suspensions  
80 AUS_FLAG_PERIOD /BEV3/CHAUS_FLAG /BEV3/CHANKREUZ CHAR 1   0   CH: Periodic Suspension Flag  
81 OPT_NEXT_DATE /BEV3/CHOPTION_DATE   DATS 8   0   CH: Option Date  
82 OPT_PERIOD_MONTH /BEV3/CHOPT_PERIOD_MONTH /BEV3/CHMONTH NUMC 3   0   CH: Option Period in Months  
83 OPT_COUNT /BEV3/CHOPT_COUNT   NUMC 3   0   CH: Number of Options  
84 PROLONG_PERIOD /BEV3/CHPROLONG_PERIOD_MONTH /BEV3/CHMONTH NUMC 3   0   CH: Prolongation Period in Months  
85 NOTICE_DATE /BEV3/CHNOTICE_DATE   DATS 8   0   CH: Notice Date  
86 NOTICE_TO_DATE /BEV3/CHNOTICE_TO_DATE   DATS 8   0   CH: Contract Termination Date:  
87 NOTICE_PER_MONTH /BEV3/CHNOTICE_PERIOD_MONTH /BEV3/CHMONTH NUMC 3   0   CH: Notice Period in Months  
88 NOTICE_PERIOD /BEV3/CHNOTICE_PERIOD /BEV3/CHMONTH NUMC 3   0   CH: Notice Period  
89 NOTICE_QUANTITY /BEV3/CHNOTICE_QUANTITY /BEV3/CHMNGE QUAN 15   5   CH: Notice Quantity  
90 NOTICE_UNIT /BEV3/CHNOTICE_UNIT MEINS UNIT 3   0   CH: Unit of Measure for Notice Quantity *
91 SEC_COUNT /BEV3/CHSECURITY_COUNT   NUMC 3   0   CH: Number of Collaterals  
92 SEC_AMOUNT /BEV3/CHSECURITY_AMOUNT CURR16 CURR 16   2   CH: Value of Collateral  
93 SEC_GRDPFD /BEV3/CHSECURITY_FLAG_GRDPFD /BEV3/CHANKREUZ CHAR 1   0   CH: Flag Mortgage Collateral  
94 SEC_IMPORTANT /BEV3/CHSECURITY_FLAG /BEV3/CHANKREUZ CHAR 1   0   CH: Flag Important Collateral  
95 REC_TIMESTAMP /BEV3/CHTIMESTAMP TIMESTAMP CHAR 14   0   CH: Time Stamp  
96 AMOUNT_BW /BEV3/CHBTRG_BW CURR16 CURR 16   2   CH: Approved Amount  
97 BW_CURRENCY /BEV3/CH_BW_CURRENCY WAERS CUKY 5   0   CH: Currency Indicator of Approved Amount *
98 AMOUNT_AZ /BEV3/CHBTRG_AZ CURR16 CURR 16   2   CH: Payment  
99 AZ_CURRENCY /BEV3/CH_AZ_CURRENCY WAERS CUKY 5   0   CH: Currency Indicator of Payment *
100 AZ_FIRST_DATE /BEV3/CH_DATE_FIRST_AZ   DATS 8   0   CH: Date of First Payment  
101 AMOUNT_AN /BEV3/CHBTRG_AN CURR16 CURR 16   2   CH: Annuity  
102 AN_CURRENCY /BEV3/CH_AN_CURRENCY WAERS CUKY 5   0   CH: Currency Indicator of Annuity *
103 PERIOD_AN /BEV3/CH_PERIOD_AN /BEV3/CHDOPG CHAR 4   0   CH: Periodicity of Annuity *
104 AMOUNT_TG /BEV3/CHBTRG_TG CURR16 CURR 16   2   CH: Redemption Amount  
105 TG_CURRENCY /BEV3/CH_TG_CURRENCY WAERS CUKY 5   0   CH: Currency Indicator for Repayment *
106 PERIOD_TG /BEV3/CH_PERIOD_TG /BEV3/CHDOPG CHAR 4   0   CH: Periodicity of Repayment *
107 AMOUNT_ZI /BEV3/CHBTRG_ZI CURR16 CURR 16   2   CH: Interest Amount  
108 ZI_CURRENCY /BEV3/CH_ZI_CURRENCY WAERS CUKY 5   0   CH: Currency Indicator of Interest Amount *
109 INTEREST_RATE /BEV3/CHZSATZ /BEV3/CHPRZ43 DEC 7   3   Interest rate  
110 ZI_EXTERN /BEV3/CH_ZI_EXTERN ZIREFKU CHAR 10   0   CH: Interest Key for External Interest Rate *
111 ZI_INTERN /BEV3/CHZNSCHL /BEV3/CHZNSCHL CHAR 6   0   CH Interest Key  
112 INTEREST_MIN /BEV3/CH_ZI_MIN /BEV3/CHPRZ43 DEC 7   3   CH: Minimum Interest Rate  
113 INTEREST_MAX /BEV3/CH_ZI_MAX /BEV3/CHPRZ43 DEC 7   3   CH: Maximum Interest Rate  
114 INTEREST_DIFF /BEV3/CH_ZI_DIFF /BEV3/CHPRZ43 DEC 7   3   CH: Interest Variance  
115 PERIOD_ZI /BEV3/CH_PERIOD_ZI /BEV3/CHDOPG CHAR 4   0   CH: Periodicity of Interest Payment *
116 AMOUNT_VG /BEV3/CHBTRG_VG CURR16 CURR 16   2   CH: Fixed Refund  
117 VG_CURRENCY /BEV3/CH_VG_CURRENCY WAERS CUKY 5   0   CH: Currency Indicator of Remuneration Amount *
118 PERIOD_VG /BEV3/CH_PERIOD_VG /BEV3/CHDOPG CHAR 4   0   CH: Periodicity of Fixed Remuneration (Remun.Amount) *
119 ABS_VG1 /BEV3/CHVG_WERT1 /BEV3/CHDOCUR17_5 CURR 17   5   CH: Refund Value 1  
120 ABS_CURRENCY_VG1 /BEV3/CH_VG1_CURRENCY WAERS CUKY 5   0   CH: Currency Indicator of Remuneration 1 *
121 ABS_UNIT_VG1 /BEV3/CH_VG1_MEINH MEINS UNIT 3   0   CH: Unit of Measure of Remuneration 1 *
122 ABS_PERIOD_VG1 /BEV3/CH_PERIOD_VG1 /BEV3/CHDOPG CHAR 4   0   CH: Periodicity of Variable Remuneration 1 *
123 ABS_VG2 /BEV3/CHVG_WERT2 /BEV3/CHDOCUR17_5 CURR 17   5   CH: Refund Value 2  
124 ABS_CURRENCY_VG2 /BEV3/CH_VG2_CURRENCY WAERS CUKY 5   0   CH: Currency Indicator of Remuneration 2 *
125 ABS_UNIT_VG2 /BEV3/CH_VG2_MEINH MEINS UNIT 3   0   CH: Unit of Measure of Remuneration 2 *
126 ABS_PERIOD_VG2 /BEV3/CH_PERIOD_VG2 /BEV3/CHDOPG CHAR 4   0   CH: Periodicity of Variable Remuneration 2 *
127 ABS_VG3 /BEV3/CHVG_WERT3 /BEV3/CHDOCUR17_5 CURR 17   5   CH: Refund Value 3  
128 ABS_CURRENCY_VG3 /BEV3/CH_VG3_CURRENCY WAERS CUKY 5   0   CH: Currency Indicator of Remuneration 3 *
129 ABS_UNIT_VG3 /BEV3/CH_VG3_MEINH MEINS UNIT 3   0   CH: Unit of Measure of Remuneration 3 *
130 ABS_PERIOD_VG3 /BEV3/CH_PERIOD_VG3 /BEV3/CHDOPG CHAR 4   0   CH: Periodicity of Variable Remuneration 3 *
131 ABS_VG4 /BEV3/CHVG_WERT4 /BEV3/CHDOCUR17_5 CURR 17   5   CH: Refund Value 4  
132 ABS_CURRENCY_VG4 /BEV3/CH_VG4_CURRENCY WAERS CUKY 5   0   CH: Currency Indicator of Remuneration 4 *
133 ABS_UNIT_VG4 /BEV3/CH_VG4_MEINH MEINS UNIT 3   0   CH: Unit of Measure of Remuneration 4 *
134 ABS_PERIOD_VG4 /BEV3/CH_PERIOD_VG4 /BEV3/CHDOPG CHAR 4   0   CH: Periodicity of Variable Remuneration 4 *
135 ABS_VG5 /BEV3/CHVG_WERT5 /BEV3/CHDOCUR17_5 CURR 17   5   CH: Refund Value 5  
136 ABS_CURRENCY_VG5 /BEV3/CH_VG5_CURRENCY WAERS CUKY 5   0   CH: Currency Indicator of Remuneration 5 *
137 ABS_UNIT_VG5 /BEV3/CH_VG5_MEINH MEINS UNIT 3   0   CH: Unit of Measure of Remuneration 5 *
138 ABS_PERIOD_VG5 /BEV3/CH_PERIOD_VG5 /BEV3/CHDOPG CHAR 4   0   CH: Periodicity of Variable Remuneration 5 *
139 ABS_VG6 /BEV3/CHVG_WERT6 /BEV3/CHDOCUR17_5 CURR 17   5   CH: Refund Value 6  
140 ABS_CURRENCY_VG6 /BEV3/CH_VG6_CURRENCY WAERS CUKY 5   0   CH: Currency Indicator of Remuneration 6 *
141 ABS_UNIT_VG6 /BEV3/CH_VG6_MEINH MEINS UNIT 3   0   CH: Unit of Measure of Remuneration 6 *
142 ABS_PERIOD_VG6 /BEV3/CH_PERIOD_VG6 /BEV3/CHDOPG CHAR 4   0   CH: Periodicity of Variable Remuneration 6 *
143 ABS_VG7 /BEV3/CHVG_WERT7 /BEV3/CHDOCUR17_5 CURR 17   5   CH: Refund Value 7  
144 ABS_CURRENCY_VG7 /BEV3/CH_VG7_CURRENCY WAERS CUKY 5   0   CH: Currency Indicator of Remuneration 7 *
145 ABS_UNIT_VG7 /BEV3/CH_VG7_MEINH MEINS UNIT 3   0   CH: Unit of Measure of Remuneration 7 *
146 ABS_PERIOD_VG7 /BEV3/CH_PERIOD_VG7 /BEV3/CHDOPG CHAR 4   0   CH: Period of Variable Remuneration 7 *
147 ABS_RS1 /BEV3/CHRS_WERT1 /BEV3/CHDOCUR17_5 CURR 17   5   CH: Reserves Value 1  
148 ABS_CURRENCY_RS1 /BEV3/CH_RS1_CURRENCY WAERS CUKY 5   0   CH: Currency Indicator of Reserves 1 *
149 ABS_UNIT_RS1 /BEV3/CH_RS1_MEINH MEINS UNIT 3   0   CH: Unit of Measure of Reserves 1 *
150 ABS_PERIOD_RS1 /BEV3/CH_PERIOD_RS1 /BEV3/CHDOPG CHAR 4   0   CH: Periodicity of Variable Reserves 1 *
151 UMS_VG1 /BEV3/CHVG_PRZ1 /BEV3/CHPRZ43 DEC 7   3   CH: % Valuation Sales Refund 1  
152 UMS_PERIOD_VG1 /BEV3/CH_PERIOD_UMS_VG1 /BEV3/CHDOPG CHAR 4   0   CH: Periodicity of Sales Remuneration 1 *
153 UMS_VG2 /BEV3/CHVG_PRZ2 /BEV3/CHPRZ43 DEC 7   3   CH: % Valuation Sales Refund 2  
154 UMS_PERIOD_VG2 /BEV3/CH_PERIOD_UMS_VG2 /BEV3/CHDOPG CHAR 4   0   CH: Periodicity of Sales Remuneration 2 *
155 UMS_VG3 /BEV3/CHVG_PRZ3 /BEV3/CHPRZ43 DEC 7   3   CH: % Valuation Sales Refund 3  
156 UMS_PERIOD_VG3 /BEV3/CH_PERIOD_UMS_VG3 /BEV3/CHDOPG CHAR 4   0   CH: Periodicity of Sales Remuneration 3 *
157 UMS_VG4 /BEV3/CHVG_PRZ4 /BEV3/CHPRZ43 DEC 7   3   CH: % Valuation Sales Refund 4  
158 UMS_PERIOD_VG4 /BEV3/CH_PERIOD_UMS_VG4 /BEV3/CHDOPG CHAR 4   0   CH: Periodicity of Sales Remuneration 4 *
159 UMS_VG5 /BEV3/CHVG_PRZ5 /BEV3/CHPRZ43 DEC 7   3   CH: % Valuation Sales Refund 5  
160 UMS_PERIOD_VG5 /BEV3/CH_PERIOD_UMS_VG5 /BEV3/CHDOPG CHAR 4   0   CH: Periodicity of Sales Remuneration 5 *
161 AMOUNT_ZS /BEV3/CHBTRG_ZS CURR16 CURR 16   2   CH: Allowance (Fixed)  
162 ZS_CURRENCY /BEV3/CH_ZS_CURRENCY WAERS CUKY 5   0   CH: Currency Indicator of Allowance *
163 PERIOD_ZS /BEV3/CH_PERIOD_ZS /BEV3/CHDOPG CHAR 4   0   CH: Periodicity of Allowance *
164 PERIOD_MP_NK /BEV3/CH_PERIOD_MP /BEV3/CHDOPG CHAR 4   0   CH: Periodicity of Rent & Lease *
165 MP_CURRENCY /BEV3/CH_MP_CURRENCY WAERS CUKY 5   0   CH: Currency Indicator of Rent & Lease *
166 AMOUNT_MP_OBJ /BEV3/CHBTRG_MP_OBJ CURR16 CURR 16   2   CH: Object Lease (Rent)  
167 AMOUNT_MP_WHG /BEV3/CHBTRG_MP_WHG CURR16 CURR 16   2   CH: Apartment Rent  
168 AMOUNT_MP_GAR /BEV3/CHBTRG_MP_GAR CURR16 CURR 16   2   CH: Garage Rent  
169 AMOUNT_MP_4 /BEV3/CHBTRG_MP_4 CURR16 CURR 16   2   CH: Rent  
170 AMOUNT_MP_VK /BEV3/CHBTRG_MP_VK CURR16 CURR 16   2   CH: Management Costs  
171 AMOUNT_MP_NK1 /BEV3/CHBTRG_MP_NK1 CURR16 CURR 16   2   CH: Incidentals Cost Element 1  
172 AMOUNT_MP_NK2 /BEV3/CHBTRG_MP_NK2 CURR16 CURR 16   2   CH: Incidentals Cost Element 2  
173 AMOUNT_MP_NK3 /BEV3/CHBTRG_MP_NK3 CURR16 CURR 16   2   CH: Incidentals Cost Element 3  
174 AMOUNT_MP_NK4 /BEV3/CHBTRG_MP_NK4 CURR16 CURR 16   2   CH: Incidentals Cost Element 4  
175 AMOUNT_MP_NK5 /BEV3/CHBTRG_MP_NK5 CURR16 CURR 16   2   CH: Incidentals Cost Element 5  
176 AMOUNT_MP_NK6 /BEV3/CHBTRG_MP_NK6 CURR16 CURR 16   2   CH: Incidentals Cost Element 6  
177 AMOUNT_MP_NK7 /BEV3/CHBTRG_MP_NK7 CURR16 CURR 16   2   CH: Incidentals Cost Element 7  
178 AMOUNT_MP_NK8 /BEV3/CHBTRG_MP_NK8 CURR16 CURR 16   2   CH: Incidentals Cost Element 8  
179 AMOUNT_MP_NK9 /BEV3/CHBTRG_MP_NK9 CURR16 CURR 16   2   CH: Incidentals Cost Element 9  
180 AMOUNT_MP_NK10 /BEV3/CHBTRG_MP_NK10 CURR16 CURR 16   2   CH: Incidentals Cost Element 10  
181 EXT_LIST_NK /BEV3/CH_LIST_NK /BEV3/CHBTRGLST CHAR 13   0   CH: External Amount List for Incidentals *
182 PERIOD_NK /BEV3/CH_PERIOD_NK /BEV3/CHDOPG CHAR 4   0   CH: Periodicity of Expense Settlement for Rent & Lease *
183 AMOUNT_IM /BEV3/CHBTRG_IM CURR16 CURR 16   2   CH: Fittings and Equipment Rent  
184 IM_CURRENCY /BEV3/CH_IM_CURRENCY WAERS CUKY 5   0   CH: Currency Indicator for Fittings and Equipment Rent *
185 PERIOD_IM /BEV3/CH_PERIOD_IM /BEV3/CHDOPG CHAR 4   0   CH: Periodicity of Rent for Fittings and Equipment *
186 AMOUNT_AM1 /BEV3/CHBTRG_AM1 CURR16 CURR 16   2   CH: Vending Machine Rent 1  
187 AM1_CURRENCY /BEV3/CH_AM1_CURRENCY WAERS CUKY 5   0   CH: Currency Indicator of Vending Machine Rent 1 *
188 PERIOD_AM1 /BEV3/CH_PERIOD_AM1 /BEV3/CHDOPG CHAR 4   0   CH: Periodicity of Vending Machine Rent 1 *
189 AMOUNT_AM2 /BEV3/CHBTRG_AM2 CURR16 CURR 16   2   CH: Vending Machine Rent 2  
190 AM2_CURRENCY /BEV3/CH_AM2_CURRENCY WAERS CUKY 5   0   CH: Currency Indicator of Vending Machine Rent 2 *
191 PERIOD_AM2 /BEV3/CH_PERIOD_AM2 /BEV3/CHDOPG CHAR 4   0   CH: Periodicity of Vending Machine Rent 2 *
192 AMOUNT_AM3 /BEV3/CHBTRG_AM3 CURR16 CURR 16   2   CH: Vending Machine rent 3  
193 AM3_CURRENCY /BEV3/CH_AM3_CURRENCY WAERS CUKY 5   0   CH: Currency Indicator of Vending Machine Rent 3 *
194 PERIOD_AM3 /BEV3/CH_PERIOD_AM3 /BEV3/CHDOPG CHAR 4   0   CH: Periodicity of Vending Machine Rent 3 *
195 AMOUNT_KT /BEV3/CHBTRG_KT CURR16 CURR 16   2   CH: Security Deposit Amount  
196 AMOUNT_ANSP /BEV3/CHBTRG_ANSP CURR16 CURR 16   2   CH: Fixed Saving Installment Deposit  
197 KT_CURRENCY /BEV3/CH_KT_CURRENCY WAERS CUKY 5   0   CH: Currency Indicator of Security Deposit *
198 PERIOD_ANSP /BEV3/CH_PERIOD_ANSP /BEV3/CHDOPG CHAR 4   0   CH: Periodicity of Fixed Savings Installment *
199 KT_ANSP_V /BEV3/CHKT_WERT1 /BEV3/CHDOCUR17_5 CURR 17   5   CH: Variable Saving Installment Security Deposit  
200 KT_CURRENCY_V /BEV3/CH_KTV_CURRENCY WAERS CUKY 5   0   CH: Currency Indicator of Variable Savings Installmt/Deposit *
201 KT_UNIT_V /BEV3/CH_KTV_MEINH MEINS UNIT 3   0   CH: Unit of Measure of Variable Savings Installmt/Deposit *
202 KT_PERIOD_V /BEV3/CH_PERIOD_KTV /BEV3/CHDOPG CHAR 4   0   CH: Periodicity of Var.Savings Installment for Sec.Deposit *
203 KT_INTEREST_RATE /BEV3/CHZSATZ_KT /BEV3/CHPRZ43 DEC 7   3   CH: Interest Rate of Deposit  
204 KT_PERIOD_ZI /BEV3/CH_PERIOD_KTZI /BEV3/CHDOPG CHAR 4   0   CH: Periodicity of Payment of Interest on Deposit *
205 AMOUNT_BS /BEV3/CHBTRG_BS CURR16 CURR 16   2   CH: Guaranty  
206 AMOUNT_BS_ACT /BEV3/CHBTRG_BS_ACT CURR16 CURR 16   2   CH: Reported Guarantee Amount  
207 BS_CURRENCY /BEV3/CH_BS_CURRENCY WAERS CUKY 5   0   CH: Currency Indicator of Guaranty *
208 SL_GROUP1 /BEV3/CHSALG1 /BEV3/CHSALG NUMC 4   0   CH: Payment in Kind Group 1  
209 SL_TYPE1 /BEV3/CHSALA1 /BEV3/CHSALA NUMC 4   0   CH: Payment in Kind Type 1  
210 AMOUNT_SL1 /BEV3/CHBTRG_SL1 CURR16 CURR 16   2   CH: Value of Payment in Kind 1  
211 SL_CURRENCY_1 /BEV3/CH_SL1_CURRENCY WAERS CUKY 5   0   CH: Currency Indicator of Payment in Kind 1 *
212 SL_GROUP2 /BEV3/CHSALG2 /BEV3/CHSALG NUMC 4   0   CH: Payment in Kind Group 2  
213 SL_TYPE2 /BEV3/CHSALA2 /BEV3/CHSALA NUMC 4   0   CH: Payment in Kind Type 2  
214 AMOUNT_SL2 /BEV3/CHBTRG_SL2 CURR16 CURR 16   2   CH: Value of Payment in Kind 2  
215 SL_CURRENCY_2 /BEV3/CH_SL2_CURRENCY WAERS CUKY 5   0   CH: Currency Indicator of Payment in Kind 2 *
216 SL_GROUP3 /BEV3/CHSALG3 /BEV3/CHSALG NUMC 4   0   CH: Payment in Kind Group 3  
217 SL_TYPE3 /BEV3/CHSALA3 /BEV3/CHSALA NUMC 4   0   CH: Payment in Kind Type 3  
218 AMOUNT_SL3 /BEV3/CHBTRG_SL3 CURR16 CURR 16   2   CH: Value of Payment in Kind 3  
219 SL_CURRENCY_3 /BEV3/CH_SL3_CURRENCY WAERS CUKY 5   0   CH: Currency Indicator of Payment in Kind 3 *
220 SL_GROUP4 /BEV3/CHSALG4 /BEV3/CHSALG NUMC 4   0   CH: Payment in Kind Group 4  
221 SL_TYPE4 /BEV3/CHSALA4 /BEV3/CHSALA NUMC 4   0   CH: Payment in Kind Type 4  
222 AMOUNT_SL4 /BEV3/CHBTRG_SL4 CURR16 CURR 16   2   CH: Value of Payment in Kind 4  
223 SL_CURRENCY_4 /BEV3/CH_SL4_CURRENCY WAERS CUKY 5   0   CH: Currency Indicator of Payment in Kind 4 *
224 SL_GROUP5 /BEV3/CHSALG5 /BEV3/CHSALG NUMC 4   0   CH: Payment in Kind Group 5  
225 SL_TYPE5 /BEV3/CHSALA5 /BEV3/CHSALA NUMC 4   0   CH: Payment in Kind Type 5  
226 AMOUNT_SL5 /BEV3/CHBTRG_SL5 CURR16 CURR 16   2   CH: Value of Payment in Kind 5  
227 SL_CURRENCY_5 /BEV3/CH_SL5_CURRENCY WAERS CUKY 5   0   CH: Currency Indicator of Payment in Kind 5 *
228 GEBIET /BEV3/CH_GEBIET CHAR10 CHAR 10   0   CH: Assignment of Territory  
229 GEBIET_NAME /BEV3/CH_GEBIET_NAME CHAR20 CHAR 20   0   CH: Territory Description  
230 PSTLZ PSTLZ PSTLZ CHAR 10   0   Postal Code  
231 REGIO REGIO REGIO CHAR 3   0   Region (State, Province, County) *
232 KUKLA KUKLA KUKLA CHAR 2   0   Customer classification *
233 BUSAB BUSAB BUSAB CHAR 2   0   Accounting clerk *
234 BUSAB_NAME SNAME_001S TEXT30 CHAR 30   0   Name of Accounting Clerk  
235 ADM1 /BEV3/CH_ADM1 CHAR10 CHAR 10   0   CH: Field Sales Representative 1  
236 ADM1_NAME /BEV3/CH_ADM1_NAME TEXT30 CHAR 30   0   CH: Name of Field Sales Representative 1  
237 ADM2 /BEV3/CH_ADM2 CHAR10 CHAR 10   0   CH: Field Sales Representative 2  
238 ADM2_NAME /BEV3/CH_ADM2_NAME TEXT30 CHAR 30   0   CH: Name of Field Sales Representative 2  
239 ADM3 /BEV3/CH_ADM3 CHAR10 CHAR 10   0   CH: Field Sales Representative 3  
240 ADM3_NAME /BEV3/CH_ADM3_NAME TEXT30 CHAR 30   0   CH: Name of Field Sales Representative 3  
241 ADM4 /BEV3/CH_ADM4 CHAR10 CHAR 10   0   CH: Field Sales Representative 4  
242 ADM4_NAME /BEV3/CH_ADM4_NAME TEXT30 CHAR 30   0   CH: Name of Field Sales Representative 4  
243 ADM5 /BEV3/CH_ADM5 CHAR10 CHAR 10   0   CH: Field Sales Representative 5  
244 ADM5_NAME /BEV3/CH_ADM5_NAME TEXT30 CHAR 30   0   CH: Name of Field Sales Representative 5  
245 DT_BIS /BEV3/CHBUDAT_BIS   DATS 8   0   CH: Posting Period - To Date  
246 CH_SALDO /BEV3/CHBTRG_SALDO WERT7 CURR 13   2   CH: Contract Balance (Account View)  
247 AUS_SORTIMENT /BEV3/CHDTSORT /BEV3/CHDOSORT CHAR 18   0   CH Assortment  
248 GES_SORTIMENT /BEV3/CHDTSORT /BEV3/CHDOSORT CHAR 18   0   CH Assortment  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 /BEV3/CH_ALV_CONTRACTLIST BUKRS_DEBITOR T001 BUKRS 1 CN
2 /BEV3/CH_ALV_CONTRACTLIST BZV_ABS_CURR TCURC WAERS 1 CN
3 /BEV3/CH_ALV_CONTRACTLIST BZV_ABS_STAF_BON /BEV3/CHCTSTAF STAFFELID 1 CN
4 /BEV3/CH_ALV_CONTRACTLIST BZV_ABS_STAF_MAL /BEV3/CHCTSTAF STAFFELID 1 CN
5 /BEV3/CH_ALV_CONTRACTLIST BZV_ABS_UNIT T006 MSEHI 1 CN
6 /BEV3/CH_ALV_CONTRACTLIST BZV_UMS_CURR TCURC WAERS 1 CN
7 /BEV3/CH_ALV_CONTRACTLIST BZV_UMS_STAF_BON /BEV3/CHCTSTAF STAFFELID 1 CN
8 /BEV3/CH_ALV_CONTRACTLIST BZV_UMS_STAF_MAL /BEV3/CHCTSTAF STAFFELID 1 CN
9 /BEV3/CH_ALV_CONTRACTLIST CHORG /BEV3/CHTBVORGE YVORGE KEY 1 1
10 /BEV3/CH_ALV_CONTRACTLIST CLASS1 /BEV3/CHCTKLAS1 KLASS1 KEY 1 N
11 /BEV3/CH_ALV_CONTRACTLIST CLASS2 /BEV3/CHCTKLAS2 KLASS2 KEY 1 N
12 /BEV3/CH_ALV_CONTRACTLIST CLASS3 /BEV3/CHCTKLAS3 KLASS3 KEY 1 N
13 /BEV3/CH_ALV_CONTRACTLIST CLASS4 /BEV3/CHCTKLAS4 KLASS4 KEY 1 N
14 /BEV3/CH_ALV_CONTRACTLIST CLASS5 /BEV3/CHCTKLAS5 KLASS5 KEY 1 N
15 /BEV3/CH_ALV_CONTRACTLIST CTR_BUKRS T001 BUKRS KEY 1 N
16 /BEV3/CH_ALV_CONTRACTLIST CTR_CURRENCY TCURC WAERS 1 CN
17 /BEV3/CH_ALV_CONTRACTLIST LANGU_ORIGINAL T002 SPRAS KEY 1 N
18 /BEV3/CH_ALV_CONTRACTLIST SPART_RG TSPA SPART 1 CN
19 /BEV3/CH_ALV_CONTRACTLIST SPART_WE TSPA SPART 1 CN
20 /BEV3/CH_ALV_CONTRACTLIST VKORG_RG TVKO VKORG 1 CN
21 /BEV3/CH_ALV_CONTRACTLIST VKORG_WE TVKO VKORG 1 CN
22 /BEV3/CH_ALV_CONTRACTLIST VTWEG_RG TVTW VTWEG 1 CN
23 /BEV3/CH_ALV_CONTRACTLIST VTWEG_WE TVTW VTWEG 1 CN
24 /BEV3/CH_ALV_CONTRACTLIST VWDART /BEV3/CHTVWDART VWDART KEY 1 N
History
Last changed by/on SAP  20130529 
SAP Release Created in 461