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

120 columns | Print definition?ERP 6.0  | EMAIL

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/AIF/NS_LOCKDefine Namespace7EMAILEmail address of the person requesting the locknvarchar1000
2/BIC/B0000283000PSA for 0EMPLOYEE_2_ATTR T90CLNT090 Employee30EMAILnvarchar2410
3/CPD/D_MP_CONTACMaster Project contact person11EMAILE-Mail Addressnvarchar2410
4/OPT/VIM_STG_LIFTable: Staging data - Vendor master for ICC27EMAILE-Mail Addressnvarchar2410
5/OPT/WT_3S_SUPPLSupplier Self Service - Supplier Definition5EMAILE-Mail Addressnvarchar800
6/OPT/WT_3S_USERSupplier Self Service - Users3EMAILE-Mail Addressnvarchar800
7/OPT/X141Approval table6EMAILE-Mail Addressnvarchar2410
8/OPT/X143Reqisitioner Request table6EMAILE-Mail Addressnvarchar2410
9/OPT/Y141Approval table6EMAILE-Mail Addressnvarchar2410
10/OPT/Y143Reqisitioner Request table6EMAILE-Mail Addressnvarchar2410
11/OPT/Z141Approval table6EMAILE-Mail Addressnvarchar2410
12/OPT/Z143Reqisitioner Request table6EMAILE-Mail Addressnvarchar2410
13/ORS/7_2_APBApproval table6EMAILE-Mail Addressnvarchar2410
14/ORS/7_2_APB_REQReqisitioner Request table6EMAILE-Mail Addressnvarchar2410
15/ORS/RECENTUSERMost Recently Selected Users15EMAILEmailnvarchar2410
16/ORS/USERMAPOptura User Mapping Object15EMAILEmailnvarchar2410
17/OTTM/OCR_T_OCICInput Channels for OCR5EMAILInput Channel Type: E-Mailnvarchar10
18/PERSOS/USRPROUser Profile data7EMAILE-Mail Addressnvarchar2410
19/SAPPSSRM/SCHPORDatabase Table for Schema for Purchasing Organisation6EMAILEmail Addressnvarchar1000
20/SAPQUERY/TA02Flight customers15EMAILCustomer e-mail addressnvarchar400
21/SAPSRM/D_PARMSTParticipant Master6EMAILSurvey Participant email addressnvarchar2410
22/SAPSRM/D_SURPARSurvey Participant6EMAILSurvey Participant email addressnvarchar2410
23/SAPSRM/SUCO_DSTBackend Systems for transfer from Supplier Self registr.4EMAILSend an E-Mailnvarchar10
24/XLSO/PREF_COMMTable to maintain preferred communication for user6EMAILBoolean Variable (X=True, -=False, Space=Unknown)nvarchar10
25ACO000SAP_GP: Communication Data Set Bidder/Vendor/Portal11EMAILE-Mail Addressnvarchar2410
26BBPT_IMS_LOGIMS Log Data Table13EMAILE-Mail Addressnvarchar2410
27BBP_IU01Link Table: Internet User to E-Mail4EMAILE-Mail Addressnvarchar2410
28BBP_TMP_ACOTemporary: Request 'Bidder', Communication Data12EMAILE-Mail Addressnvarchar2410
29CNVMBTNEOBSERVERKnown Observer Instances3EMAILBoolean Variable (X=True, -=False, Space=Unknown)nvarchar10
30CRM_ICI_TRACES_Hstorage for SOAP traces in ICI: session level attributes8EMAILBoolean Variable (X=True, -=False, Space=Unknown)nvarchar10
31DCFLC_EMAIL_RECIdoc Error additional E-Mail Receiver2EMAILE-Mail Addressnvarchar2410
32EHFNDD_VEN_EMCONVendor - Emergency Contact12EMAILE-Mail Address of Partynvarchar2410
33EHFNDD_VEN_SDSCOVendor - SDS Contact12EMAILE-Mail Address of Partynvarchar2410
34EHPRCD_ORGPERContact8EMAILE-Mailnvarchar800
35FIPDCKW_USERSKuwait Check Responsible Users6EMAILE-Mail Addressnvarchar2410
36GRACREQUSERUser Associated with Request16EMAILE-Mail Addressnvarchar2550
37GRACUSERUser Table6EMAILE-Mail Addressnvarchar2410
38GRFNPARTNERPartner3EMAILEmail Addressnvarchar500
39HRP1655DB Table for Infotype 165528EMAILE-Mail Addressnvarchar300
40J_1UF_TP_MAINMain Information of Notification14EMAILE-mailnvarchar800
41J_3RF_TP_CC_PROPCompany category and liquidation code for bukrs10EMAILE-mailnvarchar800
42J_3RF_TP_MAINMain Information of Notification16EMAILE-mailnvarchar800
43MENA_CR_DATAMENA Certificates10EMAILE-Mail Addressnvarchar2410
44PA3399HR Master Record: Infotype 339924EMAILEmail Idnvarchar600
45SIMDQ_MTC_POLICYIM in HANA match policy settings10EMAILIM in HANA Email component in Match Policy settingnvarchar10
46T5FADRAddresses for legal reporting6EMAILE-mail addressnvarchar1000
47T5P0EEstablishment21EMAILMail addressnvarchar610
48T7BREFD_ERCNTCContact of person responsible for information10EMAILE-Mailnvarchar600
49T7BRERCONTACTCompany contact table10EMAILFCG: E-mailnvarchar600
50T7NZCIRCompany Tax Details - NZ16EMAILE-mail : NZnvarchar600
51T7OM05OMAN Health Insurance Company Address and E-mail5EMAILInsurance Company E-mail Addressnvarchar600
52T7RU9AAddresses of organizations55EMAILOrganization E-Mail Addressnvarchar300
53ZCUSTOMERMOBILETable to store information about recorded customers2EMAILMail of customernvarchar400
54HRP1756DB Table for Infotype 175626EMAILE-Mail Addressnvarchar2410
55T7PIQ_GB_SCHOOLUCAS: Schools40EMAILUCAS: Email addressnvarchar2410
56T7PIQ_NL_INSTITInstitutes and Education Details26EMAILE-Mail Addressnvarchar2410
TOPABAP Test Frameworks ATC, CheckMan, Code Inspector
57CRMAHRData on Persons10EMAILE-Mail Addressnvarchar2410
58CRMCHKRESLFindings (Display LoaD)34EMAILE-Mail Addressnvarchar2410
TOPABAP Workbench, Java IDE and Infrastructure
59SCUSTOMFlight customers15EMAILCustomer e-mail addressnvarchar400
TOPAccounts Receivable Accounting Process Integration
60TEBPPCOMMFLAGNotification Methods for Communication Events7EMAILNotification by e-Mailnvarchar10
TOPAlert Framework
61SALRTDLVRYAlert Assignment (Personalization)4EMAILSend Alert by E-Mailnvarchar10
TOPArgentina
62T7ARM2(Dependents) additional data15EMAILE-mail addressnvarchar600
TOPBalanced Scorecard
63UMB_SC186Scorecard: Initiative: Team Members12EMAILE-Mail Addressnvarchar600
TOPBelgium
64T5B9AInstitutions (B)27EMAILEmail Address of Contact Person (00637)nvarchar600
TOPBusiness Information Collection
65UIIUSRInfoUser (SEM-BIC)3EMAILE-Mail Addressnvarchar2410
66UIORD_R_IUSRRelation between Research Request and InfoUser (SEM-BIC)4EMAILE-Mail Addressnvarchar2410
TOPBusiness Server Pages
67AUUSERUser Table for the eRhine Auction House5EMAILString 20 -> Name, Usrname, pwd, ... - use STRING for formsnvarchar400
TOPClinical System
68N2DLV_RECEIVERi.s.h.med: Dispatch - Recipient21EMAILIS-H: Internet Mail (SMTP) Addressnvarchar2410
69N2MV_DISREQDispatch Request Data Table27EMAILIS-H: Internet Mail (SMTP) Addressnvarchar2410
70N2MV_VSDATRecipient Data Table26EMAILIS-H: Internet Mail (SMTP) Addressnvarchar2410
TOPConnection to External Systems
71DPR_OBJLINK_SC_IItems for SRM Shopping Cart18EMAILE-Mail Address of Alert Recipientnvarchar2410
TOPConstruction Industry
72PDBKANConstruction Industry Social Fund Proced: ANMEL Data Records28EMAILE-mail Addressnvarchar500
TOPContract Billing
73ISU_ERR_RESPONSPersons responsible for processing error extracts4EMAILE-mail addressnvarchar1320
74ISU_WAR_ROOMRegister Agent for Manual Corrections4EMAILE-mail addressnvarchar1320
TOPCorporate Performance Monitor
75UMR_RI142RMS: Risk-Reducing Activities - Team Members14EMAILE-Mail Addressnvarchar600
TOPCross-Application Components
76/OPT/VPRVendor Portal Registration15EMAILE-Mail Addressnvarchar2410
77/OPT/VPR_LOCVendor Registration Location10EMAILE-Mail Addressnvarchar2410
78ETP_PARTNERTask Partner11EMAILE-Mail Addressnvarchar2410
TOPeCATT Extended Computer Aided Test Tool
79DEMO_SCUSTOMCreate Control Table Flight Customers15EMAILCustomer e-mail addressnvarchar400
TOPEmployee Interaction Center
80THREIC_CONTACTEIC Contact13EMAILE-Mail Addressnvarchar2410
TOPEnvironment, Health and Safety
81/TDAG/CPT_ORGPERIMDS Contact8EMAILE-Mailnvarchar800
TOPFinancials Basis
82UBC_TB_INVHBill (Header)17EMAILE-Mail Address of Ordering Partynvarchar2410
TOPFunctions for U.S. Federal Government
83FMCCRTVENDORPOCCCR Vendor Points of Contact18EMAILnvarchar800
TOPGeneral Application Functions
84TFISCOMMFLAGFSCM, Biller Direct: Notification Methods7EMAILNotification by e-Mailnvarchar10
TOPGeneral Object Relations
85SFLITPASSAttribute Table: Transit Passenger16EMAILCustomer e-mail addressnvarchar400
TOPGermany
86T5D4X_ZERTRCertificate Request - Admin. Contrib. Statmt Certificates20EMAILText, 40 Characters Longnvarchar400
TOPImplementation Guide
87TRESSPProject Resources6EMAILE-Mail Addressnvarchar2410
TOPIncident Recording
88EHHSSD_INC_PINITIncident - Person Initial Recording15EMAILE-Mail Address of Involved Personnvarchar2410
TOPIncident Reporting
89EHHSSD_IRT_CCRECReport Cc Receivers10EMAILE-Mail Address of Partynvarchar2410
TOPIreland
90T7IEEEHECS: Return Data18EMAILEHECS: Contact Person E-mail Addressnvarchar800
TOPLocalization
91J_1BECD_CUST03ECD Person Responsible8EMAILE-mail Addressnvarchar600
TOPMonitoring
92ALXMBEMAILCCMS: Registration of E-Mail Recipients for Alerts5EMAILCCMS: Message Type Activation E-Mailnvarchar10
TOPNew Zealand
93T7NZIRInland Revenue Certificates NZ17EMAILE-mail : NZnvarchar600
TOPNon Profit Organizations
94PA0962HR Master Record: Infotype 096255EMAILEmail Idnvarchar600
TOPOLAP Technology
95RSDDTREXCHECKIDHeader for BIA Checks for Data Consistency7EMAILnvarchar1000
TOPOrganizational Flexibility
96/ISDFPS/USER_MAPAssign Users Responsible7EMAILE-Mailnvarchar10
TOPPatient Accounting
97NEHC_INSIS-H: Health Insurance Card (Insurance Data)84EMAILnvarchar1000
TOPPatient Management
98NADRIS-H: Addresses (Central Address Management)31EMAILIS-H: Internet Mail (SMTP) Addressnvarchar2410
99NTMNIS-H: Patient-Specific Appointments (Header Table for NAPP)65EMAILIS-H: Internet Mail (SMTP) Addressnvarchar2410
TOPPayroll
100T7ROG5EE register - ER history26EMAILnvarchar300
101T7TRG01General information about company.27EMAILnvarchar500
TOPPerformance Assessment Workbench
102SLS_CONTACPAW - Contact Data of Location8EMAILEmail address (PAW)nvarchar500
TOPPeriodical Sales and Distribution
103JKTWBZINIS-M/SD: Clipboard for WBZ Records for Processing61EMAILIS-M/SD: WBZ, E-Mail Addressnvarchar500
104JKTWBZOUTIS-M/SD: Clipboard for Processed WBZ Records49EMAILIS-M/SD: WBZ, E-Mail Addressnvarchar500
TOPPersonnel Administration
105HRP1656DB Table for Infotype 165629EMAILE-Mail Addressnvarchar300
106T7CO01Additional data of the company20EMAILE-mailnvarchar600
TOPPortugal
107T5P0PHR-PT: Personnel Subarea Supplements23EMAILMail addressnvarchar610
TOPProduct and Process Modeling
108RLMFWOHADRelease Order - Recipient9EMAILNotification via E-Mailnvarchar10
TOPPublic Sector Contract Accounts Receivable and Payable
109DFMCA_BRF650BRF: Business Partner Reading34EMAILBRF: Expressionnvarchar200
TOPReal Estate Localization Czech Republic
110/CEERE/RIZENIPT settings for company code29EMAILE-Mail Addressnvarchar2410
TOPReporting
111P05TPRNL_EE_PDPension Return: Personal Data - Pers Level35EMAILCommunication: Long Identification/Numbernvarchar2410
TOPRoom Reservations and Seating Arrangements
112VIORRSPARTAttendees9EMAILE-Mail Addressnvarchar2410
TOPSecurity
113STRUSTCABCentral Address Book12EMAILEmail addressnvarchar2540
TOPTax Reporter
114T5UX7Alternate forms details11EMAILFlag for e-mail generationnvarchar10
TOPTerminologyGlossary
115STERM_Q_MAILRecipient for E-Mail Notification2EMAILSAPoffice: Name of the recipient of a document (also ext.)nvarchar12150
TOPThailand
116PA0180Alternative Address Data (Thailand)28EMAILE-mail Address (TH)nvarchar600
TOPTranslation Tools
117LXE_TAMO_ERRORConfiguration Table for Trados Analysis Errors2EMAILSAPoffice: Name of the recipient of a document (also ext.)nvarchar12150
TOPWorkflows and Tasks for Risk Assessment
118EHHSSC_RAS_FTNRFree Text Notification Receivers2EMAILE-Mail Address of Partynvarchar2410
TOPWorkforce Management Core
119/SAPAPO/LRPGWRESResource Information for GW Integration5EMAILE-Mail Addressnvarchar2410
120/SAPAPO/TSTGWRESResource Information for GW Integration5EMAILE-Mail Addressnvarchar2410