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

30 columns | Print definition?ERP 6.0  | CGROUP

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/SDF/DRM_CONFData Readyness Monitoring - Configuration2CGROUPCharacter String - 32 User-Defined Charactersnvarchar320
2/SDF/DRM_RESULTSData Readyness Monitoring - Results6CGROUPCharacter String - 32 User-Defined Charactersnvarchar320
3CMM_MTM_CALCAssign Condition Types to Groups5CGROUPMtM Condition Groupnvarchar10
4CMM_MTM_CGROUPTMtM Condition Group2CGROUPMtM Condition Groupnvarchar10
5CMM_MTM_CGROUPTTMtM Condition Group3CGROUPMtM Condition Groupnvarchar10
6CMM_MTM_POMtM per Purchase Order31CGROUPMtM Condition Groupnvarchar10
7CMM_MTM_SOMtM per Sales Order28CGROUPMtM Condition Groupnvarchar10
8GSWCGRP_SERVER_AComponent --- Group3CGROUPGTABKEY Groupnvarchar200
9GTABKEYEXC20Exception List: Global Key Check6CGROUPGTABKEY Groupnvarchar200
10GTABKEYEXC_ARCHException List: Global Key Check6CGROUPGTABKEY Groupnvarchar200
11GTABKEY_ARCHIVEGlobal Key Entries from Requests/Tasks2CGROUPGTABKEY Groupnvarchar200
12GTABKEY_EXTMapping of Group to Virtual Group to Check for Conflicts1CGROUPGTABKEY Groupnvarchar200
13WB2B_CMM_MTM_TCMtM per Trading Contract34CGROUPMtM Condition Groupnvarchar10
14ZCMM_MTM_01MtM Persistency per Transaction26CGROUPMtM Condition Groupnvarchar10
15ZCMM_MTM_TCMtM per TC33CGROUPMtM Condition Groupnvarchar10
TOPPhilippines
16T7PHRSReceipt number and Issue dates-Company Grouping.3CGROUPTax groupingnvarchar40
TOPSequencing
17TSPG2Order characteristic3CGROUPOrder characteristic groupnvarchar20
TOPTariffs, Duties and Permits
18OIH_J1B_CPRBrazil: Posting exceptions for ICMS complement7CGROUPCustomer tax groupnvarchar40
19OIH_J1B_FACBrazil: Factor for calculation of PIS / COFINS ST6CGROUPCustomer tax groupnvarchar40
20OIH_J1B_PICBrazil: Printing exceptions for ICMS6CGROUPCustomer tax groupnvarchar40
21OIH_J1B_ZFDBrazil tax: Sub. Trib. Discount for Zona Franca de Manaus8CGROUPCustomer tax groupnvarchar40
22OIH_J_1BTXCI2Tax calc.: Complement of ICMS rules INSIDE CALCULATION8CGROUPCustomer tax groupnvarchar40
23OIH_J_1BTXIX1Tax calc.: ISS rules for sales and purchasing exeptions9CGROUPCustomer tax groupnvarchar40
TOPTransport Organizer
24GGRPGroup for Global Table Keys1CGROUPGTABKEY Groupnvarchar200
25GSWCGRPComponent --- Group3CGROUPGTABKEY Groupnvarchar200
26GSWCGRP_SERVERComponent --- Group3CGROUPGTABKEY Groupnvarchar200
27GTABKEYGlobal Key Entries from Requests/Tasks2CGROUPGTABKEY Groupnvarchar200
28GTABKEY_LOCALGlobal Key Entries from Requests/Tasks2CGROUPGTABKEY Groupnvarchar200
29GTABKEY_TABEXCLTables Excluded from Conflict Check2CGROUPGTABKEY Groupnvarchar200
30GUPDLAYOUTList of Table Layouts that Need to Be Updated1CGROUPGTABKEY Groupnvarchar200