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

179 columns | Print definition?ERP 6.0  | AS4LOCAL

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/1CADMC/00000201DD02L5AS4LOCALnvarchar10
2/1CADMC/00000202DD02T6AS4LOCALnvarchar10
3/1CADMC/00000203DD08L6AS4LOCALnvarchar10
4/1CADMC/00000204DD02L5AS4LOCALnvarchar10
5/1CADMC/00000205DD02T6AS4LOCALnvarchar10
6/1CADMC/00000206DD08L6AS4LOCALnvarchar10
7/1CADMC/00000427DD04T6AS4LOCALnvarchar10
8/1CADMC/00000430DD07T6AS4LOCALnvarchar10
9/1CADMC/00001431DD02L5AS4LOCALnvarchar10
10/1CADMC/00001432DD02T6AS4LOCALnvarchar10
11/1CADMC/00001433DD08L6AS4LOCALnvarchar10
12ACMDCLSRCACM: DCL Source (Accesspolicy or Role)2AS4LOCALActivation Status of a Repository Objectnvarchar10
13ACMDCLSRCTACM: DCL Source Text Table3AS4LOCALActivation Status of a Repository Objectnvarchar10
14DD02BDD: Header for Structured Objects2AS4LOCALActivation Status of a Repository Objectnvarchar10
15DD02BNDDD: List of Nodes for a Structured Object3AS4LOCALActivation Status of a Repository Objectnvarchar10
16DD02BNDTDD: Text Table for Nodes of Structured Objects3AS4LOCALActivation Status of a Repository Objectnvarchar10
17DD02BTTexts for Structured Objects3AS4LOCALActivation Status of a Repository Objectnvarchar10
18DD03NDDD: Attributes of a Node of a Structured Object4AS4LOCALActivation Status of a Repository Objectnvarchar10
19DD03NTDD: Texts for fields (Language-Dependent) (Struct.Object)4AS4LOCALActivation Status of a Repository Objectnvarchar10
20DD05BDD: Associations for Structured Objects: Fields5AS4LOCALActivation Status of a Repository Objectnvarchar10
21DD05FDD: Associations Filter Info for Structured Objects5AS4LOCALActivation Status of a Repository Objectnvarchar10
22DD08BDD: Associations (Headers) for Structured Objects4AS4LOCALActivation Status of a Repository Objectnvarchar10
23DD08BTDD: Texts for Association Headers, Structured Objects5AS4LOCALActivation Status of a Repository Objectnvarchar10
24DD10BDD: Parameters for Structured Objects, for ex. View Entities5AS4LOCALActivation Status of a Repository Objectnvarchar10
25DD12BDD: Secondary Index Headers for Structured Objects4AS4LOCALActivation Status of a Repository Objectnvarchar10
26DD12BTText Table for DD12B (Texts for Nodes Indexes)5AS4LOCALActivation Status of a Repository Objectnvarchar10
27DD17BDD: Secondary Indexes Fields for Structured Objects5AS4LOCALActivation Status of a Repository Objectnvarchar10
28DDDDLSRCDDL Sources2AS4LOCALActivation Status of a Repository Objectnvarchar10
29DDDDLSRCTDDL Source Texts3AS4LOCALActivation Status of a Repository Objectnvarchar10
30DDSQLSCSRCSource Code Buffer for Database Procedure Proxies2AS4LOCALActivation Status of a Repository Objectnvarchar10
31DDSQLSCTTexts for SQL Scripts3AS4LOCALActivation Status of a Repository Objectnvarchar10
32SCI_DD28SZeilen einer Selektionsbedingung2AS4LOCALAktivierungsstand eines Repository-Objektesnvarchar10
TOPActivation Program, Conversion Program, DB Utility, MC, SPDD
33CD0TBSH001Veri-Struktur mit Suchhilfe-Anbindung2AS4LOCALAktivierungsstand eines Repository-Objektesnvarchar10
34DD01LDomains2AS4LOCALActivation Status of a Repository Objectnvarchar10
35DD01TR/3 DD: domain texts3AS4LOCALActivation Status of a Repository Objectnvarchar10
36DD02LSAP Tables2AS4LOCALActivation Status of a Repository Objectnvarchar10
37DD02TSAP DD: SAP Table Texts3AS4LOCALActivation Status of a Repository Objectnvarchar10
38DD03LTable Fields3AS4LOCALActivation Status of a Repository Objectnvarchar10
39DD03TDD: Texts for fields (language dependent)3AS4LOCALActivation Status of a Repository Objectnvarchar10
40DD04LData elements2AS4LOCALActivation Status of a Repository Objectnvarchar10
41DD04TR/3 DD: Data element texts3AS4LOCALActivation Status of a Repository Objectnvarchar10
42DD05SForeign key fields4AS4LOCALActivation Status of a Repository Objectnvarchar10
43DD06LPool/cluster structures2AS4LOCALActivation Status of a Repository Objectnvarchar10
44DD06TR/3 DD: texts on SQL tables3AS4LOCALActivation Status of a Repository Objectnvarchar10
45DD07LR/3 DD: values for the domains2AS4LOCALActivation Status of a Repository Objectnvarchar10
46DD07TDD: Texts for Domain Fixed Values (Language-Dependent)3AS4LOCALActivation Status of a Repository Objectnvarchar10
47DD08LR/3 DD: relationship definitions3AS4LOCALActivation Status of a Repository Objectnvarchar10
48DD08TTexts on the relationship definitions4AS4LOCALActivation Status of a Repository Objectnvarchar10
49DD09LDD: Technical settings of tables2AS4LOCALActivation Status of a Repository Objectnvarchar10
50DD12LR/3 S_SECINDEX: secondary indexes, header;3AS4LOCALActivation Status of a Repository Objectnvarchar10
51DD12TText Table for DD12L (Short Descriptions of Sec. Indexes)4AS4LOCALActivation Status of a Repository Objectnvarchar10
52DD14SR/3 DD: components of SAP objects3AS4LOCALActivation Status of a Repository Objectnvarchar10
53DD15LR/3 DD: SAP objects2AS4LOCALActivation Status of a Repository Objectnvarchar10
54DD15TR/3 DD: texts on SAP objects3AS4LOCALActivation Status of a Repository Objectnvarchar10
55DD16SR/3 DD: SQL table fields3AS4LOCALActivation Status of a Repository Objectnvarchar10
56DD17SR/3 S_SECINDEX: secondary indexes, fields4AS4LOCALActivation Status of a Repository Objectnvarchar10
57DD20LMatchcode objects2AS4LOCALActivation Status of a Repository Objectnvarchar10
58DD20TAS400-T_MCOBJECT: MC Object Texts3AS4LOCALActivation Status of a Repository Objectnvarchar10
59DD21SS-MCIDTABLE: Tables for a MC ID3AS4LOCALActivation Status of a Repository Objectnvarchar10
60DD23LMatchcode ID3AS4LOCALActivation Status of a Repository Objectnvarchar10
61DD23TAS400_L-MCID: Matchcode ID Texts4AS4LOCALActivation Status of a Repository Objectnvarchar10
62DD24SFields of a matchcode ID3AS4LOCALActivation Status of a Repository Objectnvarchar10
63DD25LAggregate Header (Views, MC Objects, Lock Objects)2AS4LOCALActivation Status of a Repository Objectnvarchar10
64DD25TShort Texts for Views and Lock Objects3AS4LOCALActivation Status of a Repository Objectnvarchar10
65DD26SBase tables and foreign key relationships for a view2AS4LOCALActivation Status of a Repository Objectnvarchar10
66DD27SFields in an Aggregate (View, MC Object, Lock Object)2AS4LOCALActivation Status of a Repository Objectnvarchar10
67DD28SLines of a selection condition2AS4LOCALActivation Status of a Repository Objectnvarchar10
68DD29LSelection Condition for Views and MC IDs2AS4LOCALActivation Status of a Repository Objectnvarchar10
69DD29TAS400_L-SELCOND: Selection Condition Texts3AS4LOCALActivation Status of a Repository Objectnvarchar10
70DD40LTable types (internal tables defined in DD)2AS4LOCALActivation Status of a Repository Objectnvarchar10
71DD40TText on table types3AS4LOCALActivation Status of a Repository Objectnvarchar10
72DD42SKey fields for table types (internal tab. defined in DD)4AS4LOCALActivation Status of a Repository Objectnvarchar10
73DD43LSecondary Key for Table Types3AS4LOCALActivation Status of a Repository Objectnvarchar10
74DD43TText Table for DD43L (Secondary Key for Table Types)4AS4LOCALActivation Status of a Repository Objectnvarchar10
75DDPATHDD: Definition of access paths2AS4LOCALActivation Status of a Repository Objectnvarchar10
TOPBasis Services Communication Interfaces
76SFSQB_QUERYMain Table of Query Builder3AS4LOCALActivation Status of a Repository Objectnvarchar10
77SFSQB_QUERY_TDescription of the Queries3AS4LOCALActivation Status of a Repository Objectnvarchar10
TOPBusiness Navigator
78DF03LEvents2AS4LOCALActivation Status of a Repository Objectnvarchar10
79DF03TEvent descriptions4AS4LOCALActivation Status of a Repository Objectnvarchar10
80DF04LSoftware Modules/Functions2AS4LOCALActivation Status of a Repository Objectnvarchar10
81DF04TFunction description4AS4LOCALActivation Status of a Repository Objectnvarchar10
82DF06LInformation flow2AS4LOCALActivation Status of a Repository Objectnvarchar10
83DF06TInformation Flow Names3AS4LOCALActivation Status of a Repository Objectnvarchar10
84DF07LObject Types2AS4LOCALActivation Status of a Repository Objectnvarchar10
85DF07TObject Type Names3AS4LOCALActivation Status of a Repository Objectnvarchar10
86DF08LALE Messages2AS4LOCALActivation Status of a Repository Objectnvarchar10
87DF08TMessage Names3AS4LOCALActivation Status of a Repository Objectnvarchar10
88DF10LALE Message Flows2AS4LOCALActivation Status of a Repository Objectnvarchar10
89DF10TMessage Flow Names3AS4LOCALActivation Status of a Repository Objectnvarchar10
90DF11LScenario Processes2AS4LOCALActivation Status of a Repository Objectnvarchar10
91DF11TScenario Names3AS4LOCALActivation Status of a Repository Objectnvarchar10
92DF12LOrganizational Units2AS4LOCALActivation Status of a Repository Objectnvarchar10
93DF12TOrganization Unit Names3AS4LOCALActivation Status of a Repository Objectnvarchar10
94DF13LEnterprise areas2AS4LOCALActivation Status of a Repository Objectnvarchar10
95DF13TEnterprise Area Names3AS4LOCALActivation Status of a Repository Objectnvarchar10
96DF14AApplication Components: Data for SAP Applications2AS4LOCALActivation Status of a Repository Objectnvarchar10
97DF14LApplication Components2AS4LOCALActivation Status of a Repository Objectnvarchar10
98DF14TBusiness Application Component Names4AS4LOCALActivation Status of a Repository Objectnvarchar10
99DF15LCommunication Relationships2AS4LOCALActivation Status of a Repository Objectnvarchar10
100DF15TCommunications Flow Names3AS4LOCALActivation Status of a Repository Objectnvarchar10
101DF16LGroups2AS4LOCALActivation Status of a Repository Objectnvarchar10
102DF16TGroup names3AS4LOCALActivation Status of a Repository Objectnvarchar10
103DF18LCollaborative Business Scenario2AS4LOCALActivation Status of a Repository Objectnvarchar10
104DF18TCollaborative Business Scenario: Description4AS4LOCALActivation Status of a Repository Objectnvarchar10
105DF30SObject Relationships6AS4LOCALActivation Status of a Repository Objectnvarchar10
106DF32SAssignment of IMG chapters to functions5AS4LOCALActivation Status of a Repository Objectnvarchar10
107DF40DDiagam Management Information3AS4LOCALActivation Status of a Repository Objectnvarchar10
108DF41SNodes3AS4LOCALActivation Status of a Repository Objectnvarchar10
109DF42SLinks3AS4LOCALActivation Status of a Repository Objectnvarchar10
110DF43SLink points6AS4LOCALActivation Status of a Repository Objectnvarchar10
111DF50DVariant diagram radio button3AS4LOCALActivation Status of a Repository Objectnvarchar10
112DF50LVariants2AS4LOCALActivation Status of a Repository Objectnvarchar10
113DF50OVariant objects4AS4LOCALActivation Status of a Repository Objectnvarchar10
114DF50TVariant descriptions3AS4LOCALActivation Status of a Repository Objectnvarchar10
115DF52AFilter Action Log2AS4LOCALActivation Status of a Repository Objectnvarchar10
116DF52LFilter2AS4LOCALActivation Status of a Repository Objectnvarchar10
117DF52TFilter names3AS4LOCALActivation Status of a Repository Objectnvarchar10
118DF53SActive variant on variant node5AS4LOCALActivation Status of a Repository Objectnvarchar10
119DF54SActive nodes for a variant5AS4LOCALActivation Status of a Repository Objectnvarchar10
120DF55LVariants3AS4LOCALActivation Status of a Repository Objectnvarchar10
121DF55TVariant name5AS4LOCALActivation Status of a Repository Objectnvarchar10
122DFMLOLinks from R/3 Reference Model objects to mail folder4AS4LOCALActivation Status of a Repository Objectnvarchar10
TOPComputer Aided Process Planning
123TCAPTTables used in CAPP formulas and methods3AS4LOCALActivation Status of a Repository Objectnvarchar10
TOPCondition Technique
124/SAPCND/CTLISTDet. Procedure5AS4LOCALActivation Status of a Repository Objectnvarchar10
125/SAPCND/CTLISTIElements in Determ. Procedure7AS4LOCALActivation Status of a Repository Objectnvarchar10
126/SAPCND/CTLISTTTexts for Condition Type Lists6AS4LOCALActivation Status of a Repository Objectnvarchar10
127/SAPCND/T681Condition Table Structure4AS4LOCALActivation Status of a Repository Objectnvarchar10
128/SAPCND/T681ECondition Table Structure Field6AS4LOCALActivation Status of a Repository Objectnvarchar10
129/SAPCND/T681TGeneratable Condition Tables - Texts5AS4LOCALActivation Status of a Repository Objectnvarchar10
TOPData Modeler
130DM02LDM Entity Type2AS4LOCALActivation Status of a Repository Objectnvarchar10
131DM02SDM Entity Type Definition Variant2AS4LOCALActivation Status of a Repository Objectnvarchar10
132DM02TDM Entity Type Short Text3AS4LOCALActivation Status of a Repository Objectnvarchar10
133DM03SDM Attribute2AS4LOCALActivation Status of a Repository Objectnvarchar10
134DM25LDM View-Entity Type Assignment2AS4LOCALActivation Status of a Repository Objectnvarchar10
135DM26LDM Table-Entity Type Assignment2AS4LOCALActivation Status of a Repository Objectnvarchar10
136DM40LDM Data Model2AS4LOCALActivation Status of a Repository Objectnvarchar10
137DM40TDM Data Model Short Text3AS4LOCALActivation Status of a Repository Objectnvarchar10
138DM41SDM Data Model Hierarchy2AS4LOCALActivation Status of a Repository Objectnvarchar10
139DM42SDM Relationship2AS4LOCALActivation Status of a Repository Objectnvarchar10
140DM42TDM Relationship Short Text3AS4LOCALActivation Status of a Repository Objectnvarchar10
141DM43TDM Entity Type Aliases3AS4LOCALActivation Status of a Repository Objectnvarchar10
142DM45LDM Specialization Category2AS4LOCALActivation Status of a Repository Objectnvarchar10
143DM45TDM Short text for specialization type3AS4LOCALActivation Status of a Repository Objectnvarchar10
144DM46SDM Specialization2AS4LOCALActivation Status of a Repository Objectnvarchar10
145DM48LDM Area2AS4LOCALActivation Status of a Repository Objectnvarchar10
146DM48TDM Area Short Text3AS4LOCALActivation Status of a Repository Objectnvarchar10
147DM50SDM ADW Position2AS4LOCALActivation Status of a Repository Objectnvarchar10
148DM50TDM ADW Text on Entity Type3AS4LOCALActivation Status of a Repository Objectnvarchar10
TOPF4 Help
149DD30LSearch helps2AS4LOCALActivation Status of a Repository Objectnvarchar10
150DD30TSearch help texts3AS4LOCALActivation Status of a Repository Objectnvarchar10
151DD31SAssignment of search helps to collective search helps3AS4LOCALActivation Status of a Repository Objectnvarchar10
152DD32SSearch Help Parameter3AS4LOCALActivation Status of a Repository Objectnvarchar10
153DD33SAssignment of search help fields5AS4LOCALActivation Status of a Repository Objectnvarchar10
154DD35LSearch help attachments to structures: Headers3AS4LOCALActivation Status of a Repository Objectnvarchar10
155DD36SParameter-field assignments for search help attachment4AS4LOCALActivation Status of a Repository Objectnvarchar10
156DD90LHeader Information for External Index2AS4LOCALActivation Status of a Repository Objectnvarchar10
157DD90TR/3-DD: Text for External Index3AS4LOCALActivation Status of a Repository Objectnvarchar10
158DD91SDocID Key Definition of External Index3AS4LOCALActivation Status of a Repository Objectnvarchar10
159DD92SMapping of R/3 Data on External Index5AS4LOCALActivation Status of a Repository Objectnvarchar10
160DD93SAttributes of an External Index3AS4LOCALActivation Status of a Repository Objectnvarchar10
161DD94SLanguages of an Index Category4AS4LOCALActivation Status of a Repository Objectnvarchar10
162DD96SSynchronization Tables4AS4LOCALActivation Status of a Repository Objectnvarchar10
TOPFast Search Infrastructure
163SFSG_DEF_DDatabase Table for GFS Definitions (Design Time)2AS4LOCALActivation Status of a Repository Objectnvarchar10
164SFSG_DEF_DTText Table for SFSG_DEF_D2AS4LOCALActivation Status of a Repository Objectnvarchar10
165SFSG_QR_DEFRepository Table for Query Definition2AS4LOCALActivation Status of a Repository Objectnvarchar10
166SFSG_QR_INPUTResult mapping of query definition2AS4LOCALActivation Status of a Repository Objectnvarchar10
167SFSG_QR_RESULTResult mapping of query definition2AS4LOCALActivation Status of a Repository Objectnvarchar10
168SFSG_Q_CONDQuery Condition2AS4LOCALActivation Status of a Repository Objectnvarchar10
169SFSG_Q_GROUPQuery Group2AS4LOCALActivation Status of a Repository Objectnvarchar10
170SFSG_Q_JOINQuery Joins2AS4LOCALActivation Status of a Repository Objectnvarchar10
171SFSG_Q_RESULTResult Table for Query2AS4LOCALActivation Status of a Repository Objectnvarchar10
172SFSG_Q_TABLEQuery Tables2AS4LOCALActivation Status of a Repository Objectnvarchar10
173SFSG_TAB_POSItem Details in View Builder2AS4LOCALActivation Status of a Repository Objectnvarchar10
TOPService Data Download
174/BDL/IFHEAD/BDL/SDCC: Headerinfo for Tables/Structures4AS4LOCALSingle-Character Indicatornvarchar10
175BDLIFHEADBDL SDCC: Header Info for Tables/Structures4AS4LOCALSingle-Character Indicatornvarchar10
TOPTranslation Tools
176TGRAPHTranslation Graphs: General4AS4LOCALActivation Status of a Repository Objectnvarchar10
177TGRAPHDEVCTranslation Graphs: General5AS4LOCALActivation Status of a Repository Objectnvarchar10
TOPUpgrade Tools
178UPG_DD12LICNV: Secondary Indexes - Header3AS4LOCALnvarchar10
179UPG_DD17SICNV: Secondary Indexes - Fields4AS4LOCALnvarchar10