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

78 columns | Print definition?ERP 6.0  | RECEIVER

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/GSINS/NLG_OUTAGBA Interface: Outgoing Message Header5RECEIVERGBA Interface: Outgoing Message Receivernvarchar40
2/OPT/CT_IDH_MAILInbound Document Handler: Email Input Log - obsolete13RECEIVERExternal profile that triggers incoming channelnvarchar600
3/PLMI/TD_AGT_LSTTeam Definition: Agent List12RECEIVERTeam Definition: Recipientnvarchar10
4IDGT_GTDHGT Document Header24RECEIVERReceivernvarchar120
5OTM_HREE_C01OnDemand Transfer of Employee master data - configuration2RECEIVERPartner Number of Receivernvarchar100
6TIVXCITF24PYMNTF24 Payment Data4RECEIVERReceivernvarchar50
7ZROLESWrkflow Recipients4RECEIVERInternet Addressnvarchar1320
8ZSPWFSP Workflow Triggering and Email Notifiy4RECEIVERInternet Addressnvarchar1320
TOPALE Integration Technology
9TBDTPBALE Template: BAPI Interfaces3RECEIVERALE partnernvarchar100
10TBDTPBDFALE Template: Parameter Filtering for BAPIs3RECEIVERALE partnernvarchar100
11TBDTPBDRALE Template: Reduction for BAPIs3RECEIVERALE partnernvarchar100
12TBDTPBDRFALE Template: Fields in Reduced Parameter5RECEIVERALE partnernvarchar100
13TBDTPBRALE Template: Receiver Determination for BAPIs3RECEIVERALE partnernvarchar100
14TBDTPMALE Template: Message Type Interfaces3RECEIVERALE partnernvarchar100
15TBDTPMDALE Template: Data Filters for Message Types3RECEIVERALE partnernvarchar100
TOPAuthentication and SSO
16SAML2_ARTIFACTStorage Table for SMAL2 Artifacts6RECEIVERSAML2 Entity ID Keyvarbinary160
17SAML2_REQUESTStorage Table for SAML2 Requests and RelayState4RECEIVERSAML2 Entity ID Keyvarbinary160
TOPBank Customer Accounts
18NIHC_DB_RINSTRouting Instructions5RECEIVERnvarchar1280
TOPBasic Data
19NCMONIS-HCM: Function Modules for Monitoring Program4RECEIVERRecipient Namenvarchar120
20NCMOSIS-HCM: Status Table for HCM Monitor15RECEIVERRecipient Namenvarchar120
TOPBroadcast Messaging
21CRMD_BM_MESCRM broadcast messaging runtime table for messages6RECEIVERUser Name in User Master Recordnvarchar120
TOPBusiness Rule Framework
22TBRF370BRF: External Rule Engine Integration (XREI)9RECEIVERBRF: XREI/XI - Receivernvarchar800
TOPChange Pointer Service
23CNS_HB_CONVCNS: Do the status entries for recipients have hash values?2RECEIVERRecipient IDnvarchar50
24CNS_RECV_STATUSCNS: Change Pointers - Recipient Worklist3RECEIVERRecipient IDnvarchar50
25CNS_RECV_STAT_PCNS: Change Pointers - Recipient Worklist History3RECEIVERRecipient IDnvarchar50
26TCNS_EXP_RECCNS: Export Object Type for Recipient Combination3RECEIVERRecipient IDnvarchar50
27TCNS_MAPPIN_CUSTCNS: Mapping Receiver to Export Object Types4RECEIVERRecipient IDnvarchar50
28TCNS_RECEIVEROBSOLETE: CNS Recipient2RECEIVERRecipient IDnvarchar50
29TCNS_RECEIVERSCNS: Recievers1RECEIVERRecipient IDnvarchar50
30TCNS_RECEIVERSTCNS: Receiver Description2RECEIVERRecipient IDnvarchar50
31TCNS_RECEIVERTOBSOLETE: CNS Description of Recipient2RECEIVERRecipient IDnvarchar50
32TCNS_RECV_CUSTCNS: Recipient Settings3RECEIVERRecipient IDnvarchar50
33TCNS_SET_RECVOBSOLETE: Assignment of Recipient to Export Object Type4RECEIVERRecipient IDnvarchar50
TOPCollectionsDisbursements
34DIMAPARCORRIO: Correspondence for Ins. Object <-> Partner Relationship7RECEIVERCorrespondence Recipient IDnvarchar100
TOPConfiguration management
35TCMRECEIVERSReceiver of the CM folder3RECEIVERKey of BOR object 'Address'nvarchar280
TOPContract Accounts
36FKKVK_CORRCorrespondence for Relationship Contract Account<->Partner7RECEIVERCorrespondence Recipient IDnvarchar100
TOPContract Accounts Receivable and Payable
37DFKKINFCORInformation Container: Reset History3RECEIVERReceiver Systemnvarchar600
38DFKKINFCOSInformation Container: Send Information3RECEIVERReceiver Systemnvarchar600
39DFKKINFCOTInformation Container: Entries from Test4RECEIVERReceiver Systemnvarchar600
TOPCorrespondence Tool
40TRCV_SHLP_ADDRTable for Search Help for Address Number Selection3RECEIVERBusiness Partner ID of Correspondence Recipientnvarchar100
TOPCustomer Interaction Center
41ECCPRECEIVEConfiguration of office-recipient for workflow start2RECEIVERRecipient Configurationnvarchar200
42ECCPRECEIVETConfiguration of office-recipient for workflow start (texts)3RECEIVERRecipient Configurationnvarchar200
TOPDefault Risk and Limit System
43KLRECEIVERUser-Recipient Relationship3RECEIVERRecipient of a Workflownvarchar120
TOPEnergy Data Management
44EEDMPROSENDRecording of Sent Profiles11RECEIVERRecipient (Service Provider)nvarchar100
TOPFSCM In-House Cash
45IHC_TAB_GUI_FLDIHC: Container Field in GUI7RECEIVERRecipient/Payer Tab Pagenvarchar10
46IHC_TAB_GUI_MAPIHC: Mapping Table for GUI12RECEIVERRecipient/Payer Tab Pagenvarchar10
TOPGateway Business Eventing and Provisioning
47/IWBEP/D_SUBSInformation on the events subscribers4RECEIVEREvent receivernvarchar120
TOPIncentive and Commission Management ICM
48CACSCS_DFKKCOHAggregation Container10RECEIVERCorrespondence Recipientnvarchar100
49CACS_CTRTBUCommission Contract25RECEIVERCorrespondence Recipient IDnvarchar100
50CACS_CTRTCORRICM: Assignment of Correspondence Types to Contract20RECEIVERCorrespondence Recipient IDnvarchar100
TOPIntegration Engine
51SXMSMSGDEFMessage Definition5RECEIVERReceiver IDnvarchar300
52SXMSMSGREFMessage Reference Storage11RECEIVERXI: Servicenvarchar600
53SXMSRECVTTechnical Receiver5RECEIVERProxy Generation: External Namespacenvarchar2550
TOPIntercompany Data Exchange
54ECOMCONTROLSPCommunication Control Based on Service Providers7RECEIVERRecipient (Service Provider)nvarchar100
TOPMapping
55SMPPCASEXI Mapping: Automatic Test Cases7RECEIVERReceiver Systemnvarchar600
TOPMonitoring
56ALXMBEMAILCCMS: Registration of E-Mail Recipients for Alerts4RECEIVERUser Name in User Master Recordnvarchar120
TOPProduct Data Management
57CEPMONITORMonitoring Table for CEP scenario (status changes)3RECEIVERKey of BOR object 'Address'nvarchar280
58CEPRECEIVERSRecipients of the distributed CM folder in CEP scenario3RECEIVERKey of BOR object 'Address'nvarchar280
59CEPRESENDDOCSDocuments to be sent again3RECEIVERKey of BOR object 'Address'nvarchar280
TOPProduct Safety
60CCRCC_ERRMAILEHS: Specify Recipients for Error Messages12RECEIVERRecipient addressnvarchar2410
TOPPublic Sector Contract Accounts Receivable and Payable
61DFMCA_BRF533BRF: Correspondence Recipient for Contract object assignment10RECEIVERBRF Expression: Business Partnernvarchar200
62DPSOB_BP_ACC_CORCorrespondence Control for Contract Object8RECEIVERCorrespondence Recipient IDnvarchar100
TOPQuestion Answer Database
63SCQADBRECVRecipient of Q&Adb Questionnaire2RECEIVERE-Mail Addressnvarchar610
TOPReporting
64MCRSV_USRSelection version: Assigned distribution lists or users4RECEIVERAssigned distribution list or user for selection versionnvarchar120
TOPRuntime WorkbenchMonitoring
65SXMSPFAGGIntegration Engine: Aggregated Data for Performance Display2RECEIVERGUID for Integration Engine Objectsvarbinary160
66SXMSPFRAWHIntegn Eng: Header Table for Raw Data for Performance Evaln2RECEIVERGUID for Integration Engine Objectsvarbinary160
67SXMSPMIRAWIntegration Engine: Performance Data Extracted from PMI5RECEIVERGUID for Integration Engine Objectsvarbinary160
TOPSales Returns
68/BEV1/SR_MAILExpress Mail Recipient for Background Processing3RECEIVERUser Name in User Master Recordnvarchar120
TOPServices
69SDENDPOINTSXI: Endpoints2RECEIVERReceiver Systemnvarchar600
70SDSECURITYXI: Security2RECEIVERReceiver Systemnvarchar600
TOPTraders and Schedulers Workbench
71OIJHCT01OIL-TSW: Ticket Holding Table (Draft version 1) - OBSOLETE20RECEIVERLocation Partnernvarchar100
72OIJNOMHNomination Header92RECEIVERReceivernvarchar100
73OIJ_EL_TICKET_IUniversal ticket item table15RECEIVERLocation Partnernvarchar100
TOPTransport Organizer
74GTABKEY_MAILGTABKEY Mail Recipient3RECEIVERLast Changed bynvarchar120
TOPTravel Expenses
75PTRV_DOC_HDTransfer Travel -> FI/CO: Header of TRV int. document17RECEIVERLogical systemnvarchar100
TOPUse Subcomponents
76SOEPSAPoffice: Table for data transfer during express handling1RECEIVERSAP name of a SAPoffice usernvarchar120
77SOFRSAPoffice: Distribution List Table for Incoming Faxes8RECEIVERSAPoffice: Recipient name/name of the distribution listnvarchar120
78SOXPSAPoffice: Table for data transfer during express handling2RECEIVERSAP name of a SAPoffice usernvarchar120