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

46 columns | Print definition?ERP 6.0  | COMM_TYPE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/SMD/MD_____00E7SID-Tabelle fuer Comm. Method3COMM_TYPECommunication Method (Key) (Business Address Services)nvarchar30
2/SMD/MD_____00RHSID-Tabelle fuer Comm. Method3COMM_TYPECommunication Method (Key) (Business Address Services)nvarchar30
3BBP_PCPOSProcurement Card Statement: Position Data39COMM_TYPECommunication Method (Key) (Business Address Services)nvarchar30
4BBP_SUS_STG_ADRStaging address table41COMM_TYPECommunication Method (Key) (Business Address Services)nvarchar30
5BBP_TMP_ZA_ASPTemporary: Request 'Bidder', Contact Addresses42COMM_TYPECommunication Method (Key) (Business Address Services)nvarchar30
6BBP_TMP_ZA_ORGTemporary: Request 'Bidder', Company Address42COMM_TYPECommunication Method (Key) (Business Address Services)nvarchar30
7EHPRCD_CMP_ROOTCampaign Root23COMM_TYPECommunication Typenvarchar20
8GRACREQUSERADRUser Communication Fields15COMM_TYPECommunication Typenvarchar30
9NWS_EXT_ADR2Texts for Communication Data (Central Address Management)3COMM_TYPECommunication Method (Key) (Business Address Services)nvarchar30
10NWS_EXT_ADRTTexts for Communication Data (Central Address Management)3COMM_TYPECommunication Method (Key) (Business Address Services)nvarchar30
11REQADDRESSDelivery Address for Requirement Coverage Request Lines41COMM_TYPECommunication Method (Key) (Business Address Services)nvarchar30
12SRT_CDTC_CO_DETCentral Design Time Cache: Contract Details8COMM_TYPESRT: Communication Typenvarchar10
13UCONSTATMONITORAStorage of UCON Statistics Data (Cross Client; aggregated)18COMM_TYPECommunication Typenvarchar180
14PIQDB_NL_ADDRMaintain GBA Address44COMM_TYPECommunication Method (Key) (Business Address Services)nvarchar30
TOPAddress ManagementBusiness Address
15ADRCOMCComm. Data Serial Number Counter (Business Address Services)4COMM_TYPECommunication Method (Key) (Business Address Services)nvarchar30
16ADRCOMCSShadow table: Counter for current numbers for comm. data5COMM_TYPECommunication Method (Key) (Business Address Services)nvarchar30
17ADRCOMCS2Shdow Table 2: Comm. data serial number counter5COMM_TYPECommunication Method (Key) (Business Address Services)nvarchar30
18ADRTCommunication Data Text (Business Address Services)4COMM_TYPECommunication Method (Key) (Business Address Services)nvarchar30
19ADRTSShadow Table: Texts for Communications Data (BAS)5COMM_TYPECommunication Method (Key) (Business Address Services)nvarchar30
20ADRTS2Shadow Table 2: Communication Data Texts (BAS)5COMM_TYPECommunication Method (Key) (Business Address Services)nvarchar30
21ADRUTable for Communication Usages4COMM_TYPECommunication Method (Key) (Business Address Services)nvarchar30
22ADRUSShadow Table: Communication Usages (BAS)5COMM_TYPECommunication Method (Key) (Business Address Services)nvarchar30
23ADRUS2Shadow Table_2: Communication Usages (BAS)5COMM_TYPECommunication Method (Key) (Business Address Services)nvarchar30
24TSACCommunication Methods (Business Address Services)1COMM_TYPECommunication Method (Key) (Business Address Services)nvarchar30
25TSACTCommunication Method Description (Business Address Services)2COMM_TYPECommunication Method (Key) (Business Address Services)nvarchar30
TOPAP-LIM Logistics Inventory Management Engine
26/LIME/CUST_DISPACustomizing: Control Dispatcher4COMM_TYPECommunication Types for Distribution of LIME Datanvarchar40
27/LIME/CUST_FDRELDetermination Table for Filter Values BAdI /LIME/DISPATCHER3COMM_TYPECommunication Types for Distribution of LIME Datanvarchar40
28/LIME/CUSY_COMCommunication Types for Distribution of LIME Data1COMM_TYPECommunication Types for Distribution of LIME Datanvarchar40
29/LIME/CUSY_COMSPCommunication Types for Distribution of LIME Data - Texts1COMM_TYPECommunication Types for Distribution of LIME Datanvarchar40
TOPBackground Processing
30TBTC_EXT_SDLExtSdl: Registration Table: External Schedulers3COMM_TYPEExtSdl: Communication Typenvarchar10
TOPBasis Services Communication Interfaces
31TCSTRPCommunication types in communication strategy4COMM_TYPECommunication Method (Key) (Business Address Services)nvarchar30
TOPCommunication Services Mail, Fax, SMS, Telephony
32BCST_IBNDBCS: Rules for Inbound Distribution2COMM_TYPECommunication Method (Key) (Business Address Services)nvarchar30
33BCST_RETEBCS: Status of Technical Recipients3COMM_TYPECommunication Method (Key) (Business Address Services)nvarchar30
TOPDocument Builder
34/IPRO/TDOCMNTDocument Builder Documents41COMM_TYPECommunication Typenvarchar10
TOPE-Recruiting
35T77RCF_COM_CHNCommunication Channels2COMM_TYPECommunication Typenvarchar40
36T77RCF_COM_CHN_TCommunication Channels2COMM_TYPECommunication Typenvarchar40
TOPManagement of Global Employees
37PA0708HR Master Record: Infotype 070824COMM_TYPEGlobal Commuting Typesnvarchar20
38T76MGE_COMTTText Table for Global Commuting Types3COMM_TYPEGlobal Commuting Typesnvarchar20
39T76MGE_COMTYGlobal Commuting Types2COMM_TYPEGlobal Commuting Typesnvarchar20
TOPMonitoring
40SCMLPSMOI_WS: Configuration of Logical Ports for SAPSTARTSRV7COMM_TYPESMOI_WS: Web Service Communication Type (HTTP, HTTPS, ...)nvarchar50
TOPNetWeaver Business Content
41BIZC_CPROV_SOLMAConnection Table: l Content Provider - SolMan4COMM_TYPECommunication Type for Content Providernvarchar40
TOPPost Processing Framework
42PPFTTCSTRPCommunication types in communication strategy4COMM_TYPECommunication Method (Key) (Business Address Services)nvarchar30
TOPSAP Business Workflow
43SWN_DELTYPEWF Notif: Delivery Type3COMM_TYPECommunication Typenvarchar30
TOPStakeholder Relationship Management
44USC_COMM_TYPESDefault Communication Types for Contact Categories3COMM_TYPECommunication Type in Stakeholder Contactsnvarchar30
45USC_TEMPLATEForms / SmartForms by Communication Type2COMM_TYPECommunication Type in Stakeholder Contactsnvarchar30
TOPWeb Service and SOAP - ABAP
46SRT_MMASTERWS message (Master table)6COMM_TYPECommunication Typenvarchar10