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

44 columns | Print definition?ERP 6.0  | POSITION

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1CNVMBTTABSTRUCField list of tables for file transfer8POSITIONPosition of the field in the tablenvarchar40
2DD03NDDD: Attributes of a Node of a Structured Object5POSITIONDD: Marked Position in a Repeat Groupint100
3DDFIELDANNODD: Generic Annotations: Fields4POSITIONDD: Marked Position in a Repeat Groupint100
4DDHEADANNODD: Annotations: Header3POSITIONDD: Marked Position in a Repeat Groupint100
5DDREPLINTABFDDD: Nametab Field Structure4POSITIONPosition of the field in the tablenvarchar40
6DDXTF_CONV_UCNametab Feldstruktur für verzögertes Schreiben3POSITIONPosition des Feldes in der Tabellenvarchar40
7DDYTF_CONV_UCUsed during UCMIG within DMO of SUM3POSITIONPosition of the field in the tablenvarchar40
8T370ZHistory-related fields6POSITIONTable offsetnvarchar50
9TFM12Function Relationships of a Hierarchy Type10POSITIONPosition in a hierarchy levelsmallint50
10TSE05ABAP/4 Editor insert commands3POSITIONEDIC: Position keynvarchar20
TOPActivation Program, Conversion Program, DB Utility, MC, SPDD
11DD03LTable Fields5POSITIONPosition of the field in the tablenvarchar40
12DD16SR/3 DD: SQL table fields5POSITIONPosition of the field in the tablenvarchar40
13DD17SR/3 S_SECINDEX: secondary indexes, fields3POSITIONPosition of the field in the tablenvarchar40
14DD21SS-MCIDTABLE: Tables for a MC ID5POSITIONPosition in a repetition groupnvarchar40
15DD24SFields of a matchcode ID6POSITIONPosition in a repetition groupnvarchar40
16DD28SLines of a selection condition4POSITIONPosition in a repetition groupnvarchar40
17DDFTXRun-time object with Screen Painter texts4POSITIONPosition of the field in the tablenvarchar40
18DDXTFNametab Field Structure for Delayed Writing3POSITIONPosition of the field in the tablenvarchar40
TOPCapacity Leveling
19TCY38MTSort key for the planning table4POSITIONItem counter for sort keynvarchar30
20TCY38_MSort key for the planning table3POSITIONItem counter for sort keynvarchar30
21TCY39_SSelected fields for a layout key6POSITIONPosition of the field in the requirements linenvarchar30
TOPData Modeler
22DM43TDM Entity Type Aliases4POSITIONAttribute positionnvarchar20
23DM50TDM ADW Text on Entity Type4POSITIONAttribute positionnvarchar20
TOPF1 Help
24F4COLSColumn selection in F45POSITIONVerification: Column positionnvarchar20
TOPJoint Venture und Production Sharing Accounting
25T8J0HJV Billing Form SAPscript Events8POSITIONSTXD event typenvarchar10
26T8J0NJV Billing level - SapScript text elements7POSITIONSTXD event typenvarchar10
TOPPeriodical Sales and Distribution
27JRTRVPOSIS-M/SD: Item in Truck Route Contract3POSITIONItem number in truck route contractnvarchar60
TOPProcess Management
28TC52ACustomizing of Process Instruction Positions in PI Sheet4POSITIONPosition of generated proc. instructions in the ctrl. recipenvarchar20
TOPResults Recording
29QAMRCharacteristic results during inspection processing75POSITIONTest Positionnvarchar40
30QASEResults table for the sample unit50POSITIONTest Positionnvarchar40
31QASRSample results for inspection characteristics72POSITIONTest Positionnvarchar40
TOPService Implementation Workbench
32TSIW_SXF_FIELDSignature Exchange Format - Field8POSITIONSXF Field Positionnvarchar40
TOPTransport Organizer
33OBJSUBSubobjects11POSITIONPosition of Tcode in IMGnvarchar20
TOPUpgrade - General
34DDMTFNametab Field Structure for Delayed Writing3POSITIONPosition of the field in the tablenvarchar40
35DDMTF_ISUNametab Field Structure for Delayed Writing3POSITIONPosition of the field in the tablenvarchar40
36DDMTF_SAVNametab Feldstruktur für verzögertes Schreiben3POSITIONPosition des Feldes in der Tabellenvarchar40
37DDXTF_SAVNametab Feldstruktur für verzögertes Schreiben3POSITIONPosition des Feldes in der Tabellenvarchar40
38DDXTF_SHDNametab Feldstruktur für verzögertes Schreiben3POSITIONPosition des Feldes in der Tabellenvarchar40
39DDXTF_STDNametab Feldstruktur für verzögertes Schreiben3POSITIONPosition des Feldes in der Tabellenvarchar40
40DDYTFSubstitution Nametab (shadow-shadow-nametab for DDXTF)3POSITIONPosition of the field in the tablenvarchar40
TOPUpgrade Tools
41ICNV31LNametab for Incremental Conversion5POSITIONvarbinary20
42UPG_DD17SICNV: Secondary Indexes - Fields3POSITIONnvarchar40
TOPUser Administration
43USR08Table for user menu entries4POSITIONPosition in table usr08 for one usernvarchar30
44USR09Entries for user menus (work areas)5POSITIONPosition in table usr08 for one usernvarchar30