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

47 columns | Print definition?ERP 6.0  | RELEASED

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/SDF/CC_RELLink between CC_OBJECTS and CC_REF entries27RELEASEDSingle-Character Indicatornvarchar10
2/SYCLO/WB000DevTool: Client application definition header7RELEASEDBoolean Type: 'X' == True '' == Falsenvarchar10
3CNVMBTIMGHEADIMG header table - contains IMG change information7RELEASEDRelased flag for IMG (checked/unchecked)nvarchar100
4DMC_UPG_ACTIONMWB: Upgrade Actions11RELEASEDMWB: Indicator for 'Released'nvarchar10
5DMC_UPG_COMPMWB: Upgrade Directory (Component/Release)4RELEASEDMWB: Indicator for 'Released'nvarchar10
6RSCRMTGEXTIDSExternal IDs in Target Groups4RELEASEDnvarchar10
7T5FDSNRELFLDDSN Released DAQ Fields2RELEASEDData element for domain BOOLE: TRUE (='X') and FALSE (=' ')nvarchar10
8PIQDBAUDR0Audits12RELEASEDIndicator: Audit Run Releasednvarchar10
TOPABAP Test Frameworks ATC, CheckMan, Code Inspector
9CRMREQOUTDATED - TO BE DELETED - ACCESS STRONGLY DISCOURAGED5RELEASEDnvarchar10
TOPAdvertising Management
10JJTPCBundle6RELEASEDSales Releasenvarchar10
TOPALE Integration Technology
11EDBASBasic types6RELEASEDRelease of basic typenvarchar40
12EDCIMExtensions6RELEASEDRelease of extensionnvarchar40
13EDIDOValue table for IDoc types8RELEASEDRelease of IDoc segmentnvarchar40
14EDIMSGOutput Types and Assignment to IDoc Types4RELEASEDRelease for which message type assignment is validnvarchar40
15EDISDEFIDoc Development : IDoc Segment Definitions4RELEASEDIDoc development: Release of segment definitionnvarchar40
16EDISEGEDI: IDoc Segments with Assignment to Segment Type3RELEASEDSAP release for which segment definition was creatednvarchar40
17EDSEAEDI: Table of all segments of current release3RELEASEDSAP release for which segment definition was creatednvarchar40
18EDSEGEDI: Convert segments to 3.03RELEASEDSAP release for which segment definition was creatednvarchar40
19EDSVRSEDI: Table of all segments of current release4RELEASEDSAP release for which segment definition was creatednvarchar40
20IDXEDISDEFIDoc Adapter Segment Versions for each Port5RELEASEDIDoc development: Release of segment definitionnvarchar40
21IDXSLOADIDoc Adapter Administration12RELEASEDSAP Release for IDocnvarchar40
TOPBusiness Navigator
22DF14LApplication Components18RELEASEDReleased to customers innvarchar40
TOPClaims Management
23ICLCCEVENTClaim Bundle31RELEASEDStatus "Released"nvarchar10
24ICLPROCUREClaim Item Groupings59RELEASEDStatus "Released"nvarchar10
25ICSCCEVENTShadow Table Claim Bundle31RELEASEDStatus "Released"nvarchar10
26ICSPROCUREClaim Item Groupings59RELEASEDStatus "Released"nvarchar10
TOPCross-Application Components
27SPRTLOBRELDrag&Relate: Released Object Types2RELEASEDDrag&Relate: Object Release Statusnvarchar10
TOPData Collection
28MCSLISEHLIS Inbound Interface: Control Information (Headers)7RELEASEDSAP release for which segment definition was creatednvarchar40
TOPData Conversion
29DMC_IDOCMaster Data for IDocs4RELEASEDReleased innvarchar40
TOPData Mining
30RSDMESC_ABC_STATAdministration Data for ABC Analysis17RELEASEDFlagnvarchar10
TOPFunction Builder
31RODIRReleased Objects Directory4RELEASEDCharacter 1 change document relevantnvarchar10
TOPGraphical User Interface
32CNTLWARNTable containing information about control restrictions3RELEASEDDummy for B20 int1 (Local Everywhere)tinyint30
TOPHelp Infrastructure for ABAP
33WDY_TEXTFILE_REFInbox Text File References (Author Buffer)5RELEASEDText File Released = 'X'nvarchar10
TOPliveCache Applications
34/SAPAPO/ORDKEYKey and descriptive data for order16RELEASEDStatus 'Released'nvarchar10
TOPLocal Currency Changeover
35ADMI_CRITManage critical archiving objects (database conversion)12RELEASEDReleased flag for the objectnvarchar10
TOPPackage Tools
36AKB_STATISTICSObsolete: BCB Statistics7RELEASEDNatural Numberint100
37AKB_USGObsolete: Index of Base Objects for BCB6RELEASEDSingle-Character Indicatornvarchar10
38AKB_USG_EXTObsolete: Frozen Base Objects for BCB9RELEASEDSingle-Character Indicatornvarchar10
TOPPrint and Output Management
39TSPOPIPPrinter / device type repations8RELEASEDRelease flagnvarchar10
TOPProfitability Analysis
40TKEPSVCO-PA: Plan Structure Status Management7RELEASEDCO-PA released indicator for planning structurenvarchar10
TOPRepository Browser
41RSEUMODSettings for ABAP Workbench42RELEASEDObject type is released for operational usenvarchar10
TOPSAP Business Workflow
42SWZAIHeader Table for all Properties of a Work Queue5RELEASEDIndicator Denoting Whether Entire Work Queue Is Releasednvarchar10
43SWZAIENTRYObject Table for Work Queues (Entries)7RELEASEDFlag whether the line of a work queue is releasednvarchar10
TOPSAP Records Management
44SRMSTATUSSRM Status7RELEASEDSRM: Releasednvarchar10
TOPTerminologyGlossary
45STERM_Q_CHECK_HHeader Table for Terminology Check13RELEASEDFlag (X or Blank)nvarchar10
TOPTest Organizer
46TNODE02ATest Organizer, Test Catalog, Plan, Package Attributes11RELEASEDReleased / not releasednvarchar10
TOPTranslation Tools
47TRACOLSYSTParameters for transport collector3RELEASEDGeneral Flagnvarchar10