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

18 columns | Print definition?ERP 6.0  | NID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPBank Components
1JBKLOBJ1Segment Table for Financial Transactions, CL Part8NIDIdentifier for Netting Groupsnvarchar100
TOPDefault Risk and Limit System
2KLNT01Definition of Netting Group2NIDIdentifier for Netting Groupsnvarchar100
3KLNT01TText Table for KLNT012NIDIdentifier for Netting Groupsnvarchar100
4KLSI02Collateral Agreements3NIDIdentifier for Netting Groupsnvarchar100
5KLSI02_BAKBackup for Euro Changeover for Collateral Agreements3NIDIdentifier for Netting Groupsnvarchar100
TOPMaster Recipe
6CPC_CMX_DB_LOGXSteps: Change Log4NIDXSteps: Unique ID of a Nodenvarchar220
7CPC_CMX_DB_R_LOGXSteps (Routing): Change Log4NIDXSteps: Unique ID of a Nodenvarchar220
TOPProcess Management
8CMX_XSR_DB_CLOGXSteps: Change Log4NIDXSteps: Unique ID of a Nodenvarchar220
9CMX_XS_DB_HISTXSteps: Historical Objects (Change Status)2NIDXSteps: Unique ID of a Nodenvarchar220
10CMX_XS_DB_HOBJXSteps: Historical Objects (Status Table)3NIDXSteps: Unique ID of a Nodenvarchar220
11CMX_XS_DB_NOBJXSteps: Non-Historic Objects (Table of States)2NIDXSteps: Unique ID of a Nodenvarchar220
12CMX_XS_DB_NRELXSteps: Links to Non-Historic Objects (Relationships)2NIDXSteps: Unique ID of a Nodenvarchar220
13CMX_XS_DB_PREDXSteps: Predecessor4NIDXSteps: Unique ID of a Nodenvarchar220
14CMX_XS_DB_PREXXSteps: Predecessor before the Generation4NIDXSteps: Unique ID of a Nodenvarchar220
15CMX_XS_DB_PSLXSteps: Parameter, LIVE Data in DB Format SMALL9NIDXSteps: Unique ID of a Nodenvarchar220
16CMX_XS_DB_TREEXSteps: Tree Characteristics2NIDXSteps: Unique ID of a Nodenvarchar220
17POC_DB_C_SYTABLEDomain Model: Variable Collection (Symbol Table)11NIDXSteps: Unique ID of a Nodenvarchar220
TOPProduct Data Management
18CONV_MATRICESMatrixes that must be checked into BOMs5NIDInstance Counternvarchar40