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

31 columns | Print definition?ERP 6.0  | CALENDAR

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1AFWKFRA_KCFARCKey Figures: CfaR by variance/covariance6CALENDARCalendar ID for Cash Flow at Risk Calculationnvarchar20
2AFWKFRA_KCFARC_HKey Figures: CfaR by variance/covariance7CALENDARCalendar ID for Cash Flow at Risk Calculationnvarchar20
3AFWKFRA_KCFPLKey Figures: CfaR - Profit/Loss Distribution6CALENDARCalendar ID for Cash Flow at Risk Calculationnvarchar20
4AFWKFRA_KCFPL_HKey Figures: CfaR - Profit/Loss Distribution7CALENDARCalendar ID for Cash Flow at Risk Calculationnvarchar20
5FSEPA_INST_CDLocal Instrument and Lead Times for SEPA Direct Debits12CALENDARFactory calendarnvarchar20
6FTBBC_CFARTYPECash Flow at Risk Type8CALENDARCalendar ID for Cash Flow at Risk Calculationnvarchar20
7TBAC_BADI_PER_FWParameters for Period Determination of Commodity Forwards8CALENDARProvider Calendar for Commodity Forward Indexnvarchar20
8TBAC_DCS_LOFDerivative Contrac Specification for Listed Options, Futures5CALENDARPrompt Date Calendarnvarchar20
9TBAC_MICCustomizing table for Market Identification Code7CALENDARFactory calendarnvarchar20
10TFK8186RDRules for Scheduling of Rating7CALENDARFactory Calendar for Definition of Rating Datenvarchar20
11VDSEPA_DDSepa DD - Lead Time Determination11CALENDARFactory calendarnvarchar20
TOPBasic Functions
12TFTE_BSM_CUSTCustomizing: Bank Statement Monitor11CALENDARFactory Calendarnvarchar20
TOPBasic Market Data
13/BA1/TF4_EXCHDefinition of Stock Exchanges5CALENDARFactory Calendarnvarchar20
TOPBilling in Contract Accounts Receivable and Payable
14TFK8106RDRules for Scheduling of Billing7CALENDARFactory Calendar for Defining the Billing Datenvarchar20
TOPCondition
15TBKK8IWPeriods for Interest Guarantee for Offers5CALENDARYes/No Fieldnvarchar10
TOPEvent Management
16/SAPTRX/EXT_EEExtraction of Expected Events9CALENDARFactory Calendar IDnvarchar20
TOPGeneral Application Functions
17CRMD_PARTNERPartners21CALENDARMaintain Calendar for the Partner?nvarchar10
TOPHoliday Calendar, Factory Calendar, Appointment Calendar
18SCALT_CONVBeginning of Months of any Calendar with Gregorian Format2CALENDARCalendar Typenvarchar300
TOPIndustry-Specific Component Automotive
19RESKEYR3Resource Proxy ERP8CALENDARCalendar IDnvarchar20
TOPInvoicing in Contract Accounts Receivable and Payable
20TFK2606RDScheduling Rules for Invoicing7CALENDARFactory Calendar for Defining Invoicing Datenvarchar20
TOPSales-Based Rent and Settlement
21VISRTMRPRHAssignment of Frequency Rule to Reporting Rule12CALENDARCalendarnvarchar20
TOPSAP Business Workflow
22SWDSHEADERWF Definition: Basic Data8CALENDARWorkflow definition: Factory calendarnvarchar20
23SWD_HEADERWF Definition/Runtime: Basic Data9CALENDARWorkflow definition: Factory calendarnvarchar20
24SWP_HEADERWorkflow Instances: Header Data of a Workflow Execution12CALENDARWorkflow definition: Factory calendarnvarchar20
TOPTime Sheet
25TCATSCATS: Data Entry Profiles30CALENDARData Entry for Workdays onlynvarchar10
TOPTraders and Schedulers Workbench
26OIGSVTD Vehicles in Transport/Shipment22CALENDARFactory calendar IDnvarchar20
27OIGVTD Vehicle Header20CALENDARFactory calendar IDnvarchar20
28OIJ_EL_LAYT_INFLaytime terms13CALENDARFactory Calendarnvarchar20
TOPTransaction Manager
29RDPT_SETQuantity of Redemption Schedules16CALENDARFactory calendarnvarchar20
30THMHRC_HR_STRE-HA: Customizing Hedge Strategy13CALENDARFactory calendarnvarchar20
31TRCOT_CTY_PROVProvider dependent Forward Period Settings for a CO7CALENDARFactory calendarnvarchar20