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

72 columns | Print definition?ERP 6.0  | TYPENAME

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/KORA/OBJREL_Tkr: Objektrelationen5TYPENAMEkr:Schema elementnvarchar80
2/KORA/SCHEMA_Tkr: schema information2TYPENAMEkr:Schema elementnvarchar80
3/KORA/SCHTXT_Tkr: language dependend type description2TYPENAMEkr:Schema elementnvarchar80
4/PLMB/EXP_ADDINFDownload Data: Additional Information5TYPENAMEName of Dictionary Typenvarchar300
5CNVCMIS_A_1_TTYPTable types for Repository Analysis5TYPENAMEName of table typenvarchar300
6CNVCMIS_A_1_TYPFTable type text for Repository Analysis5TYPENAMEName of table typenvarchar300
7CNV_ADT_DP_FUNCT. Summary: Data provider function (version-dependent)5TYPENAMEName of Dictionary Typenvarchar300
8COM_IPC_PROP_ERPIPC Settings (User Interface, Scenario-Spec., User-Spec.)3TYPENAMEName of Typenvarchar320
9DMC_SD_FPARAMA1S: Formal parameters of a Semantic Descriptor6TYPENAMEDatatypenvarchar630
10HRP1893DB Table for Infotype 189321TYPENAMEPrevious Education Type Namenvarchar130
TOPActivation Program, Conversion Program, DB Utility, MC, SPDD
11DD40LTable types (internal tables defined in DD)1TYPENAMEName of table typenvarchar300
12DD40TText on table types1TYPENAMEName of table typenvarchar300
13DD42SKey fields for table types (internal tab. defined in DD)1TYPENAMEName of table typenvarchar300
14DD43LSecondary Key for Table Types1TYPENAMEName of table typenvarchar300
15DD43TText Table for DD43L (Secondary Key for Table Types)1TYPENAMEName of table typenvarchar300
16DDTYPESTable of all Dictionary types and classes1TYPENAMEName of Dictionary Typenvarchar300
TOPApplication Framework
17MDG_MDF2101List of Generated DDIC Elements1TYPENAMEName of Dictionary Typenvarchar300
TOPBasic Functions
18EMMA_COBJECTObjects and Field Values for Case9TYPENAMEName of Dictionary Typenvarchar300
TOPBRFplus - ABAP-Based Business Rules
19FDT_DOBJ_0010FDT: Data Object Type - Typename4TYPENAMEName of Dictionary Typenvarchar620
20FDT_DOBJ_0010AFDT: Data Object Type - Typename4TYPENAMEName of Dictionary Typenvarchar620
21FDT_DOBJ_0010SFDT: Data Object Type - Typename3TYPENAMEName of Dictionary Typenvarchar620
22FDT_DOBJ_0010TFDT: Data Object Type - Typename3TYPENAMEName of Dictionary Typenvarchar620
TOPBudget Control System
23BUBAS_CLUSTERCluster to store application log6TYPENAMEName of table typenvarchar300
TOPBudgeting
24BUKUTXTTEMPLVARVariables for Budget Text Templates6TYPENAMEName of Dictionary Typenvarchar300
TOPBusiness Analytics
25TCOCOMAPTYPESMapping: Type Remote System <--> Object Type SEM5TYPENAMEType Namenvarchar100
26UAB_FIELD_CALMemorize Fields of PDCE Join which Kind of Costing3TYPENAMEType Namenvarchar100
27UAB_FUNC_FIELDFields for Use in Formula Functions (PDCE)6TYPENAMEType Namenvarchar100
28UAB_TLNE_CAL_AMTTrigger Table for Table Line to Calculate Amount in PDCE3TYPENAMEType Namenvarchar100
29UAB_TLNE_CAL_QTYTrigger Table for Table Line to Calculate Amount in PDCE3TYPENAMEType Namenvarchar100
30UAMDF4CHEException Table for Field Checks and F46TYPENAMEType Namenvarchar100
31UAPRICETABLEPrice Tables Assignment3TYPENAMEType Namenvarchar100
32UAREP_CONFIG1Configuration for UA Reports3TYPENAMEType Namenvarchar100
TOPBusiness Configuration Tools Runtime
33SC2_PG_NODEC2 Server: Node Generation Details5TYPENAMEName of Dictionary Typenvarchar300
TOPBusiness Process Engine
34BRR_ATTRIBCustom Attribute or Rule6TYPENAMECharacter field, length 64nvarchar640
35BRR_ATTRIB_CCustom Attribute or Rule7TYPENAMECharacter field, length 64nvarchar640
TOPCentral Part of Product Master
36COMS_PR_ORG_KEYGComponents of Differentiation Key (Gen. Link-Handler)5TYPENAMEData Type of the Key Component (External Format)nvarchar300
TOPData Conversion
37DMC_CSTRTTable for Storing Complex Data Type Information3TYPENAMEName of Dictionary Typenvarchar300
38DMC_PARAMDMC: Formal Parameters in Rule and Operation Calls6TYPENAMEDMC: Data Type Namenvarchar630
TOPDictionary Maintenance
39GSUBTYPESCentral Table for TYPE-POOL Types and BAdIs1TYPENAMESubty. Namenvarchar300
40GSUBT_CONFLICTSLog Table for Name Conflicts3TYPENAMESubty. Namenvarchar300
41GSUBT_EXCEPTException Table for GSUBTYPES3TYPENAMESubty. Namenvarchar300
TOPFinancials Basis
42UGMD2101FIN Master Data: List of Generated DDIC Elements2TYPENAMEName of Dictionary Typenvarchar300
TOPOLAP Technology
43RSTTU_TRANSTransformations for Test Utilities1TYPENAMEText field length 200nvarchar2000
TOPPayroll General Parts
44T52RELIDHR: Description of cluster in table PCLx2TYPENAMEType name in dictionary for HR cluster tables PCLxnvarchar300
TOPProxy Generation
45SPROXSIGProxy Runtime Metadata (Substitution Table)6TYPENAMEName of Dictionary Typenvarchar300
TOPSAP Business Workflow
46SWDSCNTIDXWF Definition: Container Index (Where-Used List from 610)10TYPENAMEData element (semantic domain)nvarchar300
47SWD_CNTIDXWF Definition: Container Index (Where-Used List from 610)11TYPENAMEData element (semantic domain)nvarchar300
48SWFDCNTSDTContainer Editor: List of Standard Data Types2TYPENAMEName of Dictionary Typenvarchar300
49SWFDLOGCMPLog Manager: Components of a Log Type4TYPENAMEName of Dictionary Typenvarchar300
50SWU_DBSTRSystem Table for Structure Persistence Settings2TYPENAMEStructure Namenvarchar300
TOPSAP Records Management
51SRMRGETYPETypes of Rule Elements1TYPENAMEElement Typenvarchar320
52SRMRGETYPTTexts for Rule Element Types1TYPENAMEElement Typenvarchar320
53SRMRGETYPUUser Interface Classes for Rule Element Types1TYPENAMEElement Typenvarchar320
54SRMRGRTYPERNG: Rule Types1TYPENAMEType of Rulenvarchar30
55SRMRGRTYPTRNG: Rule Types -- Texts1TYPENAMEType of Rulenvarchar30
TOPService Implementation Workbench
56TSIW_MM_TEAPOTSTentacles between structures2TYPENAMEData Type Namenvarchar1200
57TSIW_MM_TENTACLETentacles between structures3TYPENAMEData Type Namenvarchar1200
TOPServices
58FINB_RT_TKEYKey of Runtime Tables7TYPENAMEName of Dictionary Typenvarchar300
TOPSmart Forms
59STXFSTDPARSmart Forms: Default Parameters4TYPENAMESAP Smart Forms: Operandnvarchar1320
TOPSyntax, Compiler, Runtime
60THDLPROTProtokoll- und Steuertabelle CREATE/ASSIGN TYPE HANDLE Tests1TYPENAMEName des Dictionary Typsnvarchar300
TOPUser Administration
61SPERS_REGPersonalization registration table18TYPENAMEName of Dictionary Typenvarchar300
TOPWeb Service Tools - ABAP
62VEPELEMTYPEVirtual Interface: Elementary Data Type3TYPENAMEName of Type in a Service Definitionnvarchar1200
63VEPELETYPSOAPVirtual Interface: Elementary Type of SOAP Extension3TYPENAMEName of Type in a Service Definitionnvarchar1200
64VEPFIELDREFWS Virtual Interface: Field References, Default Values12TYPENAMEName of Type in a Service Definitionnvarchar1200
65VEPPARAMETERWS Virtual Interface: Parameter(s) of a Function11TYPENAMEName of Type in a Service Definitionnvarchar1200
66VEPPARAMIDSParameter ID of VI (Generated)2TYPENAMEName of Type in a Service Definitionnvarchar1200
67VEPSTRUTYPEVirtual Interface: Structure Type3TYPENAMEName of Type in a Service Definitionnvarchar1200
68VEPTABLETYPEVirtual Interface: Table Type3TYPENAMEName of Type in a Service Definitionnvarchar1200
69VEPTABTYPSOAPVirtual Interface: Table Type SOAP Extension3TYPENAMEName of Type in a Service Definitionnvarchar1200
70VEPTYPEVirtual Interface: Associated Type3TYPENAMEName of Type in a Service Definitionnvarchar1200
71VEPTYPESOAPEXTVirtual Interface: Associated Type of SOAP Extension3TYPENAMEName of Type in a Service Definitionnvarchar1200
72VEPTYPESTSimple Transformation of VI Type2TYPENAMEName of Type in a Service Definitionnvarchar1200