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

48 columns | Print definition?ERP 6.0  | MODIFIED_BY

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1CMCBD_CYCLECash Budgeting Cycle19MODIFIED_BYModified bynvarchar120
2CMCBD_ORG_HIEROrganizational Hierarchy6MODIFIED_BYModified bynvarchar120
3CMCBD_PC_RL_CONTCash Budget: Payment control - relative control content11MODIFIED_BYUser Namenvarchar120
4CMCBD_PC_SG_CONTCash Budget: Payment control rule - Single Control Content11MODIFIED_BYUser Namenvarchar120
5GRRMANALDRS5DRS5 Risk Analysis12MODIFIED_BYDRS5 Analysis - Modified Bynvarchar120
6OA2C_SAML2_ENTSAML2 Entity Table for OAuth 2.0 Client6MODIFIED_BYEntity Changed Bynvarchar120
TOPAuthentication and SSO
7SAML2_ENTITYSAML2 Entity Table10MODIFIED_BYEntity Changed Bynvarchar120
TOPBasic Functions
8WITH_EXCL_STR_HDDerivation Strategies for Exclusion of Lines in Withhold.Tax6MODIFIED_BYLast changed bynvarchar120
TOPData Mining
9RSDMTP_DSRC_BWDMining Source to Datasource Relation7MODIFIED_BYUser who last changednvarchar120
TOPECM ABAP Stack
10NWECMD_NODEtable for persistent node objects13MODIFIED_BYnwecm: Stringntext10737418230
11NWECMD_RELATIONSnwecm: persistent representation of relations9MODIFIED_BYnwecm: Stringntext10737418230
TOPFunds Management
12FMBUDGETPDFM: Budget Period Master Data10MODIFIED_BYFIFM: Name of Last Person to Make a Changenvarchar120
13FMFGRCNRULEReconciliation: Reconcilation Rule definition6MODIFIED_BYFIFM: Name of Last Person to Make a Changenvarchar120
14FMFGRCNSLICEData slice for Reconciliation Tool13MODIFIED_BYFIFM: Name of Last Person to Make a Changenvarchar120
15FMSPLIT_RULEDistribution Rule for Rule-Based Account Distributions11MODIFIED_BYFIFM: Name of Last Person to Make a Changenvarchar120
16FMSPLIT_SPLITDistributions for Rule-Based Account Distributions17MODIFIED_BYFIFM: Name of Last Person to Make a Changenvarchar120
17FMTABADRHCharacteristic Derivation: Header7MODIFIED_BYLast changed bynvarchar120
TOPGeneral Application Functions
18TABADRHCharacteristic Derivation: Header7MODIFIED_BYLast changed bynvarchar120
19TABADRSCharacteristic Derivation: Steps22MODIFIED_BYLast changed bynvarchar120
TOPGeneral Ledger Accounting
20FAGL_VAL_HDRValidation Strategy7MODIFIED_BYLast changed bynvarchar120
TOPGrantor Management
21GTRFIBILL_HHeader of Grantor FI AP/AR Billing Doc39MODIFIED_BYModified Bynvarchar120
TOPIntegration Engine
22SXMS_EOIOREORGReorganization of EOIO Queues10MODIFIED_BYLast Changed Bynvarchar120
23SXMS_EOIO_ERRError Table for Overserialized EOIO Queues6MODIFIED_BYLast Changed Bynvarchar120
24SXMS_EOIO_REORGReorganization of EOIO Queues10MODIFIED_BYLast Changed Bynvarchar120
25SXMS_EOIO_STATMaximum Number of EOIO Queues10MODIFIED_BYLast Changed Bynvarchar120
TOPMaster Data
26FMMEASUREFM Funded Program Master Data12MODIFIED_BYFIFM: Name of Last Person to Make a Changenvarchar120
27GMGRGrant Master53MODIFIED_BYLast Modified bynvarchar120
28GMSPCLASSSponsored Class Master12MODIFIED_BYLast Modified bynvarchar120
29GMSPPROGRAMSponsored program master15MODIFIED_BYLast Modified bynvarchar120
TOPOffice Suite Program
30/OSP/T_CORRELATECorrelation Table7MODIFIED_BYName of User who modified the Correlation recordnvarchar120
31/OSP/T_CORR_EXTCorrelation Table - External object records8MODIFIED_BYName of User who modified the External object recordnvarchar120
32/OSP/T_CORR_SAPCorrelation Table - SAP object records9MODIFIED_BYName of User who modified the SAP object recordnvarchar120
33/OSP/T_IH_NOTIFSTable containing generic header information for Notification18MODIFIED_BYR/3 user name of employeenvarchar120
34/OSP/T_JOBINFOOSP Report Schedule Jobs information9MODIFIED_BYUser IDnvarchar120
35/OSP/T_MEND_LRTable of Mendocino Leave Requests10MODIFIED_BYR/3 user name of employeenvarchar120
36/OSP/T_REGIS/OSP/ Time points registration table.13MODIFIED_BYUser IDnvarchar120
37/OSP/T_REPINFOOSP Report Information Table28MODIFIED_BYUser IDnvarchar120
38/OSP/T_REPMD5BKTOSP : Report MD5 Book Keeping Table10MODIFIED_BYUser IDnvarchar120
39/OSP/T_TEAMD5BKTOSP : Team Management MD5 Book Keeping Table12MODIFIED_BYUser IDnvarchar120
40SOSP_T_BKT_PERFMBook Keeping table for Performance12MODIFIED_BYSAP Usernamenvarchar120
TOPOverhead Cost Controlling
41TFKBFunctional areas11MODIFIED_BYFIFM: Name of Last Person to Make a Changenvarchar120
TOPPeople Centric UI Framework
42CRMD_PERS_LISTGeneric Storage for Personalization Data22MODIFIED_BYChanged bynvarchar120
TOPPeople Centric UI Framework Customizing
43CRMC_PERSLST_EXTEnhanced Personalization Data for Result List8MODIFIED_BYChanged bynvarchar120
44CRMC_VSET_PERSPersonalization Data View Set Group8MODIFIED_BYChanged bynvarchar120
TOPProfitability Analysis
45TKEDRHCharacteristic Derivation: Header7MODIFIED_BYLast changed bynvarchar120
46TKEDRSCharacteristic Derivation: Steps22MODIFIED_BYLast changed bynvarchar120
TOPRisk Analysis
47AFWCH_DRS_SAMPSample Customizing for Derivation (Steps)21MODIFIED_BYLast changed bynvarchar120
TOPSAP NetWeaver Mobile - Use subcomponents
48MEMSDMobile Solution Descriptor: Main Table9MODIFIED_BYUser Name in User Master Recordnvarchar120