SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

Schema:
 Module:  Table: 
Column: 
Searchbeta 

icon of database logic symbol SAP  TABLESv1Made in Britain

JDETables.com - the webs number one JD Edwards Table Definition reference

ERP 6.0: Top 10 requests

TableColumnsDescription
1TJKWE15IS-M/SD: WBZ, Order Data for Inbound Processing
2RSADMINC96Customizing Table General BW
3BBP_PD_XML8Table for Persistent Class CL_XML_PPF_BBP
4/OTX/RM_TELIB24Enterprise Library Server Settings
5UMV_TR1259Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6BSEG345Accounting Document Segment
7/ISDFPS/CHVW_E34External Batch Where-Used List
8FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
9/1RA/0SD010MI170Items for Class SD01 - Raw Data
10FMARCPAR4Parallelization of FMARC_BATCH

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5OJDT100Journal Entry
6OPCH386A/P Invoice
7INV1265A/R Invoice - Rows
8JDT1124Journal Entry - Rows
9OPOR386Purchase Order
10OVTG52Tax Definition

B1 8.8: Top 10 requests

TableColumnsDescription
1ORCT154Incoming Payment
2OITM249Items
3OINM101Whse Journal
4OINV268A/R Invoice
5OIVL77Whse Journal
6OVPM154Outgoing Payments
7OPCH268A/P Invoice
8JDT1110Journal Entry - Rows
9OOCR9Loading Factors
10OSRN20Serial Numbers Master Data
Sales and Distribution :: Sales :: Part Load Lift Orders :: Remaining Beverage - Obsolete Objects
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0/BEV3/CHCDPCTR21371CDP: Contract Data 2 - Specific Contract DataRemaining Beverage - Obsolete Objects
SQL:  selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns

