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

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1BBP_PD_TEMPL_XMLTable for XML Issue Templates6INVALIDSingle-Character Indicatornvarchar10
2CLB2D_USER_TOKENOAuth Access Data for User6INVALIDIndicator: Token Is Invalidnvarchar10
3CLBD_USER_TOKENOAuth Access Data for User6INVALIDIndicator: Token is Invalidnvarchar10
4CNVMBTGLOBPARAMTable of global parameters for DMIS3INVALIDFlag (X = yes, initial = no)nvarchar10
5CNV_10020_RULEPRules for components of non-transp. fields/determ. objects11INVALIDValid -> Invalidnvarchar10
6RSCRMPACK_CELL2.8INVALIDValue of Key Figure Invalidnvarchar10
TOPAccounts Receivable Accounting Process Integration
7FDM_LDDBFSCM-DM: Log And Delay Database22INVALIDFSCM-DM: Indicator for Obsolete LDDB Entriesnvarchar10
TOPBasic Functions
8CMPB_ASGNCampaign Assignment7INVALIDCampaigns: Invalid Assignmentnvarchar10
TOPContract Accounts Receivable and Payable
9FKK_GPSHADData Extract: Business Partner Data (Faster Access)43INVALIDShadow Table Entry Invalidnvarchar10
TOPData Conversion
10DMC_COBJDMC: Conversion Object23INVALIDBoolean Variable (X=True, -=False, Space=Unknown)nvarchar10
TOPData Replication Framework
11FOX3_INST_DBData Storage for FOX Instances6INVALIDObject Statusnvarchar10
TOPEnterprise Service Framework Layer
12SCOL_TYPEMANAGERSCOL_TYPEMANAGER5INVALIDBooleannvarchar10
TOPIncentive and Commission Management ICM
13CRD000_AAS01Referencing Credential Assignments8INVALIDInvalidnvarchar10
14CRD000_AF01Template for Referencing Credential Descriptions7INVALIDInvalidnvarchar10
15CRD000_AS01Credential Assignments6INVALIDInvalidnvarchar10
16CRD000_CRD01Template for Credential Descriptions6INVALIDInvalidnvarchar10
TOPOLAP Technology
17RSECLOPDQSTATLOPD-Relevant Objects Within Queries4INVALIDBooleannvarchar10
TOPPatient Management
18N1COMPLDEGREECompletion Status8INVALIDCompletion Status: Incorrectnvarchar10
TOPPost Processing Framework
19PPFTALMTEPPF: Medium Alert (Template)8INVALIDSingle-Character Indicatornvarchar10
20PPFTBCSTETransmission Medium Database Table (Template)7INVALIDSingle-Character Indicatornvarchar10
21PPFTGEMETEPPF: Table for Generic Medium (Templ)14INVALIDSingle-Character Indicatornvarchar10
22PPFTMETHTEPPF: Medium Method Call (Template)8INVALIDSingle-Character Indicatornvarchar10
23PPFTSFFXT2PPF: Medium Smart Forms Fax (Template) -> Transportable18INVALIDSingle-Character Indicatornvarchar10
24PPFTSFFXTEPPF: Medium Smart Forms Fax (Template)18INVALIDSingle-Character Indicatornvarchar10
25PPFTSFMLT2PPF: Medium Smart Forms Mail (Template)18INVALIDSingle-Character Indicatornvarchar10
26PPFTSFMLTEPPF: Medium Smart Forms Mail (Template)18INVALIDSingle-Character Indicatornvarchar10
27PPFTSFPRT2PPF: Medium Smart Forms Print (Template)29INVALIDSingle-Character Indicatornvarchar10
28PPFTSFPRTEPPF: Medium Smart Forms Print (Template)29INVALIDSingle-Character Indicatornvarchar10
29PPFTWFTEPPF: Workflow Medium (Template)8INVALIDSingle-Character Indicatornvarchar10
TOPProduct Data Management
30FOX_INST_DBData Storage for FOX Instances6INVALIDInvalid Objectnvarchar10
TOPProduct Data Replication
31CRWB_BADI_BL2UPSUPS Entries for Baseline (Workflow Dependent)18INVALIDCM: Indicatornvarchar10
TOPSAP Note Assistant
32CWBRFCCACHCache for Request Data from Remote Systems5INVALIDCHAR01 data element for SYSTnvarchar10
TOPSCM Basis
33CPVINFRPurchasing info record and production version assignment4INVALIDProduction Version Invalidnvarchar10
TOPStorage and Retention Service
34DAS_RESOURCESILM SRS: Resources8INVALID'Invalid' Indicatornvarchar10
TOPWithout Description
35RSTT_CALLSTACKTrace Tool: Call Stack Table of Trace16INVALIDTrace Tool: Standard Flagnvarchar10
36RSTT_TRACETrace Tool: Table Trace Attribute18INVALIDTrace Tool: Standard Flagnvarchar10