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
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

30 columns | Print definition?ERP 6.0  | SUFFIX

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/CFMFND/DOBJDESCCustomizingtabelle dyn. Objekte - Darstellungsmerkm. - Tab5SUFFIXCAFM Foundation dynamische Objekte - Suffixnvarchar80
2DD02BNDDD: List of Nodes for a Structured Object7SUFFIXDD: Suffix for Field Namesnvarchar100
3GRFNUIBRANYSTYPEBusiness Rule Analysis Type Link11SUFFIXSuffix structure for outputnvarchar300
4OIUX8_NM_JC_MSTTax 2.0 - NM - Jicarilla Credit Master3SUFFIXTax 2.0 - New Mexico Suffix for School Dist Codenvarchar50
5OIUX8_NM_OOSHSTTax 2.0 - NM - Out-Of-Statute Transaction History14SUFFIXTax 2.0 - New Mexico Suffix for School Dist Codenvarchar50
6OIUX8_NM_OOSTXNTax 2.0 - NM - Out-Of-Statute Transactions14SUFFIXTax 2.0 - New Mexico Suffix for School Dist Codenvarchar50
7OIUX8_NM_PRDTTax 2.0 - NM - PRA Detail Transactions15SUFFIXTax 2.0 - New Mexico Suffix for School Dist Codenvarchar50
8OIUX8_NM_RPDTTax 2.0 - NM - Report Detail7SUFFIXTax 2.0 - New Mexico Suffix for School Dist Codenvarchar50
9OIUX8_NM_RPDT_HTax 2.0 - NM Tax Report Detail - State History7SUFFIXTax 2.0 - New Mexico Suffix for School Dist Codenvarchar50
10OIUX8_NM_SUFFDECTax 2.0 - New Mexico Suffix Decimal9SUFFIXTax 2.0 - New Mexico Suffix for School Dist Codenvarchar50
11OIUX8_NM_SUFFXRFTax 2.0 - New Mexico Suffix and tax rate x-ref2SUFFIXTax 2.0 - New Mexico Suffix for School Dist Codenvarchar50
12OIUX8_NM_TAXDTLTax 2.0 - New Mexico Tax Details7SUFFIXTax 2.0 - New Mexico Suffix for School Dist Codenvarchar50
13OIUX8_NM_TAXHSTTax 2.0 - NM - Tax Transaction History14SUFFIXTax 2.0 - New Mexico Suffix for School Dist Codenvarchar50
14OIUX8_NM_TAXSTGTax 2.0 - NM - Tax Transactions (Staging)14SUFFIXTax 2.0 - New Mexico Suffix for School Dist Codenvarchar50
15OIUX8_NM_TAXTXNTax 2.0 - NM - Tax Transactions14SUFFIXTax 2.0 - New Mexico Suffix for School Dist Codenvarchar50
TOPApplication Framework
16MDG_GN_TGOBJCatalog of Generated Objects5SUFFIXSuffix for Generated Objectsnvarchar50
TOPAuto-ID Infrastructure
17/AIN/TGIAI_NRRANGIAI Number Range11SUFFIXSerial number suffixnvarchar240
TOPCommunication Services Mail, Fax, SMS, Telephony
18SXSERVSAPconnect: Node capabilities11SUFFIXSAPconnect: Domain of Internet Mail Addressnvarchar2300
TOPFinancials Basis
19FINB_GN_TGOBJCatalog of Generated Objects5SUFFIXSuffix for Generated Objectsnvarchar50
TOPFlexible Real Estate Management
20TIVHOHBKID1Mandatsverwaltung, Hausbanken: Vorlagekonten5SUFFIXMandatsverwaltung, Hausbankkonten: Suffix der Kontoartnvarchar30
TOPGlobal Trade Services
21/SAPSLL/PRECONDGTS: Preference: Additional Conditions (Data Prov. Upload)5SUFFIXSuffix for Chaper or Heading Rulesnvarchar20
22/SAPSLL/PREGPMAPMapping: Item-Specific Conditions for Rule Groups6SUFFIXSuffix for Chaper or Heading Rulesnvarchar20
23/SAPSLL/PSVCONDGTS: Preference: Additional Conditions (Manual Entry)5SUFFIXSuffix for Chaper or Heading Rulesnvarchar20
TOPGRC Risk Management
24GRRMCACTWRAPPERCactivity Wrapper ID3SUFFIXSuffix IDnvarchar10
TOPLegacy System Migration Workbench
25/SAPDMC/LSORULRule Category13SUFFIXSuffixnvarchar300
TOPLogistics - General
26MGWPICTURECustomizing Image Data6SUFFIXFile Type of Image Filenvarchar30
TOPMaster Data
27TJS45IS-M: Street Suffixes (Mainly USA)2SUFFIXIS-M: Suffix in Street Namenvarchar200
TOPMigration
28TEMSERKEYIS-U Mig: Determine Container Serial Number via UNAME5SUFFIXShort Description for Migration Objectnvarchar30
TOPRecycling Administration Core Functions
29J_7LC34REA DME: Field Mapping and Rule Set12SUFFIXSuffixnvarchar300
TOPTransport Organizer
30OBJSUBRESNReserved System Suffixes for Sub-Object Names2SUFFIXSub-object: System suffix for sub-objectsnvarchar20