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

51 columns | Print definition?ERP 6.0  | VERS

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1FIKZ_FILE_TBLFiles for invoice journal record9VERSXML format versionnvarchar70
2J_1UFDI_FILE_TBLFiles for tax document register record9VERSXML format versionnvarchar80
3J_3RFDI_ARCTable for archiving and logging digital invoices15VERSXML format versionnvarchar70
4J_3RF_RGTORG_IFSIndex Electronic Documents File Storage12VERSXML format versionnvarchar70
5T5C55Conversion Denomination Key3VERSVersionnvarchar40
6T5TPENSAVData for pension savings14VERSVersionnvarchar20
7T5TPENSAV_YSPension savings - annual reporting14VERSVersionnvarchar20
8T5TS0Central storage of XML documents3VERSVersionnvarchar20
9T5VF1Altinn Communication Framework - Document storage3VERSACF - Versionnvarchar20
TOPAustria
10T5AB0Sick Leave Certificate: ELDA Opening and Closing Record16VERSELDA: External Version Numbernvarchar20
TOPB2A Business to Administration
11T50C_XMLXML-Convesion routines6VERSXML-Schema versionnvarchar40
12T50G_XMLXML-Global Schema6VERSXML-Schema versionnvarchar40
13T50V_XMLXML-Versions8VERSXML-Schema versionnvarchar40
TOPBank
14BNKABank master record19VERSFormat of File with Bank Datanvarchar30
15T005BUTable for Transferring Bank Data2VERSFormat of File with Bank Datanvarchar30
16T005BUTTable for Transferring Bank Data3VERSFormat of File with Bank Datanvarchar30
TOPConsolidation
17TFIN000Independent Characteristic Values for Consolidation Type5VERSConsolidation (end-result) versionnvarchar30
18TFIN005Ledger Selection2VERSConsolidation (end-result) versionnvarchar30
TOPContract Accounts Receivable and Payable
19DFKKPTSAFTDEFObsolete! DO NOT USE1VERSPortugal: SAF-T Versionnvarchar100
TOPFlexible Real Estate Management
20TIVHOHBKIDIRWEG-Verwaltung Instandhaltungsrücklage Kontenvorschlag4VERSGitterversion Instandhaltungsrücklagen und Geldanlagen WEGnvarchar20
21TIVHOIRMandatsverw.: Instandhaltungsrücklage Konten/Vorschlagsw4VERSGitterversion Instandhaltungsrücklagen und Geldanlagen WEGnvarchar20
22TIVPRHSBZuordnung Gitterpositionen zu Bewegungen2VERSGitterversion Instandhaltungsrücklagen und Geldanlagen WEGnvarchar20
23TIVPRHSPGitterpositionen2VERSGitterversion Instandhaltungsrücklagen und Geldanlagen WEGnvarchar20
24TIVPRHSPTGitterpositionstexte3VERSGitterversion Instandhaltungsrücklagen und Geldanlagen WEGnvarchar20
25TIVPRHSVGitterversionen2VERSGitterversion Instandhaltungsrücklagen und Geldanlagen WEGnvarchar20
26TIVPRHSVTGitterpositionstexte3VERSGitterversion Instandhaltungsrücklagen und Geldanlagen WEGnvarchar20
TOPIntegration Engine
27SXMSCLUPXMB: Property Cluster5VERSSequence Number for a Message Log IDnvarchar30
28SXMSCLUP2XMB: Property Cluster (Switch Table)5VERSSequence Number for a Message Log IDnvarchar30
29SXMSCLURXMB: Resources Cluster5VERSSequence Number for a Message Log IDnvarchar30
30SXMSCLUR2XMB: Resources Cluster (Switch Table)5VERSSequence Number for a Message Log IDnvarchar30
31SXMSPMASTIntegration Engine: Message Queue (Master)37VERSSequence Number for a Message Log IDnvarchar30
32SXMSPMAST2XML Message Broker: Message Queue (Master) (Switch Table)37VERSSequence Number for a Message Log IDnvarchar30
33SXMSPVERSIntegration Engine: Message Version4VERSSequence Number for a Message Log IDnvarchar30
34SXMSPVERS2Integration Engine: Message Version (Switch Table)4VERSSequence Number for a Message Log IDnvarchar30
TOPLoans Management
35VDDD_HEADERLoans: Header Data - Lines Layout2VERSLayout Versionnvarchar10
36VDDD_HEADER_COLLoans: Header Data - Columns Layout2VERSLayout Versionnvarchar10
37VDDD_HEADER_VERLoans: Header Data - Version Layout2VERSLayout Versionnvarchar10
TOPMaintenance Notifications
38TQ80Notification Types68VERSVariants for Determining Existence of Notificationsnvarchar10
TOPMapping
39SMPPBINDMapping Parameterization: Binding5VERSXI Runtime: GUIDvarbinary160
40SMPPCONTTest for Mapping Parameterization8VERSXI Runtime: GUIDvarbinary160
41SMPPSTEPMapping Runtime: Mapping Step7VERSXI Runtime: GUIDvarbinary160
TOPNorway
42PA0173Tax card information43VERSTax Card versionnvarchar10
TOPPayroll
43T5HVCÉrvényes nyomtatványkódok (havi bevallás)7VERSHavi bevallás 2 - XML verziójanvarchar160
TOPPayroll General Parts
44T50FDHR: Time Dependency of Message Type Versions7VERSHR: Version of Notification Typenvarchar20
45T50FEHR: Mapping Internal and External Structure5VERSHR: Version of Notification Typenvarchar20
TOPPerformance Assessment Workbench
46SLS_ITEMPAW - Item Description13VERSPAW test versionnvarchar100
47SLS_PUPAW - Performance Unit13VERSPAW test versionnvarchar100
TOPRuntime WorkbenchMonitoring
48SXMSMSGINDLOGSAP XI: Indexing Log of Messages4VERSSequence Number for a Message Log IDnvarchar30
TOPSwitzerland
49T5C50Uniform Wage Notification Procedure: Control Data Extraction2VERSVersionnvarchar40
50T5C53Conversion Table Marital Status3VERSVersionnvarchar40
51T5C54Conversion Table Residence Status3VERSVersionnvarchar40