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

180 columns | Print definition?ERP 6.0  | OBJAP

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1CFAFOIACT_DETL_2FO Integration: Selection of Details (Risk Category)2OBJAPApplication Object for Integration of FO into TRMnvarchar40
TOPBusiness Partner
2CCXO_CHANNEL_BDTDefinition of Channel for Business Data Toolset (BDT)2OBJAPBDT: Application Objectnvarchar40
3CEXO_CHANNEL_BDTDefinition of Channel for Business Data Toolset (BDT)2OBJAPBDT: Application Objectnvarchar40
4TP23SControl Table for Differentiation Type Criterion2OBJAPBDT: Application Objectnvarchar40
5TPR10Partner Object Rel. Assign. BDT Application to Appl. Cat.2OBJAPBDT: Application Objectnvarchar40
6TPZ24BP Role Assignment4OBJAPBDT: Application Objectnvarchar40
7TPZ24TBP Role Assignment Text5OBJAPBDT: Application Objectnvarchar40
8TPZ40Protected Applications2OBJAPBDT: Application Objectnvarchar40
9TPZ41Use of Protected Applications2OBJAPBDT: Application Objectnvarchar40
TOPClaims Management
10TICL106Assignment Data Set - Claim Subobject Category2OBJAPBDT: Application Objectnvarchar40
11TICL107FS-CM: BDT Screen Fields -> Internal GUI Structure Fields2OBJAPBDT: Application Objectnvarchar40
12TICLSRCSettings for BDT Search3OBJAPBDT: Application Objectnvarchar40
13TIGN220Search8OBJAPBDT Application Object for Searchnvarchar40
TOPContract Accounts Receivable and Payable
14CFC_ACTIONLOGAction Log of Status and Processing Status Changes2OBJAPCFC: Clarification controller: Application objectnvarchar40
15CFC_APPLCTSCFC: Applications2OBJAPCFC: Clarification controller: Application objectnvarchar40
16CFC_APPLCTS_TXTCFC: Applications: Texts3OBJAPCFC: Clarification controller: Application objectnvarchar40
17CFC_APPLOBJCFC: Application objects2OBJAPCFC: Clarification controller: Application objectnvarchar40
18CFC_APPLOBJ_TXTCFC: Application objects: Texts3OBJAPCFC: Clarification controller: Application objectnvarchar40
19CFC_APPL_FCODESApplication-Specific GUI Function Codes2OBJAPCFC: Clarification controller: Application objectnvarchar40
20CFC_EVENT_FCTCFC events -> Function modules assignment2OBJAPCFC: Clarification controller: Application objectnvarchar40
21CFC_ITEM_STATECFC: Status of the application table entries2OBJAPCFC: Clarification controller: Application objectnvarchar40
22CFC_ITEM_STATE_TCFC: Status of the application table entries (texts)3OBJAPCFC: Clarification controller: Application objectnvarchar40
23CFC_IT_WORKSTATEClarification Case Processing Status2OBJAPCFC: Clarification controller: Application objectnvarchar40
24CFC_LOCKSCFC: Lock table for application items (generic key)2OBJAPCFC: Clarification controller: Application objectnvarchar40
25CFC_ROLESCFC: Roles for application objects2OBJAPCFC: Clarification controller: Application objectnvarchar40
26CFC_SCREEN_VARSMaster Screen Layout Variants2OBJAPCFC: Clarification controller: Application objectnvarchar40
27CFC_SELFIELDSCFC: Selection fields of the application2OBJAPCFC: Clarification controller: Application objectnvarchar40
28CFC_WORKSTATE_TClarification Case Processing State (Texts)3OBJAPCFC: Clarification controller: Application objectnvarchar40
29DFKKMDUGPMaster Data Lot: Items of the Groups of a Lot7OBJAPApplication Objectnvarchar40
30DFKKNRPENOC Returns Lot: Error Messages for Items4OBJAPApplication Objectnvarchar40
31MDU_APPLOBJMaster Data Update: Maintainable Application Objects2OBJAPApplication Objectnvarchar40
32MDU_SUBOBJMDU: Maintainable Subobjects of Application Objects2OBJAPApplication Objectnvarchar40
TOPData Quality
33USMD_DUPCHK_MODDuplicate Check Mode For Particular Data Model9OBJAPBDT Where-Used List: Application Objectnvarchar40
TOPDefault Risk and Limit System
34LMSDCIACTIntegrated Limit Check in CFM: Activation2OBJAPUse of Integrated Limit Checknvarchar40
TOPFlexible Real Estate Management
35TIVCABDTSCRBDT View for All Title Elements1OBJAPBDT: Application Objectnvarchar40
36TIVCAOBJAPREOBSOLETE: Allowed BDT Objects RE-FX2OBJAPBDT: Application Objectnvarchar40
TOPGlobal Trade Services
37/SAPSLL/TPABPLegal & Logistics Services: Business Partner - Control2OBJAPBDT: Application Objectnvarchar40
TOPIncentive and Commission Management ICM
38TCACS_ASSGN1Assignment Table - Commission Application <-> BDT Subobjects3OBJAPBDT: Application Objectnvarchar40
39TCACS_CSD001Dispatcher for Commission Interface: Control Table3OBJAPBDT: Application Objectnvarchar40
40TCACS_FITYPDispatcher of Commission Interface: Filter Information Types3OBJAPBDT: Application Objectnvarchar40
41TCACS_FITYPTDispatcher of Commission Interface: Filter Information Types4OBJAPBDT: Application Objectnvarchar40
42TCACS_TMPL_EBExclude Field Groups for Contract Bundle Template4OBJAPBDT: Application Objectnvarchar40
43TCACS_TMPL_EXExclude Field Groups for Contract Template4OBJAPBDT: Application Objectnvarchar40
44TCACS_TMPL_TBField Group Texts for TCACS_TMPL_EB (Bundle)3OBJAPBDT: Application Objectnvarchar40
45TCACS_TMPL_TVTexts - Field Groups for TCACS_TMPL_EX (Contract)3OBJAPBDT: Application Objectnvarchar40
TOPRisk Analysis
46CFAFOIACTFO Integration - Activation2OBJAPApplication Object for Integration of FO into TRMnvarchar40
47CFAFOIACT_DETAILFO Integration: Selection of Details2OBJAPApplication Object for Integration of FO into TRMnvarchar40
48CFAFOIACT_DETL_1FO Integration: Selection of Details (Valuation Area)2OBJAPApplication Object for Integration of FO into TRMnvarchar40
TOPSAP Business Partner
49BUPA_IFC_CALL_FUDetermining Function Modules for Data Exchange: BP3OBJAPData Exchange: Application Objectnvarchar40
50COM_BUPA_CALL_FUDetermining Function Modules for Data Exchange: BP3OBJAPData Exchange: Application Objectnvarchar40
51CRMC_BUT_CALL_FUDetermining Function Modules for Data Exchange: BP3OBJAPData Exchange: Application Objectnvarchar40
52TB018BDT Object Usage: Variants2OBJAPBDT: Application Objectnvarchar40
53TB018TBDT Object Usage: Variants, Texts3OBJAPBDT: Application Objectnvarchar40
54TB018VBDT Object Usage: Variant Table2OBJAPBDT: Application Objectnvarchar40
55TB019ABDT Object Usage: Assign Context-View Variant2OBJAPBDT Where-Used List: Application Objectnvarchar40
56TB019ATBDT Object Usage: Assign Context-View Variant3OBJAPBDT Where-Used List: Application Objectnvarchar40
57TB030BP authorization types2OBJAPBDT: Application Objectnvarchar40
58TB030TBP Authorization Types: Texts3OBJAPBDT: Application Objectnvarchar40
59TB031BP Field Groups for Authorization2OBJAPBDT: Application Objectnvarchar40
60TB040BDT: Database Tables of Evaluation2OBJAPBDT: Application Objectnvarchar40
61TB040BBDT: Link Tables for Indirect Join Relationships2OBJAPBDT: Application Objectnvarchar40
62TB040FBDT: Selection and Display Fields of Evaluation2OBJAPBDT: Application Objectnvarchar40
63TB041BP: Entry Variants for Evaluation Generator2OBJAPBDT: Application Objectnvarchar40
64TB041TBP: Texts for Variants of Evaluation Generator3OBJAPBDT: Application Objectnvarchar40
65TB044(Obsolete!) Business Partner Roles: Properties2OBJAPBDT: Application Objectnvarchar40
66TB044T(Obsolete!) Business Partner Roles: Properties, Texts3OBJAPBDT: Application Objectnvarchar40
67TB049Appointment Rules: Schedule Types2OBJAPBDT: Application Objectnvarchar40
68TB049TAppointment Rules: Texts for Schedule Types3OBJAPBDT: Application Objectnvarchar40
69TB050Screen Config. (Obsolete from Second Edition VCT)2OBJAPBDT: Application Objectnvarchar40
70TB050_SScreen Configuration (Shadow Table) (Obsolete)3OBJAPBDT: Application Objectnvarchar40
71TB060BDT: Transaction Entry2OBJAPBDT: Application Objectnvarchar40
72TB060RBDT: Transaction Entry Via Search Screen for Object Parts2OBJAPBDT: Application Objectnvarchar40
73TB102SAP BP Field Grouping, Client-Specific2OBJAPBDT: Application Objectnvarchar40
74TB102_2SAP BP Field Grouping, Client-Dep. Field Group 1751 - 35002OBJAPBDT: Application Objectnvarchar40
75TB102_3SAP BP Field Grouping, Client-Dep. Field Group 3501 - 52502OBJAPBDT: Application Objectnvarchar40
76TB102_4SAP BP Field Grouping, Client-Dep. Field Group 5251 - 70002OBJAPBDT: Application Objectnvarchar40
77TB103BDT: Field Grouping for each Object Part2OBJAPBDT: Application Objectnvarchar40
78TB103_2BDT: Field Grouping per Object Part Part22OBJAPBDT: Application Objectnvarchar40
79TB103_3BDT: Field Grouping per Object Part Part32OBJAPBDT: Application Objectnvarchar40
80TB103_4BDT: Field Grouping per Object Part Part42OBJAPBDT: Application Objectnvarchar40
81TB104BDT-Field grouping per external application2OBJAPBDT: Application Objectnvarchar40
82TB104_2BDT Field Grouping per External Application Part 22OBJAPBDT: Application Objectnvarchar40
83TB104_3BDT Field Grouping per External Application Part 32OBJAPBDT: Application Objectnvarchar40
84TB104_4BDT Field Grouping per External Application Part 42OBJAPBDT: Application Objectnvarchar40
85TB105BDT Field Grouping for each Activity Category2OBJAPBDT: Application Objectnvarchar40
86TB105_2BDT Field Grouping per Activity Category Part 22OBJAPBDT: Application Objectnvarchar40
87TB105_3BDT Field Grouping per Activity Category Part 32OBJAPBDT: Application Objectnvarchar40
88TB105_4BDT Field Grouping per Activity Category Part 42OBJAPBDT: Application Objectnvarchar40
89TBZ0BDT Object Parts2OBJAPBDT: Application Objectnvarchar40
90TBZ0ABDT Applications2OBJAPBDT: Application Objectnvarchar40
91TBZ0BBDT Applications: Texts3OBJAPBDT: Application Objectnvarchar40
92TBZ0CAssign BDT Object Part -> BDT Applications2OBJAPBDT: Application Objectnvarchar40
93TBZ0FAssign BDT Object Part -> BDT Views2OBJAPBDT: Application Objectnvarchar40
94TBZ0GBDT Object Part Grouping2OBJAPBDT: Application Objectnvarchar40
95TBZ0HBDT Object Part Grouping: Texts3OBJAPBDT: Application Objectnvarchar40
96TBZ0IAssign BDT Object Part Grouping-> BDT Object Parts2OBJAPBDT: Application Objectnvarchar40
97TBZ0JAssign BDT Object Part Grouping -> BDT Screen Sequences2OBJAPBDT: Application Objectnvarchar40
98TBZ0MBDT Activities2OBJAPBDT: Application Objectnvarchar40
99TBZ0NBDT Activities: Texts3OBJAPBDT: Application Objectnvarchar40
100TBZ0OBDT Field Grouping for Each Activity (Control)2OBJAPBDT: Application Objectnvarchar40
101TBZ0O_2BDT Field Grouping per Activity (Control) Part 22OBJAPBDT: Application Objectnvarchar40
102TBZ0O_3BDT Field Grouping per Activity (Control) Part 32OBJAPBDT: Application Objectnvarchar40
103TBZ0O_4BDT Field Grouping per Activity (Control) Part 42OBJAPBDT: Application Objectnvarchar40
104TBZ0QBDT Data Sets2OBJAPBDT: Application Objectnvarchar40
105TBZ0RBDT Data Sets: Texts3OBJAPBDT: Application Objectnvarchar40
106TBZ0SBDT Object Part -> BDT Data Sets Assignment2OBJAPBDT: Application Objectnvarchar40
107TBZ0TBDT Object Parts: Texts3OBJAPBDT: Application Objectnvarchar40
108TBZ0UAssign BDT Object Part -> BDT Screen Sequences2OBJAPBDT: Application Objectnvarchar40
109TBZ1BDT Application Objects2OBJAPBDT: Application Objectnvarchar40
110TBZ1CAssign BDT Screen Fields -> BDT Database Fields2OBJAPBDT: Application Objectnvarchar40
111TBZ1DBDT Setting Transactions2OBJAPBDT: Application Objectnvarchar40
112TBZ1EBDT Application Transactions2OBJAPBDT: Application Objectnvarchar40
113TBZ1FAssign BDT Events -> Function Modules4OBJAPBDT: Application Objectnvarchar40
114TBZ1GAssign BDT Application Object-> BDT Differentiation Type2OBJAPBDT: Application Objectnvarchar40
115TBZ1HBDT Tables2OBJAPBDT: Application Objectnvarchar40
116TBZ1IBDT-External applications2OBJAPBDT: Application Objectnvarchar40
117TBZ1JBDT-External applications: Texts3OBJAPBDT: Application Objectnvarchar40
118TBZ1KAssign BDT Direct Input Fields -> BDT Database Fields2OBJAPBDT: Application Objectnvarchar40
119TBZ1TBDT Application Objects: Texts3OBJAPBDT: Application Objectnvarchar40
120TBZ3BDT Screen Sequences2OBJAPBDT: Application Objectnvarchar40
121TBZ3ABDT Screens2OBJAPBDT: Application Objectnvarchar40
122TBZ3A_GENBDT Screens to be Regenerated2OBJAPBDT: Application Objectnvarchar40
123TBZ3A_TDBDT Screens Subscreen Containers2OBJAPBDT: Application Objectnvarchar40
124TBZ3BBDT Screens: Texts3OBJAPBDT: Application Objectnvarchar40
125TBZ3CBDT Sections2OBJAPBDT: Application Objectnvarchar40
126TBZ3DBDT Sections: Texts3OBJAPBDT: Application Objectnvarchar40
127TBZ3EBDT Views2OBJAPBDT: Application Objectnvarchar40
128TBZ3FBDT Views: Texts3OBJAPBDT: Application Objectnvarchar40
129TBZ3GBDT-Views: Further checks2OBJAPBDT: Application Objectnvarchar40
130TBZ3HAssign BDT Section -> BDT View2OBJAPBDT: Application Objectnvarchar40
131TBZ3IAssign BDT Screen -> BDT Sections2OBJAPBDT: Application Objectnvarchar40
132TBZ3JBDT: Field Groups Additional FMOD2 Modules2OBJAPBDT: Application Objectnvarchar40
133TBZ3KAssign BDT Screen Sequence -> BDT Screen2OBJAPBDT: Application Objectnvarchar40
134TBZ3LBDT-Screen Sequence Categories2OBJAPBDT: Application Objectnvarchar40
135TBZ3MBDT-Screen Sequence Categories: Texts3OBJAPBDT: Application Objectnvarchar40
136TBZ3NBDT-Screen Sequence Category -> BDT-Screen Seq. Assignment2OBJAPBDT: Application Objectnvarchar40
137TBZ3OBDT Field Grouping Criteria: Texts3OBJAPBDT: Application Objectnvarchar40
138TBZ3QBDT Field Grouping Criteria2OBJAPBDT: Application Objectnvarchar40
139TBZ3RAssign BDT Field Group -> BDT Field2OBJAPBDT: Application Objectnvarchar40
140TBZ3R_BDAssign BDT Field Group -> BAPI Fields2OBJAPBDT: Application Objectnvarchar40
141TBZ3R_CAssign BDT Field Group -> BDT Field2OBJAPBDT: Application Objectnvarchar40
142TBZ3SAssign BDT View -> BDT Field Groups2OBJAPBDT: Application Objectnvarchar40
143TBZ3TBDT Screen Sequence Variants: Texts3OBJAPBDT: Application Objectnvarchar40
144TBZ3WBDT Field Groups2OBJAPBDT: Application Objectnvarchar40
145TBZ3XBDT Field Groups: Texts3OBJAPBDT: Application Objectnvarchar40
146TBZ4BDT GUI Functions2OBJAPBDT: Application Objectnvarchar40
147TBZ4ABDT GUI Functions: Active for Each View2OBJAPBDT: Application Objectnvarchar40
148TBZ4BBDT GUI Functions: Active per View/Screen Seq.Variant (Obs)2OBJAPBDT: Application Objectnvarchar40
149TBZ4CBDT-GUI Functions: Active per View/Screen Sequence Cat.2OBJAPBDT: Application Objectnvarchar40
150TBZ4TBDT GUI Functions: Texts3OBJAPBDT: Application Objectnvarchar40
151TBZ5BDT: Where-Used List - Structure Table2OBJAPBDT Where-Used List: Application Objectnvarchar40
152TBZ5ABDT Object Usage: Assign Context-View Variant2OBJAPBDT Where-Used List: Application Objectnvarchar40
153TBZ5ATBDT Object Usage: Assign Context-View Variant3OBJAPBDT Where-Used List: Application Objectnvarchar40
154TBZ5BBDT Where-Used List: Application Objects2OBJAPBDT Where-Used List: Application Objectnvarchar40
155TBZ5BTBDT Where-Used List: Application Object Texts3OBJAPBDT Where-Used List: Application Objectnvarchar40
156TBZ5DBDT Setting Transactions2OBJAPBDT Where-Used List: Application Objectnvarchar40
157TBZ5EBDT Object Usage: Variants2OBJAPBDT Where-Used List: Application Objectnvarchar40
158TBZ5ETBDT Object Usage: Variants, Texts3OBJAPBDT Where-Used List: Application Objectnvarchar40
159TBZ5FBDT Object Usage: Variant Table2OBJAPBDT Where-Used List: Application Objectnvarchar40
160TBZ5SBDT: Where-Used List - Transport Shadow Table2OBJAPBDT Where-Used List: Application Objectnvarchar40
161TBZ5TBDT: Where-Used List - Structure Texts3OBJAPBDT Where-Used List: Application Objectnvarchar40
162TBZ6BDT: VCT Usages2OBJAPBDT: Application Objectnvarchar40
163TBZ6SBDT: VCT Usages (Shadow Table)3OBJAPBDT: Application Objectnvarchar40
164TBZ7ABDT-DC: Wizard Declaration2OBJAPBDT: Application Objectnvarchar40
165TBZ7ATBDT-DC: Wizard Declaration - Texts3OBJAPBDT: Application Objectnvarchar40
166TBZ7BBDT-DC: Wizards - Screen Descriptions2OBJAPBDT: Application Objectnvarchar40
167TBZ7BTBDT-DC: Wizards - Screen Descriptions - Texts3OBJAPBDT: Application Objectnvarchar40
168TBZS1BDT Search Help: Tables with Alias Names2OBJAPBDT: Application Objectnvarchar40
169TBZS2BDT Search Help: Join Conditions2OBJAPBDT: Application Objectnvarchar40
170TBZS3BDT Search Help: Views2OBJAPBDT: Application Objectnvarchar40
171TBZS4BDT Search Help: Search Fields2OBJAPBDT: Application Objectnvarchar40
172TBZS5BDT Search Help: Tree of Tables Containing Search Fields2OBJAPBDT: Application Objectnvarchar40
TOPTransaction Management
173VTB_FMOD_BASICField Modification Values2OBJAPBDT: Application Objectnvarchar40
174VTB_FMOD_FTRField Modification Definition2OBJAPBDT: Application Objectnvarchar40
175VTB_FMOD_PROCESSBDT Field Grouping per Activity Category2OBJAPBDT: Application Objectnvarchar40
176VTB_FMOD_SFGZUSTField Modification at Activity Category Level2OBJAPBDT: Application Objectnvarchar40
177VTB_FMOD_SFHAARTField Modification Values2OBJAPBDT: Application Objectnvarchar40
178VTB_FMOD_SFUNKTLField Modification Values2OBJAPBDT: Application Objectnvarchar40
179VTB_PCAT_FMODBDT Field Modification per Product Category2OBJAPBDT: Application Objectnvarchar40
TOPWaste Management
180EHSWAC_ROLE_HELPCD: Role-Dependent Elementary Search Helps2OBJAPBDT: Application Objectnvarchar40