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

26 columns | Print definition?ERP 6.0  | USER1

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1TNWCH_ATC_RELStatistikrelevante ATC-Codes9USER1Statistikrelevante ATC-Codes: Benutzerdefiniertes Feld 1nvarchar10
TOPBasic Functions
2T850KCompany correspondence data15USER1User field 1nvarchar300
TOPBasis Components
3/XFT/INV_QInvoice receipt queue: Header124USER1User Fieldnvarchar1280
4/XFT/INV_Q_SInvoice receipt queue: Header124USER1User Fieldnvarchar1280
TOPBusiness Partners
5NFEEAddnl HC-Specific Fee Recipient Data for SAP BP22USER1User Field 1nvarchar500
6NPNTPatient Master Data45USER1IS-H: User-Defined Field 1nvarchar200
TOPConstruction Equipment Management
7J_3GANZVARDisplay Variants - Link to INDX3USER1User Namenvarchar120
TOPCross-Application Components
8AAUUFKOrder master data52USER1Applicant's telephone numbernvarchar200
TOPExternal Services
9ESSRService Entry Sheet Header Data47USER1Technical Reference Field for External Entry Sheet Numbernvarchar200
TOPOverhead Cost Orders
10AUFKOrder master data52USER1Applicant's telephone numbernvarchar200
TOPPatient Accounting
11NTPKIS-H: Header Data of Service Item83USER1Customer-Specific Field 2nvarchar800
12NVBRPIS-H: Billing document item data82USER1IS-H: Customer-Specific Field 2nvarchar200
TOPPatient Management
13N1CORDERIS-H: Clinical Order46USER1IS-H: User-Defined Field 1nvarchar200
14N1VKGIS-H: Item of Clinical Order (Preregistration)61USER1IS-H: User-Defined Field 1nvarchar200
15NKAVISH: Intermediate File Creation/Borrowing/Transfer of Recrds13USER1IS-H: User-Defined Field 1nvarchar200
16NLEIIS-H: Services Performed89USER1IS-H: Customer-Specific Field 2nvarchar200
17NPATIS-H: Patient Master Data (General)110USER1IS-H: User-Defined Field 1nvarchar200
TOPPayroll
18T7SKHOZPKódy pre hromadné oznámenie ZP10USER1Nie bližšie def. oblast, príp. použitelné pre patchlevelsnvarchar40
TOPRepetitive Manufacturing
19RMIOInput Structure of Repetitive Manufacturing Confirmation105USER1User Field for HR Backflush Datanvarchar120
20RMRPHR Data of Repetitive Manufacturing Backflush13USER1User Field for HR Backflush Datanvarchar120
TOPSAP Healthcare - Industry-Specific Components for Hospitals
21NWCH90AAdditional Table for Fee-Based Services in NWCH906USER1User Field 1nvarchar500
22NWCHLS_RNLSRIS-H CH: ALIS-Fehlerhandlung - Leistungen (RNLSR)71USER1IS-H: campo specifico cliente 2nvarchar200
23TNWCH94Fee Recipient Data22USER1User Field 1nvarchar500
24TNWCH_EHC_BOAKontext für die Massendeckungsabfrage4USER1Massendeckungsabfrage: Benutzerdefiniertes Feld 1nvarchar10
TOPSession Manager
25SSM_STATSession Manager status table15USER1User who generated the menunvarchar120
TOPSimulation
26VSAUFK_CNVersion: Order master data53USER1Applicant's telephone numbernvarchar200