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

36 columns | Print definition?ERP 6.0  | EXTERNIND

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1CNVC_SCNR_NRIVNumber range intervals11EXTERNINDInternal (' ') or external ('X') number range flagnvarchar10
2CNVTDMSBW_NRDIMNumber range table for DIMID9EXTERNINDGeneral Flagnvarchar10
3CNVTDMSBW_NRSIDNumber range Table for SID8EXTERNINDGeneral Flagnvarchar10
4CNVTDMS_05_NRIVTDMS Table for Number Range Intervals10EXTERNINDInternal (' ') or external ('X') number range flagnvarchar10
5CNVTDMS_11_NRANGTDMS Number Ranges7EXTERNINDInternal (' ') or external ('X') number range flagnvarchar10
6CNV_20000_NRIVBack up table for NRIV11EXTERNINDInternal (' ') or external ('X') number range flagnvarchar10
7CNV_20201_NRIV_NTarget number ranges10EXTERNINDInternal (' ') or external ('X') number range flagnvarchar10
8CNV_20201_NRIV_OSource number ranges10EXTERNINDInternal (' ') or external ('X') number range flagnvarchar10
9CNV_NCE_NRIV_BAKNumber Conversion Engine: NRIV before modifications / Backup11EXTERNINDInternal (' ') or external ('X') number range flagnvarchar10
10CNV_NCE_NRIV_SIMNumber Conversion Engine: NRIV entries for simulation14EXTERNINDInternal (' ') or external ('X') number range flagnvarchar10
11CNV_NCE_NRIV_TMPNCE: Number intervals on basis of NRIV15EXTERNINDInternal (' ') or external ('X') number range flagnvarchar10
12CNV_NCE_NRIV_WRKNumber Conversion Engine: NRIV copy for modifications12EXTERNINDInternal (' ') or external ('X') number range flagnvarchar10
13IUUC_NRIVLO_SNAPLocal NRIV for multiprocessor machines12EXTERNINDInternal (' ') or external ('X') number range flagnvarchar10
14IUUC_NRIVSH_SNAPLocal NRIV for multiprocessor machines14EXTERNINDInternal (' ') or external ('X') number range flagnvarchar10
15IUUC_NRIV_SNAPIUUC Number Range Intervals11EXTERNINDInternal (' ') or external ('X') number range flagnvarchar10
16NRIV_DOCUNon-Assigned Internal Numbers in Parallel Buffering14EXTERNINDInternal (' ') or external ('X') number range flagnvarchar10
TOPBasic Functions
17ANKLGeneration table for generating asset classes from accounts18EXTERNINDInternal (' ') or external ('X') number range flagnvarchar10
TOPBasis Technology R3
18/ISDFPS/BAPINRIVTransfer Data for NRIV Update7EXTERNINDExternal Number Range Intervalnvarchar10
19/ISDFPS/NRIVCentral Table for Cross-System Number Ranges7EXTERNINDExternal Number Range Intervalnvarchar10
20/ISDFPS/NRIV_UPDCross-System NR Settings - Update Using Local System7EXTERNINDExternal Number Range Intervalnvarchar10
TOPClinical System
21N1KRSIS-H*MED: Number Ranges4EXTERNINDInternal (' ') or external ('X') number range flagnvarchar10
TOPLogistics Basic Data
22WRF_MATGRP_TREETable of Hierarchy Levels4EXTERNINDExternal Number Assignmentnvarchar10
TOPMigration
23VIGW_NUMNummernvergabe auf Objektebene4EXTERNINDTunnus sisäiselle (" ") tai ulkoiselle ("X") numerosarjallenvarchar10
TOPNumber Range Management
24NRIVNumber Range Intervals9EXTERNINDInternal (' ') or external ('X') number range flagnvarchar10
25NRIVSHADOWLocal NRIV for multiprocessor machines12EXTERNINDInternal (' ') or external ('X') number range flagnvarchar10
26NRIV_LOKALLocal NRIV for multiprocessor machines10EXTERNINDInternal (' ') or external ('X') number range flagnvarchar10
27NRIV_RESTEInternal numbers not assigned in conn. with NRIV split12EXTERNINDInternal (' ') or external ('X') number range flagnvarchar10
TOPProduction and Revenue Accounting
28OIUCM_SN_NR_CONFNumber Range Interval Assignments To PRA Tables3EXTERNINDInternal (' ') or external ('X') number range flagnvarchar10
29OIUCM_SN_NR_TText Descriptions for OIU_CM_SN_NR tables3EXTERNINDInternal (' ') or external ('X') number range flagnvarchar10
30OIU_CM_SN_NRNumber ranges by table names2EXTERNINDInternal (' ') or external ('X') number range flagnvarchar10
31OIU_PR_DN_GRPPRA: DN Group Codes4EXTERNINDInternal (' ') or external ('X') number range flagnvarchar10
32OIU_PR_FL_GRPPRA: Field Group Codes4EXTERNINDInternal (' ') or external ('X') number range flagnvarchar10
33OIU_PR_MP_GRPPRA MP Group Codes4EXTERNINDInternal (' ') or external ('X') number range flagnvarchar10
34OIU_PR_PF_GRPPRA: Platform Group Codes4EXTERNINDInternal (' ') or external ('X') number range flagnvarchar10
35OIU_PR_RS_GRPPRA: Reservoir Group Codes4EXTERNINDInternal (' ') or external ('X') number range flagnvarchar10
36OIU_PR_WL_GRPPRA: Well Group Codes4EXTERNINDInternal (' ') or external ('X') number range flagnvarchar10