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
4OVPM154Outgoing Payments
5OIVL77Whse Journal
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

143 columns | Print definition?ERP 6.0  | IS_DEFAULT

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/GBT/W_WRKLST_HWorklist Header4IS_DEFAULTData element for domain BOOLE: TRUE (='X') and FALSE (=' ')nvarchar10
2/IWBEP/I_SBU_PSVSB: UI perspective component assignments8IS_DEFAULTSB: UI indicator for usage as defaultnvarchar10
3/IWFND/C_MGDEAMCustomizing table: Routing for OData Services6IS_DEFAULTSystem Alias is default - Used for Create and Metadatanvarchar10
4/MRE/RSC_OBJ_FLPMobile Retail Object Filter Profile4IS_DEFAULTGeneral Flagnvarchar10
5/PERS/FLAVORSPersonas: Flavors5IS_DEFAULTPersonas: Flag to set a flavor as defaultnvarchar10
6/XFT/DDSFEND01User-Specific Favorites8IS_DEFAULTBoolean (Constants: /XFT/IF_CONSTANT)nvarchar10
7DODP_FIELD_VALUEDBOS-DP: Data Provider Field Value10IS_DEFAULTnvarchar10
8DOUI_ELEM_VALUEDBOS Cockpit: Screen Element Values9IS_DEFAULTnvarchar10
9EHFNDC_AUTHENTAuthorization Entity3IS_DEFAULTDefault Valuenvarchar10
10EHFNDC_CHCOLORColors of Chemicals4IS_DEFAULTDefault Valuenvarchar10
11EHFNDC_CHFORMForms of Chemicals3IS_DEFAULTDefault Valuenvarchar10
12EHFNDC_CHODOROdor of Chemicals4IS_DEFAULTDefault Valuenvarchar10
13EHFNDC_PROFAuthorization Feld Profile6IS_DEFAULTDefault Valuenvarchar10
14EHHSSC_SEGROLETeam Member Role3IS_DEFAULTDefault Valuenvarchar10
15PRSNAS_FLAVORSPersonas: Flavors5IS_DEFAULTPersonas: Flag to Set a Flavor as Defaultnvarchar10
16PYD_D_TYPTRRDTPayroll Data Source Type Par. Ty. Result Details Type Asgmt.7IS_DEFAULTPayroll Data Source Framework: General Indicatornvarchar10
17PYD_D_UVPayroll Data Source Framework: User Variant7IS_DEFAULTPayroll Data Source Framework: Default Indicatornvarchar10
18TIVYCSETTLPARAMCAM Settlement Parameters4IS_DEFAULTDefault Value for CAMnvarchar10
19/BOBF/CONF_LIBCLBOPF Library classes8IS_DEFAULTData element for domain BOOLE: TRUE (='X') and FALSE (=' ')nvarchar10
TOPAddress ManagementBusiness Address
20TSADVC_CLIDEPInternational Address Version Customizing (Client-Specific)4IS_DEFAULTIndicator: The standard version has this semanticnvarchar10
TOPAgency Business Global Trade
21TMPRX_IDNTAB: Define an Identification Scheme6IS_DEFAULTAB: Default Identification Schemenvarchar10
TOPAnti-Virus Protection
22VSCAN_PROFVirus Scan Profiles4IS_DEFAULTIndicator: Virus Scan Profile Is the Default Profilenvarchar10
TOPAuthentication and SSO
23SAML2_AFL_ENTSAML2 Service Provider Membership for Each Affiliation4IS_DEFAULTSAML2 Truth Valuenvarchar10
24SAML2_ENT_AUTHSAML2 Authentication Context for Each Entity5IS_DEFAULTSAML2 Truth Valuenvarchar10
25SAML2_ENT_NFMTSAML2 NameID Format Definition for Each Entity5IS_DEFAULTSAML2 Truth Valuenvarchar10
26SAML2_ENT_SRVCSAML2 Service Definition for Each Entity6IS_DEFAULTSAML2 Truth Valuenvarchar10
27SAML2_POL_AUTHSAML2 Authentication Contexts of Logon Policies6IS_DEFAULTSAML2 Truth Valuenvarchar10
28SAML2_TRUSTTrust Table for SAML2 Entities4IS_DEFAULTSAML2 Truth Valuenvarchar10
TOPBackground Processing
29TBTC_EXT_SDLExtSdl: Registration Table: External Schedulers7IS_DEFAULTBoolean Variable (X=True, -=False, Space=Unknown)nvarchar10
TOPBasis Components
30/CRYSTAL/CA_SYSTContent Administration target system aliases4IS_DEFAULTGeneral Flagnvarchar10
TOPBusiness Objects, Common Components
31EHDMOC_ADR_DSTCustomizing Table for District3IS_DEFAULTDefault Valuenvarchar10
32EHDMOC_ADR_FLRCustomizing Table for Floor3IS_DEFAULTDefault Valuenvarchar10
33EHFNDC_ACTEFFAction Effectivity Code3IS_DEFAULTDefault Valuenvarchar10
34EHFNDC_ACTPRTGAction Protection Goal Code3IS_DEFAULTDefault Valuenvarchar10
35EHFNDC_ACTSUBSubtypes - Dependent on Type7IS_DEFAULTDefault Valuenvarchar10
36EHFNDC_ACTTMPLAction Template Code8IS_DEFAULTDefault Valuenvarchar10
37EHFNDC_ACTTYPEAction Type - Depending on Safety Measure Category8IS_DEFAULTDefault Valuenvarchar10
38EHFNDC_TEMPLTable Template for CODE-Phrase-Attributes3IS_DEFAULTDefault Valuenvarchar10
TOPCapacity and Resource Planning
39/MRSS/C_RM_ASSFLCustomizing table for Assignment Filter4IS_DEFAULTDefault Assignment Filternvarchar10
40/MRSS/C_RM_RWLRegional Defaults for worklists4IS_DEFAULTIndicatornvarchar10
TOPClinical System
41N1FATTR_VALUEIS-H*MED: Value of Field Attribute Type4IS_DEFAULTCheckboxnvarchar10
42TN2CATCategories: Categories in Category Set7IS_DEFAULTCategories: Indicator Category Is Presettingnvarchar10
43TN2CATSETCategories: Category Set5IS_DEFAULTCategories: Standard Category Set Indicatornvarchar10
TOPCommunication Services Mail, Fax, SMS, Telephony
44BCSD_RQSTBCS: Status Requests for Specific Address Area3IS_DEFAULTSAPconnect: Selectionnvarchar10
45BCSD_STMLBCS: Status Confirmation by E-Mail for Specific Address Area3IS_DEFAULTSAPconnect: Selectionnvarchar10
TOPCondition Technique
46/SAPCND/CNTXT_GRTable of Condition Maintenance Groups for Maintenance Contxt4IS_DEFAULTDefault Group Namenvarchar10
TOPCustomer Enhancements
47BADIIMPL_MENURuntime Table BAdI Menu Enhancements10IS_DEFAULTDefault Indicator of an FCode Entrynvarchar10
TOPeCATT Extended Computer Aided Test Tool
48ECTC_ATTACHExternal Documents linked to eCATT Objects9IS_DEFAULTDefaultnvarchar10
TOPEEW Services
49OXT_CUS_PRJObject Extension Projects16IS_DEFAULTDefault Objectnvarchar10
TOPEnd User Technology
50RSRD_ER_DOCTYPEException Reporting Document Type3IS_DEFAULTBooleannvarchar10
TOPFlexible Real Estate Management
51TIVSCISREPORTSOBSOLETE5IS_DEFAULTOBSOLETE: Report is taken if no default knownnvarchar10
TOPFSCM In-House Cash
52IHC_TAB_VARIANTIHC: Selection Variant8IS_DEFAULTFlag: Variant Is Default Settingnvarchar10
TOPGlobal Organization Customizing
53/MRSS/C_REQ_RWKRegional Defaults for worklists4IS_DEFAULTFlagnvarchar10
TOPGovernance, Risk and Compliance
54GRFNREPCOLUMNReport: Columns7IS_DEFAULTReport: Flag for default columnnvarchar10
55GRFNREPCOLUMNCReport: Columns - customer8IS_DEFAULTReport: Flag for default columnnvarchar10
TOPIncident Recording
56EHHSSC_AFFLANDAffected Land Type4IS_DEFAULTDefault Valuenvarchar10
57EHHSSC_BDYPARTBody Part Code4IS_DEFAULTDefault Valuenvarchar10
58EHHSSC_BDYSIDEBody Side Code4IS_DEFAULTDefault Valuenvarchar10
59EHHSSC_CLUPMTHCleanup Method Code3IS_DEFAULTDefault Valuenvarchar10
60EHHSSC_CSEODTHCause of Death3IS_DEFAULTDefault Valuenvarchar10
61EHHSSC_EST_RSKEstimated Risk4IS_DEFAULTDefault Valuenvarchar10
62EHHSSC_FINCATFinancial Tracking Categories4IS_DEFAULTDefault Valuenvarchar10
63EHHSSC_IMMACTImmediate Action Code3IS_DEFAULTDefault Valuenvarchar10
64EHHSSC_INCAUSEIncident Cause3IS_DEFAULTDefault Valuenvarchar10
65EHHSSC_INCCOBJIncident-Causing Object3IS_DEFAULTDefault Valuenvarchar10
66EHHSSC_INCCOBMMovement of Incident-Causing Object3IS_DEFAULTDefault Valuenvarchar10
67EHHSSC_INCXTINIncident External Influence Code3IS_DEFAULTDefault Valuenvarchar10
68EHHSSC_INC_ASPIncident Aspect Type Code3IS_DEFAULTDefault Valuenvarchar10
69EHHSSC_INC_DUCIncident Duration Classification Code4IS_DEFAULTDefault Valuenvarchar10
70EHHSSC_INC_FREIncident Frequency Code4IS_DEFAULTDefault Valuenvarchar10
71EHHSSC_INC_GRPIncident Group Code4IS_DEFAULTDefault Valuenvarchar10
72EHHSSC_INC_LIKIncident Likelihood Code4IS_DEFAULTDefault Valuenvarchar10
73EHHSSC_INC_RITIncident Risk Type Code3IS_DEFAULTDefault Valuenvarchar10
74EHHSSC_INC_SEVIncident Severity Code5IS_DEFAULTDefault Valuenvarchar10
75EHHSSC_INJILInjury / Illness Code5IS_DEFAULTDefault Valuenvarchar10
76EHHSSC_INJILTPInjury / Illness Type Code5IS_DEFAULTDefault Valuenvarchar10
77EHHSSC_INVGUIDInvestigation Guidelines8IS_DEFAULTDefault Valuenvarchar10
78EHHSSC_LOCATLocation Classification4IS_DEFAULTDefault Valuenvarchar10
79EHHSSC_LOCODTHLocation of Death3IS_DEFAULTDefault Valuenvarchar10
80EHHSSC_MATDSPMDisposal Method Code3IS_DEFAULTDefault Valuenvarchar10
81EHHSSC_MATDSPRMaterial Recovery Method Code3IS_DEFAULTDefault Valuenvarchar10
82EHHSSC_MATDSPSDisposal Site Code3IS_DEFAULTDefault Valuenvarchar10
83EHHSSC_MATSTATMaterial State Code4IS_DEFAULTDefault Valuenvarchar10
84EHHSSC_MATWASTMaterial Waste Type Code3IS_DEFAULTDefault Valuenvarchar10
85EHHSSC_NM_GRPNear Miss Group Code4IS_DEFAULTDefault Valuenvarchar10
86EHHSSC_OCC_TYPOccupational Incident Type Code5IS_DEFAULTDefault Valuenvarchar10
87EHHSSC_PERACTYActivity of Injured Person Code3IS_DEFAULTDefault Valuenvarchar10
88EHHSSC_PERMOVEMovement of Injured Person Code3IS_DEFAULTDefault Valuenvarchar10
89EHHSSC_PERPEQPersonal Protective Equipment Code3IS_DEFAULTDefault Valuenvarchar10
90EHHSSC_PER_ROLPerson Role Code8IS_DEFAULTDefault Valuenvarchar10
91EHHSSC_RCNODECauses and Root Causes5IS_DEFAULTDefault Valuenvarchar10
92EHHSSC_REL_SIZRelease Size Code3IS_DEFAULTDefault Valuenvarchar10
93EHHSSC_REL_TYPRelease Type Code4IS_DEFAULTDefault Valuenvarchar10
94EHHSSC_REPCRITReporting Criteria (OSHA) Code4IS_DEFAULTDefault Valuenvarchar10
95EHHSSC_RES_TYPRestriction Type Code3IS_DEFAULTDefault Valuenvarchar10
96EHHSSC_SO_GRPSafety Observation Group Code4IS_DEFAULTDefault Valuenvarchar10
97EHHSSC_STEPCATIncident Investigation - Step Category6IS_DEFAULTDefault Valuenvarchar10
98EHHSSC_ST_CODEIncident Investigation - Step Code10IS_DEFAULTDefault Valuenvarchar10
99EHHSSC_TCSADEVTechnical Safety Device Code3IS_DEFAULTDefault Valuenvarchar10
100EHHSSC_TR2FAIDTransport to First Aid Code3IS_DEFAULTDefault Valuenvarchar10
101EHHSSC_TRFURTFurther Transport Code3IS_DEFAULTDefault Valuenvarchar10
102EHHSSC_VIOCATViolation Category3IS_DEFAULTDefault Valuenvarchar10
103EHHSSC_VIOSRCEViolation Notice Source3IS_DEFAULTDefault Valuenvarchar10
104EHHSSC_VIOTYPEViolation Type3IS_DEFAULTDefault Valuenvarchar10
105EHHSSC_WNDDRECWind Direction Code3IS_DEFAULTDefault Valuenvarchar10
106EHHSSC_XSLT_TLFilters for Extraction to XML File3IS_DEFAULTDefault Valuenvarchar10
TOPIntegration Builder - Configuration
107SRT_SA_APPL_XISOAP Runtime Framework: SOAP Applications8IS_DEFAULTBoolean Variable (X=True, -=False, Space=Unknown)nvarchar10
TOPIntegration Objects
108EHFNDC_PERGRPPerson Group4IS_DEFAULTDefault Valuenvarchar10
TOPLocations Location Structure
109EHFNDC_LOC_AUTLocation Auth. Group Configuration Table3IS_DEFAULTDefault Valuenvarchar10
110EHFNDC_LOC_EVLEvaluation Path for Position3IS_DEFAULTDefault Valuenvarchar10
TOPNetWeaver Demonstration
111SEPM_PI_RECEIVERObsolete, do not use6IS_DEFAULTSingle-Character Indicatornvarchar10
112SEPM_PI_ROUTINGReceiver Determination6IS_DEFAULTSingle-Character Indicatornvarchar10
TOPPerishables Procurement
113FIP_C_BI_SYSTEMLogical System for BI Data Extraction4IS_DEFAULTDefault Booleannvarchar10
TOPPrice Planning Workbench
114WRFT_PPW_TSHPTreeProfl.4IS_DEFAULTTree Profile is Defaultnvarchar10
TOPPublic Sector Contract Accounts Receivable and Payable
115DFMCA_BRF920BRF: Update Business Partner Industry Code9IS_DEFAULTBRF: Expressionnvarchar200
TOPRecipe Development
116/PLMB/RCA_COSTMPMaterial Prices Selectable in Cost Screen3IS_DEFAULTMaterial Price Used by Defaultnvarchar10
TOPResourcen Management
117FRMLC_COSTS_MMPRRMS-FRM: Material Prices Selectable in Costs Dialog4IS_DEFAULTMaterial Price Used by Defaultnvarchar10
TOPReuse Services for Country Development
118T799BATTRIB02Fixed Values of HR Attributes8IS_DEFAULTFixed Value is Default Valuenvarchar10
TOPRisk Assessment
119EHHSSC_HAZAMNCATAssignment of Amount Categories to Hazards4IS_DEFAULTDefault Valuenvarchar10
120EHHSSC_RASROLEPerson Roles3IS_DEFAULTDefault Valuenvarchar10
121EHHSSC_RASSTEPAssessment Steps6IS_DEFAULTDefault Valuenvarchar10
TOPSales-Based Rent and Settlement
122TIVSRSETTLPARAMSettlement Parameters4IS_DEFAULTIs the Entry the Standard Entrynvarchar10
TOPSAP Business Workflow
123SBPT_CMNDSFWWP: Command Definitions for Class4IS_DEFAULTCheckboxnvarchar10
124SWFDLOGHDRLog Manager: Headers for Log Profiles3IS_DEFAULTIndicator for Standard Profilenvarchar10
TOPService Charge Settlement
125TIVSCSETTLPARAMSettlement Parameters4IS_DEFAULTDefault Value for Service Charge Settlementnvarchar10
TOPService Data Download
126/BDL/BDLFUPIMPService Definition, import parameters for interface6IS_DEFAULTDefaultparameternvarchar10
127/BDL/IFCHA/BDL/SDCC: In/Out-Parameter5IS_DEFAULTnvarchar210
128/BDL/IFIMP/BDL/SDCC: Import-Parameter5IS_DEFAULTnvarchar210
129BDLFUPIMPDefinition of import parameters for one function version5IS_DEFAULTIs default?nvarchar10
130BDLIFCHABDL SDCC: Input/Output Parameters5IS_DEFAULTnvarchar210
131BDLIFIMPBDL SDCC: Import Parameters5IS_DEFAULTnvarchar210
TOPSolution Directory
132SMDTSCOMPTPDTS: Supported Component Types2IS_DEFAULTGeneral Flagnvarchar10
TOPStatus and Action Management
133SAM_STAT_VALUESAM Status values5IS_DEFAULTTo indicate the intial status value of the status variablenvarchar10
TOPSyntax, Compiler, Runtime
134BADI_IMPLImplementations6IS_DEFAULTSingle-Character Indicatornvarchar10
TOPTrading Contract
135PPE_C_GROUP_ASGNAssign Events to Pricing and Payment Events Group4IS_DEFAULTIdentifier for Events to be Defaulted from Customizingnvarchar10
TOPTransaction Manager
136TCORT_USER_VARUser settings for display variant5IS_DEFAULTIs default display variant?nvarchar10
TOPWeb Screen Tools - ABAP
137WDY_UI_AGGR_DEFWeb Dynpro: Definition of View Element Aggregations13IS_DEFAULTGeneral Flagnvarchar10
138WDY_VD_DESIGNDEFWebDynpro ViewDesigner: Description of View Elements18IS_DEFAULTnvarchar10
TOPWeb Service and SOAP - ABAP
139SRTFT_SA_APPLSRT Runtime Framework: SOAP Applications8IS_DEFAULTBoolean Variable (X=True, -=False, Space=Unknown)nvarchar10
140SRT_SA_APPLSOAP Runtime Framework: SOAP Applications8IS_DEFAULTBoolean Variable (X=True, -=False, Space=Unknown)nvarchar10
TOPWorkflows and Tasks for Risk Assessment
141EHHSSC_RVWRESResult Code of Risk Assessment Review3IS_DEFAULTDefault Valuenvarchar10
TOPWorkforce Management Core
142WFDCAPLIMPROCapacity Profile Configuration6IS_DEFAULTFlag (SPACE or 'X')nvarchar10
143WFDOTPROFOvertime Profile Configuration10IS_DEFAULTFlag (SPACE or 'X')nvarchar10