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  | N1PRPAT
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)
8BSEG345Accounting Document Segment
9/1RA/0SD010MI170Items for Class SD01 - Raw Data
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
1ORCT154Incoming Payment
2OITM249Items
3OINV268A/R Invoice
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OINM101Whse Journal
7OPCH268A/P Invoice
8JDT1110Journal Entry - Rows
9OOCR9Loading Factors
10OSRN20Serial Numbers Master Data
Industry Specific :: Clinical System
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0N1PRPAT849IS-H*MED: PATREG: PatientenstammdatentabelleClinical System
SQL:  selectupdate insert create

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

SELECT MANDT, PATID, GSCHL, GSCHLE, GSCHLTXT, NNAME, NNAMS, VNAME, VNAMS, TITEL, NAMZU, VORSW, NAME2, GBDAT, GBNAM, GBNAS, GLAND, GLANDTXT, TODKZ, TODDT, TODZT, TODDB, TODZB, TODUR, TODURTXT, ANRED, ANREDTXT, FAMST, FAMSTTXT, KONFE, KONFETXT, NATIO, NATIOTXT, SPRAS, SPRASTXT, LAND, LANDTXT, PSTLZ, ORT, ORT2, STRAS, BLAND, BLANDTXT, GEBIE, TELF1, SPEND, SPENT, SPELT, VIPKZ, STATU, EXTNR, NOTAN, KRZAN, RFPAT, RFZIF, BERUF, RVNUM, ANNA1, ANVN1, ANLA1, ANLA1TXT, ANPL1, ANOR1, ANST1, ANTE1, ANVV1, ANVV1TXT, KZTXT, BEGDT, ENDDT, ERDAT, ERUSR, UPDAT, UPUSR, STORN, STUSR, STDAT, GBORT, RACE, RACETXT, RESID, PASSTY, PASSTYTXT, PASSNR FROM N1PRPAT
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTÜst birimnvarchar30CLNT(N'000')No*MANDT Allow NULL? 
2PATIDPATREG: Hasta taniticisinvarchar100CHAR(N' ')NoN1PRPATID Allow NULL? 
3GSCHLIS-H: Cinsiyet göstergesi - dahilichar10CHAR(N' ')NoGSCHL Allow NULL? 
4GSCHLEIS-H: Kullaniciya özgü cinsiyet göstergesichar10CHAR(N' ')Yes*GSCHLE Allow NULL? 
5GSCHLTXTIS-H: Cinsiyet tanimi - kullaniciya özgünvarchar100CHAR(N' ')YesTEXT_GES Allow NULL? 
6NNAMEIS-H: Hastanin soyadinvarchar300CHAR(N' ')YesNNAME_PAT Allow NULL? 
7NNAMSIS-H: Standartlasmis soyadnvarchar800CHAR(N' ')YesNNAMES_PAT Allow NULL? 
8VNAMEIS-H: Hastanin adinvarchar300CHAR(N' ')YesVNAME_PAT Allow NULL? 
9VNAMSIS-H: Standartlasmis adnvarchar800CHAR(N' ')YesVNAMES_PAT Allow NULL? 
10TITELIS-H: Basliknvarchar150CHAR(N' ')Yes*RI_TITEL Allow NULL? 
11NAMZUIS-H: Ad ekinvarchar150CHAR(N' ')Yes*RI_NAMZU Allow NULL? 
12VORSWIS-H: Ad önekinvarchar150CHAR(N' ')Yes*RI_VORSW Allow NULL? 
13NAME2IS-H: Takma ad, siparis adinvarchar300CHAR(N' ')YesNAME2_PAT Allow NULL? 
14GBDATIS-H: Dogum tarihinvarchar80DATS(N'00000000')NoRI_GBDAT Allow NULL? 
15GBNAMIS-H: Kizlik soyadinvarchar300CHAR(N' ')YesGBNAM Allow NULL? 
16GBNASIS-H: Standartlasmis kizlik soyadinvarchar800CHAR(N' ')YesGBNAMS_PAT Allow NULL? 
17GLANDIS-H: Dogdugu ülkenvarchar30CHAR(N' ')Yes*GLAND Allow NULL? 
18GLANDTXTÜlke adinvarchar150CHAR(N' ')YesLANDX Allow NULL? 
19TODKZIS-H: 'Hasta öldü' göstergesichar10CHAR(N' ')YesPAT_TOD Allow NULL? 
20TODDTIS-H: Ölüm tarihi (ilk)nvarchar80DATS(N'00000000')YesTODDV Allow NULL? 
21TODZTIS-H: Ölüm saati (baslangiç)nvarchar60TIMS(N'000000')YesTODZV Allow NULL? 
22TODDBISH: Ölüm tarihi (son)nvarchar80DATS(N'00000000')YesTODDB Allow NULL? 
23TODZBISH: Ölüm saati (son)nvarchar60TIMS(N'000000')YesTODZB Allow NULL? 
24TODURIS-H: Ölüm nedeninvarchar30CHAR(N' ')Yes*TODUR Allow NULL? 
25TODURTXTIS-H: Ölüm nedeni metninvarchar200CHAR(N' ')YesTUTXT Allow NULL? 
26ANREDIS-H: Hitap biçimi anahtarinvarchar20CHAR(N' ')Yes*RI_ANRDS Allow NULL? 
27ANREDTXTIS-H: Hitap biçimi metninvarchar250CHAR(N' ')YesRI_ANTXT Allow NULL? 
28FAMSTIS-H: Medeni durumchar10CHAR(N' ')YesRI_FAMST Allow NULL? 
29FAMSTTXTMedeni hali taniminvarchar60CHAR(N' ')YesFATXT Allow NULL? 
30KONFEIS-H: Mezhepnvarchar20CHAR(N' ')YesRI_KONFE Allow NULL? 
31KONFETXTDin tanimi uzun metinnvarchar250CHAR(N' ')YesKNFTX Allow NULL? 
32NATIOIS-H: Uyruknvarchar30CHAR(N' ')Yes*RI_NATIO Allow NULL? 
33NATIOTXTUyruk taniminvarchar150CHAR(N' ')YesNATIO Allow NULL? 
34SPRASIS-H: Dil (hasta)char10LANG(N' ')Yes*SPRAS_PAT Allow NULL? 
35SPRASTXTOmschrijving van de taalnvarchar160CHAR(N' ')YesSPTXT Allow NULL? 
36LANDIS-H: Hasta adresinin bulundugu ülkenvarchar30CHAR(N' ')Yes*LAND_PAT Allow NULL? 
37LANDTXTÜlke adinvarchar150CHAR(N' ')YesLANDX Allow NULL? 
38PSTLZIS-H: Hasta posta kodunvarchar100CHAR(N' ')YesPSTLZ_PAT Allow NULL? 
39ORTIS-H: Kentnvarchar400CHAR(N' ')YesISH_CITY1 Allow NULL? 
40ORT2IS-H: Semtnvarchar400CHAR(N' ')YesISH_CITY2 Allow NULL? 
41STRASIS-H: Sokaknvarchar400CHAR(N' ')YesISH_STRASS Allow NULL? 
42BLANDIS-H: Bölge (eyalet, il, ilçe, belde)nvarchar30CHAR(N' ')Yes*ISH_REGION Allow NULL? 
43BLANDTXTTanimnvarchar200CHAR(N' ')YesBEZEI20 Allow NULL? 
44GEBIEIS-H: Cografi alannvarchar90CHAR(N' ')YesEINZGEBIET Allow NULL? 
45TELF1IS-H: Telefonnvarchar300CHAR(N' ')YesISH_TELNR Allow NULL? 
46SPENDIS-H: Organ donörü göstergesichar10CHAR(N' ')YesSPENKZ Allow NULL? 
47SPENTIS-H: Donör göstergesi açiklamasinvarchar500CHAR(N' ')YesSPENTEXT Allow NULL? 
48SPELTIS-H: Uzun metin mevcut olup olmadigina iliskin göstergechar10CHAR(N' ')YesRI_LGTXT Allow NULL? 
49VIPKZIS-H: VIP göstergesichar10CHAR(N' ')YesVIPKZ Allow NULL? 
50STATUIS-H: Hasta durumuchar10CHAR(N' ')YesPAT_STATUS Allow NULL? 
51EXTNRIS-H: Harici hasta taniticisinvarchar200CHAR(N' ')YesEXT_PATNR Allow NULL? 
52NOTANIS-H: Acil kabul göstergesichar10CHAR(N' ')YesNOTAUF Allow NULL? 
53KRZANIS-H: Hizli kabul göstergesichar10CHAR(N' ')YesKURZAUF Allow NULL? 
54RFPATIS-H: Birlestirmede hasta numarasi referansinvarchar100CHAR(N' ')Yes*RFPAT Allow NULL? 
55RFZIFIS-H: Hasta kontrol rakamichar10CHAR(N' ')YesPZIFF_PAT Allow NULL? 
56BERUFIS-H: Hastanin mesleginvarchar250CHAR(N' ')YesBERUF Allow NULL? 
57RVNUMIS-H: Sosyal sigorta numarasinvarchar200CHAR(N' ')YesISH_RVNUM Allow NULL? 
58ANNA1IS-H: Haberdar edilecek kisinin soyadinvarchar300CHAR(N' ')YesNNAME_ANG Allow NULL? 
59ANVN1IS-H: Haberdar edilecek kisinin adinvarchar300CHAR(N' ')YesVNAME_ANG Allow NULL? 
60ANLA1IS-H: Haberdar edilecek kisinin ülkesinvarchar30CHAR(N' ')Yes*LAND_ANG Allow NULL? 
61ANLA1TXTÜlke adinvarchar150CHAR(N' ')YesLANDX Allow NULL? 
62ANPL1IS-H: Posta kodunvarchar100CHAR(N' ')YesPSTLZ_ANG Allow NULL? 
63ANOR1IS-H: Kentnvarchar400CHAR(N' ')YesISH_CITY1 Allow NULL? 
64ANST1IS-H: Sokaknvarchar400CHAR(N' ')YesISH_STRASS Allow NULL? 
65ANTE1IS-H: Telefonnvarchar300CHAR(N' ')YesISH_TELNR Allow NULL? 
66ANVV1IS-H: Akrabalik derecesichar10CHAR(N' ')Yes*VERWVH Allow NULL? 
67ANVV1TXTIS-H: Akrabalik derecesi metninvarchar150CHAR(N' ')YesTEXT_VER Allow NULL? 
68KZTXTIS-H: Hasta için açiklamanvarchar500CHAR(N' ')YesTEXT_PAT Allow NULL? 
69BEGDTIS-H: Kaydin geçerlik baslangicinvarchar80DATS(N'00000000')YesRI_BEGDT Allow NULL? 
70ENDDTIS-H: Kaydin geçerlik sonunvarchar80DATS(N'00000000')YesRI_ENDDT Allow NULL? 
71ERDATIS-H: Kaydin yaratildigi tarihnvarchar80DATS(N'00000000')YesRI_ERDAT Allow NULL? 
72ERUSRIS-H: Kaydi yaratan sorumlunun adinvarchar120CHAR(N' ')YesRI_ERNAM Allow NULL? 
73UPDATIS-H: Degisiklik tarihinvarchar80DATS(N'00000000')YesRI_UPDAT Allow NULL? 
74UPUSRIS-H: Degistiren sorumlunun adinvarchar120CHAR(N' ')YesRI_UPNAM Allow NULL? 
75STORNIS-H: Ters kayit göstergesichar10CHAR(N' ')YesRI_STORN Allow NULL? 
76STUSRIS-H: Iptal eden sorumlunun adinvarchar120CHAR(N' ')YesSTORN_USER Allow NULL? 
77STDATIS-H: Iptal tarihinvarchar80DATS(N'00000000')YesSTORN_DAT Allow NULL? 
78GBORTIS-H: Hastanin dogum yerinvarchar250CHAR(N' ')YesISH_GBORT Allow NULL? 
79RACEIS-H: Etnik grupnvarchar20CHAR(N' ')Yes*ISH_RACE Allow NULL? 
80RACETXTIS-H: Etnik grup metninvarchar150CHAR(N' ')YesISH_RACETX Allow NULL? 
81RESIDIS-H: Gösterge: Hasta ülke vatandasi degilchar10CHAR(N' ')YesISH_RESID Allow NULL? 
82PASSTYIS-H: Kimlik belgesinin tipinvarchar20CHAR(N' ')Yes*ISH_PASSTY Allow NULL? 
83PASSTYTXTIS-H: Kimlik belgesi tipi için metinnvarchar150CHAR(N' ')YesISH_PASSTX Allow NULL? 
84PASSNRIS-H: Kimlik belgesi no.nvarchar150CHAR(N' ')YesISH_PASSNR Allow NULL? 
NamePrimaryUniqueTypeColumns
N1PRPAT~0YesYesCLUSTEREDPATID, MANDT
N1PRPAT~1NoNoNONCLUSTEREDVNAMS, NNAMS
N1PRPAT~2NoNoNONCLUSTEREDGBNAS
N1PRPAT~3NoNoNONCLUSTEREDRVNUM
N1PRPAT~4NoNoNONCLUSTEREDPASSNR
N1PRPAT~5NoNoNONCLUSTEREDGBDAT
N1PRPAT~6NoNoNONCLUSTEREDKRZAN
N1PRPAT~7NoNoNONCLUSTEREDNOTAN
N1PRPAT~8NoNoNONCLUSTEREDSTDAT, RFPAT

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