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

29 columns | Print definition?ERP 6.0  | NRLEVEL

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1CNVC_SCNR_NRIVNumber range intervals10NRLEVELNumber range statusnvarchar200
2CNVTDMSBW_NRDIMNumber range table for DIMID8NRLEVELChar 20nvarchar200
3CNVTDMSBW_NRSIDNumber range Table for SID7NRLEVELChar 20nvarchar200
4CNVTDMS_05_NRIVTDMS Table for Number Range Intervals9NRLEVELNumber range statusnvarchar200
5CNVTDMS_11_NRANGTDMS Number Ranges6NRLEVELLast used Range Nonvarchar100
6CNV_20000_NRIVBack up table for NRIV10NRLEVELNumber range statusnvarchar200
7CNV_20201_NRIV_NTarget number ranges9NRLEVELNumber range statusnvarchar200
8CNV_20201_NRIV_OSource number ranges9NRLEVELNumber range statusnvarchar200
9CNV_NCE_NRIV_BAKNumber Conversion Engine: NRIV before modifications / Backup10NRLEVELNumber range statusnvarchar200
10CNV_NCE_NRIV_SIMNumber Conversion Engine: NRIV entries for simulation13NRLEVELNumber range statusnvarchar200
11CNV_NCE_NRIV_TMPNCE: Number intervals on basis of NRIV14NRLEVELNumber range statusnvarchar200
12CNV_NCE_NRIV_WRKNumber Conversion Engine: NRIV copy for modifications11NRLEVELNumber range statusnvarchar200
13IUUC_NRIVLO_SNAPLocal NRIV for multiprocessor machines11NRLEVELNumber range statusnvarchar200
14IUUC_NRIVSH_SNAPLocal NRIV for multiprocessor machines13NRLEVELNumber range statusnvarchar200
15IUUC_NRIV_SNAPIUUC Number Range Intervals10NRLEVELNumber range statusnvarchar200
16NRIV_DOCUNon-Assigned Internal Numbers in Parallel Buffering13NRLEVELNumber range statusnvarchar200
TOPBasic Functions
17T863ZSelection: Document status8NRLEVELCurrent numbernvarchar200
TOPBasis Technology R3
18/ISDFPS/BAPINRIVTransfer Data for NRIV Update13NRLEVELNumber Levelnvarchar200
19/ISDFPS/NRIVCentral Table for Cross-System Number Ranges13NRLEVELNumber Levelnvarchar200
20/ISDFPS/NRIV_UPDCross-System NR Settings - Update Using Local System13NRLEVELNumber Levelnvarchar200
TOPData Basis
21RRBANRIVClient-independent number range intervals7NRLEVELNumber range statusnvarchar200
TOPForms Processing
22FPNUMBERLEVELForm Objects: Number Range Status2NRLEVELNumber range statusnvarchar80
TOPInterfaces
23VXSITDLVSmall Parcel Carrier: Data Fields per Shipping Point7NRLEVELNumber range statusnvarchar200
TOPMaterial Master
24MGVNOSTATUSMaterial dependent status of the number range3NRLEVELMaterial Version Numbernvarchar100
TOPNumber Range Management
25NRIVNumber Range Intervals8NRLEVELNumber range statusnvarchar200
26NRIVSHADOWLocal NRIV for multiprocessor machines11NRLEVELNumber range statusnvarchar200
27NRIV_LOKALLocal NRIV for multiprocessor machines9NRLEVELNumber range statusnvarchar200
28NRIV_RESTEInternal numbers not assigned in conn. with NRIV split11NRLEVELNumber range statusnvarchar200
TOPRemaining Beverage - Obsolete Objects
29/DSD/ME_CPT_SNSTNumber Status for Each External Number Range3NRLEVELNumber Status for Each Number Number Rangenvarchar100