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

91 columns | Print definition?ERP 6.0  | PREFIX

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/AIF/T_FG_MAPmapping table for created objects3PREFIXPrefix of Function Name Generatornvarchar150
2/AIF/T_RFC_FGLOGFunction Module List Generation Log11PREFIXPrefix of Function Name Generatornvarchar150
3/CFMFND/DOBJDESCCustomizingtabelle dyn. Objekte - Darstellungsmerkm. - Tab6PREFIXCAFM Foundation dynamische Objekte - Präfixnvarchar80
4/EHR/S71_DOWNOutput Structures12PREFIXPrefix Output Fieldnvarchar20
5/IWBEP/I_SBU_ASB: UI plugins (add-on)4PREFIXSB: UI plugin prefixnvarchar20
6/SAPPSSRM/FLPNIDCustomizing table for mapping between LPN and FPDS ID5PREFIXComponent Prefix in Alphanumeric Smart Numbernvarchar10
7/SAPPSSRM/NMTPDFDefinition of composite number components (long number)5PREFIXComponent Prefix in Alphanumeric Smart Numbernvarchar10
8/WSOPT/HR_DESTCommunication HR Data5PREFIXPrefix for SAPIDnvarchar100
9/WSOPT/PM_DESTCommunication PM Data5PREFIXPrefix for SAPIDnvarchar100
10ARBFND_I_DCXML_HDDIC objects generated for cXML messages: header data8PREFIXPrefix used for the names of generated dcXML DDIC objectsnvarchar200
11CNV_20000_NRIV_MCustomizing table to store NRIV object mapping11PREFIX3-Byte fieldnvarchar30
12CODD_PREFIXESThe prefixes that C4C supports for customer entries4PREFIXnvarchar100
13DOCR_NUM_RANGESDBOSC-CR: Number Ranges for ID Generation1PREFIXnvarchar320
14GRFNUIBRANYSTYPEBusiness Rule Analysis Type Link10PREFIXPrefix structure for outputnvarchar300
15NWS_EXT_OBJData Transport Management Tool Data Objects20PREFIX3-Byte fieldnvarchar30
16RSBPCA_APPLBPC model information12PREFIXBPC: Application Prefixnvarchar70
17RSBPCA_APPSETBPC Environment information3PREFIXBPC: AppSet Prefixnvarchar20
18SFICLClass Table for SAPfind2PREFIXPrefix for table namesnvarchar30
19TFICClass Table for SAPfind2PREFIXPrefix for table namesnvarchar30
20TGSU0SAP Structural Graphics: Log Description4PREFIXPrefix (header, values, comments)nvarchar20
21TLRC_TARO_TARTrade Repository7PREFIXPrefix of the filenamenvarchar2550
22TPTABTable parameters for DB23PREFIXTable and tablespace prefixnvarchar40
23TPTSPTablespace parameters for DB23PREFIXTable and tablespace prefixnvarchar40
24/BOBF/OBM_OBJBOPF Configuration: Version31PREFIXPrefixnvarchar100
TOPAccounting Entities
25FINB_ST_VARGRPCVariable Groups for Structured Types3PREFIXnvarchar300
TOPAuto-ID Infrastructure
26/AIN/TGIAI_NRRANGIAI Number Range10PREFIXPrefix of a serial numbernvarchar240
TOPBasic Functions
27T028PAssign Search Strings to Bank Statement Transactions12PREFIXMapping prefixnvarchar320
TOPBusiness Application Support
28CNV_10992_TSTRUCStructure of text object keys for texts3PREFIXPrefix in field TDNAME in tables STXB, STXH, STXLnvarchar100
TOPBusiness Rule Framework
29TBRF365BRF: Context Elements for Simple Context10PREFIXBRF: Prefix for Expressionnvarchar200
TOPBusiness Server Pages
30O2TAGLIBBSP Extensions7PREFIXBSP Extension: Prefix, Case-Sensitivenvarchar300
TOPChange Documents
31TCDRPInformation on Include Reports Generated by RSSCD00011PREFIXPrefix for generated change document structuresnvarchar140
32TCDRPSTCDRP Shadow Table for Change Document Object Transport11PREFIXPrefix for generated change document structuresnvarchar140
TOPConditions
33CND_USAGE_PREFIXPrefix for Every Usage2PREFIXPrefix per Usage (in Exchange)nvarchar100
TOPConsolidation
34TFIN001ID Combination Rules for Cons Type and Cons Org. Unit7PREFIXPrefix of an organizational unit IDnvarchar40
TOPCross-Application Components
35TSERIALSerial Number Profile3PREFIXSerial Number Prefixnvarchar300
TOPCross-System Tools
36SCDTSYSRFC_HTTPGenerierte HTTP-Destinationen3PREFIXntext10737418230
TOPDown Payment Chains
37/SAPPCE/TDPC02Down Payment Chain Types10PREFIXPrefix for Reservation of Assignment Numbernvarchar30
TOPDSD Connector
38/DSD/ME_NUM_MAPPDSD Connector: Document Numbering Mapping4PREFIXDSD Connector: Prefixnvarchar80
39/DSD/ME_NUM_PREFDSD Connector: Document Numbering Prefix2PREFIXDSD Connector: Prefixnvarchar80
40/DSD/ME_NUM_TRANDSD Connector: Document Numering Last Number2PREFIXDSD Connector: Prefixnvarchar80
TOPEasy Enhancement Workbench
41AXT_EXTENSIONExtension13PREFIXGeneration Prefixnvarchar10
42AXT_NUMBERRANGENumber Ranges for Extensibility2PREFIXGeneration Prefixnvarchar10
43AXT_SYSTABExtensibility Tool System Table5PREFIXGeneration Prefixnvarchar10
TOPFinancial Accounting
44/CCEE/FISIMT940Bank statement - MT 940 - convert reference7PREFIXMapping prefixnvarchar320
45OFFNUM_CNAssign Number group and Prefix to comp. code and doc. class5PREFIXPrefix of the Official Document Numbernvarchar100
TOPForms Processing
46FPNUMBERLEVELForm Objects: Number Range Status1PREFIXPrefix for Namespacenvarchar20
TOPGeneral Application Functions
47/BA1/TC0_GENPRGGenerates Programs for Deep Move Corresponding8PREFIXPrefix of Field Name for Deep-Move-Corresponding Toolnvarchar30
TOPGeneral Ledger
48/EACA/GL_DOCNR_XG/L Number Ranges: Counter for Generated Subobjects1PREFIXData Field Character 3nvarchar30
TOPGeneric Interaction Layer
49GIL_ENH_COMPgenIL Component Enhancement Table6PREFIXComponent/Enhancement Prefixnvarchar150
50WCFC_GIL_COMPROPComponent properties5PREFIXComponent/Enhancement Prefixnvarchar150
51WCF_GIL_COMPPROPComponent properties4PREFIXComponent/Enhancement Prefixnvarchar150
TOPIndustry Solution Catch Weight Management
52/CWM/SAPLMBMM_FTable Fields3PREFIXField Namenvarchar300
TOPIntegration Builder - Configuration
53TRD_COBJPREFIXPrefix-Namespace Assignment for Context Objects3PREFIXPrefix of XML Document Namespacenvarchar100
54TRD_NAMESPACENamespaces for XPath Rules3PREFIXPrefix of XML Document Namespacenvarchar100
TOPIntegration Engine
55SXMSMSGDEFMessage Definition8PREFIXQueue Prefixnvarchar40
56SXMS_NSPREFIXTable for Extractor Namespace Prefixes3PREFIXPrefix of XML Document Namespacenvarchar100
57SXMS_QUEUE_PRIOPrioritized EOIO Queues2PREFIXQueue Prefixnvarchar40
TOPLegacy System Migration Workbench
58/SAPDMC/LSORULRule Category12PREFIXPrefixnvarchar300
TOPLocalization
59J_1BBRANCHBusiness Place37PREFIXPrefix for Fiscal Branchnvarchar10
60SIPT_NUMBR_MMSignature PT: Relevancy of Self Billing Number range7PREFIXDigital Signature Portugal : Prefixnvarchar100
TOPMaterial Master
61WGDS_CONFIRMWGDS Confirmation6PREFIXConfirmation Prefixnvarchar50
62WGDS_LOG_SUBCWGDS Log Subscription6PREFIXSubscription Prefixnvarchar50
63WGDS_SUBC_DFLTSSubscriptions Defaults3PREFIXSubscription Prefixnvarchar50
64WGDS_SUBSCRIPSWGDS Subscriptions9PREFIXSubscription Prefixnvarchar50
TOPMaterials Management
65J_1GPUPREFIXSource / Target Document Types5PREFIXDocument number prefixnvarchar20
TOPMobile data entry
66T313GGeneral Parameters for Bar Code Type Definition5PREFIXBar code type prefixnvarchar100
TOPObject Services
67OSEXXMLNODEOS Example: XML Node5PREFIXOS Example: Stringnvarchar2550
TOPOrganization and Planning
68T77MWBFCHFunction Code Hierarchies for Manager's Desktop6PREFIXPrefix for Function Code Supplied by Function Modulenvarchar40
TOPPayroll General Parts
69DSYS_CUSTHRDSYS: Storage for Customer Documentation4PREFIXHRDSYS: Prefix for object name when searching in obj. tablenvarchar200
70DSYS_STDHRDSYS: Storage for SAP standard documentation4PREFIXHRDSYS: Prefix for object name when searching in obj. tablenvarchar200
TOPProduct Cost Planning
71TCWB_IN_OUTUmschlüsselung von Input-Werten5PREFIXnvarchar10
72TNAMECHANGENamensersetzung: Umschlüsselung6PREFIXnvarchar10
TOPProxy Generation
73SPROXHDRProxy Header Data (substitution table)18PREFIXProxy Generation: Prefix for Names of Proxy Objectsnvarchar300
TOPRecycling Administration Core Functions
74J_7LC34REA DME: Field Mapping and Rule Set11PREFIXPrefixnvarchar300
TOPResourcen Management
75RMSAT_HDRRMS: Header Data Table for Versioning8PREFIXKey Part of a Version for Inspectionnvarchar420
TOPRetention Warehouse
76IWP_GEN_CONFIGConfiguration of BI extraction7PREFIXPrefix for Generated Objectsnvarchar50
TOPSecurity
77RSECACHKTable for Controlling ABAP Programs3PREFIXPermitted Namespaces for Applicationnvarchar630
TOPStandardized Key Mapping
78UKMPI_MAPPINGMapping Settings for UKMS8PREFIXKey Prefixnvarchar100
TOPSwitch Framework Tools
79SFW_BFC_KWBFUNCTION SFKnowledge Warehouse of Business Function Content6PREFIXText Fieldnvarchar500
TOPTransaction Manager
80TCORFTS_MAP_RULEMapping Rules7PREFIXPrefix for a Mapping Fieldnvarchar300
81TCORIC_FILETreasury; Messaging Interface: Configuration of File Adapter4PREFIXPrefix of the filenamenvarchar2550
TOPUpgrade - General
82MERGEMAPSHeader Information for Merge Maps3PREFIXRequest/Tasknvarchar200
TOPVariant Configuration
83PMEVC_AFFIX_TMPLTemplate with affix (i.e. prefix and postfix) rules5PREFIXPrefix or Suffixntext10737418230
TOPWeb Dynpro ABAP
84WDG_UR_ENUMUnified Rendering: Events1PREFIXnvarchar30
85WDG_UR_ENUM_VALUnified Rendering: Events1PREFIXnvarchar30
TOPWeb Service and SOAP - ABAP
86SRT_WSICF_PREFTable of Valid URL Prefixes for Web Service Definition2PREFIXPath Prefix in ICF for Web Service Definitionsnvarchar2550
TOPWeb Service Tools - ABAP
87WSHEADERWeb Services Definition Administrative Data10PREFIXPath Prefix in ICF for Web Service Definitionsnvarchar2550
88WSHEADER_DARKDark table of WSHEADER (only for transport reasons)11PREFIXPath Prefix in ICF for Web Service Definitionsnvarchar2550
TOPWeb Services Tool
89CRMC_WSC_COMPWSC Component Table2PREFIXPrefix for Componentnvarchar30
TOPWithout Description
90RSTC_CALL_BIACURL to call the BI Adminstration Cockpit2PREFIXURL Prefix for Portal URLsnvarchar2550
TOPWorkforce Management Core
91/SAPAPO/LRPGWPREMapping of Prefix for GWI Applications to Application Cat.2PREFIXPrefix for GWI Applicationsnvarchar30