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

83 columns | Print definition?ERP 6.0  | CHNAM

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1CNVTDMS_04_TABTable Pool for TDMS MD&C12CHNAMUser Namenvarchar120
2CNV_10400_SETUPSettings for characteristic conversion31CHNAMModifier of control datanvarchar400
3CNV_10400_TABUSESettings for characteristic conversion6CHNAMModifier of control datanvarchar400
4DMC_CNTRLPARAMMWB: Control Parameters7CHNAMUser Namenvarchar120
5DMC_CNTRLPARAMCCustomizing Control Parameters4CHNAMUser Namenvarchar120
6DMC_CU_RUN_HDRHeader record of a Content Upgrade Run7CHNAMUser Namenvarchar120
7DMC_DEVL_CSTEPSSP: Status table of ConvObj Work Steps (Development Env.)8CHNAMUser Namenvarchar120
8DMC_FIXEDVALUEMWB: Fixed Values10CHNAMUser Namenvarchar120
9DMC_FIXEDVALUECCustomizing Fixed Values4CHNAMUser Namenvarchar120
10DMC_PC_COBJSTEPSSP: Status table of ConvObj Work Steps (Processing Cockpit)8CHNAMUser Namenvarchar120
11DMC_PC_PROJSTEPSSP: Status table of Project Work Steps (Processing Cockpit)10CHNAMUser Namenvarchar120
12DMC_RULECMWB: Customizing of rules4CHNAMUser Namenvarchar120
13DMC_STREE_TRACEMWB: Trace storage for table DMC_STREE13CHNAMUser Namenvarchar120
14DMC_UPG_ACTIONMWB: Upgrade Actions9CHNAMMWB: User who made the last changenvarchar120
15DMC_UPG_COMPMWB: Upgrade Directory (Component/Release)9CHNAMMWB: User who made the last changenvarchar120
16DMC_UPG_CPROJMWB: Customer Project6CHNAMMWB: User who made the last changenvarchar120
17DMC_UPG_CUSTMWB: Customer Data for a Project5CHNAMMWB: User who made the last changenvarchar120
18DMC_VARIABLEMWB: Variables14CHNAMUser Namenvarchar120
19J_3RF_RGTORG_INIncoming Journal of Acceptance Documents31CHNAMName of Person Who Changed the Documentnvarchar120
20J_3RF_RGTORG_OUTOutgoing Journal of Acceptance Documents26CHNAMName of Person Who Changed the Documentnvarchar120
TOPAddress ManagementBusiness Address
21SADRAddress Management: Company Data43CHNAMAddresses: Changed bynvarchar120
22SADRPAddress Management: Personal Data13CHNAMAddresses: Changed bynvarchar120
TOPAnalyzer
23AFWCH_FCAT_SAMPAFW: Sample Customizing Characteristics48CHNAMUsernvarchar120
TOPBusiness Planning
24UPBXPlanning Applications: Generic Data Container5CHNAMUser namenvarchar120
TOPConsolidation
25TF90FActive Field Catalog, Consolidation48CHNAMUsernvarchar120
26TF90SBasis Field Catalog Consolidation (Fixed Fields)48CHNAMUsernvarchar120
27TF91FField Catalog, Consolidation48CHNAMUsernvarchar120
TOPData Collection
28TKAFField catalog for Accounting49CHNAMUsernvarchar120
29TKCFSAP-EIS Field Catalog48CHNAMUsernvarchar120
30TKCHHSAP-EIS: Hierarchy header6CHNAMUsernvarchar120
31TKCKKey figures13CHNAMUsernvarchar120
32TKCSBasic field catalog SAP-EIS (fixed fields)48CHNAMUsernvarchar120
TOPData Conversion
33DMC_ACTPDMC: Actual Parameters from Rule Call or Operator Call7CHNAMUser Namenvarchar120
34DMC_ANWDGDMC: Applications in the Direct Input Concept4CHNAMUser Namenvarchar120
35DMC_BAPIDMC: Master Data for BAPI Integration10CHNAMUser Namenvarchar120
36DMC_BIPDMC: Attributes for Standard Batch Input6CHNAMUser Namenvarchar120
37DMC_BWIBData from BW Query Inbound Processing3CHNAMUser Namenvarchar120
38DMC_BWQRYInbound Interface for BW Query5CHNAMUser Namenvarchar120
39DMC_CNTNContainer Type for Sender Structure Name Administration4CHNAMUser Namenvarchar120
40DMC_COBJDMC: Conversion Object7CHNAMUser Namenvarchar120
41DMC_COMPLComplex Data Structures6CHNAMUser Namenvarchar120
42DMC_DITDirect Input - Test Type4CHNAMUser Namenvarchar120
43DMC_DIWWrapper for Direct Input5CHNAMUser Namenvarchar120
44DMC_FDESCDMC: Description of Data to Be Imported5CHNAMUser Namenvarchar120
45DMC_FIELDDMC: Data Field of a Structure12CHNAMUser Namenvarchar120
46DMC_IDOCMaster Data for IDocs9CHNAMUser Namenvarchar120
47DMC_IFREGRegistration of Interfaces13CHNAMUser Namenvarchar120
48DMC_IOTMPLRegistry Entry for Inbound/Outbound Template8CHNAMUser Namenvarchar120
49DMC_IRULEDMC: Installed Rules5CHNAMUser Namenvarchar120
50DMC_ISBDMC Tool: Information about Direct Input 27CHNAMUser Namenvarchar120
51DMC_OPDMC: Rule Implementation Type6CHNAMUser Namenvarchar120
52DMC_PARAMDMC: Formal Parameters in Rule and Operation Calls8CHNAMUser Namenvarchar120
53DMC_PRJCTProject Management5CHNAMUser Namenvarchar120
54DMC_RCALLDMC: Representation of Rule or Operator Calls7CHNAMUser Namenvarchar120
55DMC_RSDATDMC: Information about Self-Defined Recipient Container3CHNAMUser Namenvarchar120
56DMC_RSRELDMC: Relations Between Sender/Recipient Structures7CHNAMUser Namenvarchar120
57DMC_RULEMapping Rules in DMC Tool4CHNAMUser Namenvarchar120
58DMC_SPRJCTSub-Projects (Conversion Object Administration)5CHNAMUser Namenvarchar120
59DMC_SSDATDMC: Information About Self-Defined Sender Container3CHNAMUser Namenvarchar120
60DMC_STREEDMC: Tree Structure for Administration of Structures10CHNAMUser Namenvarchar120
61DMC_STRUCTSender Structure or Recipient Structure7CHNAMUser Namenvarchar120
62DMC_SXDAMaster Data for SXDA7CHNAMUser Namenvarchar120
63DMC_TROBJDMC: Recoding Object Definition6CHNAMUser Namenvarchar120
64DMC_WSTEPSave and Display User Steps8CHNAMUser Namenvarchar120
65DMC_XMLDDMC: Administration of XML Descriptions3CHNAMUser Namenvarchar120
TOPDown Payment Chains
66/SAPPCE/TDPC01Down Payment Chains36CHNAMUser name of processer who made change to objectnvarchar120
TOPIncentive and Commission Management ICM
67TCACSFCommissions: Field Catalog Search49CHNAMUsernvarchar120
TOPInformation System
68TKAF_USER_APPD_KField Catalog for Customer Key Figures17CHNAMUsernvarchar120
69TKAF_USER_APPD_MField Catalog for Customer Characteristics22CHNAMUsernvarchar120
TOPInvestment Programs
70TAIFIM Drilldown: Characteristic Catalog49CHNAMUsernvarchar120
TOPMaster data
71PACKKPPacking Object Header38CHNAMPerson responsible, changenvarchar120
TOPObject Dependencies
72CUVFUN_ADMAdministrative Data for variant function5CHNAMName of Person Who Changed Objectnvarchar120
TOPProfitability Analysis
73TJBFField Catalog IS-B-PA48CHNAMUsernvarchar120
74TJBSBase Field Catalog IS-B-PA (Fixed Fields)48CHNAMUsernvarchar120
75TKEFCO-PA field catalog48CHNAMUsernvarchar120
76TKESCO-PA Basis Field Catalog (fixed fields)48CHNAMUsernvarchar120
TOPProgress Tracking
77TSTNTExpediting Status Information11CHNAMName of Person Who Changed Objectnvarchar120
TOPPublic Sector
78PA0752HR Master Record: Infotype 075226CHNAMFinancially dependent child namenvarchar1200
TOPRecycling Administration Core Functions
79J_7LSADRAddress Management: Company Data43CHNAMAddresses: Changed bynvarchar120
TOPRisk Analysis
80JBRRMTKEFRM: Copy of CO-PA Field Catalog48CHNAMUsernvarchar120
81JBRRMTKESRM: Base Field Catalog CO-PA Fix.Char./Basic Key Figures48CHNAMUsernvarchar120
TOPTreasury
82TTMRFField catalog for Risk Management48CHNAMUsernvarchar120
83TTMRSBasis field catalog Risk Management (fixed fields)48CHNAMUsernvarchar120