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

39 columns | Print definition?ERP 6.0  | VTYPE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/BIC/B0000190000PSA for 0MM_PUR_PURCH_DATA T90CLNT090 Purchasing Data20VTYPEnvarchar30
2/BIC/B0000191000PSA for 0MM_PUR_PURCH_GROUPS T90CLNT090 Purchasing Groups15VTYPEnvarchar30
3/BIC/B0000218000PSA for 0CO_OM_OPA_1 T90CLNT090 Orders: Costs9VTYPEnvarchar30
4/BIC/B0000219000PSA for 0CO_OM_OPA_3 T90CLNT090 Orders: Total plan9VTYPEnvarchar30
5/BIC/B0000220000PSA for 0CO_OM_OPA_4 T90CLNT090 Orders: Statist. KFs10VTYPEnvarchar30
6/BIC/B0000221000PSA for 0CO_OM_OPA_2 T90CLNT090 Orders: Budget9VTYPEnvarchar30
7/BIC/B0000222000PSA for 0CO_OM_OPA_5 T90CLNT090 Orders: Selections9VTYPEnvarchar30
8/BIC/B0000223000PSA for 0CO_OM_OPA_6 T90CLNT090 Orders: ActCostDelta11VTYPEnvarchar30
9TKSF0CUA control function modules6VTYPEProcessing Typenvarchar20
10TKSP1CUA control CO-CCA master data6VTYPEProcessing Typenvarchar20
TOPAdd-Ons for Progress Analysis
11AD03OBJTVPlan data handling WBS objects, type and version3VTYPEversion typenvarchar20
12AD03PHVWBS version type2VTYPEversion typenvarchar20
13AD03PHVTversion type text3VTYPEversion typenvarchar20
TOPBalanced Scorecard
14UMB_SV100Scorecard View4VTYPEScorecard View: Typenvarchar10
15UMB_UP110Personal Views: Master Table2VTYPEView Categorynvarchar10
TOPBusiness Configuration Sets
16SCPRDATABC Set: Values8VTYPEBC Set value data typenvarchar10
17SCPRDATACBC Set: Values6VTYPEBC Set value data typenvarchar10
TOPCompensation Management
18T71E0Guidelines12VTYPECalculation Variantnvarchar10
19T71G0Compensation Matrix12VTYPECalculation Variantnvarchar10
20T71GTCalculation Variants for Compensation Matrix2VTYPECalculation Variantnvarchar10
21T71GTTText Table for Calculation Variants3VTYPECalculation Variantnvarchar10
TOPCross-Application Components
22TASUVSVOASU: Variants: transparent saved object information9VTYPEABAP: Type of variant variablenvarchar10
TOPInformation System
23BIW_CSH_CVConversion Table for Payments4VTYPEValue type for Reportingnvarchar30
TOPJoint Venture und Production Sharing Accounting
24T8J9AEquity Group - JOA level14VTYPEVenture Typenvarchar10
25T8JVJoint Venture6VTYPEVenture Typenvarchar10
TOPLease Accounting
26FILA_RE_LNKLink Between Leasing <-> Refinancing6VTYPEPartner Contract Type of Source Documentnvarchar10
27FILA_RE_TR_ITranche Item: Selection Result for Refinancing6VTYPEPartner Contract Type of Source Documentnvarchar10
TOPMaterial Master
28MGVTYPETable of version categories2VTYPEVersion Categorynvarchar100
29MGVTYPEFIELDTable of field without a version2VTYPEVersion Categorynvarchar100
30MGVTYPEFIELDWORKTable of field without a version2VTYPEVersion Categorynvarchar100
31MGVTYPEFIELD_WRKTable of field without a version2VTYPEVersion Categorynvarchar100
32MGVTYPETEXTDescription of version types3VTYPEVersion Categorynvarchar100
33MGVTYPETEXT_WRKDescription of version types3VTYPEVersion Categorynvarchar100
34MGVTYPEWORKTable of version categories2VTYPEVersion Categorynvarchar100
35MGVTYPE_WRKTable of version categories2VTYPEVersion Categorynvarchar100
36T134Material Types33VTYPEVersion Categorynvarchar100
TOPProduction and Revenue Accounting
37OIUCM_T8JVPRA Joint Venture Master Data6VTYPEVenture Typenvarchar10
TOPProject Risk Management for Contractors
38/SAPPCE/JVA_PROFProfile for JVA master data maintenance7VTYPEVenture typenvarchar10
TOPSAP Records Management
39SRMUSVALUESRM User Settings5VTYPEData Typenvarchar10