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

29 columns | Print definition?ERP 6.0  | SEPARATOR

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/AIF/T_FINFInterface definition8SEPARATORSeparatornvarchar10
2/AIF/T_LFA_CONFLean File Adapter Configuration9SEPARATORField Separatornvarchar10
3/CCEE/FISC_BSFiscalization Croatia: Business Space Master Data19SEPARATORSeparator of Invoice Numbernvarchar10
4RSCRMREPTABRSCRM: Report Table Catalog10SEPARATORSeparator for File Exportnvarchar10
5ZSYSTEM_RELINFORelease Info per System Type5SEPARATORCheckboxnvarchar10
TOPABAP Authorization and Role Management
6WIZ_MODULFunction Modules for the Wizard Tool9SEPARATORCustomized ('C') or standard menu ('S') flagnvarchar10
TOPAuto-ID Infrastructure
7/AIN/TID_URNURN Format of IDs7SEPARATORURN Format Separatornvarchar10
TOPBusiness Consolidation
8UCF7100Upload: Methods6SEPARATORColumn Separatornvarchar10
TOPCase Management
9SCMGFUNCPROFFCase: Available Profile Functions5SEPARATORSeparator After Pushbuttonnvarchar10
TOPCentral Part of Product Master
10COMC_ALTID_TYPEControl Data for Alternative Product IDs15SEPARATORSeparators for Concatenated Displaynvarchar10
TOPClassification System New
11CME_ST_FORMATCME Data Type: Format Details20SEPARATORSet Thousand Separatornvarchar10
12CME_ST_FORMAT1CME-Datentyp: Formatangaben20SEPARATORTausendertrenner setzennvarchar10
13CME_ST_FORMATHCME Data Type: Format Details18SEPARATORSet Thousand Separatornvarchar10
TOPCustomer Master
14TCONV_ADRConversion of Old Address Fields to CAM Address Fields10SEPARATORSeperator to be used during concatenation (* = none)nvarchar10
TOPData Basis
15RSBFILEOpen Hub Destinations: Files5SEPARATORSeparator for csv filesnvarchar10
TOPGeneric Project Planning
16CGPL_CODING_SECTNumber Formatting Sections5SEPARATORNumber Formatting - Separatornvarchar10
TOPGraphic
17TGSUTSAP Structural Graphics: Check Table for Separators2SEPARATORSeparatornvarchar20
TOPI18N Unicode
18UM4SEPWord separators1SEPARATORvarbinary10
19UMGSEPWord separators1SEPARATORvarbinary10
TOPInformation Consistency
20SIC_NORM_TOKEN0RRules for Simple Tokenization (CL_SIC_NORM_SIMPLE_TOKENIZE)4SEPARATORSeparator Between Two Tokensnvarchar2550
TOPLocalization
21IDCN_ALGACCHIERAccount Level Hierarchy: Account Level Hierarchy (Top Level)6SEPARATORAccount Hierarchy Attribute: Separator of Levelsnvarchar10
22J_3R_CAUTHOutput control for Goods Withholding Authorization6SEPARATORSeparatornvarchar10
TOPPeople Centric UI Framework Customizing
23CRMC_SEPARATORSearch Separator2SEPARATORSeparator for Multivalue Searchnvarchar10
TOPPersonal Object Worklist
24POWL_EASY_ACTAction definition for Easy-POWL Feeder8SEPARATORInsert Separator after Buttonnvarchar10
TOPPosition Budgeting and Control
25T77HRFPMLGMEX01Define Message Extractor9SEPARATORSeparator for Splitting Message Textsnvarchar10
TOPProduct Structure Browser
26TCPDM01Function Enhancement in the Browser Toolbar5SEPARATORSeparator for Functions in the Toolbarnvarchar10
TOPPublic Sector Contract Accounts Receivable and Payable
27TFMCA_PT_LD_FMTFormat of Customizing Legal Description4SEPARATORSeparator Character(s) for Components of Legal Descriptionnvarchar30
TOPStructures Workbench
28/ISDFPS/CFDPSA08Standard Reporting Interface - Structure Area Workbench5SEPARATORSeparator for Context Menu Distributionnvarchar10
TOPWeb Screen Tools - ABAP
29WDY_APP_PROP_DEFWeb Dynpro: Application Property Definition10SEPARATORCharacter Field Length 1nvarchar10