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

109 columns | Print definition?ERP 6.0  | COMP

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/CFMFND/DOBJDESCCustomizingtabelle dyn. Objekte - Darstellungsmerkm. - Tab3COMPCAFM Foundation dynamische Objekte - Komponentenvarchar300
2/SAPPSSRM/FLPNIDCustomizing table for mapping between LPN and FPDS ID4COMPSmart Number Component in Alphanumeric Numbering Schemenvarchar200
3/SAPPSSRM/NMTPCMComponents of types of numbering strategies2COMPSmart Number Component in Alphanumeric Numbering Schemenvarchar200
4/SAPPSSRM/NMTPCTDescription of /SAPPSSRM/NMTPCM3COMPSmart Number Component in Alphanumeric Numbering Schemenvarchar200
5/SAPPSSRM/NMTPDFDefinition of composite number components (long number)4COMPSmart Number Component in Alphanumeric Numbering Schemenvarchar200
6/SAPPSSRM/NUMTYPType of Numbering Scheme for Long Procurement Numbering3COMPSmart Number Component in Alphanumeric Numbering Schemenvarchar200
7CTS_AIM_TRC_PTSHControl Table for Shadow Import During the Upgrade13COMPnvarchar10
8GRFNQRATINGTYPEQuestion Rating Types3COMPApplication Componentnvarchar20
9PA9500Personal-Stammsatz Infotyp 950024COMPVollzeitnvarchar10
10PUTTB_SHD_1Steuertabelle für den Schattenimport während des Upgrades12COMPSoftware-Komponentenvarchar10
11TFAA_PC_P_STEPAssignment of Processes -> Process Steps2COMPApplication Componentnvarchar40
12TFAA_PC_STEPProcess Steps (Entity Table)2COMPApplication Componentnvarchar40
13TFAA_PC_STEPTProcess Steps (Text Table)3COMPApplication Componentnvarchar40
14TKEGCCO-PA: System table for management of generated coding (old)1COMPComponent in CO-PAnvarchar40
TOPABAP Test Frameworks ATC, CheckMan, Code Inspector
15CRMCHKOBJAObject Attributes5COMPnvarchar200
TOPAccrual Engine
16ACEDSASSGMTStandard Account Assignments for Accrual Objects2COMPAccrual Engine Application Componentnvarchar40
17ACEDSOHAccrual Subobject Header Data2COMPAccrual Engine Application Componentnvarchar40
18ACEDSOIItem Data for Accrual Subobject2COMPAccrual Engine Application Componentnvarchar40
19ACEDSOI_ACCOUNTSAccounts for Accrual Postings per Accrual Item2COMPAccrual Engine Application Componentnvarchar40
20ACEDSOPAccrual Subobject Parameters2COMPAccrual Engine Application Componentnvarchar40
21ACEOBJAccrual Objects2COMPAccrual Engine Application Componentnvarchar40
22ACEPSOHAccrual Subobject: Header Data in Posting Component2COMPAccrual Engine Application Componentnvarchar40
23ACEPSOIAccrual Item: Values in Posting Component2COMPAccrual Engine Application Componentnvarchar40
24ACEPSOITLine Items for Accrual Item in Accrual Engine2COMPAccrual Engine Application Componentnvarchar40
25ACEPSPPLOGLogical Periodic Accrual Run2COMPAccrual Engine Application Componentnvarchar40
26ACEPSPPSELSelect Options Periodic Posting Run2COMPAccrual Engine Application Componentnvarchar40
27TACE001Company Code Settings2COMPAccrual Engine Application Componentnvarchar40
28TACE001TTexts for Company Codes in the Accrual Engine3COMPAccrual Engine Application Componentnvarchar40
29TACECOMPAccrual Engine Application Component2COMPAccrual Engine Application Componentnvarchar40
30TACECOMPCCustomer Settings for Components2COMPAccrual Engine Application Componentnvarchar40
31TACECOMPTApplication Components of Accrual Function3COMPAccrual Engine Application Componentnvarchar40
32TACEDS_LEGACYMLegacy Data Transfer Control2COMPAccrual Engine Application Componentnvarchar40
33TACEDS_OP_PERCPercentages for Derived Accrual Types (Operator "P")2COMPAccrual Engine Application Componentnvarchar40
34TACEPSRULEACE Account Determination: Account Determination Rule2COMPAccrual Engine Application Componentnvarchar40
35TACEPSRULETACE Account Determination: Account Determination Rule2COMPAccrual Engine Application Componentnvarchar40
36TACEPSSYMACE Account Determination: Account Symbol2COMPAccrual Engine Application Componentnvarchar40
37TACEPSSYMTACE Account Determination: Account Symbol2COMPAccrual Engine Application Componentnvarchar40
38TACESYSTEVENTSEvents in the Accrual Engine3COMPAccrual Engine Application Componentnvarchar40
39TACE_ACCMETHODSMethods for Calculation of Periodic Accrual Amount2COMPAccrual Engine Application Componentnvarchar40
40TACE_ACCMETHODSTTexts of Accrual Methods2COMPAccrual Engine Application Componentnvarchar40
41TACE_ACRTYPEAccrual Types2COMPAccrual Engine Application Componentnvarchar40
42TACE_ACRTYPETText for Accrual Types3COMPAccrual Engine Application Componentnvarchar40
43TACE_ACRTYPE_OPNCalculation Rules for Derived Accrual Types2COMPAccrual Engine Application Componentnvarchar40
44TACE_COMBINATIONPossible Combinations in the Accrual Engine2COMPAccrual Engine Application Componentnvarchar40
45TACE_COMP_SPECComponent-Specific Program Components2COMPAccrual Engine Application Componentnvarchar40
46TACE_DE_MAPPINGApplication-Dependent Data Elements for Accrual Engine2COMPAccrual Engine Application Componentnvarchar40
47TACE_DS_CALCDistribution Server: Accrual Type Settings2COMPAccrual Engine Application Componentnvarchar40
48TACE_PS_POSTPosting Server: Posting Control2COMPAccrual Engine Application Componentnvarchar40
49TACE_TREEORDERTable for the Sequence in the Tree Structure2COMPAccrual Engine Application Componentnvarchar40
50TACE_TREEVARITable for Tree Structure Variants2COMPAccrual Engine Application Componentnvarchar40
51TACE_TREEVARITText Table of Tree Structure Variants2COMPAccrual Engine Application Componentnvarchar40
52TACE_TRNSFERTYPESelection Methods for Data Transfer to the Accrual Engine2COMPAccrual Engine Application Componentnvarchar40
53TACE_TRNSFERTYPTTexts for Selection Methods2COMPAccrual Engine Application Componentnvarchar40
TOPASAP AcceleratedSAP
54SPERSSORTPersonalization Table for ALV Tree Sort Order Tables8COMPSingle-Character Indicatornvarchar10
TOPBasic Functions
55FILCOFI-LC: Acct assign.fields (Object-TrPartner) for table FILCT7COMPCompanynvarchar60
56GGREFOExample for Global Object Table 1 (Object/Partner)7COMPCompanynvarchar60
57GLOO2Object Table for GLT02: Global2COMPCompanynvarchar60
58TFAA_PC_PProcesses2COMPApplication Componentnvarchar40
59TFAA_PC_PSAssignment Process -> Subprocess2COMPApplication Componentnvarchar40
60TFAA_PC_PTProcess Names3COMPApplication Componentnvarchar40
61TFAA_PC_SSubprocesses2COMPApplication Componentnvarchar40
62TFAA_PC_SMAssignment of Subprocess to Processing Methods/Modules2COMPApplication Componentnvarchar40
63TFAA_PC_STSubprocess Names3COMPApplication Componentnvarchar40
TOPBusiness Object Builder
64BMA_CONSBOR Migration: Usage of BOR Constants in Programs12COMPApplication component IDnvarchar240
TOPClinical System
65TN2CLIM_COMPCLIM: Entry Elements for Specific Measurements2COMPCLIM: ID of Entry Elementnvarchar100
66TN2CLIM_COMPMSCLIM: Measurement in Input Element2COMPCLIM: ID of Entry Elementnvarchar100
67TN2CLIM_COMPMSTCLIM: Measurement in Input Element2COMPCLIM: ID of Entry Elementnvarchar100
68TN2CLIM_COMPTCLIM: Entry Elements for Specific Measurements - Texts2COMPCLIM: ID of Entry Elementnvarchar100
69TN2CLIM_COMP_OUCLIM: Measurement - Entry Element Assignment for OU8COMPCLIM: ID of Entry Elementnvarchar100
TOPConsolidation
70ECMCOSAP Cons.: Object Table Assignment Fields (Object/Partner)7COMPCompanynvarchar60
TOPCost Object
71FCO_DOC_POSFailure Cost Document Item4COMPMaterial Numbernvarchar180
TOPCRM Accruals
72CRM_ACE_CU_ACRTYCRM Accruals: Assignment of Accruals Type to Transact. Type2COMPAccrual Engine Application Componentnvarchar40
73CRM_ACE_CU_CONDCustomizing for CRM Accruals: Relevant Revenue Elements2COMPAccrual Engine Application Componentnvarchar40
74CRM_ACE_CU_COPACRM Accruals: Assgmt of Accruals Type to Cond.Type for CO-PA2COMPAccrual Engine Application Componentnvarchar40
75CRM_ACE_CU_METHCRM Accruals Customizing: Find Accrual Method2COMPAccrual Engine Application Componentnvarchar40
76CRM_ACE_OH_DATACRM Accruals: Object Header3COMPAccrual Engine Application Componentnvarchar40
77IPM_ACE_CU_BVALCustomizing Settings for Data Values for Rights Usage Conf.2COMPAccrual Engine Application Componentnvarchar40
78IPM_ACE_CU_VALTYCustomizing Data Values Relevant to Accrual Types2COMPAccrual Engine Application Componentnvarchar40
TOPCross-System Tools
79MCOBJECTSMultiple Client Analysis: Object List12COMPApplication component IDnvarchar240
TOPCustomer Interaction Center
80CCMCSCONFContact search/display configuration4COMPIS-M: Componentnvarchar30
TOPEnvironment, Health and Safety
81EHQMT_MAIN1EH&S-QM: Subs. Value Assignmt Types for Insp. Plan Creation21COMPEH&S-QM: Compositionnvarchar10
TOPFinancial Accounting
82FBICRC001OICRC: Open Items GL Accounts: Object table 17COMPCompanynvarchar60
83FBICRC002OICRC: GL Accounts: Object table 17COMPCompanynvarchar60
84FBICRC003OICRC: Open Items Customers/Vendors: Object table 17COMPCompanynvarchar60
85TICRC_CNUMICRC: Company IDs in External Systems3COMPCompanynvarchar60
TOPGeneric Interaction Layer
86CRMC_SO_RELSRelation Table for Simple Objects4COMPComponent Namenvarchar60
TOPLease Accounting
87FIOTPOHOne-Time Postings: Header2COMPAccrual Engine Application Componentnvarchar40
88FIOTPOIOne-Time Postings: Items2COMPAccrual Engine Application Componentnvarchar40
89TFILAFM_IRCMAssignment of Acct Prin. to Interest Rate Calc. Methods2COMPAccrual Engine Application Componentnvarchar40
90TFILA_COMPONENTApplication Components of Accounting Engine2COMPApplication Componentnvarchar40
91TFILA_GF_021Controls Number of Processes2COMPApplication Componentnvarchar40
92TFIOTP_001Document Group Characteristic2COMPApplication Componentnvarchar40
93TFIOTP_001TDocument Group Characteristic Name3COMPApplication Componentnvarchar40
94TFIOTP_002Account Determination Rule2COMPApplication Componentnvarchar40
95TFIOTP_002TDocument Group Characteristic Name3COMPApplication Componentnvarchar40
96TFIOTP_003Posting Key for Document Grouping Characteristic2COMPApplication Componentnvarchar40
TOPMessages
97DNOD_NOTIF_SNotification: SAP Support Data8COMPSAP componentnvarchar200
TOPProcess Controls
98GRPCQCATEGORYQuestion Categories3COMPApplication Componentnvarchar20
TOPProduct Configurator
99COMM_CFGCUSDCustomizing Screen Designer Groups7COMPFlagnvarchar10
TOPProject System
100SAVESORT_PS_LOGto save the sort for ps_log10COMPSingle-Character Indicatornvarchar10
TOPRegulatory reporting for insurance companies
101TISSR_TP_ALVSORTISSR: Einstellung ALV-Grid Sortierkriterien11COMPEinstelliges Kennzeichennvarchar10
TOPResourcen Management
102FRMLC_T006RMSFRM: Assignment of Units of Measure to Views21COMPPermitted for Composition Ingredientsnvarchar10
103FRMLC_T007RMSFRM: Assignment of Units of Measure to Views5COMPPermitted for Composition Ingredientsnvarchar10
TOPSales and Distribution
104SCECUSDInterface Design - Grouping Structure6COMPBoolean (T = true, F = false, blank = unknown)nvarchar10
TOPTax Reporting
105OIUX3_RPT_COMPXTax Reporting - Reporting Company XRef4COMPCompany Codenvarchar40
TOPUpgrade - General
106PUTTB_SHDControl Table for Shadow Import During the Upgrade12COMPSoftware Componentnvarchar10
107PUTTB_SHD_SAVSteuertabelle für den Schattenimport während des Upgrades12COMPSoftware-Komponentenvarchar10
108PUTTB_SHD_SHDSteuertabelle für den Schattenimport während des Upgrades12COMPSoftware-Komponentenvarchar10
109PUTTB_SHD_STDSteuertabelle für den Schattenimport während des Upgrades12COMPSoftware-Komponentenvarchar10