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

48 columns | Print definition?ERP 6.0  | APPNO

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1T77WWW_GACCHRGeneric Application Type Characteristics2APPNOSolution Typenvarchar50
2T77WWW_GACCMLGeneric Application Customize Mail Configuration2APPNOSolution Typenvarchar50
3T77WWW_GACDEFGeneric Application Definition2APPNOSolution Typenvarchar50
4T77WWW_GACDEFTGeneric Application Definition Text3APPNOSolution Typenvarchar50
5T77WWW_GACDPVGeneral Application Dependent data Visibilty Control2APPNOSolution Typenvarchar50
6T77WWW_GACHLCGeneric Application Header Fields2APPNOSolution Typenvarchar50
7T77WWW_GACHLCTText table for Generic Application Header Fields3APPNOSolution Typenvarchar50
8T77WWW_GACHLVF4 Help/Dropdown Values for Header Custom Fields: GA2APPNOSolution Typenvarchar50
9T77WWW_GACHLVTText table for F4 Help/Dropdown options for Header fields3APPNOSolution Typenvarchar50
10T77WWW_GACHRGeneric Application Type Characteristics1APPNOSolution Typenvarchar50
11T77WWW_GACMLGeneric Application Customize Mail Configuration1APPNOSolution Typenvarchar50
12T77WWW_GACMLCGeneric Application Multiple Line Fields2APPNOSolution Typenvarchar50
13T77WWW_GACMLCTText table for Generic Application Multiple Line Fields3APPNOSolution Typenvarchar50
14T77WWW_GACMLVF4 Help/Dropdown Values for Multiple Line Custom Fields: GA2APPNOSolution Typenvarchar50
15T77WWW_GACMLVTText table for F4 Help/Dropdown options for Multiple Line3APPNOSolution Typenvarchar50
16T77WWW_GACSFCStandard Field Labels and Properties2APPNOSolution Typenvarchar50
17T77WWW_GACSFCTStandard Fields Label and ToolTip3APPNOSolution Typenvarchar50
18T77WWW_GACTSRScreen Rendering Field Data2APPNOSolution Typenvarchar50
19T77WWW_GACTSRTText table for Screen Render3APPNOSolution Typenvarchar50
20T77WWW_GACTYPGeneric Application Types2APPNOSolution Typenvarchar50
21T77WWW_GACTYPTText table for Generic Application type3APPNOSolution Typenvarchar50
22T77WWW_GADEFGeneric Application Definition1APPNOSolution Typenvarchar50
23T77WWW_GADEFTGeneric Application Definition Text1APPNOSolution Typenvarchar50
24T77WWW_GADPVGeneral Application Dependent data Visibilty Control1APPNOSolution Typenvarchar50
25T77WWW_GAHLCGeneric Application Header Fields1APPNOSolution Typenvarchar50
26T77WWW_GAHLCTText table for Generic Application Header Fields2APPNOSolution Typenvarchar50
27T77WWW_GAHLVF4 Help/Dropdown Values for Header Custom Fields: GA1APPNOSolution Typenvarchar50
28T77WWW_GAHLVTText table for F4 Help/Dropdown options for Header fields2APPNOSolution Typenvarchar50
29T77WWW_GAMLCGeneric Application Multiple Line Fields1APPNOSolution Typenvarchar50
30T77WWW_GAMLCTText table for Generic Application Multiple Line Fields2APPNOSolution Typenvarchar50
31T77WWW_GAMLVF4 Help/Dropdown Values for Multiple Line Custom Fields: GA1APPNOSolution Typenvarchar50
32T77WWW_GAMLVTText table for F4 Help/Dropdown options for Multiple Line2APPNOSolution Typenvarchar50
33T77WWW_GASFCStandard Field Labels and Properties1APPNOSolution Typenvarchar50
34T77WWW_GASFCTStandard Fields Label and ToolTip2APPNOSolution Typenvarchar50
35T77WWW_GASTASolutions to be considered for approver single link3APPNOSolution Typenvarchar50
36T77WWW_GATSRScreen Rendering Field Data1APPNOSolution Typenvarchar50
37T77WWW_GATSRTText table for Screen Render2APPNOSolution Typenvarchar50
38T77WWW_GATYPGeneric Application Types1APPNOSolution Typenvarchar50
39T77WWW_GATYPTText table for Generic Application type2APPNOSolution Typenvarchar50
TOPChina
40PA0536HR Master Record: Infotype 0536 (Administration)29APPNODocument no. of appointmentnvarchar100
41PA0537HR Master Record: Infotype 0537 (Going Abroad Information)33APPNOApproval numbernvarchar100
TOPIndia
42T77WWW_GAHLPIN ESS: Tax Declaration Details2APPNOSolution Typenvarchar50
43T77WWW_GAHLP_TIN ESS: Tax Declaration Details Text Table3APPNOSolution Typenvarchar50
TOPWaste Management
44EHSWAT_APPROVALMD: Waste Approval18APPNOWaste Approval Number Assigned by Authoritynvarchar200
45EWAOBJHeader Data for Service Frequency31APPNOAuthority-Assigned Waste Approval Numbernvarchar200
46EWA_ORDER_OBJECTItem Table for Waste Disposal Order65APPNOAuthority-Assigned Waste Approval Numbernvarchar200
47EWA_WEIGH_FAVORFavorite Table of Suppliers26APPNOWaste Approval Number Assigned by Authoritynvarchar200
TOPWorkbench Utilities
48FLAPPInternal flight applications1APPNOProposal numbernvarchar80