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

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
4OVPM154Outgoing Payments
5OIVL77Whse Journal
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction
Industry Specific :: SAP Media :: Master Data
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0JSTSTRDAVERW302Reference Table for Street Records from DBPMaster Data
SQL:  selectupdate insert create

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

SELECT ALORT, STR_NRPOST, HNR1VON, HNR2VON, HNR1BIS, HNR2BIS, STRHNR1000, ALORT_NEU, STR_NRPNEU, HNR1VONNEU, HNR2VONNEU, HNR1BISNEU, HNR2BISNEU, VERSION_N3, VERSION_J, VERSION_M, VERSION_NR, AENDNRAKT, SNAMESORT, PLZNEU, SNAMEPO, ABKSTR, KENN_HNRAE, HNR_TYP, STR_CODE, OTL_KEY, KREISG_SCH, STATUS, XERROR, XGPVORH FROM JSTSTRDAVERW
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1ALORTIS-M: City Number (Unique)nvarchar80CHAR(N' ')No*JALORT Allow NULL? 
2STR_NRPOSTIS-M: Street key from postal service (for transfer)nvarchar110CHAR(N' ')NoSTRKEYPOST Allow NULL? 
3HNR1VONIS-M: House Number From (Numerical)nvarchar40CHAR(N' ')NoHNR1VON_DBP Allow NULL? 
4HNR2VONIS-M: Affix to First House Number (Alphanumeric)nvarchar40CHAR(N' ')NoHNR2VON_DBP Allow NULL? 
5HNR1BISIS-M: House Numbers To (Numerical)nvarchar40CHAR(N' ')NoHNR1BIS_DBP Allow NULL? 
6HNR2BISIS-M: Affix for Last House Number (Alphanumeric)nvarchar40CHAR(N' ')NoHNR2BIS_DBP Allow NULL? 
7STRHNR1000IS-M: 1000 column in house number intervalchar10CHAR(N' ')NoSTRHNR1000 Allow NULL? 
8ALORT_NEUIS-M: City Number (Unique)nvarchar80CHAR(N' ')No*JALORT Allow NULL? 
9STR_NRPNEUIS-M: Street key from postal service (for transfer)nvarchar110CHAR(N' ')NoSTRKEYPOST Allow NULL? 
10HNR1VONNEUIS-M: House Number From (Numerical)nvarchar40CHAR(N' ')NoHNR1VON_DBP Allow NULL? 
11HNR2VONNEUIS-M: Affix to First House Number (Alphanumeric)nvarchar40CHAR(N' ')NoHNR2VON_DBP Allow NULL? 
12HNR1BISNEUIS-M: House Numbers To (Numerical)nvarchar40CHAR(N' ')NoHNR1BIS_DBP Allow NULL? 
13HNR2BISNEUIS-M: Affix for Last House Number (Alphanumeric)nvarchar40CHAR(N' ')NoHNR2BIS_DBP Allow NULL? 
14VERSION_N3IS-M: Version number (3 characters for German post)nvarchar30CHAR(N' ')NoVERSION_N3 Allow NULL? 
15VERSION_JIS-M: Version yearnvarchar40NUMC(N'0000')YesVERSION_J Allow NULL? 
16VERSION_MIS-M: Version monthnvarchar20NUMC(N'00')YesVERSION_M Allow NULL? 
17VERSION_NRIS-M: Version numbernvarchar50CHAR(N' ')YesVERSION_NR Allow NULL? 
18AENDNRAKTChange Number in Processnvarchar90CHAR(N' ')Yes*AENDNRAKT Allow NULL? 
19SNAMESORTIS-M: Sort field for street namenvarchar460CHAR(N' ')YesSNAMESORT Allow NULL? 
20PLZNEUIS-M: New postal code (D)nvarchar50CHAR(N' ')YesPOPLZNEU Allow NULL? 
21SNAMEPOIS-M: Street name as printed in the addressnvarchar460CHAR(N' ')YesSNAMEPO Allow NULL? 
22ABKSTRIS-M: Abbreviation of Street Namenvarchar220CHAR(N' ')YesABKSTR22 Allow NULL? 
23KENN_HNRAESingle-Character Indicatorchar10CHAR(N' ')YesCHAR1 Allow NULL? 
24HNR_TYPSingle-Character Indicatorchar10CHAR(N' ')YesCHAR1 Allow NULL? 
25STR_CODEIS-M: Street code for coding street sectionsnvarchar30CHAR(N' ')YesSTR_CODE Allow NULL? 
26OTL_KEYIS-M: City District Numbernvarchar30CHAR(N' ')Yes*OTL_KEY Allow NULL? 
27KREISG_SCHIS-M: Postal district municipality key for transfernvarchar80NUMC(N'00000000')YesKREISGPOST Allow NULL? 
28STATUSIS-M: Status of new record for transferchar10CHAR(N' ')YesJPOSTATUS Allow NULL? 
29XERRORIS-M: Incorrect data recordchar10CHAR(N' ')YesX_FEHLER Allow NULL? 
30XGPVORHIS-M: Incorrect data recordchar10CHAR(N' ')YesX_FEHLER Allow NULL? 
NamePrimaryUniqueTypeColumns
JSTSTRDAVERW~0YesYesCLUSTEREDVERSION_N3, HNR2BISNEU, HNR1BISNEU, HNR2VONNEU, HNR1VONNEU, STR_NRPNEU, ALORT_NEU, STRHNR1000, HNR2BIS, HNR1BIS, HNR2VON, HNR1VON, STR_NRPOST, ALORT
JSTSTRDAVERW~001NoNoNONCLUSTEREDVERSION_NR, VERSION_M, VERSION_J