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

144 columns | Print definition?ERP 6.0  | ROOT_KEY

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/CPD/D_MP_PROJ_8Qualification of Project Member3ROOT_KEYNodeIDvarbinary160
2/CPD/D_MP_PROJ_9Qualification of Project Member3ROOT_KEYNodeIDvarbinary160
3/CPD/D_MP_RESPResponsibility Node3ROOT_KEYNodeIDvarbinary160
4/CPD/D_MP_ST_ARVTable for Status Area version3ROOT_KEYNodeIDvarbinary160
5/CPD/D_MP_ST_HRAStatus Header Area3ROOT_KEYNodeIDvarbinary160
6/CPD/D_MP_TEAM_MTeam Member Subnode3ROOT_KEYNodeIDvarbinary160
7/CPD/D_MP_TEAM_RTeam Role Subnodes3ROOT_KEYNodeIDvarbinary160
8/CPD/D_MP_TM_RESResponsibility assigned to a Team3ROOT_KEYNodeIDvarbinary160
9/CPD/D_PFP_MSMapped Structure3ROOT_KEYNodeIDvarbinary160
10/CPD/D_PFP_PVTXTPlan Version Description Text3ROOT_KEYNodeIDvarbinary160
11/IAM/D_ACT_DTXTDescription Text3ROOT_KEYNodeIDvarbinary160
12/IAM/D_ACT_FOA_PFollow Up Action Parameter3ROOT_KEYNodeIDvarbinary160
13/IAM/D_ACT_OR_DTLanguage dependant description texts3ROOT_KEYNodeIDvarbinary160
14/IAM/D_I_DESC_TXLanguage dependant description texts node DB table3ROOT_KEYNodeIDvarbinary160
15/IAM/D_I_OREF_DTLanguage dependant reference desc. texts node DB table3ROOT_KEYNodeIDvarbinary160
16BOE_ACTION_REQBoe action request4ROOT_KEYGlobal Unique ID for tablevarbinary160
17BOE_BLANK_NOTESBlank Notes4ROOT_KEYGlobal Unique ID for tablevarbinary160
18BOE_COL_ITEMCollection item data table4ROOT_KEYGlobal Unique ID for tablevarbinary160
19BOE_COUNT_HEADERBOE Count Header4ROOT_KEYGlobal Unique ID for tablevarbinary160
20BOE_COUNT_ITEMBOE Count Item4ROOT_KEYGlobal Unique ID for tablevarbinary160
21BOE_CUS_ITEMCustody item data table4ROOT_KEYGlobal Unique ID for tablevarbinary160
22BOE_DIS_ITEMDiscount item data table4ROOT_KEYGlobal Unique ID for tablevarbinary160
23BOE_DOCBoe Document4ROOT_KEYGlobal Unique ID for tablevarbinary160
24BOE_D_EXCEPTException Data of BOE Counting4ROOT_KEYGlobal Unique ID for tablevarbinary160
25BOE_D_INVENTORYMaking inventory of bill of exchange receivable4ROOT_KEYGlobal Unique ID for tablevarbinary160
26BOE_D_INVE_ITEMTable of BOE Counting Item4ROOT_KEYGlobal Unique ID for tablevarbinary160
27BOE_D_LOCKLock Data of BOE Counting4ROOT_KEYGlobal Unique ID for tablevarbinary160
28BOE_END_ITEMEndorse item data table4ROOT_KEYGlobal Unique ID for tablevarbinary160
29BOE_OP_HISTORYOperation history data table4ROOT_KEYGlobal Unique ID for tablevarbinary160
30BOE_PAY_ITEMPayment item data table4ROOT_KEYGlobal Unique ID for tablevarbinary160
31BOE_PLE_ITEMPledge item data table of BoE management4ROOT_KEYGlobal Unique ID for tablevarbinary160
32BOE_REF_DOCReference documnet for BoE4ROOT_KEYGlobal Unique ID for tablevarbinary160
33EHFNDD_ACTT_TITLTemplate Title for Action3ROOT_KEYNodeIDvarbinary160
34EHFNDD_CHA_STEPChemical Approval - Step3ROOT_KEYNodeIDvarbinary160
35EHFNDD_CHA_STPTXChemical Approval - Step Name / Description3ROOT_KEYNodeIDvarbinary160
36EHFNDD_CHMDETChemical Details4ROOT_KEYNodeIDvarbinary160
37EHFNDD_CHM_BINFOChemical - Basic Info3ROOT_KEYNodeIDvarbinary160
38EHFNDD_CHM_CINChemical - Company Internal Names3ROOT_KEYNodeIDvarbinary160
39EHFNDD_CHM_FIGHTChemical - Fire Fight Measures3ROOT_KEYNodeIDvarbinary160
40EHFNDD_CHM_F_AIDChemical - First Aid Measures3ROOT_KEYNodeIDvarbinary160
41EHFNDD_CHM_GRIEHFNDS_CHM_GERMAN_REG_INFO_D3ROOT_KEYNodeIDvarbinary160
42EHFNDD_CHM_HCEWGChemical - Hazard Classification GWS3ROOT_KEYNodeIDvarbinary160
43EHFNDD_CHM_HCLSSChemical - Hazard Classificationi3ROOT_KEYNodeIDvarbinary160
44EHFNDD_CHM_HINGChemical - Hazardous Ingredients3ROOT_KEYNodeIDvarbinary160
45EHFNDD_CHM_HSTMTChemical - Hazard Statement3ROOT_KEYNodeIDvarbinary160
46EHFNDD_CHM_LNKCChemical - Linked Chemcial3ROOT_KEYNodeIDvarbinary160
47EHFNDD_CHM_MATChemical - Material3ROOT_KEYNodeIDvarbinary160
48EHFNDD_CHM_NAMEChemical - Name3ROOT_KEYNodeIDvarbinary160
49EHFNDD_CHM_PPEQChemical - Personal Protective Equipment3ROOT_KEYNodeIDvarbinary160
50EHFNDD_CHM_PROPchemical - Physical and Chemical Properties3ROOT_KEYNodeIDvarbinary160
51EHFNDD_CHM_RLSChemical - Accidental Release3ROOT_KEYNodeIDvarbinary160
52EHFNDD_CHM_ROLEChemical - Role3ROOT_KEYNodeIDvarbinary160
53EHFNDD_CHM_RSEWGChemical - Risk Statement EWG3ROOT_KEYNodeIDvarbinary160
54EHFNDD_CHM_SYNChemical - Synonym3ROOT_KEYNodeIDvarbinary160
55EHFNDD_CHM_TNAMEChemical - Trade Name3ROOT_KEYNodeIDvarbinary160
56EHFNDD_CHM_VFIChemical - Vendor Registration Information3ROOT_KEYNodeIDvarbinary160
57EHFNDD_CHM_VPChemical - Vapour Pressure3ROOT_KEYNodeIDvarbinary160
58EHFNDD_CHM_WCPChemical - Workplace Control Parameters3ROOT_KEYNodeIDvarbinary160
59EHFNDD_DOCDETDocument Details4ROOT_KEYNodeIDvarbinary160
60EHFNDD_LHR_PATHHierarchy Location - Path3ROOT_KEYNodeIDvarbinary160
61EHFNDD_LOC_RESPLocation - Responsible Person3ROOT_KEYNodeIDvarbinary160
62EHFNDD_REGL_EXSRList of Exemptions for Substance3ROOT_KEYNodeIDvarbinary160
63EHFNDD_TS_AMNTime Series - Amounts4ROOT_KEYNodeIDvarbinary160
64EHFNDD_TS_CHKRTime Series: Check Result3ROOT_KEYNodeIDvarbinary160
65EHFNDD_TS_DHTime Series: Data History3ROOT_KEYNodeIDvarbinary160
66EHFNDD_TS_VRUAssigned Validation Rules to Time Series4ROOT_KEYNodeIDvarbinary160
67EHHSSD_ABAGT_COMAirborne Agent - Component3ROOT_KEYNodeIDvarbinary160
68EHHSSD_ABAGT_HAZAirborne Agent - Hazard3ROOT_KEYNodeIDvarbinary160
69EHHSSD_ABAGT_TXTAirborne Agent - Name3ROOT_KEYNodeIDvarbinary160
70EHHSSD_CINSP_CNControl Inspection - Note on Control3ROOT_KEYNodeIDvarbinary160
71EHHSSD_CINSP_QNQuestion Text3ROOT_KEYNodeIDvarbinary160
72EHHSSD_CINSP_QUControl Inspection - Question3ROOT_KEYNodeIDvarbinary160
73EHHSSD_CMA_IMPChemical Agent - Impacts3ROOT_KEYNodeIDvarbinary160
74EHHSSD_HSP_TCRITProtocol - Triggering Criteria3ROOT_KEYNodeIDvarbinary160
75EHHSSD_PRQ_OBJProcess Control - Context Object for RAS Request3ROOT_KEYNodeIDvarbinary160
76EHHSSD_PRQ_TXTProcess Control - Text Collection for RAS Request4ROOT_KEYNodeIDvarbinary160
77EHHSSD_RSK_AGENTRisk Agent3ROOT_KEYNodeIDvarbinary160
78EHHSSD_RSK_COMPLRisk Completion Status3ROOT_KEYNodeIDvarbinary160
79EHHSSD_RSK_HSPRisk - HS Protocol3ROOT_KEYNodeIDvarbinary160
80EHHSSD_SEG_AGTSimilar Exposure Group - Agent3ROOT_KEYNodeIDvarbinary160
81EHHSSD_SEG_JOBSimilar Exposure Group - Job3ROOT_KEYNodeIDvarbinary160
82EHHSSD_SEG_LOCSimilar Exposure Group - Location3ROOT_KEYNodeIDvarbinary160
83EHHSSD_SEG_NAMESimilar Exposure Group - Name3ROOT_KEYNodeIDvarbinary160
84EHHSSD_SEG_TEAMSimilar Exposure Group - Team Member3ROOT_KEYNodeIDvarbinary160
85EHHSSD_SI_RISKSafety Instruction - Risk4ROOT_KEYNodeIDvarbinary160
86EHHSSD_SPLCP_EXPExposures - #GENERATED#3ROOT_KEYNodeIDvarbinary160
87EHHSSD_SPLCP_OPSOperational Status Values - #GENERATED#3ROOT_KEYNodeIDvarbinary160
88EHHSSD_SPLCP_SPLReferences to Samplings - #GENERATED#3ROOT_KEYNodeIDvarbinary160
89EHPRCD_COD_CHKLCheck Log3ROOT_KEYNodeIDvarbinary160
90EHPRCD_COD_CHKRCheck Result3ROOT_KEYNodeIDvarbinary160
91EHPRCD_COD_DECDeclarable Substance Information3ROOT_KEYNodeIDvarbinary160
92EHPRCD_COD_PSNDPSN Declaration3ROOT_KEYNodeIDvarbinary160
93EHPRCD_PBB_BM_RQRequested BiOMs3ROOT_KEYNodeIDvarbinary160
94EHPRCD_PBB_CR_RQRequested + ass. relevant Comp. Requirem3ROOT_KEYNodeIDvarbinary160
95EHPRCD_TASK_MIGTask to Workflow Migration table3ROOT_KEYNodeIDvarbinary160
96EHPRCD_WL_CA_RACompl. Assmnt. Worklist - Assigend Requirements3ROOT_KEYNodeIDvarbinary160
97ZEHPRC_D_CM_SMLTConflict Mineral Smelter Data3ROOT_KEYNodeIDvarbinary160
98ZEHPRC_D_SELECTESelected CMRs3ROOT_KEYNodeIDvarbinary160
99/BOBF/DAC_DATABOPF: Generic Data Storage for Rapid Prototyping4ROOT_KEYnvarchar320
TOPBusiness Objects, Common Components
100EHFNDD_BO_ASAVEBOBF BO auto save5ROOT_KEYNodeIDvarbinary160
101EHFNDD_MAP_BOPATPath of Mapped BO Node3ROOT_KEYNodeIDvarbinary160
102EHFNDD_MAP_DPCODSource Code for Data Provider3ROOT_KEYNodeIDvarbinary160
TOPIncident Recording
103EHHSSD_INC_DAMIncident - Damage3ROOT_KEYNodeIDvarbinary160
104EHHSSD_INC_EQUIncident - Equipment3ROOT_KEYNodeIDvarbinary160
105EHHSSD_INC_FCTRLInvestigation Control Effectiveness3ROOT_KEYNodeIDvarbinary160
106EHHSSD_INC_FREETInvestigation Freetext step3ROOT_KEYNodeIDvarbinary160
107EHHSSD_INC_FTRANIncident - Financial Transaction3ROOT_KEYNodeIDvarbinary160
108EHHSSD_INC_H_SHealth and Safety database table3ROOT_KEYNodeIDvarbinary160
109EHHSSD_INC_INJILIncident - Injury / Illness3ROOT_KEYNodeIDvarbinary160
110EHHSSD_INC_INSTPInvestigation Step3ROOT_KEYNodeIDvarbinary160
111EHHSSD_INC_INVGUIncident Investigation guideline3ROOT_KEYNodeIDvarbinary160
112EHHSSD_INC_INVSRInvestigation Summary Report3ROOT_KEYNodeIDvarbinary160
113EHHSSD_INC_PASSIncident - Vehicle Passenger4ROOT_KEYNodeIDvarbinary160
114EHHSSD_INC_PINITIncident - Person Initial Recording3ROOT_KEYNodeIDvarbinary160
115EHHSSD_INC_PINJIIncident - Person Injured Information3ROOT_KEYNodeIDvarbinary160
116EHHSSD_INC_PROLEIncident - Person Role3ROOT_KEYNodeIDvarbinary160
117EHHSSD_INC_PROPIncident - Property3ROOT_KEYNodeIDvarbinary160
118EHHSSD_INC_PSTATIncident - Person Statement3ROOT_KEYNodeIDvarbinary160
119EHHSSD_INC_RCAUSIncident - Root Cause3ROOT_KEYNodeIDvarbinary160
120EHHSSD_INC_RELCUIncident - Release Cleanup3ROOT_KEYNodeIDvarbinary160
121EHHSSD_INC_RELMAIncident - Release Material3ROOT_KEYNodeIDvarbinary160
122EHHSSD_INC_RESDUIncident Restricted Duty database table3ROOT_KEYNodeIDvarbinary160
123EHHSSD_INC_RIASSIncident - Risk Assessment3ROOT_KEYNodeIDvarbinary160
124EHHSSD_INC_TIDATIncident - Time Data3ROOT_KEYNodeIDvarbinary160
125EHHSSD_INC_VEHICIncident - Vehicle3ROOT_KEYNodeIDvarbinary160
TOPIncident Reporting
126EHHSSD_IRT_CCRECReport Cc Receivers3ROOT_KEYNodeIDvarbinary160
TOPLean Staffing
127SAWE_D_TIME_PSISAWE Time Planning Sheet Item4ROOT_KEYNodeIDvarbinary160
TOPLocations Location Structure
128EHFNDD_LHR_HIERHierarchy Location - Hierarchy3ROOT_KEYNodeIDvarbinary160
129EHFNDD_LOC_PARTNLocation - Partners3ROOT_KEYNodeIDvarbinary160
130EHFNDD_LOC_TEXTLocation - Text Name3ROOT_KEYNodeIDvarbinary160
TOPMaintenance Processing
131/MRSS/D_BAS_ASGMRS Basis Assignments11ROOT_KEYGUIDvarbinary160
TOPReusable Components of Business Suite Foundation
132/BOBF/DM_SORDITTItem Texts3ROOT_KEYNodeIDvarbinary160
133/BOBF/D_TXCCONTextContent3ROOT_KEYNodeIDvarbinary160
134/BOFU/DDMOSORDTXSales Order Item Text3ROOT_KEYNodeIDvarbinary160
135/BOFU/DTSTSORDTXSales Order Item Text3ROOT_KEYNodeIDvarbinary160
TOPRisk Assessment
136EHHSSD_AGT_LREVAgent - Limit Revision3ROOT_KEYNodeIDvarbinary160
137EHHSSD_AGT_LVALAgent - Limit Value3ROOT_KEYNodeIDvarbinary160
138EHHSSD_RSK_ANLYSRisk Analysis3ROOT_KEYNodeIDvarbinary160
139EHHSSD_RSK_CTRLRisk - Control3ROOT_KEYNodeIDvarbinary160
140EHHSSD_RSK_EFFControl Effectiveness3ROOT_KEYNodeIDvarbinary160
141EHHSSD_RSK_IMPRisk - Impact3ROOT_KEYNodeIDvarbinary160
142EHHSSD_RSK_OELOEL Comparison Values3ROOT_KEYNodeIDvarbinary160
143EHHSSD_RSK_REGULRisk regulation3ROOT_KEYNodeIDvarbinary160
TOPSelf-Service Procurement
144/SRMERP/D_ACC_ITAccount assignment item3ROOT_KEYNodeIDvarbinary160