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

154 columns | Print definition?ERP 6.0  | INTERFACE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/IXOS/CL_ARCHIVEArchives that are detected as Opentext/Ixos archives3INTERFACESAP ArchiveLink: Name of communication connection componentnvarchar140
2/XFT/REG_SETYAISETY - ABAP CL - Interfaces3INTERFACEABAP interfacenvarchar300
3/XFT/REG_SETYJISETY - JAVA CL - Interfaces3INTERFACEJava interfacentext10737418230
4CLB2C_PTYPE_CFCollaboration: Factory Classes2INTERFACECollaboration: Interfacenvarchar400
5SRT_UDS_CONFIGUser defined search: config with only one table layout2INTERFACEWSP Name of Interface Objectnvarchar300
6SRT_UDS_CONFIG_MUser defined search: mapping external to internal names2INTERFACEObject namenvarchar300
7TILMSTOR_CFILM DB Store: Class Factory2INTERFACEILM Storage: Interfacenvarchar300
8TXMI_USAGEInformation About Activities of XMI Tools3INTERFACEInterface ID (for example, XBP)nvarchar30
9/BOBF/CONF_GENGeneration table4INTERFACENamenvarchar300
TOPAccounting Interface
10DCFLC_STEP_IFDecoupling: Interfaces for Steps3INTERFACEObject Type Namenvarchar300
TOPArchiveLink
11OAPRISAP ArchiveLink: Temporary table for print parameters38INTERFACEArchiving Parameter: Communication Connection Componentnvarchar140
12TOAARCommunications configuration table for storage system2INTERFACESAP ArchiveLink: Name of communication connection componentnvarchar140
TOPArchiving Connector ABAP
13ARCHLNK_TOAARCopied TOAAR from Legacy Systems to be Decommissioned2INTERFACESAP ArchiveLink: Name of communication connection componentnvarchar140
TOPBackground Processing
14TBTCPBackground Job Step Overview57INTERFACEArchiving Parameter: Communication Connection Componentnvarchar140
TOPBank Customer Accounts
15/FSCAA/IF_CLASSRelation Interfaces and Classes1INTERFACEObject Type Namenvarchar300
TOPBasis-Related Help Functions, Appl. Log, Formula Intepreter
16TBE01Library of the Publish&Subscribe Business Transaction Events2INTERFACEName of Sample Function Modulenvarchar300
17TPS01Library of the Process Business Transaction Events2INTERFACEName of Sample Function Modulenvarchar300
TOPBatch-Oriented Parallel Processing of Mass Data
18TBANK_CLIFInterface Methods for a Class (Function Module)2INTERFACEKey of an Interfacenvarchar40
19TBANK_IFDEFInterface for Process Flow Control1INTERFACEKey of an Interfacenvarchar40
20TBANK_IFDEFTInterface Description1INTERFACEKey of an Interfacenvarchar40
21TBANK_IFMETHMethods per Interface1INTERFACEKey of an Interfacenvarchar40
22TBANK_IFMETHTMethod text1INTERFACEKey of an Interfacenvarchar40
TOPBRFplus - ABAP-Based Business Rules
23FDT_ACTN_1100FDT: Action - Static method call8INTERFACEObject Type Namenvarchar300
24FDT_ACTN_1100AFDT: Action - Static method call8INTERFACEObject Type Namenvarchar300
25FDT_ACTN_1100SFDT: Action - Static method call7INTERFACEObject Type Namenvarchar300
26FDT_ACTN_1100TFDT: Action - Static method call7INTERFACEObject Type Namenvarchar300
27FDT_EXPR_1500FDT: Expression - Static Method Call Class8INTERFACEObject Type Namenvarchar300
28FDT_EXPR_1500AFDT: Expression - Static Method Call Class8INTERFACEObject Type Namenvarchar300
29FDT_EXPR_1500SFDT: Expression - Static Method Call Class7INTERFACEObject Type Namenvarchar300
30FDT_EXPR_1500TFDT: Expression - Static Method Call Class7INTERFACEObject Type Namenvarchar300
31FDT_EXTY_0000FDT: Expression Type Data5INTERFACEObject Type Namenvarchar300
32FDT_EXTY_0000AFDT: Expression Type Data5INTERFACEObject Type Namenvarchar300
33FDT_EXTY_0000SFDT: Expression Type Data4INTERFACEObject Type Namenvarchar300
34FDT_EXTY_0000TFDT: Expression Type Data4INTERFACEObject Type Namenvarchar300
35SFBMHDRFormula Builder Methods: Header3INTERFACEInterface namenvarchar300
TOPBusiness Configuration Tools Runtime
36SC2_IPG_NODEC2: Inactive Node Generation Details3INTERFACEObject Type Namenvarchar300
37SC2_PGL_NODEC2 Server: (Old) Node Generation Details (Interface)4INTERFACEInterface Name for BC Service Interfacenvarchar300
38SC2_PG_NODEC2 Server: Node Generation Details4INTERFACEInterface Name for BC Service Interfacenvarchar300
TOPBusiness Object Builder
39SWOTDIDefinition Interfaces2INTERFACEInterfacenvarchar100
40SWOTLIObject Load Interfaces2INTERFACEInterfacenvarchar100
TOPBusiness Planning and Simulation
41UPWB_CLASSESTable of Class Descriptors6INTERFACEObject Type Namenvarchar300
TOPBusiness Rule Framework
42BRFMIG_ICLCMaintenance: Assignment of Interfaces f.Implementing Classes1INTERFACEInterface for Migration Objectnvarchar300
43BRFMIG_ICLSMaintenance: Assignment of Interfaces f.Implementing Classes1INTERFACEInterface for Migration Objectnvarchar300
TOPClaims Management
44ICL_CCIMPLCLASSICL: Customizing Interfaces for Implementing Classes2INTERFACEInterface for ICL Objectnvarchar300
45ICL_CIMPLCLASSMaint.:Assignment of Interfaces to Classes To Be Implemented1INTERFACEInterface for ICL Objectnvarchar300
46ICL_CMAP_CFAMaintenance: Mapping Tool: Field Assignment2INTERFACEInterface Keynvarchar100
47ICL_CMAP_CFATMaintenance: Field Assignment (Texts)3INTERFACEInterface Keynvarchar100
48ICL_CMAP_CFATFMaintenance: Field/Target Field Assignment2INTERFACEInterface Keynvarchar100
49ICL_CMAP_CFATSMaintenance: Field - Target Structure Assignment2INTERFACEInterface Keynvarchar100
50ICL_CMAP_CINTFAMaintenance: Interface2INTERFACEInterface Keynvarchar100
51ICL_CMAP_CINTFATMaintenance: Interface (Texts)3INTERFACEInterface Keynvarchar100
52ICL_CMAP_CTSMaintenance: Target Structure2INTERFACEInterface Keynvarchar100
53ICL_CMAP_CTSASSMaintenance: Assign Source/Target Structure2INTERFACEInterface Keynvarchar100
54ICL_CMAP_CVAMaintenance: Value Assignment2INTERFACEInterface Keynvarchar100
55ICL_CMAP_CVASVMaintenance: Assign Sourche/Target Field2INTERFACEInterface Keynvarchar100
56ICL_CMAP_CVASVTMaintenance: Assign Source Values (Texts)3INTERFACEInterface Keynvarchar100
57ICL_CMAP_CVATMaintenance: Value Assignment (Texts)3INTERFACEInterface Keynvarchar100
58ICL_CMAP_INTFAMaintenance: Interface1INTERFACEInterface Keynvarchar100
59ICL_CMAP_INTFATMaintenance: Interface (Texts)2INTERFACEInterface Keynvarchar100
60ICL_CMAP_SFAMaintenance: Field Assignment1INTERFACEInterface Keynvarchar100
61ICL_CMAP_SFATMaintenance: Field Assignment (Texts)2INTERFACEInterface Keynvarchar100
62ICL_CMAP_SFATFMaintenance: Field/Target Field Assignment1INTERFACEInterface Keynvarchar100
63ICL_CMAP_SFATSMaintenance: Field/Target Structure Assignment1INTERFACEInterface Keynvarchar100
64ICL_CMAP_STSMaintenance: SAP Target Structure1INTERFACEInterface Keynvarchar100
65ICL_CMAP_STSASSMaintenance: Target/Source Structure Assignment1INTERFACEInterface Keynvarchar100
66ICL_CMAP_SVAMaintenance: Field Assignment1INTERFACEInterface Keynvarchar100
67ICL_CMAP_SVASVMaintenance: Target/Source Value Assignment1INTERFACEInterface Keynvarchar100
68ICL_CMAP_SVASVTMaintenance: Value Assignment (Texts)2INTERFACEInterface Keynvarchar100
69ICL_CMAP_SVATMaintenance: Value Assignment (Texts)2INTERFACEInterface Keynvarchar100
TOPCommunication Channel
70ICI_CCS_INFOStores CCS info shared by Soap processing and RFC Call6INTERFACECCS CHAR255nvarchar2550
TOPContract Billing
71EMDUSDIFACEHEADTime-of-Use Interface2INTERFACETime-of-Use Interfacenvarchar100
72EMDUSDIFACEHEADTText Table for TOU Interface2INTERFACETime-of-Use Interfacenvarchar100
73EMDUSDIFASSINFormula Allocation for Input Parameters2INTERFACETime-of-Use Interfacenvarchar100
74EMDUSDIFASSOUTFormula Allocation for Output Parameters2INTERFACETime-of-Use Interfacenvarchar100
75EMDUSDIFDAYGRPDay Group of TOU Interface2INTERFACETime-of-Use Interfacenvarchar100
76EMDUSDIFDAYGRPTText for Day Group of TOU Interface2INTERFACETime-of-Use Interfacenvarchar100
77EMDUSDIFEXDAYException Days of TOU Interface2INTERFACETime-of-Use Interfacenvarchar100
78EMDUSDIFEXDAYTText Table for Exception Days of TOU Interface2INTERFACETime-of-Use Interfacenvarchar100
79EMDUSDIFRESResult Parameters of TOU Interface2INTERFACETime-of-Use Interfacenvarchar100
80EMDUSDIFRESTText Table for Result Parameters of TOU Interface2INTERFACETime-of-Use Interfacenvarchar100
81EMDUSDIFTIMETABTOU Formulas of TOU Interface2INTERFACETime-of-Use Interfacenvarchar100
82EMDUSDIFTIMETABTText Table for TOU Periods2INTERFACETime-of-Use Interfacenvarchar100
83EMDUSDIFTOUTABTOU Periods of TOU Interface2INTERFACETime-of-Use Interfacenvarchar100
84EMDUSDIFTOUTABTText for TOU Period2INTERFACETime-of-Use Interfacenvarchar100
85EMDUSDRQITEMSubrequest for Request22INTERFACETime-of-Use Interfacenvarchar100
86ETRFRTPTOU Interfaces for Rate4INTERFACETime-of-Use Interfacenvarchar100
TOPControlling
87QISRSCENARIOBasic Scenario Data27INTERFACEInterfacenvarchar300
88QISRTEMPLATETemplate for Basic Data5INTERFACEInterfacenvarchar300
TOPCross-Application Components
89FRE_INTERFACESSAP F&R Connection Interfaces1INTERFACEInterfaces for SAP F&R Connectivitynvarchar30
90FRE_INTERFACES_TTexts on SAP F&R Connection Interfaces1INTERFACEInterfaces for SAP F&R Connectivitynvarchar30
91FRE_MSG_OPTIONSMaintain Minimum Message Type for User Interface Logging2INTERFACEInterfaces for SAP R/3 Connection to SAP F&Rnvarchar30
92FRE_UI_MSGF&R CON R/3 - Exception Messages for User Interface2INTERFACEInterfaces for SAP R/3 Connection to SAP F&Rnvarchar30
93J_5KFH_CLFORMCMPLegal forms in company8INTERFACEName of Form Objectnvarchar300
TOPCustomer Enhancements
94ENHCROSSCross Reference for ENH Object21INTERFACEABAP Program Namenvarchar400
TOPCustomer Interaction Center
95CCMIFIMPLClasses that implement different modules of the CIC1INTERFACEInterface namenvarchar300
96CCMIFIMPLNEWImplementaion of Interfaces in CIC environment2INTERFACEInterface namenvarchar300
TOPDistributed System Landscape
97/ISDFPS/XI_IFALE Objects - Priority Category Assignments6INTERFACESender/Receiver IDnvarchar300
TOPE-Recruiting
98T77RCF_CS_CHANOutput Channel for Correspondence4INTERFACEInterface Namenvarchar300
TOPEmployee Self-Service
99T77WWW_LE_EPProvider Configuration for External Services3INTERFACEChar 20nvarchar200
TOPEnd User Technology
100RSRA_PACKAGEScheduling Packages for the Report Agent43INTERFACEArchiving Parameter: Communication Connection Componentnvarchar140
TOPeXternal Management Interface Framework
101BAPIXMLOGRBAPI XMI: Logon information on actions of external mgt tools7INTERFACEInterface ID (for example, XBP)nvarchar30
102TXMILOGRAWLog Information on Actions of External Management Tools7INTERFACEInterface ID (for example, XBP)nvarchar30
TOPFinancials
103FINPRCTABDERIVAssignment Table for Table Type of Prices7INTERFACEObject Type Namenvarchar300
TOPForms Processing
104FPCONTEXTForm Objects: Context4INTERFACEName of Form Objectnvarchar300
105FPINTERFACEForm Objects: Interface10INTERFACEimage21474836470
TOPGeneral Ledger Accounting
106FAGL_FIELD_MOVEConversion Table for Fixed Fields of General Ledger3INTERFACEInterface to flexible general ledgernvarchar20
107FAGL_FIELD_MOVECConversion Table for Customer Fields of General Ledger3INTERFACEInterface to flexible general ledgernvarchar20
108FAGL_SCEN_FIELDSFields of a Scenario for General Ledger Accounting2INTERFACEInterface to flexible general ledgernvarchar20
109T886GFlexible general ledger: Interface information3INTERFACEInterface to flexible general ledgernvarchar20
110T888GCustomer fields for flexible general ledger3INTERFACEInterface to flexible general ledgernvarchar20
TOPInformation Consistency
111SIC_NORM_ANORMRIVariables for Attribute Normalizing Rules5INTERFACEVariable is Interface Variablenvarchar10
112SIC_NORM_CONDRUIVariables of Conditional Rules5INTERFACEVariable is Interface Variablenvarchar10
TOPIntegration Engine
113SXMSINTERFACESender/Receiver Definition2INTERFACESender/Receiver IDnvarchar300
114SXMS_BCONF_SPECSpecific Packaging Configuration3INTERFACESender/Receiver IDnvarchar300
115SXMS_EOIO_VIOLException Handling in EOIO Processing4INTERFACESender/Receiver IDnvarchar300
116SXMS_VIOL_LOGException Handling in EOIO Processing6INTERFACESender/Receiver IDnvarchar300
TOPLaunchpad
117APB_ISR_CUST_VRSScenario and Version Customizing7INTERFACEForm Interfacenvarchar300
TOPLocalization
118J_3R_CLFORMCMPLegal forms in company8INTERFACEPDF-Based Forms: Interface Namenvarchar300
TOPMaterial Master
119WER_ACT_MC_AAction method call class and method (Customers)6INTERFACEObject Type Namenvarchar300
120WER_ACT_MC_SAction method call class and method5INTERFACEObject Type Namenvarchar300
121WER_EXP_MC_AExpression method call class and method (Customers)6INTERFACEObject Type Namenvarchar300
122WER_EXP_MC_SExpression method call class and method5INTERFACEObject Type Namenvarchar300
TOPOLAP Technology
123RRT_MDX_FUNCTIONMDX functions rowset4INTERFACEInterfacenvarchar300
TOPPersonnel Cost Planning and Simulation
124T77HCP_IFATMethod Implementation Attributes2INTERFACEData Collection Methodnvarchar40
125T77HCP_IFPAAssignment of Parameters to Method Implementations1INTERFACEData Collection Methodnvarchar40
126T77HCP_IFPCParameter Attributes for Each Method Implementation2INTERFACEData Collection Methodnvarchar40
127T77HCP_INTFMethod Implementations Personnel Cost Planning1INTERFACEData Collection Methodnvarchar40
128T77HCP_INTF_TMethod Parameter Texts2INTERFACEData Collection Methodnvarchar40
TOPPersonnel Time Management
129T7TIM_CFUNCTIONSCustomer Implementation of Time Evaluation Functions4INTERFACEObject Type Namenvarchar300
130T7TIM_CONTEXTSEntity Table for Partial Contexts1INTERFACEObject Type Namenvarchar300
131T7TIM_COPERASCustomer Implementation of Time Evaluation Operations5INTERFACEObject Type Namenvarchar300
132T7TIM_FUNCTIONSImplementation of Time Evaluation Functions and Interfaces3INTERFACEObject Type Namenvarchar300
133T7TIM_NAT_IFNative Interfaces1INTERFACEInterface namenvarchar300
134T7TIM_NAT_IF_CMPNative Interface Attributes1INTERFACEInterface namenvarchar300
135T7TIM_OPERATIONSImplementation of Time Evaluation Operation and Interface4INTERFACEObject Type Namenvarchar300
136TPT_EVENTATTRPair Formation: Characteristics of Time Event Types2INTERFACEInterface Assignmentnvarchar10
TOPProduct Data Management
137CONVERTERInformation about access to installed converter5INTERFACEInterface for conversionnvarchar20
TOPProduction and Revenue Accounting
138OIUT2_INTERFACEObsolete: Interface settings2INTERFACEInterface Namenvarchar400
139OIUXI_INTERFACEXI Interface settings2INTERFACEInterface Namenvarchar400
TOPRegulatory reporting for insurance companies
140ISSR_IFFIAS_OLDInterface: Steuerungstabelle für Feldzuordnung1INTERFACEBezeichnung der Eingangsschnittstellenvarchar150
141ISSR_MACVFIASISSR: Converter Steuerungstabelle für Feldzuordnung2INTERFACEBezeichnung der Eingangsschnittstellenvarchar150
142TISSR_READ_FISLISSR: Zuordn.Umsetzungsstrukt.zur MW-Var wg.Lesen FISL-EP5INTERFACEBezeichnung der Eingangsschnittstellenvarchar150
TOPRemaining Beverage - Obsolete Objects
143/BEV3/CHCTEVPERMEvents permissible in and supported by contract handling3INTERFACEName of Sample Function Modulenvarchar300
TOPRevenue
144OIUE2_ESCH_MDDProc 2.0 - Escheat - Mass Due Diligence Print Info9INTERFACEArchiving Parameter: Communication Connection Componentnvarchar140
TOPRisk Analysis
145JBRANTYPERM: Evaluation Category (Internal for Program Generation)4INTERFACERM: Generate Interface Programnvarchar10
TOPRoyalty Reporting
146OIUREP_2014_REPMMS-2014 - Supplemental Reports From Report Executions41INTERFACEArchiving Parameter: Communication Connection Componentnvarchar140
TOPServices
147FINB_PR_TIMPLImplementations2INTERFACEObject Type Namenvarchar300
TOPStreamWork ABAP Library
148CLBC_PTYPE_CFCollaboration: Factory Classes2INTERFACECollaboration: Interfacenvarchar400
TOPTransport Organizer
149HOTPACKEXCException List for Support Package Creation7INTERFACEFlag (X or Blank)nvarchar10
TOPWeb Screen Tools - ABAP
150WDY_UI_INTERFACEWeb Dynpro: Marker Interface2INTERFACEWeb Dynpro: Name of View Element Aggregationnvarchar300
151WDY_UI_INTF_IMPLWeb Dynpro : Marker Interface Implementation4INTERFACEWeb Dynpro: Name of View Element Aggregationnvarchar300
TOPWeb Service and SOAP - ABAP
152SRT_MONI_PAYLTRCSOAP Runtime Table for Payload Trace6INTERFACESOAP Runtime Interface Name (Internal Name)nvarchar300
153SRT_TEST_PERFResults of the SRT Performance Tests10INTERFACEnvarchar2550
TOPWork Clearance Management
154WCCTCWCM: Grouping (Additional Data)3INTERFACEAdditional Datanvarchar20