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

32 columns | Print definition?ERP 6.0  | NNAME

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPClinical System
1N1PRPATIS-H*MED: PATREG: Patientenstammdatentabelle6NNAMEIS-H: Hastanin soyadinvarchar300
2N1PRPIXIS-H*MED: PATREG: Tabelle für phonetische Suche4NNAMEIS-H: Hastanin soyadinvarchar300
3N1PRTMPPATIS-H*MED: PATREG: Temporäre Patientenstammdatentabelle7NNAMEIS-H: Hastanin soyadinvarchar300
4N1PRTMPPATLOCIS-H*MED: PATREG: NPAT umgeschlüsselt auf N1PRPAT lokal7NNAMEIS-H: Hastanin soyadinvarchar300
5N2DSDEVICE_ARCHISHMED: Archive Transfer Data from Interfaces8NNAMEPatient Last Namenvarchar300
6N2DSDEVICE_DATAISHMED: Transfer Data from Interface8NNAMEPatient Last Namenvarchar300
TOPCompany Pension Scheme Germany
7P01RBM_IM01Notification Data IM01 Pension Receipt Notif. Answer Tax ID7NNAMEFamily Namenvarchar450
8P01RBM_MI01Notification Data MI01 Pension Receipt Notif. Query Tax ID19NNAMEFamily Namenvarchar450
9P01RBM_MI01RConfirmation MI01 Pension Receipt Notification Query Tax ID19NNAMEFamily Namenvarchar450
10P01RBM_MZ01Reporting Data MZ01 Pension Receipt Notification24NNAMEFamily Namenvarchar450
11P01RBM_MZ01RConfirmation MZ01 Pension Receipt Notification24NNAMEFamily Namenvarchar450
12PA0747HR Master Record for Infotype 074725NNAMELast Name of Childnvarchar350
TOPContract Accounts Receivable and Payable
13DFKKCMP2PManually Issued Checks Lot: Two Party Checks Data5NNAMEName field 1 (name1/last name)nvarchar400
14DFKKCR2PCheck Repository: Additional Payees10NNAMEName field 1 (name1/last name)nvarchar400
15DFKKCRDEL2PCR: Deleted Payment Medium / Payee Data13NNAMEName field 1 (name1/last name)nvarchar400
16DFK_NORM_BPNormalized Data for Duplicate Search for Business Partner3NNAMENormalized Name for Duplicate Searchnvarchar800
TOPPatient Accounting
17NEHC_E111IS-H: European Health Insurance Card6NNAMEIS-H: EHIC - Patient's Last Namenvarchar400
TOPPatient Management
18NPAPIS-H: Provisional Patient Master Data3NNAMEPatient Last Namenvarchar300
19NPAPIXIS-H: Preregistered Patient Name Index4NNAMEPatient Last Namenvarchar300
20NPATIS-H: Patient Master Data (General)5NNAMEPatient Last Namenvarchar300
21NPIXIS-H: Patient name index4NNAMEPatient Last Namenvarchar300
22NTMNIS-H: Patient-Specific Appointments (Header Table for NAPP)15NNAMEPatient Last Namenvarchar300
23NWANIS-H: Bad Debt Parties4NNAMELast Name of Bad Debt Partynvarchar300
TOPProduction Campaign
24PCMO4Production campaign pegged reqmt resource network10NNAMEResource network namenvarchar100
TOPPublic Sector
25P01ZFA_NN_KIDSZfA: Notifications Not Assigned - Child Data11NNAMELast Name of Child Allowance Beneficiarynvarchar400
TOPSAP Ambulatory Care Management
26NREDOMAIS-H: Table Renewable Documents - Header Data29NNAMEPatient Last Namenvarchar300
TOPSAP Healthcare - Industry-Specific Components for Hospitals
27NEHICIS-H: European Health Insurance Card5NNAMEIS-H: EHIC - Patient's Last Namenvarchar400
28NPNTCASIS-H: Patient Master Data at Case Level (CV IT)4NNAMEPatient Last Namenvarchar300
29NPSPATIS-H: Pseudonymized Patient Master Data (General)4NNAMEPatient Last Namenvarchar300
30NPSPIXIS-H: Index of Pseudonymized Patient Names4NNAMEPatient Last Namenvarchar300
31NVVNIS-H: Guarantors10NNAMELast Name of Guarantornvarchar350
TOPWithout Description
32RSROLEHIERARCHYRole hierarchy2NNAMEName of the hierarchy nodenvarchar320