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

63 columns | Print definition?ERP 6.0  | OPTIONAL

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1BTP_DL_LSCPMAPTable for Landscape System mapping4OPTIONALBTP Landscape System Type optionalnvarchar10
2BTP_DL_LSCPSYSBTP System Landscape Systems3OPTIONALBTP Landscape System Type optionalnvarchar10
3BTP_DL_LSSYTYPESBTP System Types assigned to a System Landscape Template3OPTIONALBTP Landscape System Type optionalnvarchar10
4BTP_DL_LSSYTYRFCBTP RFC-Connections in a System Landscape Template5OPTIONALBTP Landscape RFC connection optionalnvarchar10
5CNVCMIS_A_1_FUNPFucp type Repository Analysis14OPTIONALOptional parametersnvarchar10
6CNVIMGIMG activities15OPTIONALMBT PCL Optional flagnvarchar10
7CNVMBTCOPYCCopy Control Data for TDMS & CMIS packages16OPTIONALMBT PCL Optional flagnvarchar10
8CNVMBTIFPARAMPIFD Parameters contained in an Interface6OPTIONALOptional Flagnvarchar10
9CNVMBTIMGProcess plan, order of activities to be executed9OPTIONALMBT PCL Optional flagnvarchar10
10CNVMBTPROCDESTMBT PCL: Required Destinations for Process Types4OPTIONALMBT PCL Optional flagnvarchar10
11CNVMBTVARPARAMPIFD Parameters contained in an Interface6OPTIONALOptional Flagnvarchar10
12DMC_PC_DEF_PARAMMWB: Pseudocode Parameter5OPTIONALBoolean Variable (X=True, -=False, Space=Unknown)nvarchar10
13GRFNMDRCONTEXTMDR context validation5OPTIONALOPTIONALnvarchar10
14RCCL_BUF_FUNCPARRCCF: Function Parameter Buffer13OPTIONALOptional parametersnvarchar10
15TGSU0SAP Structural Graphics: Log Description7OPTIONALFlag optionalnvarchar10
16T7PIQRLCOND_PAAssign Parameters to Conditions3OPTIONALOptional parametersnvarchar10
17T7PIQ_SI2_FILPADefine Filters3OPTIONALOptional parametersnvarchar10
TOPAdvanced Returns Management
18MSR_I_STEP2SEQMulti-step returns - assign steps to sequence5OPTIONALOptional Stepnvarchar10
TOPBRFplus - ABAP-Based Business Rules
19FDT_BRMS_CONN_2FDT: BRMS Connection Type Parameter3OPTIONALData element for domain BOOLE: TRUE (='X') and FALSE (=' ')nvarchar10
20FDT_REPO_0020FDT: Repository Information for Tables7OPTIONALData element for domain BOOLE: TRUE (='X') and FALSE (=' ')nvarchar10
TOPCollaborative Cross Applications
21/POA/D_CLM_DPLFCopy of Function Names for Deployment5OPTIONALBooleannvarchar10
22/POA/I_CLM_APIValue Table for API2OPTIONALBooleannvarchar10
TOPContract Billing
23ETRFVRate Steps5OPTIONALOptional billing stepnvarchar10
TOPCross-Application Components
24SPRTL16Data Collection Function Modules: Definition of Parameters6OPTIONALOptional parametersnvarchar10
TOPData Conversion
25DMC_PARAMDMC: Formal Parameters in Rule and Operation Calls17OPTIONALDMC: Flag Whether Parameter Optionalnvarchar10
TOPeCATT Extended Computer Aided Test Tool
26ECSCR_PARDefinition of eCATT Script Parameters and Variables18OPTIONALOptional parameternvarchar10
27ECSP_PARDefinition of eCATT Test Run Parameters and Variables18OPTIONALOptional parameternvarchar10
28ECTD_PARDefinition of Test Data Container Parameters18OPTIONALOptional parameternvarchar10
TOPEnd User Technology
29RSZELTXREFDirectory of query element references7OPTIONALBooleannvarchar10
TOPFunction Builder
30FUPARAREFParameters of function modules9OPTIONALOptional parametersnvarchar10
31FUPARAREF_ENHAParameters of function modules9OPTIONALOptional parametersnvarchar10
TOPFunds Management
32FMDPEF_FSTSFieldstatus FMDPEF10OPTIONALIndicator: Fields may be entered?nvarchar10
33FMDPEF_FSTS_SAPFieldstatus FMDPEF SAP delivered7OPTIONALIndicator: Fields may be entered?nvarchar10
TOPInformation Consistency
34SIC_NORM_BRTYIInterface Variables for Basic Rule Types5OPTIONALOptionalnvarchar10
TOPIntegration Engine
35SXMSPLSRVXMS: Pipeline Service Specification17OPTIONALXMS: Flag (true/false)nvarchar10
TOPIntercompany Data Exchange
36EENRNBSERVDetermination of Non-Billable Services8OPTIONALOptional Servicenvarchar10
TOPLoans Management
37TDB23Activity Type - Control of Requirements6OPTIONALSelection field for optional screen fieldsnvarchar10
TOPMarketing Retail Network
38OIFSCTFDCONFCField Selection Customizing - Screen Configuration Tool8OPTIONALField is optionalnvarchar10
39OIFSCTFDDEFCField Definition Customizing - Screen Configuration Tool5OPTIONALField is optionalnvarchar10
40OIFSCTFDDEFC1Field Definition Customizing - Screen Configuration Tool6OPTIONALField is optionalnvarchar10
41OIFSCTFDDEFSField Definitions - Screen Configuration Tool5OPTIONALField is optionalnvarchar10
TOPOnline Correction Support Support Package and Add-On Tools
42PAT11Linking Master and Sub-Support Packages (Compound Sup. Pkgs)4OPTIONALBoolean Variable (X=True, -=False, Space=Unknown)nvarchar10
43PAT11_SDAPAT11 for Stand-Alone Support Package Disassembler4OPTIONALGeneral Flagnvarchar10
TOPPersonnel Time Management
44T7TIM_EVAL_MAPInterface<->Context Attribute Mapping (Time Evaluation)9OPTIONALAttribute Servicing Is Optionalnvarchar10
TOPProcess Management
45POC_DB_C_OPERDomain Model: Operation Collection9OPTIONALData element for domain BOOLE: TRUE (='X') and FALSE (=' ')nvarchar10
TOPProcess Monitoring Infrastructure
46SSPIPSTSPI: Transitions Between Process Steps6OPTIONALSPI: Optional Flagtinyint30
TOPRemaining Beverage - Obsolete Objects
47/BEV3/CHCDPFBPCDP: Technical FM Parameter Definition for Each Submodule8OPTIONALOptional parametersnvarchar10
TOPSAP Business Workflow
48SWLWPSSIGWorkflow: Parameters for External Services6OPTIONALWebFlow Service Parameter: Optional Attributenvarchar10
TOPService Data Download
49/BDL/BDLFUPIMPService Definition, import parameters for interface7OPTIONALOptional parametersnvarchar10
50/BDL/IFCHA/BDL/SDCC: In/Out-Parameter7OPTIONALSingle-Character Indicatornvarchar10
51/BDL/IFIMP/BDL/SDCC: Import-Parameter7OPTIONALSingle-Character Indicatornvarchar10
52/BDL/IFTBL/BDL/SDCC: Export-Parameter6OPTIONALSingle-Character Indicatornvarchar10
53BDLFUPIMPDefinition of import parameters for one function version6OPTIONALOptional parametersnvarchar10
54BDLIFCHABDL SDCC: Input/Output Parameters7OPTIONALSingle-Character Indicatornvarchar10
55BDLIFIMPBDL SDCC: Import Parameters7OPTIONALSingle-Character Indicatornvarchar10
56BDLIFTBLBDL SDCC: Export Parameters6OPTIONALSingle-Character Indicatornvarchar10
TOPService Station Retailing
57OIRCSCTFDDEFSField Definitions - Meter Maintenance4OPTIONALField is optionalnvarchar10
58OIRC_MR_FDEF_CFSSR Meters - Field Selection Customizing - SCT9OPTIONALField is optionalnvarchar10
TOPSmart Forms
59STXFSTDPARSmart Forms: Default Parameters5OPTIONALSAP Smart Forms: General Indicatornvarchar10
TOPWeb Application Builder
60W3BHTMPARAWAB: Business HTML Parameters3OPTIONALOptional Indicator for Business HTML Parametersnvarchar10
TOPWeb Screen Tools - ABAP
61WDY_CTLR_PARAMWeb Dynpro: Parameter of a Controller13OPTIONALGeneral Flagnvarchar10
62WDY_PLUG_PARAMWeb Dynpro : Plug Parameter13OPTIONALGeneral Flagnvarchar10
TOPWorkbench Tools Editors, Painters, Modelers
63MAPPARAREFParameter for Conversions Between XML and ABAP9OPTIONALIndicator for Optional Mapping Parameternvarchar10