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

36 columns | Print definition?ERP 6.0  | CHANGENR

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1CDCLS4CHANGENRnvarchar100
2CDPOSChange document items4CHANGENRDocument change numbernvarchar100
3PCDCLS4CHANGENRnvarchar100
4PCDPOSChange document items4CHANGENRDocument change numbernvarchar100
TOPApplication Framework
5USMD_PP_CDChange Document for Active Area7CHANGENRDocument change numbernvarchar100
TOPAudit trail enhancements ILM
6AUT_D_ILM_CDHDRAudit Trail (ILM): Storage Change Document Headers (ILM)5CHANGENRDocument change numbernvarchar100
7AUT_D_ILM_CDPOSAudit Trail (ILM): Storage Change Document Items (ILM)5CHANGENRDocument change numbernvarchar100
8AUT_D_ILM_CD_STRAudit Trail (ILM): Storage for Change Docs (STRING Values)6CHANGENRDocument change numbernvarchar100
9AUT_D_ILM_CD_UIDAudit Trail (ILM): Storage of Addl Data (TABKEY > 70 Chars)6CHANGENRDocument change numbernvarchar100
TOPChange Documents
10CDHANDLECD: Dummy Table for Lock Object4CHANGENRDocument change numbernvarchar100
11CDHDRChange document header4CHANGENRDocument change numbernvarchar100
12CDPOS_STRAdditional Change Document - Table for STRINGs5CHANGENRDocument change numbernvarchar100
13CDPOS_UIDAdditional Table for Inclusion of TABKEY>70 Characters5CHANGENRDocument change numbernvarchar100
14CDTESTKEYTest Table for UNICODE-CONVERSION CDPOS-TABKEY8CHANGENRnvarchar100
15PCDHDRChange document header4CHANGENRDocument change numbernvarchar100
16PCDPOS_STRAdditional Planned Change Document: Table for STRINGs5CHANGENRDocument change numbernvarchar100
17PCDPOS_UIDAdditional Table for Inclusion of TABKEY>70 Chars-Plnnd Chg.5CHANGENRDocument change numbernvarchar100
TOPDistributed System Landscape
18/ISDFPS/CDLOGSYSChange Documents: Local Assignment of Doc. to Doc. Sender5CHANGENRDocument change numbernvarchar100
TOPMarketing, Accounting and Pricing
19OICSDPCDVERChange document version management4CHANGENRDocument change numbernvarchar100
TOPMaterial Master
20MARA_TMPFile for Incorrect Data in Direct Input8CHANGENRDocument change numbernvarchar100
TOPProduct Safety
21EST_CHANGE_DOCSEHS: Change Documents in the EH&S System2CHANGENRDocument change numbernvarchar100
TOPProvisioning
22SPCIPHDRStores header information for IP data13CHANGENRDocument change numbernvarchar100
23SPCIPOSC_DSPEC2000: Stores deleted entries for SPCIPOSC8CHANGENRDocument change numbernvarchar100
TOPPublic Sector Contract Accounts Receivable and Payable
24DFMCAILOTPSCD: Approval List Installment Plans32CHANGENRDocument change numbernvarchar100
25DFMCA_CRPAApproval List for Document Changes3CHANGENRChange Number of Documentnvarchar100
TOPRegulatory reporting for insurance companies
26TISSR_GP_CHANGEISSR: Tabelle zur Aufnahme der Informationen zur GP-Änderung5CHANGENRÄnderungsnummer des Belegsnvarchar100
27TISSR_GP_CHANGETTexttabelle zur Tabelle TISSR_GP_CHANGE6CHANGENRÄnderungsnummer des Belegsnvarchar100
TOPSales
28/CBAD/CHG_EFF_HCBAD: Changes to the future in extended contracts - Header5CHANGENRDocument change numbernvarchar100
29/CBAD/CHG_EFF_ICBAD: Changes to the future in extended contracts - Item2CHANGENRDocument change numbernvarchar100
30/CBAD/CHG_FUTURECBAD: Changes to the future in extended contracts - Header5CHANGENRDocument change numbernvarchar100
31/CBAD/CON_HISTAdvanced Order Processing and Billing: Contract History5CHANGENRDocument change numbernvarchar100
TOPTraders and Schedulers Workbench
32OIJNOMHNomination Header81CHANGENRChange Numbernvarchar40
33OIJ_EL_TICKET_HUniversal ticket table27CHANGENRChange Numbernvarchar40
TOPTransfer Postings
34J_1AAWAYBLWay Bills for asset movements24CHANGENRDocument change numbernvarchar100
TOPUser and Authorization Management
35SUIM_CHG_IDXChange Document Index for User Data7CHANGENRDocument change numbernvarchar100
36USARC_CDREDReloaded Archived Change Documents for User Data3CHANGENRDocument change numbernvarchar100