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  | PROFILE_TYPE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1RSBPCE_DAP_DIMBPC: DAP Dimension & Hierarchy3PROFILE_TYPEBPC: Profile Typenvarchar10
2RSBPCE_MEMACCESSBPC: Dmension member access table3PROFILE_TYPEBPC: Profile Typenvarchar10
3RSBPCE_PROFILEProfile/Role Mapping3PROFILE_TYPEBPC: Profile Typenvarchar10
4RSBPCE_PROFILETBPC: Profile text3PROFILE_TYPEBPC: Profile Typenvarchar10
TOPApplication Frame
5CRMC_UI_PROFILEProfile3PROFILE_TYPEProfile Typenvarchar10
TOPAuto-ID Infrastructure
6/AIN/TPRFPRFESETElement sets of a profile and their usage2PROFILE_TYPEtype of profilenvarchar20
7/AIN/TPRFTYP_USEProfile Type and element set usage relationship2PROFILE_TYPEtype of profilenvarchar20
8/AIN/TPRF_PROFILProfile Definition2PROFILE_TYPEtype of profilenvarchar20
9/AIN/TPRF_PROFTDescription of profile2PROFILE_TYPEtype of profilenvarchar20
10/AIN/TPRNFILTERCondition Table for Tag Comm: Filter Value -> Profile5PROFILE_TYPEtype of profilenvarchar20
11/AIN/TPRNGRAIFLTCondition Table for Tag Comm: GRAI, Filter Value -> Profile6PROFILE_TYPEtype of profilenvarchar20
12/AIN/TPRNGTINFLTCondition Table for Tag Comm: GTIN, Filter Value -> Profile6PROFILE_TYPEtype of profilenvarchar20
13/AIN/TUIBUSPGRAIUI User Data: Business Process, GRAI -> Profile4PROFILE_TYPEtype of profilenvarchar20
14/AIN/TUIBUSPROCUI User Data: Business Process -> Profile5PROFILE_TYPEtype of profilenvarchar20
TOPCollaboration Folders
15CFX_BOM_PDX_PROFProduct Data eXchange IPC-2571: BOM Export Profile5PROFILE_TYPEProfile type : BOM or ECNnvarchar90
TOPGoods Receipt Process
16BORGR_PROFILEGoods Receipt Automotive: Profiles14PROFILE_TYPEType of Profilenvarchar10
TOPInformation Consistency
17SIC_APP_PROFTYPEDefinition of Profile Types for Applications5PROFILE_TYPEProfile Typenvarchar300
18SIC_PROFILE_NAMEDefinition of Profile Names6PROFILE_TYPEProfile Typenvarchar300
19SIC_PROF_TYPESDefinition of Profile Types for Services3PROFILE_TYPEProfile Typenvarchar300
20SIC_PROF_TYPES_TDescriptive texts for profile types3PROFILE_TYPEProfile Typenvarchar300
21SIC_PROVIDERProvider services3PROFILE_TYPEProfile Typenvarchar300
22SIC_SRV_PROFTYPEDefinition of Profile Types for Services4PROFILE_TYPEProfile Typenvarchar300
TOPMaintenance Orders
23/MRSS/D_SQP_PROFProfile Master Table : Contains all Profile Guids3PROFILE_TYPEProfile Typenvarchar10
TOPSAP Records Management
24RCM_REC_TFPRCM: Record: Function Profile3PROFILE_TYPERCM Record: Function Profile Typenvarchar20
TOPServices
25SSRVRTASSIGNXI Services: Mapping from Binding to Assignment3PROFILE_TYPEWSP Profile Typenvarchar40
26SSRVRTCONFIGXI Services: Mapping XI Config to WS Runtime Config3PROFILE_TYPEWSP Profile Typenvarchar40
TOPTransaction Manager
27TEMC_PROF_TYPEType of Exposure Planning Profile2PROFILE_TYPEType of Exposure Planning Profilenvarchar40
28TEMC_PROF_TYPE_TText Table for Type of Exposure Planning Profile3PROFILE_TYPEType of Exposure Planning Profilenvarchar40
29TEMT_PROFILEPlanning profile3PROFILE_TYPEType of Exposure Planning Profilenvarchar40
TOPWeb Service and SOAP - ABAP
30SRT_ASSIGN_DIRAssignments of Profiles to Configurations6PROFILE_TYPEWSP Profile Typenvarchar40
31SRT_PEND_TASKPending SRT Configuration Tasks6PROFILE_TYPEWSP Profile Typenvarchar40
32SRT_PRF_CFG_DIRSOAP Runtime Framework: Profile Configuration Directory7PROFILE_TYPEWSP Profile Typenvarchar40
33SRT_PROF_ASSIGNAssignment of Configuration Profiles3PROFILE_TYPEWSP Profile Typenvarchar40
TOPWorkforce Management Application
34WFAC_LOCATIONLocation7PROFILE_TYPEOrganization - Group Profile Typenvarchar30
35WFAC_PRF_MOD_FLGtable stores manager editable and need approval flag for par3PROFILE_TYPEconfiguration profile type idnvarchar30
TOPWorkforce Management Core
36WFMC_LOCATIONLocation7PROFILE_TYPEOrganization - Group Profile Typenvarchar30
37WFMC_PRF_MOD_FLGtable stores manager editable and need approval flag for par3PROFILE_TYPEconfiguration profile type idnvarchar30