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

102 columns | Print definition?ERP 6.0  | PROCTYPE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/IBS/CRB_PROCE_PECF Cust: Processing Type2PROCTYPERBD: Processing Typenvarchar20
2/IBS/CRB_PROCE_TECF Cust: Processing Types (Texts)3PROCTYPERBD: Processing Typenvarchar20
3/IBS/CRB_ZPROC_EECF Cust: Assignment of Processing Type to Processing Cat.5PROCTYPERBD: Processing Typenvarchar20
4/IBS/TRB_ECF_HDRBD ECF - Value Adjustment Header Data22PROCTYPERBD: Processing Typenvarchar20
5/IBS/TRB_ECH_HDRBD ECF - Value Adjustment History - Header Data23PROCTYPERBD: Processing Typenvarchar20
6/IBS/TRB_ECI_HDRBD ECF - Import Table Header Data22PROCTYPERBD: Processing Typenvarchar20
7/IBS/TRB_ECM_HDRBD ECF: Manual Contract Management - Header Data23PROCTYPERBD: Processing Typenvarchar20
8/SDF/SQLHISTSQL Monitor: Delta records for top SQL statements4PROCTYPESQL Monitor: Processing Block Typenvarchar40
9/SDF/SQLTOPSQL Monitor: Top Statements4PROCTYPESQL Monitor: Processing Block Typenvarchar40
10/SDF/ZQLMDSQL Monitor: Data3PROCTYPESQL Monitor: Processing Block Typenvarchar40
11/SDF/ZQLMISQL Monitor: Source Info3PROCTYPESQL Monitor: Processing Block Typenvarchar40
12/SDF/ZQLMLSQL Monitor: LREF8PROCTYPESQL Monitor: Processing Block Typenvarchar40
13BTP_DL_CONVPACKBTP Portfolio Item Conversion Package3PROCTYPEMBT PCL Type of MIgration Processnvarchar100
14CNVMBTSPEZRULESSpecic function modules to be called during load / copy5PROCTYPEMBT PCL Type of MIgration Processnvarchar100
15SQLMDSQL Monitor: Data3PROCTYPESQL Monitor: Processing Block Typenvarchar40
16SQLMHCDSQL Monitor: Data3PROCTYPESQL Monitor: Processing Block Typenvarchar40
17SQLMHCISQL Monitor: Source Info3PROCTYPESQL Monitor: Processing Block Typenvarchar40
18SQLMHCKSQL Monitor: KEY5PROCTYPESQL Monitor: Processing Block Typenvarchar40
19SQLMHCLSQL Monitor: LREF8PROCTYPESQL Monitor: Processing Block Typenvarchar40
20SQLMISQL Monitor: Source Info3PROCTYPESQL Monitor: Processing Block Typenvarchar40
21SQLMLSQL Monitor: LREF8PROCTYPESQL Monitor: Processing Block Typenvarchar40
22SQLMSHCDSQL Monitor: Data / Request4PROCTYPESQL Monitor: Processing Block Typenvarchar40
23SQLMSHCISQL Monitor: Source Info / Snapshot4PROCTYPESQL Monitor: Processing Block Typenvarchar40
24SQLMZISQL Monitor: Info & Key5PROCTYPESQL Monitor: Processing Block Typenvarchar40
25SWLT_SQLM_DSWLT: Display data from SQL Monitor test4PROCTYPESQL Monitor: Processing Block Typenvarchar40
26SWLT_STATIC_C_DCache for static check data5PROCTYPESQL Monitor: Processing Block Typenvarchar40
27SWLT_STATIC_DStatic findings cache4PROCTYPESQL Monitor: Processing Block Typenvarchar40
TOPCollectionsDisbursements
28ITAGCYPROCTYPETransaction Categories in Agency Collections1PROCTYPEActivity Category in Agency Collectionsnvarchar10
29ITAGCYPROCTYPETTransaction Categories in Agency Collections1PROCTYPEActivity Category in Agency Collectionsnvarchar10
TOPControl Plan
30QPCPC_OBJCustomizing Table for the Objects4PROCTYPEProcess Typenvarchar30
31QPCPC_PROCTYPECustomizing Table for Process Type4PROCTYPEProcess Typenvarchar30
32QPCPC_PROCTYPETText Table for Process Type5PROCTYPEProcess Typenvarchar30
33QPCPC_SELFIELDCustomizing Table for Selection Fields4PROCTYPEProcess Typenvarchar30
34QPCPC_SELRANGECustomizing Table for Selection Area4PROCTYPEProcess Typenvarchar30
35QPCPD_ITEMItem of Control Plan9PROCTYPEProcess Typenvarchar30
TOPCustomer Interaction Center
36EWBPROCXFront Office Process4PROCTYPEFront office process categorynvarchar20
TOPFlexible Real Estate Management
37TIVPROTPE0Buchungsvorgangsdefinition: Ereignisse1PROCTYPEBuchungsvorgangnvarchar40
38TIVPROTPHBuchungsvorgangsdefinition: Belegköpfe1PROCTYPEBuchungsvorgangnvarchar40
39TIVPROTPIBuchungsvorgangsdefinition: Belegzeilen1PROCTYPEBuchungsvorgangnvarchar40
40TIVPROTPK1Kontenfindung zum Buchungsvorgang: primär2PROCTYPEBuchungsvorgangnvarchar40
41TIVPROTPK2Kontenfindung zum Buchungsvorgang: sekundär2PROCTYPEBuchungsvorgangnvarchar40
42TIVPROTPPBuchungsvorgangsdefinition: Steuerung1PROCTYPEBuchungsvorgangnvarchar40
43TIVPROTPPTBuchungsvorgangsdefinition: Texte2PROCTYPEBuchungsvorgangnvarchar40
TOPFunctions for U.S. Federal Government
44FMCCRVENDOR_PROCPSM-FG: Administrative, civil or criminal proceedings8PROCTYPEProceeding Type Codenvarchar20
TOPIncentive and Commission Management ICM
45TCACS_PROCTYPESCommission Case: Behavior In Event of Errors3PROCTYPECommission Case: Behavior In Event of Errorsnvarchar10
TOPProcess Monitoring Infrastructure
46SSPIADMASAdministration Table for Assembler Runs2PROCTYPESPI: Process Type IDnvarchar320
47SSPIADMDATASUP2Administration Table for PMI Data Supplier2PROCTYPESPI: Process Type IDnvarchar320
48SSPIADMEVPMI: Configuration for Metrics (Events)2PROCTYPESPI: Process Type IDnvarchar320
49SSPIADMEVBDFPMI: Cutoff Counter/BDF Status for Metrics (Events)2PROCTYPESPI: Process Type IDnvarchar320
50SSPIADMEVHISTORYHistory of Metrics Configuration2PROCTYPESPI: Process Type IDnvarchar320
51SSPIADMREORGAdministration Table for Reorganizations2PROCTYPESPI: Process Type IDnvarchar320
52SSPIAUTHGROUPMAPAuthorization Groups for Process Types2PROCTYPESPI: Process Type IDnvarchar320
53SSPICSE1Event Table for PMI Metrics Based on One Step3PROCTYPESPI: Process Type IDnvarchar320
54SSPICSE2Event Table for PMI Metrics Based on Two Steps3PROCTYPESPI: Process Type IDnvarchar320
55SSPICSPRHDSPI: Assembled Process Instances3PROCTYPESPI: Process Type IDnvarchar320
56SSPICSSTPMI: Statistical Data for Assembled Process Instances4PROCTYPESPI: Process Type IDnvarchar320
57SSPICSTRPRSPI: Tracking Record / Instance of Lower-Level Process3PROCTYPESPI: Process Type IDnvarchar320
58SSPIMDSPI: Definition of Metrics2PROCTYPESPI: Process Type IDnvarchar320
59SSPIMD1SSPI: Definition of One-Step Metrics2PROCTYPESPI: Process Type IDnvarchar320
60SSPIMD2SSPI: Definition of Two-Step Metrics2PROCTYPESPI: Process Type IDnvarchar320
61SSPIMD_TSPI: Definition of Metrics3PROCTYPESPI: Process Type IDnvarchar320
62SSPIPASPI: Administration Table for Active Process2PROCTYPESPI: Process Type IDnvarchar320
63SSPIPAAPAdministration for Activating Processes2PROCTYPESPI: Process Type IDnvarchar320
64SSPIPADETProcess Details2PROCTYPESPI: Process Type IDnvarchar320
65SSPIPADSPSPI: Administration of Process-Depend. Assembler Dispatching2PROCTYPESPI: Process Type IDnvarchar320
66SSPIPDSPI: Process Definition for Business Process Tracking2PROCTYPESPI: Process Type IDnvarchar320
67SSPIPDTASPI: Attributes for Instance Text of Process Definition2PROCTYPESPI: Process Type IDnvarchar320
68SSPIPD_TSPI: Text Process Definition3PROCTYPESPI: Process Type IDnvarchar320
69SSPIPIFDSPI: Process Interface2PROCTYPESPI: Process Type IDnvarchar320
70SSPIPIFFLDSPI: Field Names of Process Interface2PROCTYPESPI: Process Type IDnvarchar320
71SSPIPSADDRProcess Step Addresses2PROCTYPESPI: Process Type IDnvarchar320
72SSPIPSDSPI: Process Step Definition2PROCTYPESPI: Process Type IDnvarchar320
73SSPIPSDESTProcess Step Destinations2PROCTYPESPI: Process Type IDnvarchar320
74SSPIPSRSPI: Process Step Relations2PROCTYPESPI: Process Type IDnvarchar320
75SSPIPSRFLDSPI: Reference Fields for Relationships2PROCTYPESPI: Process Type IDnvarchar320
76SSPIPSRTFLDSPI: Relationships at Technical Field Level2PROCTYPESPI: Process Type IDnvarchar320
77SSPIPSTSPI: Transitions Between Process Steps2PROCTYPESPI: Process Type IDnvarchar320
78SSPIPST_TSPI: Short Texts for Step Transitions3PROCTYPESPI: Process Type IDnvarchar320
79SSPIPVCSPI: Process Variant - Definition2PROCTYPESPI: Process Type IDnvarchar320
80SSPIPVDSPI: Process Variant - Definition2PROCTYPESPI: Process Type IDnvarchar320
81SSPIPVD_TSPI: Texts for Process Variants3PROCTYPESPI: Process Type IDnvarchar320
82SSPIRGLEVELPMI: Aggregration Levels for Process Reorganization3PROCTYPESPI: Process Type IDnvarchar320
83SSPIRGOVPRSPI Cumulation at Process Level2PROCTYPESPI: Process Type IDnvarchar320
84SSPIRGOVSTXSPI Cumulation at Step Level2PROCTYPESPI: Process Type IDnvarchar320
85SSPIRGPADMPMI: Administration Table for Reorganization2PROCTYPESPI: Process Type IDnvarchar320
86SSPIRGTZONEPMI: Time Zone for Cumulation for Process Type/Group3PROCTYPESPI: Process Type IDnvarchar320
87SSPISTCONFConfiguration for Performance Data Analysis2PROCTYPESPI: Process Type IDnvarchar320
88SSPITOOLDDefinition of Attribute Tools3PROCTYPESPI: Process Type IDnvarchar320
89SSPITRCLMTE2E Trace Duration2PROCTYPESPI: Process Type IDnvarchar320
90SSPIUICUSPI: UI Customizing2PROCTYPESPI: Process Type IDnvarchar320
91SSPIUICUPASPI: Process Definition for Business Process Tracking2PROCTYPESPI: Process Type IDnvarchar320
92SSPIUICUSASPI: Process Step Definition2PROCTYPESPI: Process Type IDnvarchar320
93SSPIUICUTASPI: Process Step Definition2PROCTYPESPI: Process Type IDnvarchar320
TOPRuntime WorkbenchMonitoring
94SXMSMSGPMIUsing XI Messages in PMI4PROCTYPESPI: Process Type IDnvarchar320
TOPSpain
95PA0714HR master record Infotype 071432PROCTYPEProcedure type affecting the workernvarchar10
96T5ER1Employment regulation files12PROCTYPEERE procedure typenvarchar30
TOPValue Adjustment
97/IBS/CRB_PROCA_PRBD Processing Type IAS2PROCTYPERBD: Processing Typenvarchar20
98/IBS/CRB_PROC_TRBD Processing Types (Texts)3PROCTYPERBD: Processing Typenvarchar20
99/IBS/CRB_ZPROCCAAssignment of Processing Type to Processing Category4PROCTYPERBD: Processing Typenvarchar20
100/IBS/TRB_IASGHDRBD IAS-GATE Header Data30PROCTYPERBD: Processing Typenvarchar20
101/IBS/TRB_SHEETHRBD IAS - Header Data of Valuation Sheet27PROCTYPERBD: Processing Typenvarchar20
102/IBS/TRB_SHISTHRBD IAS - History Header Data Valuation Sheet28PROCTYPERBD: Processing Typenvarchar20