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

33 columns | Print definition?ERP 6.0  | PERIODTYPE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1TBAC_BADI_PER_FWParameters for Period Determination of Commodity Forwards4PERIODTYPEPeriod Typenvarchar40
2TBAC_DCS_FWD_KDPPeriod table for commodity forward index5PERIODTYPEPeriod Typenvarchar40
3TBAC_DCS_KD_PRDSDCS Periods4PERIODTYPEPeriod Typenvarchar40
4TBAS_DTYPE_PTYPEAllowed Periodtypes for Derivative Category2PERIODTYPEPeriod Typenvarchar40
5TBAT_PRICE_FWDDerivative Contract Specification: Commodity Forward Prices11PERIODTYPEPeriod Typenvarchar40
TOPFinancial Accounting
6FOTETAXCSettings Electronic Data Transmission to Authorities7PERIODTYPEPeriod for Electronic Data Transmissionnvarchar20
TOPLocalization
7UKFOTVLOGAction Logs While Processing EVAT through FOTV for UK4PERIODTYPEPeriod Typenvarchar10
TOPMonitoring
8SWLN3MOIDXNon-R/3 Statistic: Index of Existing Aggregates4PERIODTYPESAP Workload: Period typenvarchar10
9SWLN3WORKLNon-R/3 Statistic: Summarized Statistic Data (Aggregates)5PERIODTYPESAP Workload: Period typenvarchar10
10SWNCCOLLPERFTOTPerformance Data of the Workload Collector4PERIODTYPESAP Workload NW Collector: Period Typenvarchar10
11SWNCMONISAP Workload NW Collector: Data Clusters5PERIODTYPESAP Workload NW Collector: Period Typenvarchar10
12SWNCMONIINDEXSAP Workload NW Collector: Data Cluster Index Table4PERIODTYPESAP Workload NW Collector: Period Typenvarchar10
TOPPerformance Monitors TCC
13SAPWLT000SAP workload: statistics data2PERIODTYPESAP Workload: Period typenvarchar10
14SAPWLT001SAP workload: Table statistics2PERIODTYPESAP Workload: Period typenvarchar10
15SAPWLT002SAP workload: RFC statistics data2PERIODTYPESAP Workload: Period typenvarchar10
TOPPersonnel Time Events
16TPTCOR_TCONSTRESS Correction Scenario: Table of Periods5PERIODTYPESpecify Periodsnvarchar10
TOPPortfolio Management
17/RPM/ITEM_DOperational item persisted data22PERIODTYPEFinancial Period Breakdownnvarchar20
18/RPM/PERIODTYPETPeriod Type Text3PERIODTYPEFinancial Period Breakdownnvarchar20
19/RPM/PERIOD_TYPEBreakdown Periods2PERIODTYPEFinancial Period Breakdownnvarchar20
20RPM_FES_ALO_DISTDistribution of Resource Assignment3PERIODTYPEResource Manager Worklist Period Breakdownnvarchar20
21RPM_FES_AVA_DISTDistribution of Resource Avaliability3PERIODTYPEResource Manager Worklist Period Breakdownnvarchar20
22RPM_FES_DEM_DISTDistribution of Role demand3PERIODTYPEResource Manager Worklist Period Breakdownnvarchar20
23RPM_ITEM_D_CDItem details - Pseudo table for change documents22PERIODTYPEFinancial Period Breakdownnvarchar20
24RPM_PROJECTProject data34PERIODTYPEPeriod Type (Weekly/Monthly/Generic Interval)nvarchar20
25RPM_RELATE_ALLBKRPM: Relationship table7PERIODTYPEPeriod Type (Weekly/Monthly/Generic Interval)nvarchar20
26RPM_RELATE_ALLOCRPM: Relationship table7PERIODTYPEPeriod Type (Weekly/Monthly/Generic Interval)nvarchar20
27RPM_REL_ALLOC_BKBack up table for RPM: Relationship table7PERIODTYPEPeriod Type (Weekly/Monthly/Generic Interval)nvarchar20
28RPM_RESOURCE_AVLProject Resource Availability7PERIODTYPEPeriod Type (Weekly/Monthly/Generic Interval)nvarchar20
29RPM_ROLE_AVLProject Role Demand7PERIODTYPEPeriod Type (Weekly/Monthly/Generic Interval)nvarchar20
30RPM_ROLE_AVL_BAKBack up table of Project Role Demand7PERIODTYPEPeriod Type (Weekly/Monthly/Generic Interval)nvarchar20
TOPResources
31DPR_BUPA_DISTDistribute Required Capacity of a Business Partner Link10PERIODTYPEPeriod Type (Weekly/Monthly/Generic Interval)nvarchar20
32DPR_PART_DISTDistribute Required Capacity to Project Role10PERIODTYPEPeriod Type (Weekly/Monthly/Generic Interval)nvarchar20
TOPStructure
33DPR_PROJECTProject Definition21PERIODTYPEPeriod Type (Weekly/Monthly/Generic Interval)nvarchar20