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
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPCH386A/P Invoice
8OVTG52Tax Definition
9OPOR386Purchase Order
10JDT1124Journal Entry - Rows

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
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

100 columns | Print definition?ERP 6.0  | REQUIRED

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/SAPSRM/C_MDFSBMeta Data Configuration for Set Fields10REQUIREDPDO Field Property "Required"nvarchar10
2/SAPSRM/C_MDFSBBBO specific Restriction of Set Field Metadata9REQUIREDPDO Field Property "Required"nvarchar10
3/SAPSRM/C_MDFSBCCustomer Table for Configuration of Set Field Metadata10REQUIREDPDO Field Property "Required"nvarchar10
4/SAPSRM/C_MDFSBLLook-Up Table BO specific Restriction of Set Field Metadata10REQUIREDPDO Field Property "Required"nvarchar10
5/SAPSRM/C_MDFSDMeta Data Configuration for Dependant object Fields8REQUIREDPDO Field Property "Required"nvarchar10
6/SAPSRM/C_MDFSDBDependant object Field Metadata7REQUIREDPDO Field Property "Required"nvarchar10
7/SAPSRM/C_MDFSDLLook-Up Table for Dependant Object/Set Field Metadata8REQUIREDPDO Field Property "Required"nvarchar10
8/SAPSRM/C_MDF_H1Meta Data Configuration for Business Object Header Fields9REQUIREDPDO Field Property "Required"nvarchar10
9/SAPSRM/C_MDF_HBBackground Table for Meta Data Config. for Header Fields7REQUIREDPDO Field Property "Required"nvarchar10
10/SAPSRM/C_MDF_HCCustomer Meta Data Configuration for BO Header Fields9REQUIREDPDO Field Property "Required"nvarchar10
11/SAPSRM/C_MDF_HDMeta Data Configuration for Business Object Header Fields9REQUIREDPDO Field Property "Required"nvarchar10
12/SAPSRM/C_MDF_HLLook-Up Table for Meta Data Configuration for Header Fields8REQUIREDPDO Field Property "Required"nvarchar10
13/SAPSRM/C_MDF_I1Meta Data Configuration for Business Object Item Fields11REQUIREDPDO Field Property "Required"nvarchar10
14/SAPSRM/C_MDF_IBBackground Table for Meta Data Configuration for Item Fields9REQUIREDPDO Field Property "Required"nvarchar10
15/SAPSRM/C_MDF_ICCustomer Meta Data Configuration for BO Item Fields11REQUIREDPDO Field Property "Required"nvarchar10
16/SAPSRM/C_MDF_ILLook-Up Table for Meta Data Configuration for Item Fields10REQUIREDPDO Field Property "Required"nvarchar10
17/SAPSRM/C_MDF_ITMeta Data Configuration for Business Object Item Fields11REQUIREDPDO Field Property "Required"nvarchar10
18/SAPSRM/C_MDF_S1Meta Data Configuration for Set Fields11REQUIREDPDO Field Property "Required"nvarchar10
19/SAPSRM/C_META_HMeta Data Cnofiguration for Business Object Header Fields7REQUIREDPDO Field Property "Required"nvarchar10
20/XLSO/TEMPLATESxLSO scenarios and templates5REQUIREDMail Activenvarchar10
21ARBFND_I_DCXML_DDDIC objects generated for the DTD elements and attributes17REQUIREDNew Input Valuesnvarchar10
22BBPC_META_ITMMeta Data for Items Types7REQUIREDRequirednvarchar10
23BBP_ATTR_ACCESSAttribute Access Mode6REQUIREDAttribute is Mandatorynvarchar10
24CNVMBTCWBSUBACTSubactivities of CWB-activities8REQUIREDGeneral Flagnvarchar10
25DOUI_ELEMDBOS Cockpit: Screen Element19REQUIREDDBOSC-CR: Generated ID (30)nvarchar300
26EHPRCC_CKDOCINCP: Define document types to be processed within a check4REQUIREDRequired Indicatornvarchar10
27EHPRCC_CKDOCOUTCP: Define document types to be processed within a check4REQUIREDRequired Indicatornvarchar10
28EHPRCD_IMDSMATCLConfiguration for matclass check7REQUIREDBoolean Variable (X=True, -=False, Space=Unknown)nvarchar10
29GRFNDEOFLDDummy EO Fields12REQUIREDTest Required or Notnvarchar10
30HRP5355DB Table for Infotype 535520REQUIREDTest Required or Notnvarchar10
31J_1ILOCDOCTCEXIM: LC Documents & Terms and Conditions7REQUIREDLoc Document Flagnvarchar10
32sap_perfcntr4requiredvarchar320
33T77SFI_COMP_EXFDFields for export of compensation data to SFSF5REQUIREDRequired Fieldnvarchar10
34T77SFI_COMP_MPFDField definitions for import of compensation data from SFSF6REQUIREDRequired Fieldnvarchar10
35T77SFI_VARPY_MPDField definitions for import of Variable Pay data from SFSF6REQUIREDRequired Fieldnvarchar10
36TEWA_EL_OBJBHUIFBehavioral Control User Interface Fields7REQUIREDBehavioral Control "Required" Propertynvarchar10
37TN1MCI_HL7DSCComponent - Data Structure Assignment9REQUIREDRequirednvarchar10
TOPAgency Business Global Trade
38TCWBCRCFAB-CWB: Reasons for Complaint - Change Fields5REQUIREDAB-CWB: Field is Required Entrynvarchar10
TOPApplication Framework
39USMD101CUI Model: Layout of Web Interface9REQUIREDRequired Entrynvarchar10
TOPBank Accounting
40TFPM042FMPayment medium formats: Reqd fields for format parameters4REQUIREDIndicator: Required-Entry Fieldnvarchar10
41TFPM042FMCPayment medium formats: Cust. reqd. fields for format para.5REQUIREDIndicator: Required-Entry Fieldnvarchar10
TOPBusiness Context Viewer
42/BCV/C_INPARInput Parameter9REQUIREDMandatory Fieldnvarchar10
TOPBusiness Server Pages
43O2TAGATTBSP Element Attributes5REQUIREDAttribute: Mandatory?nvarchar10
TOPCheck Input
44OIUCI_FIELDATTRCheck fields attributes5REQUIREDnvarchar10
TOPClaims Management
45TIGN221Settings for Search Criteria in a Search6REQUIREDBehavior of Search If Values Are Missingnvarchar10
TOPCollaboration Folders
46CFX_BOM_DTF_OTBOM Export: Object Selection per DTF Export Profile3REQUIREDBoolean Typenvarchar10
TOPContract Accounts Receivable and Payable
47DFKKPTSAFTDEFObsolete! DO NOT USE6REQUIREDPortugal: SAF-T Required fieldnvarchar10
48TFK042FMRequired Fields for Format Parameters5REQUIREDRequired Entry Fieldnvarchar10
TOPCross-System Tools
49SCDTSYSCMPSystems3REQUIREDYes/No (X/ )nvarchar10
TOPCustomer Interaction Center
50CIMAPInput Sequence for BDC Sessions6REQUIREDCheckboxnvarchar10
TOPDefense Forces and Public Security
51HRP1988DB Table for Infotype 198819REQUIREDMandatory Objectnvarchar10
TOPeCATT Extended Computer Aided Test Tool
52ECSCR_BF_VERDependency eCatt Version on SFW Business Function5REQUIREDRelevance of Software Component Assignment to Versionnvarchar10
53ECSYS_RELeCATT Software Component Release Dependency7REQUIREDRelevance of Software Component Assignment to Versionnvarchar10
54ECTD_BF_VERDependency eCatt TD Version on SFW Business Function5REQUIREDRelevance of Software Component Assignment to Versionnvarchar10
55ECTD_SYS_RELDependance Test Data Vers. on Releases of a Software Comp.7REQUIREDRelevance of Software Component Assignment to Versionnvarchar10
TOPECM ABAP Stack
56NWECMD_PRPTDFSECMI: Property Definitions12REQUIREDNW ECM: Enumeration Code from Storenvarchar10
TOPEngineering Change Record
57/PLMI/ECR_PREREQECR - Status Prerequisite customizing table5REQUIREDEngineering Record - Flagnvarchar10
TOPFinancials Basis
58FINB_TACSYST_MFNObsolete !!! Valuation Systm: Meta Description - Field Names13REQUIREDData element for domain BOOLE: TRUE (='X') and FALSE (=' ')nvarchar10
TOPForce Element
59/ISDFPS/FORCEMAuthorized Materials28REQUIREDMandatory Objectnvarchar10
60/ISDFPS/FORMCAttributes of the Material Container-Force Element Relatshp20REQUIREDMandatory Objectnvarchar10
61/ISDFPS/FORMCHAttributes of the Material Container - HR Relationship20REQUIREDMandatory Objectnvarchar10
62/ISDFPS/FORMPHAttributes of the HR - MPO Relationship25REQUIREDMandatory Objectnvarchar10
63/ISDFPS/FORMPOAttributes of the Force Element - MPO Relationship25REQUIREDMandatory Objectnvarchar10
TOPFunds Management
64FMDPEF_FSTSFieldstatus FMDPEF9REQUIREDIndicator: Display with Values Requirednvarchar10
65FMDPEF_FSTS_SAPFieldstatus FMDPEF SAP delivered6REQUIREDIndicator: Display with Values Requirednvarchar10
TOPGlobal Trade Services
66/SAPSLL/TCOEUIUser Interface Control Settings10REQUIREDUser Interface Control Settings - Required Entry Fieldnvarchar50
TOPGovernance, Risk and Compliance
67GRPC_MCF_CUSFLDCustom Field UI configuration7REQUIREDRequired flagnvarchar10
68GRPC_MCF_SAP_ATTDynamic SAP Attributes properties4REQUIREDRequired flagnvarchar10
TOPLocalization
69FPIA_FIELDSTAT_CField status control for IoA fields4REQUIREDMandatory User Inputnvarchar10
70FPIA_FIELDSTAT_SField status control for IoA fields (SAP)3REQUIREDMandatory User Inputnvarchar10
TOPMarketing Retail Network
71OIFSCTFDCONFCField Selection Customizing - Screen Configuration Tool7REQUIREDField is mandatorynvarchar10
72OIFSCTFDDEFCField Definition Customizing - Screen Configuration Tool4REQUIREDField is mandatorynvarchar10
73OIFSCTFDDEFC1Field Definition Customizing - Screen Configuration Tool5REQUIREDField is mandatorynvarchar10
74OIFSCTFDDEFSField Definitions - Screen Configuration Tool4REQUIREDField is mandatorynvarchar10
TOPOrganizational Management
75T77OMATTUSGeneral Attribute Maintenance: Attributes per Scenario5REQUIREDGeneral Attribute Maintenance: Attribute must be Availablenvarchar10
TOPPersonnel Administration
76T599XField Control for Report Categories3REQUIREDRequired fieldnvarchar10
TOPPersonnel Time Management
77T588NScreen Modification for Account Assignment Block5REQUIREDRequired entry fieldnvarchar10
TOPPortfolio Management
78/RPM/OBJ_CUS_UIObject type customizing for UI8REQUIREDRequirednvarchar10
79/RPM/OBJ_SAP_UIObject type SAP UI Fields7REQUIREDRequirednvarchar10
80/RPM/PORT_CAP_UIOverride Portfolio Capacity Cust object type UI fields6REQUIREDRequirednvarchar10
81/RPM/PORT_FIN_UIOverride Portfolio Financial Cust object type UI fields6REQUIREDRequirednvarchar10
82/RPM/PORT_FLD_UIPortfolio Fields UI9REQUIREDRequirednvarchar10
83/RPM/PORT_IP_UIOverride Portfolio Item UI fields-Phase7REQUIREDRequirednvarchar10
84/RPM/PORT_I_UIOverride Portfolio UI fields-Item6REQUIREDRequirednvarchar10
TOPProcess Controls
85GRPCTESTRESULTResults for test steps9REQUIREDTest Required or Notnvarchar10
86HRP5327DB Table for Infotype 532719REQUIREDTest Required or Notnvarchar10
TOPProduct Configurator
87COMM_CFGCLFACFacets for Characteristics of Classes8REQUIREDFlagnvarchar10
TOPProduction and Revenue Accounting
88OIUCM_TAB_MAINTCPRA Generic Table Maintenance - Non Key Field Control Tab4REQUIREDPRA Generic Table Maintenance - Required Flagnvarchar10
TOPProfitability Analysis
89TKEBPSFCO-PA Mass Processing: Screen Fields9REQUIREDRequired entry fieldnvarchar10
TOPPublic Sector Contract Accounts Receivable and Payable
90TFMCA_COREL_UIUI Setting for Relationship Maintenance4REQUIREDIndicator: Required Fieldnvarchar10
TOPRegulatory reporting for insurance companies
91TISSR_TP_C_DYNFISSR: Tabelle zur Feldaussteuerung DSUMB9REQUIREDISSR: Feld zur Aussteuerg. Mussfeld von Dynprofeldernnvarchar10
92TISSR_TP_C_DYNFSISSR: Feldsteuerung Selektionsbildschirme DSUMB9REQUIREDISSR: Feld zur Aussteuerg. Mussfeld von Dynprofeldernnvarchar10
TOPRemaining Beverage - Obsolete Objects
93/BEV3/CHBFLDSTATAgreements Field Status10REQUIREDRequired Entry Fieldnvarchar10
94/BEV3/CHWDFLDSTField Status of Contract Handling Document10REQUIREDRequired Entry Fieldnvarchar10
TOPSales and Distribution
95SCEHASCHACharacteristics of OO Class5REQUIREDBoolean (T = true, F = false, blank = unknown)nvarchar10
TOPSAP NetWeaver Mobile - Use subcomponents
96MEREP_UCMASTERUsage copy master table3REQUIREDX -> critical , SPACE -> non-criticalnvarchar10
TOPService Station Retailing
97OIRCSCTFDDEFSField Definitions - Meter Maintenance3REQUIREDField is mandatorynvarchar10
98OIRC_MR_FDEF_CFSSR Meters - Field Selection Customizing - SCT8REQUIREDField is mandatorynvarchar10
TOPTraining Management
99LSOLSPSYSServices Supported for External LMS2REQUIREDIndicator: Mandatory Servicenvarchar10
TOPUser and Authorization Management
100TUGRPField Assignment for User Types4REQUIREDStandard Screen Checknvarchar10