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

119 columns | Print definition?ERP 6.0  | ATINN

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/FLDQ/AD_MKTGDUPMarketing Attributes For Use During Duplicate Check2ATINNInternal characteristicnvarchar100
2/GEOE/CONFIG_19Geo-enabled Characteristics (LAM)3ATINNCharacteristic Namenvarchar300
3/SMERP/STG_MM003Data staging - Material UoM view complex table204ATINNInternal characteristicnvarchar100
4/SMERP/STG_PM004Data staging - Equipment list set - Measuring Points26ATINNInternal characteristicnvarchar100
5/SMERP/STG_PM007Data staging - Equip List Set - Char Values - complex table10ATINNInternal characteristicnvarchar100
6/SMERP/STG_PM009Data staging - Func. Loc. List Set - Meas. Pts - cmplex tab26ATINNInternal characteristicnvarchar100
7/SMERP/STG_PM012Data staging - Func Loc LSet - Char Values - complex table10ATINNInternal characteristicnvarchar100
8AUSP_CONVCharacteristic Values3ATINNInternal characteristicnvarchar100
9CNV_10400_ATINNIdentified ATINNs per table4ATINNInternal characteristicnvarchar100
10CNV_10400_ATWRTFound values for identified ATINNs per table4ATINNInternal characteristicnvarchar100
11CNV_10400_MERKDOMapping characteristic <-> domain for conversion4ATINNInternal characteristicnvarchar100
12CNV_10400_SETUPSettings for characteristic conversion3ATINNInternal characteristicnvarchar100
13CNV_10400_TABTables for analysis3ATINNInternal characteristicnvarchar100
14CNV_10400_TABUSESettings for characteristic conversion3ATINNInternal characteristicnvarchar100
15SGT_CATSSegmentation Structure Fields Table5ATINNInternal characteristicnvarchar100
TOPABAP List-Based PI Sheet
16COFVPPI Sheet: Process Instruction Characteristics5ATINNInternal characteristicnvarchar100
17COMEPPI Sheet: Message Characteristics3ATINNInternal characteristicnvarchar100
TOPAssortment
18WRF_APC_PACHRPlanned Article Characteristics and Characteristic Values3ATINNInternal characteristicnvarchar100
19WRF_APC_PAVARPlanned Article Variants4ATINNInternal characteristicnvarchar100
20WRF_APC_SELQSOperational APC: Select Quota Scales per Hierarchy Node4ATINNInternal characteristicnvarchar100
TOPAssortment Maintenance
21TWGRSize interval to calculation factor assignment5ATINNInternal characteristicnvarchar100
TOPBasic Data
22QPMKInspection characteristic master61ATINNInternal characteristicnvarchar100
23TIVBDMEASMETERCharacteristic per Measurement Type3ATINNSequential Assignment Numbernvarchar100
TOPBatches
24TCB03_BMInternal Characteristic Numbers for PP-PI Characteristics2ATINNInternal Character. No. for Batch Standard Characteristicsnvarchar100
TOPCharacteristics
25CABNCharacteristic2ATINNInternal characteristicnvarchar100
26CABNNEWCharacteristic2ATINNInternal characteristicnvarchar100
27CABNTCharacteristic Descriptions2ATINNInternal characteristicnvarchar100
28CABNZAssignment of Table Fields to Characteristics2ATINNInternal characteristicnvarchar100
29CAWNCharacteristic values2ATINNInternal characteristicnvarchar100
30CAWNTValue Texts2ATINNInternal characteristicnvarchar100
31CUFMCustomizing: Class/Config: Screendesigner Form13ATINNInternal characteristicnvarchar100
32TCMEValidity for Global Characteristics2ATINNInternal characteristicnvarchar100
TOPClasses
33AUSPCharacteristic Values3ATINNInternal characteristicnvarchar100
34CABSResult of the Statistical Analysis of Table AUSP2ATINNInternal characteristicnvarchar100
35CLINDEXATINNCharacteristic - Index Assignment3ATINNInternal characteristicnvarchar100
36CLSELSTATISTICSStatistics for Optimizing Object Search3ATINNInternal characteristicnvarchar100
37CLSELSTATISTICS2Statistical AUSP Information for Characteristics3ATINNInternal characteristicnvarchar100
TOPConfiguration Control
38MPL_C_ADAPTERAdapter for iPPE Workbench10ATINNInternal characteristicnvarchar100
TOPConstruction Equipment Management
39J_3GPLKATAssignment Price List - Condition Types - Catalogs6ATINNInternal characteristicnvarchar100
TOPCross-Application Component CA Enhancements
40MILL_CLPROFPProfile for Selection by Characteristics: Items5ATINNInternal characteristicnvarchar100
TOPData Collection
41S127Open Variants - Basis 211ATINNInternal characteristicnvarchar100
42S127ES127 - Structural information4ATINNInternal characteristicnvarchar100
43S128Open Variants - SIS10ATINNInternal characteristicnvarchar100
44S128ES128 - Structural information5ATINNInternal characteristicnvarchar100
45S129Open Variants - Planning11ATINNInternal characteristicnvarchar100
46S129ES129 - Structural information6ATINNInternal characteristicnvarchar100
TOPEnvironment
47LCABNCharacteristic2ATINNInternal characteristicnvarchar100
48LCABNTCharacteristic descriptions2ATINNInternal characteristicnvarchar100
TOPFlexible Real Estate Management
49REHO_GE_MERKMALZuordnung E-Satz zu den Merkmalen und Merkmalstypen4ATINNInt. Merkmalnvarchar100
TOPInspection Planning
50QMSPQM: material specification5ATINNInternal characteristicnvarchar100
TOPInstalled Base
51IBSYMBOLIB: Characteristic Value Assignment3ATINNInternal characteristicnvarchar100
TOPIntegrated Product and Process Engineering
52CPPECNTLGeneral iPPE Customizing9ATINNCharacteristic for Start-Up Parametersnvarchar100
TOPLogistics - General
53HBSFLSFit-List6ATINNInternal characteristicnvarchar100
54HBSFSPHelp dummy table6ATINNInternal characteristicnvarchar100
55WYT2MVendor-Dependent Characteristic Value Conversion4ATINNInternal characteristicnvarchar100
TOPMaintenance Orders
56/CUM/INH_CHARCU: Characteristics Used in Validation2ATINNCU: Characteristic Valid for Inheritancenvarchar100
TOPMaster Recipe
57PLFVPI Characteristics/Sub-Operation Parameter Values17ATINNInternal characteristicnvarchar100
TOPMaterial Categories
58/ISDFPS/MPO_PROTLog of Data Transfers into MPO10ATINNInternal characteristicnvarchar100
TOPMaterial Groups
59WMWKValue Scale: Header Data3ATINNInternal characteristicnvarchar100
TOPMaterial Master
60MARMUnits of Measure for Material18ATINNInternal characteristicnvarchar100
61MARM_TMPFile for Incorrect Data in Direct Input21ATINNInternal characteristicnvarchar100
62MVRMUnits of Measure for Material18ATINNInternal characteristicnvarchar100
63WRF_CHARVALCharacteristic Values with Customer Fields2ATINNInternal characteristicnvarchar100
64WRF_CHARVALTForeign-Language Texts for Characteristic Values2ATINNInternal characteristicnvarchar100
65WRF_CHARVAL_HEADHeader Table for Controlling Characteristics2ATINNInternal characteristicnvarchar100
TOPMeasurement System
66GHO_MEASDTMeasurement Details5ATINNInternal characteristicnvarchar100
67GHO_MEAS_GRPDTMeasurement Group Details7ATINNInternal characteristicnvarchar100
68GHO_MEAS_GRP_TMeasurement Group Text Table7ATINNnvarchar100
69GHO_MEAS_TMeasurement Text Table5ATINNnvarchar100
TOPMeasuring Points and Counters
70IMPTTMeasuring Point (Table)20ATINNInternal characteristicnvarchar100
TOPMigration
71TIVMISETMEASConversion of Area Type and Apportionment Unit to Meas.Type23ATINNInternal characteristicnvarchar100
TOPObject Dependencies
72CURSVARInternal Variables of Constraints9ATINNInternal characteristicnvarchar100
73CUVFUN_INDValue assignment alternatives for variant function4ATINNInternal characteristicnvarchar100
74CUVFUN_PARParameters of variant function3ATINNInternal characteristicnvarchar100
75CUVTAB_FLDFields of variant table3ATINNInternal characteristicnvarchar100
76CUVTAB_INDValue assignment alternatives for variant table4ATINNInternal characteristicnvarchar100
77CUVTAB_VALCCHAR format values for variant table4ATINNInternal characteristicnvarchar100
78CUVTAB_VALNNON-CHAR format variant table values4ATINNInternal characteristicnvarchar100
79CUXREFObject Dependency Cross References7ATINNInternal characteristicnvarchar100
TOPObject Selection
80GEN_TABLES_SUBGenerated Tables for Multiple-Value Characteristics3ATINNInternal characteristicnvarchar100
TOPProcess Management
81COCCPP-PI: Attributes for Characteristics2ATINNInternal characteristicnvarchar100
82COCC2PP-PI: Customer-Specific Attributes for Characteristics2ATINNInternal characteristicnvarchar100
83COFVProcess Management: Process Instr. Charact. in Ctrl Recipe5ATINNInternal characteristicnvarchar100
84COMEProcess Management: Message Characteristics3ATINNInternal characteristicnvarchar100
85COMERProcess Message Record: Message Characteristics3ATINNInternal characteristicnvarchar100
86COREProcess Mgmt.: Display Characteristics of the Eval. Version4ATINNInternal characteristicnvarchar100
87TC50AAssignment of Message Charact. to Dest.-Spec. Target Fields5ATINNInternal characteristicnvarchar100
88TC50EProcess Management: Process Characteristics5ATINNInternal characteristicnvarchar100
89TCB03Internal Characteristic Numbers for PP-PI Characteristics3ATINNInternal characteristicnvarchar100
90TCB06Dummy Table for External Key Assignment Betw. ATNAM & ATINN3ATINNInternal characteristicnvarchar100
91TCB11Assignment of Characteristics to Predefined Messages4ATINNInternal characteristicnvarchar100
92TCB15Predefined Assignmts of Charact. to Dest-Spec. Target Fields4ATINNInternal characteristicnvarchar100
TOPProcess Order
93AFFVOrder - Process Instruction Values15ATINNInternal characteristicnvarchar100
TOPProduct Lifecycle Management
94DIWPS_CACharacteristics for Work Package4ATINNInternal characteristicnvarchar100
95DIWPS_RV_CARevision: Characteristics for Work Package4ATINNInternal characteristicnvarchar100
TOPProduct Safety
96ESTAUSPEHS: Shadow table for AUSP3ATINNInternal characteristicnvarchar100
97TCGRULPOSMCHANGEEHS: Easy Expert Set of Rules, Changes to Characteristics6ATINNInternal characteristicnvarchar100
98TCGRULPOSMRESTEHS: Easy Expert Set of Rules, Characteristic Restrictions59ATINNInternal characteristicnvarchar100
TOPProfitability Analysis
99TKEZVCO-PA:Assignment SD characteristics to CO-PA characteristics3ATINNInternal characteristicnvarchar100
TOPReport Selection for Product Costing
100TCLZMAdministr. of Object Characteristics in Class SAP_KKR_CLASS6ATINNInternal characteristicnvarchar100
TOPResourcen Management
101RMXTC_S01TMS-TLS: Mapping Table f. Standardization (Char. - Nutrient)2ATINNInternal characteristicnvarchar100
TOPResults Recording
102QAMVCharacteristic specifications for inspection processing20ATINNInternal characteristicnvarchar100
TOPRetail Information System RIS
103ZSTARFMERKEnhancement for Article Characteristics in RIS2ATINNInternal characteristicnvarchar100
TOPSoftware Management
104S427Variant Config.2---IBASE10ATINNInternal characteristicnvarchar100
105S427ES427 - Structural information5ATINNInternal characteristicnvarchar100
TOPTakeoverHandover of Technical Objects
106TPHIN_MPT_EXTExternal ID of Supported PHIN Counters2ATINNMeasuring Point Characteristicnvarchar100
107TPHIN_TCB03Internal Characteristic Numbers for ToHo Characteristics2ATINNInternal Character. No. for ToHo Standard Characteristicsnvarchar100
TOPTechnical Objects
108EAML_D_AUSP_LFELinear Data for Characteristics - Database table3ATINNInternal characteristicnvarchar100
TOPVariant Configuration
109CABN_EXCLCharacteristics That Are Excluded for Type Matching4ATINNInternal characteristicnvarchar100
110CDCNDConfiguration: Direct Conditions Data Type:CHAR3ATINNInternal characteristicnvarchar100
111CECUFMConfiguration editor: design: format12ATINNInternal characteristicnvarchar100
112IBVALUECCBASE: Redundant Object Doc. on Value Changes for Instance5ATINNInternal characteristicnvarchar100
113KRIFRichie Riffle4ATINNInternal characteristicnvarchar100
114MACONDConfiguration: Manually Assigned Conditions4ATINNInternal characteristicnvarchar100
TOPVehicle Management System
115VLCSEARCHCHARVELO : Search Fields (Char.) Vehicle Search (for Profile)4ATINNInternal characteristicnvarchar100
TOPVendor Master
116WYT2Vendor-dependent char. value conversion3ATINNInternal characteristicnvarchar100
117WYT6Characteristics for characteristic value conversion2ATINNInternal characteristicnvarchar100
TOPWaste Management
118TEWASERVICETAXIMapping of Service Frequency Fields to Characteristics7ATINNInternal characteristicnvarchar100
119TEWAUPOSADMISBLEPermissable Waste/Waste Fraction for Subitem9ATINNInternal characteristicnvarchar100