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

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/CCEE/FISC_REQFiscalization Croatia: Communication Log Request8DIRECTDirection for IDocnvarchar10
2/CCEE/FISC_RESFiscalization Croatia: Communication Log Response8DIRECTDirection for IDocnvarchar10
3/OTEI/T_DLEIM: Additional views for DL7DIRECTEFM: Direct access to DLnvarchar10
4/SDF/IVISALEPNDGALE messages stuck in tRFC4DIRECTDirection for IDocnvarchar10
5/WSCGMBH/LOGSKommunikationsprotokolle6DIRECTRichtungsanzeigenvarchar10
6IDXLOGIDoc Adapter RFC Logging4DIRECTSingle-Character Indicatornvarchar10
7IDXLOGDC40IDoc Adapter RFC Logging EDI_DC408DIRECTDirectionnvarchar10
8IDXLOG_ADMConfiguration: IDoc Adapter RFC Logging4DIRECTSingle-Character Indicatornvarchar10
9TBDDAAGMESSAGEResidence Times for Message Types or Partners8DIRECTDirection for IDoc transmissionnvarchar10
10TFITHSAPfind: Terms for CUA Access to FIND4DIRECTFastpathnvarchar10
11TOACUSAP ArchiveLink Customizing table22DIRECTDisplay Documents Directly or Using Hit Listnvarchar10
TOPABAP Authorization and Role Management
12AGR_TCODE3Assignment of roles to Tcodes6DIRECTFlag to show that the transaction was input directlynvarchar10
13AGR_TCODESAssignment of roles to Tcodes6DIRECTFlag to show that the transaction was input directlynvarchar10
TOPALE Integration Technology
14EDBDMSKYEDI/ALE: Map CCMS Key to IDoc Attributes3DIRECTDirection for IDocnvarchar10
15EDIDCControl record (IDoc)6DIRECTDirection for IDocnvarchar10
16EDIDOCINDXControl record (IDoc)6DIRECTDirection for IDocnvarchar10
17EDIFCTIDoc: Assignment of FM to log. message and IDoc type9DIRECTDirection for IDocnvarchar10
18EDIMAPEDI: Assignment Table Between IDoc and Application Fields5DIRECTDirection (1=outbound, 2=inbound)nvarchar10
19EDIPHONETelephony Data for Partner Profiles5DIRECTDirection for IDocnvarchar10
20EDMAPDocumentation for R/3 <-> IDOC type assignments5DIRECTDirection (1=outbound, 2=inbound)nvarchar10
21EDPPVProposal Values for Partner Fast Entry3DIRECTDirection for IDocnvarchar10
22IDOCSTYLETable of Style IDs with the Objects to Be Loaded3DIRECTDirection for IDocnvarchar10
23TBDRCSTATEObjects in recovery environment (ALE)3DIRECTDirection for IDocnvarchar10
24TEDS1IDoc status values3DIRECTDirectionnvarchar10
TOPContract Accounts Receivable and Payable
25DFKKWLI_CORRCorrespondence - Not Used - Attachm. Stored in DFKKDOC_CON7DIRECTDirection of Correspondencenvarchar10
TOPDistribution Unit Distribution Packet
26DELIVERYReplication Table10DIRECTALE Distribution Packet: Distribution Directionnvarchar10
27DSPHDRALE Distribution Packet : Header data3DIRECTALE Distribution Packet: Distribution Directionnvarchar10
28TUPS04ALE Distribution Unit: Settings for Job Processing3DIRECTALE Distribution Packet: Distribution Directionnvarchar10
29UPSHDRALE Distribution Unit: Header Data3DIRECTALE Distribution Packet: Distribution Directionnvarchar10
TOPDownloadUpload
30/DSD/HH_RACOCIHDDSD Route Settlement: Check-Out / Check-In - Header data4DIRECTDSD - RA: Direction - Check-Out or Check-Innvarchar10
TOPLocalization
31J_1BAANota Fiscal type4DIRECTDirection of the movementnvarchar10
32J_1BAOCFOP determination for incoming movements and their return2DIRECTDirection of the movementnvarchar10
33J_1BAONCFOP Determination Incoming and their Returns (versioned)2DIRECTDirection of the movementnvarchar10
34J_1BAOXCFOP det. for incoming mov. and their return (exceptions)2DIRECTDirection of the movementnvarchar10
35J_1BAPCFOP determination for outgoing movements and their return2DIRECTDirection of the movementnvarchar10
36J_1BAPNCFOP Determination Outgoing and their Returns (versioned)2DIRECTDirection of the movementnvarchar10
37J_1BAPXCFOP det. for outgoing mov. and their return (exceptions)2DIRECTDirection of the movementnvarchar10
38J_1BNFDOCNota Fiscal Header5DIRECTDirection of the movementnvarchar10
39J_1BNFE_ACTIVEElectronic Nota Fiscal: Actual Status27DIRECTDirection of the movementnvarchar10
40J_1BNFLINNota Fiscal line items39DIRECTDirection of the movementnvarchar10
TOPMaintenance Processing
41/ISDFPS/PM_UPSCCommands for UPS Processing2DIRECTALE Distribution Packet: Distribution Directionnvarchar10
42/ISDFPS/PM_UPSCTCommands for UPS Processing - Description3DIRECTALE Distribution Packet: Distribution Directionnvarchar10
TOPMaterial Master
43EANC_IOPROCESSTable in Which the Processes to be Mapped are Defined3DIRECTDirection for IDocnvarchar10
TOPPackage Tools
44AKB_PRODUCT_COMPObsolete: Product Composition5DIRECTGeneral Flagnvarchar10
TOPRepository Infosystem
45WBCROSSGTIndex for Global Types - Where-Used List Workbench4DIRECTRepository Info System: Grade of Usenvarchar10
46WBCROSSGTIIndex Global Types for Inactive Objects Where-Used List4DIRECTRepository Info System: Grade of Usenvarchar10
TOPRisk Analysis
47JBRANTYPERM: Evaluation Category (Internal for Program Generation)2DIRECTRM: Generate Directly Executable Report for Evaluation Cat.nvarchar10
TOPSAP Retail Store
48WSTI_PDC_EVENTRetail Store Physical Inventory: PDC Transactions10DIRECTDirection for IDocnvarchar10
TOPSelf-Billing Proced.
49TRNSMData Transfer7DIRECTDirection for IDocnvarchar10
TOPSpecification 2
50SPCM_DISP_MENUAction table for A&D Displaytool (menu)6DIRECTDirection for IDocnvarchar10
TOPStock Visibility
51/DSD/SV_RACOCIHDDSD SV: Check-Out/Check-In - Header Data4DIRECTDSD - RA: Direction - Check-Out or Check-Innvarchar10