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

114 columns | Print definition?ERP 6.0  | REFFIELD

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/AIF/T_RECFLDSField definition13REFFIELDReference Fieldnvarchar450
2CNVCMIS_A_1_TABFSelection of Object Type TABLE (TABF) Master information18REFFIELDReference field for currency and qty fieldsnvarchar300
3CNVCMIS_A_20_DICTable fields for Cross-Client Customizing Comparison14REFFIELDReference Field for Currency and Quantity Fieldsnvarchar300
4CNVMBTTABSTRUCField list of tables for file transfer20REFFIELDReference field for currency and qty fieldsnvarchar300
5DD03NDDD: Attributes of a Node of a Structured Object14REFFIELDReference field for currency and qty fieldsnvarchar300
6DDREPLICREFDD: Information on Metadata Transfer: Fields9REFFIELDReference field for currency and qty fieldsnvarchar300
7DDREPLINTABFDDD: Nametab Field Structure24REFFIELDReference field for currency and qty fieldsnvarchar300
8DDXTF_CONV_UCNametab Feldstruktur für verzögertes Schreiben23REFFIELDReferenzfeld für Währungs- und Mengenfeldernvarchar300
9DDYTF_CONV_UCUsed during UCMIG within DMO of SUM23REFFIELDReference field for currency and qty fieldsnvarchar300
10DFKKBIXC8162CIT Class Configuration Version (Table TFK8162)14REFFIELDReference field for currency and qty fieldsnvarchar300
11DFKKBIXE8162Working Version CIT Class Configuration (Table TFK8162)13REFFIELDReference field for currency and qty fieldsnvarchar300
12DFKKBIXG8162CIT Class Generation Version (Table TFK8162)14REFFIELDReference field for currency and qty fieldsnvarchar300
13FARR_C_RAI52Fields of a Revenue Accounting Item Class15REFFIELDReference field for currency and qty fieldsnvarchar300
14FARR_D_RAIC52Configuration Version RAI Class (FARR_C_RAI52)16REFFIELDReference field for currency and qty fieldsnvarchar300
15FARR_D_RAIG52Generation Version RAI Class (FARR_C_RAI52)16REFFIELDReference field for currency and qty fieldsnvarchar300
16FARR_D_RAIW52Working Version Configuration RAI Class (FARR_C_RAI52)16REFFIELDReference field for currency and qty fieldsnvarchar300
17IUUC_DD_SYNC_NTFSystem synchronization: Nametab field data27REFFIELDReference field for currency and qty fieldsnvarchar300
18RSFBPFIELDOpen ODS View: Fields6REFFIELDField Namenvarchar120
19TFK8162Fields of a Consumption Item Class13REFFIELDReference field for currency and qty fieldsnvarchar300
20ZCLUSTDATAData "piece" definitions for data cluster reporting8REFFIELDField Namenvarchar300
TOPABAP Test Frameworks ATC, CheckMan, Code Inspector
21CRMLOGATrace Areas (OSOLETE)5REFFIELDField Namenvarchar300
TOPActivation Program, Conversion Program, DB Utility, MC, SPDD
22DD03LTable Fields15REFFIELDReference field for currency and qty fieldsnvarchar300
23DDXTFNametab Field Structure for Delayed Writing23REFFIELDReference field for currency and qty fieldsnvarchar300
TOPAlert Framework
24SALRTTRULEALM: Rules for Recipient Determination10REFFIELDReference fieldnvarchar300
TOPArchive Information System
25AIND_STR3Archive information structure: field catalog8REFFIELDReference field for archive info. structurenvarchar300
TOPBasic Functions
26EMMAC_CCAT_COBObject Container6REFFIELDReference fieldnvarchar300
27EMMAC_MSG_OBJMessage Objects6REFFIELDReference fieldnvarchar300
28EMMA_COBJECTObjects and Field Values for Case7REFFIELDReference fieldnvarchar300
29EMMA_COBJECT_CDObjects and Field Values for Case(Only for Change Documents)4REFFIELDReference fieldnvarchar300
TOPBilling in Contract Accounts Receivable and Payable
30DFKKBIXC8152BIT Class Configuration Version (Table TFK8152)16REFFIELDReference field for currency and qty fieldsnvarchar300
31DFKKBIXE8152Working Version Configuration BIT Class (Table TFK8152)16REFFIELDReference field for currency and qty fieldsnvarchar300
32DFKKBIXG8152BIT Class Generation Version (Table TFK8152)16REFFIELDReference field for currency and qty fieldsnvarchar300
33TFK8152Fields for a Class of Billable Items15REFFIELDReference field for currency and qty fieldsnvarchar300
TOPBusiness Object Builder
34SBMIGTTYPEMapping: Reference Type -> Table Type3REFFIELDReference fieldnvarchar300
35SWOTDQVerb Parameters, Exceptions11REFFIELDReference fieldnvarchar300
36SWOTDVObject Type Verbs Definition10REFFIELDReference fieldnvarchar300
37SWOTLQRuntime Table Parameters, Exceptions16REFFIELDReference fieldnvarchar300
38SWOTLVRuntime Table Verbs6REFFIELDReference fieldnvarchar300
TOPContract Accounts Receivable and Payable
39TFKBWFICA to BW - Maintain Fields for Extraction5REFFIELDReference Field for Extractionnvarchar300
40TFKBWCFICA BW - Maintain Fields for Extraction (Customer View)5REFFIELDReference Field for Extractionnvarchar300
41TFKOPBWBW - Maintain Fields for OI Extraction4REFFIELDReference Field for Extractionnvarchar300
42TFKOPBWCBW - Maintain Fields for OI Extraction4REFFIELDReference Field for Extractionnvarchar300
TOPContract Billing
43ECHDISPConsumption History Display Format4REFFIELDField Namenvarchar300
44ECHDISPTConsumption History Display Format Text4REFFIELDField Namenvarchar300
TOPCross-Application Components
45/IXOS/DC_TAHAHitlist Administrator maintenance (hierachy/separat)22REFFIELDReference field for currency and qty fieldsnvarchar300
46/IXOS/DC_TAHUHitlist User maintenance (hierachy/separat)24REFFIELDReference field for currency and qty fieldsnvarchar300
47/IXOS/DC_TAMAGeneral Doculink administraton data for data source17REFFIELDReference field for currency and qty fieldsnvarchar300
48J_8A3SGPARassign set-/get parameter to object - Old Version, don't use2REFFIELDReference fieldnvarchar300
49SPRTL1Assignment of Business Objects to Data Elements6REFFIELD30 Charactersnvarchar300
50SPRTL1CAssignment of Business Objects to Data Elements (Runtime)7REFFIELD30 Charactersnvarchar300
TOPCustomer Interaction Center
51CCMCMPCALLPAREAction Box Component Call: External Parameters7REFFIELDReference fieldnvarchar300
52CCMCMPCALLPARIAction Box Component Call: Parameters for Internal Calls7REFFIELDReference fieldnvarchar300
53CCMHTMLPARCIC HTML configuration: external parameters8REFFIELDReference fieldnvarchar300
54CCMHTMLPARICIC HTML configuration: parameter for internal calls8REFFIELDReference fieldnvarchar300
55COMAPOnline BDC output mapping from message table to container17REFFIELDReference fieldnvarchar300
56CSRCCONTAINEROnline BDC container value source map6REFFIELDReference fieldnvarchar300
57EWFPARFront Office Configuration: Call Parameter9REFFIELDReference fieldnvarchar300
TOPData Basis
58RSBTRANSFIELDTarget Structure InfoObjects for Open Hub Transformation7REFFIELDReference field for currency and qty fieldsnvarchar300
TOPData Collection
59MCSLISEFLIS Inbound Interface: Control Information (Fields)6REFFIELDReference field for currency and qty fieldsnvarchar300
TOPData Retention Tool
60TXW_C_REFReference for currency/amount fields5REFFIELDRelated unit fieldname (RSUNINM in BRS)nvarchar300
61TXX_C_REFReference for Currency and Quantity Fields5REFFIELDReference Field for Currency and Quantity Fieldsnvarchar300
TOPData Staging
62RSDANLSEGVFBW Archiving: Segment Version of a Nearline Object9REFFIELDReference field for currency and qty fieldsnvarchar300
TOPFinancial Accounting
63FBICRC01035Reconciliation Processes: Customer Defined Fields7REFFIELDReference field for currency and qty fieldsnvarchar300
TOPFinancials Basis
64UGR31008FIN Master Data: Dummy Field Names with Properties18REFFIELDReference field for currency and qty fieldsnvarchar300
65UGR31022FIN Master Data: Buffer Table f.Fields of Extract Structures16REFFIELDReference field for currency and qty fieldsnvarchar300
TOPFlexible Real Estate Management
66TIVCAECRE-FX: Currency Conversion - Relevant Tables and Fields14REFFIELDField Namenvarchar300
TOPFront Office
67EWATRAAction Manager: Parameter Def.8REFFIELDDDIC reference of target element (Field)nvarchar300
68EWBPARXFront Office Process Parameters9REFFIELDReference fieldnvarchar300
TOPIncentive and Commission Management ICM
69TCACS_ADDFIELDSObsolete - replaced by TCACS_DESFIELDS7REFFIELDReference field for currency and qty fieldsnvarchar300
70TCACS_CUSTFIELDSObsolete - replaced by TCACS_ADDFIELDS8REFFIELDReference field for currency and qty fieldsnvarchar300
71TCACS_DESFIELDSAdditional Fields for Generated Objects10REFFIELDReference field for currency and qty fieldsnvarchar300
72TCACS_EUConversion Rule: Tables and Fields in FS-ICM6REFFIELDTable Fieldnvarchar300
TOPIntegration Customer Relationship Management
73EPDESCIS-U MD template description: header entries19REFFIELDReference fieldnvarchar300
74EPDESCTYPIIS-U MD template description: MDT category interface9REFFIELDReference fieldnvarchar300
TOPIntercompany Data Exchange
75EIDESWTCHECKPARParameters for Change of Supplier Check9REFFIELDReference Field for Check Parameternvarchar300
TOPKnowledge Base
76ISMOBSDB: Symptom Object table9REFFIELDReference fieldnvarchar300
TOPLocal Currency Changeover
77EWUCUPAKETContains the individual packages for user-defined objects6REFFIELDReference field for currency and qty fieldsnvarchar300
TOPLogical Database Builder
78LDBQUANCurrency and quantity fields in logical database5REFFIELDReference field for currency and qty fieldsnvarchar300
TOPMaster Data
79EPDPRODAIS-U Master Data Generator: Attribute19REFFIELDField Namenvarchar300
80EPDTYPEAIS-U Master Data Generator: Master Data Template Attributes9REFFIELDField Namenvarchar300
TOPMedia Product Sales and Distribution
81TJKSDEVENTRULSRCSource Fields for Transfer Rules in Event Management3REFFIELDSource Field for Eventnvarchar300
TOPOrganizational Management
82HRC1212Customer Enhancement IT 1212 Events (with Binding)17REFFIELDReference fieldnvarchar300
83HRS1210Standard Infotype 1210 (SAP) Container Definition11REFFIELDReference fieldnvarchar300
84HRS1212Standard Infotype 1212 (SAP) Events with Binding Definition17REFFIELDReference fieldnvarchar300
85HRS1213Standard Infotype 1213 (SAP) Binding Task - Rule13REFFIELDReference fieldnvarchar300
86HRS1214Standard Infotype 1214 (SAP) Other Bindings for Task12REFFIELDReference fieldnvarchar300
87HRS1221Standard Infotype 1221 (SAP) Set/Get Parameter for Transact.8REFFIELDField Namenvarchar300
88HRT1210Table Part Infotype 121010REFFIELDReference fieldnvarchar300
89HRT1212Table Part Infotype 121210REFFIELDReference fieldnvarchar300
90HRT1213Table Part Infotype 121310REFFIELDReference fieldnvarchar300
91HRT1214Table Part Infotype 121410REFFIELDReference fieldnvarchar300
92HRT1218Table Part Infotype 121410REFFIELDReference fieldnvarchar300
93T77OMATTRGeneral Attribute Maintenance: Definition of Attributes4REFFIELDField Namenvarchar300
TOPRemaining Beverage - Obsolete Objects
94/BEV3/CHBCALCVAgreement Calculation - Formula Variable12REFFIELDReference fieldnvarchar300
95/BEV3/CHCFDFIELDTarget Fields of Agreements6REFFIELDReference fieldnvarchar300
96/BEV3/CHCFMVARSFormula variable7REFFIELDReference fieldnvarchar300
TOPSAP Business Workflow
97SWDSBINDEFWF Definition: Bindings12REFFIELDReference fieldnvarchar300
98SWDSWFCONTWF Definition: Container (Up To 46D)10REFFIELDReference fieldnvarchar300
99SWD_BINDEFWF Definition/Runtime: Bindings13REFFIELDReference fieldnvarchar300
100SWD_WFCONTWorkflow definition: Container11REFFIELDReference fieldnvarchar300
101SWFDCRLCBNCorrelation: Binding for Each Components9REFFIELDReference fieldnvarchar300
102SWJPCDEFContainer Definition for Parameter Condition9REFFIELDReference fieldnvarchar300
103SWWBINDEFObsolete 6.1/ Workflow Runtime - Save Bindin...8REFFIELDReference fieldnvarchar300
TOPTreasury
104CML_MIG_BUFFERTable DDIC buffering (migration)18REFFIELDReference field for currency and qty fieldsnvarchar300
TOPUpgrade - General
105DDMTFNametab Field Structure for Delayed Writing23REFFIELDReference field for currency and qty fieldsnvarchar300
106DDMTF_ISUNametab Field Structure for Delayed Writing23REFFIELDReference field for currency and qty fieldsnvarchar300
107DDMTF_SAVNametab Feldstruktur für verzögertes Schreiben23REFFIELDReferenzfeld für Währungs- und Mengenfeldernvarchar300
108DDXTF_SAVNametab Feldstruktur für verzögertes Schreiben23REFFIELDReferenzfeld für Währungs- und Mengenfeldernvarchar300
109DDXTF_SHDNametab Feldstruktur für verzögertes Schreiben23REFFIELDReferenzfeld für Währungs- und Mengenfeldernvarchar300
110DDXTF_STDNametab Feldstruktur für verzögertes Schreiben23REFFIELDReferenzfeld für Währungs- und Mengenfeldernvarchar300
111DDYTFSubstitution Nametab (shadow-shadow-nametab for DDXTF)24REFFIELD4.0 version of field namenvarchar300
TOPUpgrade Tools
112ICNV31LNametab for Incremental Conversion25REFFIELDnvarchar300
TOPUser and Authorization Management
113AUTH_FLDINFO_TMPAuthorization fields: technical info from dictionary14REFFIELDReference field for currency and qty fieldsnvarchar300
TOPWorkbench Utilities
114SPAR_NTDBParameter Storage: Persistent Nametab Container21REFFIELDReference field for currency and qty fieldsnvarchar300