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

57 columns | Print definition?ERP 6.0  | KEYFIELD

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/AIF/T_IFKEYDefine Interface Key Fields for Variants6KEYFIELDInterface Variant Key Fieldnvarchar1200
2CNVCMIS_A_1_TYPFTable type text for Repository Analysis8KEYFIELDKey component for table typesnvarchar1320
3CNVTDMSSCR_KEYSTScrambling Keyset for rule8KEYFIELDField Namenvarchar300
4COMC_TEXT_ASFAssignment of Fields in Access Sequence5KEYFIELDField from Structure in Text Keynvarchar300
5DFKKBIXC8162CIT Class Configuration Version (Table TFK8162)6KEYFIELDIdentifies a key field of a tablenvarchar10
6DFKKBIXE8162Working Version CIT Class Configuration (Table TFK8162)5KEYFIELDIdentifies a key field of a tablenvarchar10
7DFKKBIXG8162CIT Class Generation Version (Table TFK8162)6KEYFIELDIdentifies a key field of a tablenvarchar10
8FARR_C_RAI52Fields of a Revenue Accounting Item Class6KEYFIELDIdentifies a key field of a tablenvarchar10
9FARR_D_RAIC52Configuration Version RAI Class (FARR_C_RAI52)7KEYFIELDIdentifies a key field of a tablenvarchar10
10FARR_D_RAIG52Generation Version RAI Class (FARR_C_RAI52)7KEYFIELDIdentifies a key field of a tablenvarchar10
11FARR_D_RAIW52Working Version Configuration RAI Class (FARR_C_RAI52)6KEYFIELDIdentifies a key field of a tablenvarchar10
12TEWA_EL_OBJBHFPKField Transport Data Provider - Key Assignment5KEYFIELDField Namenvarchar300
13TFK8162Fields of a Consumption Item Class5KEYFIELDIdentifies a key field of a tablenvarchar10
14ZCLUSTKEY2Actual key information for data cluster reporting5KEYFIELDField Namenvarchar300
TOPActivation Program, Conversion Program, DB Utility, MC, SPDD
15CD0F4TESTTabelle mit Feldern mit verschiedenen Eingabehilfen1KEYFIELDTestdatenelement mit Wertetabellenvarchar30
16DD42SKey fields for table types (internal tab. defined in DD)6KEYFIELDKey component for table typesnvarchar1320
TOPBilling in Contract Accounts Receivable and Payable
17DFKKBIXC8152BIT Class Configuration Version (Table TFK8152)7KEYFIELDIdentifies a key field of a tablenvarchar10
18DFKKBIXE8152Working Version Configuration BIT Class (Table TFK8152)6KEYFIELDIdentifies a key field of a tablenvarchar10
19DFKKBIXG8152BIT Class Generation Version (Table TFK8152)7KEYFIELDIdentifies a key field of a tablenvarchar10
20TFK8152Fields for a Class of Billable Items6KEYFIELDIdentifies a key field of a tablenvarchar10
TOPData Collection
21TMC20Parameters for Generating Updating (Internal Use)8KEYFIELDField name of the key fieldnvarchar300
TOPData Staging
22RSDSSEGFDDataSource - Segment Fields15KEYFIELDKey Fieldnvarchar10
23RSDSSEGFDSHDataSource in BW - Shadow Table Fields15KEYFIELDKey Fieldnvarchar10
24RSISOFIELDInfoSource fields (provider structure of a source system)16KEYFIELDBooleannvarchar10
25RSOLTPSOURCEFDSHShadow Table: OLTP Source Fields16KEYFIELDSingle-Character Indicatornvarchar10
26RSOLTPSOURCEFIEOLTP Source Fields16KEYFIELDSingle-Character Indicatornvarchar10
27RSOLTPSOURCESFISegment Fields of a DataSource17KEYFIELDSingle-Character Indicatornvarchar10
TOPeCATT Extended Computer Aided Test Tool
28ECATT_TEST_TABLETest Table for ABAP Objects Commands in eCATT2KEYFIELDNatural Numberint100
TOPF4 Help
29DD91SDocID Key Definition of External Index2KEYFIELDField Namenvarchar300
TOPFlexible Real Estate Management
30TIVCASHFLDSearch Field, for Which a Search Strategy Can Be Defined6KEYFIELDName of Key Field in Customizing Tablenvarchar300
TOPFront Office
31EWATRAAction Manager: Parameter Def.5KEYFIELDKey field name of target element object typenvarchar320
32EWMOBJKEYInternal Help Table for Creating Objects from Keys2KEYFIELDKey fieldnvarchar320
TOPGeneric Statistical Data
33/DSD/GS_GENDAT_IDSD: Generic Data Container4KEYFIELDGeneric Key Fieldnvarchar200
TOPGlobal Trade Services
34/SAPSLL/TCOEUIUser Interface Control Settings24KEYFIELDField Namenvarchar300
TOPInternationalization I18N
35I18NSRHGRGlobal Results (Search) of an I18N_SEARCH analysis6KEYFIELDIs the field a key flag of the table ?nvarchar10
TOPLoans Management
36VDMAP_LABELSLoans: Mapping Table Data Fields for Descriptions4KEYFIELDName of the key fieldnvarchar300
TOPLogistics Execution
37/DSD/PE_CONFIGPricing: Configuration2KEYFIELDPricing: key field of configurationnvarchar300
TOPMetadata Repository
38RSDIOBJFIXDelivered Fixed System InfoObjects15KEYFIELDSpecial Char: IOBJ Field Name in Special Master Tablenvarchar300
TOPMusing Tools
39WDKDYNPTCKEYTable Control Information4KEYFIELDDynpro field namenvarchar1320
TOPOperational Data Provisioning ODP
40RODPS_TEST_ADDADD = ADDD = CUBE Delta2KEYFIELDNatural Numberint100
41RODPS_TEST_AIEAIE = AIM Delta2KEYFIELDNatural Numberint100
42RODPS_TEST_AIEDAIED = AIMD Delta2KEYFIELDNatural Numberint100
43RODPS_TEST_NEWENEWE = NEWD Delta2KEYFIELDNatural Numberint100
44RODPS_TEST_ODSODS = ABR = ABR1 Delta2KEYFIELDNatural Numberint100
45RODPS_TEST_SNAPSSnapshot of All Test Data Sources3KEYFIELDNatural Numberint100
TOPOracle Database Monitors
46ORA_DBA_TCOLUMNSOracle monitoring: Transparent table for table columns10KEYFIELDOracle monitoring: Column data typenvarchar180
TOPPortfolio Management
47/RPM/SHLP_LISTSearch Help List4KEYFIELDKey field No.1nvarchar300
48/RPM/SRCH_TABNAMTable Name used for Object Search7KEYFIELDField Namenvarchar300
TOPPurchasing
49WRFT_POHF_POL_FDSeasonal Procurement: Field Dependencies in the Order List1KEYFIELDName of the ABAP Dictionary objectnvarchar300
TOPRemaining Beverage - Obsolete Objects
50/BEV3/CHCLSTDEFCustomizing Parameter Definitions for List Viewer Reports3KEYFIELDChar 20nvarchar200
TOPSAP NetWeaver Mobile - Use subcomponents
51MEREP_ENQFor Generic Enqueue Purposes with Key Length 1201KEYFIELDnvarchar1200
TOPSecurity
52LAWDIVINDXTest2KEYFIELDChar 20nvarchar200
TOPServices
53FINB_KF_CHAR_KEYKey Fields Generated Table Types7KEYFIELDField Namenvarchar300
TOPStructural Graphics
54T777NAME1HR Namespace: Table Entries7KEYFIELDKey for Reserved Entrynvarchar500
55T777NAME2HR Namespace: Table Entries from Non-SAP Systems5KEYFIELDKey for Reserved Entrynvarchar500
56T777NAME2PHR Namespace: New Table Entries5KEYFIELDKey for Reserved Entrynvarchar500
TOPTransport Management System
57CTWFNUMBERTransport Proposal: Number Assignment1KEYFIELDCharacter Field Length = 10nvarchar100