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

41 columns | Print definition?ERP 6.0  | RPLAN

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1T820FPlanning Parameters: Field Group Information2RPLANPlan parametersnvarchar80
TOPBasic Functions
2T820Planning Parameters2RPLANPlan parametersnvarchar80
3T820TPlanning Parameter Descriptions3RPLANPlan parametersnvarchar80
TOPGeneral Ledger Accounting
4FAGL_RMAP_CUSTReorganization: Object Number of the Signature Values2RPLANReorganization Plannvarchar100
5FAGL_RMAP_SAPReorganization: Object Number of the Signature Values2RPLANReorganization Plannvarchar100
6FAGL_RMAP_SIGReorganization: Object Number of the Signature Values2RPLANReorganization Plannvarchar100
7FAGL_RPACKReorganization: Package2RPLANReorganization Plannvarchar100
8FAGL_RPACKTReorganization: Package Text3RPLANReorganization Plannvarchar100
9FAGL_RPACK_LISTReorganization: Object List of the Package2RPLANReorganization Plannvarchar100
10FAGL_RPACK_RESReorganization: Package Restrictions2RPLANReorganization Plannvarchar100
11FAGL_RPLAN-Obsolete- Reorganization: Plan2RPLANReorganization Plannvarchar100
12FAGL_RPLANTReorganization: Text of the Plan3RPLANReorganization Plannvarchar100
13FAGL_RPLAN_RESReorganization: Restrictions of the Plan2RPLANReorganization Plannvarchar100
14FAGL_RSNAPSHOTReorganization: Snapshot2RPLANReorganization Plannvarchar100
15FAGL_RTRACK1Summary: Company Code Currently Affected by Reorg. and KTOSL2RPLANReorganization Plannvarchar100
TOPGeneral Ledger Reorganization
16FAGL_R_APARReorganization: Object List for Receivables and Payables2RPLANReorganization Plannvarchar100
17FAGL_R_APAR_SPLReorganization: Assignment Btwn FAGL_R_APAR and FAGL_R_SPL2RPLANReorganization Plannvarchar100
18FAGL_R_APAR_VALReorg: Values for Receivables and Payables Object List2RPLANReorganization Plannvarchar100
19FAGL_R_BLNCEReorganization: Balances to Be Transferred2RPLANReorganization Plannvarchar100
20FAGL_R_BLNCE_VALReorganization: Balances to Be Transferred - Values2RPLANReorganization Plannvarchar100
21FAGL_R_JBDISPTCHReorganization: Dispatching Jobs2RPLANReorganization Plannvarchar100
22FAGL_R_JBLASTLast Dispatching Job2RPLANReorganization Plannvarchar100
23FAGL_R_JBOBJTYObject Type for Each Dispatcher for Special Activities2RPLANReorganization Plannvarchar100
24FAGL_R_JBPARTNReorganization: Packages of a Dispatching Job to Be Executed2RPLANReorganization Plannvarchar100
25FAGL_R_JBPROCEEDReorganization: Jobs of a Dispatching Job to Be Executed2RPLANReorganization Plannvarchar100
26FAGL_R_MAP_CUSTReorganization: Object Number of the Signature Values2RPLANReorganization Plannvarchar100
27FAGL_R_MAP_SAPReorganization: Object Number of the Included SAP Fields2RPLANReorganization Plannvarchar100
28FAGL_R_OI_TRACK0Reorganization: Open Items for Inclusion4RPLANReorganization Plannvarchar100
29FAGL_R_OI_TRACK1Reorganization: Included Documents for Open Items2RPLANReorganization Plannvarchar100
30FAGL_R_PER_TRACKReorganization: Log of Changed Posting Periods2RPLANReorganization Plannvarchar100
31FAGL_R_PLReorganization Plan2RPLANReorganization Plannvarchar100
32FAGL_R_PL_ACCASSReorganization: Account Assignment Elements Used2RPLANReorganization Plannvarchar100
33FAGL_R_PL_ASSIGNReorganization: Mapping Between Old and New Acct Assignment2RPLANReorganization Plannvarchar100
34FAGL_R_PL_COUNTTracking of Different Processes of a Plan2RPLANReorganization Plannvarchar100
35FAGL_R_PL_DERHReorganization: Derivation Hierarchy of the Plan2RPLANReorganization Plannvarchar100
36FAGL_R_PL_OBJECTReorganization: Objects2RPLANReorganization Plannvarchar100
37FAGL_R_PL_OBJLSTReorganization: Object List2RPLANReorganization Plannvarchar100
38FAGL_R_PL_RES_GReorganization: General Restrictions of the Plan2RPLANReorganization Plannvarchar100
39FAGL_R_PL_RES_SReorganization: Specific Restrictions for Object Types2RPLANReorganization Plannvarchar100
40FAGL_R_PL_TReorganization: Text Table of the Reorganization Plan3RPLANReorganization Plannvarchar100
TOPProfit Center Accounting
41KE1_WU_RUNIDPCA Where-Used List: Runs19RPLANReorganization Plannvarchar100