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

77 columns | Print definition?ERP 6.0  | FIELDTYPE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/GEOE/CONFIG_2XBusiness Layer Attributes8FIELDTYPEFieldtypenvarchar200
2/OPT/AT_DETDATADetermination Data4FIELDTYPEExternal Field Typenvarchar10
3/OPT/AT_DETFIELDDetermination Fields3FIELDTYPEExternal Field Typenvarchar10
4/OPT/VT_INIT_FLDDetailed field config for the initializing procedure4FIELDTYPEField type (Table/Single field)nvarchar10
5/OPT/X104Indexing field mapping for IDOC processing3FIELDTYPEExternal Field Typenvarchar10
6/OPT/Y104Indexing field mapping for IDOC processing3FIELDTYPEExternal Field Typenvarchar10
7/OPT/Z104Indexing field mapping for IDOC processing3FIELDTYPEExternal Field Typenvarchar10
8/XPPM/CRC_C_FIELCRC: Fields on Checklist Item Custom Tab4FIELDTYPEFieldtypenvarchar20
9CNVCMIS_CONFIGCMIS Mig: Configuration table for conflicts6FIELDTYPECMIS: field namespacenvarchar100
10CNVTDMSBI_SELECSelected "From date" for a package8FIELDTYPEPossible Field Types for Selectionnvarchar100
11CNVTDMS_01_INCONInconsistent Entries as per the package for 'From Date'8FIELDTYPEPossible Field Types for Selectionnvarchar100
12CNVTDMS_01_PERIOPosting Period Analysis8FIELDTYPEPossible Field Types for Selectionnvarchar100
13CNVTDMS_01_SCENtable that tells the details of the approach selected3FIELDTYPEPossible Field Types for Selectionnvarchar100
14CNVTDMS_01_SELECdetails of the picked "From date" for a certain package7FIELDTYPEPossible Field Types for Selectionnvarchar100
15CNVTDMS_03_FNAMEAssigment of Member-ID and fieldname of CNVTDMS_01_SELEC4FIELDTYPEPossible Field Types for Selectionnvarchar100
16CNVTDMS_CR_SELECdetails of the picked "From date" for a certain package7FIELDTYPEPossible Field Types for Selectionnvarchar100
17CNV_00001_CNDStatus of partitioning analysis6FIELDTYPEData Type in ABAP Dictionarynvarchar40
18DDREPLINTABFDDD: Nametab Field Structure10FIELDTYPEABAP data type (coded)varbinary10
19DDXTF_CONV_UCNametab Feldstruktur für verzögertes Schreiben9FIELDTYPEABAP-Datentyp (codiert)varbinary10
20DDYTF_CONV_UCUsed during UCMIG within DMO of SUM9FIELDTYPEABAP data type (coded)varbinary10
21DMC_DW_FORMALPFormal Parameters for Dynamic WHERE Clauses4FIELDTYPEField Type of Formal Parameters for Dynamic WHERE Clausesnvarchar10
22FMRPF_FIELDCharacteristics of Reporting Structure Field4FIELDTYPEType of Field in Reporting Structurenvarchar40
23GRFNFLDTYPEField Type1FIELDTYPEField Typenvarchar70
24GRFNFLDTYPETField Type Description2FIELDTYPEField Typenvarchar70
25HRP5342DB Table for Infotype 534222FIELDTYPEField Typenvarchar70
26HRP5346DB Table for Infotype 534621FIELDTYPEField Typenvarchar70
27IUUC_DD_SYNC_NTFSystem synchronization: Nametab field data13FIELDTYPEABAP data type (coded)varbinary10
28PIVB_FIELDCharacteristics of Report Catalog Field6FIELDTYPEType of Field in Report Catalognvarchar50
29T5UPBS01FIELDSPersonnel actions infotype fields9FIELDTYPESingle-Character Indicatornvarchar10
TOPAccounting Entities
30FINB_ST_VARGRPCVariable Groups for Structured Types4FIELDTYPEField Type for Variable Groupsnvarchar10
TOPActivation Program, Conversion Program, DB Utility, MC, SPDD
31DDXTFNametab Field Structure for Delayed Writing9FIELDTYPEABAP data type (coded)varbinary10
TOPBusiness Accounting
32/EACC/DMM_CHACharacteristics of the Accounting Views5FIELDTYPEFIN Master Data: Field Type: Characteristic or Key Figurenvarchar10
33/EACC/DMM_KYFKey Figures in the Accounting Views5FIELDTYPEFIN Master Data: Field Type: Characteristic or Key Figurenvarchar10
TOPConsumption-Based Planning See Also PP-MRP
34WSAF_FIELDSAdditional Usable SAF Parameters5FIELDTYPESAF Field Type of Parameternvarchar400
35WSAF_FIX_FIELDSAdditional Usable SAF Parameters4FIELDTYPESAF Field Type of Parameternvarchar400
TOPCost Center Accounting
36T811IAllocation Information for key field6FIELDTYPEField typenvarchar10
TOPCross-Application Components
37CMPERSINDXPersonalization: Field Catalog4FIELDTYPEField Type: Value, Interval, Hierarchy, String, ...nvarchar10
38CMPERSPARMPersonalization: User Settings7FIELDTYPEField Type: Value, Interval, Hierarchy, String, ...nvarchar10
39WPPERSINDXPersonalization: Field Catalog4FIELDTYPEField Type: Value, Interval, Hierarchy, String, ...nvarchar10
40WPPERSPARMPersonalization: User Settings7FIELDTYPEField Type: Value, Interval, Hierarchy, String, ...nvarchar10
TOPData Staging
41RSTRANFIELDMapping of Rule Parameters - Structure Fields9FIELDTYPEType of Structure Fieldnvarchar10
42RSTRANFIELDPROPField Properties Within Transformation (obsolete?)6FIELDTYPEType of Structure Fieldnvarchar10
43RSTRANGROUPFIELDSelected Grouping Fields of Transformation (Source)5FIELDTYPEType of Structure Fieldnvarchar10
TOPFast Search Infrastructure
44SFSRFW_ALIAS_DTReplication Framework - Aliases4FIELDTYPEReplication Framework - Field Type (Field/Structure)nvarchar40
TOPFinancial Accounting
45/OPT/VIM_T124Indexing field mapping for IDOC processing3FIELDTYPEExternal Field Typenvarchar10
TOPForms
46TMETADIMFLD_02HR Forms: MetaFields3FIELDTYPEData element (semantic domain)nvarchar300
47TMETAFIGURE_02HR Forms: MetaFigures2FIELDTYPEData element (semantic domain)nvarchar300
TOPFSCM In-House Cash
48IHC_TAB_GUI_FSIHC: Selectable Fields for Custom Selection3FIELDTYPEType of Field in Free Selectionnvarchar30
49IHC_TAB_LOG_CTXIHC: Contexts in Log3FIELDTYPEType of Context Fieldnvarchar10
TOPGlobal Trade Services
50/SAPSLL/TCOEUIUser Interface Control Settings5FIELDTYPEInput Types for External User Interfacenvarchar10
51/SAPSLL/TICSMGTS: Assignment of Object Components to Structure2FIELDTYPEField typenvarchar300
52/SAPSLL/TICSUIGTS: Map Interface Tab to Structure2FIELDTYPEField typenvarchar300
53/SAPSLL/TICSUITAssignment of Interface Tab Pages to Structure - Text3FIELDTYPEField typenvarchar300
TOPGRC Access Control Plug-In
54/VIRSA/FLDMAPHR Triggers - Field Mapping3FIELDTYPEChar 20nvarchar200
TOPIncentive and Commission Management ICM
55TCACS_EUConversion Rule: Tables and Fields in FS-ICM3FIELDTYPECurrency Category of Table Fieldnvarchar10
TOPLocal Currency Changeover
56EWUCUPAKETContains the individual packages for user-defined objects4FIELDTYPEField typenvarchar10
TOPMarketing, Accounting and Pricing
57OIC_ANALLVL_FLDSFields Used in Pattern Analysis Levels5FIELDTYPEField Typenvarchar10
TOPObject Services
58SEOMAPATTRelational Mapping Attributes7FIELDTYPEField typenvarchar10
TOPOverhead Cost Controlling
59REPPINDXCO-OM Reporting: Field Catalog for Screens for User Settings5FIELDTYPEUser Settings for CO-OM Reports: Field Typenvarchar10
TOPPeople Centric UI Framework
60CRMC_LAYOUTLayout table for structureedit element13FIELDTYPEDefines which kind of field we see on screennvarchar40
61CRMC_LAYOUTCLayout table for structureedit element14FIELDTYPEDefines which kind of field we see on screennvarchar40
TOPPeople Centric UI Framework Customizing
62CRMC_FIELDGRPScreen Structure Field Group Field8FIELDTYPEDefines Which Field Types Can Be Seennvarchar40
63CRMC_FIELDGRPCField Group (Cust.)9FIELDTYPEDefines Which Field Types Can Be Seennvarchar40
TOPPersonalization Framework
64FPB_PERSPARMPersonalization: User Settings14FIELDTYPEField Type: Value, Interval, Hierarchy, String, ...nvarchar10
TOPProfitability Analysis
65TKEBO_FIELDSPCM Model Metadata: Field Definition4FIELDTYPEPCM Model Metadata Field Typenvarchar10
TOPPublic Sector Contract Accounts Receivable and Payable
66DFMCACD_FORMDATAForm Data for Change Object5FIELDTYPEReferencenvarchar300
TOPSAP Query
67AQPROTQuery Logging12FIELDTYPEField type (output/selction feld)nvarchar10
TOPServices
68FINB_RP_CONFIG2Customizing for Fields in Reporting4FIELDTYPEField Typenvarchar10
TOPTools
69T532LHR PU12: Version Management Cluster IF - Fields Structure7FIELDTYPEABAP data type (C,D,N,...)nvarchar10
TOPUpgrade - General
70DDMTFNametab Field Structure for Delayed Writing9FIELDTYPEABAP data type (coded)varbinary10
71DDMTF_ISUNametab Field Structure for Delayed Writing9FIELDTYPEABAP data type (coded)varbinary10
72DDMTF_SAVNametab Feldstruktur für verzögertes Schreiben9FIELDTYPEABAP-Datentyp (codiert)varbinary10
73DDXTF_SAVNametab Feldstruktur für verzögertes Schreiben9FIELDTYPEABAP-Datentyp (codiert)varbinary10
74DDXTF_SHDNametab Feldstruktur für verzögertes Schreiben9FIELDTYPEABAP-Datentyp (codiert)varbinary10
75DDXTF_STDNametab Feldstruktur für verzögertes Schreiben9FIELDTYPEABAP-Datentyp (codiert)varbinary10
76DDYTFSubstitution Nametab (shadow-shadow-nametab for DDXTF)10FIELDTYPEABAP data type (coded)varbinary10
TOPUpgrade Tools
77ICNV31LNametab for Incremental Conversion11FIELDTYPEvarbinary10