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

116 columns | Print definition?ERP 6.0  | INTTYPE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/SMFND/GS001AGeospatial service - Service Provider Attributes Meta Info19INTTYPEABAP data type (C,D,N,...)nvarchar10
2/SYCLO/CA003DMDO DOF Table Rule - Meta Data16INTTYPEABAP data type (C,D,N,...)nvarchar10
3CNVCMIS_A_1_TABFSelection of Object Type TABLE (TABF) Master information14INTTYPEABAP data type (C,D,N,...)nvarchar10
4CNVCMIS_A_20_DICTable fields for Cross-Client Customizing Comparison10INTTYPEABAP Data Typenvarchar10
5CNVHCM_CLSTDEFTDMS4HCM: Definitions of PCLn Clusters8INTTYPETDMS4HCM: Data Type for Cluster Definitionsnvarchar10
6CNVMBTTABSTRUCField list of tables for file transfer14INTTYPEABAP data type (C,D,N,...)nvarchar10
7CNV_20308_FLDCATField Catalog for Download7INTTYPEABAP data type (C,D,N,...)nvarchar10
8DD03NDDD: Attributes of a Node of a Structured Object10INTTYPEABAP data type (C,D,N,...)nvarchar10
9DFKKBIXC8162CIT Class Configuration Version (Table TFK8162)10INTTYPEABAP data type (C,D,N,...)nvarchar10
10DFKKBIXE8162Working Version CIT Class Configuration (Table TFK8162)9INTTYPEABAP data type (C,D,N,...)nvarchar10
11DFKKBIXG8162CIT Class Generation Version (Table TFK8162)10INTTYPEABAP data type (C,D,N,...)nvarchar10
12FARR_C_RAI52Fields of a Revenue Accounting Item Class10INTTYPEABAP data type (C,D,N,...)nvarchar10
13FARR_D_RAIC52Configuration Version RAI Class (FARR_C_RAI52)11INTTYPEABAP data type (C,D,N,...)nvarchar10
14FARR_D_RAIG52Generation Version RAI Class (FARR_C_RAI52)11INTTYPEABAP data type (C,D,N,...)nvarchar10
15FARR_D_RAIW52Working Version Configuration RAI Class (FARR_C_RAI52)11INTTYPEABAP data type (C,D,N,...)nvarchar10
16IUUC_RL_TABSTRstructural historical information for tables(Transp,Cluster)7INTTYPEABAP data type (C,D,N,...)nvarchar10
17RSCRMEXFLDSRSCRM: Extract field7INTTYPEData Type in ABAP Dictionarynvarchar40
18TFK8162Fields of a Consumption Item Class9INTTYPEABAP data type (C,D,N,...)nvarchar10
19ZCLUSTDATAData "piece" definitions for data cluster reporting9INTTYPEABAP Data Typenvarchar10
20ZCLUSTKEYCluster key definitions for data cluster reporting8INTTYPEABAP Data Typenvarchar10
TOPActivation Program, Conversion Program, DB Utility, MC, SPDD
21DD03LTable Fields11INTTYPEABAP data type (C,D,N,...)nvarchar10
22DD16SR/3 DD: SQL table fields9INTTYPEABAP data type (C,D,N,...)nvarchar10
TOPApplication Framework
23MDG_MDF2005Properties of Master Data Fields18INTTYPEABAP data type (C,D,N,...)nvarchar10
TOPBank Customer Accounts
24TBKK11BCA Lists: Field Catalog for List Tool (KKBLO_FIELDCAT)23INTTYPEABAP data type (C,D,N,...)nvarchar10
TOPBilling in Contract Accounts Receivable and Payable
25DFKKBIXC8152BIT Class Configuration Version (Table TFK8152)11INTTYPEABAP data type (C,D,N,...)nvarchar10
26DFKKBIXE8152Working Version Configuration BIT Class (Table TFK8152)11INTTYPEABAP data type (C,D,N,...)nvarchar10
27DFKKBIXG8152BIT Class Generation Version (Table TFK8152)11INTTYPEABAP data type (C,D,N,...)nvarchar10
28TFK8152Fields for a Class of Billable Items10INTTYPEABAP data type (C,D,N,...)nvarchar10
TOPCATT Computer Aided Test Tool
29CAT_FINFOGeneral Control field info17INTTYPEABAP data type (C,D,N,...)nvarchar10
TOPChange Documents
30CDSOLMIG_DDChange Document Objects to be Migrated13INTTYPEABAP data type (C,D,N,...)nvarchar10
TOPChecksums
31CSUM_EV_FLDSExecuted Analyses - Fields6INTTYPEABAP data type (C,D,N,...)nvarchar10
TOPClient-System Adapter
32MDMEXTRFLDMDM Field Table for Extraktor Metadata10INTTYPEABAP data type (C,D,N,...)nvarchar10
TOPControlling
33COAS_ATTRIBUTESMetadata for Attributes in Attribute Service3INTTYPEABAP data type (C,D,N,...)nvarchar10
TOPCorporate Performance Monitor
34UMR_RI124OBSOLETE RMS: Probability and Risk Intensity - Header9INTTYPEType of Risk Intensitynvarchar10
TOPCross-Application Components
35/IXOS/DC_TAHAHitlist Administrator maintenance (hierachy/separat)20INTTYPEABAP data type (C,D,N,...)nvarchar10
36/IXOS/DC_TAHUHitlist User maintenance (hierachy/separat)22INTTYPEABAP data type (C,D,N,...)nvarchar10
37/IXOS/DC_TAMAGeneral Doculink administraton data for data source15INTTYPEABAP data type (C,D,N,...)nvarchar10
38/IXOS/DC_TCSFSelection fields9INTTYPEABAP data type (C,D,N,...)nvarchar10
39/IXOS/DC_TTC03LTable fields, created by using DDIF_NAMETAB_GET6INTTYPEABAP data type (C,D,N,...)nvarchar10
TOPData Basis
40RSBOHFIELDSFields of the Open Hub Destination11INTTYPEABAP data type (C,D,N,...)nvarchar10
TOPData Conversion
41DMC_DDTYPDMC: DDIC Data Types9INTTYPEABAP data type (C,D,N,...)nvarchar10
42DMC_FIELDDMC: Data Field of a Structure21INTTYPEABAP data type (C,D,N,...)nvarchar10
TOPData Staging
43RSBATCHDEBUGVALDebugging of Batch Processes - Variable List6INTTYPEABAP data type (C,D,N,...)nvarchar10
44RSBATCHWAITVALDebugging of Batch Processes - Variable List5INTTYPEABAP data type (C,D,N,...)nvarchar10
45RSISFIELDSHShadow table: InfoSource fields12INTTYPEABAP data type (C,D,N,...)nvarchar10
46RSISOFIELDInfoSource fields (provider structure of a source system)12INTTYPEABAP data type (C,D,N,...)nvarchar10
47RSKSFIELDNEWFields for New InfoSource12INTTYPEABAP data type (C,D,N,...)nvarchar10
48RSKSFIELDSHShadow table: Communication structure fields10INTTYPEABAP data type (C,D,N,...)nvarchar10
49RSOLTPSOURCEFDSHShadow Table: OLTP Source Fields12INTTYPEABAP data type (C,D,N,...)nvarchar10
50RSOLTPSOURCEFIEOLTP Source Fields12INTTYPEABAP data type (C,D,N,...)nvarchar10
51RSOLTPSOURCESFISegment Fields of a DataSource13INTTYPEABAP data type (C,D,N,...)nvarchar10
52RSOSATTFDSHShadow table: InfoSource attributes12INTTYPEABAP data type (C,D,N,...)nvarchar10
53RSOSFIELDSHShadow table: InfoSource fields12INTTYPEABAP data type (C,D,N,...)nvarchar10
54RSOSOATTFDInfoSource attributes of a source system12INTTYPEABAP data type (C,D,N,...)nvarchar10
55RSOSOFIELDInfoSource fields of a source system11INTTYPEABAP data type (C,D,N,...)nvarchar10
56RSRULEPARAMRule Parameters9INTTYPEABAP data type (C,D,N,...)nvarchar10
57RSTRANSTEPCNSTRule Type: Constant6INTTYPEIntTypenvarchar10
58RSTRFIELDSHShadow table: Transfer Structure Fields12INTTYPEABAP data type (C,D,N,...)nvarchar10
59RSTSFIELDTransfer structure fields10INTTYPEABAP data type (C,D,N,...)nvarchar10
60RSTSFIELDSHShadow table: Transfer structure fields12INTTYPEABAP data type (C,D,N,...)nvarchar10
61RSTSIDOCFIELDFields for the IDoc Operational Data Store10INTTYPEABAP data type (C,D,N,...)nvarchar10
62RSTSODSFIELDFields for the Operational Data Store11INTTYPEABAP data type (C,D,N,...)nvarchar10
TOPElectronic Data Interchange
63PRICAT_K010SPrice Catalog: Last Structure of Structures9INTTYPEABAP data type (C,D,N,...)nvarchar10
64WRF_PRICAT_010SPrice Catalog Generic Structures and Fields per Catalog6INTTYPEABAP data type (C,D,N,...)nvarchar10
TOPEngineering Change Management
65TCCERLinks Between Effectivity Types and Parameters5INTTYPEABAP data type (C,D,N,...)nvarchar10
TOPFast Search Infrastructure
66SFSG_Q_CONDQuery Condition4INTTYPEABAP data type (C,D,N,...)nvarchar10
67SFSRFW_IDX_IFDReplication Framework - Definition of Index Fields10INTTYPEABAP data type (C,D,N,...)nvarchar10
68SFSRFW_IDX_KEY_DReplication Framework - Doc. ID Description of an Index9INTTYPEABAP data type (C,D,N,...)nvarchar10
69SFSRFW_REQ_OBJSReplication Framework Requested Tables12INTTYPEABAP data type (C,D,N,...)nvarchar10
TOPFinancials Basis
70UGMD2005FIN Master Data: Field Properties19INTTYPEABAP data type (C,D,N,...)nvarchar10
71UGMD2140FIN Master Data: (Role-independent) Definition of Fields13INTTYPEABAP data type (C,D,N,...)nvarchar10
72UGMD2150FIN Master Data: Active (Role-Indep.) Definition of Fields12INTTYPEABAP data type (C,D,N,...)nvarchar10
73UGR31008FIN Master Data: Dummy Field Names with Properties15INTTYPEABAP data type (C,D,N,...)nvarchar10
74UGR31022FIN Master Data: Buffer Table f.Fields of Extract Structures13INTTYPEABAP data type (C,D,N,...)nvarchar10
TOPHierarchical Derivation Service
75THDS_GENCATLFCatalog for Generation7INTTYPEData Type in ABAP Dictionarynvarchar40
76THDS_GENCATLF_ACatalog for Generation7INTTYPEData Type in ABAP Dictionarynvarchar40
77THDS_GENCATLF_SCatalog for Generation6INTTYPEData Type in ABAP Dictionarynvarchar40
TOPInformation Consistency
78SIC_NODE_FIELDSDefinition of Fields per Node12INTTYPEABAP data type (C,D,N,...)nvarchar10
TOPJoint Venture und Production Sharing Accounting
79T8JINTJoint Venture Interest Types2INTTYPEInterest Typenvarchar10
80T8JINTTJoint Venture Interest Type Text3INTTYPEInterest Typenvarchar10
81T8JLP2Penalty Category Recovery Percentages*5INTTYPEInterest Typenvarchar10
82T8JQJoint Venture Owner Equity13INTTYPEInterest Typenvarchar10
TOPLegacy System Migration Workbench
83/SAPDMC/LSGBDCBI Name: "Code"23INTTYPEABAP data type (C,D,N,...)nvarchar10
TOPManufacturer Part Number
84ADPIC_HOLD_MPNStore MPN subitems for MIGO hold / restore functionality33INTTYPEReplacement Typenvarchar10
TOPMarketing, Accounting and Pricing
85OICINT_CALInterest calculation3INTTYPEInterest type for interest calculationnvarchar10
86OICINT_MASTERInterest master data4INTTYPEInterest type for interest calculationnvarchar10
TOPNetWeaver Enterprise Search
87ESH_OM_ADATATYData Types7INTTYPEABAP data type (C,D,N,...)nvarchar10
88ESH_OM_CDATATYData Types7INTTYPEABAP data type (C,D,N,...)nvarchar10
89ESH_OM_IDATATYData Types7INTTYPEABAP data type (C,D,N,...)nvarchar10
90ESH_OM_SDATATYData Types7INTTYPEABAP data type (C,D,N,...)nvarchar10
TOPOrganizational Management
91T77OMATTRGeneral Attribute Maintenance: Definition of Attributes12INTTYPEABAP data type (C,D,N,...)nvarchar10
TOPPlanning
92T8PL01DDFI Planning: Dimensions Table Index - Dictionary Information13INTTYPEABAP data type (C,D,N,...)nvarchar10
93T8PLUATTRFI-Planning: Key Figures for Planning13INTTYPEABAP data type (C,D,N,...)nvarchar10
TOPProcess Controls
94GRPCRLCRARule Criteria Assignment10INTTYPEABAP data type (C,D,N,...) for Query - Obsoletenvarchar10
95GRPCRLCRSYSARule Criteria System Type Assignment10INTTYPEABAP data type (C,D,N,...) for Querynvarchar10
TOPProfitability Analysis
96TKEPEAdmin.table for transferring plan data from CO-PA to SOP8INTTYPEABAP data type (C,D,N,...)nvarchar10
TOPProject System
97FILTER_PS_LOGFilter for PS EHP416INTTYPEABAP data type (C,D,N,...)nvarchar10
TOPSAP Business Partner
98MDMEXTRFLD_PREFMDM Field Table Extractor Metadata (Copy)10INTTYPEABAP data type (C,D,N,...)nvarchar10
TOPService Data Download
99/BDL/FUPTYPParameters or tables for the re-import7INTTYPEABAP data type (C,D,N,...)nvarchar10
100/BDL/IFFIELD/BDL/SDCC: fiels, dataelements and domains of table10INTTYPEnvarchar10
101/BDL/INTSESSInternal service sessions (to be done by customer)3INTTYPETCC contract typenvarchar80
102/BDL/OWNSESSInternal service sessions (to be done on other cust. sys.)3INTTYPETCC contract typenvarchar80
103/BDL/SESSService session schedule for the system the table is in2INTTYPETCC contract typenvarchar80
104BDLFUPTYPParameters or tables for the re-import7INTTYPEABAP data type (C,D,N,...)nvarchar10
105BDLIFFIELDBDL SDCC: Table's Fields, Data Elements, Domains10INTTYPEnvarchar10
106BDLINTSESSInternal service sessions (to be done by customer)3INTTYPEContract typenvarchar80
107BDLOWNSESSInternal service sessions (to be done on other cust. sys.)3INTTYPEContract typenvarchar80
108BDLSESSService session schedule for the system the table is in2INTTYPEContract typenvarchar80
TOPSupersession Chains
109PICPSParts Interchangeability Item (SuS+MPN)9INTTYPEReplacement Typenvarchar10
TOPTax Reporting
110OIUX3_TX_RP_EDT1OBSOLETE - Tax 2.0 - Texas Report Field Attribute Edits6INTTYPEABAP data type (C,D,N,...)nvarchar10
TOPTransport Organizer
111VERSNTABStructures of the sub-objects of versionable objects17INTTYPEABAP data type (C,D,N,...)nvarchar10
TOPTreasury
112CML_MIG_BUFFERTable DDIC buffering (migration)16INTTYPEABAP data type (C,D,N,...)nvarchar10
TOPUser and Authorization Management
113AUTH_FLDINFO_TMPAuthorization fields: technical info from dictionary12INTTYPEABAP data type (C,D,N,...)nvarchar10
TOPWithout Description
114RSKSFIELDFields of the communication structure10INTTYPEABAP data type (C,D,N,...)nvarchar10
TOPWorkbench Tools Editors, Painters, Modelers
115WBEXTTYPESWorkbench: External code for object types2INTTYPEWB Request: Type of development object (internal type)nvarchar30
TOPWorkbench Utilities
116SPAR_NTDBParameter Storage: Persistent Nametab Container19INTTYPEABAP data type (C,D,N,...)nvarchar10