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

27 columns | Print definition?ERP 6.0  | ITYPE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1DMC_CWB_INCLUDESMWB: Form and Data Includes for a CWB Package2ITYPEMWB: CWB Include Typenvarchar10
2P2VE_INT_EVALHRMS-VE: Annual Interest Results9ITYPEInterest Ratenvarchar20
3T047FSorting of dunning letters7ITYPEABAP data type (C,D,N,...)nvarchar10
4T5TPENSAVData for pension savings7ITYPEItem creation typenvarchar10
5T5TPENSAV_YSPension savings - annual reporting7ITYPEItem creation typenvarchar10
6T7QAPBS32CPromotion Rule6ITYPECondition Typenvarchar10
7T7SAPBS61CPromotion Rule Setup6ITYPEMandatory or Optional Conditionnvarchar10
TOPArchive Information System
8AIND_STR1Archive Info Structures2ITYPEArchive info structure: S-> Field catalogue I-> Info struct.nvarchar10
9AIND_STR1TText of archive information structure3ITYPEArchive info structure: S-> Field catalogue I-> Info struct.nvarchar10
10AIND_STR3Archive information structure: field catalog2ITYPEArchive info structure: S-> Field catalogue I-> Info struct.nvarchar10
11AIND_STR4Achive information structure: field catalog, further fields2ITYPEArchive info structure: S-> Field catalogue I-> Info struct.nvarchar10
TOPBusiness Context Viewer
12/BCV/C_DSISData Provider InfoSets7ITYPEInfoSet Typenvarchar40
TOPCATT Computer Aided Test Tool
13CAT_DP_FLDExport fields for DataProvider5ITYPECharacter field of length 40nvarchar400
TOPCollaborative Cross Applications
14/POA/D_DEMOITEMSRelated items for Integrated Demo2ITYPEnvarchar50
TOPeCATT Extended Computer Aided Test Tool
15ECSCR_TFLDeCATT - TCD Data Provider Data DP_FLD Export Data7ITYPECharacter field of length 40nvarchar400
TOPLine Maintenance
16/ISDFPS/CLMEERRCustomizing Tab. - Graph. Avail. Check with Error Ty. Assgmt4ITYPEIntersection Typenvarchar10
TOPLocalization
17J_3RKKRSAccount correspondence line items29ITYPEInterpretation typenvarchar10
TOPMigration
18TEMOBIS-U Mig.: Migration Objs13ITYPEReturn Structure Defined as Data Typenvarchar10
TOPProfitability Analysis
19TKEPPLPROTOITYPETable for Information Types for CO-PA Planning Logs1ITYPEInformation Type for CO-PA Planning Lognvarchar100
20TKEPPLPROTOTREEStorage of Tree Structure for Logs6ITYPEInformation Type for CO-PA Planning Lognvarchar100
TOPSAP Query
21IQICATDBInfoSet Query API: InfoSet Catalog4ITYPEInfoSet Query: InfoSet Typenvarchar40
TOPTransaction Variant and Table Control Settings
22SHDFVTransaction variants: Field contents13ITYPEField: Internal typenvarchar10
23SHDFVCITransaction variants: Field contents (cross-client)12ITYPEField: Internal typenvarchar10
24SHDSVFVCIScreen variants: Field contents9ITYPEField: Internal typenvarchar10
TOPUnited Kingdom
25T5G57HR-GB: Supplementary fields for P354ITYPETypes of P35 supplementary informationnvarchar10
TOPVenezuela
26T7VEI1Transfer of External Payroll results: Interest9ITYPEInterest Ratenvarchar20
27T7VEINInterest rates2ITYPEInterest Ratenvarchar20