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

61 columns | Print definition?ERP 6.0  | DDLANGUAGE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/1CADMC/00000202DD02T5DDLANGUAGEnvarchar10
2/1CADMC/00000205DD02T5DDLANGUAGEnvarchar10
3/1CADMC/00000427DD04T5DDLANGUAGEnvarchar10
4/1CADMC/00000430DD07T5DDLANGUAGEnvarchar10
5/1CADMC/00001432DD02T5DDLANGUAGEnvarchar10
6CNVCMIS_A_1_DOMASelection of Object Type Master information6DDLANGUAGELanguage Keynvarchar10
7CNVCMIS_A_1_DTELSelection of Object Type Master information28DDLANGUAGELanguage Keynvarchar10
8CNVCMIS_A_1_ENQUENQU Data (Header)16DDLANGUAGELanguage Keynvarchar10
9CNVCMIS_A_1_INDXIndx Table(CMIS)22DDLANGUAGELanguage Keynvarchar10
10CNVCMIS_A_1_MCIDMCID type Repository Analysis24DDLANGUAGELanguage Keynvarchar10
11CNVCMIS_A_1_MCOBMCOB type Repository Analysis17DDLANGUAGELanguage Keynvarchar10
12CNVCMIS_A_1_SHLPSearch Help Data-Header17DDLANGUAGELanguage Keynvarchar10
13CNVCMIS_A_1_TTYPTable types for Repository Analysis24DDLANGUAGELanguage Keynvarchar10
14CNVCMIS_A_1_TYPEType Pool Information Table(CMIS)36DDLANGUAGELanguage Keynvarchar10
15CNVCMIS_A_1_VIEWVIEW type Repository Analysis22DDLANGUAGELanguage Keynvarchar10
16CNVC_MENU_TXTMenu texts4DDLANGUAGELanguage Keynvarchar10
17DD02BNDTDD: Text Table for Nodes of Structured Objects4DDLANGUAGELanguage Keynvarchar10
18DD02BTTexts for Structured Objects2DDLANGUAGELanguage Keynvarchar10
19DD03NTDD: Texts for fields (Language-Dependent) (Struct.Object)3DDLANGUAGELanguage Keynvarchar10
20DD08BTDD: Texts for Association Headers, Structured Objects4DDLANGUAGELanguage Keynvarchar10
21DD12BTText Table for DD12B (Texts for Nodes Indexes)4DDLANGUAGELanguage Keynvarchar10
22DDDBFEATURESTDD: DDDBFEATURES texts (not used)3DDLANGUAGELanguage Keynvarchar10
23DDDDLSRCTDDL Source Texts2DDLANGUAGELanguage Keynvarchar10
24DDMIMETYPES_TMime Types (for Full-Text Index)2DDLANGUAGELanguage Keynvarchar10
25DDSQLSCTTexts for SQL Scripts2DDLANGUAGELanguage Keynvarchar10
26IUUC_TABLE_TXTTable short texts (standard tables)2DDLANGUAGELanguage Keynvarchar10
27IUUC_TABLE_TXTCTable short texts (customer tables)3DDLANGUAGELanguage Keynvarchar10
28SDDIC_DDLS_M_TXTDDLS Mock Data: Short Texts3DDLANGUAGELanguage Keynvarchar10
TOPActivation Program, Conversion Program, DB Utility, MC, SPDD
29DD01TR/3 DD: domain texts2DDLANGUAGELanguage Keynvarchar10
30DD02TSAP DD: SAP Table Texts2DDLANGUAGELanguage Keynvarchar10
31DD03TDD: Texts for fields (language dependent)2DDLANGUAGELanguage Keynvarchar10
32DD04TR/3 DD: Data element texts2DDLANGUAGELanguage Keynvarchar10
33DD06TR/3 DD: texts on SQL tables2DDLANGUAGELanguage Keynvarchar10
34DD07TDD: Texts for Domain Fixed Values (Language-Dependent)2DDLANGUAGELanguage Keynvarchar10
35DD08TTexts on the relationship definitions3DDLANGUAGELanguage Keynvarchar10
36DD12TText Table for DD12L (Short Descriptions of Sec. Indexes)1DDLANGUAGELanguage Keynvarchar10
37DD15TR/3 DD: texts on SAP objects1DDLANGUAGELanguage Keynvarchar10
38DD20TAS400-T_MCOBJECT: MC Object Texts1DDLANGUAGELanguage Keynvarchar10
39DD23TAS400_L-MCID: Matchcode ID Texts1DDLANGUAGELanguage Keynvarchar10
40DD25TShort Texts for Views and Lock Objects1DDLANGUAGELanguage Keynvarchar10
41DD29TAS400_L-SELCOND: Selection Condition Texts1DDLANGUAGELanguage Keynvarchar10
42DD40TText on table types2DDLANGUAGELanguage Keynvarchar10
43DD43TText Table for DD43L (Secondary Key for Table Types)3DDLANGUAGELanguage Keynvarchar10
44DDFTXRun-time object with Screen Painter texts3DDLANGUAGELanguage Keynvarchar10
TOPCondition Technique
45/SAPCND/GROUP_ITTexts for Permitted Cond. Tables and Types for Cond. Group4DDLANGUAGELanguage Keynvarchar10
46/SAPCND/REF_TYPTText for Types of Condition Reference2DDLANGUAGELanguage Keynvarchar10
47/SAPCND/REQUIRMTText Table - Implementation Number for Requirement4DDLANGUAGELanguage Keynvarchar10
48/SAPCND/T681TGeneratable Condition Tables - Texts4DDLANGUAGELanguage Keynvarchar10
TOPCross-Application Components
49/IXOS/DC_TTC02THelp for table fields, when updated /ixos/dc_ttc03t2DDLANGUAGELanguage Keynvarchar10
50/IXOS/DC_TTC03TTexts for table fields, created by using DDIF_FIELDINFO_GET2DDLANGUAGELanguage Keynvarchar10
TOPDictionary Maintenance
51DDTYPETTexts on Type Groups2DDLANGUAGELanguage Keynvarchar10
TOPF4 Help
52DD30TSearch help texts2DDLANGUAGELanguage Keynvarchar10
53DD90TR/3-DD: Text for External Index2DDLANGUAGELanguage Keynvarchar10
TOPMenu Painter
54D301TTexts for Program Functions and Menu Bars1DDLANGUAGEGUI: Language keynvarchar10
55TITLEGUI Title1DDLANGUAGELanguage Keynvarchar10
TOPPricing
56PRCC_ROUND_RULETFormula for Rounding Rules (Texts)2DDLANGUAGELanguage Keynvarchar10
TOPService Data Download
57/BDL/IFFIELD/BDL/SDCC: fiels, dataelements and domains of table6DDLANGUAGEnvarchar10
58BDLIFFIELDBDL SDCC: Table's Fields, Data Elements, Domains6DDLANGUAGEnvarchar10
TOPSyntax, Compiler, Runtime
59T022QTable for logical databases1DDLANGUAGECHAR01 data element for SYSTnvarchar10
TOPUpgrade Tools
60DDCPROTDD: Text on conversion projects3DDLANGUAGELanguage Keynvarchar10
TOPUser and Authorization Management
61AUTH_FLDINFO_TMPAuthorization fields: technical info from dictionary3DDLANGUAGELanguage Keynvarchar10