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  | VDORDER
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
Financial Services :: Loans Management
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0VDORDER771Borrower's note loan order dataLoans Management
SQL:  selectupdate insert create

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

SELECT MANDT, BUKRS, RANL, NORDER, RERF, DERF, TERF, REHER, RBEAR, DBEAR, TBEAR, RBHER, SABRECH, SBEWART, SBEWZITI, SPLANIST, SSOLHAB, SANLF, SSTATI, GSART, RREFKONT, DORDER, BNWHR, SNWHR, BBWHR, SBWHR, BCWHR, SCWHR, BHWHR, KURS1, KURS2, DVALUT, DFAELL, DDISPO, DBESTAND, DBERVON, DBERBIS, ATAGE, ABASTAGE, SZBMETH, JONLAEN, JZINSBAS, JZINSZPT, PKOND, BBASIS, SSORTZIT, SWOHER, SSTCKKZ, SSTCKTG, PEFFZINS, SEFFMETH, PARTNR, SROLEXT, XPART, SANRED, SWORTL, DVKMAX, KKASSE, KMARKT, BVTYP, RBANKK, PWKURS, SGTXT, RDEALER, DVKMIN, ZUONR, XPORE, SPAYRQ, HBKID, HKTID, ZLSCH, SPRSNG, UZAWE, SPRGRD, SCSPAY, ZWELS, PAYGR FROM VDORDER
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2BUKRSCompany Codenvarchar40CHAR(N' ')NoT001BUKRS Allow NULL? 
3RANLContract Numbernvarchar130CHAR(N' ')NoRANL Allow NULL? 
4NORDEROrder Numbernvarchar80NUMC(N'00000000')NoNORDER Allow NULL? 
5RERFEntered bynvarchar120CHAR(N' ')YesRERF Allow NULL? 
6DERFFirst Entered onnvarchar80DATS(N'00000000')YesDERF Allow NULL? 
7TERFTime of Initial Entrynvarchar60TIMS(N'000000')YesTERF Allow NULL? 
8REHERSource of initial entrynvarchar100CHAR(N' ')YesREHER Allow NULL? 
9RBEAREmployee IDnvarchar120CHAR(N' ')YesRBEAR Allow NULL? 
10DBEARLast Edited onnvarchar80DATS(N'00000000')YesDBEAR Allow NULL? 
11TBEARLast Edited atnvarchar60TIMS(N'000000')YesTBEAR Allow NULL? 
12RBHEREditing Sourcenvarchar100CHAR(N' ')YesRBHER Allow NULL? 
13SABRECHStatus borrower's note orderchar10CHAR(N' ')YesSSDSTAT Allow NULL? 
14SBEWARTFlow Typenvarchar40CHAR(N' ')Yes*SBEWART Allow NULL? 
15SBEWZITIFlow categorynvarchar40CHAR(N' ')YesTZB03SBEWZITI Allow NULL? 
16SPLANISTPlan/actual record/record to be released indicatorchar10CHAR(N' ')YesSPLANIST Allow NULL? 
17SSOLHABDebit/credit indicatorchar10CHAR(N' ')YesVVSSOLHAB Allow NULL? 
18SANLFProduct Categorynvarchar30NUMC(N'000')Yes*SANLF Allow NULL? 
19SSTATIOrder Statusnvarchar20NUMC(N'00')Yes*VVDSTATORD Allow NULL? 
20GSARTProduct Typenvarchar30CHAR(N' ')YesTZPABVVSART Allow NULL? 
21RREFKONTAccount Assignment Reference in Financial Assets Managementnvarchar80CHAR(N' ')YesT037SRREFKONT Allow NULL? 
22DORDEROrder daynvarchar80DATS(N'00000000')YesDORDER Allow NULL? 
23BNWHRNominal amountdecimal132CURR((0))YesBNWHR
24SNWHRCurrency of nominal amountnvarchar50CUKY(N' ')YesTCURCSNWHR Allow NULL? 
25BBWHRAmount in position currencydecimal132CURR((0))YesBBWHR
26SBWHRPosition Currency (Currency of Position Amount)nvarchar50CUKY(N' ')YesTCURCSBWHR Allow NULL? 
27BCWHRSettlement Amountdecimal132CURR((0))YesBCWHR
28SCWHRSettlement Currencynvarchar50CUKY(N' ')YesTCURCSCWHR Allow NULL? 
29BHWHRAmount in local currencydecimal132CURR((0))YesBHWHR
30KURS1Exchange ratedecimal95DEC((0))YesVVKURSF
31KURS2Exchange ratedecimal95DEC((0))YesVVKURSF
32DVALUTCalculation Datenvarchar80DATS(N'00000000')YesDVALUT Allow NULL? 
33DFAELLDue date/calculation datenvarchar80DATS(N'00000000')YesDFAELLIG Allow NULL? 
34DDISPOPayment Datenvarchar80DATS(N'00000000')YesDDISPO Allow NULL? 
35DBESTANDPosition value datenvarchar80DATS(N'00000000')YesDBESTAND Allow NULL? 
36DBERVONStart of Calculation Periodnvarchar80DATS(N'00000000')YesDBERVON Allow NULL? 
37DBERBISEnd of Calculation Periodnvarchar80DATS(N'00000000')YesDBERBIS Allow NULL? 
38ATAGENumber of daysnvarchar60NUMC(N'000000')YesVVATAGE Allow NULL? 
39ABASTAGENumber of base days in a calculation periodnvarchar60NUMC(N'000000')YesABASTAGE Allow NULL? 
40SZBMETHInterest Calculation Methodchar10CHAR(N' ')YesSZBMETH Allow NULL? 
41JONLAENIndicator for fixing a flow recordchar10CHAR(N' ')YesJONLAEN Allow NULL? 
42JZINSBASFlow in interest basechar10CHAR(N' ')YesJZINSBAS Allow NULL? 
43JZINSZPTInterest datechar10CHAR(N' ')YesJZINSZPT Allow NULL? 
44PKONDPercentage rate for condition itemsdecimal107DEC((0))YesPKOND
45BBASISCalculation base amountdecimal132CURR((0))YesBBASIS
46SSORTZITSort indicator for interest/repayment schedule calculationschar10CHAR(N' ')YesSSORTZIT Allow NULL? 
47SWOHERSource of flow recordchar10CHAR(N' ')YesSWOHER Allow NULL? 
48SSTCKKZAccrued interest methodchar10CHAR(N' ')YesSSTCKKZ Allow NULL? 
49SSTCKTGAccrued interest: Daily methodchar10CHAR(N' ')YesSSTCKTG Allow NULL? 
50PEFFZINSEffective Interest Ratedecimal107DEC((0))YesPEFFZINS
51SEFFMETHEffective Interest Method (Financial Mathematics)char10NUMC(N'0')YesSEFFMETH Allow NULL? 
52PARTNRBusiness Partner Numbernvarchar100CHAR(N' ')YesBUT000BU_PARTNER Allow NULL? 
53SROLEXTDummy functionnvarchar30CHAR(N' ')YesDUMMY_3 Allow NULL? 
54XPARTName of Contact Person (User-Defined Text)nvarchar300CHAR(N' ')YesXPART Allow NULL? 
55SANREDForm of Address (Key)nvarchar40CHAR(N' ')YesTSAD3BP_TITLE_NEW Allow NULL? 
56SWORTLWording of order/contractnvarchar20NUMC(N'00')YesTD20SWORTL Allow NULL? 
57DVKMAXValue date for preemption at the latest bynvarchar80DATS(N'00000000')YesDVKMAX Allow NULL? 
58KKASSECash price for repeat purchasesdecimal107DEC((0))YesKKASSE
59KMARKTMarket price for preemptionsdecimal107DEC((0))YesKMARKT
60BVTYPPartner Bank Typenvarchar40CHAR(N' ')YesBVTYP Allow NULL? 
61RBANKKBank accountnvarchar100CHAR(N' ')Yes*RBANKK Allow NULL? 
62PWKURSSecurity price for percentage quotationdecimal107DEC((0))YesPWKURS
63SGTXTItem Textnvarchar500CHAR(N' ')YesSGTXT Allow NULL? 
64RDEALERTradernvarchar120CHAR(N' ')YesTZDEARDEALER Allow NULL? 
65DVKMINPreemption payment date Poss. as fromnvarchar80DATS(N'00000000')YesDVKMIN Allow NULL? 
66ZUONRAssignment Numbernvarchar180CHAR(N' ')YesDZUONR Allow NULL? 
67XPOREIndicator: Individual Payment?char10CHAR(N' ')YesPRQ_XPORE Allow NULL? 
68SPAYRQGenerate payment requestchar10CHAR(N' ')YesTB_SPAYRQK Allow NULL? 
69HBKIDShort Key for a House Banknvarchar50CHAR(N' ')YesT012HBKID Allow NULL? 
70HKTIDID for account detailsnvarchar50CHAR(N' ')YesT012KHKTID Allow NULL? 
71ZLSCHPayment Methodchar10CHAR(N' ')YesT042ZDZLSCH Allow NULL? 
72SPRSNGIndividual paymentchar10CHAR(N' ')YesTB_SPRSNGK Allow NULL? 
73UZAWEPayment Method Supplementnvarchar20CHAR(N' ')Yes*UZAWE Allow NULL? 
74SPRGRDDetermine grouping definitionchar10CHAR(N' ')YesTB_SPRGRD Allow NULL? 
75SCSPAYSame direction necessary for joint payment?char10CHAR(N' ')YesTB_SCSPAY Allow NULL? 
76ZWELSList of the Payment Methods to be Considerednvarchar100CHAR(N' ')YesDZWELS Allow NULL? 
77PAYGRGrouping Field for Automatic Paymentsnvarchar200CHAR(N' ')YesPAYGR Allow NULL? 
NamePrimaryUniqueTypeColumns
VDORDER~0YesYesCLUSTEREDMANDT, BUKRS, RANL, NORDER

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