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
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPCH386A/P Invoice
8OVTG52Tax Definition
9OPOR386Purchase Order
10JDT1124Journal Entry - Rows

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OVPM154Outgoing Payments
5OIVL77Whse Journal
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

116 columns | Print definition?ERP 6.0  | NRRANGENR

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/CCEE/FISC_BSFiscalization Croatia: Business Space Master Data18NRRANGENRNumber range numbernvarchar20
2/CCEE/FISC_NUMBRFiscalization Croatia: Number Range Number Assignment7NRRANGENRNumber range numbernvarchar20
3CNVC_SCNR_NRIVNumber range intervals6NRRANGENRNumber range numbernvarchar20
4CNVTDMS_05_NRIVTDMS Table for Number Range Intervals5NRRANGENRNumber range numbernvarchar20
5CNV_20000_NRIVBack up table for NRIV5NRRANGENRNumber range numbernvarchar20
6CNV_20000_NRIV_MCustomizing table to store NRIV object mapping5NRRANGENRNumber range numbernvarchar20
7CNV_20201_NRIV_NTarget number ranges5NRRANGENRNumber range numbernvarchar20
8CNV_20201_NRIV_OSource number ranges5NRRANGENRNumber range numbernvarchar20
9CNV_20201_RNMBConversion rules for number ranges5NRRANGENRNumber range numbernvarchar20
10CNV_20201_TRACKLog for number range objects: Old value - new value7NRRANGENRnvarchar20
11CNV_20201_TRACKTLog for number range obj.: Old_value - New_value (test run)7NRRANGENRnvarchar20
12CNV_NCE_DOC_MAPNCE: Mapping data for individual doc numbers5NRRANGENRSource: Number range numbernvarchar20
13CNV_NCE_DOC_SIMNCE: Mapping data for individual doc numbers6NRRANGENRSource: Number range numbernvarchar20
14CNV_NCE_NRIV_BAKNumber Conversion Engine: NRIV before modifications / Backup6NRRANGENRNumber range numbernvarchar20
15CNV_NCE_NRIV_EXTNCE: Number intervals on basis of database analysis9NRRANGENRNumber range numbernvarchar20
16CNV_NCE_NRIV_MAPNCE: Mapping data for number ranges5NRRANGENRSource: Number range numbernvarchar20
17CNV_NCE_NRIV_SIMNumber Conversion Engine: NRIV entries for simulation6NRRANGENRNumber range numbernvarchar20
18CNV_NCE_NRIV_TMPNCE: Number intervals on basis of NRIV9NRRANGENRNumber range numbernvarchar20
19CNV_NCE_NRIV_TRXNumber conversion engine: Tracking data5NRRANGENRSource: Number range numbernvarchar20
20CNV_NCE_NRIV_WRKNumber Conversion Engine: NRIV copy for modifications7NRRANGENRNumber range numbernvarchar20
21CNV_NCE_SOBJ_DUPDuplicate numbers6NRRANGENRNumber range numbernvarchar20
22DFKK_PT_NUM_RULERegistration Table for Numbering/Reporting Rule in Portugal4NRRANGENRNumber range numbernvarchar20
23FUDC_VERDOCNUMR(No use)Number range assignment of verification document3NRRANGENRNumber range numbernvarchar20
24GRACNUMRANGENumber Range for Compliant User Provisioning requests3NRRANGENRNumber range numbernvarchar20
25ISM_PT_GAPS_JFRKDigital Signature Portugal: Billing Document Number Gaps2NRRANGENRNumber range numbernvarchar20
26ISM_PT_GAP_JHTFKDigital Signature Portugal: M/AMBilling Document Number Gaps2NRRANGENRNumber range numbernvarchar20
27ISM_PT_JFRKPortugal: Digital Signature for Billing Document4NRRANGENRNumber range numbernvarchar20
28ISM_PT_JHTFKPortugal: Digital Signature for M/AM Billing Document4NRRANGENRNumber range numbernvarchar20
29ISM_PT_NUMBR_AMSignature PT: Relevancy of M/AM Billing Number range2NRRANGENRNumber range numbernvarchar20
30ISM_PT_NUMBR_SDSignature PT: Relevancy of Billing Number range2NRRANGENRNumber range numbernvarchar20
31ISM_PT_NUMST_AMSignature PT: M/AM Billing Document Number From2NRRANGENRNumber range numbernvarchar20
32ISM_PT_NUMST_SDSignature PT: Billing Document Number From2NRRANGENRNumber range numbernvarchar20
33IUUC_NRIVLO_SNAPLocal NRIV for multiprocessor machines4NRRANGENRNumber range numbernvarchar20
34IUUC_NRIVSH_SNAPLocal NRIV for multiprocessor machines4NRRANGENRNumber range numbernvarchar20
35IUUC_NRIV_SNAPIUUC Number Range Intervals3NRRANGENRNumber range numbernvarchar20
36NRIV_DOCUNon-Assigned Internal Numbers in Parallel Buffering5NRRANGENRNumber range numbernvarchar20
37SEPA_NR_CUSTSEPA Mandate Reference ID: Number Range Customizing9NRRANGENRNumber range numbernvarchar20
38SIPT_GAPS_LIKPDigitial Signature Portugal: Gaps for Delivery Documents2NRRANGENRNumber range numbernvarchar20
39SIPT_GAPS_OIGSignature PT: Gaps for Delivery Documents2NRRANGENRNumber range numbernvarchar20
40SIPT_LIKPPortugal: Digital Signature for Delivery Document5NRRANGENRNumber range numbernvarchar20
41SIPT_NUMBR_OBDSignature PT: Relevancy of Delivery Number range2NRRANGENRNumber range numbernvarchar20
42SIPT_NUMBR_OIGSiganture PT : Customizing Table for Signature in IS-OIL2NRRANGENRNumber range numbernvarchar20
43SIPT_NUMST_OBDSignature PT: Delivery Document Number From2NRRANGENRNumber range numbernvarchar20
44SIPT_NUMST_OIGSignature PT: Number From in IS-OIL Process2NRRANGENRNumber range numbernvarchar20
45TNRT2Test no.ranges: with, w/o subobj.;indep.grp;1 no.range field2NRRANGENRNumber range numbernvarchar20
46TNRT2XTest no.ranges: with, w/o subobj.;indep.grp;1 no.range field2NRRANGENRNumber range numbernvarchar20
47TNRT5Test no.ranges: with, w/o subobj.;indep.grp;1 no.range field2NRRANGENRNumber range numbernvarchar20
48TNRT7Test no.range:with subobject;dep. grp;1 no.range field3NRRANGENRNumber range numbernvarchar20
TOPAccrual Engine
49TACECOMPAccrual Engine Application Component17NRRANGENRNumber Range Interval Numbernvarchar20
TOPBank Customer Accounts
50TRTP_US_PLAN_INFPlan information for a type of retirement plan4NRRANGENRNumber range numbernvarchar20
TOPBasic Functions
51ANKLGeneration table for generating asset classes from accounts15NRRANGENRNumber range numbernvarchar20
52EMMAC_BPABusiness Process Area Customizing5NRRANGENRNumber range numbernvarchar20
53EMMAC_BPCBusiness Process Code Customizing5NRRANGENRNumber range numbernvarchar20
54T863ZSelection: Document status7NRRANGENRNumber range numbernvarchar20
TOPBasis Technology R3
55/ISDFPS/BAPINRIVTransfer Data for NRIV Update5NRRANGENRNumber Range Numbernvarchar20
56/ISDFPS/GNRDefinition of Global Number Ranges4NRRANGENRNumber Range Numbernvarchar20
57/ISDFPS/NRIVCentral Table for Cross-System Number Ranges5NRRANGENRNumber Range Numbernvarchar20
58/ISDFPS/NRIV_UPDCross-System NR Settings - Update Using Local System5NRRANGENRNumber Range Numbernvarchar20
TOPBatches
59BNMATAssignment of Material No.-Number Range for Batch No. Assgmt5NRRANGENRNumber range numbernvarchar20
TOPClinical System
60N1KRSIS-H*MED: Number Ranges5NRRANGENRNumber range numbernvarchar20
TOPConstruction Equipment Management
61J_3GIENUMVInternal/External Owner/Administrator Number Assignment2NRRANGENRNumber range numbernvarchar20
62J_3GNUMKAUAssignment of Number Ranges to Order Types for CEM3NRRANGENRNumber range numbernvarchar20
TOPContract Accounts Receivable and Payable
63DFKKEXTCONControl Table: Official Number Parallel Processing5NRRANGENRNumber range numbernvarchar20
64DFKKEXTDOCOfficial Document Number with Attributes15NRRANGENRNumber range numbernvarchar20
65DFKKEXTDOC2Encryption of Official Document Numbers9NRRANGENRNumber range numbernvarchar20
66DFKKEXTTMPTemporary Entries for Official Document Number7NRRANGENRNumber range numbernvarchar20
67DFKK_PT_NUMSTDigital Signature PT: Document Number From4NRRANGENRNumber range numbernvarchar20
68DFKK_PT_ODNGAPSequential Fractures of Official Document Numbers4NRRANGENRNumber range numbernvarchar20
TOPContract Billing
69ISU_BACKLOGSDefinition of backlog sets13NRRANGENRNumber Range for Extract Generationnvarchar20
TOPCross-Application Components
70/IXOS/DC_TCLDSSFLink data source/selection field10NRRANGENRNumber range numbernvarchar20
71/IXOS/RM_TCOLDCustomizing settings for batch import in the RM10NRRANGENRNumber range numbernvarchar20
TOPCustomer Bill of Services
72/SAPBOQ/SESTYPService Entry Sheet Type12NRRANGENRNumber range numbernvarchar20
TOPData Basis
73RRBANRIVClient-independent number range intervals3NRRANGENRNumber range numbernvarchar20
TOPEngineering Change Record
74/PLMI/ECR_TYPERecord Type8NRRANGENRNumber Range Numbernvarchar20
TOPFinancial Accounting
75ACCRCUSTAccrual/Deferral Profile4NRRANGENRNumber range numbernvarchar20
TOPFinancials Basis
76ACCDOCTYPE0CDocument Type4NRRANGENRNumber range numbernvarchar20
TOPFlexible Real Estate Management
77TIVCAPROCESSProcess12NRRANGENRNumber range numbernvarchar20
TOPFunds Management
78TKBLAFunds reservation document type4NRRANGENRNumber range numbernvarchar20
TOPIncentive and Commission Management ICM
79TCACS_PRC_TYPEProcess Type4NRRANGENRNumber range numbernvarchar20
TOPIntegrated Product and Process Engineering
80CPSTRUCT_EXTRCustomizing Table for Structure Extraction10NRRANGENRNumber range numbernvarchar20
TOPInvoicing
81DBEOSBIS-U On-Site Billing29NRRANGENRNumber range numbernvarchar20
TOPJust-In-Time Processing
82CDLCNONRSupplier-specific Delivery Confirmation Number3NRRANGENRNumber range numbernvarchar20
TOPLocalization
83J_1BNFENUMCHECKNF-e Number Range - Last checked Number7NRRANGENRNumber range numbernvarchar20
84SIPT_BKPFPortugal: Digital Signature for Accounting Documents5NRRANGENRNumber range numbernvarchar20
85SIPT_GAPS_BKPFDigitial Signature Portugal: Gaps for FI Documents3NRRANGENRNumber range numbernvarchar20
86SIPT_GAPS_RBKPDigitial Signature Portugal: Gaps for MM Documents3NRRANGENRNumber range numbernvarchar20
87SIPT_GAPS_VBRKDigitial Signature Portugal: Gaps for SD Documents2NRRANGENRNumber range numbernvarchar20
88SIPT_NUMBR_FISignature PT: Relevancy of FI Number range3NRRANGENRNumber range numbernvarchar20
89SIPT_NUMBR_MMSignature PT: Relevancy of Self Billing Number range4NRRANGENRNumber range numbernvarchar20
90SIPT_NUMBR_SDSignature PT: Relevancy of Billing Number range2NRRANGENRNumber range numbernvarchar20
91SIPT_NUMST_FISignature PT: Starting point for FI documents3NRRANGENRNumber range numbernvarchar20
92SIPT_NUMST_MMSignature PT: Starting point for Self Billing3NRRANGENRNumber range numbernvarchar20
93SIPT_NUMST_SDSignature PT: Billing Document Number From2NRRANGENRNumber range numbernvarchar20
94SIPT_RBKPPortugal: Digital Signature for Self Billing Document8NRRANGENRNumber range numbernvarchar20
95SIPT_VBRKPortugal: Digital Signature for Billing Document4NRRANGENRNumber range numbernvarchar20
96TIVXCFRPOSTINGSDocument types of postings on SUs (Extraordinary expenses)6NRRANGENRNumber range numbernvarchar20
97VIXCPTSIPTDigital Signature for Invoices6NRRANGENRNumber range numbernvarchar20
TOPMobile Applications
98/ISDFPS/ME_NRBuffer Table for Mobile Numbers from Number Ranges4NRRANGENRNumber range numbernvarchar20
TOPNumber Range Management
99NRIVNumber Range Intervals4NRRANGENRNumber range numbernvarchar20
100NRIVSHADOWLocal NRIV for multiprocessor machines5NRRANGENRNumber range numbernvarchar20
101NRIV_LOKALLocal NRIV for multiprocessor machines5NRRANGENRNumber range numbernvarchar20
102NRIV_RESTEInternal numbers not assigned in conn. with NRIV split5NRRANGENRNumber range numbernvarchar20
TOPOwnership
103OIUOW_DOC_TYPEOwnership Request Document Types3NRRANGENRNumber range numbernvarchar20
TOPPayments
104TFKBOL_BOLXTBoleto: external Boleto number ranges6NRRANGENRNumber range numbernvarchar20
TOPPosition Management
105TBKKA1Position Types4NRRANGENRNumber range numbernvarchar20
TOPProduction and Revenue Accounting
106OIUCM_SN_NR_CONFNumber Range Interval Assignments To PRA Tables6NRRANGENRNumber range numbernvarchar20
TOPPurchasing
107WRFT_POHF_INBDOrder List Settings Document Types3NRRANGENRNumber range numbernvarchar20
TOPReal Estate Management
108TIVC8Definition of bank procedure for tenant5NRRANGENRNumber range for bank procedure account numbernvarchar20
TOPRemaining Beverage - Obsolete Objects
109/BEV1/REALLGRental Item: Basic Data14NRRANGENRNumber range numbernvarchar20
110/DSD/ME_CPT_SNSTNumber Status for Each External Number Range2NRRANGENRNumber range numbernvarchar20
111/DSD/ME_CPT_STNUNumber Range for Each Activity3NRRANGENRNumber range numbernvarchar20
TOPRoute Settlement
112/DSD/SL_NRZUORDDSD: Assignment of Number Range Interval3NRRANGENRNumber range numbernvarchar20
TOPSAP Healthcare - Industry-Specific Components for Hospitals
113TNLZR0IS-H NL:LAZR Einstellungen für Schnittstellebearbeitung4NRRANGENRNummerreeksnummernvarchar20
TOPTransaction Data Pool
114JBGESCHARTTransaction Type7NRRANGENRNumber range numbernvarchar20
TOPTreasury
115FLQCOMPANYLiquidity Calculation - Company Codes3NRRANGENRLiquidity Calculation: Number Range for Transfer Postingsnvarchar20
TOPValue Adjustment
116/IBS/CRB_BA_NRKRRBD: Number Range Assignment6NRRANGENRNumber range numbernvarchar20