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
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPCH386A/P Invoice
8OVTG52Tax Definition
9OPOR386Purchase Order
10JDT1124Journal Entry - Rows

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OVPM154Outgoing Payments
5OIVL77Whse Journal
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

174 columns | Print definition?ERP 6.0  | APPLIC

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/OPT/VIM_LIC_RIResults ICC counting4APPLICID for an appl. (for example, an IBU) for system measurementnvarchar40
2/OPT/VIM_LIC_RVResults VIM counting4APPLICID for an appl. (for example, an IBU) for system measurementnvarchar40
3/WSCGMBH/LOGSKommunikationsprotokolle5APPLICApplikationskürzelnvarchar20
4BBPD_APPLDefine EBP Applications2APPLICEBP Attribute Maintenance: Applicationsnvarchar50
5BBPD_APPL_ATLAssign Attributes to EBP Applications2APPLICEBP Attribute Maintenance: Applicationsnvarchar50
6BBPD_APPL_TTexts for EBP Applications3APPLICEBP Attribute Maintenance: Applicationsnvarchar50
7BBPD_APPL_TCLTransactions zu EBP Applications2APPLICEBP Attribute Maintenance: Applicationsnvarchar50
8CASH_AUDITCash Audit Table4APPLICID for an appl. (for example, an IBU) for system measurementnvarchar40
9DMC_CU_RUN_OBJTSObject pair for Content Upgrade Analysis15APPLICDMC Tool: Applicationnvarchar30
10DMC_DOCUMENT_TPTemplates for DMC Document Maintenance1APPLICDMC Tool: Applicationnvarchar30
11EAFI_CM_AUDITCash Audit Table4APPLICID for an appl. (for example, an IBU) for system measurementnvarchar40
12FMVALIDValidation for Funds Management3APPLICValidation/substitution application areanvarchar20
13LAW2D_TUAPPApplications for System Measurement (alphanumeric)1APPLICID for an appl. (for example, an IBU) for system measurementnvarchar40
14LAW2D_TUAPP_TName of an Application (such as an IBU) for System Meas.2APPLICID for an appl. (for example, an IBU) for system measurementnvarchar40
15T891BValidation for Special Purpose Ledger / Company Code3APPLICValidation/substitution application areanvarchar20
16T891CValidation for Special Purpose Ledger / Global Company3APPLICValidation/substitution application areanvarchar20
17T892BSubstitution for Special Purpose Ledger / Company Code3APPLICValidation/substitution application areanvarchar20
18T892CSubstitution for Special Purpose Ledger / Global Company3APPLICValidation/substitution application areanvarchar20
19TERCL3APPLICnvarchar50
20TERMC1Terminology entries, definitions3APPLICApplication ID for transaction TERMnvarchar50
21TERMC3Terminology entries, cross-references6APPLICApplication ID for transaction TERMnvarchar50
TOPALE Integration Technology
22EDIE5Assign logical address to physical destination in SAP2APPLICApplication code (MM, SD, etc.)nvarchar20
23EDILOGADRAssign logical address to physical destination (SAP)3APPLICApplication code (MM, SD, etc.)nvarchar20
TOPArchive Development Kit
24ARCH_OBJObjects for archiving and reorganization2APPLICApplication areanvarchar20
TOPAvailability Control
25BUAVCACTGRPActivity groups for availability control2APPLICApplication Component of Availability Controlnvarchar20
26BUAVCACTGRPTActivity Group Texts for Availability Control3APPLICApplication Component of Availability Controlnvarchar20
27BUAVCEVENTEvent of availability control2APPLICApplication Component of Availability Controlnvarchar20
28BUAVCEVENTTTexts for Availability Control Events3APPLICApplication Component of Availability Controlnvarchar20
29BUAVCLDGRAvailability Control Ledger8APPLICApplication Component of Availability Controlnvarchar20
30BUAVCSRCData sources for availability ledger5APPLICApplication Component of Availability Controlnvarchar20
31BUAVCTOLASSAssignment of tolerance limits for availability control2APPLICApplication Component of Availability Controlnvarchar20
32BUAVCTPROTolerance profiles for availability control2APPLICApplication Component of Availability Controlnvarchar20
33BUAVCTPROTTolerance Profile Texts for Availability Control3APPLICApplication Component of Availability Controlnvarchar20
TOPBudgeting
34BUBUDCATList of budget category instances2APPLICApplicationnvarchar20
35BUCC_LIBConsistency Checks - Library2APPLICApplicationnvarchar20
36BUCC_LIB_TLibrary Texts for Consistency Checks2APPLICApplicationnvarchar20
37BUCC_RULEConsistency Checks - Rules2APPLICApplicationnvarchar20
38BUCC_RULE_MSGConsistency Checks - Message of the rule2APPLICApplicationnvarchar20
39BUCC_RULE_OPDConsistency Checks - Operands2APPLICApplicationnvarchar20
40BUCC_RULE_TRule Texts for Consistency Checks2APPLICApplicationnvarchar20
41BUKF_CATKey Figures - Category1APPLICKey Figures - Applicationnvarchar20
42BUKF_CATDSRCKey Figures - Category/Data source relation1APPLICKey Figures - Applicationnvarchar20
43BUKF_CAT_TKey Figures - Category Texts1APPLICKey Figures - Applicationnvarchar20
44BUKF_DSRCKey Figures - Data source1APPLICKey Figures - Applicationnvarchar20
45BUKF_DSRC_FIELDKey Figures - Data source field1APPLICKey Figures - Applicationnvarchar20
46BUKF_DSRC_TKey Figures - Texts for Data Sources1APPLICKey Figures - Applicationnvarchar20
47BUKF_FGKey Figures - Field group1APPLICKey Figures - Applicationnvarchar20
48BUKF_FG_FIELDKey Figures - Fields of field group1APPLICKey Figures - Applicationnvarchar20
49BUKF_FG_TKey Figures - Texts for Field Groups1APPLICKey Figures - Applicationnvarchar20
50BUKF_FIELD_VALUEKey Figures - Data source fields checks per category1APPLICKey Figures - Applicationnvarchar20
51BUKF_KFKey Figures - Key Figure2APPLICKey Figures - Applicationnvarchar20
52BUKF_KFCATKey Figures - Key Figure/Category relation2APPLICKey Figures - Applicationnvarchar20
53BUKF_KFDSRCKey Figures - Key Figure Datasources relation2APPLICKey Figures - Applicationnvarchar20
54BUKF_KF_TKey Figures - Texts for Key Figures2APPLICKey Figures - Applicationnvarchar20
55BUKUTEXTCATBudget Text Categories1APPLICApplication for Budget Textnvarchar20
56BUKUTEXTCATTTexts for Budget Text Categories1APPLICApplication for Budget Textnvarchar20
57BUKUTEXTTEMPLTemplates for Budget Texts2APPLICApplication for Budget Textnvarchar20
58BUKUTEXTTEMPLTTexts for Budget Text Templates2APPLICApplication for Budget Textnvarchar20
59BUKUTXTTEMPLVARVariables for Budget Text Templates1APPLICApplication for Budget Textnvarchar20
60BUKUTXTTEMPLVARTTexts for Variables in Budget Text Templates1APPLICApplication for Budget Textnvarchar20
61BURBBLEDGERSLedgers for Revenue Increasing the Budget2APPLICApplicationnvarchar20
62BURBCALCRULESCalculation Formulas for Revenues Increasing the Budget2APPLICApplicationnvarchar20
63BURBCALCRULESTTexts on Calculation Rules for Revenues Increasing the Bud.2APPLICApplicationnvarchar20
64FMBUDTXTBudget texts register2APPLICApplication for Budget Textnvarchar20
65FMBUDTXT_KEYBudget Text Key Customizing2APPLICApplication for Budget Textnvarchar20
66FMCC_CUST_LIBFM - Consistency checks - Assignment of libraries5APPLICApplicationnvarchar20
67FMKF_DSRC_EVALKey Figures - Evaluation class of data source1APPLICKey Figures - Applicationnvarchar20
68FMPEP_FIELD_ATTRFMPEP: system table for field attributes handling1APPLICKey Figures - Applicationnvarchar20
TOPBusiness Object Builder
69TOJTBBusiness object repository: Basic data9APPLICApplicationnvarchar10
TOPBW Service API
70RSAPETDTLDetail Records from Extraction Trace2APPLICID for an appl. (for example, an IBU) for system measurementnvarchar40
TOPConsolidation
71TF510Validation of Consolidation Documents4APPLICValidation/substitution application areanvarchar20
TOPData Conversion
72DMC_ANWDGDMC: Applications in the Direct Input Concept2APPLICDMC Tool: Applicationnvarchar30
73DMC_APPDIPermitted DI Types for Applications3APPLICDMC Tool: Applicationnvarchar30
74DMC_ISBDMC Tool: Information about Direct Input 22APPLICDMC Tool: Applicationnvarchar30
75DMC_UDATDMC: Administration of User-Specific Settings8APPLICDMC Tool: Applicationnvarchar30
TOPDownstream
76TOI0_REL_RES_RNKRanking of Reservation relevance fields2APPLICIS-OIL application indexnvarchar40
TOPDSD Connector
77/DSD/ME_CND_TYPECondition types manual discount7APPLICManual discount conditionnvarchar10
TOPFinancials Basis
78UBC_TB_CESTYPCost Event Subtypes6APPLICID for an appl. (for example, an IBU) for system measurementnvarchar40
TOPImplementation Guide
79TPRCLASSProject Management Project Classes10APPLICApplication Area of a Project Classnvarchar60
TOPIndustry Solution Oil
80TOI0_REL_DOCPRTSelect production document types for relevance (text table)3APPLICIS-OIL application indexnvarchar40
81TOI0_REL_MM_RANKRanking of MM relevance fields2APPLICIS-OIL application indexnvarchar40
82TOI0_REL_NOM_RNKIS-OIL: Ranking of Nomination relvance fields2APPLICIS-OIL application indexnvarchar40
83TOI0_REL_PLIS-OIL: Relevance customizing for planned orders2APPLICIS-OIL application indexnvarchar40
84TOI0_REL_PL_RANKRanking of Planned Order relevance fields2APPLICIS-OIL application indexnvarchar40
85TOI0_REL_PP_RANKRanking of PP relevance fields2APPLICIS-OIL application indexnvarchar40
86TOI0_REL_SD_RANKIS-OIL: Ranking of SD relvance fields2APPLICIS-OIL application indexnvarchar40
TOPInterface to Terminal Automation System
87OIK37IS OIL: Shadow table for SD document processing6APPLICOIL Applicationnvarchar20
TOPLogistics
88TCNVAVariable overviews: Applications1APPLICVariable overviews: Applicationnvarchar40
89TCNVATVariable overviews: Texts for applications2APPLICVariable overviews: Applicationnvarchar40
90TCNVDVariable overviews: Data fields1APPLICVariable overviews: Applicationnvarchar40
91TCNVDTVariable overviews: Data field texts2APPLICVariable overviews: Applicationnvarchar40
92TCNVFVariable overviews: Displayed fields2APPLICVariable overviews: Applicationnvarchar40
93TCNVFTVariable overviews: Texts for displayed fields3APPLICVariable overviews: Applicationnvarchar40
94TCNVL"Variable overviews: List versions"2APPLICVariable overviews: Applicationnvarchar40
95TCNVLTVariable overviews: Texts for list variants3APPLICVariable overviews: Applicationnvarchar40
96TCNVOVariable overviews: Objects1APPLICVariable overviews: Applicationnvarchar40
97TCNVOTVariable overviews: Texts for objects2APPLICVariable overviews: Applicationnvarchar40
98TCNVSVariable overviews: Sub-applications1APPLICVariable overviews: Applicationnvarchar40
99TCNVSTVariable overviews: Texts for sub-applications2APPLICVariable overviews: Applicationnvarchar40
100TCNVZVariable overviews: Displayed objects (lines)2APPLICVariable overviews: Applicationnvarchar40
TOPOnline Text Repository
101OTR_BVOCOTR: Basic Vocabulary3APPLICApplication ID in Proposal Poolnvarchar20
TOPPayment Transactions
102FPRL_HEADERList Header Data10APPLICPayment Release List Application IDnvarchar100
103FPRL_ITEMItem Data10APPLICPayment Release List Application IDnvarchar100
TOPPlanning
104PSZ_KPP0SFPS CM: Cash Planning: Interface to Applic.-Specific Routines1APPLICCO: Application abbreviation (C=cost centers, O=orders, ...)nvarchar10
TOPProfit Center Accounting
105T8A10EC-PCA: Substitution for SD: Dependency3APPLICValidation/substitution application areanvarchar20
TOPProfitability Analysis
106KECRM_T8A10PCA: Substitution for CRM Integration3APPLICValidation/substitution application areanvarchar20
TOPReal Estate Management
107TIVS1Validation dates / logical field groups1APPLICValidation/substitution application areanvarchar20
108TIVSAName of logical field groups (Real Estate)2APPLICValidation/substitution application areanvarchar20
109TIVSBSubstitution for Real Estate Management / Company code3APPLICValidation/substitution application areanvarchar20
110TIVVAValidation for Real Esate Management / Company code3APPLICValidation/substitution application areanvarchar20
TOPSecure Store and Forward
111SSFAPPLICSSF Applications: Options Used1APPLICSSF Applicationnvarchar60
112SSFAPPLICTSSF Applications: Long Text2APPLICSSF Applicationnvarchar60
113SSFARGSApplication-Dependent Parameters for SSF Functions (SSFG)2APPLICSSF Applicationnvarchar60
114SSFVARGSSSF Applications with Versioned Keys1APPLICSSF Applicationnvarchar60
115SSFVARGSTSSF Applications with Versioned Keys (Texts)2APPLICSSF Applicationnvarchar60
116SSFVKEYDEFSSF Applications: Key Versions2APPLICSSF Applicationnvarchar60
TOPSecurity
117LAW_ENGINEEngine Measurement Data5APPLICID for an appl. (for example, an IBU) for system measurementnvarchar40
118LAW_ERESTotal Result: Engine Measurement Data1APPLICID for an appl. (for example, an IBU) for system measurementnvarchar40
119STRUSTSMIMS/MIME Identities of Client2APPLICS/MIME Identitynvarchar60
120STRUSTSMIMTS/MIME Identities of Client (Texts)3APPLICS/MIME Identitynvarchar60
121STRUSTSSLSSL Client Identities of System1APPLICSSL Client Identitynvarchar60
122STRUSTSSLSSSL Server Identities of the System1APPLICSSL Server Identitynvarchar60
123STRUSTSSLSTSSL Server Identities of the System (Texts)2APPLICSSL Server Identitynvarchar60
124STRUSTSSLTSSL Client Identities of System (Texts)2APPLICSSL Client Identitynvarchar60
125STRUSTWSSEWS Security Identities of the System1APPLICWS Security Identitynvarchar60
126STRUSTWSSETWS Security Identities of the System (Texts)2APPLICWS Security Identitynvarchar60
TOPTraders and Schedulers Workbench
127OIJ_EL_ELOG_SUBTSW: Error log for ticketing process at sub item22APPLICIS-OIL application indexnvarchar40
128OIJ_EL_ERROR_LOGOIL-TSW: Error log for ticketing process26APPLICIS-OIL application indexnvarchar40
129OIJ_SPRELStock projection relevance2APPLICIS-OIL application indexnvarchar40
130TOI0_JIS-OIL: Define variable junctions2APPLICIS-OIL application indexnvarchar40
131TOI0_JFUNCIS-OIL: Junction functions2APPLICIS-OIL application indexnvarchar40
132TOI0_JFUNCTIS-OIL: Junction functions texts3APPLICIS-OIL application indexnvarchar40
133TOI0_JGIS-OIL: Junction function groups2APPLICIS-OIL application indexnvarchar40
134TOI0_JGFIS-OIL: Junction function group / Function assignment2APPLICIS-OIL application indexnvarchar40
135TOI0_JGTIS-OIL: Junction function groups texts3APPLICIS-OIL application indexnvarchar40
136TOI0_JTIS-OIL: Text table for TOIJ0_J (define variable junctions)3APPLICIS-OIL application indexnvarchar40
137TOI0_REL_DOCPRSelect production document types for relevance assignment2APPLICIS-OIL application indexnvarchar40
138TOI0_REL_DOCSSelect document types for relevance assignment2APPLICIS-OIL application indexnvarchar40
139TOI0_REL_DOCTCRelevance assignments TSW TC2APPLICIS-OIL application indexnvarchar40
140TOI0_REL_DOCTCTRelevance assignments TSW TC (text table)3APPLICIS-OIL application indexnvarchar40
141TOI0_REL_MMRelevance customizing for MM Documents2APPLICIS-OIL application indexnvarchar40
142TOI0_REL_NOMIS-OIL: Relevance customizing for Nominations2APPLICIS-OIL application indexnvarchar40
143TOI0_REL_PPIS-OIL: Relevance customizing for PP Documents2APPLICIS-OIL application indexnvarchar40
144TOI0_REL_RESRelevance customizing for Reservations2APPLICIS-OIL application indexnvarchar40
145TOI0_REL_SDIS-OIL: Relevance customizing for SD Documents2APPLICIS-OIL application indexnvarchar40
146TOI0_REL_TCTSW relevance table for trading contract2APPLICIS-OIL application indexnvarchar40
147TOI0_REL_TC_RANKTSW relevance ranking for trading contract2APPLICIS-OIL application indexnvarchar40
148TOI0_REL_VALIS-Oil: Valid relevance values2APPLICIS-OIL application indexnvarchar40
149TOI0_REL_VALTIS-Oil: Relevance description3APPLICIS-OIL application indexnvarchar40
150TOIJ_IFAPO_PEGAPO SNP TSW Order transfer - Define auto pegging2APPLICIS-OIL application indexnvarchar40
151TOIJ_LAYT_RELVAssign laytime filter to relevance type2APPLICIS-OIL application indexnvarchar40
TOPTranslation Tools
152LWRKSTAOTRTranslation statistics7APPLICApplication ID in Proposal Poolnvarchar20
153LWRKSTATTranslation statistics7APPLICApplication ID in Proposal Poolnvarchar20
154TRMABBAbbreviations Table of Proposal Pool5APPLICApplication ID in Proposal Poolnvarchar20
155TRMCOMRemark Table for the Proposal Pool9APPLICApplication ID in Proposal Poolnvarchar20
156TRMINTLink Table of Proposal Pool6APPLICApplication ID in Proposal Poolnvarchar20
157TRMTRALink Table of Proposal Pool6APPLICApplication ID in Proposal Poolnvarchar20
158TRMWULTRM: TRM entry where-used list11APPLICApplication ID in Proposal Poolnvarchar20
TOPUser and Authorization Management
159TUAPPApplications (Such as HR or IS) for System Measurement1APPLICID for an appl. (for example, an IBU) for system measurementnvarchar40
160TUAPPTName of an Application (such as an IBU) for System Meas.2APPLICID for an appl. (for example, an IBU) for system measurementnvarchar40
161TUAPUSGSystem Measurement: User-Specific Use of Application3APPLICID for an appl. (for example, an IBU) for system measurementnvarchar40
162TUCNTCounters for Application Objects2APPLICID for an appl. (for example, an IBU) for system measurementnvarchar40
163TUCNTNMCounters for Application Objects for each Work Process2APPLICID for an appl. (for example, an IBU) for system measurementnvarchar40
164TUCNTNM_RAWCounters for Application Objects for each Work Process3APPLICID for an appl. (for example, an IBU) for system measurementnvarchar40
165TUCNTRAWCounters for Application Objects for each Work Process2APPLICID for an appl. (for example, an IBU) for system measurementnvarchar40
166TUJOBSystem Measurement Jobs Scheduled and Running1APPLICID for an appl. (for example, an IBU) for system measurementnvarchar40
167TULAPP_PLSystem Measurement: Price List-Dependent Applications1APPLICID for an appl. (for example, an IBU) for system measurementnvarchar40
168TUL_ACRESSystem Measurement: AC Results Table3APPLICID for an appl. (for example, an IBU) for system measurementnvarchar40
169TUL_ENG_PROTSystem Measurement: Engine Use Logs3APPLICID for an appl. (for example, an IBU) for system measurementnvarchar40
170TUL_ENG_RESULTSystem Measurement: Engine Use Logs3APPLICID for an appl. (for example, an IBU) for system measurementnvarchar40
171TUL_ENG_RESULT_1System Measurement: Engine Use Logs3APPLICSystem Measurement: Engines (Applications)nvarchar40
172TUMSGText Table for System Evaluation Messages1APPLICID for an appl. (for example, an IBU) for system measurementnvarchar40
173TUTYPPSystem Measurement: Authorizations for User Classes1APPLICID for an appl. (for example, an IBU) for system measurementnvarchar40
TOPWarranty Claim Processing
174CWTYVSActivation Table for Validation/Substitution3APPLICValidation/substitution application areanvarchar20