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

112 columns | Print definition?ERP 6.0  | KLART

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/CFMFND/RECL_STDKlassifizierung: Standardklasse für Objekte4KLARTKlassenartnvarchar30
2/SMD/MD_____00BISID-Tabelle fuer Class Type3KLARTClass Typenvarchar30
3/SMERP/STG_PM006Data staging - Equip List Set - Classifications - Cmplx Tab11KLARTClass Typenvarchar30
4/SMERP/STG_PM007Data staging - Equip List Set - Char Values - complex table13KLARTClass Typenvarchar30
5/SMERP/STG_PM011Data staging - Func Loc. LSet - Classifications - Cmplx Tab11KLARTClass Typenvarchar30
6/SMERP/STG_PM012Data staging - Func Loc LSet - Char Values - complex table13KLARTClass Typenvarchar30
7AUSP_CONVCharacteristic Values6KLARTClass Typenvarchar30
8KSSK_CONVAllocation Table: Object to Class4KLARTClass Typenvarchar30
9T056SInterest scale interest terms (acct bal.int.calc.)3KLARTCalendar typenvarchar10
10T056UControl table for calculation of interest on arrears3KLARTCalendar typenvarchar10
11TCLCClassification Status2KLARTClass Typenvarchar30
12TCLDCharacteristic Data from Standard7KLARTClass Typenvarchar30
13WBBIDOC_CHARVALClass and Class Type: Assrtmnt List HPR IDoc3KLARTClass Typenvarchar30
TOPAdditionals Management
14TWTCTRLControl table for procedures for additionals22KLARTAdditionals: Class type for sendernvarchar30
TOPALE Integration Technology
15TBDLILists for a logical system3KLARTClass Typenvarchar30
TOPAssortment Maintenance
16TWGRSize interval to calculation factor assignment2KLARTClass Typenvarchar30
TOPBasic Functions
17FDESCash Management and Forecast: Memo Records32KLARTCalendar typenvarchar10
18FDESDISTCash management memo records (distributed)33KLARTCalendar typenvarchar10
TOPBills of Material
19STPOBOM item73KLARTClass Typenvarchar30
TOPCharacteristics
20TCMEValidity for Global Characteristics3KLARTClass Typenvarchar30
TOPClasses
21AUSPCharacteristic Values6KLARTClass Typenvarchar30
22CABSResult of the Statistical Analysis of Table AUSP3KLARTClass Typenvarchar30
23CLAENNRChange number-to-class alloc.: classification effectivity2KLARTClass Typenvarchar30
24CLINDEXIndices of Classification System3KLARTClass Typenvarchar30
25CLPROFClassification: Parameters for Settings57KLARTClass Typenvarchar30
26CLSELSTATISTICSStatistics for Optimizing Object Search2KLARTClass Typenvarchar30
27CLSELSTATISTICS2Statistical AUSP Information for Characteristics2KLARTClass Typenvarchar30
28INOBLink between Internal Number and Object3KLARTClass Typenvarchar30
29KLAHClass Header Data3KLARTClass Typenvarchar30
30KSMLCharacteristics of a Class10KLARTClass Typenvarchar30
31KSSKAllocation Table: Object to Class4KLARTClass Typenvarchar30
32TCLAOSeveral Objects in one Class Type2KLARTClass Typenvarchar30
33TCLATClass Type Texts3KLARTClass Typenvarchar30
34TCLAUSubscreen for Additional Data of Class2KLARTClass Typenvarchar30
35TCLAUTTab Text for Additional Class Maintenance Screen3KLARTClass Typenvarchar30
36TCLAXCLASSIFICATION:3KLARTClass Typenvarchar30
37TCLRObject-Specific Reports and Transactions2KLARTClass Typenvarchar30
38TCLSClasses: Organizational areas2KLARTClass Typenvarchar30
39TCLSTClasses: Org. Areas (Texts)3KLARTClass Typenvarchar30
40TCLUClass Status2KLARTClass Typenvarchar30
41TCLUTClass Status (Texts)3KLARTClass Typenvarchar30
42TCLXClass Text IDs2KLARTClass Typenvarchar30
43TCLXTClass Text IDs, Language-Dependent3KLARTClass Typenvarchar30
44TCOBJHelp table for optimization reports (INTERNAL USE ONLY!)2KLARTClass Typenvarchar30
TOPClassification
45TCLAClass Types2KLARTClass Typenvarchar30
46TCLS_KABCRelationship: Class Type - Object Key (BOR)1KLARTClass Typenvarchar30
47TCL_CLINT_IDENTIdentification Table for Classes for Data Transfer5KLARTClass Typenvarchar30
48TCL_CUOBJ_IDENTIdentification Table for Object Keys for Data Transfer5KLARTClass Typenvarchar30
TOPConfiguration Control
49MPL_C_ADAPTERAdapter for iPPE Workbench8KLARTStandard Class Type for Cancel-Part Checknvarchar30
TOPConfiguration management
50CMTIB_CLFINT2EXTClassification conversion: internal ID to external key4KLARTClass Typenvarchar30
51IBINCMIB: Config.Mang.: Component/Instance25KLARTClass Typenvarchar30
52TCM_CUS_EXP_CTYPClass types not considered3KLARTClass Typenvarchar30
53TCM_EXP_CTYPClass types not considered3KLARTClass Typenvarchar30
TOPConfiguration Profile
54CUVCPR_ID_INTConversion: internal ID for configuration profile3KLARTClass Typenvarchar30
TOPConstruction Equipment Management
55/SAPCEM/KLA_ARBAssignment Class -> Work Center2KLARTClass Typenvarchar30
TOPCross-Application Component CA Enhancements
56MILL_CLPROFPProfile for Selection by Characteristics: Items4KLARTClass Typenvarchar30
TOPCross-Application Components
57FRE_TWTCTRLProcedures for Additionals6KLARTAdditionals: Class type for sendernvarchar30
TOPData Collection
58S127Open Variants - Basis 223KLARTClass Typenvarchar30
59S128Open Variants - SIS8KLARTClass Typenvarchar30
60S128ES128 - Structural information3KLARTClass Typenvarchar30
61S129Open Variants - Planning8KLARTClass Typenvarchar30
62S129ES129 - Structural information3KLARTClass Typenvarchar30
TOPDemand Management
63TPHVPHeader: Planning Profile7KLARTClass Typenvarchar30
TOPDevice Management
64TEDEVCLTYPEControl Parameters for Linking Classif. System to Dev.3KLARTClass Typenvarchar30
TOPEnvironment
65CLBW_SOURCESData Sources for Classification Data3KLARTClass Typenvarchar30
66LKLAHClass Header (Special Objects)3KLARTClass Typenvarchar30
67LKSMLCharacteristics of a Class10KLARTClass Typenvarchar30
68LKSSKAllocation Table: Object to Class4KLARTClass Typenvarchar30
TOPFunctions for U.S. Federal Government
69FMFEE_TYPESFee types7KLARTCalendar typenvarchar10
TOPInstalled Base
70IBINIB: IBase Components - Condition25KLARTClass Typenvarchar30
TOPIntegrated Product and Process Engineering
71CPNTYPECustomizing Table for iPPE Node Type14KLARTClass Typenvarchar30
72CPPECNTLGeneral iPPE Customizing20KLARTClass Type Standard Valuenvarchar30
73CPVTYPECustomizing Table for the iPPE Variant Types11KLARTClass Typenvarchar30
74PVSDEXExternal Indicator for Deleted PVS/iPPE Objects6KLARTClass Typenvarchar30
75PVS_VSHEMEVariance Scheme for Structure Node6KLARTClass Typenvarchar30
TOPLine Maintenance
76/ISDFPS/CASMODCLCustomizing Confign Code Classes f. Model ID (Weapon System)3KLARTClass Typenvarchar30
TOPLoans Management
77TDSOZSpecial interest indicator for loans6KLARTCalendar typenvarchar10
TOPLogistics Execution LE Enhancements
78/SAPMP/LBA_CUSTIS-MP: Control Table DTUC Processing3KLARTClass Typenvarchar30
TOPMaintenance Notifications
79TQ80OObject info parameters17KLARTView Indicatornvarchar10
80TQ8TNotification category10KLARTClass Typenvarchar30
TOPMaterial Groups
81WTREEVersion Management for Reclassification Trees2KLARTClass Typenvarchar30
TOPMerchandise and Assortment Planning
82TWISPC_BREAKDGrouping Break-Downs7KLARTClass Typenvarchar30
TOPNetwork and Activity
83TCN61Parameter: Create network from sales order7KLARTClass Typenvarchar30
TOPObject Dependencies
84TCUAXOrganizational Areas Control Table2KLARTClass Typenvarchar30
TOPPlant Master
85TWRF16Group Applications3KLARTClass Typenvarchar30
86TWRF16TDescription: group application4KLARTClass Typenvarchar30
TOPPool Asset Management
87PAMS_FSETSettings for Pool Asset Management6KLARTClass Typenvarchar30
TOPProduct Data Management
88KLFBAssignment: Class to template2KLARTClass Typenvarchar30
TOPProduct Safety
89ESTAUSPEHS: Shadow table for AUSP6KLARTClass Typenvarchar30
90TCGA6EHS: Report Symbol16KLARTClass Typenvarchar30
91TCGA8EHS: Source for symbol generation4KLARTClass Typenvarchar30
92TCGA9EHS: Limiting criteria for symbol generation source4KLARTClass Typenvarchar30
93TCGRULPOSMRESTEHS: Easy Expert Set of Rules, Characteristic Restrictions8KLARTClass Typenvarchar30
TOPProduct Structure and Assembly Management
94/PLMI/PPE_CUS_GSPSM General Customizing Settings2KLARTClass Typenvarchar30
TOPProduct Structure Browser
95USROBJECTSTable of Previous Initial Object in Structure Overview14KLARTClass Typenvarchar30
TOPPromotion
96WAGUValidity of plant groups - IS-R23KLARTClass typenvarchar30
TOPReport Selection for Product Costing
97KKBMMCharacteristic Assignment for Selection Screens for Ord. Sel2KLARTClass Typenvarchar30
98KKBSBSelection Screens for Order Selection2KLARTClass Typenvarchar30
99KKBSBTText Table for Selection Screens3KLARTClass Typenvarchar30
TOPSCM Basis
100CIF_IMCHARIntegration Model Reference Table for Classification2KLARTClass Typenvarchar30
TOPSoftware Management
101S427Variant Config.2---IBASE9KLARTClass Typenvarchar30
102S427ES427 - Structural information4KLARTClass Typenvarchar30
TOPTechnical Objects
103EAML_D_AUSP_LFELinear Data for Characteristics - Database table6KLARTClass Typenvarchar30
104EAML_D_TCLSOrganizational area for characteristics with linear data2KLARTClass Typenvarchar30
TOPTransaction Manager
105AT70Hedging Relevance of Currencies6KLARTUnit typenvarchar40
106AT72Customizing: Unit Types2KLARTUnit typenvarchar40
107AT72TText for unit types3KLARTUnit typenvarchar40
108VTBSIHedges5KLARTUnit typenvarchar40
TOPVariant Configuration
109CLRKRecursiveness Info on Objects in Classes for BOM3KLARTClass Typenvarchar30
110CUCOAdditional Data for Configurable Objects5KLARTClass Typenvarchar30
111MACONDConfiguration: Manually Assigned Conditions3KLARTClass Typenvarchar30
TOPWarranties
112T790TWarranty Category Functions3KLARTClass Typenvarchar30