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 Healthcare - Industry-Specific Components for Hospitals :: Patient Accounting
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0TNEBM131IS-H: SEM Structure (TO)Patient Accounting
SQL:  selectupdate insert create

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

SELECT DATEI, LEITZIFFER, KATALOG1, KATALOG2, KATALOG3, ZIFFERNTXT, ZIFFTXT2, BMA_DM, BMA_WERT, EGO_WERT, EGO_WERTP, REST1, REST2 FROM TNEBM
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1DATEIIS-H: file name "to" datesnvarchar80CHAR(N' ')NoISH_DATEI Allow NULL? 
2LEITZIFFERIS-H: Service Codenvarchar50CHAR(N' ')NoISH_ZIFF Allow NULL? 
3KATALOG1IS-H: Catalog letterchar10CHAR(N' ')YesISH_KAT1 Allow NULL? 
4KATALOG2IS-H: Catalog Sectionnvarchar20NUMC(N'00')YesISH_KAT2 Allow NULL? 
5KATALOG3IS-H: Catalog Subsectionnvarchar20NUMC(N'00')YesISH_KAT3 Allow NULL? 
6ZIFFERNTXTIS-H: service description 1nvarchar400CHAR(N' ')YesISH_ZTXT1 Allow NULL? 
7ZIFFTXT2IS-H: service description 2nvarchar400CHAR(N' ')YesISH_ZTXT2 Allow NULL? 
8BMA_DMIS-H: fixed amount EMP (pre-approved)nvarchar70CHAR(N' ')YesISH_BMA_DM Allow NULL? 
9BMA_WERTIS-H: point evaluation EMPnvarchar50NUMC(N'00000')YesISH_BMA_WE Allow NULL? 
10EGO_WERTIS-H: fixed amount alt. health insurance charge catalognvarchar70CHAR(N' ')YesISH_EGO_WE Allow NULL? 
11EGO_WERTPIS-H: point evaluation alt. hlth. ins. charge catlg. (labor)nvarchar50NUMC(N'00000')YesISH_EGO_WP Allow NULL? 
12REST1IS-H: Rest 1 of the EBM structurenvarchar2000CHAR(N' ')YesISH_REST1 Allow NULL? 
13REST2IS-H: rest 2 of the EBM structurenvarchar1500CHAR(N' ')YesISH_REST2 Allow NULL? 
NamePrimaryUniqueTypeColumns
TNEBM~0YesYesCLUSTEREDDATEI, LEITZIFFER