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
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPCH386A/P Invoice
8OVTG52Tax Definition
9OPOR386Purchase Order
10JDT1124Journal Entry - Rows

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OVPM154Outgoing Payments
5OIVL77Whse Journal
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

85 columns | Print definition?ERP 6.0  | DDTEXT

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1ACMDCLSRCTACM: DCL Source Text Table4DDTEXTExplanatory short textnvarchar600
2CNVCMIS_A_1_DOMASelection of Object Type Master information19DDTEXTShort Description of Repository Objectsnvarchar600
3CNVCMIS_A_1_DTELSelection of Object Type Master information24DDTEXTShort Description of Repository Objectsnvarchar600
4CNVCMIS_A_1_ENQUENQU Data (Header)17DDTEXTExplanatory short textnvarchar600
5CNVCMIS_A_1_INDXIndx Table(CMIS)23DDTEXTExplanatory short textnvarchar600
6CNVCMIS_A_1_SHLPSearch Help Data-Header18DDTEXTExplanatory short textnvarchar600
7CNVCMIS_A_1_TTYPTable types for Repository Analysis25DDTEXTExplanatory short textnvarchar600
8CNVCMIS_A_1_TYPEType Pool Information Table(CMIS)35DDTEXTExplanatory short textnvarchar600
9CNVCMIS_A_1_VIEWVIEW type Repository Analysis23DDTEXTExplanatory short textnvarchar600
10CNVCMIS_CONFIGCMIS Mig: Configuration table for conflicts8DDTEXTExplanatory short textnvarchar600
11CNVC_JSTATJob status10DDTEXTExplanatory short textnvarchar600
12CNVC_SCOL_ORSCOL Object repository10DDTEXTExplanatory short textnvarchar600
13CNVC_SCWB_TRIGTrigger10DDTEXTExplanatory short textnvarchar600
14CNVC_SCWB_XTTrigger header table6DDTEXTExplanatory short textnvarchar600
15CNVTDMS_BP_DATAStore table and fields data from remote (sender) system5DDTEXTShort Description of Repository Objectsnvarchar600
16CNVTDMS_EC_STMPCTable to store copy of CNVTDMS_02_STEMP data with Table Desc11DDTEXTShort Description of Repository Objectsnvarchar600
17CNV_10400_TABTables for analysis6DDTEXTShort Description of Repository Objectsnvarchar600
18CNV_20200_CAJODifferences in cash journal master data8DDTEXTExplanatory short textnvarchar600
19CNV_20200_CJTRDifferences in cash journal business transactions8DDTEXTExplanatory short textnvarchar600
20CNV_20201_TABTConversion rules (CNV_20201_RNMB-CNV_RULE): Texts4DDTEXTExplanatory short textnvarchar600
21DD02BNDTDD: Text Table for Nodes of Structured Objects5DDTEXTExplanatory short textnvarchar600
22DD02BTTexts for Structured Objects4DDTEXTShort Description of Repository Objectsnvarchar600
23DD03NTDD: Texts for fields (Language-Dependent) (Struct.Object)7DDTEXTShort Description of Repository Objectsnvarchar600
24DD08BTDD: Texts for Association Headers, Structured Objects6DDTEXTExplanatory short textnvarchar600
25DD12BTText Table for DD12B (Texts for Nodes Indexes)6DDTEXTExplanatory short textnvarchar600
26DDDDLSRCTDDL Source Texts4DDTEXTExplanatory short textnvarchar600
27DDSQLSCTTexts for SQL Scripts4DDTEXTExplanatory short textnvarchar600
28EDX_OBJ_TYPEEDX: Object types for documents2DDTEXTShort Text for Fixed Valuesnvarchar600
29FARR_C_CONFLI_EXExcluding field to conflict contract5DDTEXTShort Description of Repository Objectsnvarchar600
30FSH_CT_LISTFSH : Table for Determ.Procedure search help view5DDTEXTExplanatory short textnvarchar600
31GRFNBRFPATTRSTBRFPlus - Exception function attribute field description6DDTEXTExplanatory short textnvarchar600
32IUUC_TABLE_TXTTable short texts (standard tables)3DDTEXTShort Description of Repository Objectsnvarchar600
33IUUC_TABLE_TXTCTable short texts (customer tables)4DDTEXTShort Description of Repository Objectsnvarchar600
34SDDIC_DDLS_M_TXTDDLS Mock Data: Short Texts4DDTEXTExplanatory short textnvarchar600
35SXVIEW_MOCK_COLXView Mock Data: Columns11DDTEXTShort Description of Repository Objectsnvarchar600
36TKEPTTexts for SAP tables(entry aid for defining characteristics)5DDTEXTShort Description of Repository Objectsnvarchar600
37ZTR1Tabellen, die nicht über Vorrat übersetzt werden6DDTEXTKurzbeschreibung von Repository-Objektennvarchar600
TOPActivation Program, Conversion Program, DB Utility, MC, SPDD
38CD0TBSH001Veri-Struktur mit Suchhilfe-Anbindung19DDTEXTErläuternder Kurztextnvarchar600
39DD01TR/3 DD: domain texts5DDTEXTShort Description of Repository Objectsnvarchar600
40DD02TSAP DD: SAP Table Texts5DDTEXTShort Description of Repository Objectsnvarchar600
41DD03TDD: Texts for fields (language dependent)5DDTEXTShort Description of Repository Objectsnvarchar600
42DD04TR/3 DD: Data element texts5DDTEXTShort Description of Repository Objectsnvarchar600
43DD06TR/3 DD: texts on SQL tables5DDTEXTExplanatory short textnvarchar600
44DD07TDD: Texts for Domain Fixed Values (Language-Dependent)6DDTEXTShort Text for Fixed Valuesnvarchar600
45DD08TTexts on the relationship definitions6DDTEXTExplanatory short textnvarchar600
46DD12TText Table for DD12L (Short Descriptions of Sec. Indexes)6DDTEXTExplanatory short textnvarchar600
47DD15TR/3 DD: texts on SAP objects5DDTEXTShort Description of Repository Objectsnvarchar600
48DD25TShort Texts for Views and Lock Objects5DDTEXTExplanatory short textnvarchar600
49DD29TAS400_L-SELCOND: Selection Condition Texts5DDTEXTExplanatory short textnvarchar600
50DD40TText on table types4DDTEXTExplanatory short textnvarchar600
TOPActual CostingMaterial Ledger
51CKMLCURText for currency type and valuation type4DDTEXTShort Text for Fixed Valuesnvarchar600
TOPBasic Functions
52T883TDescriptions of FI-SL user tables4DDTEXTShort Description of Repository Objectsnvarchar600
TOPClaims Management
53TICL283Change History: Tables3DDTEXTShort Description of Repository Objectsnvarchar600
TOPCondition Technique
54/SAPCND/CTLISTTTexts for Condition Type Lists7DDTEXTExplanatory short textnvarchar600
55/SAPCND/REQUIRMTText Table - Implementation Number for Requirement5DDTEXTExplanatory short textnvarchar600
56/SAPCND/T681TGeneratable Condition Tables - Texts6DDTEXTExplanatory short textnvarchar600
57PRTC_PROD_GRP_TProduct Group4DDTEXTExplanatory short textnvarchar600
TOPContract Accounts Receivable and Payable
58DFKKCOLLP_IM_WBuffer: Coll. Agency Info File (Item Master Data Change)14DDTEXTName of Changenvarchar600
TOPCorrespondence Tool
59TFK070CORRAPPLKCorrespondence - Structure for Application Search Help3DDTEXTShort Text for Fixed Valuesnvarchar600
TOPCross-Application Components
60/IXOS/DC_TTC03TTexts for table fields, created by using DDIF_FIELDINFO_GET4DDTEXTShort Description of Repository Objectsnvarchar600
TOPData Retention Tool
61TXW_DIRSEGData file segment directory (replaced by txw_dirsg2: uuids)25DDTEXTShort Description of Repository Objectsnvarchar600
62TXW_DIRSG2Data file segment directory25DDTEXTShort Description of Repository Objectsnvarchar600
TOPDictionary Maintenance
63DDTYPETTexts on Type Groups3DDTEXTExplanatory short textnvarchar600
TOPElectronic Data Interchange
64WRF_PRICAT_PREPrice Catalog Default10DDTEXTShort Description of Repository Objectsnvarchar600
65WRF_PRICAT_PRE_CPrice Catalog Default Customizing for Client Level10DDTEXTShort Description of Repository Objectsnvarchar600
TOPF4 Help
66DD30TSearch help texts4DDTEXTExplanatory short textnvarchar600
67DD90TR/3-DD: Text for External Index4DDTEXTShort Description of Repository Objectsnvarchar600
TOPFast Search Infrastructure
68SFSRFW_IDX_DTReplication Framework - Index Definition Description4DDTEXTShort Description of Repository Objectsnvarchar600
TOPFinancials Basis
69UGR31008FIN Master Data: Dummy Field Names with Properties26DDTEXTShort Description of Repository Objectsnvarchar600
70UGR31022FIN Master Data: Buffer Table f.Fields of Extract Structures24DDTEXTShort Description of Repository Objectsnvarchar600
TOPLocalization
71GLOFAACNTRLTCountry-Specific Table Name4DDTEXTShort Description of Repository Objectsnvarchar600
TOPMedia Product Sales and Distribution
72TJKSDSALESQUANAssignment of Calculation Rule to Sales Figure8DDTEXTShort Description of Repository Objectsnvarchar600
73TJKSDSALESQUANINDefine Assignment of Sales Indicator to Quantity Fields5DDTEXTShort Description of Repository Objectsnvarchar600
TOPPricing
74PRCC_ROUND_RULETFormula for Rounding Rules (Texts)3DDTEXTExplanatory short textnvarchar600
TOPService Data Download
75/BDL/IFFIELD/BDL/SDCC: fiels, dataelements and domains of table17DDTEXTnvarchar600
76BDLIFFIELDBDL SDCC: Table's Fields, Data Elements, Domains17DDTEXTnvarchar600
TOPSyntax, Compiler, Runtime
77T022QTable for logical databases3DDTEXTCHAR40 for SYSTnvarchar400
TOPTransport Management System
78TCEQUASTMS: Quality Clients and Systems3DDTEXTExplanatory short textnvarchar600
79TCESYSTTText for System Table4DDTEXTExplanatory short textnvarchar600
TOPTransport Organizer
80OBJSUBTObject: Short Description of Sub-Object5DDTEXTExplanatory short textnvarchar600
81OBJTDescription of Type T Objects (Separate Transaction)4DDTEXTExplanatory short textnvarchar600
82TLOGOTObsolete3DDTEXTExplanatory short textnvarchar600
83TSYSTOBSOLETE: Do not use (see TCESYST)2DDTEXTObsolete field (do not use anymore)nvarchar600
84TSYSTTOBSOLETE: Do not use (see TCESYSTT)3DDTEXTShort Description of Repository Objectsnvarchar600
TOPUpgrade Tools
85DDCPROTDD: Text on conversion projects4DDTEXTShort Description of Repository Objectsnvarchar600