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

37 columns | Print definition?ERP 6.0  | PHONE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/BIC/B0000283000PSA for 0EMPLOYEE_2_ATTR T90CLNT090 Employee31PHONEnvarchar300
2/IXOS/DC_EX_ADDRAddresses of a customer6PHONEFirst telephone no.: dialling code+numbernvarchar300
3/OPT/VIM_STG_LIFTable: Staging data - Vendor master for ICC17PHONEFirst telephone no.: dialling code+numbernvarchar300
4/ORS/RECENTUSERMost Recently Selected Users17PHONETelephone Numbernvarchar140
5/ORS/USERMAPOptura User Mapping Object17PHONETelephone Numbernvarchar140
6/SAPSRM/D_PARMSTParticipant Master8PHONESurvey Participant telephone numbernvarchar300
7/SAPSRM/D_SURPARSurvey Participant9PHONESurvey Participant telephone numbernvarchar300
8/XLSO/PREF_COMMTable to maintain preferred communication for user5PHONEBoolean Variable (X=True, -=False, Space=Unknown)nvarchar10
9GRACUSERUser Table7PHONEPhone Numbernvarchar200
10SIMDQ_MTC_POLICYIM in HANA match policy settings9PHONEIM in HANA Phone component in Match Policy settingnvarchar10
11T5FADRAddresses for legal reporting7PHONETelephone numbernvarchar100
12T7BREFD_ERCNTCContact of person responsible for information7PHONETelephone no.nvarchar120
13T7BRERCONTACTCompany contact table8PHONESIP: telephonenvarchar120
14ZSKSYSUSERuser in den IDES-Systemen5PHONEnvarchar150
15T7PIQ_NL_INSTITInstitutes and Education Details24PHONETelephone no.: dialling code+numbernvarchar300
TOPABAP Test Frameworks ATC, CheckMan, Code Inspector
16CRMAHRData on Persons5PHONEFirst telephone no.: dialling code+numbernvarchar300
17CRMEMTCIDCopy of EMTCID Table5PHONEnvarchar60
TOPBasic Functions
18LECI_EVENT_DATAActivity Data Within the Check-in/Check-out Process29PHONEFirst telephone no.: dialling code+numbernvarchar300
19T850KCompany correspondence data6PHONETelephone number of companynvarchar150
TOPBasis Components
20ZDS400_TAB1Exercise table6PHONECHAR20 for SYSTnvarchar200
TOPBusiness Objects, Common Components
21EHDMOD_ADR_PHONEAddress - Contacts8PHONEPhone Number Typenvarchar100
TOPConnection to External Systems
22DPR_OBJLINK_SC_IItems for SRM Shopping Cart19PHONETelephone Number of External Business Partnernvarchar400
TOPCross-Application Components
23/OPT/VPRVendor Portal Registration14PHONEFirst telephone no.: dialling code+numbernvarchar300
TOPDownloadUpload
24/DSD/HH_RACADDSD Route Settlement: Customer Address Data (One-Time Only)11PHONEFirst telephone numbernvarchar160
TOPDSD Connector
25/DSD/ME_CUST_CPDDSD CN: One-time Customer13PHONEDSD Connector: Phone numbernvarchar160
26/DSD/ME_CUST_HDDSD CN: Customer Details13PHONEDSD Connector: Phone numbernvarchar160
TOPEmployee Interaction Center
27THREIC_CONTACTEIC Contact10PHONEFirst telephone no.: dialling code+numbernvarchar300
28THREIC_GROUP_DETEIC Grouping Detail3PHONEPhone Number EICnvarchar300
TOPFunctions for U.S. Federal Government
29FMCCRTVENDORPOCCCR Vendor Points of Contact14PHONEnvarchar300
TOPImplementation Guide
30TRESSPProject Resources7PHONETelephone Number of a Project Team Membernvarchar300
TOPIreland
31T7IEEEHECS: Return Data17PHONEEHECS:Contact Person Phone Numbernvarchar140
TOPLocations Location Structure
32EHFNDD_LOC_REVLocation - Revisions31PHONETelephone Numbernvarchar300
TOPPatient Accounting
33NEHC_INSIS-H: Health Insurance Card (Insurance Data)83PHONEnvarchar300
TOPPerformance Assessment Workbench
34SLS_CONTACPAW - Contact Data of Location9PHONETelephone number (PAW)nvarchar400
TOPRoom Reservations and Seating Arrangements
35VIORRSPARTAttendees10PHONEComplete number: dialling code+number+extensionnvarchar300
TOPTravel Planning
36FTPT_HOTEL_DATAHotel Data16PHONETelephone Numbernvarchar400
37TA23HOTELSHotel Data16PHONETelephone Numbernvarchar400