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

93 columns | Print definition?ERP 6.0  | SCOPE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/AIF/CFUNC_DETFunction Information17SCOPEScopenvarchar10
2/AIF/CLINKCustom Data Link9SCOPEScopenvarchar10
3/AIF/CTEXTCustom Message Text9SCOPEScopenvarchar10
4/AIF/HINTSDB Table for saving the hints12SCOPEScopenvarchar10
5/CIDEON/AF_CONFTabelle mit Konfigurationseinträge2SCOPEDatenelement für Parameterscopenvarchar300
6/IAM/D_I_ROOTRoot node DB table66SCOPEImpactnvarchar30
7/SAPPSSRM/C_RFTRBORF Trace Data7SCOPEValidation Scopeint100
8AMC_CHANNELABAP Messaging Channel definition4SCOPEScope of an AMC channelnvarchar10
9AUAASettlement Document: Receiver Segment33SCOPEObject class (language-independent)nvarchar20
10CNVMBTNEADMINUsers and COT objects they want get notifications for4SCOPESLO COT Object GUIDnvarchar320
11CNVMBTNEREFReference Handling for Inheritance Between Scopes3SCOPESLO COT Object GUIDnvarchar320
12CNVMBTNEREGISTRYUsers and COT objects they want get notifications for5SCOPESLO COT Object GUIDnvarchar320
13CNVMBTNEUSERKnown Observer Instances3SCOPESLO COT Object GUIDnvarchar320
14DODP_MAP_SOURCEDBOSC-DP: Map Data Provider to Data Source8SCOPEDBOSC-CR: Namenvarchar300
15DOUI_MAP_RQSTDBOS Cockpit: Mapping Between UI and Request5SCOPEnvarchar40
16GRACFUNCFunction4SCOPEFunction Scopenvarchar10
17OA2C_TOKEN_SCOPEOAuth 2.0 Client Scopes5SCOPEOAuth 2.0 Client Scopentext10737418230
18OA2P_SCOPESOAuth 2.0 Client Scopes3SCOPEOAuth 2.0 Client Scopentext10737418230
19SRT_WSP_ASSERTSSOAP Runtime Framework: WS-Policy Assertions5SCOPEWSP attachment pointnvarchar100
20T77PAOSSPESSearch Category4SCOPEScope Namenvarchar320
21UCONRFCCUSTHEADUCON: configuration RFC server side3SCOPEVisibility of RFC Services (Scope "E" includes "S")nvarchar10
22UCONRFCSERVHEADUCON: RFC Service Header Table3SCOPEVisibility of RFC Services (Scope "E" includes "S")nvarchar10
23UCONRFCSRVMAINRTRuntime Table for relation among VH, RFC Service Name, Scope10SCOPEVisibility of RFC Services (Scope "E" includes "S")nvarchar10
TOPAccounting Interface
24GLE_FI_ITEM_MODFECS: Modified FI Line Items (Header/Item/Currency Data)228SCOPEObject Classnvarchar20
25GLE_FI_ITEM_ORIGECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F)228SCOPEObject Classnvarchar20
TOPActual CostingMaterial Ledger
26TMLCCSHDAct.Cost Comp. Split: Data Range in Valuation Area (General)3SCOPEStructure for Data Scopenvarchar40
27TMLCCSSCOPEActual Cost Component Split: Structure of Data Range2SCOPEStructure for Data Scopenvarchar40
28TMLCCSSCOPETXTActual Cost Component Split: Split for Data Range (Texts)3SCOPEStructure for Data Scopenvarchar40
TOPAppropriation Requests
29IMAKAppropriation requests - general data38SCOPEObject Classnvarchar20
TOPClaims Management
30ICL_PRIVILEGESpecial Rights (Benefit/3rd Party Rights) in Benefit Split22SCOPEScope of Third Party Rights in Benefit Splitnvarchar100
31ICS_PRIVILEGESpecial Rights (Shadow Table)22SCOPEScope of Third Party Rights in Benefit Splitnvarchar100
TOPCondition Technique
32/SAPCND/UE_TYPUser Exit Types4SCOPEScope of a user exitnvarchar10
TOPControlling
33IAOM_CSCENARIOControlling Scenario10SCOPEObject Classnvarchar20
TOPCost Element Accounting
34COFIO1Object Table for Reconciliation Ledger COFIT10SCOPEObject Classnvarchar20
35TBO02Language-dependent values for the object class2SCOPEObject class (language-independent)nvarchar20
TOPCost Object
36CKPHSControl for Cost Object Category24SCOPEObject class (language-independent)nvarchar20
TOPCross-Application Components
37/KYK/TA_TAGGING1Scope tagging and grouping of transactions in role menu4SCOPEScope of a transactionnvarchar10
38AAUUFKOrder master data68SCOPEObject Classnvarchar20
TOPData Staging
39RSMIGRATEPREXMMigration: Execution - result with messages3SCOPEMigration: (Executed) Stepnvarchar10
TOPDefault Risk and Limit System
40ATLPGLimit Product Group3SCOPEIndicator: Basic Commitmentnvarchar10
TOPECM ABAP Stack
41NWECMD_LOCKTable for persistent Lock objects3SCOPENW ECM: Length limited string for table queriesnvarchar2500
42NWECMD_LOCKSNW ECM: Locks7SCOPENW ECM: Enumeration Code from Storenvarchar10
TOPEnd User Technology
43RSRD_ER_DOCTYPEException Reporting Document Type4SCOPEException Reporting: Scope of the Documentnvarchar100
TOPFinancial Accounting
44ACCTITCompressed Data from FI/CO Document91SCOPEObject Classnvarchar20
TOPGeographical Information System
45GEOPRO_EXT_ATTRDAttribute Data with User Name4SCOPEScope to check Tooltip or attribute Personalizationnvarchar10
46GHO_EXT_PER_ATRPersonalization Data for External Attributes4SCOPEAttribute Manager Scopenvarchar10
47GHO_INT_PER_ATRInternal Attributes Personalization Table4SCOPEAttribute Manager Scopenvarchar10
TOPInvestment Programs
48TAI05CI Program Types6SCOPEObject Classnvarchar20
TOPMaintenance Orders
49/MRSS/D_SQM_KPFQualification Catalog: Person-Specific Filter5SCOPEApplication Area of Filternvarchar10
50/MRSS/D_SQM_KPOQualification Catalog: Organization-Specific Filter6SCOPEApplication Area of Filternvarchar10
TOPMaterials Management
51J_1GVL_MLMaterial Ledger115SCOPEObject class (language-independent)nvarchar20
TOPMetadata Repository
52RSOCLASSATTRBW Metadata Repository: Attributes for a Class7SCOPECharacter field, length 32nvarchar320
TOPNetWeaver Business Content
53BIZCRDOCObsolete4SCOPEBizc: Semantic Use of Documentsnvarchar120
54BIZCRDOCLBusiness Content: Document Link4SCOPEBizc: Semantic Use of Documentsnvarchar120
TOPOperative Structures
55PROJProject definition48SCOPEObject Classnvarchar20
56PRPSWBS (Work Breakdown Structure) Element Master Data69SCOPEObject Classnvarchar20
57TCJ41Default Values for Work Breakdown Structure46SCOPEObject Classnvarchar20
TOPOverhead Cost Controlling
58COEPCO Object: Line Items (by Period)58SCOPEObject Classnvarchar20
59COVP_DELTA_LOGLog of COVP Delta Queue for Error Analysis60SCOPEObject Classnvarchar20
TOPOverhead Cost Orders
60AUFKOrder master data68SCOPEObject Classnvarchar20
61T003OOrder Types22SCOPEObject Classnvarchar20
62TKP02Budget manager for orders6SCOPEObject Classnvarchar20
TOPPlant Maintenance
63EAMS_CVBATTRMANDAttribute Manager: User display fields4SCOPEAttribute Manager Scopenvarchar10
TOPPortfolio and Project Management
64INM_GEN_SETTINGSTable for General Settings for integration with RPM2SCOPEType of Settingnvarchar10
65RPM_SET_INDTable for settlement processing settings2SCOPEType of Settingnvarchar10
TOPPortfolio Management
66/RPM/DASH_ROLEDashboard Attributes Override Table7SCOPEDashboard Scopenvarchar20
67/RPM/DASH_SCOPEScope Defintion2SCOPEDashboard Scopenvarchar20
68/RPM/DB_SCOPEDashboard Scope3SCOPEDashboard Scopenvarchar20
69/RPM/DB_SCOPE_TDashboard Scope Text4SCOPEDashboard Scopenvarchar20
70/RPM/DSH_MET_ROLDashboard Metric Attributes7SCOPEDashboard Scopenvarchar20
71/RPM/DSH_PRS_ROLDashboard Customization Override Table7SCOPEDashboard Scopenvarchar20
72/RPM/DSH_SCOPE_TText of dashboard scope2SCOPEDashboard Scopenvarchar20
TOPProcess Monitoring Infrastructure
73SSPIADMDATASUP2Administration Table for PMI Data Supplier3SCOPEPMI: Range of Validity of a Service Attributetinyint30
74SSPIPSRSPI: Process Step Relations8SCOPESPI Area of Validity of a Relationship Rulevarbinary10
TOPProduct Lifecycle Management
75DIWPS_USER_SETUser Settings Table4SCOPEScope for Settingnvarchar200
TOPProduction Orders
76AFVCOperation within an order123SCOPEObject Classnvarchar20
TOPProfit Center Accounting
77GLPCOEC-PCA: Object Table for Account Assignment Elements11SCOPEObject Classnvarchar20
TOPProfitability Analysis
78CECOEPCO-PA Account Based Line Items60SCOPEObject Classnvarchar20
TOPProject Summarization
79PSERBInheritance data, Project System21SCOPEObject Classnvarchar20
TOPRecipe Development
80/PLMI/EXPL_CMPTYExplosion customizing: Assignment of component types2SCOPEExplosion Scope for Recipe Explosionnvarchar100
81/PLMI/EXPL_SCExplosion customizing: Explosion scope header data2SCOPEExplosion Scope for Recipe Explosionnvarchar100
82/PLMI/EXPL_SC_TExplosion customizing: Explosion scope description3SCOPEExplosion Scope for Recipe Explosionnvarchar100
TOPReport Selection for Product Costing
83TKKR0Hierarchy Summarization (Header)7SCOPEObject classnvarchar20
TOPResources
84DPR_DIST_VALMake Settings for Distribution2SCOPEType of Settingnvarchar10
TOPSimulation
85VSAFVC_CNVersion: Operation in order124SCOPEObject Classnvarchar20
86VSAUFK_CNVersion: Order master data69SCOPEObject Classnvarchar20
87VSPROJ_CNVersion: Project definition49SCOPEObject Classnvarchar20
88VSPRPS_CNVersion: WBS Element (Work Breakdwn Struc. Elem.) Mast. Data70SCOPEObject Classnvarchar20
TOPStatus Board
89/ISDFPS/LMSTBSETSettings for Application Status Board4SCOPEName in an Area of Validity (User or Roles, for Example)nvarchar300
TOPTaiwan
90T7TW0ZTText Table for ZIP code7SCOPEHouse Number Rangenvarchar400
TOPTemplates
91PROJSStandard project definition48SCOPEObject Classnvarchar20
92PRPSSStandard WBS Element (WBS element) - Master Data69SCOPEObject Classnvarchar20
TOPWeb Service and SOAP - ABAP
93TASK_VITA_RUNParameter Table for TW Runtime Environment4SCOPESingle-Character Indicatornvarchar10