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 :: Clinical System
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0N2N3AF06361PDOK: N3AFRM06 HI: Prescription (Private)Clinical System
SQL:  selectupdate insert create

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

SELECT MANDT, DOKAR, DOKNR, DOKVR, DOKTL, N3A_PATNN, N3A_KLNAME, N3A_PATVN, N3A_PATGDT, N3A_FACHR, N3A_PATSTR, N3A_ORGNA, N3A_PATPLZ, N3A_PATORT, N3A_OSTRAS, N3A_INSTKZ, N3A_VERSNR, N3A_VERSST, N3A_VERSSE, N3A_OPLZ, N3A_OORT, N3A_VERARZ, N3A_VKBIS, X00_AUSDT, N3A_AUSDT, N3A_OTELNR, N3A_OFAXNR, N3A_OARZTN, N3A_F05A13, N3A_KKNUM, N3A_KKNAME, N3A_CAPT, N3A_FORMN, N3A_VARZTN, N3A_VARZT, N3A_GPART FROM N2N3AF06
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')No*MANDT Allow NULL? 
2DOKARDocument Typenvarchar30CHAR(N' ')No*DOKAR Allow NULL? 
3DOKNRDocument numbernvarchar250CHAR(N' ')No*DOKNR Allow NULL? 
4DOKVRDocument Versionnvarchar20CHAR(N' ')NoDOKVR Allow NULL? 
5DOKTLDocument Partnvarchar30CHAR(N' ')NoDOKTL_D Allow NULL? 
6N3A_PATNNLast Name of Person Insurednvarchar300CHAR(N' ')YesN3A_PATNN Allow NULL? 
7N3A_KLNAMEHI: Name of Clinicnvarchar300CHAR(N' ')YesN3A_KLNAME Allow NULL? 
8N3A_PATVNInsured First Namenvarchar300CHAR(N' ')YesN3A_PATVN Allow NULL? 
9N3A_PATGDTBirthdate of Person Insurednvarchar80DATS(N'00000000')YesN3A_PATGDT Allow NULL? 
10N3A_FACHRHI: Specialtynvarchar300CHAR(N' ')YesN3A_FACHR Allow NULL? 
11N3A_PATSTRStreet and Number of Insured Personnvarchar300CHAR(N' ')YesN3A_PATSTR Allow NULL? 
12N3A_ORGNAHI: Name of Issuing Organizational Unitnvarchar300CHAR(N' ')YesN3A_ORGNA Allow NULL? 
13N3A_PATPLZPostal Codenvarchar100CHAR(N' ')YesN3A_PATPLZ Allow NULL? 
14N3A_PATORTCity of Person Insurednvarchar300CHAR(N' ')YesN3A_PATORT Allow NULL? 
15N3A_OSTRASHI: Street, Number of Issuing Organizational Unitnvarchar300CHAR(N' ')YesN3A_OSTRAS Allow NULL? 
16N3A_INSTKZHI Fund Number / Institute Indicatornvarchar70CHAR(N' ')YesN3A_INSTKZ Allow NULL? 
17N3A_VERSNRHealth Insurance No.nvarchar200CHAR(N' ')YesN3A_VERSNR Allow NULL? 
18N3A_VERSSTStatus of Insurednvarchar40CHAR(N' ')YesN3A_VERSST Allow NULL? 
19N3A_VERSSESupplement to Status of Insured Personnvarchar30CHAR(N' ')YesN3A_VERSSE Allow NULL? 
20N3A_OPLZHI: Postal Code of Issuing Organizational Unitnvarchar100CHAR(N' ')YesN3A_OPLZ Allow NULL? 
21N3A_OORTHI: Location of Issuing Organizational Unitnvarchar250CHAR(N' ')YesN3A_OORT Allow NULL? 
22N3A_VERARZNumber of Contracted Physiciannvarchar200CHAR(N' ')YesN3A_VERARZ Allow NULL? 
23N3A_VKBIS'Valid to' Date of Health Insurance Cardnvarchar80DATS(N'00000000')YesN3A_VKBIS Allow NULL? 
24X00_AUSDTReference Key of a Referenced Objectnvarchar200CHAR(N' ')YesN2_REFKEY Allow NULL? 
25N3A_AUSDTHI: Date of Issuenvarchar80DATS(N'00000000')YesN3A_AUSDT Allow NULL? 
26N3A_OTELNRHI: Telephone Number of Issuing Organizational Unitnvarchar160CHAR(N' ')YesN3A_OTELNR Allow NULL? 
27N3A_OFAXNRHI: Fax Number of Organizational Unitnvarchar310CHAR(N' ')YesN3A_OFAXNR Allow NULL? 
28N3A_OARZTNHI: Contracted Physician No. (identical to N3A_VERARZ )nvarchar200CHAR(N' ')YesN3A_OARZTN Allow NULL? 
29N3A_F05A13Checkboxchar10CHAR(N' ')YesXFELD Allow NULL? 
30N3A_KKNUMHealth Insurer No.nvarchar150CHAR(N' ')YesN3A_KKNUM Allow NULL? 
31N3A_KKNAMEHealth Insurer Namenvarchar350CHAR(N' ')YesN3A_KKNAME Allow NULL? 
32N3A_CAPTShort Textnvarchar300CHAR(N' ')YesTDTEXT Allow NULL? 
33N3A_FORMNSmart Forms: Form Namenvarchar300CHAR(N' ')Yes*TDSFNAME Allow NULL? 
34N3A_VARZTNText (30 Characters)nvarchar300CHAR(N' ')YesTEXT30 Allow NULL? 
35N3A_VARZTIS-H: Business Partnernvarchar100CHAR(N' ')Yes*GPARTNER Allow NULL? 
36N3A_GPARTIS-H: Business Partnernvarchar100CHAR(N' ')Yes*GPARTNER Allow NULL? 
NamePrimaryUniqueTypeColumns
N2N3AF06~0YesYesCLUSTEREDDOKTL, DOKVR, DOKNR, DOKAR, MANDT