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
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPCH386A/P Invoice
8OVTG52Tax Definition
9OPOR386Purchase Order
10JDT1124Journal Entry - Rows

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OVPM154Outgoing Payments
5OIVL77Whse Journal
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

141 columns | Print definition?ERP 6.0  | DIRECTION

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/GEOE/GISMSGMessage Table4DIRECTIONDirection (Target System)nvarchar10
2/GEOE/GISMSGARCMessage Table - Archive: succesfully processed commands4DIRECTIONDirection (Target System)nvarchar10
3/GSINS/NLG_FILESGBA NL: Values of Importing/Exporting Reports6DIRECTIONReport Run Direction (Importing/Exporting)nvarchar10
4/GSINS/NLG_FIMSGGBA NL: Link Import/Export Report to Incoming/Outgoing Msg5DIRECTIONReport Run Direction (Importing/Exporting)nvarchar10
5/IWBEP/I_SBD_MPSB: DM node Mapping Attribute8DIRECTIONMapping Directionnvarchar10
6/MRSS/M_CHECK_ORMirror for MRS Checks While Saving Order5DIRECTIONTransfer Directionnvarchar10
7ARBERP_C_MSGCUSTDefine Document-Specific Message Customizing4DIRECTIONMessage directionnvarchar30
8ARBERP_I_DFTXTAllowed data flows for text mapping via configuration5DIRECTIONMessage directionnvarchar30
9ARBFND_C_MSGCUSTcXML Message Configuration5DIRECTIONMessage directionnvarchar30
10ARBFND_I_APPMSGTAssignment of cXML Message Type to Application Component ID3DIRECTIONMessage directionnvarchar30
11ARBFND_I_PROCApplication processing (outbound and inbound)4DIRECTIONMessage directionnvarchar30
12ARBFND_I_TRFMTransformation (for outbound and inbound processing)3DIRECTIONMessage directionnvarchar30
13BBPC_SUS_TEXTSUS: Definition of UI Texts5DIRECTIONCommunication Directionnvarchar10
14CCGLT_PR_HDR_UT2EHS: Print Request Header Table Test Data for Unit Test5DIRECTION30 Charactersnvarchar300
15CCGLT_PR_PAR_UTEHS: Print Request Parameters Test Data for Unit Tests5DIRECTION30 Charactersnvarchar300
16CCGLT_PR_SLS_UTEHS: Print Request Sequential Data Test Data for Unit Tests3DIRECTION30 Charactersnvarchar300
17CCGLT_PR_SNO_UTEHS: Print Request Sequence Numbers Test Data for Unit Tests3DIRECTION30 Charactersnvarchar300
18EPIC_CBCEPIC:Cash budgeting control consumption table16DIRECTIONCredit or Debit Indicator for Cash Budget Amountnvarchar10
19EPIC_CBC_EBRCash Budgeting Control of Bank Receipt10DIRECTIONCredit or Debit Indicator for Cash Budget Amountnvarchar10
20EPIC_CB_PLANEPIC: Cash Budgeting planning DB Table5DIRECTIONCredit or Debit Indicator for Cash Budget Amountnvarchar10
21EPIC_DUM_TRANSACTransactions of Dummy Bank9DIRECTIONSingle-Character Indicatornvarchar10
22EPIC_EBR_HDROBSOLETE!!!36DIRECTIONDirection of Bank Receipt Transactionnvarchar10
23FIKZ_FILE_TBLFiles for invoice journal record8DIRECTIONDocument directionnvarchar30
24J_1UFDI_FILE_TBLFiles for tax document register record8DIRECTIONDocument Directionnvarchar10
25J_3RFDI_ARCTable for archiving and logging digital invoices12DIRECTIONDocument directionnvarchar30
26J_3RFDI_DEADLINEDeadline for Digital Invoices3DIRECTIONDocument directionnvarchar30
27J_3RF_DI_TRANFTransformations for digital invoice processing2DIRECTIONDocument directionnvarchar30
28J_3RF_RGTORG_IFSIndex Electronic Documents File Storage11DIRECTIONDocument directionnvarchar30
29LTR_DELIM_LINKLTR: Delimitation Option - Links8DIRECTIONLTR: Direction of a Link Delimitationnvarchar10
30P2RX_RT_GPPayroll Result: Payroll for Global Employees14DIRECTIONExchange from Receiving to Sending or Vice Versanvarchar20
31SRAL_EXP_LOGRAL expanded log - header table8DIRECTIONRead Access Logging: Directionnvarchar10
32SRAL_FIELDS_WSRAL: Channel specific fields4DIRECTIONRAL: Web Service Message Direction Indicatornvarchar30
33SRAL_LOGRead Access Logging: Log6DIRECTIONRead Access Logging: Directionnvarchar10
34SRAL_LOG_PERFRead Access Logging: Log (modified version for performance)6DIRECTIONnvarchar10
35TRQT_OTC_LOTTreasury: OTC Lot (Subposition of OTC Lot Position)4DIRECTIONDirection of Transactionnvarchar10
36T7PIQSCALEAcademic Scales4DIRECTIONDisplay Direction of Scale Valuesnvarchar10
TOPALE Integration Technology
37IDXSLOADIDoc Adapter Administration14DIRECTIONDirection for IDocnvarchar10
TOPAP-LIM Logistics Inventory Management Engine
38/LIME/COLL_APSCollection for Planning System11DIRECTIONDirection of Movement (In/Out/Transfer)nvarchar10
39/LIME/COLL_BWCollection for Business Warehouse11DIRECTIONDirection of Movement (In/Out/Transfer)nvarchar10
40/LIME/COLL_FINCollection for Financial System11DIRECTIONDirection of Movement (In/Out/Transfer)nvarchar10
41/LIME/COLL_INVCollection for Inventory System11DIRECTIONDirection of Movement (In/Out/Transfer)nvarchar10
42/LIME/COLL_LEGCollection for External System11DIRECTIONDirection of Movement (In/Out/Transfer)nvarchar10
43/LIME/COLL_MMIMCollection for R/3 Inventory Management11DIRECTIONDirection of Movement (In/Out/Transfer)nvarchar10
44/LIME/COLL_W2IMCollection for WME after ERP-MMIM11DIRECTIONDirection of Movement (In/Out/Transfer)nvarchar10
45/LIME/MMIM_BWARTDetermination of Movement Types for R/3 MM-IM Dispatcher2DIRECTIONDirection of Movement (In/Out/Transfer)nvarchar10
46/LIME/PN_ITEMTable to Save Prima Nota Item Data64DIRECTIONDirection of Movement (In/Out/Transfer)nvarchar10
TOPBack Office
47TRSC_SECACCTRANSTreasury: Update Type for Securities Account Transfer5DIRECTIONTR: Sec.Acct Management: Direction of Sec.Acct Transfer Flownvarchar10
TOPBasic functions
48COMC_IL_UICustomizing Table for Relationship Type Interface2DIRECTIONDefines the Direction of a Directed Relationshipnvarchar10
49VEVWWhere-Used List for Handling Units6DIRECTIONDirection (1=outbound, 2=inbound)nvarchar10
TOPCentral Part of Product Master
50COMC_PRWB_ILProduct Workbench: Assignment of Relship Type to Object Type4DIRECTIONDefines the Direction of a Directed Relationshipnvarchar10
51COMM_PRWBIL_USERUser Settings for Interlinkages in the Product Workbench5DIRECTIONDefines the Direction of a Directed Relationshipnvarchar10
TOPClaims Management
52ICLVISIONVision Findings8DIRECTIONAlignment (Left/Right)nvarchar10
53ICSVISIONEyeglass Prescription8DIRECTIONAlignment (Left/Right)nvarchar10
TOPClinical System
54N2COMM_LOGDocuments Received in Temporary Storage5DIRECTIONDirection of Communicationnvarchar30
55N2COMM_LOGSTATLast Known Status for Transmitted Object5DIRECTIONDirection of Communicationnvarchar30
56TN2CCF_CONCCF: Connectors4DIRECTIONUsage of Connector (Start/End/Both)nvarchar50
TOPCorporate Performance Monitor
57UMK_MB100Key Figures: Header Table16DIRECTIONDesired Changenvarchar10
TOPCustomer Contact
58BPCT_CRM_DIRECTCreation of Contact Direction from Contact -> Activity3DIRECTIONCRM Direction of Activitynvarchar10
TOPDenmark
59T5M_LO_INTERFACELoans: Relationship: WT & Pseudo-Split and Generated WT1DIRECTIONFirst parameternvarchar40
TOPDistributed Maintenance
60/ISDFPS/PMCPRUNTransfer Change Authorization - Runtime Data3DIRECTIONTransfer Directionnvarchar10
61/ISDFPS/PMDISRHDistribution Factory - Runtime Data3DIRECTIONDirection of Transfernvarchar10
TOPDSD Connector
62/DSD/ME_TRANSDSD Connector: Transaction Management with Mobile Devices4DIRECTIONDSD Connector: Transaction Directionnvarchar10
TOPEmployee Interaction Center
63THREIC_CONTACTEIC Contact5DIRECTIONEIC: Communication Directionnvarchar10
TOPEnterprise SOA
64BSSOA_IAS_SEQInApplicationSequencing: Current Message Counter4DIRECTIONSequencing Information: Direction of Interface Callnvarchar10
TOPEnvironment, Health and Safety
65/TDAG/RCSC_PNAVOBSOLETE: Portal Navigation Configuration2DIRECTIONPortal Navigation Directionnvarchar20
TOPExchange Infrastructure
66SXMSAEAGGXI: Adapter Runtime Data (Aggregated)2DIRECTIONXI Services: Call Directionnvarchar10
TOPExcise Duty
67/BEV2/CS_HDEMCS Process: Header Data5DIRECTIONInbound/Outbound Indicatornvarchar10
68/BEV2/CS_HD_HEMCS Process: Header Data - History6DIRECTIONInbound/Outbound Indicatornvarchar10
69/BEV2/CS_MSGEMCS Process: Messages5DIRECTIONInbound/Outbound Indicatornvarchar10
TOPFinancial Services
70PSJ_D_STEPPSJ: Journal Entries6DIRECTIONMessage Direction for Log Entrynvarchar10
TOPFinancials Basis
71UGMD1201FIN Master Data: Role Sub-objects7DIRECTIONType of Relationship between Object and Sub-objectnvarchar10
72UGMDL1201FIN Master Data: Local Roles, Subobjects8DIRECTIONType of Relationship between Object and Sub-objectnvarchar10
TOPFSCM In-House Cash
73IHC_TAB_TRANSIHC: Transaction Types4DIRECTIONBank Transfernvarchar10
TOPGeneric Project Planning
74CGPL_MAPPINGMapping of SAP App. Field to MS Project7DIRECTIONDummy for B20 int1 (Local Everywhere)tinyint30
TOPGlobal Trade Services
75/SAPSLL/IVMCSL01Individual Stock Item, Special Customs Proced. - Change Log5DIRECTIONDirection of Stock Movementnvarchar10
76/SAPSLL/IVMCSL02Totals Stock, Special Customs Procedures - Change Log5DIRECTIONDirection of Stock Movementnvarchar10
77/SAPSLL/IVMFSL01Change Log for Individual Stock item Free Circulation f. PEU5DIRECTIONDirection of Stock Movementnvarchar10
78/SAPSLL/IVMPSL01Processing Stock: Log of Changes5DIRECTIONDirection of Stock Movementnvarchar10
79/SAPSLL/LCLICAQLLicense: Change Log: Available Quantity8DIRECTIONDirection of Stock Movementnvarchar10
80/SAPSLL/LCLICAVLLicense: Change Log of Available Quantity8DIRECTIONDirection of Stock Movementnvarchar10
81/SAPSLL/PRTAXLegal and Logistics Services: Product Master - Tax Groups7DIRECTIONImport/Export Indicator (Inclusive)nvarchar10
TOPGraphic
82TGSUOSAP Structural Graphics: User-Specific Settings8DIRECTIONAlignment of structure (before rotation)nvarchar10
83TGSUVSAP Structural Graphics: User-Specific Settings9DIRECTIONAlignment of structure (before rotation)nvarchar10
TOPIntercompany Data Exchange
84ECOMEVENTCommunication Events2DIRECTIONDirection for IDocnvarchar10
85EIDESWTMSGDATAMessage Data for Switch Document8DIRECTIONDirection of Data Exchangenvarchar10
86EIDESWTMSGTMPTemporary Switch Document Message Data7DIRECTIONDirection of Data Exchangenvarchar10
TOPliveCache Applications
87MMRP_DATEVECSKey: Date Vector (Only in the liveCache)7DIRECTIONForward Schedulingnvarchar10
TOPMaintenance Orders
88/MRSS/C_CHECK_ORMRS Checks While Saving Order3DIRECTIONTransfer directionnvarchar10
TOPMapping
89SMPPCASEXI Mapping: Automatic Test Cases10DIRECTIONDirectionint100
90SMPPMAPMapping Runtime: Mapping4DIRECTIONDirectionint100
91SMPPMAP3Mapping Runtime: Mapping5DIRECTIONDirectionint100
TOPPersonnel Administration
92T539UYearly wage calculation in Basic Payments (Infotype 0008)3DIRECTIONSingle-Character Indicatornvarchar10
TOPProcess Orchestration for Built-In Processes
93POC_C_PS_INTProcess Definition: Integration Point Assignment7DIRECTIONIntegration Type Direction (In/Out)nvarchar10
94POC_C_PS_INT_RESProcess Definition: Integration Point Restrictions7DIRECTIONIntegration Type Direction (In/Out)nvarchar10
95POC_D_PRC_IPProcess Registry: Integration Points7DIRECTIONIntegration Type Direction (In/Out)nvarchar10
96POC_D_PRC_IP_RProcess Registry: Integration Points with Restrictions7DIRECTIONIntegration Type Direction (In/Out)nvarchar10
TOPProxy Generation
97SPROXDATProxy Metadata (Substitution Table)48DIRECTIONProxy Generation: Interface Direction (Inbound/Outbound)nvarchar10
98SPROXHDRProxy Header Data (substitution table)20DIRECTIONProxy Generation: Interface Direction (Inbound/Outbound)nvarchar10
TOPReal Estate Management
99TIVDIRECTransfer/Retirement3DIRECTIONTransfer/retirementnvarchar10
100VIOB35Productive Holdings4DIRECTIONTransfer/retirementnvarchar10
TOPRelationships Between Objects with GUID Identification
101COMC_IL_TYPE_TRelationship Type Description3DIRECTIONDefines the Direction of a Directed Relationshipnvarchar10
102COMC_IL_TYPE_TXTRelationship Type Description4DIRECTIONDefines the Direction of a Directed Relationshipnvarchar10
TOPResourcen Management
103FRMLT20RMS-FRM: Connection Table BOM - Formula (LoM)9DIRECTIONSource of Generation BOM<->LoMnvarchar10
104RMXTC_T30Process Parameter Assignment: Mapping Modules RM to PP-PI4DIRECTIONDirection of Assignmentnvarchar10
TOPSales Activities
105TVKKSales Activity Types37DIRECTIONDirection of sales activity: Inbound / outboundnvarchar10
106VBKASales Activities54DIRECTIONDirection of sales activity: Inbound / outboundnvarchar10
TOPSAP Business Workflow
107SWXTRABOOKFlight Bookings and Offers3DIRECTIONDirection of Flightnvarchar10
TOPSAP NetWeaver Mobile - Use subcomponents
108MEMON_TECH_CONAGS Monitoring: Resource Consumtion Monitor12DIRECTIONIn/Outbound Indicator (Link to Inbox/Outbox)nvarchar10
109MEMON_TECH_OBJAGS Monitoring: Main data technical Monitor (item list)9DIRECTIONME: AGS - Direction of the header - (I)nbound - (O)utboundnvarchar10
110MEREP_503Conversation Worklist2DIRECTIONIn/Outbound Indicator (Link to Inbox/Outbox)nvarchar10
111MEREP_504Inbox/Outbox Data2DIRECTIONIn/Outbound Indicator (Link to Inbox/Outbox)nvarchar10
112MEREP_505Inbox/Outbox Worklist2DIRECTIONIn/Outbound Indicator (Link to Inbox/Outbox)nvarchar10
113MEREP_601Job Table5DIRECTIONIn/Outbound Indicator (Link to Inbox/Outbox)nvarchar10
114MEREP_DSD001Sync Type master2DIRECTIONMEREP_DSD_DIRECTIONnvarchar10
TOPSAP Records Management
115SRM_ASC_DESCManagement Table for Performance Optimization2DIRECTIONNatural Numberint100
TOPService Implementation Workbench
116TSIW_SXF_FIELDSignature Exchange Format - Field10DIRECTIONDirection of Service Operationnvarchar50
TOPServices
117FINB_SIGNATUREFunction Builder5DIRECTIONImport/Exportnvarchar60
118SSRVBINDINGXI Services: Bindings10DIRECTIONXI Services: Call Directionnvarchar10
119SSRVCHANNELXI Services: Channels15DIRECTIONXI Services: Call Directionnvarchar10
TOPSpecification 2
120SPCMPRTNRINFPartner Information for SPEC 2000 message4DIRECTIONDirection for IDocnvarchar10
121SPCPRTNRINFPartner Information for SPEC 2000 message4DIRECTIONDirection for IDocnvarchar10
TOPTransaction Management
122VTBMDMAPCFM: Mirror Transaction - Map PType/TType in Meta Name6DIRECTIONDirection of Data Flownvarchar10
TOPTransaction Manager
123IDCFM_BST_CFMAVCustomizing for Balance Sheet Transfer with VA (obsolete)10DIRECTIONDirection of flownvarchar10
124IDCFM_BST_CFMITCustomizing for Balance Sheet Transfer for Brazil (obsolete)9DIRECTIONDirection of flownvarchar10
125IDCFM_BST_CFMIT1Customizing for Balance Sheet Transfer for Brazil (obsolete)9DIRECTIONDirection of flownvarchar10
126IDCFM_BST_CUSAVCustomizing for Balance Sheet Transfer for Brazil (obsolete)10DIRECTIONDirection of flownvarchar10
127IDCFM_BST_CUSTITCustomizing for Balance Sheet Transfer for Brazil9DIRECTIONDirection of flownvarchar10
128TCORFTS_MAP_OBJMapping Objects1DIRECTIONMapping Directionnvarchar10
129TCORFTS_MAP_RULEMapping Rules1DIRECTIONMapping Directionnvarchar10
130TCORT_COCorrespondence Administrative Data25DIRECTIONDirection of correspondencenvarchar10
131TCORT_CODCODeal: Conditions8DIRECTIONDirection of Transactionnvarchar10
132TCORT_CODCOFODeal: Condition's Formula9DIRECTIONDirection of Transactionnvarchar10
133TCORT_CODPIDeal: Payment Information6DIRECTIONDirection of flownvarchar10
134TCORT_CODULCODeal : Underlying's Conditions14DIRECTIONDirection of Transactionnvarchar10
135TCORT_CODULCOFODeal: Underlying's Formula11DIRECTIONDirection of Transactionnvarchar10
TOPUse Subcomponents
136SOSTSAPoffice: Status log table29DIRECTIONSpecifies whether status applies to sending or receivingnvarchar10
TOPWeb Service and SOAP - ABAP
137SRT_MONILOG_DATASOAP Runtime Table for Monitoring and Log Data Records22DIRECTIONSOAP Web Service Direction (Inbound, Outbound)nvarchar10
138SRT_MONLOG_DATA2SOAP Runtime Table for Monitoring and Log Data Records22DIRECTIONSOAP Web Service Direction (Inbound, Outbound)nvarchar10
139SRT_TEST_PERFResults of the SRT Performance Tests19DIRECTIONSOAP Web Service Direction (Inbound, Outbound)nvarchar10
TOPWork Clearance Management
140WCCOWCM: WCM Object8DIRECTIONDirection According to Architecturenvarchar20
141WCCPWCM: WCM Object <-> Approvals8DIRECTIONDirection According to Architecturenvarchar20