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

64 columns | Print definition?ERP 6.0  | SENDER

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/GRCPI/GRIANOTCNotification Messages (Customer)5SENDERSendernvarchar120
2/GRCPI/GRIANOTFNotification Messages (Defaults)4SENDERSendernvarchar120
3/GSINS/NLG_INAGBA Interface: Incoming Message Header8SENDERGBA Interface: Message Sendernvarchar40
4/OPT/X004Table for Email Templates6SENDERUser Namenvarchar120
5/OPT/Y004Table for Email Templates6SENDERUser Namenvarchar120
6/OPT/Z004Table for Email Templates6SENDERUser Namenvarchar120
7BBPT_IMS_LOGIMS Log Data Table6SENDERUser Namenvarchar120
8EDIQIDESTAssignment of bgRFC Queue Names and Destination2SENDERPartner Number of Sendernvarchar100
9NWS_EXT_MAP_DATAMapping Data Extract ByD12SENDERField Namenvarchar300
10TIVXCITF24PYMNTF24 Payment Data3SENDERSender Codenvarchar50
TOPAccounts Receivable Accounting Process Integration
11TEBPP_REC_INVSAP Biller Direct: Bill Receipt Processing2SENDERSAP Biller Direct: Billernvarchar200
12TEBPP_REC_INV_ASAP Biller Direct: Bill Receipt Processing: Archive2SENDERSAP Biller Direct: Billernvarchar200
13TEBPP_REC_INV_ISAP Biller Direct: Bill Receipt Processing: IDoc2SENDERSAP Biller Direct: Billernvarchar200
TOPALE Integration Technology
14TBDTPBALE Template: BAPI Interfaces2SENDERALE partnernvarchar100
15TBDTPBDFALE Template: Parameter Filtering for BAPIs2SENDERALE partnernvarchar100
16TBDTPBDRALE Template: Reduction for BAPIs2SENDERALE partnernvarchar100
17TBDTPBDRFALE Template: Fields in Reduced Parameter2SENDERALE partnernvarchar100
18TBDTPBRALE Template: Receiver Determination for BAPIs2SENDERALE partnernvarchar100
19TBDTPMALE Template: Message Type Interfaces2SENDERALE partnernvarchar100
20TBDTPMDALE Template: Data Filters for Message Types2SENDERALE partnernvarchar100
TOPAuthentication and SSO
21SAML2_ARTIFACTStorage Table for SMAL2 Artifacts5SENDERSAML2 Entity ID Keyvarbinary160
22SAML2_REQUESTStorage Table for SAML2 Requests and RelayState3SENDERSAML2 Entity ID Keyvarbinary160
TOPBroadcast Messaging
23CRMD_BM_MESCRM broadcast messaging runtime table for messages3SENDERUser Name in User Master Recordnvarchar120
TOPCollaboration Folders
24CFX_NTF_CONTENTCollaboration Folders: Content Data of Notifications6SENDERSender of a Notificationnvarchar120
TOPConfiguration management
25TCMFOLDERSTable for sending CM folders3SENDERUser Namenvarchar120
TOPCross-Application Components
26FRE_BIF_OPH_INInbound interface table order proposal header20SENDERLogical Systemnvarchar100
27FRE_BIF_OPI_INInbound Interface Table Order Proposal Item44SENDERLogical Systemnvarchar100
28FRE_IF_HEADERR/3 Outbound Header Interface Table11SENDERLogical Systemnvarchar100
29FRE_IF_ITEMF&R Order Outbound IF: internal Item Table34SENDERLogical Systemnvarchar100
TOPDay-to-Day Activities
30LSOCRPCNTXTPRTCLLSO Correspondence: Log Area40SENDERSender ID for Business Partner Simulationnvarchar100
TOPDefault Risk and Limit System
31KLLIMITEXCEEDEDManagement of Exceeded Limits per Product/Transaction Type7SENDERSender of a Workflownvarchar120
32KLRECEIVERUser-Recipient Relationship2SENDERSender of a Workflownvarchar120
TOPDunning
33T047IStandard texts for dunning notices11SENDERSmart Forms: Name of Sender Text in Text Processingnvarchar300
TOPEnergy Data Management
34EEDMPROSENDRecording of Sent Profiles10SENDERSender (Service Provider)nvarchar100
35EEDMSETTLDOCSNDSSettlement Document (Sent Profiles) Status6SENDERName of Agentnvarchar120
TOPFinancial Accounting
36/OPT/BL_EMAIL_TMTable for Email Templates6SENDERUser Namenvarchar120
37T001GCompany Code-Dependent Standard Texts12SENDERSmart Forms: Name of Sender Text in Text Processingnvarchar300
TOPFinancial Supply Chain Management
38IHC_PI_INB_ACCTSPI: Clearing Partner Details for Inbound IDOC5SENDERPartner Number of Sendernvarchar100
TOPFinancials Basis
39UBC_TB_CEDATACost Events3SENDERSystem Provider IDnvarchar200
TOPFSCM In-House Cash
40IHC_DB_INB_ACCTSClearing Partner Details for PEXR20025SENDERPartner Number of Sendernvarchar100
41IHC_TAB_GUI_FLDIHC: Container Field in GUI6SENDERPayer/Beneficiary Tab Pagenvarchar10
42IHC_TAB_GUI_MAPIHC: Mapping Table for GUI11SENDERPayer/Beneficiary Tab Pagenvarchar10
TOPGovernance, Risk and Compliance
43GRFNNOTIFYMSGNotification Messages (Defaults)4SENDERSendernvarchar120
44GRFNNOTIFYMSGCNotification Messages (Customer)5SENDERSendernvarchar120
TOPIntegration Engine
45SXMSMSGDEFMessage Definition4SENDERSender/Receiver IDnvarchar300
46SXMSMSGREFMessage Reference Storage6SENDERXI: Servicenvarchar600
TOPIntercompany Data Exchange
47ECOMCONTROLSPCommunication Control Based on Service Providers6SENDERSender (Service Provider)nvarchar100
48EREFDISSUPReference Between Supplier and Distributor Documents2SENDERService Providernvarchar100
TOPMapping
49SMPPCASEXI Mapping: Automatic Test Cases5SENDERSender Systemnvarchar600
TOPProduct Data Management
50CEPFOLDERSTable of CM folder for CEP scenario3SENDERUser Namenvarchar120
TOPRecords and Case Management
51RMPSGENSPHISTHistory Table for Generic SP Objects11SENDERSender of Incoming Post Itemnvarchar100
TOPReuse Services for Country Development
52T50F0HR-FORMS: Assignment of Standard Texts to Forms5SENDERHR-FORMS: Standard text for sendernvarchar300
TOPRuntime WorkbenchMonitoring
53SXMSPFAGGIntegration Engine: Aggregated Data for Performance Display1SENDERGUID for Integration Engine Objectsvarbinary160
54SXMSPFRAWHIntegn Eng: Header Table for Raw Data for Performance Evaln1SENDERGUID for Integration Engine Objectsvarbinary160
55SXMSPMIRAWIntegration Engine: Performance Data Extracted from PMI4SENDERGUID for Integration Engine Objectsvarbinary160
TOPSAP NetWeaver Mobile - Use subcomponents
56MEMPAMONITORAlert ID: Reply Details for MPA5SENDERUser Name in User Master Recordnvarchar120
TOPServices
57SDENDPOINTSXI: Endpoints5SENDERSender Systemnvarchar600
58SDSECURITYXI: Security5SENDERSender Systemnvarchar600
TOPSpecification 2
59SPCMPRTNRINFPartner Information for SPEC 2000 message2SENDERSender Name for SPEC 2000 message headernvarchar100
60SPCPRTNRINFPartner Information for SPEC 2000 message2SENDERSender Name for SPEC 2000 message headernvarchar100
TOPStructural Graphics
61T777NAME2SHR Namespace: Required Entries for Systems4SENDERUser Namenvarchar120
TOPTraders and Schedulers Workbench
62OIJNOMHNomination Header90SENDERSendernvarchar100
TOPUse Subcomponents
63SOMGTable for persistence of objects MESSAGE/RECIPIENT28SENDERObject IDnvarchar900
64SOSTSAPoffice: Status log table28SENDERAuthor of status (address object)nvarchar300