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

90 columns | Print definition?ERP 6.0  | ATNAM

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/SMERP/STG_PM004Data staging - Equipment list set - Measuring Points54ATNAMCharacteristic Namenvarchar300
2/SMERP/STG_PM009Data staging - Func. Loc. List Set - Meas. Pts - cmplex tab54ATNAMCharacteristic Namenvarchar300
3CMM_FCHAR_MAPMapping of Attribute in Classification to Structure Field3ATNAMCharacteristic Namenvarchar300
4CMM_MD_CHARAssign Commodity Material to Characteristic2ATNAMCharacteristic Namenvarchar300
5CNV_10400_ATINNIdentified ATINNs per table5ATNAMCharacteristic namenvarchar300
6CNV_10400_MERKDOMapping characteristic <-> domain for conversion3ATNAMCharacteristic namenvarchar300
7CNV_10400_SETUPSettings for characteristic conversion5ATNAMCharacteristic namenvarchar300
8CNV_10400_TABUSESettings for characteristic conversion4ATNAMCharacteristic namenvarchar300
9EHPRCC_EC2MAPCP: Map Characteristics5ATNAMMapped Characteristic Namenvarchar300
10EHPRCC_IMMAPMapping table12ATNAMCharacteristic Namenvarchar300
11EHPRCC_PROPCP: definition of properties and characteristics4ATNAMCharacteristic Namenvarchar300
12EHPRCI_PAWMPhrase Set <-> characteristics check table for filling TCG662ATNAMCharacteristic Namenvarchar300
13TCG66_NONCHR30Exclude Characteristics from Phrase Set Assignment2ATNAMCharacteristic Namenvarchar300
14TIVYCMETER2COSTMeter and Cost Element Mapping table3ATNAMCharacteristic Namenvarchar300
15VIYCMETERCOSTSMeter Based Costs14ATNAMCharacteristic Namenvarchar300
TOPAerospace Defence Industry Solution
16ADFDR_CUSTCustomizing Flight Data Entry: Characteristic Assignment3ATNAMCharacteristic Namenvarchar300
17ROTKPI_CUSTTable to store the customization for MTBE Extractor3ATNAMCharacteristic Namenvarchar300
TOPBasic Data
18TIVBDMEASMETERCharacteristic per Measurement Type4ATNAMCharacteristic Namenvarchar300
TOPBatches
19TCB03_BMInternal Characteristic Numbers for PP-PI Characteristics1ATNAMCharacteristic Name for Batch Standard Characteristicsnvarchar300
TOPCharacteristics
20CABNCharacteristic4ATNAMCharacteristic Namenvarchar300
21CABNNEWCharacteristic4ATNAMCharacteristic Namenvarchar300
22TCTRWReserved Characteristic Names1ATNAMCharacteristic Namenvarchar300
TOPClassification
23TCL_ATINN_IDENTIdentification Table for Characteristics for Data Transfer5ATNAMCharacteristic Namenvarchar300
TOPComputer Aided Process Planning
24VMETVORData base for CAPP rules15ATNAMCharacteristic Namenvarchar300
TOPConfiguration Control
25MPL_C_ADAPTERAdapter for iPPE Workbench12ATNAMCharacteristic Name for Cancel-Part Relationshipnvarchar300
TOPConstruction Equipment Management
26J_3GPLKATAssignment Price List - Condition Types - Catalogs8ATNAMCharacteristic Namenvarchar300
TOPEnvironment
27CTBWCharacteristics for DataSources2ATNAMCharacteristic Namenvarchar300
28LCABNCharacteristic4ATNAMCharacteristic Namenvarchar300
TOPEnvironment, Health and Safety
29/TDAG/CPC_EC2MAPCP: Map Characteristics5ATNAMMapped Characteristic Namenvarchar300
30/TDAG/CPC_EXMAPCP: Export Mapping10ATNAMCharacteristic Namenvarchar300
31/TDAG/CPC_IMMAPMapping table12ATNAMCharacteristic Namenvarchar300
32/TDAG/CPC_PROPCP: definition of properties and characteristics4ATNAMCharacteristic Namenvarchar300
33/TDAG/CPC_PROPICP: Definition of Characteristic Mapping4ATNAMCharacteristic Namenvarchar300
34/TDAG/CPC_REP005CP: Define attributes for element11ATNAMCharacteristic Namenvarchar300
35/TDAG/RCSW_PAWMPhrase Set <-> characteristics check table for filling TCG663ATNAMCharacteristic Namenvarchar300
36EHQMT_MAIN1EH&S-QM: Subs. Value Assignmt Types for Insp. Plan Creation19ATNAMEH&S-QM: Name of Characteristic with Value to Specifynvarchar300
37EHQMT_MAIN2EH&S-QM: Characteristics for Inspection Plan Creation16ATNAMCharacteristic Namenvarchar300
TOPEnvironment, Health and Safety Master Data
38TCG66EHS: Value Assignment Type Class Characteristic4ATNAMCharacteristic Namenvarchar300
TOPFlexible Real Estate Management
39TIVXCSCCHMPATTRIAssignment of Characteristic ID to Characteristic3ATNAMCharacteristic Namenvarchar300
TOPIntegrated Product and Process Engineering
40PVS_VSHEME_CHARCharacteristics for Variance Scheme5ATNAMCharacteristic Namenvarchar300
TOPLine Maintenance
41/ISDFPS/CLMSLFTCharacteristics Lists for Controlled Usage Rate3ATNAMCharacteristic Namenvarchar300
TOPLogbook
42DIACL_CNTR_UPDControl of Aircraft logbook Counter updates2ATNAMName of characteristic used by logbook countersnvarchar300
TOPLogistics - General
43HBSCNBConfiguration <-> condition indexing3ATNAMCharacteristic Namenvarchar300
44HBSFSPHelp dummy table11ATNAMCharacteristic Namenvarchar300
TOPLogistics - General LO Enhancements
45/SAPMP/CHARACTAssignment of MillCa Characteristics3ATNAMCharacteristic Namenvarchar300
TOPMaintenance Program Definition
46MPDCUST_EFFT_DOCCustomising table to store effectivity data for documents5ATNAMCharacteristic Namenvarchar300
47MPDEFFECTMPD effectivity data5ATNAMCharacteristic Namenvarchar300
TOPMaterial Categories
48/ISDFPS/MPO_PROTLog of Data Transfers into MPO11ATNAMCharacteristic Namenvarchar300
TOPMaterial Groups
49LDGMAssignment Table Country Groups to Characteristics2ATNAMCharacteristic Namenvarchar300
50TWORDCharacteristic Sequence2ATNAMCharacteristic Namenvarchar300
TOPMaterial Master
51WRF_CHARVAL_HEADHeader Table for Controlling Characteristics3ATNAMCharacteristic Namenvarchar300
TOPMeasurement System
52GHO_IMPTT_ITEMData Capture Items4ATNAMCharacteristic Namenvarchar300
53GHO_IMRG_ITEMMeasurement Document Item Details4ATNAMCharacteristic Namenvarchar300
54GHO_MEASDTMeasurement Details3ATNAMCharacteristic Namenvarchar300
55GHO_MEAS_GRPDTMeasurement Group Details3ATNAMCharacteristic Namenvarchar300
56GHO_MEAS_TMeasurement Text Table3ATNAMnvarchar300
57IMPTT_ITEMMeasuring Point (Table) Extension4ATNAMCharacteristic Namenvarchar300
TOPMerchandise and Assortment Planning
58TWISPC_LEVELSRetail Planning: Meaning of Individual Planning Levels5ATNAMMAP: Name of Classification System Characteristicnvarchar300
TOPMill Products Industry Solution
59/SAPMP/GT_FDE_T1IMG: Fast Entry in Trading Contract General Settings8ATNAMCharacteristic namenvarchar300
TOPOverhead Cost Orders
60TKLCORules for taking over classification data3ATNAMCharacteristic Namenvarchar300
TOPPool Asset Management
61PAMS_MERKLinks: Characteristics/Fields3ATNAMCharacteristic Namenvarchar300
TOPProcess Management
62TC50CCharacteristics for Process Messages / Process Instructions5ATNAMCharacteristic namenvarchar300
63TC50PMessage Characteristics for Dest.-Specific Target Fields5ATNAMCharacteristic namenvarchar300
64TC60PP-PI: Assignment of PI Characteristics to Operator Cockpit7ATNAMCharacteristic namenvarchar300
65TCB03Internal Characteristic Numbers for PP-PI Characteristics2ATNAMCharacteristic namenvarchar300
66TCB06Dummy Table for External Key Assignment Betw. ATNAM & ATINN2ATNAMCharacteristic namenvarchar300
TOPProduct Lifecycle Management
67CDIWPS_CONFCustomizing Table for Configuration in MEB2ATNAMCharacteristic Namenvarchar300
68DIWPS_CACharacteristics for Work Package5ATNAMCharacteristic Namenvarchar300
69DIWPS_RV_CARevision: Characteristics for Work Package5ATNAMCharacteristic Namenvarchar300
TOPProduct Safety
70EST_CHANGE_DOCSEHS: Change Documents in the EH&S System19ATNAMCharacteristic Namenvarchar300
71TCG29EHS: Override for identification listing definitions7ATNAMCharacteristic Namenvarchar300
72TCGA6EHS: Report Symbol18ATNAMCharacteristic Namenvarchar300
73TCGRULPOSMRESTEHS: Easy Expert Set of Rules, Characteristic Restrictions57ATNAMCharacteristic Namenvarchar300
TOPProduct Structure Browser
74USROBJECTSTable of Previous Initial Object in Structure Overview13ATNAMCharacteristic Namenvarchar300
TOPReal Estate Management
75TIV07Apportionment unit ID9ATNAMCharacteristic Namenvarchar300
TOPReport Selection for Product Costing
76KKBMMCharacteristic Assignment for Selection Screens for Ord. Sel5ATNAMCharacteristic Namenvarchar300
TOPResourcen Management
77RMSAC_VAI_PPRMS-ATL: Phrased Process Parameter Names3ATNAMCharacteristicnvarchar300
TOPSales
78VBMUEZSales Document: Characteristic Overview Assignments4ATNAMCharacteristic Namenvarchar300
TOPSCM Basis
79CIF_IMCHRIntegration Model Reference Table for Characteristics2ATNAMCharacteristic Namenvarchar300
TOPSoftware Management
80S427Variant Config.2---IBASE17ATNAMCharacteristic Namenvarchar300
TOPSubcontracting
81SCMATMPCounters for SUBCONTRACTING3ATNAMCharacteristic Namenvarchar300
TOPTakeoverHandover of Technical Objects
82TPHIN_MPT_EXT1External ID of Supported PHIN Counters2ATNAMMeasuring Point Characteristicnvarchar300
83TPHIN_TCB03Internal Characteristic Numbers for ToHo Characteristics1ATNAMCharacteristic Name for ToHo Standard Characteristicsnvarchar300
TOPTransaction Manager
84VTBFATHDAcct Assmt Templates for PS Mult. Acct Assmts: Header Info.3ATNAMName of an Acct Assignment Templatenvarchar200
85VTBFATHD_TText Table for Account Assignment Templates3ATNAMName of an Acct Assignment Templatenvarchar200
86VTBFATITAcct Assmt Templates for PS Mult. Acct Assmts: Line Info.3ATNAMName of an Acct Assignment Templatenvarchar200
TOPVehicle Management System
87CVLC05VELO : Control Table Object Characteristics4ATNAMCharacteristic Namenvarchar300
88VLCCHPROITEMVELO : Configuration Change Profiles Characteristic Assgmt3ATNAMCharacteristic Namenvarchar300
TOPWaste Management
89TEWASERVICETAXIMapping of Service Frequency Fields to Characteristics8ATNAMCharacteristic Namenvarchar300
90TEWAUPOSADMISBLEPermissable Waste/Waste Fraction for Subitem10ATNAMCharacteristic Namenvarchar300