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  | VWORDE
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
Financials :: Financial Supply Chain Management :: Treasury and Risk Management :: Transaction Manager
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0VWORDE1146Order DataTransaction Manager
SQL:  selectupdate insert create

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

SELECT MANDT, BUKRS, NORDER, DTRANS, TTRANS, NTRANS, RERF, DERF, TERF, REHER, RBEAR, DBEAR, TBEAR, RBHER, RANL, RLDEPO, SSTATI, INTEB, SBEWART, SBEWZITI, SSOLHAB, DVORGANG, SVORGANG, SNWHR, SBWHR, SCWHR, ASTUECK, BWKURS, BNWHR, PWKURS, BBWHR, BCWHR, BHWHR, KURS1, KURS2, DORDER, DVALUT, DDISPO, DBESTAND, DBEST6B, SSPESEN, SLIMIT, BLIMIT, PLIMIT, RBANKK, RKONTRA, SROLEXTKO, SFDLEV, JFDUPD, JONLAEN, JZINSBAS, JZINSZPT, PKOND, SSTCKKZ, SSTCKTG, PEFFZINS, SEFFMETH, SCRWHR1, SCRWHR2, KCROSS, NORDEXT, SWOHER, XZUSATZ, DANST, TANST, SANST, SABRECH, SVERFALL, RDEALER, SOBJECT, KOSTL, GSBER, BBASIS, DBERVON, DBERBIS, ATAGE, ABASTAGE, SZBMETH, RZBANK, SROLEXTZB, JVERK6B, RHANDPL, SFLAT, DCOUPON, SCOUPON, SSWHR, BSWHR, SRUNIT, KWKURS, SINCL, DSCHLUSS, TSCHLUSS, SFGKZ, RAHABKI, RAHKTID, RPBANK, ZLSCH, SZART, SEXCLVON, SULTVON, SINCLBIS, SULTBIS, PEFFZCALL, RFHA, OBJNR, SDELETE, TBEGRU, ZUOND, REFER, MERKM, DBUDAT, SPAYRQ, SPRSNG, RPZAHL FROM VWORDE
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')No*MANDT Allow NULL? 
2BUKRSCompany Codenvarchar40CHAR(N' ')NoT001BUKRS Allow NULL? 
3NORDEROrder Numbernvarchar80NUMC(N'00000000')NoNORDER Allow NULL? 
4DTRANSFlow data key: System datenvarchar80DATS(N'00000000')NoVVDTRANS Allow NULL? 
5TTRANSTransaction data key: system timenvarchar60TIMS(N'000000')NoVVTTRANS Allow NULL? 
6NTRANSTransaction data key: Consecutive numbernvarchar40NUMC(N'0000')NoVVNTRANS Allow NULL? 
7RERFEntered bynvarchar120CHAR(N' ')YesRERF Allow NULL? 
8DERFFirst Entered onnvarchar80DATS(N'00000000')YesDERF Allow NULL? 
9TERFTime of Initial Entrynvarchar60TIMS(N'000000')YesTERF Allow NULL? 
10REHERSource of initial entrynvarchar100CHAR(N' ')YesREHER Allow NULL? 
11RBEAREmployee IDnvarchar120CHAR(N' ')YesRBEAR Allow NULL? 
12DBEARLast Edited onnvarchar80DATS(N'00000000')YesDBEAR Allow NULL? 
13TBEARLast Edited atnvarchar60TIMS(N'000000')YesTBEAR Allow NULL? 
14RBHEREditing Sourcenvarchar100CHAR(N' ')YesRBHER Allow NULL? 
15RANLSecurity ID Numbernvarchar130CHAR(N' ')YesVWPANLAVVRANLW Allow NULL? 
16RLDEPOSecurities Accountnvarchar100CHAR(N' ')YesTWD01VRLDEPO Allow NULL? 
17SSTATIStatus of data recordnvarchar20NUMC(N'00')YesTZC37SSTATI Allow NULL? 
18INTEBFinancial Assets Management internal levelnvarchar20NUMC(N'00')Yes*VVSINTEB Allow NULL? 
19SBEWARTFlow Typenvarchar40CHAR(N' ')YesTZB0ASBEWART Allow NULL? 
20SBEWZITIFlow categorynvarchar40CHAR(N' ')YesTZB03SBEWZITI Allow NULL? 
21SSOLHABDebit/credit indicatorchar10CHAR(N' ')YesVVSSOLHAB Allow NULL? 
22DVORGANGActivity datenvarchar80DATS(N'00000000')YesDVORGANG Allow NULL? 
23SVORGANGSecurities-Activitynvarchar80CHAR(N' ')YesRVORGANG Allow NULL? 
24SNWHRCurrency of nominal amountnvarchar50CUKY(N' ')YesTCURCSNWHR Allow NULL? 
25SBWHRPosition Currency (Currency of Position Amount)nvarchar50CUKY(N' ')YesTCURCSBWHR Allow NULL? 
26SCWHRSettlement Currencynvarchar50CUKY(N' ')YesTCURCSCWHR Allow NULL? 
27ASTUECKNumber of units for unit-quoted securitiesdecimal155DEC((0))YesASTUECK
28BWKURSSecurity price for unit quotationdecimal132CURR((0))YesBWKURS
29BNWHRNominal amountdecimal132CURR((0))YesBNWHR
30PWKURSSecurity price for percentage quotationdecimal107DEC((0))YesPWKURS
31BBWHRAmount in position currencydecimal132CURR((0))YesBBWHR
32BCWHRSettlement Amountdecimal132CURR((0))YesBCWHR
33BHWHRAmount in local currencydecimal132CURR((0))YesBHWHR
34KURS1Exchange ratedecimal95DEC((0))YesKURSF
35KURS2Exchange ratedecimal95DEC((0))YesKURSF
36DORDEROrder daynvarchar80DATS(N'00000000')YesDORDER Allow NULL? 
37DVALUTInterest Value Date/Calculation Datenvarchar80DATS(N'00000000')YesVVDZINVAL Allow NULL? 
38DDISPOValue date / planning daynvarchar80DATS(N'00000000')YesVVDWERTST Allow NULL? 
39DBESTANDPosition value datenvarchar80DATS(N'00000000')YesDBESTAND Allow NULL? 
40DBEST6BDate for ยง6b EstG relevant postingsnvarchar80DATS(N'00000000')YesDBEST6B Allow NULL? 
41SSPESENExpenses keychar10CHAR(N' ')YesSSPESEN Allow NULL? 
42SLIMITOrder notationchar10CHAR(N' ')YesSLIMIT Allow NULL? 
43BLIMITLimit price for unit quotationdecimal132CURR((0))YesBLIMIT
44PLIMITLimit price for percentage quotationdecimal107DEC((0))YesPLIMIT
45RBANKKBank accountnvarchar100CHAR(N' ')YesSKB1RBANKK Allow NULL? 
46RKONTRAReference to Counterpartynvarchar100CHAR(N' ')YesBUT000RKONTRA_NEW Allow NULL? 
47SROLEXTKODummy functionnvarchar30CHAR(N' ')YesDUMMY_3 Allow NULL? 
48SFDLEVPlanning levelnvarchar20CHAR(N' ')Yes*FDLEV Allow NULL? 
49JFDUPDRecord transferred to cash management and forecastchar10CHAR(N' ')YesJFDUPD Allow NULL? 
50JONLAENIndicator for fixing a flow recordchar10CHAR(N' ')YesJONLAEN Allow NULL? 
51JZINSBASFlow in interest basechar10CHAR(N' ')YesJZINSBAS Allow NULL? 
52JZINSZPTInterest datechar10CHAR(N' ')YesJZINSZPT Allow NULL? 
53PKONDPercentage rate for condition itemsdecimal107DEC((0))YesPKOND
54SSTCKKZAccrued interest methodchar10CHAR(N' ')YesSSTCKKZ Allow NULL? 
55SSTCKTGAccrued interest: Daily methodchar10CHAR(N' ')YesSSTCKTG Allow NULL? 
56PEFFZINSEffective Interest Ratedecimal107DEC((0))YesPEFFZINS
57SEFFMETHEffective Interest Method (Financial Mathematics)char10NUMC(N'0')YesSEFFMETH Allow NULL? 
58SCRWHR1Currency Keynvarchar50CUKY(N' ')YesTCURCWAERS Allow NULL? 
59SCRWHR2Currency Keynvarchar50CUKY(N' ')YesTCURCWAERS Allow NULL? 
60KCROSSExchange ratedecimal95DEC((0))YesKURSF
61NORDEXTExternal order numbernvarchar200CHAR(N' ')YesNORDEXT Allow NULL? 
62SWOHERSource of flow recordchar10CHAR(N' ')YesSWOHER Allow NULL? 
63XZUSATZAssignmentnvarchar180CHAR(N' ')YesXZUSATZ Allow NULL? 
64DANSTReservation datenvarchar80DATS(N'00000000')YesDANST Allow NULL? 
65TANSTOrder time of daynvarchar60TIMS(N'000000')YesTANST Allow NULL? 
66SANSTReservation reasonnvarchar20CHAR(N' ')Yes*SANST Allow NULL? 
67SABRECHSingle-Character Indicatorchar10CHAR(N' ')YesCHAR1 Allow NULL? 
68SVERFALLSingle-Character Indicatorchar10CHAR(N' ')YesCHAR1 Allow NULL? 
69RDEALERTradernvarchar120CHAR(N' ')YesTZDEARDEALER Allow NULL? 
70SOBJECTInternal key for objectnvarchar100CHAR(N' ')YesVVKEYOBJ Allow NULL? 
71KOSTLCost Centernvarchar100CHAR(N' ')Yes*KOSTL Allow NULL? 
72GSBERBusiness Areanvarchar40CHAR(N' ')Yes*GSBER Allow NULL? 
73BBASISCalculation base amountdecimal132CURR((0))YesBBASIS
74DBERVONStart of Calculation Periodnvarchar80DATS(N'00000000')YesDBERVON Allow NULL? 
75DBERBISEnd of Calculation Periodnvarchar80DATS(N'00000000')YesDBERBIS Allow NULL? 
76ATAGENumber of daysnvarchar60NUMC(N'000000')YesVVATAGE Allow NULL? 
77ABASTAGENumber of base days in a calculation periodnvarchar60NUMC(N'000000')YesABASTAGE Allow NULL? 
78SZBMETHInterest Calculation Methodchar10CHAR(N' ')YesSZBMETH Allow NULL? 
79RZBANKPaying Banknvarchar100CHAR(N' ')YesBUT000VVRZBANK_NEW Allow NULL? 
80SROLEXTZBExternal role of partnernvarchar30CHAR(N' ')Yes*SROLEXT Allow NULL? 
81JVERK6BSingle-Character Indicatorchar10CHAR(N' ')YesCHAR1 Allow NULL? 
82RHANDPLExchangenvarchar100CHAR(N' ')YesTWH01VVRHANDPL Allow NULL? 
83SFLATIndicator 'Traded flat',i.e.no accrued interest calculationchar10CHAR(N' ')YesVVSFLAT Allow NULL? 
84DCOUPONCoupon date of next delivered couponnvarchar80DATS(N'00000000')YesVVDCOUPON Allow NULL? 
85SCOUPONCoupon ID for interest and accrued interest calculationchar10CHAR(N' ')YesVVSCOUPON Allow NULL? 
86SSWHRStock price currencynvarchar50CUKY(N' ')Yes*VVSSWHR Allow NULL? 
87BSWHRMarket valuedecimal132CURR((0))YesVVBSWHR
88SRUNITCurrency unitnvarchar50CHAR(N' ')Yes*VVSRUNIT Allow NULL? 
89KWKURSSecurity pricedecimal156DEC((0))YesVVKWKURS
90SINCLInclusive indicator for beginning and end of a periodchar10NUMC(N'0')YesVVSINCL Allow NULL? 
91DSCHLUSSDate of business closingnvarchar80DATS(N'00000000')YesVVDSCHLUSS Allow NULL? 
92TSCHLUSSTime of business closingnvarchar60TIMS(N'000000')YesVVTSCHLUSS Allow NULL? 
93SFGKZRelease Indicatorchar10CHAR(N' ')YesVVSFGKZ Allow NULL? 
94RAHABKIShort key for own house banknvarchar50CHAR(N' ')Yes*TB_RHABKI Allow NULL? 
95RAHKTIDShort key for house bank accountnvarchar50CHAR(N' ')Yes*TB_RHKTID Allow NULL? 
96RPBANKPartner bank detailsnvarchar40CHAR(N' ')YesTB_RPBANK Allow NULL? 
97ZLSCHPayment Methodchar10CHAR(N' ')Yes*DZLSCH Allow NULL? 
98SZARTPayment transactionchar10CHAR(N' ')YesTB_SZART Allow NULL? 
99SEXCLVONExclusive Indicator for the Start of a Calculation Periodchar10NUMC(N'0')YesVVSEXCLVON Allow NULL? 
100SULTVONMonth-End Indicator for Start of a Calculation Periodchar10CHAR(N' ')YesVVSULTVON Allow NULL? 
101SINCLBISInclusive Indicator for the End of a Calculation Periodchar10NUMC(N'0')YesVVSINCLBIS Allow NULL? 
102SULTBISMonth-End Indicator for the End of a Calculation Periodchar10CHAR(N' ')YesVVSULTBIS Allow NULL? 
103PEFFZCALLEffective Interest Ratedecimal107DEC((0))YesPEFFZINS
104RFHAFinancial Transactionnvarchar130CHAR(N' ')Yes*TB_RFHA Allow NULL? 
105OBJNRObject numbernvarchar220CHAR(N' ')YesONR00J_OBJNR Allow NULL? 
106SDELETEDeletion indicatorchar10NUMC(N'0')YesVVSLOEKZ Allow NULL? 
107TBEGRUAuthorization Groupnvarchar40CHAR(N' ')Yes*TBEGRU Allow NULL? 
108ZUONDAssignmentnvarchar180CHAR(N' ')YesTB_ZUOND Allow NULL? 
109REFERInternal Referencenvarchar160CHAR(N' ')YesTB_REFER Allow NULL? 
110MERKMCharacteristicsnvarchar250CHAR(N' ')YesTB_MERKM Allow NULL? 
111DBUDATPosting Date in the Documentnvarchar80DATS(N'00000000')YesBUDAT Allow NULL? 
112SPAYRQGenerate payment requestchar10CHAR(N' ')YesTB_SPAYRQK Allow NULL? 
113SPRSNGIndividual paymentchar10CHAR(N' ')YesTB_SPRSNGK Allow NULL? 
114RPZAHLPayer/payeenvarchar100CHAR(N' ')Yes*TB_RPZAHL_NEW Allow NULL? 
NamePrimaryUniqueTypeColumns
VWORDE~0YesYesCLUSTEREDMANDT, BUKRS, NORDER, DTRANS, TTRANS, NTRANS
VWORDE~1NoNoNONCLUSTEREDMANDT, BUKRS, NORDER
VWORDE~2NoNoNONCLUSTEREDBUKRS, RANL, RLDEPO
VWORDE~3NoNoNONCLUSTEREDDVALUT
VWORDE~4NoNoNONCLUSTEREDSBEWART
VWORDE~RM1NoNoNONCLUSTEREDOBJNR

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