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

Home | ERP 6.0  | /BEV3/CHTMPMDHST
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
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

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

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction
Sales and Distribution :: Sales :: Part Load Lift Orders :: Remaining Beverage - Obsolete Objects
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0/BEV3/CHTMPMDHST1171Temp. history of cond. modifications from temp. settle. itemRemaining Beverage - Obsolete Objects
SQL:  selectupdate insert create

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

SELECT MANDT, BLG_NR, POS_NR, ABR_NR, YVWDNR, MOD_LFDNR, YVORGE, VBKL_SUPER, RI_SUPER, VBIN_SUPER, PART_SUPER, PTIN_SUPER, VBKL, RI, VBIN, VBNR, VBDTA, ABR_KZ, VBEWAR, STR_VRG, VWD_LAND, VWD_STRKZ, ERG_NR, STAT_KZ, STAT_BZNR, VERD_KZ, SP_TAG, VB_STRKZ, VERTSI_BCH, ABR_KZ_BCH, PARTTM_BCH, RI_BCH, VKORG_BCH, VTWEG_BCH, SPART_BCH, BUKRS_BCH, WERK_BCH, VWDNR_BCH, RG_BCH, WE_BCH, AG_BCH, RE_BCH, DE_BCH, VRL_BCH, SPD_BCH, RG_STAT, WE_STAT, AG_STAT, RE_STAT, VB_PERSNO, BTRG_BCH, WAERK_BCH, LAST_BDG, SPRAS, ZUORDNR, BSCHL, PBANKTYP, ZAHLWEG, ZAHLSP, MAHNSP, MSCHL, ZAHLBED, MAHNBER, BUCHDT_AB, BUCHDT_BIS, BRCHDT_AB, BRCHDT_BIS, VKORG_LSTG, VTWEG_LSTG, SPART_LSTG, BUKRS_LSTG, WERK_LSTG, VWDNR_LSTG, BTRG_LSTG, WAERK_LSTG, UKURS, KURSTYP, PRZSTZ_ZNS, PRZSTZ_MAX, PRZSTZ_MIN, PRZSTZ_ABW, BTRG_ZNS, WAERK_ZNS, I_ZNSCHL, E_ZNSCHL, SZBMETH, STGBASIS, ABASTAGE, ATAGE, MAT_NR, SORTIMENT, MENGE, MEINH, MENGE_LSTG, MEINH_LSTG, BTRG_UMS, WAERK_UMS, SACHKTO, KOST_ST, I_AUFTRG, PRFTCNTR, MWSKZ, BTRG_STR, BTRG_STRBAS, WAERK_STR, EVENT_NR, BUZEI, TXT_BCH, BK_LFDNR, UMSSTAFFEL, ABSSTAFFEL, GLTG_AB, MEINH_VG, WAERK_VG, ABSBASIS_VG, BTRG_VG, PRT_ID FROM /BEV3/CHTMPMDHST
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')No*MANDT Allow NULL? 
2BLG_NRCH Reference Document Numbernvarchar100CHAR(N' ')No/BEV3/CHXBLNR Allow NULL? 
3POS_NRCH Item Numbernvarchar60NUMC(N'000000')No/BEV3/CHVPOSNR Allow NULL? 
4ABR_NRSettlement Numbernvarchar100NUMC(N'0000000000')No/BEV3/CHABRNR Allow NULL? 
5YVWDNRCHD Contract Numbernvarchar130NUMC(N'0000000000000')No/BEV3/CHDTWDNR Allow NULL? 
6MOD_LFDNRSequence Number of Modificationnvarchar40NUMC(N'0000')No/BEV3/CHMODLFDNR Allow NULL? 
7YVORGECH Organizational Unitnvarchar40NUMC(N'0000')Yes*/BEV3/CHOE Allow NULL? 
8VBKL_SUPERAgreement Class - Callernvarchar40CHAR(N' ')Yes*/BEV3/CHBKL_SPR Allow NULL? 
9RI_SUPERRule Identifier - Callernvarchar60NUMC(N'000000')Yes*/BEV3/CHRI_SPR Allow NULL? 
10VBIN_SUPERAgreement Entity - Calling Programnvarchar40NUMC(N'0000')Yes/BEV3/CHBIN_SPR Allow NULL? 
11PART_SUPERPart of the Agreement Date - Callernvarchar80CHAR(N' ')Yes/BEV3/CHBTMPART_SPR Allow NULL? 
12PTIN_SUPERIdentification of the individual date parts - Callernvarchar40NUMC(N'0000')Yes/BEV3/CHTMINSTANZ_SPR Allow NULL? 
13VBKLAgreement Class - Contract Callednvarchar40CHAR(N' ')Yes*/BEV3/CHBKL_SLF Allow NULL? 
14RIRule Identifier - Contract Callednvarchar60NUMC(N'000000')Yes*/BEV3/CHRI_SLF Allow NULL? 
15VBINAgreement Entity - Contract Callednvarchar40NUMC(N'0000')Yes/BEV3/CHBIN_SLF Allow NULL? 
16VBNRAgreement Number in Seq. Time Order - Contract Callednvarchar90NUMC(N'000000000')Yes/BEV3/CHBNR_SLF Allow NULL? 
17VBDTADate (Valid from) - Contract Callednvarchar80DATS(N'00000000')Yes/BEV3/CHBDTA_SLF Allow NULL? 
18ABR_KZSettlement Method Identifiernvarchar40NUMC(N'0000')Yes/BEV3/CHABRFID Allow NULL? 
19VBEWARContract Movement Typenvarchar40CHAR(N' ')Yes*/BEV3/CHBEWAR Allow NULL? 
20STR_VRGTax transactionchar10CHAR(N' ')Yes/BEV3/CHSTRVRG Allow NULL? 
21VWD_LANDCountry Key of CHDnvarchar30CHAR(N' ')Yes*/BEV3/CHWD_LAND Allow NULL? 
22VWD_STRKZTax Classification of Contract Handling Documentchar10CHAR(N' ')Yes*/BEV3/CHWD_STRKZ Allow NULL? 
23ERG_NRCH Reference Document Number of Date Supplementnvarchar100CHAR(N' ')Yes/BEV3/CHXBLNR_ERGZ Allow NULL? 
24STAT_KZStatistics Indicatorchar10CHAR(N' ')Yes/BEV3/CHSTATKZ Allow NULL? 
25STAT_BZNRCH Item Numbernvarchar60NUMC(N'000000')Yes/BEV3/CHVPOSNR Allow NULL? 
26VERD_KZCompression Indicatorchar10CHAR(N' ')Yes/BEV3/CHRDKZ Allow NULL? 
27SP_TAGCompression Daynvarchar80DATS(N'00000000')Yes/BEV3/CHERDICHTET_ZUM Allow NULL? 
28VB_STRKZTax Classification of Agreementchar10CHAR(N' ')Yes*/BEV3/CHB_STRKZ Allow NULL? 
29VERTSI_BCHContract View - Postchar10CHAR(N' ')Yes/BEV3/CHERTSI_BCH Allow NULL? 
30ABR_KZ_BCHSettlement Method Identifier - Postnvarchar40NUMC(N'0000')Yes/BEV3/CHABRFID_BCH Allow NULL? 
31PARTTM_BCHPart of the Agreement Date - Postnvarchar80CHAR(N' ')Yes/BEV3/CHBTMPART_BCH Allow NULL? 
32RI_BCHRule Identifier - Postnvarchar60NUMC(N'000000')Yes*/BEV3/CHRI_BCH Allow NULL? 
33VKORG_BCHSales Organization - Postnvarchar40CHAR(N' ')Yes*/BEV3/CHKORG_BCH Allow NULL? 
34VTWEG_BCHDistribution Channel - Postnvarchar20CHAR(N' ')Yes*/BEV3/CHTWEG_BCH Allow NULL? 
35SPART_BCHDivision - Postnvarchar20CHAR(N' ')Yes*/BEV3/CHSPART_BCH Allow NULL? 
36BUKRS_BCHCompany Code - Postnvarchar40CHAR(N' ')Yes*/BEV3/CHBUKRS_BCH Allow NULL? 
37WERK_BCHPlant - Postnvarchar40CHAR(N' ')Yes*/BEV3/CHWERK_BCH Allow NULL? 
38VWDNR_BCHCHD Contract Number - Postnvarchar130NUMC(N'0000000000000')Yes/BEV3/CHWDNR_BCH Allow NULL? 
39RG_BCHCustomer Number of Payer - Postnvarchar100CHAR(N' ')Yes*/BEV3/CHRG_BCH Allow NULL? 
40WE_BCHCustomer Number of Ship-to Party - Postnvarchar100CHAR(N' ')Yes*/BEV3/CHWE_BCH Allow NULL? 
41AG_BCHCustomer Number of Sold-to Party - Postnvarchar100CHAR(N' ')Yes*/BEV3/CHAG_BCH Allow NULL? 
42RE_BCHCustomer Number of Bill-to Party - Postnvarchar100CHAR(N' ')Yes*/BEV3/CHRE_BCH Allow NULL? 
43DE_BCHCustomer Number - Postnvarchar100CHAR(N' ')Yes*/BEV3/CHDE_BCH Allow NULL? 
44VRL_BCHDistributor Number - Postnvarchar100CHAR(N' ')Yes*/BEV3/CHRL_BCH Allow NULL? 
45SPD_BCHForwarding Agent - Postnvarchar100CHAR(N' ')Yes*/BEV3/CHSPD_BCH Allow NULL? 
46RG_STATCustomer Number of Payer - Statisticsnvarchar100CHAR(N' ')Yes*/BEV3/CHRG_STAT Allow NULL? 
47WE_STATCustomer Number of Ship-to Party - Statisticsnvarchar100CHAR(N' ')Yes*/BEV3/CHWE_STAT Allow NULL? 
48AG_STATCustomer Number of Sold-to Party - Statisticsnvarchar100CHAR(N' ')Yes*/BEV3/CHAG_STAT Allow NULL? 
49RE_STATCustomer Number of Bill-to Party - Statisticsnvarchar100CHAR(N' ')Yes*/BEV3/CHRE_STAT Allow NULL? 
50VB_PERSNOPersonnel Number Sales Representativenvarchar80NUMC(N'00000000')Yes*/BEV3/CHBPERSNO Allow NULL? 
51BTRG_BCHAmount - Postdecimal162CURR((0))Yes/BEV3/CHBTRG_BCH
52WAERK_BCHCurrency Indicator - Postnvarchar50CUKY(N' ')Yes*/BEV3/CHWAERK_BCH Allow NULL? 
53LAST_BDGCondition that Modified Posting Datanvarchar40NUMC(N'0000')Yes*/BEV3/CHLASTBDG Allow NULL? 
54SPRASLanguage Key for Documentschar10LANG(N' ')YesT002/BEV3/CHSPRAS_BLG Allow NULL? 
55ZUORDNRAssignment Numbernvarchar180CHAR(N' ')YesDZUONR Allow NULL? 
56BSCHLPosting Keynvarchar20CHAR(N' ')Yes*BSCHL Allow NULL? 
57PBANKTYPPartner Bank Typenvarchar40CHAR(N' ')YesBVTYP Allow NULL? 
58ZAHLWEGPayment Methodchar10CHAR(N' ')Yes*DZLSCH Allow NULL? 
59ZAHLSPBlock Key for Paymentchar10CHAR(N' ')Yes*DZAHLS Allow NULL? 
60MAHNSPDunning blockchar10CHAR(N' ')Yes*MANSP Allow NULL? 
61MSCHLDunning keychar10CHAR(N' ')Yes*MSCHL Allow NULL? 
62ZAHLBEDTerms of Payment Keynvarchar40CHAR(N' ')YesDZTERM Allow NULL? 
63MAHNBERDunning Areanvarchar20CHAR(N' ')Yes*MABER Allow NULL? 
64BUCHDT_ABFrom Date of Settlement Periodnvarchar80DATS(N'00000000')Yes/BEV3/CHBUCHDAT_AB Allow NULL? 
65BUCHDT_BISTo Date of Settlement Periodnvarchar80DATS(N'00000000')Yes/BEV3/CHBUCHDAT_BIS Allow NULL? 
66BRCHDT_ABFrom Date of Calculation Intervalnvarchar80DATS(N'00000000')Yes/BEV3/CHBRCHDAT_AB Allow NULL? 
67BRCHDT_BISTo Date of Calculation Intervalnvarchar80DATS(N'00000000')Yes/BEV3/CHBRCHDAT_BIS Allow NULL? 
68VKORG_LSTGSales Organization - Performancenvarchar40CHAR(N' ')Yes*/BEV3/CHKORG_LSTG Allow NULL? 
69VTWEG_LSTGDistribution Channel - Performancenvarchar20CHAR(N' ')Yes*/BEV3/CHTWEG_LSTG Allow NULL? 
70SPART_LSTGDivision - Performancenvarchar20CHAR(N' ')Yes*/BEV3/CHSPART_LSTG Allow NULL? 
71BUKRS_LSTGCompany Code - Paymentnvarchar40CHAR(N' ')Yes*/BEV3/CHBUKRS_LSTG Allow NULL? 
72WERK_LSTGPlant - Performancenvarchar40CHAR(N' ')Yes*/BEV3/CHWERK_LSTG Allow NULL? 
73VWDNR_LSTGCHD Contract Number - Performancenvarchar130NUMC(N'0000000000000')Yes/BEV3/CHWDNR_LSTG Allow NULL? 
74BTRG_LSTGAmount - Paymentdecimal162CURR((0))Yes/BEV3/CHBTRG_LSTG
75WAERK_LSTGCurrency Indicator - Performancenvarchar50CUKY(N' ')Yes*/BEV3/CHWAERK_LSTG Allow NULL? 
76UKURSExchange Rate Performance -> Postdecimal95DEC((0))Yes/BEV3/CHUKURS
77KURSTYPExchange Rate Type of Conversion Performance -> Postnvarchar40CHAR(N' ')Yes*/BEV3/CHKURST_CURR Allow NULL? 
78PRZSTZ_ZNSPercentagedecimal73DEC((0))Yes/BEV3/CHZNSTZ
79PRZSTZ_MAXPercentage Maximumdecimal73DEC((0))Yes/BEV3/CHZNSTZ_MAX
80PRZSTZ_MINPercentage Minimumdecimal73DEC((0))Yes/BEV3/CHZNSTZ_MIN
81PRZSTZ_ABWPercentage Variancedecimal73DEC((0))Yes/BEV3/CHZNSTZ_ABW
82BTRG_ZNSAmount - Interest Basisdecimal162CURR((0))Yes/BEV3/CHBTRG_ZNS
83WAERK_ZNSCurrency Indicator - Interestnvarchar50CUKY(N' ')Yes*/BEV3/CHWAERK_ZNS Allow NULL? 
84I_ZNSCHLCH - Interest Key (Internal)nvarchar60CHAR(N' ')Yes/BEV3/CHZNSCHL_I Allow NULL? 
85E_ZNSCHLCH - Interest Key (External); Reference Interest Ratenvarchar100CHAR(N' ')Yes*/BEV3/CHZNSCHL_E Allow NULL? 
86SZBMETHInterest Calculation Methodchar10CHAR(N' ')YesSZBMETH Allow NULL? 
87STGBASISBase Days Methodchar10CHAR(N' ')YesVVSTGBASIS Allow NULL? 
88ABASTAGENumber of base days in a calculation periodnvarchar60NUMC(N'000000')YesABASTAGE Allow NULL? 
89ATAGENumber of Daysint100INT4((0))YesTFMATAGE Allow NULL? 
90MAT_NRMaterial Numbernvarchar180CHAR(N' ')Yes*MATNR Allow NULL? 
91SORTIMENTAssortment modulenvarchar180CHAR(N' ')Yes*W_SORTK Allow NULL? 
92MENGEMinimum Purchasedecimal155QUAN((0))Yes/BEV3/CHMNGE
93MEINHUnit of Measure of Minimum Purchasenvarchar30UNIT(N' ')Yes*/BEV3/CHMEINH_ABN Allow NULL? 
94MENGE_LSTGQuantity of Purchase Performancedecimal155QUAN((0))Yes/BEV3/CHMNGE_LSTG
95MEINH_LSTGUnit of Measure for Performance Quantitynvarchar30UNIT(N' ')Yes*/BEV3/CHMEINH_LSTG Allow NULL? 
96BTRG_UMSAmount - Salesdecimal162CURR((0))Yes/BEV3/CHBTRG_UMS
97WAERK_UMSCurrency Indicator - Salesnvarchar50CUKY(N' ')Yes*/BEV3/CHWAERK_UMS Allow NULL? 
98SACHKTOG/L Account Numbernvarchar100CHAR(N' ')Yes*SAKNR Allow NULL? 
99KOST_STCost Centernvarchar100CHAR(N' ')Yes*KOSTL Allow NULL? 
100I_AUFTRGOrder Numbernvarchar120CHAR(N' ')Yes*AUFNR Allow NULL? 
101PRFTCNTRProfit Centernvarchar100CHAR(N' ')Yes*PRCTR Allow NULL? 
102MWSKZTax on sales/purchases codenvarchar20CHAR(N' ')Yes*MWSKZ Allow NULL? 
103BTRG_STRTax Amount in Local Currencydecimal132CURR((0))YesMWSTS
104BTRG_STRBASTax Base Amount in Local Currencydecimal132CURR((0))YesHWBAS
105WAERK_STRCurrency Indicator - Taxnvarchar50CUKY(N' ')Yes*/BEV3/CHWAERK_STR Allow NULL? 
106EVENT_NRCH BTE Sequence Number of Event Receiptnvarchar160NUMC(N'0000000000000000')Yes/BEV3/CHEVENR Allow NULL? 
107BUZEINumber of Line Item Within Accounting Documentnvarchar30NUMC(N'000')YesBUZEI Allow NULL? 
108TXT_BCHIndividual Posting Textnvarchar500CHAR(N' ')Yes/BEV3/CHTXTBCH Allow NULL? 
109BK_LFDNRSequence Numbernvarchar160NUMC(N'0000000000000000')Yes/BEV3/CHLFDNR16 Allow NULL? 
110UMSSTAFFELScale IDnvarchar60CHAR(N' ')Yes*/BEV3/CHSTAF_RA Allow NULL? 
111ABSSTAFFELScale IDnvarchar60CHAR(N' ')Yes*/BEV3/CHSTAF_RA Allow NULL? 
112GLTG_ABCH Date Valid Fromnvarchar80DATS(N'00000000')Yes/BEV3/CHDATABV Allow NULL? 
113MEINH_VGUnit of Measurenvarchar30UNIT(N' ')Yes*/BEV3/CHMEINH Allow NULL? 
114WAERK_VGCurrency indicatornvarchar50CUKY(N' ')Yes*/BEV3/CHWAERK Allow NULL? 
115ABSBASIS_VGSales Basisdecimal155QUAN((0))Yes/BEV3/CHABSBAS
116BTRG_VGAmountdecimal162CURR((0))Yes/BEV3/CHBTRG
117PRT_IDAssignment to a Document Printoutnvarchar40NUMC(N'0000')Yes/BEV3/CHPRTID Allow NULL? 
NamePrimaryUniqueTypeColumns
/BEV3/CHTMPMDHST~0YesYesCLUSTEREDMOD_LFDNR, YVWDNR, ABR_NR, POS_NR, BLG_NR, MANDT

All references to SAP and SAP logo are trademarks of SAP AG in Germany, EU, USA and other territories.
No warranty is provided to data provided by this site. This website is not affiliated with, maintained, authorized, endorsed or sponsored by the SAP AG Company or any of its affiliates.
About :: Terms :: Privacy