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

63 columns | Print definition?ERP 6.0  | TOYEAR

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/ATL/UILBILNRLocalization SD - Billing documents NR intervals4TOYEARTo fiscal yearnvarchar40
2CNVC_SCNR_NRIVNumber range intervals7TOYEARTo fiscal yearnvarchar40
3CNVTDMS_05_NRIVTDMS Table for Number Range Intervals6TOYEARTo fiscal yearnvarchar40
4CNV_20000_NRIVBack up table for NRIV6TOYEARTo fiscal yearnvarchar40
5CNV_20000_NRIV_MCustomizing table to store NRIV object mapping6TOYEARTo fiscal yearnvarchar40
6CNV_20201_NRIV_NTarget number ranges6TOYEARTo fiscal yearnvarchar40
7CNV_20201_NRIV_OSource number ranges6TOYEARTo fiscal yearnvarchar40
8CNV_20201_RNMBConversion rules for number ranges7TOYEARTo fiscal yearnvarchar40
9CNV_NCE_DOC_MAPNCE: Mapping data for individual doc numbers6TOYEARSource: To fiscal yearnvarchar40
10CNV_NCE_DOC_SIMNCE: Mapping data for individual doc numbers7TOYEARSource: To fiscal yearnvarchar40
11CNV_NCE_JOBSNCE: Job states and logs7TOYEARFiscal Yearnvarchar40
12CNV_NCE_NRIV_BAKNumber Conversion Engine: NRIV before modifications / Backup7TOYEARTo fiscal yearnvarchar40
13CNV_NCE_NRIV_EXTNCE: Number intervals on basis of database analysis12TOYEARTo fiscal yearnvarchar40
14CNV_NCE_NRIV_MAPNCE: Mapping data for number ranges6TOYEARSource: To fiscal yearnvarchar40
15CNV_NCE_NRIV_SIMNumber Conversion Engine: NRIV entries for simulation7TOYEARTo fiscal yearnvarchar40
16CNV_NCE_NRIV_TMPNCE: Number intervals on basis of NRIV10TOYEARTo fiscal yearnvarchar40
17CNV_NCE_NRIV_TRXNumber conversion engine: Tracking data6TOYEARSource: To fiscal yearnvarchar40
18CNV_NCE_NRIV_WRKNumber Conversion Engine: NRIV copy for modifications8TOYEARTo fiscal yearnvarchar40
19CNV_NCE_SOBJ_DUPDuplicate numbers7TOYEARTo fiscal yearnvarchar40
20DFKKODNCHRODN: Chronological numbering last assigned number6TOYEARTo fiscal yearnvarchar40
21DFKK_PT_NUM_RULERegistration Table for Numbering/Reporting Rule in Portugal5TOYEARTo fiscal yearnvarchar40
22IUUC_NRIVLO_SNAPLocal NRIV for multiprocessor machines5TOYEARTo fiscal yearnvarchar40
23IUUC_NRIVSH_SNAPLocal NRIV for multiprocessor machines5TOYEARTo fiscal yearnvarchar40
24IUUC_NRIV_SNAPIUUC Number Range Intervals4TOYEARTo fiscal yearnvarchar40
25NRIV_DOCUNon-Assigned Internal Numbers in Parallel Buffering6TOYEARTo fiscal yearnvarchar40
26TFK_ODNNR_DETAssign Number Range Numbers to Document Classes11TOYEARTo fiscal yearnvarchar40
27TRWCAFI/CO Interface: Active Components3TOYEARTo-yearnvarchar40
TOPBasis Technology R3
28/ISDFPS/BAPINRIVTransfer Data for NRIV Update6TOYEARTo Yearnvarchar40
29/ISDFPS/NRIVCentral Table for Cross-System Number Ranges6TOYEARTo Yearnvarchar40
30/ISDFPS/NRIV_UPDCross-System NR Settings - Update Using Local System6TOYEARTo Yearnvarchar40
TOPBatches
31BNMATAssignment of Material No.-Number Range for Batch No. Assgmt6TOYEARTo fiscal yearnvarchar40
TOPBusiness Consolidation
32UCM6100Organizational Change: Top Nodes9TOYEARFIN Master Data: Ending Yearnvarchar40
33UCS0110Tasks: Preceding Tasks9TOYEARFIN Master Data: Ending Yearnvarchar40
TOPContract Accounts Receivable and Payable
34DFKKEXTCONControl Table: Official Number Parallel Processing6TOYEARTo fiscal yearnvarchar40
35DFKKEXTDOCOfficial Document Number with Attributes16TOYEARTo fiscal yearnvarchar40
36DFKKEXTDOC2Encryption of Official Document Numbers10TOYEARTo fiscal yearnvarchar40
37DFKKEXTTMPTemporary Entries for Official Document Number8TOYEARTo fiscal yearnvarchar40
38DFKK_PT_NUMSTDigital Signature PT: Document Number From5TOYEARTo fiscal yearnvarchar40
39DFKK_PT_ODNGAPSequential Fractures of Official Document Numbers5TOYEARTo fiscal yearnvarchar40
TOPData Basis
40RRBANRIVClient-independent number range intervals4TOYEARTo fiscal yearnvarchar40
TOPGeneral Ledger Accounting
41FAGL_ORG_INFOGeneral Ledger: Configuration Information17TOYEARFiscal Year Until which a General Ledger Is Activatednvarchar40
42T882GCompany code - ledger assignment13TOYEARFiscal Year Until which a General Ledger Is Activatednvarchar40
TOPInvoicing
43DBEOSBIS-U On-Site Billing30TOYEARTo fiscal yearnvarchar40
TOPJoint Venture und Production Sharing Accounting
44T8JZJV Global Company Parameters15TOYEARJV year for last period allowednvarchar40
45T8PSA_OPEN_PEROpen Periods5TOYEARPSA Effective Yearnvarchar40
46T8PSC_PERIODPSC open production periods5TOYEARPSC Effective Yearnvarchar40
TOPLocalization
47J_1BNFENUMCHECKNF-e Number Range - Last checked Number8TOYEARTo fiscal yearnvarchar40
48J_1HWTCTNCO4Withholding tax certificate numbering concept 47TOYEARCheckboxnvarchar10
49SIPT_BKPFPortugal: Digital Signature for Accounting Documents6TOYEARTo fiscal yearnvarchar40
50SIPT_GAPS_BKPFDigitial Signature Portugal: Gaps for FI Documents4TOYEARTo fiscal yearnvarchar40
51SIPT_GAPS_RBKPDigitial Signature Portugal: Gaps for MM Documents4TOYEARTo fiscal yearnvarchar40
52SIPT_NUMBR_FISignature PT: Relevancy of FI Number range4TOYEARTo fiscal yearnvarchar40
53SIPT_NUMBR_MMSignature PT: Relevancy of Self Billing Number range5TOYEARTo fiscal yearnvarchar40
54SIPT_NUMST_FISignature PT: Starting point for FI documents4TOYEARTo fiscal yearnvarchar40
55SIPT_NUMST_MMSignature PT: Starting point for Self Billing4TOYEARTo fiscal yearnvarchar40
56VIXCPTSIPTDigital Signature for Invoices7TOYEARTo fiscal yearnvarchar40
TOPMobile Applications
57/ISDFPS/ME_NRBuffer Table for Mobile Numbers from Number Ranges5TOYEARTo fiscal yearnvarchar40
TOPNumber Range Management
58NRIVNumber Range Intervals5TOYEARTo fiscal yearnvarchar40
59NRIVSHADOWLocal NRIV for multiprocessor machines6TOYEARTo fiscal yearnvarchar40
60NRIV_LOKALLocal NRIV for multiprocessor machines6TOYEARTo fiscal yearnvarchar40
61NRIV_RESTEInternal numbers not assigned in conn. with NRIV split6TOYEARTo fiscal yearnvarchar40
TOPProduction and Revenue Accounting
62OIUCM_SN_NR_CONFNumber Range Interval Assignments To PRA Tables5TOYEARTo fiscal yearnvarchar40
TOPValue Adjustment
63/IBS/CRB_BA_NRKRRBD: Number Range Assignment7TOYEARTo fiscal yearnvarchar40