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

64 columns | Print definition?ERP 6.0  | OBSOLETE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/NAKISA/HRP9820DB Table for Infotype 982023OBSOLETEObsolete datanvarchar10
2/NAKISA/HRP9824DB Table for Infotype 982431OBSOLETEObsolete datanvarchar10
3/NAKISA/THRADZNHTable for additional data relationship ZNK/ZNL16OBSOLETEObsolete datanvarchar10
4/OPT/VIM_T104BProcess Screen Options - Category Specific10OBSOLETEObsoletenvarchar10
5/OPT/X076Process Screen Options10OBSOLETEObsoletenvarchar10
6/OPT/Y076Process Screen Options10OBSOLETEObsoletenvarchar10
7/OPT/Z076Process Screen Options10OBSOLETEObsoletenvarchar10
8/SAPSRM/C_SWITCHDefinition of Customizing Switches and their Attributes20OBSOLETEObsolete Customizing Switchnvarchar10
9/SDF/CC_RELLink between CC_OBJECTS and CC_REF entries29OBSOLETESingle-Character Indicatornvarchar10
10BTP_DL_OBJECTBTP Object26OBSOLETEBTP Object Flag 'Obsolete'nvarchar10
11CNVMBTPEMProcess Execution Plan / Groups / Blocks15OBSOLETEFlag (X = yes, initial = no)nvarchar10
12DFKKPICLARIFITPenalty and Interest Clarification Case: Processed objects9OBSOLETEObject in the Clarification Case is Obsoletenvarchar10
13EHFNDC_AREPCAccidental Release Environmental Precaution3OBSOLETEIndicator for Obsolete Statementsnvarchar10
14EHFNDC_ARMCUCAccidental Release Method for Cleaning up3OBSOLETEIndicator for Obsolete Statementsnvarchar10
15EHFNDC_ARPPCAccidental Release Personal Precaution3OBSOLETEIndicator for Obsolete Statementsnvarchar10
16EHFNDC_CHCOLORColors of Chemicals3OBSOLETEIndicator for Obsolete Statementsnvarchar10
17EHFNDC_CHODOROdor of Chemicals3OBSOLETEIndicator for Obsolete Statementsnvarchar10
18EHFNDC_CTQUESTControl Inspection Question3OBSOLETEIndicator for Obsolete Statementsnvarchar10
19EHFNDC_FAECFirst Aid Eye Contact3OBSOLETEIndicator for Obsolete Statementsnvarchar10
20EHFNDC_FAFHCFirst Aid Hint for Physician3OBSOLETEIndicator for Obsolete Statementsnvarchar10
21EHFNDC_FAGACFirst Aid General Advice3OBSOLETEIndicator for Obsolete Statementsnvarchar10
22EHFNDC_FAICFirst Aid Inhalation3OBSOLETEIndicator for Obsolete Statementsnvarchar10
23EHFNDC_FAINGCFirst Aid Ingestion3OBSOLETEIndicator for Obsolete Statementsnvarchar10
24EHFNDC_FASCCFirst Aid Skin Contact3OBSOLETEIndicator for Obsolete Statementsnvarchar10
25EHFNDC_FFSEMFire Fight Suitable Extinguishing Media3OBSOLETEIndicator for Obsolete Statementsnvarchar10
26EHFNDC_FFUEMFire Fight Unsuitable Extinguishing Media3OBSOLETEIndicator for Obsolete Statementsnvarchar10
27EHFNDC_METHMethod of Use of the Chemical3OBSOLETEIndicator for Obsolete Statementsnvarchar10
28EHFNDC_PPEEPEye Protection3OBSOLETEIndicator for Obsolete Statementsnvarchar10
29EHFNDC_PPEHMHygiene Measure3OBSOLETEIndicator for Obsolete Statementsnvarchar10
30EHFNDC_PPEHPHand Protection3OBSOLETEIndicator for Obsolete Statementsnvarchar10
31EHFNDC_PPERPRespiratory Protection3OBSOLETEIndicator for Obsolete Statementsnvarchar10
32EHFNDC_PPESPSkin and Body Protection3OBSOLETEIndicator for Obsolete Statementsnvarchar10
33EHFNDC_PURPPurpose of the Chemical3OBSOLETEIndicator for Obsolete Statementsnvarchar10
34EHFNDC_WSOLWater Solubility Remark3OBSOLETEIndicator for Obsolete Statementsnvarchar10
35SATC_CI_REASONSExemption reasons3OBSOLETEReason is obsoletenvarchar10
36STC_BASSCN_HDRTask List Group Header Data9OBSOLETEBoolean Variable (X=True, Space=False)nvarchar10
37/BOBF/CONF_CONVConversion types5OBSOLETEData element for domain BOOLE: TRUE (='X') and FALSE (=' ')nvarchar10
TOPAuthoring Environment
38LSOLUTYPE_CLearning Net Types5OBSOLETEObsolete for Usenvarchar10
39LSOLU_CLearning Nets9OBSOLETEObsolete for Usenvarchar10
TOPBRFplus - ABAP-Based Business Rules
40FDT_ADMN_0000FDT: Central Administrative Data18OBSOLETEData element for domain BOOLE: TRUE (='X') and FALSE (=' ')nvarchar10
41FDT_ADMN_0000AFDT: Central Administrative Data18OBSOLETEData element for domain BOOLE: TRUE (='X') and FALSE (=' ')nvarchar10
42FDT_ADMN_0000SFDT: Central Administrative Data17OBSOLETEData element for domain BOOLE: TRUE (='X') and FALSE (=' ')nvarchar10
43FDT_ADMN_0000TFDT: Central Administrative Data17OBSOLETEData element for domain BOOLE: TRUE (='X') and FALSE (=' ')nvarchar10
44FDT_ADMN_0001FDT: Central Administrative Data - Transport7OBSOLETEData element for domain BOOLE: TRUE (='X') and FALSE (=' ')nvarchar10
45FDT_ADMN_0001AFDT: Central Administrative Data - Transport7OBSOLETEData element for domain BOOLE: TRUE (='X') and FALSE (=' ')nvarchar10
46FDT_ADMN_0001SFDT: Central Administrative Data - Transport6OBSOLETEData element for domain BOOLE: TRUE (='X') and FALSE (=' ')nvarchar10
47FDT_ADMN_0001TFDT: Central Administrative Data - Transport6OBSOLETEData element for domain BOOLE: TRUE (='X') and FALSE (=' ')nvarchar10
TOPBudget Management
48T7PMMCombinations of Rules and Budget Structure Element Types11OBSOLETEIndicator: Rule Type Obsoletenvarchar10
TOPBusiness Object Builder
49SWOTDVObject Type Verbs Definition34OBSOLETERelease in which object type was set as obsoletenvarchar40
50SWOTLVRuntime Table Verbs53OBSOLETERelease in which object type was set as obsoletenvarchar40
51TOJTBBusiness object repository: Basic data38OBSOLETERelease in which object type was set as obsoletenvarchar40
TOPClinical System
52N2GL_BASEITEMIS-H*MED: Basic Item of Treatment Pathway7OBSOLETEIS-H: Boolean Data Type for ON (= "X") and OFF (= " ")nvarchar10
TOPCross-Application Components
53/PTGWFI/F_PIRAPSWorkflow Runtime Stack for Parked Invoices13OBSOLETERun Statusnvarchar10
TOPData Staging
54RSOLTPSOURCEReplicate Table for OLTP Sources in BW28OBSOLETEIndicator: The DataSource Is Obsoletenvarchar10
TOPDevelopment Workbench
55BSPWD_PAGDIR_EXTO2PAGDIR Enhancement Table3OBSOLETEBoolean Variable (X=True, -=False, Space=Unknown)nvarchar10
TOPFinancial Accounting
56/OPT/VIM_T104Process Screen Options10OBSOLETEObsoletenvarchar10
TOPFlexible Real Estate Management
57TIVCAOBJTYPEAllowed Object Type2OBSOLETEObsolete?nvarchar10
TOPFunction Builder
58RODIRReleased Objects Directory6OBSOLETECharacter 1 change document relevantnvarchar10
TOPPackage Tools
59FRODIRObsolete: Index of Frozen Objects4OBSOLETEnvarchar10
TOPPosition Budgeting and Control
60T77HRFPMFINEXC1Reason for Alternative Financing Requirement4OBSOLETEReason for Alt. Financing Requirement Obsoletenvarchar10
TOPRuntime for ABAP based automated TC
61STC_SCN_HDRTask List Header Data10OBSOLETETask List is Obsoletenvarchar10
TOPSAP Business Workflow
62SWASYSTFLDWF: List of system fields with categorization5OBSOLETECheckboxnvarchar10
TOPSearch
63CRMC_UI_ROLE_CSCentral Search Objects supported by Business Role7OBSOLETEEntry is Obsoletenvarchar10
TOPSwitch Framework Tools
64SFW_BFBusiness Function11OBSOLETEBusiness Function must not be switched on againnvarchar10