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

65 columns | Print definition?ERP 6.0  | DOCTYP

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1EHPRCC_DOCTYDCP: Description for document types1DOCTYPDocument Typenvarchar100
2EHPRCC_DOCTYPCP: Document types1DOCTYPDocument Typenvarchar100
3EHPRCC_INTPLIncoming Template16DOCTYPDocument Typenvarchar100
4FIAPSAD_ORDR_HDOrder Number Header KSA10DOCTYPDocument Typenvarchar10
5IDAR_TXDITMDocument item used in country specific taxation2DOCTYPDocument Type Used in Country-Specific Taxationnvarchar10
6J_1UF_REEI_XML_AXML table for J_1UF_REEI with User30DOCTYPDocument Typenvarchar70
7J_1UF_REP_XMLXML table for J_1UF_REP34DOCTYPDocument Typenvarchar70
8J_1UF_REP_XML_AXML table for J_1UF_REEI with User35DOCTYPDocument Typenvarchar70
9J_1UF_RES_XMLXML table for J_1UF_RES33DOCTYPDocument Typenvarchar70
10T7PIQ_NL_RESIDMMapping for SLM Residence Status to SL Status of residence4DOCTYPDocument Typenvarchar10
TOPALE Integration Technology
11EDIDCControl record (IDoc)5DOCTYPIDoc Typenvarchar80
12EDIDOValue table for IDoc types1DOCTYPIDoc type (for example, ORDERS01)nvarchar80
13EDIDOCINDXControl record (IDoc)5DOCTYPIDoc Typenvarchar80
14EDIDOTShort description of IDoc types1DOCTYPIDoc type (for example, ORDERS01)nvarchar80
15EDISYNSyntax Description for Extended Basic Types12DOCTYPIDoc typenvarchar80
16EDI_CNVDOCConversion Table for Field DOCTYP1DOCTYPIDoc Typenvarchar80
17EDMAPDocumentation for R/3 <-> IDOC type assignments1DOCTYPIDoc type (for example, ORDERS01)nvarchar80
18EDP13Partner Profile: Outbound (technical parameters)10DOCTYPIDoc typenvarchar80
19EDPO3EDI table for partner profiles (outbound), level 212DOCTYPIDoc typenvarchar80
20EDSYNIDoc syntax after 3.01DOCTYPIDoc type (for example, ORDERS01)nvarchar80
TOPAssortment List
21WDLSPPOS outbound log: IDoc (items)5DOCTYPIDoc Typenvarchar80
TOPBank Customer Accounts
22BKK45_CORRCorrespondence Receiver Administration9DOCTYPDocument Typenvarchar10
TOPData Transfer
23PPDHDTransfer to Accounting: Document Header3DOCTYPDocument typenvarchar10
TOPDocument Builder
24/IPRO/TDOCSLDocument Selection4DOCTYPDocument Typenvarchar200
25/IPRO/TDOCTYPContains data for document type3DOCTYPDocument Typenvarchar200
26/IPRO/TDOCTYP_TText table for document type4DOCTYPDocument Typenvarchar200
TOPDSD Connector
27/DSD/ME_DEL_HDDSD CN: Delivery Header Data6DOCTYPDSD Connector: Shipment Type (Doc Type)nvarchar40
28/DSD/ME_ORD_HDDSD CN: Order Header Data7DOCTYPDSD Connector: Shipment Type (Doc Type)nvarchar40
TOPEnvironment, Health and Safety
29/TDAG/CPC_DOCTYDCP: Description for document types1DOCTYPDocument Typenvarchar100
30/TDAG/CPC_DOCTYPCP: Document types1DOCTYPDocument Typenvarchar100
31/TDAG/CPC_IMFOCP: Import format15DOCTYPDocument Typenvarchar100
32/TDAG/RCSC_INTPLIncoming Template16DOCTYPDocument Typenvarchar100
TOPFinancial Accounting
33ACCRBDAccruals/Deferrals Master Data - Basic Data8DOCTYPAccrual/Deferral Profilenvarchar20
34ACCRCUSTAccrual/Deferral Profile3DOCTYPAccrual/Deferral Profilenvarchar20
35ACCRCUST_TXTAccruals/Deferrals Customizing Text4DOCTYPAccrual/Deferral Profilenvarchar20
36J_1UF_REEII_XMLXML table for J_1UF_REEII30DOCTYPDocument Typenvarchar70
37J_1UF_REEI_XMLXML table for J_1UF_REEI29DOCTYPDocument Typenvarchar70
TOPFSCM In-House Cash
38IHC_DB_DSP_TRAPOTable Structure for displaying the Posted Item Detail7DOCTYPDocument Typenvarchar20
TOPFunctions for U.S. Federal Government
39FMFG_TROR_CONFIGConfiguration for TROR lines9DOCTYPDocument Typenvarchar20
40FMFG_TROR_DTYPTROR Document Type group details4DOCTYPDocument Typenvarchar20
TOPGeneral Ledger Accounting
41FAGL_EMP_PROCESSDocument Splitting: Process Adjustment for HR Postings3DOCTYPTransfer from HR to FI: Document Typenvarchar10
TOPInterface to Terminal Automation System
42OIKSSLTPI: Log table2DOCTYPSD document categorynvarchar10
TOPLocalization
43A344BR: ICMS base reduction carrier: Land/St. Basis/Belegart6DOCTYPBelegartnvarchar10
44A382Land/Belegart/SF/ST/Schlüssel1/Schlüssel2/Schlüssel3/St.-Grp5DOCTYPBelegartnvarchar10
45J_1BAANota Fiscal type3DOCTYPDocument typenvarchar10
46J_1BDOCTYPESNota Fiscal Document Types2DOCTYPDocument typenvarchar10
47J_1BDOCTYPESTDescription of Nota Fiscal Document Types3DOCTYPDocument typenvarchar10
48J_1BNFDOCNota Fiscal Header4DOCTYPDocument typenvarchar10
TOPPension Administration
49T7PBSNO5Adocument type3DOCTYPDocument type of a notificationnvarchar40
50T7PBSNO5ATName of the documenttypes4DOCTYPDocument type of a notificationnvarchar40
51T7PBSNO6BAssignment of package, documentationtype and Pro.Scenario8DOCTYPDocument type of a notificationnvarchar40
TOPPOS Interface
52WPLSTPOS interface: processing log14DOCTYPIDoc type (for example, ORDERS01)nvarchar80
TOPSpecification 2
53SPCCNVDOCNUMConversion between S2K doc. no. and Appl. Doc. No.2DOCTYPApplication for output conditionsnvarchar20
54SPCINMAPRules for linking src field and trg field2DOCTYPIDoc Typenvarchar80
55SPCMCNVDOCNUMConversion between S2KM doc. no. and Appl. Doc. No.2DOCTYPApplication for output conditionsnvarchar20
56SPCMINMAPRules for linking src field and trg field (AECMA)2DOCTYPIDoc Typenvarchar80
57SPCPORTFUNIIRules table linking src field and trg fields5DOCTYPIDoc Typenvarchar80
TOPTraders and Schedulers Workbench
58OIJNOMCOIL-TSW: Nomination copy table56DOCTYPReference Document Typenvarchar40
59OIJNOMINomination Item56DOCTYPReference Document Typenvarchar40
60OIJNOMIVERSNomination Item Version Table58DOCTYPReference Document Typenvarchar40
61OIJ_SCHEDPlanned Schedule Lines107DOCTYPReference Document Typenvarchar40
62TOIJ_EL_DOC_MMChoose screens for TSW details pop-up in MM contracts3DOCTYPPurchasing Document Typenvarchar40
63TOIJ_EL_DOC_SDChoose screens for TSW details pop-up in SD contracts2DOCTYPSales Document Typenvarchar40
64TOIJ_EL_EV_MMDefault events for purchase documents3DOCTYPOrder Type (Purchasing)nvarchar40
65TOIJ_EL_EV_SDDefault events for sales documents2DOCTYPSales Document Typenvarchar40