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

151 columns | Print definition?ERP 6.0  | CHUSER

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1CNVFIELDMAPConversion: Table mapping14CHUSERChange usernvarchar120
2CNVFIELDMAPFUNCConversion: Mapping Methods for Field Mapping14CHUSERChange usernvarchar120
3CNVINCLTABConversion: Includes for certain tables14CHUSERChange usernvarchar120
4CNVLTHCM_ADDTABOBSOLETE! DO NOT USE!!!14CHUSERChange usernvarchar120
5CNVLTHCM_APPLTABOBSOLETE! DO NOT USE!!!14CHUSERChange usernvarchar120
6CNVLTHCM_BASETABLT HCM: List of HCM Basis Tables12CHUSERChange usernvarchar120
7CNVLTHCM_CWBPACKLT HCM: Assigned CWB Packages14CHUSERChange usernvarchar120
8CNVLTHCM_DELOPTLT HCM: Options for Deletion of HCM Tables14CHUSERChange usernvarchar120
9CNVLTHCM_DELTABLT HCM: List of HCM Tables to be Deleted15CHUSERChange usernvarchar120
10CNVLTHCM_HRDOMOBSOLETE! DO NOT USE!!!12CHUSERChange usernvarchar120
11CNVLTHCM_HRDOM2LT HCM: Domains of HCM Tables13CHUSERChange usernvarchar120
12CNVLTHCM_HRPCKOBSOLETE! DO NOT USE!!!11CHUSERChange usernvarchar120
13CNVLTHCM_HRPCK2LT HCM: HCM Development Packages12CHUSERChange usernvarchar120
14CNVLTHCM_HRTABLT HCM: List of HCM Tables for Transfer15CHUSERChange usernvarchar120
15CNVLTHCM_INDXTRNLT HCM: Cluster Components for Transfer15CHUSERChange usernvarchar120
16CNVLTHCM_MIGSCENLT HCM: Migration Scenario16CHUSERChange usernvarchar120
17CNVLTHCM_PRESELLT HCM: HR Object Selection Assignment to Package13CHUSERChange usernvarchar120
18CNVLTHCM_RCVINFOLT HCM: Information about Receiver System17CHUSERChange usernvarchar120
19CNVLTHCM_SELTABSLT HCM: Data Selection for Tables28CHUSERChange usernvarchar120
20CNVLTHCM_SELTYPLT HCM: Customer-defined Selection Types11CHUSERChange usernvarchar120
21CNVLTHCM_TABGRPLT HCM: Table Groups12CHUSERChange usernvarchar120
22CNVLTHCM_TABOPTOBSOLETE! DO NOT USE!!!12CHUSERChange usernvarchar120
23CNVLTHCM_TP_DEFLT HCM: Time-point Processing - Definition17CHUSERChange usernvarchar120
24CNVLTHCM_TP_MAPLT HCM: Time-point Mapping13CHUSERChange usernvarchar120
25CNVMBTCODEAPPCodeAppends11CHUSERMBT PCL created / changed usernamenvarchar120
26CNVMBTKPILMODULSMBT KP: initial load function moduls knowledge pool11CHUSERMBT PCL created / changed usernamenvarchar120
27CNVMBTKPTABFIELDMBT KP: Response information of tables and fields13CHUSERMBT PCL created / changed usernamenvarchar120
28CNVMBTRULESconversion rules9CHUSERMBT PCL created / changed usernamenvarchar120
29CNVMBTSCAPPLScrambling Applications10CHUSERMBT PCL created / changed usernamenvarchar120
30CNVMBTSCCDSETConditionSet20CHUSERMBT PCL created / changed usernamenvarchar120
31CNVMBTSCCDSETTConditionSetText11CHUSERMBT PCL created / changed usernamenvarchar120
32CNVMBTSCCUCOScramblingRule Code Customizing11CHUSERMBT PCL created / changed usernamenvarchar120
33CNVMBTSCFDSETFieldSet18CHUSERMBT PCL created / changed usernamenvarchar120
34CNVMBTSCFDSETTFieldSetText11CHUSERMBT PCL created / changed usernamenvarchar120
35CNVMBTSCGRPScramblingGroup13CHUSERMBT PCL created / changed usernamenvarchar120
36CNVMBTSCGRPTScramblingGroupText11CHUSERMBT PCL created / changed usernamenvarchar120
37CNVMBTSCKYSETKeySet12CHUSERMBT PCL created / changed usernamenvarchar120
38CNVMBTSCOPRDOperands12CHUSERMBT PCL created / changed usernamenvarchar120
39CNVMBTSCSCCUScramblingRule Customizing13CHUSERMBT PCL created / changed usernamenvarchar120
40CNVMBTSCSCCUTScramblingRule Customizing12CHUSERMBT PCL created / changed usernamenvarchar120
41CNVMBTSCSCRLScramblingRule14CHUSERMBT PCL created / changed usernamenvarchar120
42CNVMBTSCSCRLTScramblingRule Text11CHUSERMBT PCL created / changed usernamenvarchar120
43CNVMBTSCSETScramblingSet16CHUSERMBT PCL created / changed usernamenvarchar120
44CNVMBTSCSETTScramblingSetText11CHUSERMBT PCL created / changed usernamenvarchar120
45CNVTABLEMAPConversion: Table mapping12CHUSERChange usernvarchar120
46CNVTDMSSCR_APLNKLink Table : Connects Rules and Proc Types8CHUSERMBT PCL created / changed usernamenvarchar120
47CNVTDMSSCR_APPLApplication Master Table for Scrambling7CHUSERMBT PCL created / changed usernamenvarchar120
48CNVTDMSSCR_APPLTApplication Text Table9CHUSERMBT PCL created / changed usernamenvarchar120
49CNVTDMSSCR_CONDScrambling Condition Sets19CHUSERMBT PCL created / changed usernamenvarchar120
50CNVTDMSSCR_CULNKLink Table : Connects CWB Packages to TDMS Scrambling UI8CHUSERMBT PCL created / changed usernamenvarchar120
51CNVTDMSSCR_DOMSList of Domains Assigned to a Rule12CHUSERMBT PCL created / changed usernamenvarchar120
52CNVTDMSSCR_DPARSParameters assigned to the Domain15CHUSERMBT PCL created / changed usernamenvarchar120
53CNVTDMSSCR_FLDSList of Tables and Fields Assigned to a Rule13CHUSERMBT PCL created / changed usernamenvarchar120
54CNVTDMSSCR_FMIDScrambling Final Mapping ID9CHUSERMBT PCL created / changed usernamenvarchar120
55CNVTDMSSCR_FPARSParameters assigned to the Rules14CHUSERMBT PCL created / changed usernamenvarchar120
56CNVTDMSSCR_GRLNKLink Table : Connects Rules and Groups10CHUSERMBT PCL created / changed usernamenvarchar120
57CNVTDMSSCR_GRPScrambling Groups9CHUSERMBT PCL created / changed usernamenvarchar120
58CNVTDMSSCR_GRPHIScrambling Groups Hierarchy10CHUSERMBT PCL created / changed usernamenvarchar120
59CNVTDMSSCR_GRPTScrambling Groups Text Table9CHUSERMBT PCL created / changed usernamenvarchar120
60CNVTDMSSCR_INCLList of Includes Assigned to a RUle10CHUSERMBT PCL created / changed usernamenvarchar120
61CNVTDMSSCR_KEYSTScrambling Keyset for rule11CHUSERMBT PCL created / changed usernamenvarchar120
62CNVTDMSSCR_MIDMapping ID's for Scrambling.10CHUSERMBT PCL created / changed usernamenvarchar120
63CNVTDMSSCR_MIDTMapping ID Texts9CHUSERMBT PCL created / changed usernamenvarchar120
64CNVTDMSSCR_MLNKLink Table : Connects Mapping ID's to Rules9CHUSERMBT PCL created / changed usernamenvarchar120
65CNVTDMSSCR_MTYPMapping Types for Scrambling9CHUSERMBT PCL created / changed usernamenvarchar120
66CNVTDMSSCR_MTYPTMapping Types Texts9CHUSERMBT PCL created / changed usernamenvarchar120
67CNVTDMSSCR_PROCProc Types for Scrambling.7CHUSERMBT PCL created / changed usernamenvarchar120
68CNVTDMSSCR_PROCTProc Types Texts.9CHUSERMBT PCL created / changed usernamenvarchar120
69CNVTDMSSCR_RANIDScrambling Random ID8CHUSERMBT PCL created / changed usernamenvarchar120
70CNVTDMSSCR_RULEScrambling Rules14CHUSERMBT PCL created / changed usernamenvarchar120
71CNVTDMSSCR_RULETScrambling Rule Texts9CHUSERMBT PCL created / changed usernamenvarchar120
72CNV_00001_FDOMSOBSOLETE: Use CNVDOMS17CHUSERChange usernvarchar120
73CNV_00001_FORMSForm routines used in conversions21CHUSERChange usernvarchar120
74CNV_00001_PARSParameters of form routines used in conversion16CHUSERChange usernvarchar120
75CNV_00001_PDOMSDomains suitable for conversion routine parameters18CHUSERChange usernvarchar120
76CNV_10996_FIELDSSpecific conversion routines24CHUSERChange usernvarchar120
77CNV_10996_FIPARSParameters for specific conversion routines15CHUSERChange usernvarchar120
78CNV_20100_CONFLConflicts on field level (new found account fields)15CHUSERUser Namenvarchar120
79CNV_20200_SP_TABDefinition of tables for the Special Priority Handling16CHUSERChange usernvarchar120
80CNV_20200_SP_VALControl Table for the Special Priority Handling14CHUSERChange usernvarchar120
81CNV_20317_DATBIDetermination for date dependent tables24CHUSERChange usernvarchar120
82CNV_20400_EXCLUTables to be excluded17CHUSERChange usernvarchar120
83CNV_20551_OBJCVTObjecttypes for which a re-conversion shall take place8CHUSERChange usernvarchar120
84CNV_20551_SEQORDTable dependency for start sequence7CHUSERUser Namenvarchar120
85CNV_20551_TABCVTTables for special (re-) processing13CHUSERChange usernvarchar120
86CNV_INDX_CLUSTSINDX clusters13CHUSERChange usernvarchar120
87CNV_INDX_FIELDSINDX conversion: Conv.-relev. RELID component fields20CHUSERChange usernvarchar120
88CNV_INDX_FIPARSINDX conversion: Parameters for conv. of RELID comp. fields17CHUSERChange usernvarchar120
89CNV_INDX_IEINCLSIncludes for versions of RELID import/export routines15CHUSERChange usernvarchar120
90CNV_INDX_IEVERSAdditional versions of RELID import/export routines16CHUSERChange usernvarchar120
91CNV_INDX_IEVPARSParameters of RELID import/export routines17CHUSERChange usernvarchar120
92CNV_INDX_IEVRULERules for choosng RELID structure variant13CHUSERChange usernvarchar120
93CNV_INDX_IEVRULPParameters of rules for choosng RELID structure variant15CHUSERChange usernvarchar120
94CNV_INDX_INCLINDX conversion: Includes for INDX RELID conversion15CHUSERChange usernvarchar120
95CNV_INDX_PACKCNFConfiguration of the INDX conversion for the package19CHUSERChange usernvarchar120
96CNV_INDX_RELIDSINDX cluster RELIDs16CHUSERChange usernvarchar120
97CNV_INDX_STEPSINDX conversion: process-related functions19CHUSERChange usernvarchar120
98CNV_INDX_STPARSINDX conversion: Parameters for process-related functions18CHUSERChange usernvarchar120
99CNV_INDX_STRUCTSStructures of INDX RELIDs17CHUSERChange usernvarchar120
100CNV_INDX_STRVERSAdditional versions of RELID structure retrieval methods13CHUSERChange usernvarchar120
101CNV_INDX_TABLESINDX conversion: Conv.-relev. RELID components18CHUSERChange usernvarchar120
102IUUC_REPL_CONFIGConfiguration of a replication mt_id31CHUSERUser Namenvarchar120
103IUUC_REPL_HDRHeader for the configuration ID11CHUSERUser Namenvarchar120
104T7PIQCONVERSIONCM: Data Conversions after Upgrades7CHUSERUser Namenvarchar120
TOPALE Integration Technology
105TBD611Definition of Conversion Matrix for System7CHUSERUser Namenvarchar120
106TBD61BLogging for Conversion Data14CHUSERUser Namenvarchar120
TOPBusiness Application Support
107CNVDOMSCNV: Domains required by conversion package20CHUSERChange usernvarchar120
108CNVDOPARSConversion: Parameters for the FORM routines from CNVDOMS18CHUSERChange usernvarchar120
109CNVFIELDSConversion: Table fields affected24CHUSERChange usernvarchar120
110CNVFIPARSConversion: Parameters for conversion of table fields15CHUSERChange usernvarchar120
111CNVINCLConversion: of includes required by conversion package12CHUSERChange usernvarchar120
112CNVSTEPSConversion: procedure-related functions16CHUSERChange usernvarchar120
113CNVSTPARSConversion: Parameters for procedure-related functions16CHUSERChange usernvarchar120
114CNVTABLESConversion: Tables for processing by package24CHUSERChange usernvarchar120
115CNV_00001_PARAMSParameter table19CHUSERChange usernvarchar120
TOPCollectionsDisbursements
116VVSCPOSPayment Plan Item50CHUSERPayment Plan Item Last Changed bynvarchar120
TOPControlling
117SUR_SSM_BUFFERSurvey Status Manager: buffer table for status changes7CHUSERUser Namenvarchar120
TOPExpenditure Certification
118FMEUFFNSFinancing Source32CHUSERLast changed bynvarchar120
119FMEUFOPHDefine Operation Header8CHUSERLast changed bynvarchar120
120FMEUFRUNCertification Run Parameter27CHUSERLast changed bynvarchar120
TOPGL transfer
121TBKKC_BUKRSBCA Locally Duplicated Values for Corresponding FI16CHUSERLast user to change objectnvarchar120
TOPJoint Venture und Production Sharing Accounting
122T8JUJoint Operating Agreement28CHUSERUser who Last Changednvarchar120
123T8JVJoint Venture14CHUSERUser who Last Changednvarchar120
TOPLoans Management
124TDPR_PRODVVersion of a Prodcut, Master Data12CHUSERLast User to Change the Objectnvarchar120
TOPMaster Data
125BKK610Account Hierarchy: Assignment of Root Account to Tree Number22CHUSERLast user to change objectnvarchar120
TOPMonitoring
126ALMDRULESAlerts: Rules for rule nodes of a monitor definition13CHUSERUser Namenvarchar120
127ALMONISETSAlerts: Monitor sets of the CCMS monitoring infrastructure12CHUSERUser Namenvarchar120
128ALMONITORSAlerts: Monitors and Corresponding Default Values11CHUSERUser Namenvarchar120
129ALMRULESAlerts: Rule Descriptions for Monitor Definitions (V3)12CHUSERUser Namenvarchar120
130ALMSETSAlerts: Monitor Sets and Corresponding Attributes11CHUSERUser Namenvarchar120
131ALMSETSV2Alerts: Copy of Monitor Sets From Database Version 212CHUSERUser Namenvarchar120
TOPPackage Tools
132AKB_SCR_DIRObsolete: Script Index2CHUSERLast Changed bynvarchar120
TOPPegging, Grouping, and Distribution
133GPD_TARCH_REPOBJGPD Archiving Replenishment Object table12CHUSERName of Person Who Changed Objectnvarchar120
134GPD_TARCH_WBSGPD Archiving WBS table9CHUSERName of Person Who Changed Objectnvarchar120
TOPProduct definition
135FIPR_PRODVVersion of a Prodcut, Master Data12CHUSERLast user to change objectnvarchar120
TOPProduction and Revenue Accounting
136OIUCM_T8JVPRA Joint Venture Master Data14CHUSERUser who Last Changednvarchar120
TOPRemaining Beverage - Obsolete Objects
137/BEV3/CHBKERGRSLPurchase control results42CHUSERChanged bynvarchar120
138/BEV3/CHBKRESHISPurchase Control Results - History42CHUSERChanged bynvarchar120
139/BEV3/CHBKRESULTPurchase control results42CHUSERChanged bynvarchar120
140/BEV3/CHBKTMPTemp. Purchase Control Results42CHUSERChanged bynvarchar120
TOPSCM Basis
141CIF_MTCFGSDefault Values for Configuration Relevance for SAP APO10CHUSERChanged bynvarchar120
TOPTransaction Variant and Table Control Settings
142SHDGUIXTScreen variants <--> GuiXT scripts (attributes)5CHUSERUser Namenvarchar120
143SHDSVCIScreen variants7CHUSERUser Namenvarchar120
144SHDTVTransaction variants7CHUSERUser Namenvarchar120
145SHDTVCICross-client transaction variants6CHUSERUser Namenvarchar120
146SHDTVCIUTransaction variants independent6CHUSERUser Namenvarchar120
147SHDTVUTransaction Variants7CHUSERUser Namenvarchar120
TOPUpgrade - General
148CVERS_ACTActive Software Components in the System6CHUSERChanged bynvarchar120
149MERGENEGLNExclusion Objects Merger Central Maintenance Table15CHUSERUser Name in User Master Recordnvarchar120
TOPWeb Application Builder
150SW3M_ATTRMiniApp Attributes2CHUSERChanged bynvarchar120
TOPWorkbench Tools Editors, Painters, Modelers
151W3ATTRXMiniApp Attributes2CHUSERChanged bynvarchar120