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

50 columns | Print definition?ERP 6.0  | FLDNAME

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/OPT/VIM_Y_LOGDYear End log details19FLDNAMEField namenvarchar1320
2/OPT/X151OPENTEXT: Approval Diagnostic Log Data19FLDNAMEField namenvarchar1320
3/OPT/Y151OPENTEXT: Approval Diagnostic Log Data19FLDNAMEField namenvarchar1320
4/OPT/Z151OPENTEXT: Approval Diagnostic Log Data19FLDNAMEField namenvarchar1320
5/ORS/DIAG_LOGSOPENTEXT: Approval Diagnostic Log Data19FLDNAMEField namenvarchar1320
6/PTGWFI/M_YEND_LYear end program log for optura po inv year end process21FLDNAMEField namenvarchar1320
7CNV_20551_COUNTCounter for selection for deletion (empty fields)4FLDNAMEField Namenvarchar300
TOPActual Update and Commitment Update
8GTRCOND_CUSTTable for Customer Spec. Fields - Grantor Rule Conditions2FLDNAMEGTR Rule Condition Field Namenvarchar300
9GTRCOND_CUSTTRule Condition Text table for the Field texts.3FLDNAMEGTR Rule Condition Field Namenvarchar300
10GTRPROG_PROFILCTRule Condition Text table for the assignment field texts.4FLDNAMEGTR Rule Condition Field Namenvarchar300
11GTRPROG_PROFILECGTR Program Profile Assignment to Rule Conditions3FLDNAMEGTR Rule Condition Field Namenvarchar300
12GTRRULE_COND_VAssignment Condition Block --> Condition Values4FLDNAMEGTR Rule Condition Field Namenvarchar300
TOPALE Integration Technology
13BDCPChange pointer5FLDNAMEField Namenvarchar300
14BDCP2Aggregated Change Pointers (BDCP, BDCPS)7FLDNAMEField Namenvarchar300
15BDLSPOSItem for Conversion of Logical System Names4FLDNAMEField Namenvarchar300
16TBD21ALE: IDoc reduction3FLDNAMEField Namenvarchar300
17TBD22ALE: mapping IDoc fields to change document fields3FLDNAMEField Namenvarchar300
18TBD23ALE: definition of mandatory segments/fields3FLDNAMEField Namenvarchar300
19TBD24ALE: IDOC reduction flagged with positive logic3FLDNAMEField Namenvarchar300
20TBD62Assignment of change document field to message type5FLDNAMEField Namenvarchar300
TOPCross-Application Components
21/PTGWFI/F_YEND_LYear end program log for optura non po year end process21FLDNAMEField namenvarchar1320
TOPeCATT Extended Computer Aided Test Tool
22ECMSG_COLLCollecting Messages for eCATT SAPGUI15FLDNAMEField namenvarchar1320
TOPF1 Help
23ERG001Statistics ergonomics version for Q teams3FLDNAMEField Namenvarchar300
TOPFinancial Accounting
24/OPT/VIM_1BDCLOGBDC Log19FLDNAMEField namenvarchar1320
TOPGlobal Trade Services
25/SAPSLL/TICSDAGTS: Assign Determination Supplement to Field Name4FLDNAMEField Namenvarchar300
26/SAPSLL/TICSFDGTS: Definition of Field in Incompleteness Check4FLDNAMEField Namenvarchar300
TOPLegacy System Migration Workbench
27/SAPDMC/LSOFLDSource Fields5FLDNAMESource Fieldnvarchar300
28/SAPDMC/LSOINFLegacy Data: Not Yet Used5FLDNAMESource Fieldnvarchar300
TOPLoans Management
29TDPR_ATTRFIELDAttribute: Field Description3FLDNAMEField Namenvarchar300
TOPMaster Data
30TDINTER_FIELDCATField Catalog for Converting Modification Groups3FLDNAMEField Namenvarchar300
TOPPatient Management
31NHLPFIELDIS-H: (Personal) Field Selection for F4 Help4FLDNAMEName of Dynpro Fieldnvarchar300
TOPProcess Monitoring Infrastructure
32SSPIAGCNDLocal SPI: Agent Runtime; Configurations3FLDNAMESPI: Data Field Namenvarchar300
33SSPIAGDFLDLocal SPI: Agent Runtime; Field Names4FLDNAMESPI: Data Field Namenvarchar300
34SSPIAGFLDSPI: Descriptions for Agent Payload Attributes3FLDNAMESPI: Data Field Namenvarchar300
35SSPIAGFLD_TSPI: Payload Attribute Short Texts for Agent4FLDNAMESPI: Data Field Namenvarchar300
36SSPICSTRPLSPI: Payload Tracking Record3FLDNAMESPI: Data Field Namenvarchar300
37SSPIPIFFLDSPI: Field Names of Process Interface4FLDNAMESPI: Data Field Namenvarchar300
38SSPIPVCSPI: Process Variant - Definition5FLDNAMESPI: Data Field Namenvarchar300
39SSPISGCONSPI: Signature Condition Records4FLDNAMESPI: Data Field Namenvarchar300
40SSPISGFLDSPI: Signature Payload Attributes4FLDNAMESPI: Data Field Namenvarchar300
41SSPISGFLD_TSPI: Short Texts for Supported Signature Fields5FLDNAMESPI: Data Field Namenvarchar300
42SSPITRCCNDE2E Trace Conditions4FLDNAMESPI: Data Field Namenvarchar300
TOPProduction Orders
43COMPFOCM: Names of compared fields5FLDNAMEField namenvarchar300
TOPRecycling Administration Core Functions
44J_7LBDCMSGREA Conditions: Error Messages BDC Condition Adjustment39FLDNAMEField namenvarchar1320
TOPService Station Retailing
45OIRADBTCFLDCustomer specifc fields for he document base table (OIRADB2FLDNAMEField name of customer-specific fieldnvarchar300
TOPTransaction Data Pool
46JBDVAFEOutbound Fields for Procedures3FLDNAMEField Namenvarchar100
TOPTransaction Manager
47TZKN9Acct assignm.ref.:Check tab.for permitted table-/field names3FLDNAMEField name (in table)nvarchar300
TOPTravel Expenses
48T706FORM_FLDSInformation in fixed positions7FLDNAMEField namenvarchar400
49T706FORM_VARFLDVariable fields1FLDNAMEField namenvarchar400
50T706FORM_VARFLDSVariable fields (language-dependent)2FLDNAMEField namenvarchar400