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  | VZSKOKO
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.0VZSKOKO311Condition header for stock, subscrip.rights, investmentsTransaction Manager
SQL:  selectupdate insert create

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

SELECT MANDT, RANL, DGUEL_KK, SANLF, SSTATI, KZAHLAKT, BZAHLAKT, DREST, SZAHLDIV, DDBAB, RDIVNR, BAUSGLCH, SWHRAUSG, DXGUELT, DTSCHAB, DXTAUSCH, ATCHNEN, ATSHZAE, PWANLRAB, JTHESAU, DBFRB, DBFRV, BBPRU, RWBZP, RWBZP_T, DBHAB, DBHAV, BBVHN, BBVHZ, BVNJA, KREAK FROM VZSKOKO
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2RANLContract Numbernvarchar130CHAR(N' ')NoRANL Allow NULL? 
3DGUEL_KKDate Condition Effective fromnvarchar80DATS(N'00000000')NoDGUEL Allow NULL? 
4SANLFProduct Categorynvarchar30NUMC(N'000')Yes*SANLF Allow NULL? 
5SSTATIStatus of data recordnvarchar20NUMC(N'00')Yes*SSTATI Allow NULL? 
6KZAHLAKTPay-in ratedecimal107DEC((0))YesKZAHLAKT
7BZAHLAKTAmount Depositeddecimal102CURR((0))YesBZAHLAKT
8DRESTBalance payment datenvarchar80DATS(N'00000000')YesDREST Allow NULL? 
9SZAHLDIVDividend form of paymentchar10NUMC(N'0')YesSZAHLDIV Allow NULL? 
10DDBABDate from which entitled to dividendsnvarchar80DATS(N'00000000')YesDDBAB Allow NULL? 
11RDIVNRDividend coupon numbernvarchar30NUMC(N'000')YesRDIVNR Allow NULL? 
12BAUSGLCHClearing amount for swapdecimal102CURR((0))YesBABTA
13SWHRAUSGClearing amount currencynvarchar50CUKY(N' ')YesTCURCSWHRAUSG Allow NULL? 
14DXGUELTTrading untilnvarchar80DATS(N'00000000')YesDTGBI Allow NULL? 
15DTSCHABSwap period fromnvarchar80DATS(N'00000000')YesDTFVO Allow NULL? 
16DXTAUSCHSwap period tonvarchar80DATS(N'00000000')YesDTFBI Allow NULL? 
17ATCHNENSwap ratio - denominatordecimal94DEC((0))YesBTVNE
18ATSHZAESwap ratio - numeratordecimal94DEC((0))YesBTVZA
19PWANLRABReinvestment discount percentdecimal107DEC((0))YesPWARB
20JTHESAUReinvestment indicatorchar10CHAR(N' ')YesSTHES Allow NULL? 
21DBFRBDate subscription period untilnvarchar80DATS(N'00000000')YesDBFRB Allow NULL? 
22DBFRVSubscription period fromnvarchar80DATS(N'00000000')YesDBFRV Allow NULL? 
23BBPRUUnderlying subscription pricedecimal102CURR((0))YesBBPRU
24RWBZPSubscription price currencynvarchar50CUKY(N' ')YesTCURCRWBZP Allow NULL? 
25RWBZP_T30 Charactersnvarchar300CHAR(N' ')YesCHAR30 Allow NULL? 
26DBHABDate of subscription rights trading untilnvarchar80DATS(N'00000000')YesDBHAB Allow NULL? 
27DBHAVDate of subscription rights trading fromnvarchar80DATS(N'00000000')YesDBHAV Allow NULL? 
28BBVHNSubscription ratio - Denominatordecimal94DEC((0))YesBBVHN
29BBVHZSubscription ratio - Numeratordecimal94DEC((0))YesBBVHZ
30BVNJAAdvantage/disadvantage dividend of new stockdecimal102CURR((0))YesBVNJA
31KREAKPost Subscription Rightsdecimal156DEC((0))YesKREAK
NamePrimaryUniqueTypeColumns
VZSKOKO~0YesYesCLUSTEREDMANDT, RANL, DGUEL_KK

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