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

72 columns | Print definition?ERP 6.0  | APP_ID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/AIF/LAYOUTUser specified layout3APP_IDApplication IDnvarchar30
2/AIF/LAYOUT_FSUser specified layout for full screen3APP_IDApplication IDnvarchar30
3/PERSONAS/C_CLOVPersonas : Control ID overwrite rules2APP_IDPersonas : Application ID or Transaction Codenvarchar500
4/PERSONAS/C_RFCWPersonas Function Module RFC Whitelist4APP_IDPersonas : Application ID or Transaction Codenvarchar500
5/PERSONAS/C_SCOVPersonas : Screen ID overwrite rules2APP_IDPersonas : Application ID or Transaction Codenvarchar500
6/PERSONAS/FLAVORPersonas Flavor Header Data4APP_IDPersonas : Application ID or Transaction Codenvarchar500
7/PERSONAS/MIGRSLInformation about Personas 2.0 Silverlight flavors.5APP_IDPersonas : Application ID or Transaction Codenvarchar500
8/PERSONAS/ROTHASPersonas : ROle THeme ASsignments4APP_IDPersonas : Application ID or Transaction Codenvarchar500
9GHO_RULE_DATESValidity Dates for Rule2APP_IDApplication IDnvarchar50
10GHO_RULE_DETAILGeneric Rule2APP_IDApplication IDnvarchar50
11ODATA_PP_POP_UVAssignment of variant to user2APP_IDApplication IDnvarchar60
12ODATA_PP_POR_UVAssignment of variant to user2APP_IDApplication IDnvarchar60
13PPORDCNF_UVAssignment of variant to user2APP_IDApplication IDnvarchar60
14TSE00ABAP/4 Editor applications1APP_IDEDIC: Editor interfacenvarchar20
15TSE01ABAP/4 Editor application Fcodes1APP_IDEDIC: Editor interfacenvarchar20
16TSE02ABAP/4 Editor user commands1APP_IDEDIC: Editor interfacenvarchar20
17TSE03ABAP/4 Editor update functions1APP_IDEDIC: Editor interfacenvarchar20
18VBIC_APPApplication Definition table1APP_IDVisual Business Application Identifiernvarchar400
19VBIC_APP_MS_ASGNApplication Map Stack Assignments1APP_IDVisual Business Application Identifiernvarchar400
20VBIC_APP_REPLApplication replacement table2APP_IDVisual Business Application Identifiernvarchar400
TOPAssortment
21WRF_APC_PABDPlanned Article Basic Data9APP_IDApplication IDnvarchar20
TOPClinical System
22N2HIT_APPTYHL:Assignment:Obj.Type f. Hit List Object<->Application Area2APP_IDHL: Application Area of a Hit List (Key)nvarchar100
TOPDealer Portal
23/SAPDII/CAPPSETApplication Settings for Dealer Portal2APP_IDApplication IDnvarchar40
24/SAPDII/CEXTINTExternal Interface2APP_IDApplication IDnvarchar40
25/SAPDII/CIMGMANTImage Maintenance2APP_IDApplication IDnvarchar40
26/SAPDII/CUSPRMAPUser to Partner Mapping3APP_IDApplication IDnvarchar40
TOPEasy Enhancement Workbench
27AXT_RUN_RULERule Runtime3APP_IDGUIDnvarchar320
TOPGovernance, Risk and Compliance
28GRFNORGCOMPObsolete - Organiyation detail application components1APP_IDApplication Componentnvarchar100
29GRFNORGCOMPTObsolete - Organiyation detail application components1APP_IDApplication Componentnvarchar100
30GRFNROLEASSRole Assignement1APP_IDApplication Componentnvarchar100
31GRFNROLEASSCOMPRole Assignemet Components1APP_IDApplication Componentnvarchar100
32GRFNROLEASSCOMPTText of Role Assignment Component1APP_IDApplication Componentnvarchar100
33GRFNROLEASSTText of Role Assignment Component1APP_IDApplication Componentnvarchar100
TOPMaterial Master
34WRF_APPL_SETHierarchy Control Table2APP_IDApplication IDnvarchar20
35WRF_APPL_SET_TText Table for WRF_APPL_SET2APP_IDApplication IDnvarchar20
36WRF_HIER_IDHierarchy Table2APP_IDApplication IDnvarchar20
37WRF_HIER_ID_THierarchy Text2APP_IDApplication IDnvarchar20
38WRF_HIER_NODEBOXNode Container2APP_IDApplication IDnvarchar20
39WRF_HIER_NODESHierarchy Node2APP_IDApplication IDnvarchar20
40WRF_HIER_NODES_TNode Texts2APP_IDApplication IDnvarchar20
41WRF_HIER_OBJObjects of a Hierarchy2APP_IDApplication IDnvarchar20
42WRF_HIER_OBJBOXObject Container2APP_IDApplication IDnvarchar20
43WRF_HIER_OBJ_TObject Descriptions2APP_IDApplication IDnvarchar20
TOPVisual Business
44VBCC_APP2V2 Application Definition table1APP_IDVisual Business Application Identifiernvarchar400
45VBCC_APP_MS_ASGNV2 Application Map Stack Assignments1APP_IDVisual Business Application Identifiernvarchar400
46VBCD_APPMain Visual Business Model1APP_IDVisual Business Application Identifiernvarchar400
47VBCD_APP_OBJMain Visual Business Model XML Streams1APP_IDVisual Business Application Identifiernvarchar400
48VBCD_CONTEXTApplication Context1APP_IDVisual Business Application Identifiernvarchar400
49VBCD_CONTEXT_ENCModel context2APP_IDVisual Business Application Identifiernvarchar400
50VBCD_DOData Objects1APP_IDVisual Business Application Identifiernvarchar400
51VBCD_MOVisual Business Message Objects1APP_IDVisual Business Application Identifiernvarchar400
52VBCD_PERSONALZTNPersonalization2APP_IDVisual Business Application Identifiernvarchar400
53VBCD_TXTVisual Business Texts1APP_IDVisual Business Application Identifiernvarchar400
54VBCD_TXT_TVisual Business Texts (language dependent)2APP_IDVisual Business Application Identifiernvarchar400
55VBCD_VOVisual Objects1APP_IDVisual Business Application Identifiernvarchar400
TOPWarranty Claim Processing
56DPCOMMON_MAP_U_PUser to Partner Mapping3APP_IDApplication IDnvarchar40
TOPWeb Channel Personalisation
57WECD_PERS_USERUser Personalization3APP_IDHolds Shop IDnvarchar400
TOPWeb Service and SOAP - ABAP
58TASK_VITA_APPTable for Watcher Service Test2APP_IDUTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)decimal217
TOPWorkforce Management Application
59WFACS_APPCFGapplication configuration2APP_IDapplication idnvarchar320
60WFACS_REQACTIONSrequest actions2APP_IDapplication idnvarchar320
61WFACS_REQMNGMNTrequest management data2APP_IDapplication idnvarchar320
62WFACS_REQMNGRSregistered request managers2APP_IDapplication idnvarchar320
63WFACS_REQMSGSrequest messages: warnings, errors, etc2APP_IDapplication idnvarchar320
64WFACS_REQUESTScalculation requests2APP_IDapplication idnvarchar320
65WFACS_SOLVERSregistered calculation solvers2APP_IDapplication idnvarchar320
TOPWorkforce Management Core
66WFDCS_APPCFGapplication configuration2APP_IDapplication idnvarchar320
67WFDCS_REQACTIONSrequest actions2APP_IDapplication idnvarchar320
68WFDCS_REQMNGMNTrequest management data2APP_IDapplication idnvarchar320
69WFDCS_REQMNGRSregistered request managers2APP_IDapplication idnvarchar320
70WFDCS_REQMSGSrequest messages: warnings, errors, etc2APP_IDapplication idnvarchar320
71WFDCS_REQUESTScalculation requests2APP_IDapplication idnvarchar320
72WFDCS_SOLVERSregistered calculation solvers2APP_IDapplication idnvarchar320