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
6/ISDFPS/CHVW_E34External Batch Where-Used List
7FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9BSEG345Accounting Document Segment
10FMARCPAR4Parallelization of FMARC_BATCH

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5OJDT100Journal Entry
6INV1265A/R Invoice - Rows
7OPCH386A/P Invoice
8JDT1124Journal Entry - Rows
9OPOR386Purchase Order
10OVTG52Tax Definition

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
9OINM101Whse Journal
10OSRN20Serial Numbers Master Data
Industry Specific :: Clinical System
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0N2N3AF02851PDOK: N3AFRM02 HI: Medication Prescription ph ProceduresClinical 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_RB1KR2, N3A_KKNAME, N3A_KKNUM, N3A_PATNN, N3A_PATVN, N3A_PATGDT, N3A_PATSTR, N3A_PATPLZ, N3A_PATORT, N3A_INSTKZ, N3A_VERSNR, N3A_VERSST, N3A_VERSSE, N3A_VERARZ, N3A_VKBIS, X00_AUSDT, N3A_AUSDT, N3A_F01A34, N3A_F01A35, N3A_F01A38, N3A_F01A39, N3A_KLNAME, N3A_FACHR, N3A_ORGNA, N3A_OSTRAS, N3A_OPLZ, N3A_OORT, N3A_OTELNR, N3A_OFAXNR, N3A_OARZTN, N3A_F01A97, N3A_F01A98, N3A_F01A47, N3A_ALL01, N3A_ALL02, N3A_ALL03, N3A_FORMN, N3A_VARZTN, N3A_GPART, N3A_VARZT, N3A_CAPT, X00_RB1KR2, X00_ALL01, X00_KKNAME, X00_KKNUM, X00_GPART, X00_F01A97, X00_F01A98, N3A_X13, X00_PATNN, X00_PATVN, X00_PATGDT, X00_PATSTR, X00_PATPLZ, X00_PATORT, X00_INSTKZ, X00_VERSNR, X00_VERSST, X00_VERSSE, X00_VERARZ, X00_VKBIS, X02_AUSDT, X01_AUSDT, X00_ALL02, X00_F01A34, X00_F01A35, X00_ALL03, X00_F01A47, X00_F01A38, X00_F01A39, N3A_X11, N3A_X12, X00_X11, X00_X12, X00_X13, N3A_X14, N3A_X15, N3A_X16, N3A_X17, N3A_INDNR FROM N2N3AF02
ColumnFieldDescriptionSQL TypeLengthDecimalsRelationDefault ValueConstraintsSQL Create Statement
1MANDTClientnvarchar30 Allow NULL? 
2DOKARDocument Typenvarchar30 Allow NULL? 
3DOKNRDocument numbernvarchar250 Allow NULL? 
4DOKVRDocument Versionnvarchar20 Allow NULL? 
5DOKTLDocument Partnvarchar30 Allow NULL? 
6N3A_RB1KR2HI: Radio Button Bar Health Insurer with AI*char10 Allow NULL? 
7N3A_KKNAMEHealth Insurer Namenvarchar350 Allow NULL? 
8N3A_KKNUMHealth Insurer No.nvarchar150 Allow NULL? 
9N3A_PATNNLast Name of Person Insurednvarchar300 Allow NULL? 
10N3A_PATVNInsured First Namenvarchar300 Allow NULL? 
11N3A_PATGDTBirthdate of Person Insurednvarchar80 Allow NULL? 
12N3A_PATSTRStreet and Number of Insured Personnvarchar300 Allow NULL? 
13N3A_PATPLZPostal Codenvarchar100 Allow NULL? 
14N3A_PATORTCity of Person Insurednvarchar300 Allow NULL? 
15N3A_INSTKZHI Fund Number / Institute Indicatornvarchar70 Allow NULL? 
16N3A_VERSNRHealth Insurance No.nvarchar200 Allow NULL? 
17N3A_VERSSTStatus of Insurednvarchar40 Allow NULL? 
18N3A_VERSSESupplement to Status of Insured Personnvarchar30 Allow NULL? 
19N3A_VERARZNumber of Contracted Physiciannvarchar200 Allow NULL? 
20N3A_VKBIS'Valid to' Date of Health Insurance Cardnvarchar80 Allow NULL? 
21X00_AUSDTReference Key of a Referenced Objectnvarchar200 Allow NULL? 
22N3A_AUSDTHI: Date of Issuenvarchar80 Allow NULL? 
23N3A_F01A34Checkboxchar10 Allow NULL? 
24N3A_F01A35HI: Start of Treatmentnvarchar80 Allow NULL? 
25N3A_F01A38Checkboxchar10 Allow NULL? 
26N3A_F01A39Checkboxchar10 Allow NULL? 
27N3A_KLNAMEHI: Name of Clinicnvarchar300 Allow NULL? 
28N3A_FACHRHI: Specialtynvarchar300 Allow NULL? 
29N3A_ORGNAHI: Name of Issuing Organizational Unitnvarchar300 Allow NULL? 
30N3A_OSTRASHI: Street, Number of Issuing Organizational Unitnvarchar300 Allow NULL? 
31N3A_OPLZHI: Postal Code of Issuing Organizational Unitnvarchar100 Allow NULL? 
32N3A_OORTHI: Location of Issuing Organizational Unitnvarchar250 Allow NULL? 
33N3A_OTELNRHI: Telephone Number of Issuing Organizational Unitnvarchar160 Allow NULL? 
34N3A_OFAXNRHI: Fax Number of Organizational Unitnvarchar310 Allow NULL? 
35N3A_OARZTNHI: Contracted Physician No. (identical to N3A_VERARZ )nvarchar200 Allow NULL? 
36N3A_F01A97Checkboxchar10 Allow NULL? 
37N3A_F01A98Checkboxchar10 Allow NULL? 
38N3A_F01A47Checkboxchar10 Allow NULL? 
39N3A_ALL01HI: Fee Radio Buttonchar10 Allow NULL? 
40N3A_ALL02HI: Prescription Radio Buttonchar10 Allow NULL? 
41N3A_ALL03HI: Home Visit Radio Buttonchar10 Allow NULL? 
42N3A_FORMNSmart Forms: Form Namenvarchar300 Allow NULL? 
43N3A_VARZTNText (30 Characters)nvarchar300 Allow NULL? 
44N3A_GPARTIS-H: Business Partnernvarchar100 Allow NULL? 
45N3A_VARZTIS-H: Business Partnernvarchar100 Allow NULL? 
46N3A_CAPTShort Textnvarchar300 Allow NULL? 
47X00_RB1KR2HI: Radio Button Bar Health Insurer with AI*char10 Allow NULL? 
48X00_ALL01HI: Fee Radio Buttonchar10 Allow NULL? 
49X00_KKNAMEHealth Insurer Namenvarchar350 Allow NULL? 
50X00_KKNUMHealth Insurer No.nvarchar150 Allow NULL? 
51X00_GPARTIS-H: Business Partnernvarchar100 Allow NULL? 
52X00_F01A97Checkboxchar10 Allow NULL? 
53X00_F01A98Checkboxchar10 Allow NULL? 
54N3A_X13Reserve field XFELDchar10 Allow NULL? 
55X00_PATNNLast Name of Person Insurednvarchar300 Allow NULL? 
56X00_PATVNInsured First Namenvarchar300 Allow NULL? 
57X00_PATGDTBirthdate of Person Insurednvarchar80 Allow NULL? 
58X00_PATSTRStreet and Number of Insured Personnvarchar300 Allow NULL? 
59X00_PATPLZPostal Codenvarchar100 Allow NULL? 
60X00_PATORTLast Name of Person Insurednvarchar300 Allow NULL? 
61X00_INSTKZHI Fund Number / Institute Indicatornvarchar70 Allow NULL? 
62X00_VERSNRHealth Insurance No.nvarchar200 Allow NULL? 
63X00_VERSSTStatus of Insurednvarchar40 Allow NULL? 
64X00_VERSSESupplement to Status of Insured Personnvarchar30 Allow NULL? 
65X00_VERARZNumber of Contracted Physiciannvarchar200 Allow NULL? 
66X00_VKBIS'Valid to' Date of Health Insurance Cardnvarchar80 Allow NULL? 
67X02_AUSDTReference Key of a Referenced Objectnvarchar200 Allow NULL? 
68X01_AUSDTHI: Date of Issuenvarchar80 Allow NULL? 
69X00_ALL02HI: Prescription Radio Buttonchar10 Allow NULL? 
70X00_F01A34Checkboxchar10 Allow NULL? 
71X00_F01A35HI: Start of Treatmentnvarchar80 Allow NULL? 
72X00_ALL03HI: Home Visit Radio Buttonchar10 Allow NULL? 
73X00_F01A47Checkboxchar10 Allow NULL? 
74X00_F01A38Checkboxchar10 Allow NULL? 
75X00_F01A39Checkboxchar10 Allow NULL? 
76N3A_X11Reserve field XFELDchar10 Allow NULL? 
77N3A_X12Reserve field XFELDchar10 Allow NULL? 
78X00_X11Reserve field XFELDchar10 Allow NULL? 
79X00_X12Reserve field XFELDchar10 Allow NULL? 
80X00_X13Reserve field XFELDchar10 Allow NULL? 
81N3A_X14Reserve field XFELDchar10 Allow NULL? 
82N3A_X15Reserve field XFELDchar10 Allow NULL? 
83N3A_X16Reserve field XFELDchar10 Allow NULL? 
84N3A_X17Reserve field XFELDchar10 Allow NULL? 
85N3A_INDNRnvarchar40 Allow NULL? 
NamePrimaryUniqueTypeColumns
N2N3AF02~0YesYesCLUSTEREDDOKTL, DOKVR, DOKNR, DOKAR, MANDT