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

55 columns | Print definition?ERP 6.0  | FIELDPOS

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/OPT/X035Notification Mail Data Configuration3FIELDPOSVerification: Column positionnvarchar20
2/OPT/X036Notification Mail Data Configuration Texts4FIELDPOSVerification: Column positionnvarchar20
3/OPT/Y035Notification Mail Data Configuration3FIELDPOSVerification: Column positionnvarchar20
4/OPT/Y036Notification Mail Data Configuration Texts4FIELDPOSVerification: Column positionnvarchar20
5/OPT/Z035Notification Mail Data Configuration3FIELDPOSVerification: Column positionnvarchar20
6/OPT/Z036Notification Mail Data Configuration Texts4FIELDPOSVerification: Column positionnvarchar20
7ACMACFIELDACM: Access-Condition Field3FIELDPOSACM: Position in a Sequence (First Position=0)int100
8ACMTSTACFIELDACMTST: AC-Field (Expected test-results)3FIELDPOSACM: Position in a Sequence (First Position=0)int100
9CNVCMIS_A_20_DICTable fields for Cross-Client Customizing Comparison7FIELDPOSField Position in Tablenvarchar40
10CNV_20308_FLDCATField Catalog for Download5FIELDPOSPosition of the field in the tablenvarchar40
11DFKKBIXC8162CIT Class Configuration Version (Table TFK8162)5FIELDPOSPosition of the field in the tablenvarchar40
12DFKKBIXE8162Working Version CIT Class Configuration (Table TFK8162)4FIELDPOSPosition of the field in the tablenvarchar40
13DFKKBIXG8162CIT Class Generation Version (Table TFK8162)5FIELDPOSPosition of the field in the tablenvarchar40
14FARR_C_RAI52Fields of a Revenue Accounting Item Class5FIELDPOSPosition of the field in the tablenvarchar40
15FARR_D_RAIC52Configuration Version RAI Class (FARR_C_RAI52)6FIELDPOSPosition of the field in the tablenvarchar40
16FARR_D_RAIG52Generation Version RAI Class (FARR_C_RAI52)6FIELDPOSPosition of the field in the tablenvarchar40
17FARR_D_RAIW52Working Version Configuration RAI Class (FARR_C_RAI52)5FIELDPOSPosition of the field in the tablenvarchar40
18TFK8162Fields of a Consumption Item Class4FIELDPOSPosition of the field in the tablenvarchar40
TOPArchive Information System
19AIND_STR8Archive Information System: indexes, fields3FIELDPOSPosition in Database Indexnvarchar40
TOPBatches
20TBICFSelection Fields for Batch Information Cockpit - Standard -4FIELDPOSItem in Batch Information Cockpit selection tab titlenvarchar30
21TBICFUSelection Fields for Batch Information Cockpit7FIELDPOSItem in Batch Information Cockpit selection tab titlenvarchar30
TOPBilling in Contract Accounts Receivable and Payable
22DFKKBIXC8152BIT Class Configuration Version (Table TFK8152)6FIELDPOSPosition of the field in the tablenvarchar40
23DFKKBIXE8152Working Version Configuration BIT Class (Table TFK8152)5FIELDPOSPosition of the field in the tablenvarchar40
24DFKKBIXG8152BIT Class Generation Version (Table TFK8152)6FIELDPOSPosition of the field in the tablenvarchar40
25TFK8152Fields for a Class of Billable Items5FIELDPOSPosition of the field in the tablenvarchar40
TOPChecksums
26CSUM_CV_FLDSCheck Sum Variant - Fields6FIELDPOSField Positionnvarchar40
27CSUM_EV_FLDSExecuted Analyses - Fields3FIELDPOSField Positionnvarchar40
TOPCommon Parts
28T7XSSPERBIZFLDAvailable fields on bizcards on PersInfo Overview screen6FIELDPOSVertical position of field on a bizcardtinyint30
29T7XSSPERBIZFLDCCustomize fields for bizcards on PersInfo Overview screen6FIELDPOSVertical position of field on a bizcardtinyint30
TOPConsumption-Based Planning See Also PP-MRP
30WSAF_DSX_FILETable for Maintaining the SAF Configuration Files *.dsx5FIELDPOSNumber of Field in the Corresponding DDIC Structurenvarchar40
31WSAF_FIX_FIELDSAdditional Usable SAF Parameters9FIELDPOSNumber of Field in the Corresponding DDIC Structurenvarchar40
TOPCross-Application Components
32/IXOS/DC_TACAAdministrator maintenance for Editing11FIELDPOSPosition of fields in administrationnvarchar30
33/IXOS/DC_TACUChange user maintenance - not used9FIELDPOSPosition of fields in administrationnvarchar30
34/IXOS/DC_TADAAdministrator maintenance for Details11FIELDPOSPosition of fields in administrationnvarchar30
35/IXOS/DC_TADUDetail user maintenance12FIELDPOSPosition of fields in administrationnvarchar30
36/IXOS/DC_TAHAHitlist Administrator maintenance (hierachy/separat)18FIELDPOSPosition of fields in administrationnvarchar30
37/IXOS/DC_TAHUHitlist User maintenance (hierachy/separat)20FIELDPOSPosition of fields in administrationnvarchar30
38/IXOS/DC_TAIAAdministrator maintenance for Creating11FIELDPOSPosition of fields in administrationnvarchar30
39/IXOS/DC_TAIUCapture user maintenance - not used10FIELDPOSPosition of fields in administrationnvarchar30
40/IXOS/DC_TASASelectionscreen Administrator maintenance13FIELDPOSPosition of fields in administrationnvarchar30
41/IXOS/DC_TASUSelectionscreen user maintenance13FIELDPOSPosition of fields in administrationnvarchar30
42/IXOS/DC_TTC03LTable fields, created by using DDIF_NAMETAB_GET3FIELDPOSRow Index of Internal Tablesint100
TOPData Basis
43RSBFILEMAPMapping of Fields of an InfoSpoke on a DB Table4FIELDPOSPosition of the Field in the Structure / Tablenvarchar40
TOPFast Search Infrastructure
44SFSRFW_ALIAS_DTReplication Framework - Aliases2FIELDPOSReplication Framework - Status Numberint100
45SFSRFW_IDX_KEY_DReplication Framework - Doc. ID Description of an Index4FIELDPOSPosition of the field in the tablenvarchar40
TOPFinancial Accounting
46/OPT/T854Notification Mail Data Configuration3FIELDPOSVerification: Column positionnvarchar20
47/OPT/T854TNotification Mail Data Configuration Texts4FIELDPOSVerification: Column positionnvarchar20
TOPI18N Unicode
48UMGNTCD6List of offsets and lengths2FIELDPOSPosition of the field in the tablenvarchar40
TOPLink to Geographic Information System
49GCCGGBC: Structures4FIELDPOSPosition of the field in the tablenvarchar40
TOPTable Analysis
50ARDB_STAT3Table Analysis: Analysis Variants4FIELDPOSTable Analysis: Field Positionnvarchar40
51ARDB_STAT3NTable Analysis: Analysis Variant (with TADIR Connection)4FIELDPOSTable Analysis: Field Positionnvarchar40
52TAAN_FLDSTable Analysis: Executed Analyses - Fields3FIELDPOSTable Analysis: Field Positionnvarchar40
TOPTools
53T532LHR PU12: Version Management Cluster IF - Fields Structure5FIELDPOSHR: Comp. 709: Field positionnvarchar30
TOPWeb Service Tools - ABAP
54VEPPARAMIDSParameter ID of VI (Generated)4FIELDPOSVirtual Interface of Web Service : Field Positionint100
55VEPSTRUTYPEVirtual Interface: Structure Type4FIELDPOSVirtual Interface of Web Service : Field Positionint100