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

176 columns | Print definition?ERP 6.0  | DOMNAME

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/1CADMC/00000430DD07T4DOMNAMEnvarchar300
2/SMFND/GS001AGeospatial service - Service Provider Attributes Meta Info12DOMNAMEDomain namenvarchar300
3/SYCLO/CA003DMDO DOF Table Rule - Meta Data9DOMNAMEDomain namenvarchar300
4BTP_DL_IDXATTRBTP Index Attribute2DOMNAMEDomain namenvarchar300
5CNVA_CCD_ANA_DOMList of Domains supported by CNVA_CCD_ANA package2DOMNAMEDomain namenvarchar300
6CNVCMIS_A_1_DOMASelection of Object Type Master information4DOMNAMEDomain namenvarchar300
7CNVCMIS_A_1_DTELSelection of Object Type Master information6DOMNAMEDomain namenvarchar300
8CNVCMIS_A_1_TABFSelection of Object Type TABLE (TABF) Master information24DOMNAMEDomain namenvarchar300
9CNVCMIS_A_20_DICTable fields for Cross-Client Customizing Comparison18DOMNAMEDomain Namenvarchar300
10CNVCMIS_A_20_EXCExclude table for CMIS analysis (CCCC)4DOMNAMEDomain Namenvarchar300
11CNVCMIS_DOM_EXPTDomain exception table for CHECK DOMAIN function1DOMNAMEDomain namenvarchar300
12CNVCMIS_NTR_OBJInformation about shipped objects of nontransparent field3DOMNAMEDomain Namenvarchar300
13CNVCMIS_NTR_STRUInformation about the known values of nontransparent field6DOMNAMEDomain Namenvarchar300
14CNVC_CCE_CONVConversions-Table4DOMNAMEDomainnvarchar300
15CNVC_CCE_DOMAMapping table for comparison (1)2DOMNAMEDomain namenvarchar300
16CNVC_CCE_DOMVALCustomizing Comparison Domain values for Status and Comments2DOMNAMEDomain Namenvarchar300
17CNVC_CCE_FILTERFilter table4DOMNAMEDomainnvarchar300
18CNVC_CCE_STATCustomizing Comparison Status and Comments2DOMNAMEDomain Namenvarchar300
19CNVC_CCE_STATTCustomizing Comparison Descriptions for Status and Comments2DOMNAMEDomain Namenvarchar300
20CNVC_CCE_WUWhere-used cache (domain)2DOMNAMEDomain namenvarchar300
21CNVC_SCNG_F4TText Table for 'F4' Help Values2DOMNAMEDomain Namenvarchar300
22CNVC_SCNG_F4_DOM'F4' Help values for Domains2DOMNAMEDomain Namenvarchar300
23CNVC_SCNR_SCMD1Assignment NRIV-Object to data element9DOMNAMEDomain namenvarchar300
24CNVHCM_PARDEFTDMS4HCM: Parameter Object Definitions11DOMNAMEDomain namenvarchar300
25CNVLTHCM_HRDOMOBSOLETE! DO NOT USE!!!2DOMNAMEDomain namenvarchar300
26CNVLTHCM_HRDOM2LT HCM: Domains of HCM Tables3DOMNAMEDomain namenvarchar300
27CNVLTHCM_I_HRDOMOBSOLETE! DO NOT USE!!!1DOMNAMEDomain namenvarchar300
28CNVMBTDOMSdomains / data elements with corresponding conv. rules3DOMNAMEDomain Namenvarchar300
29CNVMBTDOPARSparameters for domains3DOMNAMEDomain Namenvarchar300
30CNVMBTRENAMERenaming 1:13DOMNAMEDomain Namenvarchar300
31CNVMBTRULEFIELDSfield assignments for rules during migration6DOMNAMEDomain Namenvarchar300
32CNVMBTRULEPARSconversion rules parameter structure and types8DOMNAMEDomain Namenvarchar300
33CNVMBTSCCUCOPARSScramble Rule Parameters12DOMNAMEDomain Namenvarchar300
34CNVMBTSELMEMTYPEMBT PCL Selection group member types6DOMNAMEDomain Namenvarchar300
35CNVMBTTABSTRUCField list of tables for file transfer12DOMNAMEDomain namenvarchar300
36CNVTDMSSCR_DOMSList of Domains Assigned to a Rule5DOMNAMEDomain namenvarchar300
37CNVTDMSSCR_DPARSParameters assigned to the Domain5DOMNAMETable Namenvarchar300
38CNVTDMS_08_TSTRUTDMS_TSTRUCT for Client Conversion6DOMNAMEDomain Namenvarchar300
39CNVTDMS_EC_DTEXTTable to hold desc. for Domains used for selection groups2DOMNAMEDomain Namenvarchar300
40CNV_00001_FDOMSOBSOLETE: Use CNVDOMS5DOMNAMEDomain namenvarchar300
41CNV_00001_PDOMSDomains suitable for conversion routine parameters6DOMNAMEDomain namenvarchar300
42CNV_10020_DTOBJPAssignment of determination objects to domains/data elemen5DOMNAMEDomain namenvarchar300
43CNV_10100_SETCLS(Obsolete for Package 10100)4DOMNAMEDomain namenvarchar300
44CNV_10210_DOMSNumber conversion engine: relevant subobject domains3DOMNAMEDomain namenvarchar300
45CNV_10400_DOPARSConversion: Parameter for conversion routine of a domain3DOMNAMEDomain namenvarchar300
46CNV_10400_MERKDOMapping characteristic <-> domain for conversion9DOMNAMEDomain namenvarchar300
47CNV_10400_SETUPSettings for characteristic conversion23DOMNAMEDomain namenvarchar300
48CNV_10940_DOMAINDomain Entries4DOMNAMEDomain namenvarchar300
49CNV_20330_TSTRUCStructure of CO object numbers7DOMNAMEDomain namenvarchar300
50CNV_20551_KORDOMCorrection table for domains for 205511DOMNAMEDomain namenvarchar300
51CNV_20551_TSTRUCIntransparent fields: Structure description6DOMNAMEDomainnvarchar300
52CNV_20800_MSEGTable to maintain database for MSEG3DOMNAMEDomain namenvarchar300
53CNV_20900_MSGTable to maintain database for MSEG3DOMNAMEDomain namenvarchar300
54CNV_INTR_FLD_STRIntransparent fields: Structure description6DOMNAMEDomainnvarchar300
55CNV_NCE_KBNumber conversion engine: Knowledge Base5DOMNAMEDomain namenvarchar300
56CNV_NCE_KB_LOCALNumber conversion engine: Local Knowledge Base7DOMNAMEDomain namenvarchar300
57CTS_DEPL_USERSeCTS: Deploy Users1DOMNAMETMS: Transport Domainnvarchar100
58DD03NDDD: Attributes of a Node of a Structured Object19DOMNAMEDomain namenvarchar300
59DFKKBIXC8162CIT Class Configuration Version (Table TFK8162)9DOMNAMEDomain namenvarchar300
60DFKKBIXE8162Working Version CIT Class Configuration (Table TFK8162)8DOMNAMEDomain namenvarchar300
61DFKKBIXG8162CIT Class Generation Version (Table TFK8162)9DOMNAMEDomain namenvarchar300
62DMC_VARIABLEMWB: Variables6DOMNAMEDomain namenvarchar300
63DVM_BOF_PACKSBusiness Object Footprint packages for PPF5DOMNAMEDomain namenvarchar300
64DVM_BOF_RUNSBusiness Objects Footprint runs6DOMNAMEDomain namenvarchar300
65DVM_BOF_STATSBusiness Objects Footprint statistics5DOMNAMEDomain namenvarchar300
66DVM_BOF_TEXTBusiness Objects Footprint: Description fields for domains1DOMNAMEDomain namenvarchar300
67FARR_C_RAI52Fields of a Revenue Accounting Item Class9DOMNAMEDomain namenvarchar300
68FARR_D_RAIC52Configuration Version RAI Class (FARR_C_RAI52)10DOMNAMEDomain namenvarchar300
69FARR_D_RAIG52Generation Version RAI Class (FARR_C_RAI52)10DOMNAMEDomain namenvarchar300
70FARR_D_RAIW52Working Version Configuration RAI Class (FARR_C_RAI52)10DOMNAMEDomain namenvarchar300
71TFK8162Fields of a Consumption Item Class8DOMNAMEDomain namenvarchar300
72TMSDEPLOYTARGETSManaging CTS: Current Deployment Targets (Overall Domains)1DOMNAMETMS: Transport Domainnvarchar100
TOPABAP Authorization and Role Management
73HRT1254Table Part Variable Assignments5DOMNAMEDomain namenvarchar300
TOPActivation Program, Conversion Program, DB Utility, MC, SPDD
74DD01LDomains1DOMNAMEDomain namenvarchar300
75DD01TR/3 DD: domain texts1DOMNAMEDomain namenvarchar300
76DD03LTable Fields21DOMNAMEDomain namenvarchar300
77DD04LData elements4DOMNAMEDomain namenvarchar300
78DD07LR/3 DD: values for the domains1DOMNAMEDomain namenvarchar300
79DD07TDD: Texts for Domain Fixed Values (Language-Dependent)1DOMNAMEDomain namenvarchar300
80DDFTXRun-time object with Screen Painter texts5DOMNAMEDomain namenvarchar300
TOPApplication Framework
81MDG_MDF9102Local Domains (Storage Only)1DOMNAMEDomain namenvarchar300
TOPBasic Functions
82T800DOMFixed exits1DOMNAMEDomain namenvarchar300
TOPBilling in Contract Accounts Receivable and Payable
83DFKKBIXC8152BIT Class Configuration Version (Table TFK8152)10DOMNAMEDomain namenvarchar300
84DFKKBIXE8152Working Version Configuration BIT Class (Table TFK8152)10DOMNAMEDomain namenvarchar300
85DFKKBIXG8152BIT Class Generation Version (Table TFK8152)10DOMNAMEDomain namenvarchar300
86TFK8152Fields for a Class of Billable Items9DOMNAMEDomain namenvarchar300
TOPBusiness Application Support
87CNVDOMSCNV: Domains required by conversion package3DOMNAMEDomain namenvarchar300
88CNVDOMSCCNV: from conv. pack. domains with conflicts in blending4DOMNAMEDomain namenvarchar300
89CNVDOMSTConversion: Domains and data elements affected4DOMNAMEDomain namenvarchar300
90CNVDOMSTCConversion: relevant domains with conflicts5DOMNAMEDomain namenvarchar300
91CNVDOPARSConversion: Parameters for the FORM routines from CNVDOMS3DOMNAMEDomain namenvarchar300
92CNVDOPARSCConversion: Parameters for FORM routines with conflicts4DOMNAMEDomain namenvarchar300
93CNVFIELDREFAssignment of fields to organizational units6DOMNAMEDomain namenvarchar300
94CNVFIREF_DELTATable for delta maintenance of CNVFIELDREF7DOMNAMEDomain namenvarchar300
95CNVKONDITIONENConversion: Auxiliary table for fields of condition tables5DOMNAMEDomain namenvarchar300
96CNVRENAMEConversion: Renaming 1:13DOMNAMEDomain namenvarchar300
97CNV_10992_TSTRUCStructure of text object keys for texts7DOMNAMEDomainnvarchar300
98CNV_10994_TSTRUCIntransparent fields in change doc. obj.: Structure8DOMNAMEDomainnvarchar300
TOPBusiness Configuration Sets
99SCPRENTYBC Set: Organizational units1DOMNAMEDomain namenvarchar300
TOPBusiness Consolidation
100UCL0010Text Information for Domains1DOMNAMEDomain namenvarchar300
TOPBusiness Object Builder
101SWOTLQRuntime Table Parameters, Exceptions28DOMNAMEDomain namenvarchar300
102SWOTLVRuntime Table Verbs35DOMNAMEDomain namenvarchar300
TOPBusiness Partner
103BPUMConversion: Tables/Fields to be Converted7DOMNAMEDomain namenvarchar300
104BPUM_DOMConversion: List of Domains to be Converted3DOMNAMEDomain namenvarchar300
105BPUM_ROLConversion: Data elements to be converted4DOMNAMEDomain namenvarchar300
TOPBW Service API
106RSIOTAB01Table for Setting Up Master Data Delta5DOMNAMEDomain namenvarchar300
TOPCentral Part of Product Master
107COMC_CRD_GEN_BWDCRM CRD: Generated Text DataSources for Domains3DOMNAMEDomain namenvarchar300
TOPCoding Block
108TCOBNCoding Block: Customer Fields2DOMNAMEDomain namenvarchar300
TOPCondition Technique
109/SAPCND/T688CFields from Condition Tables Sorted Acc. To Dependency25DOMNAMEDomain namenvarchar300
TOPConsolidation
110TF020Textinformation for Domains1DOMNAMEDomain namenvarchar300
TOPCross-Application Components
111/IXOS/DC_TAMAGeneral Doculink administraton data for data source7DOMNAMEDomain namenvarchar300
112/IXOS/DC_TCLNTSFLink nodetype/selection field16DOMNAMEDomain name for text replacementnvarchar300
113/IXOS/DC_TC_NTSFMemorized deleted Links: nodetype/selection field16DOMNAMEnvarchar300
TOPData Collection
114TMC6PNecessary Characteristics for Units3DOMNAMEDomain namenvarchar300
TOPData Conversion
115DMC_FIELDDMC: Data Field of a Structure33DOMNAMEDomain namenvarchar300
TOPData Staging
116RSTSDOMAGeneral domains for transfer structure4DOMNAMEDomain namenvarchar300
117RSTSDTELData element for transfer structure per logical system7DOMNAMEDomain namenvarchar300
118RSTSDTELNEWData element for transfer structure per logical system7DOMNAMEDomain namenvarchar300
TOPEmployee Interaction Center
119THREIC_CONSTANTVInput Help for EIC Constants3DOMNAMEData element (semantic domain)nvarchar300
TOPFinancials Basis
120UGR31008FIN Master Data: Dummy Field Names with Properties23DOMNAMEDomain namenvarchar300
121UGR31022FIN Master Data: Buffer Table f.Fields of Extract Structures21DOMNAMEDomain namenvarchar300
TOPFlexible Real Estate Management
122TIVCAECRE-FX: Currency Conversion - Relevant Tables and Fields8DOMNAMEDomain namenvarchar300
TOPFront Office
123EWMOBJKEYInternal Help Table for Creating Objects from Keys3DOMNAMEDomain namenvarchar300
TOPGlobal Organization Customizing
124ENTCOPY00Valid Domains for Entity Copier1DOMNAMEDomain namenvarchar300
125ENTCOPY01Object Assignments for Entity Copier1DOMNAMEDomain namenvarchar300
126ENTCOPY02User Exits for Entity Copier1DOMNAMEDomain namenvarchar300
127ENTCOPY03ECOP: Permitted maintenance views to be processed1DOMNAMEDomain namenvarchar300
TOPGlobal Trade Services
128/SAPSLL/TCOCNVLegal & Logistics Services - Conversion Data2DOMNAMEDomain namenvarchar300
TOPHR Information Systems
129T770UText field information on table fields7DOMNAMEDomain namenvarchar300
TOPI18N Unicode
130UMGCONResults Table for Container Search5DOMNAMEDomain namenvarchar300
TOPLocal Currency Changeover
131EWUCUPAKETContains the individual packages for user-defined objects11DOMNAMEDomain namenvarchar300
TOPMaster Data Framework
132UGMD9102FIN Master Data: Local Domains (Only Folder)1DOMNAMEDomain namenvarchar300
TOPMaterial Master
133WER_ITEM_FIELD_AInformation about the fields of an item11DOMNAMEDomain namenvarchar300
134WER_ITEM_FIELD_SInformation about the fields of an item10DOMNAMEDomain namenvarchar300
135WER_ITEM_FIELD_TItem fields used for testing10DOMNAMEDomain namenvarchar300
TOPMerchandise and Assortment Planning
136TWISPC_MDATTRMaster Data Attributes7DOMNAMEDomain namenvarchar300
TOPMobile Applications
137/ISDFPS/ME_SFLDDO Segement Fields14DOMNAMEDomain namenvarchar300
TOPNetWeaver Enterprise Search
138ESH_OM_ADATATYData Types5DOMNAMEDomain namenvarchar300
139ESH_OM_CDATATYData Types5DOMNAMEDomain namenvarchar300
140ESH_OM_IDATATYData Types5DOMNAMEDomain namenvarchar300
141ESH_OM_SDATATYData Types5DOMNAMEDomain namenvarchar300
TOPPension Administration
142T7PBSCA2GEntities Table of Domains for Table T7PBSCA2H3DOMNAMEDomain namenvarchar300
143T7PBSCA2HAlternative Texts for Fixed Value Domains4DOMNAMEDomain namenvarchar300
144T7PBSCA2HTText Table for T7PBSCA2H5DOMNAMEDomain namenvarchar300
TOPPlanning
145T8PL01DDFI Planning: Dimensions Table Index - Dictionary Information7DOMNAMEDomain namenvarchar300
TOPProcess Management
146CMX_XS_C_TL_PICXSteps: Translatable Process Instruction Characteristics2DOMNAMEName of a Process Instruction Characteristicnvarchar400
147CMX_XS_DB_ARPXSteps: Fields for Property Index of the Applications4DOMNAMEName of a Process Instruction Characteristicnvarchar400
148CMX_XS_DB_METAXSteps: Metadata4DOMNAMEName of a Process Instruction Characteristicnvarchar400
149CMX_XS_DB_PSXSteps: Parameter, Definition in DB Format SMALL4DOMNAMEName of a Process Instruction Characteristicnvarchar400
150CMX_XS_DB_PSLXSteps: Parameter, LIVE Data in DB Format SMALL5DOMNAMEName of a Process Instruction Characteristicnvarchar400
151CMX_XS_DB_VSXSteps: Values in DB Format SMALL4DOMNAMEName of a Process Instruction Characteristicnvarchar400
TOPReportReport Interface
152TVIRTDOMStandard Domains and Virtual Domains2DOMNAMEVirtual Domain Name for Transformationnvarchar300
TOPSales Support
153T180LSD: Valid Logical Databases for Extended Search Help1DOMNAMEDomain namenvarchar300
TOPSAP NetWeaver Mobile - Use subcomponents
154MEREP_406Default Value: Value ID10DOMNAMEDomain namenvarchar300
TOPSpecification 2
155ADS2KIPUPL_DTELSPEC2000 IP Upload: Data Elements2DOMNAMEDomain namenvarchar300
TOPTable Maintenance Tool
156ORGCRFLDOrganization criteria attribute8DOMNAMEDomain namenvarchar300
TOPTechnical Application Support
157CNV_20365_ORGControlling area currencies for conversion2DOMNAMECharacter Field with Length 5nvarchar50
TOPTransaction Variant and Table Control Settings
158ESHDGBlock global values2DOMNAMEDomain namenvarchar300
159SHDCFGlobal values 3.1: Candidates for domains and fields1DOMNAMEDomain namenvarchar300
160SHDDCGlobal values 3.1: Assignment of domains to components1DOMNAMEDomain namenvarchar300
161SHDDCDEGlobal values: Assign data elements to components3DOMNAMEDomain namenvarchar300
162SHDDCDOGlobal values: Assignment of domains to components1DOMNAMEDomain namenvarchar300
163SHDDFGlobal values 3.1: Assgnmt of depend. text fields to domains1DOMNAMEDomain namenvarchar300
164SHDDFDOGlobal values: Assign dependent fields to domains1DOMNAMEDomain namenvarchar300
165SHDGVGlobal values4DOMNAMEDomain namenvarchar300
166SHDGVDOGlobal values: Values and flags for domains2DOMNAMEDomain namenvarchar300
TOPTransport Management System
167TMSCTASKTMS: Task List1DOMNAMETMS: Transport Domainnvarchar100
168TMSQCONFRMTMS: QA Confirm Table - Copy of TCECONFIRM1DOMNAMETMS: Transport Domainnvarchar100
TOPTransport Organizer
169CTS_APPLTYPECTS: Supported values for application types1DOMNAMETMS: Transport Domainnvarchar100
170CTS_APPLTYPETCTS: Text for supported application types (CTS_APPLTYPE)1DOMNAMETMS: Transport Domainnvarchar100
171CTS_SY_DETAILSCTS: System details for handling of application types1DOMNAMETMS: Transport Domainnvarchar100
TOPTreasury
172CML_MIG_BUFFERTable DDIC buffering (migration)8DOMNAMEDomain namenvarchar300
TOPUser and Authorization Management
173AUTH_FLDINFO_TMPAuthorization fields: technical info from dictionary4DOMNAMEDomain namenvarchar300
TOPValue Mapping
174MDGD_DOMAIN_MAPMapping of "official" internal to domain-specific codelist3DOMNAMEDomain Namenvarchar300
TOPWeb Service and SOAP - ABAP
175SRT_WSSELECTIONOBSOLETE Excerpt of Selection Criteria22DOMNAMECharacter field, length 32nvarchar320
TOPWorkbench Utilities
176SPAR_NTDBParameter Storage: Persistent Nametab Container11DOMNAMEDomain namenvarchar300