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
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

74 columns | Print definition?ERP 6.0  | CLINT

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/SMD/MD_____00BHSID-Tabelle fuer Internal class no.3CLINTInternal Class Numbernvarchar100
2/SMERP/STG_PM006Data staging - Equip List Set - Classifications - Cmplx Tab12CLINTInternal Class Numbernvarchar100
3/SMERP/STG_PM011Data staging - Func Loc. LSet - Classifications - Cmplx Tab12CLINTInternal Class Numbernvarchar100
4CNV_10400_SETUPSettings for characteristic conversion21CLINTInternal Class Number / copy of CLINTnvarchar100
5KSSK_CONVAllocation Table: Object to Class5CLINTInternal Class Numbernvarchar100
6ZEIM_LIPSSD document: Delivery: Item data156CLINTInternal Class Numbernvarchar100
7ZEIM_VBAPSales Document: Item Data170CLINTInternal Class Numbernvarchar100
TOPBills of Material
8CLSTLink class - BOM2CLINTInternal Class Numbernvarchar100
TOPCharacteristics
9CABNCharacteristic65CLINTInternal Class Numbernvarchar100
10CABNNEWCharacteristic65CLINTInternal Class Numbernvarchar100
11CUFMCustomizing: Class/Config: Screendesigner Form2CLINTInternal Class Numbernvarchar100
12CUSDCustomizing: Class/Config: Screendesigner2CLINTInternal Class Numbernvarchar100
13CUSDTCustomizing: Class/Config: Screendesigner Descriptions2CLINTInternal Class Numbernvarchar100
14CUSFCustomizing: Class/Config: Screendesigner Frame2CLINTInternal Class Numbernvarchar100
15CUSFTCustomizing: Class/Config: Screendesigner Frame Desc.2CLINTInternal Class Numbernvarchar100
TOPClasses
16CLAENNRChange number-to-class alloc.: classification effectivity3CLINTInternal Class Numbernvarchar100
17INOBLink between Internal Number and Object8CLINTInternal Class Number of Configurable Objectnvarchar100
18KLAHClass Header Data2CLINTInternal Class Numbernvarchar100
19KLATClasses: Long Texts2CLINTInternal Class Numbernvarchar100
20KSMLCharacteristics of a Class2CLINTInternal Class Numbernvarchar100
21KSSKAllocation Table: Object to Class5CLINTInternal Class Numbernvarchar100
22SWORClassification System: Keywords2CLINTInternal Class Numbernvarchar100
TOPClassification System New
23CME_ST_R3_ATTRCME Characteristic: R/3 Attributes8CLINTClass of User-Defined Data Typenvarchar180
24CME_ST_R3_ATTRHCME Characteristic: R/3 Attributes6CLINTClass of User-Defined Data Typenvarchar180
TOPConditions
25KONDHConditions: Batch Strategy - Data Division13CLINTInternal Class Numbernvarchar100
TOPConfiguration Control
26MPL_C_ADAPTERAdapter for iPPE Workbench7CLINTInternal Class Numbernvarchar100
TOPCross-Application Component CA Enhancements
27MILL_CLPROFCProfile for Selection by Characteristics: Classes4CLINTInternal Class Numbernvarchar100
TOPCross-Application Components
28FRE_MC_MCH_KEYWLanguage dependent Text for Merch.Categor. and MC-Hierarchy2CLINTInternal Class Numbernvarchar100
29FRE_MC_MCH_NODEMerchandise Category and MC-Hier. Node sent to F&R2CLINTInternal Class Numbernvarchar100
30FRE_SITE_GROUPSite Group Assignments relevant for Det.of Processing Method2CLINTInternal Class Numbernvarchar100
31VVBAPSales Document: Item Data170CLINTInternal Class Numbernvarchar100
TOPData Collection
32S137Variants: Basis 211CLINTCharacteristics combinationnvarchar100
33S137ES137 -Structural Information6CLINTCharacteristics combinationnvarchar100
34S138Variants: SIS & planning14CLINTCharacteristics combinationnvarchar100
35S138ES138 - Structural Information9CLINTCharacteristics combinationnvarchar100
TOPDemand Management
36TPLVPPlanning Profile4CLINTInternal number of variant tablenvarchar100
37TPSVPPlanning profile lines4CLINTInternal number of variant tablenvarchar100
TOPEngineering Change Management
38AENRChange Master22CLINTInternal class number describing effectivity typenvarchar100
39TCCERLinks Between Effectivity Types and Parameters4CLINTInternal class number describing effectivity typenvarchar100
TOPEnvironment
40LCABNCharacteristic65CLINTInternal Class Numbernvarchar100
41LKLAHClass Header (Special Objects)2CLINTInternal class numbernvarchar100
42LKSMLCharacteristics of a Class2CLINTInternal class numbernvarchar100
43LKSSKAllocation Table: Object to Class5CLINTInternal Class Numbernvarchar100
44LSWORClassification System: Keywords2CLINTInternal class numbernvarchar100
TOPIntegrated Product and Process Engineering
45CPNTYPECustomizing Table for iPPE Node Type15CLINTInternal Class Numbernvarchar100
46CPVTYPECustomizing Table for the iPPE Variant Types12CLINTInternal Class Numbernvarchar100
47PNODEPositionsknoten in der PVS5CLINTInterne Klassennummernvarchar100
48PNODIDiPPE Node: Identification7CLINTInternal Class Numbernvarchar100
49PPEFILTEXPLThis table is obsolete, use PPEFILTEXPLPAR9CLINTInternal Class Numbernvarchar100
50PPEFILTEXPLPARExplosion Parameters for the iPPE Filter10CLINTInternal Class Numbernvarchar100
51PPESCMPViPPE Status, BOM-Specific Data6CLINTInternal Class Numbernvarchar100
52PVCMPRPVS Variant (CMP): Supplement to the Selection Criteria4CLINTInternal Class Numbernvarchar100
53PVS_VSHEMEVariance Scheme for Structure Node4CLINTInternal Class Numbernvarchar100
54USRGISETTINGSUser Settings for the iPPE Workbench6CLINTInternal Class Numbernvarchar100
55USRTICLASSClass Assignment for Tabular Maintenance of iPPE3CLINTInternal Class Numbernvarchar100
TOPMaster data
56PACKPOPacking Object Item8CLINTMaterial class or packing instructions classnvarchar100
TOPMaterial Groups
57T023SBase Material Group/Hierarchy Material Assignment4CLINTInternal Class Numbernvarchar100
TOPObject Selection
58GEN_TABLES_MAINGenerated Tables for Search in Classification System2CLINTInternal Class Numbernvarchar100
59GEN_TABLES_SUBGenerated Tables for Multiple-Value Characteristics2CLINTInternal Class Numbernvarchar100
TOPPlant Master
60TWRF2Plant Profiles4CLINTInternal Class Numbernvarchar100
TOPProduct Cost Planning
61CKTC_KALNRDatabase Table for Costing Numbers6CLINTInternal Class Numbernvarchar100
TOPProduct Safety
62TCGRULPOSMRESTEHS: Easy Expert Set of Rules, Characteristic Restrictions7CLINTInternal Class Numbernvarchar100
TOPPromotion
63WAGUValidity of plant groups - IS-R3CLINTInternal Class Numbernvarchar100
64WAKRWPromotion discounts by plant7CLINTInternal Class Numbernvarchar100
65WALEMaterial to store assignment to promotion6CLINTInternal Class Numbernvarchar100
66WAZBModule plant-group assignment8CLINTInternal class numbernvarchar100
TOPRemaining Beverage - Obsolete Objects
67/BEV1/RBVBAPSales Document: Item Data170CLINTInternal Class Numbernvarchar100
TOPSales
68VBAPSales Document: Item Data170CLINTInternal Class Numbernvarchar100
TOPShipping
69LIPSSD document: Delivery: Item data156CLINTInternal Class Numbernvarchar100
TOPSimulation
70VSVBAP_CNVersion: Sales document: Item data171CLINTInternal Class Numbernvarchar100
TOPVariant Configuration
71CDCNDConfiguration: Direct Conditions Data Type:CHAR2CLINTInternal Class Numbernvarchar100
72CLRKRecursiveness Info on Objects in Classes for BOM5CLINTInternal Class Numbernvarchar100
73CUCOAdditional Data for Configurable Objects6CLINTInternal Class Numbernvarchar100
74KRIFRichie Riffle2CLINTInternal Class Numbernvarchar100