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

81 columns | Print definition?ERP 6.0  | EXCLUDE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/OTX/RM_WSC_FCESOpen Text dynamically context exclude and / or spare funct.6EXCLUDEOpen Text Exclude fcodesnvarchar10
2BBPC_CMS_ATTRSTRStructure type for Attributes5EXCLUDECMS indicator that Attr is relevant for Category Itemnvarchar10
3CNVCMIS_A_20_DICTable fields for Cross-Client Customizing Comparison21EXCLUDEExclude Field Flag for Cross-Client Customizing Comparisonnvarchar10
4CNVINCLTABConversion: Includes for certain tables6EXCLUDEConversion: Exclusion indicatornvarchar10
5CNVLTHCM_HRDOMOBSOLETE! DO NOT USE!!!4EXCLUDEConversion: Exclusion indicatornvarchar10
6CNVLTHCM_HRDOM2LT HCM: Domains of HCM Tables5EXCLUDEConversion: Exclusion indicatornvarchar10
7CNVLTHCM_HRPCKOBSOLETE! DO NOT USE!!!3EXCLUDEConversion: Exclusion indicatornvarchar10
8CNVLTHCM_HRPCK2LT HCM: HCM Development Packages4EXCLUDEFlag Obsolete; Do Not Fillnvarchar10
9CNVLTHCM_I_HRDOMOBSOLETE! DO NOT USE!!!3EXCLUDEConversion: Exclusion indicatornvarchar10
10CNVMBTDOMSdomains / data elements with corresponding conv. rules7EXCLUDEMBT PCL : Exclude Flagnvarchar10
11CNVMBTINCLMBT PCL: Includes to be integrated in Conversion Objects6EXCLUDEMBT PCL : Exclude Flagnvarchar10
12CNVTDMSSCR_DOMSList of Domains Assigned to a Rule8EXCLUDEConversion: Exclusion indicatornvarchar10
13CNVTDMS_06_EXCLUExcluding Table for TDMS Cross-Application6EXCLUDEExclude Indicator for TDMS_06nvarchar10
14CNV_00001_FDOMSOBSOLETE: Use CNVDOMS9EXCLUDEConversion: Exclusion indicatornvarchar10
15CNV_00001_PDOMSDomains suitable for conversion routine parameters10EXCLUDEConversion: Exclusion indicatornvarchar10
16CNV_00300_MAPSPCCWB-ME Interface - Template ID - Profile Class - Check Class6EXCLUDEFlag (X = yes, initial = no)nvarchar10
17CNV_02300_NOTESContains the list of SAP Notes required before migration10EXCLUDEGeneral Flagnvarchar10
18CNV_10020_DTOBJPAssignment of determination objects to domains/data elemen7EXCLUDEIndicator for 'exclude'nvarchar10
19CNV_10210_DOMSNumber conversion engine: relevant subobject domains5EXCLUDEExclude from conversionnvarchar10
20CNV_10940_FCONSTFinal consistency check status12EXCLUDEExcluded inconsistent variantsnvarchar10
21CNV_10940_PARAStoring parameters and select options11EXCLUDEUsed for Flagnvarchar10
22CNV_10940_REPTable for Reports10EXCLUDEUsed for Flagnvarchar10
23CNV_10940_REPVARReports relevant for analyse variants9EXCLUDEExcluded inconsistent variantsnvarchar10
24CNV_10940_VARDETStoring values of variants12EXCLUDEUsed for Flagnvarchar10
25CNV_10992_STXHSchedule existing TDOBJECT in STXH for optimization5EXCLUDEConversion: Exclusion indicatornvarchar10
26CNV_10994_BDCPSchedule existing object classes in BDCP for optimization4EXCLUDEConversion: Exclusion indicatornvarchar10
27CNV_10994_CDHDRSchedule existing object classes in CDHDR for optimization5EXCLUDEConversion: Exclusion indicatornvarchar10
28CNV_10994_PCDHDRSchedule existing object classes in PCHDR for optimization5EXCLUDEConversion: Exclusion indicatornvarchar10
29CNV_20100_IC_CSTConstellat. for source accnt due to (I)tem (C)ategory map.12EXCLUDEMBT PCL : Exclude Flagnvarchar10
30CNV_20100_SCENElementary scenarios for chart of accounts conversion16EXCLUDEMBT PCL : Exclude Flagnvarchar10
31CNV_20100_TABCHKTable fields to be analyzed8EXCLUDESingle-Character Indicatornvarchar10
32CNV_20200_TABCHKtable field analysis6EXCLUDEData element for domain BOOLE: TRUE (='X') and FALSE (=' ')nvarchar10
33CNV_20551_CDCLSObject classes for exact deletion of change documents6EXCLUDEConversion: Exclusion indicatornvarchar10
34CNV_20551_NOCONSModification of search for deletion criteria5EXCLUDEExcludenvarchar10
35CNV_20700_TCMF5HAnalyze table TCMF5 for package 2070010EXCLUDEExclusion from conversion indicationnvarchar10
36CNV_ADT_MENUTransformation Summary: Menu tree13EXCLUDEExclude flagnvarchar10
37CNV_INDX_IEINCLSIncludes for versions of RELID import/export routines7EXCLUDEConversion: Exclusion indicatornvarchar10
38CNV_INDX_INCLINDX conversion: Includes for INDX RELID conversion7EXCLUDEConversion: Exclusion indicatornvarchar10
39CNV_MBT_UT_CASESUnit test cases5EXCLUDEExclusion from conversion indicationnvarchar10
40CNV_NCE_DOC_MAPNCE: Mapping data for individual doc numbers20EXCLUDEExclude from conversionnvarchar10
41CNV_NCE_DOC_SIMNCE: Mapping data for individual doc numbers20EXCLUDEExclude from conversionnvarchar10
42CNV_NCE_KB_LOCALNumber conversion engine: Local Knowledge Base34EXCLUDEExclude from conversionnvarchar10
43J_1UF_TP_BSEGCORItems of Corrective documents40EXCLUDEGeneral Flagnvarchar10
44J_1UF_TP_BSEGORIItems of Original documents40EXCLUDEGeneral Flagnvarchar10
45J_3RF_TP_BSEGCORItems of Corrective documents38EXCLUDEGeneral Flagnvarchar10
46J_3RF_TP_BSEGORIItems of Original documents38EXCLUDEGeneral Flagnvarchar10
TOPABAP Authorization and Role Management
47AGR_TCODE3Assignment of roles to Tcodes5EXCLUDEExclusivenvarchar10
48AGR_TCODESAssignment of roles to Tcodes5EXCLUDEExclusivenvarchar10
49AGR_USERSAssignment of roles to users6EXCLUDEExclusivenvarchar10
50AGR_USERTAssignment of roles to users6EXCLUDEExclusivenvarchar10
TOPBasic Functions
51T035ZLiquidity Forecast: Payment Date Determinations/Assignments4EXCLUDEExclude from assignment to payment datesnvarchar10
52T038Cash Management: Grouping Structure7EXCLUDEExcludenvarchar10
TOPBusiness Application Support
53CNVDOMSCNV: Domains required by conversion package6EXCLUDEConversion: Exclusion indicatornvarchar10
54CNVDOMSCCNV: from conv. pack. domains with conflicts in blending7EXCLUDEConversion: Exclusion indicatornvarchar10
TOPBusiness Navigator
55DF33SCustomizing assignment to modeling16EXCLUDESelectednvarchar10
TOPContract Accounts Receivable and Payable
56DFKKORDERDUERequests: Due Dates9EXCLUDEDue Date is Excludednvarchar10
TOPCustom Development Management Cockpit
57CNVCDMCCA_OBJSCDMC : Customer Objects and SAP Mods for Clearing Analysis40EXCLUDECDMC: Indicator for Exclusionnvarchar10
58CNVCDMCCA_SRCCDMC: Customer Objects and SAP Mods for Syntax Check16EXCLUDECDMC: Indicator for Exclusionnvarchar10
59CNVCDMCUCIA_PLCDMC : UCIA - SAP Objects impacted in an Upgrade or Patch10EXCLUDECDMC: Indicator for Exclusionnvarchar10
TOPDocument Builder
60/IPRO/TATTRSTRStructure Type for Attributes Used in Duet7EXCLUDEExcludenvarchar10
TOPEasy Enhancement Workbench
61AXT_REG_BO_UIExtensible UI elements8EXCLUDEGeneral Flagnvarchar10
TOPForms
62TMETANETSTARI_02HR Forms: MetaStars in MetaNets (International)3EXCLUDEHR Forms: Do Not Include Object in Country Versionnvarchar10
63TMETANETSTAR_03HR Forms: Assignment of MetaStars to MetaNets4EXCLUDEHR Forms: Do Not Include Object in Country Versionnvarchar10
64TMETASTARDIM_03HR Forms: Assignment of Dimensions to MetaStars4EXCLUDEHR Forms: Do Not Include Object in Country Versionnvarchar10
TOPImplementation Guide
65EXCEPT1IMG Activity-Specific BC Set Error Exception Table10EXCLUDECharacter Field Length 1nvarchar10
66EXCEPT2Object-Specific BC Set Error Case Exception Table7EXCLUDECharacter Field Length 1nvarchar10
TOPIntegration Customer Relationship Management
67EVER_PC_CONTRTable of Contracts for Mass Rate Change4EXCLUDEExclusion Indicatornvarchar10
TOPInteraction Center WebClient
68CRMC_IC_KSPROFDSecurity Profile of Knowledge Base for Knowledge Search6EXCLUDEExcludenvarchar10
TOPLanguage Transport
69TLANSUPTALanguage Transport: Tables to Be Supplemented3EXCLUDEBoolean Variable (X=True, -=False, Space=Unknown)nvarchar10
TOPOLAP Technology
70RSDDSTATDU_IOQuery Filter Statistics: Monitored InfoObjects3EXCLUDEBooleannvarchar10
TOPProduct Data Replication
71CIBASE2UPSCustomizing: Transport IBASE fields into UPS fields12EXCLUDEExclude Object Type in Distributionnvarchar10
72CRWB_BADICHG2UPSCustomizing: Transport IBASE fields into UPS fields5EXCLUDEExclude Object Type in Distributionnvarchar10
TOPSuite Inbox
73IBO_C_WF_TTAEList of Allowed Actions per Task7EXCLUDEExcludenvarchar10
TOPTaxes
74TTXXtable to determine which tax law is used9EXCLUDEExclude from tax lawnvarchar10
TOPTraders and Schedulers Workbench
75OIJ_EL_CP_LOCCharter party contract: load and discharge locations8EXCLUDEExclude locationnvarchar10
76OIJ_EL_CP_PRODCharter contracts: products and product groups8EXCLUDEExclude productnvarchar10
TOPTransaction Manager
77TRGC_PC_EXCLProduct Cats of the Parallel Valn Areas to be Excluded6EXCLUDEExclude Product Group/Category/Type in Parallel Val. Areasnvarchar10
78TRGC_PG_EXCLProduct Groups to be Excluded in the Parallel Val. Areas5EXCLUDEExclude Product Group/Category/Type in Parallel Val. Areasnvarchar10
79TRGC_PT_EXCLProduct Types to be Excluded in the Parallel Val. Areas7EXCLUDEExclude Product Group/Category/Type in Parallel Val. Areasnvarchar10
TOPWorkforce Management Core
80/SAPAPO/LRPSUBIDTable for Subscription of Concrete Subjects9EXCLUDEExclusion of WFM Objects from Subscriptionsnvarchar10
81/SAPAPO/LRPSUBTYTable for Subscription of Generic Subjects8EXCLUDEExclusion of WFM Objects from Subscriptionsnvarchar10