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

31 columns | Print definition?ERP 6.0  | VALUEID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1CCGLC_TRCHKEEHS: Additional Rules for Print Requests of Process Orders6VALUEIDRule Keynvarchar100
2CNVMBTSHELLPARAMShell Creation: Parameters of system copy process3VALUEIDID of the stored valuenvarchar100
3CNVTDMS_13_PARAMTDMS Database system information for shell creation3VALUEIDID of the stored valuenvarchar100
TOPECM ABAP Stack
4NWECMD_VALUEtable for persistent value objects2VALUEIDGlobally Unique Identifiervarbinary160
TOPLease Accounting
5FILA_GF_ITEMVALCObject Data: Changed Value IDs7VALUEIDValue IDnvarchar100
6FILA_GF_ITEMVALSObject Data: Value IDs and their Values/Contents6VALUEIDValue IDnvarchar100
7TFILA_GF_001CControl Table for Value IDs to Be Changed or Added4VALUEIDValue IDnvarchar100
8TFILA_GF_003Value IDs and their Determination3VALUEIDValue IDnvarchar100
9TFILA_GF_003CFAssignment of Value ID -> Payment Schedule for Calculation5VALUEIDValue IDnvarchar100
10TFILA_GF_003MFor Later Use of Value IDs for Retrieval7VALUEIDValue IDnvarchar100
11TFILA_GF_003MVAssignment Value ID <-> Processing Method6VALUEIDValue IDnvarchar100
12TFILA_GF_003RValue IDs Referenced from Method5VALUEIDValue ID with Check against Value Tablenvarchar100
13TFILA_GF_003TValue IDs4VALUEIDValue IDnvarchar100
14TFILA_GF_004Assignment Value ID -> Accrual Method9VALUEIDValue IDnvarchar100
15TFILA_GF_004BTAssignment of Value ID -> Accrual Method for Determ. Balance5VALUEIDValue IDnvarchar100
16TFILA_GF_005Specifications for One-Time Postings per Value ID8VALUEIDValue IDnvarchar100
17TFILA_GF_007Assignment Condition Type -> Value ID5VALUEIDValue IDnvarchar100
18TFILA_GF_007CValue IDs to Be Included in Payment Schedule4VALUEIDValue ID with Check against Value Tablenvarchar100
19TFILA_GF_007CFAPayment Schedule Definition4VALUEIDValue ID with Check against Value Tablenvarchar100
20TFILA_GF_009Assignment of Value IDs to Structure Field10VALUEIDValue ID with Check against Value Tablenvarchar100
21TFILA_GF_009VMapping Table for Structure Fields in Value IDs10VALUEIDValue IDnvarchar100
22TFILA_LC_003Assignmt of Value IDs to Fields of FILA_LCS_PARAM Structure5VALUEIDValue ID with Check against Value Tablenvarchar100
23TFILA_RE_VALAssign Refinancing Category and Value Identifier4VALUEIDValue ID in Refinancingnvarchar100
TOPSAP NetWeaver Mobile - Use subcomponents
24MEREP_105Default Value: Mobile ID4VALUEIDValue IDnvarchar160
25MEREP_205Default Value: Mobile Group4VALUEIDValue IDnvarchar160
26MEREP_406Default Value: Value ID2VALUEIDValue IDnvarchar160
27MEREP_406TDefault Value: Value ID Short Description2VALUEIDValue IDnvarchar160
28MEREP_407Default Value: SyncBO3VALUEIDValue IDnvarchar160
TOPSocial Services and Social Security
29PSSCC_SWITCHSocial Services Switches2VALUEIDSwitch Value IDnvarchar100
30PSSCC_SWITCHVALSocial Services Switches3VALUEIDSwitch Value IDnvarchar100
31PSSCC_SWITCH_TSocial Services Switches3VALUEIDSwitch Value IDnvarchar100