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

36 columns | Print definition?ERP 6.0  | EBENE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/SMD/MD_____003BSID-Tabelle fuer Planning level3EBENEPlanning levelnvarchar20
2T036QAllocating Levels for T03603EBENEPlanning levelnvarchar20
3T036SPlanning Levels with Payment Blocks2EBENEPlanning levelnvarchar20
4T037Planning Types3EBENEPlanning levelnvarchar20
5T038VDistribution for Cash Mgmt Position and Liquidity Forecast2EBENEPlanning levelnvarchar20
6T074Special G/L Accounts8EBENEPlanning levelnvarchar20
7TFKSEPA_VSEPA: Visibility of Mandate Fields2EBENESEPA: Level at Which Mandate Data Is Visiblenvarchar20
8ZSKSTRUCHierachiestrauktur3EBENEEbenen in Hierarchietinyint30
TOPAutomatic Payments
9FDZACash Management line items in payment requests12EBENEPlanning levelnvarchar20
10T036RPayment Request Levels2EBENEPlanning levelnvarchar20
TOPBack Office
11TRRC_CA2TR Reporting: Assign Levels for Currency Accts for Balance2EBENEPlanning levelnvarchar20
TOPBank Components
12JBKLOBJ1Segment Table for Financial Transactions, CL Part23EBENECredit Limit: Level for Cash Management and Forecastingnvarchar20
TOPBasic Functions
13FDAUCash Managment Advice Authorization Catalog6EBENEPlanning levelnvarchar20
14FDESCash Management and Forecast: Memo Records6EBENEPlanning levelnvarchar20
15FDESDISTCash management memo records (distributed)7EBENEPlanning levelnvarchar20
16FDS1Cash Management & Forecast: Line Items of SD Documents31EBENEPlanning levelnvarchar20
17FDSBCMF summary records for G/L accounts5EBENEPlanning levelnvarchar20
18FDSB2CMF Totals Records for G/L Accounts (As of Release 604)6EBENEPlanning levelnvarchar20
19FDSBDISTCMF Summary Records for G/L Accounts (distbtd)6EBENEPlanning levelnvarchar20
20FDSRCMF summary records for planning groups4EBENEPlanning levelnvarchar20
21FDSR2CMF Totals Records for Planning Groups (As of Release 604)6EBENEPlanning levelnvarchar20
22FDSRDISTCash management totals records for planning groups (distbd)5EBENEPlanning levelnvarchar20
23T035Planning groups4EBENEPlanning levelnvarchar20
24T035ZLiquidity Forecast: Payment Date Determinations/Assignments3EBENEPlanning Level (masking possible)nvarchar20
25T036Planning levels2EBENEPlanning levelnvarchar20
26T036MLevel Assignment for Earmarked Funds3EBENEPlanning levelnvarchar20
27T036TPlanning Level Texts3EBENEPlanning levelnvarchar20
TOPFlexible Real Estate Management
28VIFLURST_HIERARLUM: Reporting - Arbeitstabelle Flurstücke nach Hierarchie4EBENEEbenetinyint30
29VIFLURST_HIERAR2LUM: Reporting - Arbeitstabelle Flurstücke nach Hierarchie4EBENEEbenetinyint30
TOPPeriodical Sales and Distribution
30TJKFProcessing Functions for Sales Order3EBENELevel in Sales Ordernvarchar10
TOPQuality Management
31TQ80_DSDigital Signature for Notifications3EBENELevel of Notification (Header Level or Task Level)nvarchar10
TOPRisk Analysis
32JBRDBKORM: DB Table Header Information Extended Risk Object17EBENECredit Limit: Level for Cash Management and Forecastingnvarchar20
33JBRHKORM: Version Table: Header Information: Extended Risk Object18EBENECredit Limit: Level for Cash Management and Forecastingnvarchar20
34JBRRHKNTNode Structure of a Risk Hierarchy5EBENERisk Factor Indicator/Node Typenvarchar10
35JBRSVKORM: Header Table of SDTFT for Saved Datasets12EBENECredit Limit: Level for Cash Management and Forecastingnvarchar20
TOPWarehouse Management
36T337CSearch Range per Level for Stock Placement Strategy K4EBENELevel as component of the storage bin coordinatenvarchar50