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

51 columns | Print definition?ERP 6.0  | AENAME

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1CNV_10940_FCONSTFinal consistency check status8AENAMEUser Namenvarchar120
2CNV_10940_VARHStoring all variants for relevant reports9AENAMEUser Namenvarchar120
3CNV_20201_NRIV_NTarget number ranges12AENAMEnvarchar120
4CNV_20201_NRIV_OSource number ranges12AENAMEnvarchar120
5CNV_20201_REFSubobjects - reference indicator6AENAMEnvarchar120
TOPABAP List-Based PI Sheet
6COTRPPI Sheet: Process Parameter Texts (Versions)8AENAMEName of the person who changed the process instruction textnvarchar120
TOPAdvertising Management
7JJTGENTRIS-M/AM: Generation Status7AENAMEName of Person Who Changed Objectnvarchar120
TOPBusiness Package for Manager Self-Service FI
8FPB_EXP_CA_ASSMExpress Planning: Assignments Context Elem. / Roadmap Elem.11AENAMEExpress Planning: Last Changed Bynvarchar120
9FPB_EXP_CA_ITMExpress Planning: Elements of the Context Area (Obsolete)10AENAMEExpress Planning: Last Changed Bynvarchar120
10FPB_EXP_CA_ITM1Express Planning: Elements of the Context Area11AENAMEExpress Planning: Last Changed Bynvarchar120
11FPB_EXP_GRP_STPExpress Planning: Assignment of Substeps to Steps9AENAMEExpress Planning: Last Changed Bynvarchar120
12FPB_EXP_HIERExpress Planning: Object Hierarchies for Planning Instances9AENAMEExpress Planning: Last Changed Bynvarchar120
13FPB_EXP_INSTExpress Planning: Instances10AENAMEExpress Planning: Last Changed Bynvarchar120
14FPB_EXP_INSTRUCTExpress Planning: Instruction Texts9AENAMEExpress Planning: Last Changed Bynvarchar120
15FPB_EXP_INSTTExpress Planning: Instance Texts10AENAMEExpress Planning: Last Changed Bynvarchar120
16FPB_EXP_INS_MAILExpress Planning: Standard E-Mails11AENAMEExpress Planning: Last Changed Bynvarchar120
17FPB_EXP_ROLEExpress Planning: User Roles for Planning Rounds11AENAMEExpress Planning: Last Changed Bynvarchar120
18FPB_EXP_SCENExpress Planning: Scenarios7AENAMEExpress Planning: Last Changed Bynvarchar120
19FPB_EXP_SCENTExpress Planning: Scenario Texts9AENAMEExpress Planning: Last Changed Bynvarchar120
20FPB_EXP_SCEN_GRPExpress Planning: Assignment of Steps to Scenarios9AENAMEExpress Planning: Last Changed Bynvarchar120
21FPB_EXP_SECTExpress Planning: Context Area Sections9AENAMEExpress Planning: Last Changed Bynvarchar120
22FPB_EXP_SECTTText Table for FPB_EXP_SECT9AENAMEExpress Planning: Last Changed Bynvarchar120
23FPB_EXP_STPExpress Planning: Planning Substeps10AENAMEExpress Planning: Last Changed Bynvarchar120
24FPB_EXP_STPGRPExpress Planning: Steps8AENAMEExpress Planning: Last Changed Bynvarchar120
25FPB_EXP_STPGRPTExpress Planning: Groups or Planning Steps (Texts)8AENAMEExpress Planning: Last Changed Bynvarchar120
26FPB_EXP_STPTExpress Planning: Texts for Substeps8AENAMEExpress Planning: Last Changed Bynvarchar120
27FPB_EXP_UINSTExpress Planning: User Instance14AENAMEExpress Planning: Last Changed Bynvarchar120
28FPB_EXP_USCENExpress Planning: Application Scenario per iView and User8AENAMEExpress Planning: Last Changed Bynvarchar120
29FPB_EXP_VARVALExpress Planning: Value Assignment to Variables (SAP & Ext.)9AENAMEExpress Planning: Last Changed Bynvarchar120
30FPB_EXP_VAR_EXTExpress Planning: Customer-Specific Variables8AENAMEExpress Planning: Last Changed Bynvarchar120
31FPB_EXP_VAR_EXTTExpress Planning: Customer-Specific Variables Texts9AENAMEExpress Planning: Last Changed Bynvarchar120
TOPCross-Application Mass Maintenance
32MASSAENAMEDefined Application Exits1AENAMEChar 20nvarchar200
33MASSAPPEXApplication Exits for an Object2AENAMEChar 20nvarchar200
TOPData Collection
34TKCMPVEC-BP: Parameterization for Automatic Planning Runs4AENAMEUser Namenvarchar120
TOPEmpties Management
35/BEV1/EMLGOFSEmpties - Billing Document Without Update13AENAMELast changed bynvarchar120
TOPInterface to Terminal Automation System
36OIK01IS-OIL/TAS: LID Document Data23AENAMELast changed bynvarchar120
37OIK01DIS-OIL/TAS: deactivated LID Document Data24AENAMELast changed bynvarchar120
38OIKLIDRTD - TAS Reference Table58AENAMELast changed bynvarchar120
TOPLogical DB, Selection Screens, Selection Variants
39VARIDVariant directory14AENAMEUser Namenvarchar120
40VARID_CIVariant Catalog, Cross-Client12AENAMEUser Namenvarchar120
TOPMaintenance Processing
41/ISDFPS/MNTF_HDDFPS: Mass Maintenance6AENAMEName of Person Who Changed Objectnvarchar120
TOPPeriodical Sales and Distribution
42JDTGENTRIS-M/SD: Generation Trigger7AENAMEName of Person Who Changed Objectnvarchar120
TOPProfitability Analysis
43COVADVariant catalog10AENAMEUser Namenvarchar120
TOPRemaining Beverage - Obsolete Objects
44/BEV1/RSQUSEQuick Settlement23AENAMELast changed bynvarchar120
TOPRevenues and Earnings
45VPKHEADSales Pricing Header Data15AENAMEUser Namenvarchar120
TOPSAP List Viewer
46LTDXGeneric storage of display variants16AENAMEName of the last user to change the display variantnvarchar120
47SALV_EX_STORAGEALV Data Repository for External Access15AENAMEName of the last user to change the display variantnvarchar120
TOPTreasury
48FLQHEADMALiquidity Calculation - Header for Manual Transfer Postings14AENAMEUser Namenvarchar120
49FLQQRLiquidity Calculation - Queries7AENAMEUser Namenvarchar120
TOPWeb Dynpro ALV for ABAP
50SALV_BS_ADMINTable for Creating Control Values for ALV16AENAMEName of the last user to change the display variantnvarchar120
TOPXBRL Reporting
51UGXV00CVariant - Check Table6AENAMEUser Namenvarchar120