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

38 columns | Print definition?ERP 6.0  | VAR_NAME

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1BBPD_BWREP_DETBW Reports: Detailed Data4VAR_NAMEName of BW Report Variablenvarchar80
2FUCNC_WRL_PARAMCustomizing for Workcenter Report - Variable Configuration2VAR_NAMEVariable Name for the Reportnvarchar500
3PYC_D_BPC_RPTBatch Processing Component Reports11VAR_NAMEABAP: Name of variant (without program name)nvarchar140
4ZSYSTEM_VARIStandard Variables1VAR_NAMEVariable for objectnvarchar300
5ZSYSTEM_VARI_Tstandard variable objects: Texts1VAR_NAMEVariable for objectnvarchar300
TOPABAP Authorization and Role Management
6SSM_RFCVariables for RFC Destinations in the Workplace1VAR_NAMETable row namenvarchar200
7SSM_VARVariable Definitions for URLs1VAR_NAMETable row namenvarchar200
8SSM_VARTText and Variable definations for URL1VAR_NAMETable row namenvarchar200
TOPBusiness Analytics
9UABATIMPORTVARVariants for Batch Import, PDCE, EhP42VAR_NAMEVariant for Batch Import, EhP4nvarchar200
10UABATIMPVARSELSelection Condits in Variants for Batch Import, PDCE, EhP42VAR_NAMEVariant for Batch Import, EhP4nvarchar200
11UABATIMPVARTText Table for Variants of Batch Import, PDCE, EhP43VAR_NAMEVariant for Batch Import, EhP4nvarchar200
12UABSCEBATIMPTable to store SCE variants, PDCE, Ehp42VAR_NAMEVariant for Batch Import, EhP4nvarchar200
13UABXMLBATIMPtable for XML, batch import, PDCE, Ehp42VAR_NAMEVariant for Batch Import, EhP4nvarchar200
TOPBusiness Package for Manager Self-Service FI
14FPB_EXP_VARVALExpress Planning: Value Assignment to Variables (SAP & Ext.)4VAR_NAMETechnical Name of the Variablesnvarchar300
15FPB_EXP_VAR_EXTExpress Planning: Customer-Specific Variables3VAR_NAMETechnical Name of the Variablesnvarchar300
16FPB_EXP_VAR_EXTTExpress Planning: Customer-Specific Variables Texts3VAR_NAMETechnical Name of the Variablesnvarchar300
17FPB_EXP_VAR_SAPExpress Planning: SAP Standard Variables2VAR_NAMETechnical Name of the Variablesnvarchar300
18FPB_EXP_VAR_SAPTExpress Planning: SAP Standard Variables2VAR_NAMETechnical Name of the Variablesnvarchar300
TOPChecksums
19CSUM_CV_FLDSCheck Sum Variant - Fields2VAR_NAMEName of Check Variantnvarchar240
20CSUM_CV_HEADCheck Sum Variant - Header Data2VAR_NAMEName of Check Variantnvarchar240
21CSUM_CV_TEXTCheck Sum Variant - Field Description3VAR_NAMEName of Check Variantnvarchar240
22CSUM_EV_HEADExecuted Analyses - Header Data3VAR_NAMEName of Check Variantnvarchar240
TOPCorrespondence Tool
23TIFP_ADFORM_PARParameters for Data Import3VAR_NAMEVariable Namenvarchar300
TOPEnvironment, Health and Safety
24/TDAG/EHXC_DBVARVariables for the Xcelsius dashboards4VAR_NAMEName of Xcelsius Flash Variablenvarchar200
TOPMaster Data
25GMGRREPORTGrant report tracking5VAR_NAMEVariant Namenvarchar140
TOPOffice Suite Program
26/OSP/T_CON_VARTable to store context variables2VAR_NAMEContext Variable Namenvarchar300
27/OSP/T_CON_VAR_TContext Variables - Text Table2VAR_NAMEContext Variable Namenvarchar300
28/OSP/T_CTXT_MAPTable to map the context variables to context groups4VAR_NAMEContext Variable Namenvarchar300
29/OSP/T_RAUI_CMVLOSP Chart Report Parameter Multiple Values Table11VAR_NAMEContext Variable Namenvarchar300
30/OSP/T_RAUI_CPVLOSP Chart Report Parameterization Value Table27VAR_NAMEContext Variable Namenvarchar300
31/OSP/T_RAUI_MVLOSP Report Parameterization Table11VAR_NAMEContext Variable Namenvarchar300
32/OSP/T_RAUI_PBHOSP Report Parameterization Table30VAR_NAMEContext Variable Namenvarchar300
33/OSP/T_RAUI_TMVLOSP : Triggered Report Parameter Multiple Value11VAR_NAMEContext Variable Namenvarchar300
34/OSP/T_RAUI_TPBHOSP Triggered Report Parameterization Table32VAR_NAMEContext Variable Namenvarchar300
35/OSP/T_REP_CXTPReport personalization of parameters with context variables5VAR_NAMEContext Variable Namenvarchar300
36/OSP/T_VAR_MAPTable to map the context variables to context groups5VAR_NAMEContext Variable Namenvarchar300
TOPSyntax, Compiler, Runtime
37AAB_VAR_IDAssignment of Variants to Activation IDs1VAR_NAMEActivation Variant (Act. Assertions and Breakpoints)nvarchar300
TOPWorkbench Tools Editors, Painters, Modelers
38COVMVSETTable for Storing Settings for Global View6VAR_NAMEVariant Name for Settings in the Global Viewnvarchar150