SELECT MANDT, YVWDNR, DATE_TO, DATE_FROM, AMOUNT_BW, BW_CURRENCY, AMOUNT_AZ, AZ_CURRENCY, AZ_FIRST_DATE, AMOUNT_AN, AN_CURRENCY, PERIOD_AN, AMOUNT_TG, TG_CURRENCY, PERIOD_TG, AMOUNT_ZI, ZI_CURRENCY, INTEREST_RATE, ZI_EXTERN, ZI_INTERN, INTEREST_MIN, INTEREST_MAX, INTEREST_DIFF, PERIOD_ZI, AMOUNT_VG, VG_CURRENCY, PERIOD_VG, ABS_VG1, ABS_CURRENCY_VG1, ABS_UNIT_VG1, ABS_PERIOD_VG1, ABS_VG2, ABS_CURRENCY_VG2, ABS_UNIT_VG2, ABS_PERIOD_VG2, ABS_VG3, ABS_CURRENCY_VG3, ABS_UNIT_VG3, ABS_PERIOD_VG3, ABS_VG4, ABS_CURRENCY_VG4, ABS_UNIT_VG4, ABS_PERIOD_VG4, ABS_VG5, ABS_CURRENCY_VG5, ABS_UNIT_VG5, ABS_PERIOD_VG5, ABS_VG6, ABS_CURRENCY_VG6, ABS_UNIT_VG6, ABS_PERIOD_VG6, ABS_VG7, ABS_CURRENCY_VG7, ABS_UNIT_VG7, ABS_PERIOD_VG7, ABS_RS1, ABS_CURRENCY_RS1, ABS_UNIT_RS1, ABS_PERIOD_RS1, UMS_VG1, UMS_PERIOD_VG1, UMS_VG2, UMS_PERIOD_VG2, UMS_VG3, UMS_PERIOD_VG3, UMS_VG4, UMS_PERIOD_VG4, UMS_VG5, UMS_PERIOD_VG5, AMOUNT_ZS, ZS_CURRENCY, PERIOD_ZS, PERIOD_MP_NK, MP_CURRENCY, AMOUNT_MP_OBJ, AMOUNT_MP_WHG, AMOUNT_MP_GAR, AMOUNT_MP_4, AMOUNT_MP_VK, AMOUNT_MP_NK1, AMOUNT_MP_NK2, AMOUNT_MP_NK3, AMOUNT_MP_NK4, AMOUNT_MP_NK5, AMOUNT_MP_NK6, AMOUNT_MP_NK7, AMOUNT_MP_NK8, AMOUNT_MP_NK9, AMOUNT_MP_NK10, EXT_LIST_NK, PERIOD_NK, AMOUNT_IM, IM_CURRENCY, PERIOD_IM, AMOUNT_AM1, AM1_CURRENCY, PERIOD_AM1, AMOUNT_AM2, AM2_CURRENCY, PERIOD_AM2, AMOUNT_AM3, AM3_CURRENCY, PERIOD_AM3, AMOUNT_KT, AMOUNT_ANSP, KT_CURRENCY, PERIOD_ANSP, KT_ANSP_V, KT_CURRENCY_V, KT_UNIT_V, KT_PERIOD_V, KT_INTEREST_RATE, KT_PERIOD_ZI, AMOUNT_BS, AMOUNT_BS_ACT, BS_CURRENCY, SL_GROUP1, SL_TYPE1, AMOUNT_SL1, SL_CURRENCY_1, SL_GROUP2, SL_TYPE2, AMOUNT_SL2, SL_CURRENCY_2, SL_GROUP3, SL_TYPE3, AMOUNT_SL3, SL_CURRENCY_3, SL_GROUP4, SL_TYPE4, AMOUNT_SL4, SL_CURRENCY_4, SL_GROUP5, SL_TYPE5, AMOUNT_SL5, SL_CURRENCY_5, REC_TIMESTAMP FROM /BEV3/CHCDPCTR2
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')No*MANDT Allow NULL? 
2YVWDNRCHD Contract Numbernvarchar130NUMC(N'0000000000000')No/BEV3/CHDTWDNR Allow NULL? 
3DATE_TOValid To Datenvarchar80DATS(N'00000000')NoDATBI Allow NULL? 
4DATE_FROMValid-From Datenvarchar80DATS(N'00000000')NoDATAB Allow NULL? 
5AMOUNT_BWCH: Approved Amountdecimal162CURR((0))Yes/BEV3/CHBTRG_BW
6BW_CURRENCYCH: Currency Indicator of Approved Amountnvarchar50CUKY(N' ')YesTCURC/BEV3/CH_BW_CURRENCY Allow NULL? 
7AMOUNT_AZCH: Paymentdecimal162CURR((0))Yes/BEV3/CHBTRG_AZ
8AZ_CURRENCYCH: Currency Indicator of Paymentnvarchar50CUKY(N' ')YesTCURC/BEV3/CH_AZ_CURRENCY Allow NULL? 
9AZ_FIRST_DATECH: Date of First Paymentnvarchar80DATS(N'00000000')Yes/BEV3/CH_DATE_FIRST_AZ Allow NULL? 
10AMOUNT_ANCH: Annuitydecimal162CURR((0))Yes/BEV3/CHBTRG_AN
11AN_CURRENCYCH: Currency Indicator of Annuitynvarchar50CUKY(N' ')YesTCURC/BEV3/CH_AN_CURRENCY Allow NULL? 
12PERIOD_ANCH: Periodicity of Annuitynvarchar40CHAR(N' ')Yes/BEV3/CHCPG/BEV3/CH_PERIOD_AN Allow NULL? 
13AMOUNT_TGCH: Redemption Amountdecimal162CURR((0))Yes/BEV3/CHBTRG_TG
14TG_CURRENCYCH: Currency Indicator for Repaymentnvarchar50CUKY(N' ')YesTCURC/BEV3/CH_TG_CURRENCY Allow NULL? 
15PERIOD_TGCH: Periodicity of Repaymentnvarchar40CHAR(N' ')Yes/BEV3/CHCPG/BEV3/CH_PERIOD_TG Allow NULL? 
16AMOUNT_ZICH: Interest Amountdecimal162CURR((0))Yes/BEV3/CHBTRG_ZI
17ZI_CURRENCYCH: Currency Indicator of Interest Amountnvarchar50CUKY(N' ')YesTCURC/BEV3/CH_ZI_CURRENCY Allow NULL? 
18INTEREST_RATEInterest ratedecimal73DEC((0))Yes/BEV3/CHZSATZ
19ZI_EXTERNCH: Interest Key for External Interest Ratenvarchar100CHAR(N' ')YesT056R/BEV3/CH_ZI_EXTERN Allow NULL? 
20ZI_INTERNCH Interest Keynvarchar60CHAR(N' ')Yes/BEV3/CHCZNSCHLT/BEV3/CHZNSCHL Allow NULL? 
21INTEREST_MINCH: Minimum Interest Ratedecimal73DEC((0))Yes/BEV3/CH_ZI_MIN
22INTEREST_MAXCH: Maximum Interest Ratedecimal73DEC((0))Yes/BEV3/CH_ZI_MAX
23INTEREST_DIFFCH: Interest Variancedecimal73DEC((0))Yes/BEV3/CH_ZI_DIFF
24PERIOD_ZICH: Periodicity of Interest Paymentnvarchar40CHAR(N' ')Yes/BEV3/CHCPG/BEV3/CH_PERIOD_ZI Allow NULL? 
25AMOUNT_VGCH: Fixed Refunddecimal162CURR((0))Yes/BEV3/CHBTRG_VG
26VG_CURRENCYCH: Currency Indicator of Remuneration Amountnvarchar50CUKY(N' ')YesTCURC/BEV3/CH_VG_CURRENCY Allow NULL? 
27PERIOD_VGCH: Periodicity of Fixed Remuneration (Remun.Amount)nvarchar40CHAR(N' ')Yes/BEV3/CHCPG/BEV3/CH_PERIOD_VG Allow NULL? 
28ABS_VG1CH: Refund Value 1decimal175CURR((0))Yes/BEV3/CHVG_WERT1
29ABS_CURRENCY_VG1CH: Currency Indicator of Remuneration 1nvarchar50CUKY(N' ')YesTCURC/BEV3/CH_VG1_CURRENCY Allow NULL? 
30ABS_UNIT_VG1CH: Unit of Measure of Remuneration 1nvarchar30UNIT(N' ')YesT006/BEV3/CH_VG1_MEINH Allow NULL? 
31ABS_PERIOD_VG1CH: Periodicity of Variable Remuneration 1nvarchar40CHAR(N' ')Yes/BEV3/CHCPG/BEV3/CH_PERIOD_VG1 Allow NULL? 
32ABS_VG2CH: Refund Value 2decimal175CURR((0))Yes/BEV3/CHVG_WERT2
33ABS_CURRENCY_VG2CH: Currency Indicator of Remuneration 2nvarchar50CUKY(N' ')YesTCURC/BEV3/CH_VG2_CURRENCY Allow NULL? 
34ABS_UNIT_VG2CH: Unit of Measure of Remuneration 2nvarchar30UNIT(N' ')YesT006/BEV3/CH_VG2_MEINH Allow NULL? 
35ABS_PERIOD_VG2CH: Periodicity of Variable Remuneration 2nvarchar40CHAR(N' ')Yes/BEV3/CHCPG/BEV3/CH_PERIOD_VG2 Allow NULL? 
36ABS_VG3CH: Refund Value 3decimal175CURR((0))Yes/BEV3/CHVG_WERT3
37ABS_CURRENCY_VG3CH: Currency Indicator of Remuneration 3nvarchar50CUKY(N' ')YesTCURC/BEV3/CH_VG3_CURRENCY Allow NULL? 
38ABS_UNIT_VG3CH: Unit of Measure of Remuneration 3nvarchar30UNIT(N' ')YesT006/BEV3/CH_VG3_MEINH Allow NULL? 
39ABS_PERIOD_VG3CH: Periodicity of Variable Remuneration 3nvarchar40CHAR(N' ')Yes/BEV3/CHCPG/BEV3/CH_PERIOD_VG3 Allow NULL? 
40ABS_VG4CH: Refund Value 4decimal175CURR((0))Yes/BEV3/CHVG_WERT4
41ABS_CURRENCY_VG4CH: Currency Indicator of Remuneration 4nvarchar50CUKY(N' ')YesTCURC/BEV3/CH_VG4_CURRENCY Allow NULL? 
42ABS_UNIT_VG4CH: Unit of Measure of Remuneration 4nvarchar30UNIT(N' ')YesT006/BEV3/CH_VG4_MEINH Allow NULL? 
43ABS_PERIOD_VG4CH: Periodicity of Variable Remuneration 4nvarchar40CHAR(N' ')Yes/BEV3/CHCPG/BEV3/CH_PERIOD_VG4 Allow NULL? 
44ABS_VG5CH: Refund Value 5decimal175CURR((0))Yes/BEV3/CHVG_WERT5
45ABS_CURRENCY_VG5CH: Currency Indicator of Remuneration 5nvarchar50CUKY(N' ')YesTCURC/BEV3/CH_VG5_CURRENCY Allow NULL? 
46ABS_UNIT_VG5CH: Unit of Measure of Remuneration 5nvarchar30UNIT(N' ')YesT006/BEV3/CH_VG5_MEINH Allow NULL? 
47ABS_PERIOD_VG5CH: Periodicity of Variable Remuneration 5nvarchar40CHAR(N' ')Yes/BEV3/CHCPG/BEV3/CH_PERIOD_VG5 Allow NULL? 
48ABS_VG6CH: Refund Value 6decimal175CURR((0))Yes/BEV3/CHVG_WERT6
49ABS_CURRENCY_VG6CH: Currency Indicator of Remuneration 6nvarchar50CUKY(N' ')YesTCURC/BEV3/CH_VG6_CURRENCY Allow NULL? 
50ABS_UNIT_VG6CH: Unit of Measure of Remuneration 6nvarchar30UNIT(N' ')YesT006/BEV3/CH_VG6_MEINH Allow NULL? 
51ABS_PERIOD_VG6CH: Periodicity of Variable Remuneration 6nvarchar40CHAR(N' ')Yes/BEV3/CHCPG/BEV3/CH_PERIOD_VG6 Allow NULL? 
52ABS_VG7CH: Refund Value 7decimal175CURR((0))Yes/BEV3/CHVG_WERT7
53ABS_CURRENCY_VG7CH: Currency Indicator of Remuneration 7nvarchar50CUKY(N' ')YesTCURC/BEV3/CH_VG7_CURRENCY Allow NULL? 
54ABS_UNIT_VG7CH: Unit of Measure of Remuneration 7nvarchar30UNIT(N' ')YesT006/BEV3/CH_VG7_MEINH Allow NULL? 
55ABS_PERIOD_VG7CH: Period of Variable Remuneration 7nvarchar40CHAR(N' ')Yes/BEV3/CHCPG/BEV3/CH_PERIOD_VG7 Allow NULL? 
56ABS_RS1CH: Reserves Value 1decimal175CURR((0))Yes/BEV3/CHRS_WERT1
57ABS_CURRENCY_RS1CH: Currency Indicator of Reserves 1nvarchar50CUKY(N' ')YesTCURC/BEV3/CH_RS1_CURRENCY Allow NULL? 
58ABS_UNIT_RS1CH: Unit of Measure of Reserves 1nvarchar30UNIT(N' ')YesT006/BEV3/CH_RS1_MEINH Allow NULL? 
59ABS_PERIOD_RS1CH: Periodicity of Variable Reserves 1nvarchar40CHAR(N' ')Yes/BEV3/CHCPG/BEV3/CH_PERIOD_RS1 Allow NULL? 
60UMS_VG1CH: % Valuation Sales Refund 1decimal73DEC((0))Yes/BEV3/CHVG_PRZ1
61UMS_PERIOD_VG1CH: Periodicity of Sales Remuneration 1nvarchar40CHAR(N' ')Yes/BEV3/CHCPG/BEV3/CH_PERIOD_UMS_VG1 Allow NULL? 
62UMS_VG2CH: % Valuation Sales Refund 2decimal73DEC((0))Yes/BEV3/CHVG_PRZ2
63UMS_PERIOD_VG2CH: Periodicity of Sales Remuneration 2nvarchar40CHAR(N' ')Yes/BEV3/CHCPG/BEV3/CH_PERIOD_UMS_VG2 Allow NULL? 
64UMS_VG3CH: % Valuation Sales Refund 3decimal73DEC((0))Yes/BEV3/CHVG_PRZ3
65UMS_PERIOD_VG3CH: Periodicity of Sales Remuneration 3nvarchar40CHAR(N' ')Yes/BEV3/CHCPG/BEV3/CH_PERIOD_UMS_VG3 Allow NULL? 
66UMS_VG4CH: % Valuation Sales Refund 4decimal73DEC((0))Yes/BEV3/CHVG_PRZ4
67UMS_PERIOD_VG4CH: Periodicity of Sales Remuneration 4nvarchar40CHAR(N' ')Yes/BEV3/CHCPG/BEV3/CH_PERIOD_UMS_VG4 Allow NULL? 
68UMS_VG5CH: % Valuation Sales Refund 5decimal73DEC((0))Yes/BEV3/CHVG_PRZ5
69UMS_PERIOD_VG5CH: Periodicity of Sales Remuneration 5nvarchar40CHAR(N' ')Yes/BEV3/CHCPG/BEV3/CH_PERIOD_UMS_VG5 Allow NULL? 
70AMOUNT_ZSCH: Allowance (Fixed)decimal162CURR((0))Yes/BEV3/CHBTRG_ZS
71ZS_CURRENCYCH: Currency Indicator of Allowancenvarchar50CUKY(N' ')YesTCURC/BEV3/CH_ZS_CURRENCY Allow NULL? 
72PERIOD_ZSCH: Periodicity of Allowancenvarchar40CHAR(N' ')Yes/BEV3/CHCPG/BEV3/CH_PERIOD_ZS Allow NULL? 
73PERIOD_MP_NKCH: Periodicity of Rent & Leasenvarchar40CHAR(N' ')Yes/BEV3/CHCPG/BEV3/CH_PERIOD_MP Allow NULL? 
74MP_CURRENCYCH: Currency Indicator of Rent & Leasenvarchar50CUKY(N' ')YesTCURC/BEV3/CH_MP_CURRENCY Allow NULL? 
75AMOUNT_MP_OBJCH: Object Lease (Rent)decimal162CURR((0))Yes/BEV3/CHBTRG_MP_OBJ
76AMOUNT_MP_WHGCH: Apartment Rentdecimal162CURR((0))Yes/BEV3/CHBTRG_MP_WHG
77AMOUNT_MP_GARCH: Garage Rentdecimal162CURR((0))Yes/BEV3/CHBTRG_MP_GAR
78AMOUNT_MP_4CH: Rentdecimal162CURR((0))Yes/BEV3/CHBTRG_MP_4
79AMOUNT_MP_VKCH: Management Costsdecimal162CURR((0))Yes/BEV3/CHBTRG_MP_VK
80AMOUNT_MP_NK1CH: Incidentals Cost Element 1decimal162CURR((0))Yes/BEV3/CHBTRG_MP_NK1
81AMOUNT_MP_NK2CH: Incidentals Cost Element 2decimal162CURR((0))Yes/BEV3/CHBTRG_MP_NK2
82AMOUNT_MP_NK3CH: Incidentals Cost Element 3decimal162CURR((0))Yes/BEV3/CHBTRG_MP_NK3
83AMOUNT_MP_NK4CH: Incidentals Cost Element 4decimal162CURR((0))Yes/BEV3/CHBTRG_MP_NK4
84AMOUNT_MP_NK5CH: Incidentals Cost Element 5decimal162CURR((0))Yes/BEV3/CHBTRG_MP_NK5
85AMOUNT_MP_NK6CH: Incidentals Cost Element 6decimal162CURR((0))Yes/BEV3/CHBTRG_MP_NK6
86AMOUNT_MP_NK7CH: Incidentals Cost Element 7decimal162CURR((0))Yes/BEV3/CHBTRG_MP_NK7
87AMOUNT_MP_NK8CH: Incidentals Cost Element 8decimal162CURR((0))Yes/BEV3/CHBTRG_MP_NK8
88AMOUNT_MP_NK9CH: Incidentals Cost Element 9decimal162CURR((0))Yes/BEV3/CHBTRG_MP_NK9
89AMOUNT_MP_NK10CH: Incidentals Cost Element 10decimal162CURR((0))Yes/BEV3/CHBTRG_MP_NK10
90EXT_LIST_NKCH: External Amount List for Incidentalsnvarchar130CHAR(N' ')Yes/BEV3/CHCL_LSTK/BEV3/CH_LIST_NK Allow NULL? 
91PERIOD_NKCH: Periodicity of Expense Settlement for Rent & Leasenvarchar40CHAR(N' ')Yes/BEV3/CHCPG/BEV3/CH_PERIOD_NK Allow NULL? 
92AMOUNT_IMCH: Fittings and Equipment Rentdecimal162CURR((0))Yes/BEV3/CHBTRG_IM
93IM_CURRENCYCH: Currency Indicator for Fittings and Equipment Rentnvarchar50CUKY(N' ')YesTCURC/BEV3/CH_IM_CURRENCY Allow NULL? 
94PERIOD_IMCH: Periodicity of Rent for Fittings and Equipmentnvarchar40CHAR(N' ')Yes/BEV3/CHCPG/BEV3/CH_PERIOD_IM Allow NULL? 
95AMOUNT_AM1CH: Vending Machine Rent 1decimal162CURR((0))Yes/BEV3/CHBTRG_AM1
96AM1_CURRENCYCH: Currency Indicator of Vending Machine Rent 1nvarchar50CUKY(N' ')YesTCURC/BEV3/CH_AM1_CURRENCY Allow NULL? 
97PERIOD_AM1CH: Periodicity of Vending Machine Rent 1nvarchar40CHAR(N' ')Yes/BEV3/CHCPG/BEV3/CH_PERIOD_AM1 Allow NULL? 
98AMOUNT_AM2CH: Vending Machine Rent 2decimal162CURR((0))Yes/BEV3/CHBTRG_AM2
99AM2_CURRENCYCH: Currency Indicator of Vending Machine Rent 2nvarchar50CUKY(N' ')YesTCURC/BEV3/CH_AM2_CURRENCY Allow NULL? 
100PERIOD_AM2CH: Periodicity of Vending Machine Rent 2nvarchar40CHAR(N' ')Yes/BEV3/CHCPG/BEV3/CH_PERIOD_AM2 Allow NULL? 
101AMOUNT_AM3CH: Vending Machine rent 3decimal162CURR((0))Yes/BEV3/CHBTRG_AM3
102AM3_CURRENCYCH: Currency Indicator of Vending Machine Rent 3nvarchar50CUKY(N' ')YesTCURC/BEV3/CH_AM3_CURRENCY Allow NULL? 
103PERIOD_AM3CH: Periodicity of Vending Machine Rent 3nvarchar40CHAR(N' ')Yes/BEV3/CHCPG/BEV3/CH_PERIOD_AM3 Allow NULL? 
104AMOUNT_KTCH: Security Deposit Amountdecimal162CURR((0))Yes/BEV3/CHBTRG_KT
105AMOUNT_ANSPCH: Fixed Saving Installment Depositdecimal162CURR((0))Yes/BEV3/CHBTRG_ANSP
106KT_CURRENCYCH: Currency Indicator of Security Depositnvarchar50CUKY(N' ')YesTCURC/BEV3/CH_KT_CURRENCY Allow NULL? 
107PERIOD_ANSPCH: Periodicity of Fixed Savings Installmentnvarchar40CHAR(N' ')Yes/BEV3/CHCPG/BEV3/CH_PERIOD_ANSP Allow NULL? 
108KT_ANSP_VCH: Variable Saving Installment Security Depositdecimal175CURR((0))Yes/BEV3/CHKT_WERT1
109KT_CURRENCY_VCH: Currency Indicator of Variable Savings Installmt/Depositnvarchar50CUKY(N' ')YesTCURC/BEV3/CH_KTV_CURRENCY Allow NULL? 
110KT_UNIT_VCH: Unit of Measure of Variable Savings Installmt/Depositnvarchar30UNIT(N' ')YesT006/BEV3/CH_KTV_MEINH Allow NULL? 
111KT_PERIOD_VCH: Periodicity of Var.Savings Installment for Sec.Depositnvarchar40CHAR(N' ')Yes/BEV3/CHCPG/BEV3/CH_PERIOD_KTV Allow NULL? 
112KT_INTEREST_RATECH: Interest Rate of Depositdecimal73DEC((0))Yes/BEV3/CHZSATZ_KT
113KT_PERIOD_ZICH: Periodicity of Payment of Interest on Depositnvarchar40CHAR(N' ')Yes/BEV3/CHCPG/BEV3/CH_PERIOD_KTZI Allow NULL? 
114AMOUNT_BSCH: Guarantydecimal162CURR((0))Yes/BEV3/CHBTRG_BS
115AMOUNT_BS_ACTCH: Reported Guarantee Amountdecimal162CURR((0))Yes/BEV3/CHBTRG_BS_ACT
116BS_CURRENCYCH: Currency Indicator of Guarantynvarchar50CUKY(N' ')YesTCURC/BEV3/CH_BS_CURRENCY Allow NULL? 
117SL_GROUP1CH: Payment in Kind Group 1nvarchar40NUMC(N'0000')Yes/BEV3/CHCSALG/BEV3/CHSALG1 Allow NULL? 
118SL_TYPE1CH: Payment in Kind Type 1nvarchar40NUMC(N'0000')Yes/BEV3/CHCSALA/BEV3/CHSALA1 Allow NULL? 
119AMOUNT_SL1CH: Value of Payment in Kind 1decimal162CURR((0))Yes/BEV3/CHBTRG_SL1
120SL_CURRENCY_1CH: Currency Indicator of Payment in Kind 1nvarchar50CUKY(N' ')Yes*/BEV3/CH_SL1_CURRENCY Allow NULL? 
121SL_GROUP2CH: Payment in Kind Group 2nvarchar40NUMC(N'0000')Yes/BEV3/CHCSALG/BEV3/CHSALG2 Allow NULL? 
122SL_TYPE2CH: Payment in Kind Type 2nvarchar40NUMC(N'0000')Yes/BEV3/CHCSALA/BEV3/CHSALA2 Allow NULL? 
123AMOUNT_SL2CH: Value of Payment in Kind 2decimal162CURR((0))Yes/BEV3/CHBTRG_SL2
124SL_CURRENCY_2CH: Currency Indicator of Payment in Kind 2nvarchar50CUKY(N' ')Yes*/BEV3/CH_SL2_CURRENCY Allow NULL? 
125SL_GROUP3CH: Payment in Kind Group 3nvarchar40NUMC(N'0000')Yes/BEV3/CHCSALG/BEV3/CHSALG3 Allow NULL? 
126SL_TYPE3CH: Payment in Kind Type 3nvarchar40NUMC(N'0000')Yes/BEV3/CHCSALA/BEV3/CHSALA3 Allow NULL? 
127AMOUNT_SL3CH: Value of Payment in Kind 3decimal162CURR((0))Yes/BEV3/CHBTRG_SL3
128SL_CURRENCY_3CH: Currency Indicator of Payment in Kind 3nvarchar50CUKY(N' ')Yes*/BEV3/CH_SL3_CURRENCY Allow NULL? 
129SL_GROUP4CH: Payment in Kind Group 4nvarchar40NUMC(N'0000')Yes/BEV3/CHCSALG/BEV3/CHSALG4 Allow NULL? 
130SL_TYPE4CH: Payment in Kind Type 4nvarchar40NUMC(N'0000')Yes/BEV3/CHCSALA/BEV3/CHSALA4 Allow NULL? 
131AMOUNT_SL4CH: Value of Payment in Kind 4decimal162CURR((0))Yes/BEV3/CHBTRG_SL4
132SL_CURRENCY_4CH: Currency Indicator of Payment in Kind 4nvarchar50CUKY(N' ')Yes*/BEV3/CH_SL4_CURRENCY Allow NULL? 
133SL_GROUP5CH: Payment in Kind Group 5nvarchar40NUMC(N'0000')Yes/BEV3/CHCSALG/BEV3/CHSALG5 Allow NULL? 
134SL_TYPE5CH: Payment in Kind Type 5nvarchar40NUMC(N'0000')Yes/BEV3/CHCSALA/BEV3/CHSALA5 Allow NULL? 
135AMOUNT_SL5CH: Value of Payment in Kind 5decimal162CURR((0))Yes/BEV3/CHBTRG_SL5
136SL_CURRENCY_5CH: Currency Indicator of Payment in Kind 5nvarchar50CUKY(N' ')Yes*/BEV3/CH_SL5_CURRENCY Allow NULL? 
137REC_TIMESTAMPCH: Time Stampnvarchar140CHAR(N' ')Yes/BEV3/CHTIMESTAMP Allow NULL? 
NamePrimaryUniqueTypeColumns
/BEV3/CHCDPCTR2~0YesYesCLUSTEREDDATE_TO, YVWDNR, MANDT