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

48 columns | Print definition?ERP 6.0  | FIELD_TYPE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/CPD/FC_TRNMT_TFRelationship Between Transfer Method and Target Filed5FIELD_TYPEField Type for Valuation Methodnvarchar10
2/CPD/FC_VAL_RFValuation Method Relevent Field4FIELD_TYPEField Type for Valuation Methodnvarchar10
3/OPT/CT_IDH_DATAInbound Document Handler: Table for storing key/value pairs6FIELD_TYPEExternal Field Typenvarchar10
4/OPT/FIELDSInvoice Header/Item fields configuration4FIELD_TYPEField Typenvarchar10
5/OPT/VIM_IDH_EXTInbound Document Handler: Table for storing original values6FIELD_TYPEExternal Field Typenvarchar10
6/OPT/X162Search field configuration table11FIELD_TYPEData Type in ABAP Dictionarynvarchar40
7/OPT/Y162Search field configuration table11FIELD_TYPEData Type in ABAP Dictionarynvarchar40
8/OPT/Z162Search field configuration table11FIELD_TYPEData Type in ABAP Dictionarynvarchar40
9/ORS/SCH_FLD_CFGSearch field configuration table11FIELD_TYPEData Type in ABAP Dictionarynvarchar40
10/SYCLO/WB001FDevTool: Mobile Screen layout6FIELD_TYPEDevTool: client field typenvarchar20
11CBESH_ANNO_KFConfiguration Table for7FIELD_TYPEType of Key Facts Fieldnvarchar100
12CNV_MBT_ME_MAPPSTable for mappings of the Mapping Engine3FIELD_TYPEType of a fieldnvarchar300
13GRFNREPFIELDMAPReport: Special fields for reporting6FIELD_TYPEFree filternvarchar10
14GRFNREPFIELDTYPEReport: Field types for reporting2FIELD_TYPEReport: Field typenvarchar10
15SIMDQ_FLD_TYPIM in HANA table field data type1FIELD_TYPEIM in HANA table field data typenvarchar150
16T77PAOSQUVSValue Suggest Fields for Query Category4FIELD_TYPEValue Suggest Field Typenvarchar100
17T77SFI_COMP_MPFDField definitions for import of compensation data from SFSF4FIELD_TYPEField Type for Importing Compensation Data from SFSFnvarchar10
18T77SFI_VARPY_MPDField definitions for import of Variable Pay data from SFSF4FIELD_TYPEField Type for Importing Variable Pay Data from SFSFnvarchar10
TOPAnalysis Process Designer
19RSANT_PRP_TREXCAPD Provider Runtime - TREX Component Descriptions7FIELD_TYPEnvarchar10
TOPBatches
20TBICFSelection Fields for Batch Information Cockpit - Standard -5FIELD_TYPEBIC Field Display Control Selection/Resultnvarchar10
21TBICFUSelection Fields for Batch Information Cockpit8FIELD_TYPEBIC Field Display Control Selection/Resultnvarchar10
TOPData Basis
22MDM_CS_FIELD_TABMDM: Field Table of SAP System5FIELD_TYPEint100
TOPEvent Management
23/SAPTRX/EXT_FLDSExtraction fields5FIELD_TYPEField Typenvarchar10
TOPLaunchpad
24APB_ISR_CUST_F4LInput and Output Fields for Input Help7FIELD_TYPEField Categorynvarchar20
TOPMaterial Master
25WER_DBE_FIELD_AAction database enrichment field assignment (Customers)8FIELD_TYPEDatabase enrichment where clause field typenvarchar10
26WER_DBE_FIELD_SAction database enrichment field assignment7FIELD_TYPEDatabase enrichment where clause field typenvarchar10
TOPNetWeaver Enterprise Search
27ESH_OM_AOTYPNFObject Types: Nodes: Node Fields17FIELD_TYPEType of Fieldnvarchar20
28ESH_OM_COTYPNFObject Types: Nodes: Node Fields17FIELD_TYPEType of Fieldnvarchar20
29ESH_OM_FLDTYPEField Types2FIELD_TYPEType of Fieldnvarchar20
30ESH_OM_FLDTYPETField Types: Descriptions2FIELD_TYPEType of Fieldnvarchar20
31ESH_OM_IOTYPNFObject Types: Nodes: Node Fields17FIELD_TYPEType of Fieldnvarchar20
32ESH_OM_SOTYPNFObject Types: Nodes: Node Fields17FIELD_TYPEType of Fieldnvarchar20
TOPPlant Maintenance
33EAMS_KPIPARAMKPI Display Parameter Customizing Table7FIELD_TYPEKPI Parameter Field Type (Input, Checkbox)nvarchar20
TOPPosition Budgeting and Control
34T77HRFPM_PCS_03Definition of Consolidation Rules7FIELD_TYPEEnh. PCS Handlingnvarchar10
TOPRegulatory reporting for insurance companies
35TISSR_OUT_SULVISSR: Weist pro Listentyp die Summationsebenen aus7FIELD_TYPEFeldtyp: Welche Funktion hat Feld in interner Tabellenvarchar20
TOPSAP Records Management
36SRM_ATTR_QUER_CUAttribute Query Metadata Customizing6FIELD_TYPEAttribute Description - Visualization: Field Typenvarchar320
37SRM_ATTR_VISU_CUAttribute Visualization Metadata Customizing6FIELD_TYPEAttribute Description - Visualization: Field Typenvarchar320
38SRM_PROP_QUER_CUObsolete!8FIELD_TYPEAttribute Description - Visualization: Field Typenvarchar320
39SRM_PROP_VISU_CUObsolete!8FIELD_TYPEAttribute Description - Visualization: Field Typenvarchar320
TOPService Data Download
40/SDF/FLD_INFOFields Information3FIELD_TYPEnvarchar100
TOPService Implementation Workbench
41TSIW_MM_TYPEDEFSType definitions4FIELD_TYPEData Type Namenvarchar1200
TOPTransaction Tax Engine
42TTEC_GLPARMTTE Global Settings4FIELD_TYPEField typenvarchar300
TOPUI Configuration Design Layer
43BSP_DLC_DESIGNDesign layer: Design11FIELD_TYPEField Type on UI (Input Field, Dropdown Box, ...)nvarchar10
44BSP_DLC_SDESIGNDesign layer: Design10FIELD_TYPEField Type on UI (Input Field, Dropdown Box, ...)nvarchar10
TOPUI Framework Service Provider Infrastructure
45/PLMB/FRW_FLDTYPField types1FIELD_TYPEField Typenvarchar100
46/PLMB/FRW_FLDTYTField types descriptions1FIELD_TYPEField Typenvarchar100
47/PLMB/FRW_MAPDTLMapping of data elements to parameters6FIELD_TYPEField Typenvarchar100
48/PLMB/FRW_MAPFLDMapping of Structure Components to Parameters7FIELD_TYPEField Typenvarchar100