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

27 columns | Print definition?ERP 6.0  | MNAME

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1SFTT_ATTND_SAVESave crew member attendance status7MNAMEName of Crew Membernvarchar200
2SSF_PSE_HISTPSE History10MNAMELast Changed Bynvarchar120
3SSF_PSE_LConfiguration Table for PSE File Mode8MNAMELast Changed Bynvarchar120
4TTST_MEMBERCrew Members3MNAMEName of Crew Membernvarchar200
5TTS_SFTSAVECrew Member Information5MNAMEName of Crew Membernvarchar200
TOPDangerous Goods Management
6ET001Conversion of Phrases in Table Fields (Field: Translation)2MNAMECharacteristic/Field Namenvarchar300
7ET002Conversion of Phrases in Table Fields (Contents:Translation)2MNAMECharacteristic/Field Namenvarchar300
TOPEarly Warning System
8MCYAEarly Warning: Exceptions9MNAMESAPoffice: Recipient namenvarchar350
TOPPrint and Output Management
9TSPCPCDSCPC: Distribution status7MNAMELast modifier's namenvarchar120
10TSPCPCDSEExtended distribution status information12MNAMELast modifier's namenvarchar120
11TSPCPCFAVTarget Systems and Target System Groups as Favorite Targets7MNAMELast modifier's namenvarchar120
12TSPCPCPGCCPC: Printer group configuration5MNAMELast modifier's namenvarchar120
13TSPCPCPGLCPC: Printer group list5MNAMELast modifier's namenvarchar120
14TSPCPCPLCPC: List of CPC managed printers on central system6MNAMELast modifier's namenvarchar120
15TSPCPCTPROBSOLETE CPC: Target system group / printer group relations5MNAMELast modifier's namenvarchar120
16TSPCPCTSGCCPC: Target system group configuration5MNAMELast modifier's namenvarchar120
17TSPCPCTSGLCPC: Target system group list5MNAMELast modifier's namenvarchar120
18TSPCPCTSLCPC: Target system list7MNAMELast modifier's namenvarchar120
TOPSecure Network Communications
19RFCDESSECUSNC extensions for RFC destinations9MNAMELast Changed Bynvarchar120
20SNCSYSACLSNC Access Control List (ACL): Systems14MNAMELast Changed Bynvarchar120
21TXCOMSECUSNC extension for CPIC destinations8MNAMELast Changed Bynvarchar120
22USRACLSNC Access Control List (ACL): User10MNAMELast Changed Bynvarchar120
23USRACLEXTExtended SNC Access Control List (ACL) for Users10MNAMELast Changed Bynvarchar120
24USREXTIDAssignment of External ID to Users13MNAMELast Changed Bynvarchar120
25USREXTIDHExternal ID (Access Using Hash Value)7MNAMELast Changed Bynvarchar120
TOPSecure Store and Forward
26SSF_PSE_HSSF: Personel Security Environment9MNAMELast Changed Bynvarchar120
TOPTechnical Objects
27EAML_D_AUSP_CDOCLinear Data for Characteristics2MNAMECharacteristic Description (Technical Name)nvarchar300