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/CHSIMSTZ_P
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
6/ISDFPS/CHVW_E34External Batch Where-Used List
7FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
8BSEG345Accounting Document Segment
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
6INV1265A/R Invoice - Rows
7OPCH386A/P Invoice
8JDT1124Journal Entry - Rows
9OPOR386Purchase Order
10OVTG52Tax Definition

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
9OINM101Whse Journal
10OSRN20Serial Numbers Master Data
Sales and Distribution :: Sales :: Part Load Lift Orders :: Remaining Beverage - Obsolete Objects
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0/BEV3/CHSIMSTZ_P1182CH Simulation ItemsRemaining 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, YVORGE, ABR_NR, YVWDNR, 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, ABR_TYP, ST_KZ FROM /BEV3/CHSIMSTZ_P
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? 
4YVORGECH Organizational Unitnvarchar40NUMC(N'0000')Yes*/BEV3/CHOE Allow NULL? 
5ABR_NRSettlement Numbernvarchar100NUMC(N'0000000000')Yes/BEV3/CHABRNR Allow NULL? 
6YVWDNRCHD Contract Numbernvarchar130NUMC(N'0000000000000')Yes/BEV3/CHDTWDNR Allow NULL? 
7VBKL_SUPERAgreement Class - Callernvarchar40CHAR(N' ')Yes*/BEV3/CHBKL_SPR Allow NULL? 
8RI_SUPERRule Identifier - Callernvarchar60NUMC(N'000000')Yes*/BEV3/CHRI_SPR Allow NULL? 
9VBIN_SUPERAgreement Entity - Calling Programnvarchar40NUMC(N'0000')Yes/BEV3/CHBIN_SPR Allow NULL? 
10PART_SUPERPart of the Agreement Date - Callernvarchar80CHAR(N' ')Yes/BEV3/CHBTMPART_SPR Allow NULL? 
11PTIN_SUPERIdentification of the individual date parts - Callernvarchar40NUMC(N'0000')Yes/BEV3/CHTMINSTANZ_SPR Allow NULL? 
12VBKLAgreement Class - Contract Callednvarchar40CHAR(N' ')Yes*/BEV3/CHBKL_SLF Allow NULL? 
13RIRule Identifier - Contract Callednvarchar60NUMC(N'000000')Yes*/BEV3/CHRI_SLF Allow NULL? 
14VBINAgreement Entity - Contract Callednvarchar40NUMC(N'0000')Yes/BEV3/CHBIN_SLF Allow NULL? 
15VBNRAgreement Number in Seq. Time Order - Contract Callednvarchar90NUMC(N'000000000')Yes/BEV3/CHBNR_SLF Allow NULL? 
16VBDTADate (Valid from) - Contract Callednvarchar80DATS(N'00000000')Yes/BEV3/CHBDTA_SLF Allow NULL? 
17ABR_KZSettlement Method Identifiernvarchar40NUMC(N'0000')Yes/BEV3/CHABRFID Allow NULL? 
18VBEWARContract Movement Typenvarchar40CHAR(N' ')Yes*/BEV3/CHBEWAR Allow NULL? 
19STR_VRGTax transactionchar10CHAR(N' ')Yes/BEV3/CHSTRVRG Allow NULL? 
20VWD_LANDCountry Key of CHDnvarchar30CHAR(N' ')Yes*/BEV3/CHWD_LAND Allow NULL? 
21VWD_STRKZTax Classification of Contract Handling Documentchar10CHAR(N' ')Yes*/BEV3/CHWD_STRKZ Allow NULL? 
22ERG_NRCH Reference Document Number of Date Supplementnvarchar100CHAR(N' ')Yes/BEV3/CHXBLNR_ERGZ Allow NULL? 
23STAT_KZStatistics Indicatorchar10CHAR(N' ')Yes/BEV3/CHSTATKZ Allow NULL? 
24STAT_BZNRCH Item Numbernvarchar60NUMC(N'000000')Yes/BEV3/CHVPOSNR Allow NULL? 
25VERD_KZCompression Indicatorchar10CHAR(N' ')Yes/BEV3/CHRDKZ Allow NULL? 
26SP_TAGCompression Daynvarchar80DATS(N'00000000')Yes/BEV3/CHERDICHTET_ZUM Allow NULL? 
27VB_STRKZTax Classification of Agreementchar10CHAR(N' ')Yes*/BEV3/CHB_STRKZ Allow NULL? 
28VERTSI_BCHContract View - Postchar10CHAR(N' ')Yes/BEV3/CHERTSI_BCH Allow NULL? 
29ABR_KZ_BCHSettlement Method Identifier - Postnvarchar40NUMC(N'0000')Yes/BEV3/CHABRFID_BCH Allow NULL? 
30PARTTM_BCHPart of the Agreement Date - Postnvarchar80CHAR(N' ')Yes/BEV3/CHBTMPART_BCH Allow NULL? 
31RI_BCHRule Identifier - Postnvarchar60NUMC(N'000000')Yes*/BEV3/CHRI_BCH Allow NULL? 
32VKORG_BCHSales Organization - Postnvarchar40CHAR(N' ')Yes*/BEV3/CHKORG_BCH Allow NULL? 
33VTWEG_BCHDistribution Channel - Postnvarchar20CHAR(N' ')Yes*/BEV3/CHTWEG_BCH Allow NULL? 
34SPART_BCHDivision - Postnvarchar20CHAR(N' ')Yes*/BEV3/CHSPART_BCH Allow NULL? 
35BUKRS_BCHCompany Code - Postnvarchar40CHAR(N' ')Yes*/BEV3/CHBUKRS_BCH Allow NULL? 
36WERK_BCHPlant - Postnvarchar40CHAR(N' ')Yes*/BEV3/CHWERK_BCH Allow NULL? 
37VWDNR_BCHCHD Contract Number - Postnvarchar130NUMC(N'0000000000000')Yes/BEV3/CHWDNR_BCH Allow NULL? 
38RG_BCHCustomer Number of Payer - Postnvarchar100CHAR(N' ')Yes*/BEV3/CHRG_BCH Allow NULL? 
39WE_BCHCustomer Number of Ship-to Party - Postnvarchar100CHAR(N' ')Yes*/BEV3/CHWE_BCH Allow NULL? 
40AG_BCHCustomer Number of Sold-to Party - Postnvarchar100CHAR(N' ')Yes*/BEV3/CHAG_BCH Allow NULL? 
41RE_BCHCustomer Number of Bill-to Party - Postnvarchar100CHAR(N' ')Yes*/BEV3/CHRE_BCH Allow NULL? 
42DE_BCHCustomer Number - Postnvarchar100CHAR(N' ')Yes*/BEV3/CHDE_BCH Allow NULL? 
43VRL_BCHDistributor Number - Postnvarchar100CHAR(N' ')Yes*/BEV3/CHRL_BCH Allow NULL? 
44SPD_BCHForwarding Agent - Postnvarchar100CHAR(N' ')Yes*/BEV3/CHSPD_BCH Allow NULL? 
45RG_STATCustomer Number of Payer - Statisticsnvarchar100CHAR(N' ')Yes*/BEV3/CHRG_STAT Allow NULL? 
46WE_STATCustomer Number of Ship-to Party - Statisticsnvarchar100CHAR(N' ')Yes*/BEV3/CHWE_STAT Allow NULL? 
47AG_STATCustomer Number of Sold-to Party - Statisticsnvarchar100CHAR(N' ')Yes*/BEV3/CHAG_STAT Allow NULL? 
48RE_STATCustomer Number of Bill-to Party - Statisticsnvarchar100CHAR(N' ')Yes*/BEV3/CHRE_STAT Allow NULL? 
49VB_PERSNOPersonnel Number Sales Representativenvarchar80NUMC(N'00000000')Yes*/BEV3/CHBPERSNO Allow NULL? 
50BTRG_BCHAmount - Postdecimal162CURR((0))Yes/BEV3/CHBTRG_BCH
51WAERK_BCHCurrency Indicator - Postnvarchar50CUKY(N' ')Yes*/BEV3/CHWAERK_BCH Allow NULL? 
52LAST_BDGCondition that Modified Posting Datanvarchar40NUMC(N'0000')Yes*/BEV3/CHLASTBDG Allow NULL? 
53SPRASLanguage Key for Documentschar10LANG(N' ')YesT002/BEV3/CHSPRAS_BLG Allow NULL? 
54ZUORDNRAssignment Numbernvarchar180CHAR(N' ')YesDZUONR Allow NULL? 
55BSCHLPosting Keynvarchar20CHAR(N' ')Yes*BSCHL Allow NULL? 
56PBANKTYPPartner Bank Typenvarchar40CHAR(N' ')YesBVTYP Allow NULL? 
57ZAHLWEGPayment Methodchar10CHAR(N' ')Yes*DZLSCH Allow NULL? 
58ZAHLSPBlock Key for Paymentchar10CHAR(N' ')Yes*DZAHLS Allow NULL? 
59MAHNSPDunning blockchar10CHAR(N' ')Yes*MANSP Allow NULL? 
60MSCHLDunning keychar10CHAR(N' ')Yes*MSCHL Allow NULL? 
61ZAHLBEDTerms of Payment Keynvarchar40CHAR(N' ')YesDZTERM Allow NULL? 
62MAHNBERDunning Areanvarchar20CHAR(N' ')Yes*MABER Allow NULL? 
63BUCHDT_ABFrom Date of Settlement Periodnvarchar80DATS(N'00000000')Yes/BEV3/CHBUCHDAT_AB Allow NULL? 
64BUCHDT_BISTo Date of Settlement Periodnvarchar80DATS(N'00000000')Yes/BEV3/CHBUCHDAT_BIS Allow NULL? 
65BRCHDT_ABFrom Date of Calculation Intervalnvarchar80DATS(N'00000000')Yes/BEV3/CHBRCHDAT_AB Allow NULL? 
66BRCHDT_BISTo Date of Calculation Intervalnvarchar80DATS(N'00000000')Yes/BEV3/CHBRCHDAT_BIS Allow NULL? 
67VKORG_LSTGSales Organization - Performancenvarchar40CHAR(N' ')Yes*/BEV3/CHKORG_LSTG Allow NULL? 
68VTWEG_LSTGDistribution Channel - Performancenvarchar20CHAR(N' ')Yes*/BEV3/CHTWEG_LSTG Allow NULL? 
69SPART_LSTGDivision - Performancenvarchar20CHAR(N' ')Yes*/BEV3/CHSPART_LSTG Allow NULL? 
70BUKRS_LSTGCompany Code - Paymentnvarchar40CHAR(N' ')Yes*/BEV3/CHBUKRS_LSTG Allow NULL? 
71WERK_LSTGPlant - Performancenvarchar40CHAR(N' ')Yes*/BEV3/CHWERK_LSTG Allow NULL? 
72VWDNR_LSTGCHD Contract Number - Performancenvarchar130NUMC(N'0000000000000')Yes/BEV3/CHWDNR_LSTG Allow NULL? 
73BTRG_LSTGAmount - Paymentdecimal162CURR((0))Yes/BEV3/CHBTRG_LSTG
74WAERK_LSTGCurrency Indicator - Performancenvarchar50CUKY(N' ')Yes*/BEV3/CHWAERK_LSTG Allow NULL? 
75UKURSExchange Rate Performance -> Postdecimal95DEC((0))Yes/BEV3/CHUKURS
76KURSTYPExchange Rate Type of Conversion Performance -> Postnvarchar40CHAR(N' ')Yes*/BEV3/CHKURST_CURR Allow NULL? 
77PRZSTZ_ZNSPercentagedecimal73DEC((0))Yes/BEV3/CHZNSTZ
78PRZSTZ_MAXPercentage Maximumdecimal73DEC((0))Yes/BEV3/CHZNSTZ_MAX
79PRZSTZ_MINPercentage Minimumdecimal73DEC((0))Yes/BEV3/CHZNSTZ_MIN
80PRZSTZ_ABWPercentage Variancedecimal73DEC((0))Yes/BEV3/CHZNSTZ_ABW
81BTRG_ZNSAmount - Interest Basisdecimal162CURR((0))Yes/BEV3/CHBTRG_ZNS
82WAERK_ZNSCurrency Indicator - Interestnvarchar50CUKY(N' ')Yes*/BEV3/CHWAERK_ZNS Allow NULL? 
83I_ZNSCHLCH - Interest Key (Internal)nvarchar60CHAR(N' ')Yes/BEV3/CHZNSCHL_I Allow NULL? 
84E_ZNSCHLCH - Interest Key (External); Reference Interest Ratenvarchar100CHAR(N' ')Yes*/BEV3/CHZNSCHL_E Allow NULL? 
85SZBMETHInterest Calculation Methodchar10CHAR(N' ')YesSZBMETH Allow NULL? 
86STGBASISBase Days Methodchar10CHAR(N' ')YesVVSTGBASIS Allow NULL? 
87ABASTAGENumber of base days in a calculation periodnvarchar60NUMC(N'000000')YesABASTAGE Allow NULL? 
88ATAGENumber of Daysint100INT4((0))YesTFMATAGE Allow NULL? 
89MAT_NRMaterial Numbernvarchar180CHAR(N' ')Yes*MATNR Allow NULL? 
90SORTIMENTAssortment modulenvarchar180CHAR(N' ')Yes*W_SORTK Allow NULL? 
91MENGEMinimum Purchasedecimal155QUAN((0))Yes/BEV3/CHMNGE
92MEINHUnit of Measure of Minimum Purchasenvarchar30UNIT(N' ')Yes*/BEV3/CHMEINH_ABN Allow NULL? 
93MENGE_LSTGQuantity of Purchase Performancedecimal155QUAN((0))Yes/BEV3/CHMNGE_LSTG
94MEINH_LSTGUnit of Measure for Performance Quantitynvarchar30UNIT(N' ')Yes*/BEV3/CHMEINH_LSTG Allow NULL? 
95BTRG_UMSAmount - Salesdecimal162CURR((0))Yes/BEV3/CHBTRG_UMS
96WAERK_UMSCurrency Indicator - Salesnvarchar50CUKY(N' ')Yes*/BEV3/CHWAERK_UMS Allow NULL? 
97SACHKTOG/L Account Numbernvarchar100CHAR(N' ')Yes*SAKNR Allow NULL? 
98KOST_STCost Centernvarchar100CHAR(N' ')Yes*KOSTL Allow NULL? 
99I_AUFTRGOrder Numbernvarchar120CHAR(N' ')Yes*AUFNR Allow NULL? 
100PRFTCNTRProfit Centernvarchar100CHAR(N' ')Yes*PRCTR Allow NULL? 
101MWSKZTax on sales/purchases codenvarchar20CHAR(N' ')Yes*MWSKZ Allow NULL? 
102BTRG_STRTax Amount in Local Currencydecimal132CURR((0))YesMWSTS
103BTRG_STRBASTax Base Amount in Local Currencydecimal132CURR((0))YesHWBAS
104WAERK_STRCurrency Indicator - Taxnvarchar50CUKY(N' ')Yes*/BEV3/CHWAERK_STR Allow NULL? 
105EVENT_NRCH BTE Sequence Number of Event Receiptnvarchar160NUMC(N'0000000000000000')Yes/BEV3/CHEVENR Allow NULL? 
106BUZEINumber of Line Item Within Accounting Documentnvarchar30NUMC(N'000')YesBUZEI Allow NULL? 
107TXT_BCHIndividual Posting Textnvarchar500CHAR(N' ')Yes/BEV3/CHTXTBCH Allow NULL? 
108BK_LFDNRSequence Numbernvarchar160NUMC(N'0000000000000000')Yes/BEV3/CHLFDNR16 Allow NULL? 
109UMSSTAFFELScale IDnvarchar60CHAR(N' ')Yes*/BEV3/CHSTAF_RA Allow NULL? 
110ABSSTAFFELScale IDnvarchar60CHAR(N' ')Yes*/BEV3/CHSTAF_RA Allow NULL? 
111GLTG_ABCH Date Valid Fromnvarchar80DATS(N'00000000')Yes/BEV3/CHDATABV Allow NULL? 
112MEINH_VGUnit of Measurenvarchar30UNIT(N' ')Yes*/BEV3/CHMEINH Allow NULL? 
113WAERK_VGCurrency indicatornvarchar50CUKY(N' ')Yes*/BEV3/CHWAERK Allow NULL? 
114ABSBASIS_VGSales Basisdecimal155QUAN((0))Yes/BEV3/CHABSBAS
115BTRG_VGAmountdecimal162CURR((0))Yes/BEV3/CHBTRG
116PRT_IDAssignment to a Document Printoutnvarchar40NUMC(N'0000')Yes/BEV3/CHPRTID Allow NULL? 
117ABR_TYPSettlement Type (Settlement/Proposal/Simulation/Event)char10CHAR(N' ')Yes/BEV3/CHABRTYP Allow NULL? 
118ST_KZCancel. ID ('X'->Cancellation; ' '->Canceled cancellationchar10CHAR(N' ')Yes/BEV3/CHST_KZ Allow NULL? 
NamePrimaryUniqueTypeColumns
/BEV3/CHSIMSTZ_PBCNoNoNONCLUSTEREDRG_BCH, VWDNR_BCH, BUKRS_BCH, VBEWAR
/BEV3/CHSIMSTZ_P~0YesYesCLUSTEREDPOS_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