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

134 columns | Print definition?ERP 6.0  | KBID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/SLCE/CACHE_KBKnowledge Bases Cached in EJB-IPC2KBIDInternal identifier of a knowledge baseint100
2/SLCE/OBO_ITEMMapping of Order BOM Items to Main Line items on Documents7KBIDInternal identifier of a knowledge baseint100
TOPCentral Part of Product Master
3COMM_PME_CAT_MAPMapping of a Category or Product to PME Classes10KBIDInternal Number of SCE Knowledge Baseint100
4COMM_PME_PRD_MAPMapping of CRM Products for PME Classes10KBIDInternal Number of SCE Knowledge Baseint100
5COMM_PME_SET_MAPMapping Set Types for PME Classes10KBIDInternal Number of SCE Knowledge Baseint100
TOPInstalled Base
6IBIBIB: Installed Base/IBase20KBIDConfiguration: Temporary Data Element for SCEKB-KBIDnvarchar60
TOPProduct Configurator
7COMM_CFGCHADEPDependencies that are attached to Characteristics of Classes2KBIDInternal identifier of a knowledge baseint100
8COMM_CFGCHAPOSPosition Numbers of the Characteristics of Classes2KBIDInternal identifier of a knowledge baseint100
9COMM_CFGCHARACBasic Data for Characteristics2KBIDInternal identifier of a knowledge baseint100
10COMM_CFGCHAREFCharacteristics that reference to external data sources2KBIDInternal identifier of a knowledge baseint100
11COMM_CFGCHATXLanguage-Dependent Description of Characteristic2KBIDInternal identifier of a knowledge baseint100
12COMM_CFGCLACOMCompiled Code for Classic Dependencies2KBIDInternal identifier of a knowledge baseint100
13COMM_CFGCLFACFacets for Characteristics of Classes2KBIDInternal identifier of a knowledge baseint100
14COMM_CFGCLNDOMDomains for Numeric Characteristics of Classes2KBIDInternal identifier of a knowledge baseint100
15COMM_CFGCLNHIERNumeric Characteristic Values Hierarchy2KBIDInternal identifier of a knowledge baseint100
16COMM_CFGCLPARTDecomposition Item2KBIDInternal identifier of a knowledge baseint100
17COMM_CFGCLPRECClass Precedence List2KBIDInternal identifier of a knowledge baseint100
18COMM_CFGCLSDOMDomains for String Characteristics of Classes2KBIDInternal identifier of a knowledge baseint100
19COMM_CFGCLSHIERSymbolic Characteristic Values Hierarchy2KBIDInternal identifier of a knowledge baseint100
20COMM_CFGCLVALValues and Defaults for Characteristics of Classes2KBIDInternal identifier of a knowledge baseint100
21COMM_CFGCLVTXLanguage Dependent Value Descriptions2KBIDInternal identifier of a knowledge baseint100
22COMM_CFGCNTControl Objects (Tasks and Events)2KBIDInternal identifier of a knowledge baseint100
23COMM_CFGCNTDEPDependency Nets that are attached to Tasks/Events2KBIDInternal identifier of a knowledge baseint100
24COMM_CFGCNTTXLanguage-Dependent Descriptions for Control Objects2KBIDInternal identifier of a knowledge baseint100
25COMM_CFGCONFPRConfigurations Profiles2KBIDInternal identifier of a knowledge baseint100
26COMM_CFGCUCOCharacteristic Order2KBIDInternal identifier of a knowledge baseint100
27COMM_CFGCUHDCustomizing Screen Designer Header2KBIDInternal identifier of a knowledge baseint100
28COMM_CFGCUSDCustomizing Screen Designer Groups2KBIDInternal identifier of a knowledge baseint100
29COMM_CFGCUSDTLanguage-Dependent Descriptions for Screen Designer2KBIDInternal identifier of a knowledge baseint100
30COMM_CFGCUSDUCustomizing Screen Designer Groups Usage2KBIDInternal identifier of a knowledge baseint100
31COMM_CFGDEPBasic Data for Dependencies (including Nets)2KBIDInternal identifier of a knowledge baseint100
32COMM_CFGDEPCOMCompiled Code for Dependency Nets2KBIDInternal identifier of a knowledge baseint100
33COMM_CFGDEPDEPRelationship between Dependencies2KBIDInternal identifier of a knowledge baseint100
34COMM_CFGDEPDNNDiscrimination Nodes2KBIDInternal identifier of a knowledge baseint100
35COMM_CFGDEPPATPattern2KBIDInternal identifier of a knowledge baseint100
36COMM_CFGDEPSPNSimple Pattern Nodes2KBIDInternal identifier of a knowledge baseint100
37COMM_CFGDEPSRCSource Text for Dependencies2KBIDInternal identifier of a knowledge baseint100
38COMM_CFGDEPTXLanguage Dependent Description of Dependencies2KBIDInternal identifier of a knowledge baseint100
39COMM_CFGDEPVARPattern2KBIDInternal identifier of a knowledge baseint100
40COMM_CFGDOCKEYRef. table between documentation and object2KBIDInternal identifier of a knowledge baseint100
41COMM_CFGDOCOBJStructure for Identifying Document2KBIDInternal identifier of a knowledge baseint100
42COMM_CFGHASCHACharacteristics of Classes2KBIDInternal identifier of a knowledge baseint100
43COMM_CFGHASDECOOClass <=> Decomposition (Deprecated)2KBIDInternal identifier of a knowledge baseint100
44COMM_CFGHIERBasic Data for Model Hierarchy2KBIDInternal identifier of a knowledge baseint100
45COMM_CFGHIERTXLanguage-Dependent Description of Hierarchy2KBIDInternal identifier of a model elementint100
46COMM_CFGINFILTFilter2KBIDInternal identifier of a knowledge baseint100
47COMM_CFGKBRuntime Version of SCE Knowledge Base2KBIDInternal identifier of a knowledge baseint100
48COMM_CFGKBLANGSupported Languages of a KB2KBIDInternal identifier of a knowledge baseint100
49COMM_CFGKBTXLanguage-Dependent Description of KB2KBIDInternal identifier of a model elementint100
50COMM_CFGKMTDEPDependencies that are attached to KMATS2KBIDInternal identifier of a knowledge baseint100
51COMM_CFGLNGTXTLong Texts for Different Objects2KBIDInternal identifier of a knowledge baseint100
52COMM_CFGMATBasic Data for Materials2KBIDInternal identifier of a knowledge baseint100
53COMM_CFGNETBLOBBLOBed Dependency Nets2KBIDInternal identifier of a knowledge baseint100
54COMM_CFGNETOBJPosition Numbers of the Characteristics of Classes2KBIDInternal identifier of a knowledge baseint100
55COMM_CFGNHIERNumeric Characteristic Values Hierarchy2KBIDInternal identifier of a knowledge baseint100
56COMM_CFGNUMBasic Data for Numeric Characteristics2KBIDInternal identifier of a knowledge baseint100
57COMM_CFGNUMDOMDomains for Numeric Characteristics2KBIDInternal identifier of a knowledge baseint100
58COMM_CFGOBJDEPRelationship between Classes and Dependencies2KBIDInternal identifier of a knowledge baseint100
59COMM_CFGOCLASSBasic Data for OO-Classes2KBIDInternal identifier of a knowledge baseint100
60COMM_CFGOCLTXLanguage Dependent Descriptions of OO-Classes2KBIDInternal identifier of a knowledge baseint100
61COMM_CFGPROFKnowledge Base Profiles2KBIDInternal identifier of a knowledge baseint100
62COMM_CFGPROFTXLanguage-Dependent Descriptions for Knowledge Base Profiles2KBIDInternal identifier of a knowledge baseint100
63COMM_CFGPRTDEPDependencies that are attached to BOM positions2KBIDInternal identifier of a knowledge baseint100
64COMM_CFGSHIERSymbolic Characteristic Values Hierarchy2KBIDInternal identifier of a knowledge baseint100
65COMM_CFGSTRDOMDomains for String Characteristics2KBIDInternal identifier of a knowledge baseint100
66COMM_CFGSTRINGBasic Data for String Characteristics2KBIDInternal identifier of a knowledge baseint100
67COMM_CFGSUPERClass Hierarchy2KBIDInternal identifier of a knowledge baseint100
68COMM_CFGTABFUNVariant Tables and Functions2KBIDInternal identifier of a knowledge baseint100
69COMM_CFGVACONDVariant Condition Key2KBIDInternal identifier of a knowledge baseint100
70COMM_CFGVALDEPDependencies that are attached to Values of Characteristics2KBIDInternal identifier of a knowledge baseint100
71COMM_CFGVALSYMSymbol Table for Characteristic Values2KBIDInternal identifier of a knowledge baseint100
72COMM_CFGVALTXLanguage Dependent Value Descriptions2KBIDInternal identifier of a knowledge baseint100
73COMM_CFGVTABLEVariant Table Metadata2KBIDInternal identifier of a knowledge baseint100
74COMM_CFGVTCOLUMNVariant Table Column2KBIDInternal identifier of a knowledge baseint100
75COMM_CFGXREFCross Reference2KBIDInternal identifier of a knowledge baseint100
TOPSales and Distribution
76SCECHADEPAssignment: Classic Dependencies to Chars of Classes2KBIDInternal Number of SCE Knowledge Basenvarchar60
77SCECHAINPNo User Entry for Characteristic of Class2KBIDInternal Number of SCE Knowledge Basenvarchar60
78SCECHAPOSPosition of Characteristic in Class2KBIDInternal Number of SCE Knowledge Basenvarchar60
79SCECHARACCharacteristics2KBIDInternal Number of SCE Knowledge Basenvarchar60
80SCECHAREFReference of Reference Characteristic2KBIDInternal Number of SCE Knowledge Basenvarchar60
81SCECHATXLanguage-Dependent Description of Characteristic2KBIDInternal Number of SCE Knowledge Basenvarchar60
82SCECHAVISCharacteristic of Class Hidden/Shown2KBIDInternal Number of SCE Knowledge Basenvarchar60
83SCECLACOMCompilation for Classic Dependencies2KBIDInternal Number of SCE Knowledge Basenvarchar60
84SCECLNDOMAllowed Values for Numeric Characteristic of Class2KBIDInternal Number of SCE Knowledge Basenvarchar60
85SCECLPRECPrecedence List for OO Classes2KBIDInternal Number of SCE Knowledge Basenvarchar60
86SCECLSDOMAllowed Values of Alphanumeric Characteristic of Class2KBIDInternal Number of SCE Knowledge Basenvarchar60
87SCECLVALValues Assigned to Characteristics of a Class2KBIDInternal Number of SCE Knowledge Basenvarchar60
88SCECLVTXLang.-Dependent Descs of Vals of Alphanum. Chars of Classes2KBIDInternal Number of SCE Knowledge Basenvarchar60
89SCECNTControl Knowledge (Tasks and Events)2KBIDInternal Number of SCE Knowledge Basenvarchar60
90SCECNTDEPAssignment of Dependencies to Control Knowledge2KBIDInternal Number of SCE Knowledge Basenvarchar60
91SCECNTTXLanguage-Dependent Descriptions of Control Knowledge2KBIDInternal Number of SCE Knowledge Basenvarchar60
92SCECONFPRConfiguration Profiles2KBIDInternal Number of SCE Knowledge Basenvarchar60
93SCECUCOInterface Design - Sequence of Characteristics in a Group2KBIDInternal Number of SCE Knowledge Basenvarchar60
94SCECUHDInterface Design - Header Data2KBIDInternal Number of SCE Knowledge Basenvarchar60
95SCECUSDInterface Design - Grouping Structure2KBIDInternal Number of SCE Knowledge Basenvarchar60
96SCECUSDTInterface Design - Description of Groupings2KBIDInternal Number of SCE Knowledge Basenvarchar60
97SCEDECOMPDecomposition (BOM and so on)2KBIDInternal Number of SCE Knowledge Basenvarchar60
98SCEDEPDependencies (Basic Data)2KBIDInternal Number of SCE Knowledge Basenvarchar60
99SCEDEPCOMCompilation of Dependency Nets2KBIDInternal Number of SCE Knowledge Basenvarchar60
100SCEDEPDNNDNNs of Dependency2KBIDInternal Number of SCE Knowledge Basenvarchar60
101SCEDEPDOCDocumentation for Dependencies2KBIDInternal Number of SCE Knowledge Basenvarchar60
102SCEDEPPATPattern of Dependency2KBIDInternal Number of SCE Knowledge Basenvarchar60
103SCEDEPSPNSPNs of Dependency2KBIDInternal Number of SCE Knowledge Basenvarchar60
104SCEDEPSRCSource Code of Dependency2KBIDInternal Number of SCE Knowledge Basenvarchar60
105SCEDEPTXLanguage-Dependent Descriptions for Dependencies2KBIDInternal Number of SCE Knowledge Basenvarchar60
106SCEDEPVARVariables of Dependencies2KBIDInternal Number of SCE Knowledge Basenvarchar60
107SCEDOCKEYStorage Location of Document Key2KBIDInternal Number of SCE Knowledge Basenvarchar60
108SCEDOCOBJLink Between Documents and Objects2KBIDInternal Number of SCE Knowledge Basenvarchar60
109SCEHASCHACharacteristics of OO Class2KBIDInternal Number of SCE Knowledge Basenvarchar60
110SCEHASDECAssignment of Decomposition to OO Class2KBIDInternal Number of SCE Knowledge Basenvarchar60
111SCEHASPRTComponents of Decomposition (BOM and so on)2KBIDInternal Number of SCE Knowledge Basenvarchar60
112SCEINVIEWAllocation of Characteristic of Class to Org. Area2KBIDInternal Number of SCE Knowledge Basenvarchar60
113SCEKBRuntime Version of SCE Knowledge Base2KBIDInternal Number of SCE Knowledge Basenvarchar60
114SCEKBTXLanguage-Dependent Description for SCE Knowledge Base2KBIDInternal Number of SCE Knowledge Basenvarchar60
115SCEKMTDEPAssignment: Dependencies for Configurable Materials2KBIDInternal Number of SCE Knowledge Basenvarchar60
116SCELNGTXTStorage Location for Long Texts2KBIDInternal Number of SCE Knowledge Basenvarchar60
117SCEMATMaterials2KBIDInternal Number of SCE Knowledge Basenvarchar60
118SCENUMNumeric Characteristics2KBIDInternal Number of SCE Knowledge Basenvarchar60
119SCENUMDOMAllowed Values of Numeric Characteristic2KBIDInternal Number of SCE Knowledge Basenvarchar60
120SCEOCLASSOO Classes of SCE Knowledge Base2KBIDInternal Number of SCE Knowledge Basenvarchar60
121SCEOCLTXLanguage-Dependent Descriptions of OO Classes2KBIDInternal Number of SCE Knowledge Basenvarchar60
122SCEPROFProfile of Knowledge Base (Starting Point of Configuration)2KBIDInternal Number of SCE Knowledge Basenvarchar60
123SCEPROFTXLanguage-Dependent Description of Knowledge-Base Profile2KBIDInternal Number of SCE Knowledge Basenvarchar60
124SCEPRTDEPAssignment of Dependencies to Components (of BOM)2KBIDInternal Number of SCE Knowledge Basenvarchar60
125SCESTRDOMAllowed Values for Alphanumeric Characteristics2KBIDInternal Number of SCE Knowledge Basenvarchar60
126SCESTRINGAlphanumeric Characteristics2KBIDInternal Number of SCE Knowledge Basenvarchar60
127SCESUPERClass Hierarchy of Knowledge Base2KBIDInternal Number of SCE Knowledge Basenvarchar60
128SCETABFUNValue Assignment Alternatives for Variant Table and Functs2KBIDInternal Number of SCE Knowledge Basenvarchar60
129SCEVACONDAssignment of Variant Condition to Char. Value in SCE KB2KBIDInternal Number of SCE Knowledge Basenvarchar60
130SCEVALDEPAssignment of Dependencies to Char. Values of Classes2KBIDInternal Number of SCE Knowledge Basenvarchar60
131SCEVALSYMSymbol Table for Characteristic Values2KBIDInternal Number of SCE Knowledge Basenvarchar60
132SCEVALTXLanguage-Dependent Descriptions of Values of Alphanum. Chars2KBIDInternal Number of SCE Knowledge Basenvarchar60
133SCEVARVALValues in Variant Tables2KBIDInternal Number of SCE Knowledge Basenvarchar60
TOPSoftware Agent Framework
134CRMD_EI_SOL_CARTEI: Persist user selected solution out of SDB4KBIDKnowledge Base Entity IDnvarchar500