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

77 columns | Print definition?ERP 6.0  | CR_USER

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1CNVMBT09INDEXAll indexes they are not on the database5CR_USERMBT PCL created / changed usernamenvarchar120
2CNVMBTGLBVARINFOPIFD Global Variant header table3CR_USERCreated bynvarchar120
3CNVTDMS_09_INDEXAll indexes they are not on the database5CR_USERMBT PCL created / changed usernamenvarchar120
4FDT_BRS_CC_0000BRS Managed System: Meta data of generate code6CR_USERUser Namenvarchar120
5FDT_BRS_CC_0001BRS Managed System: Generated classes + XML10CR_USERUser Namenvarchar120
6FDT_BRS_CC_0003BRS Managed System: Generated HANA objects11CR_USERUser Namenvarchar120
7FDT_BRS_CC_0005FDT: Database table for non productive simulation7CR_USERUser Namenvarchar120
8FDT_BRS_CC_0006BRS Managed System: Generated HANA objects - non productive10CR_USERUser Namenvarchar120
9FDT_BRS_DSM_0000BRS DSM: Managed Systems5CR_USERUser Namenvarchar120
10FDT_CC_H_0000FDT: Generated HANA DB objects9CR_USERUser Namenvarchar120
11FDT_CI_SETTINGFDT: Client Ind. Settings Parameter Table for Boolean Values6CR_USERUser Namenvarchar120
12FDT_CI_TEXT_SETFDT: Client Independent Settings Parameter Table6CR_USERUser Namenvarchar120
13FDT_TRANS_Q_0010FDT: Transport Activation Queue - Frozen Interface to CTS4CR_USERUser Namenvarchar120
14FDT_TRANS_Q_0011FDT: Transport Activation Queue - Merge Transport8CR_USERUser Namenvarchar120
15J_3RF_CTS_HCurrency Transaction Statement Document Header21CR_USERUser namenvarchar120
16LTR_ANYHeader Table for any LTR Object10CR_USERUser Namenvarchar120
17LTR_ANY_BACKUPHeader Table for any LTR Object10CR_USERUser Namenvarchar120
18PYC_D_BPCBatch Processing Component Run Time Information10CR_USERUser Namenvarchar120
19PYC_D_BPC_JOBBatch Processing Component Jobs7CR_USERUser Namenvarchar120
20PYC_D_BPC_REJOBatch Processing Component Reject Object6CR_USERUser Namenvarchar120
21PYC_D_DTAREGDTA Stamp Registry6CR_USERUser Namenvarchar120
22PYC_D_DTAREGPDTA Stamp Registry Processing8CR_USERUser Namenvarchar120
23PYC_D_PY_MSG_JOBPYC: payroll message34CR_USERUser Namenvarchar120
24PYD_D_ALPayroll Data Source Framework: Action Log17CR_USERUser Namenvarchar120
25PYD_D_CLSPASPayroll Data Source Class Parameter Activation Status6CR_USERUser Namenvarchar120
26PYD_D_CLSPASHPayroll Data Source Class Parameter Act. Status History7CR_USERUser Namenvarchar120
27PYD_D_RESPayroll Data Source Result10CR_USERUser Namenvarchar120
28PYD_D_RESOPayroll Data Source Result Object8CR_USERUser Namenvarchar120
29PYD_D_RESOHPayroll Data Source Result Object History9CR_USERUser Namenvarchar120
30PYD_D_RESOSPayroll Data Source Result Object Shadow9CR_USERUser Namenvarchar120
31PYD_D_SHPayroll Data Source Shadow8CR_USERUser Namenvarchar120
32PYD_D_SHIPayroll Data Source Shadow Item11CR_USERUser Namenvarchar120
33PYD_D_UVPayroll Data Source Framework: User Variant9CR_USERUser Namenvarchar120
34PYD_D_UVDPayroll Data Source Framework: User Variant Details12CR_USERUser Namenvarchar120
35/BOBF/D_CC_LOG_HBOPF Contract Compliance Check Log header11CR_USERUser Namenvarchar120
TOPAnalyzer
36AFWGO_LOADADMINManagement of Single Records Procedures per Date8CR_USERCreated Bynvarchar120
37AFWGO_LOGHISTORYHistory of Application Logs in Single Records Procedure7CR_USERCreated Bynvarchar120
TOPBank Customer Accounts
38RTP_US_PLANRetirement plan data (US enhancement)20CR_USERCreated bynvarchar120
TOPBRFplus - ABAP-Based Business Rules
39FDT_ADMN_0000FDT: Central Administrative Data8CR_USERUser Namenvarchar120
40FDT_ADMN_0000AFDT: Central Administrative Data8CR_USERUser Namenvarchar120
41FDT_ADMN_0000SFDT: Central Administrative Data7CR_USERUser Namenvarchar120
42FDT_ADMN_0000TFDT: Central Administrative Data7CR_USERUser Namenvarchar120
43FDT_ADMN_0030FDT: Central Administrative Data - Versions with State5CR_USERUser Namenvarchar120
44FDT_ADMN_0030AFDT: Central Administrative Data - Versions with State5CR_USERUser Namenvarchar120
45FDT_ADMN_0030SFDT: Central Administrative Data - Versions with State4CR_USERUser Namenvarchar120
46FDT_ADMN_0030TFDT: Central Administrative Data - Versions with State4CR_USERUser Namenvarchar120
47FDT_CC_0000FDT: Generated programs for FDT customizing objects8CR_USERUser Namenvarchar120
48FDT_CC_0000SFDT: Generated programs for FDT system objects7CR_USERUser Namenvarchar120
49FDT_EMEX_0001BRFplus: Protocol table for emergency transports3CR_USERUser Namenvarchar120
50FDT_INTRP_0000FDT:Table of interrupted actions3CR_USERUser Namenvarchar120
51FDT_JOB_0000FDT: Job Header Table2CR_USERUser Namenvarchar120
52FDT_SETTINGFDT: Settings Parameter Table for Boolean Values7CR_USERUser Namenvarchar120
53FDT_TEST_XMLFDT: Table for Test Data to be processed in UnitTest4CR_USERUser Namenvarchar120
54FDT_TEXT_SETTINGFDT: Settings Parameter Table7CR_USERUser Namenvarchar120
55FDT_TRANS_Q_0000FDT: Transport Activation Queue - Frozen Interface to CTS3CR_USERUser Namenvarchar120
56FDT_TRANS_Q_0001FDT: Transport Activation Queue - Merge Transport7CR_USERUser Namenvarchar120
57FDT_TRANS_RT_000FDT: Package Header Table9CR_USERUser Namenvarchar120
58FDT_TRREQUESTFDT Transport Request: Persistent Requests - Header3CR_USERUser Namenvarchar120
TOPCross-Application Components
59BC430_DSStatus of Sample Data for BC4304CR_USERnvarchar120
TOPData Mining
60RSDMTD_TREE_MAPTree ID mapping to Mining Source Mapping4CR_USERUser who has created the modelnvarchar120
TOPDocument Management System
61DRZAODDS: task-specific data for recipient list4CR_USERCreated bynvarchar120
62DRZODDS: Distribution order (DDO)13CR_USERCreated bynvarchar120
63DRZOCDDS: partial order20CR_USERCreated bynvarchar120
64DRZOIDDS: initial order11CR_USERCreated bynvarchar120
TOPInformation System
65T803JReport Writer: Report Groups4CR_USERCreated Bynvarchar120
TOPIntercompany Data Exchange
66TINV_INV_TMPLTBill Document: Template9CR_USERUser who created recordnvarchar120
TOPLogistics Basic Data
67MASS_JOB_ERRORMass Maintenance Cluster for Error Recover6CR_USERUser namenvarchar120
TOPRemote Logistics Management
68OIO_C1_CNTNRRLM Oil and gas container master data34CR_USERName of Person who Created the Objectnvarchar120
69OIO_CM_DOC_FLOWRLM document flow index10CR_USERName of Person who Created the Objectnvarchar120
70OIO_MX_INDEXRLM material tracking extract index11CR_USERName of Person who Created the Objectnvarchar120
71OIO_RT_RTDOCRLM returns document - header14CR_USERName of Person who Created the Objectnvarchar120
72OIO_SH_VOYAGEVoyages18CR_USERName of Person who Created the Objectnvarchar120
TOPTransaction Tax Engine
73TTEC_DT_DATADecision Tree Data8CR_USERCreation Usernvarchar120
TOPTranslation Tools
74LXE_KEY_VALUEProperties3CR_USERUser Namenvarchar120
75LXE_KW_TRANSLKW folders defined for translation11CR_USERUser Namenvarchar120
TOPWeb Survey
76TUWS_SURVEY_LOGSurvey Log18CR_USERUser Namenvarchar120
77TUXX_COND_VALResults of Conditions on XML Documents13CR_USERUser Namenvarchar120