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

68 columns | Print definition?ERP 6.0  | HIENM

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/BI0/SHIENMMaster Data IDs: InfoObject Hierarchy Name1HIENMHierarchy Namenvarchar300
2CNV_20100_CEFORMCEFORMF records with rel. org. units + addit. VALUE field18HIENMnvarchar300
3RSBPCB_MEM_HIEBPC: BPF Driver Dimension Hierarchy Member Item10HIENMHierarchy namenvarchar300
4RSBPCE_DAP_DIMBPC: DAP Dimension & Hierarchy8HIENMHierarchy namenvarchar300
TOPBusiness Planning
5UPB_HI_REFPlanning Applucations: Reference to Hierarchy2HIENMHierarchynvarchar300
6UPB_YT_HIERARCHYBW Hierarchies: Header Data4HIENMName of Hierarchy (Technical)nvarchar300
TOPBusiness Planning and Simulation
7UPC_NODESHierarchy Node4HIENMHierarchynvarchar300
8UPC_STEPSRelations between Characteristics of a Planning Area6HIENMHierarchynvarchar300
9UPC_VAR_HIEVariables - Hierarchies4HIENMHierarchynvarchar300
10UPC_VAR_HIE_SELVariables - Selections using Hierarchies6HIENMHierarchynvarchar300
11UPC_VAR_HIE_SELAVariables - Selections using Hierarchies (Active Values)6HIENMHierarchynvarchar300
12UPP_DOCPlanning: Layout Builder Info about Document13HIENMHierarchynvarchar300
13UPS_TP_HIERARCHYConnection Subplan-Hierarchy4HIENMHierarchynvarchar300
14UPX_DSRC_HEADUPX: Data Sources - Header5HIENMHierarchynvarchar300
TOPBW Service API
15ROVERFIELHHierarchy using Test Fields in Verification Scenario2HIENMHierarchy namenvarchar300
16ROVERHIEHierarchies in Verification Scenario2HIENMHierarchy namenvarchar300
17ROVERHIETHierarchy Texts in Verification Scenario3HIENMHierarchy namenvarchar300
TOPControlling
18FCOMIPHIEDIRUnique Ids for extracted Hierarchies4HIENMHierarchy namenvarchar300
TOPData Basis
19RSHIEDIRHierarchy Catalog4HIENMHierarchy namenvarchar300
20RSMDUCMUKHIERUT Hierarchy: Identifying attributes for MUKs5HIENMHierarchy namenvarchar300
TOPData Mining
21RSDMTP_BAT_HRHDRBW Hierarchy Creation - Hierarchy Header Details2HIENMHierarchy namenvarchar300
TOPData Staging
22RSHIEDONESelection table for Fields Scheduler5HIENMCustomer-Defined Hierarchy Namenvarchar300
23RSLDPSELSelection table for fields scheduler18HIENMCustomer-Defined Hierarchy Namenvarchar300
24RSLDPSELHISTSelection Table for Fields of Scheduler - Changes/History19HIENMCustomer-Defined Hierarchy Namenvarchar300
25RSLDPSELSHSelection table for fields scheduler17HIENMCustomer-Defined Hierarchy Namenvarchar300
26RSOSOHIEDirectory for Master Data Hierarchies4HIENMCustomer-Defined Hierarchy Namenvarchar300
27RSOSOHIESHShadow Table: Hierarchy Information in BW4HIENMCustomer-Defined Hierarchy Namenvarchar300
28RSOSOHIETDirectory for Master Data Hierarchies - Texts5HIENMCustomer-Defined Hierarchy Namenvarchar300
29RSOSOHIETSHShadow Table: Hierarchy Information in BW5HIENMCustomer-Defined Hierarchy Namenvarchar300
TOPEnd User Technology
30RSRA_BP_OBJECTSParts of the Batch Printing Setting22HIENMHierarchy namenvarchar300
31RSRA_ER_DRILLDrill Characteristics for the Exception Reporting Setting7HIENMHierarchy namenvarchar300
32RSVHSUSERSETAValue help services user setting A segment3HIENMHierarchy namenvarchar300
33RSVHSUSERSETB1Value help services user settings List of display Attributes3HIENMHierarchy namenvarchar300
34RSVHSUSERSETB2Value help services user List of Favourites and History3HIENMHierarchy namenvarchar300
35RSVHSVALUESETValue help services user setting A segment4HIENMHierarchy namenvarchar300
36RSZELTPROPElement properties (settings)44HIENMHierarchy namenvarchar300
37RSZGLOBVGlobal Variables in Reporting32HIENMHierarchy namenvarchar300
38RSZRANGESelection specification for an element20HIENMHierarchy namenvarchar300
TOPInformation System
39TCNDSStructure overview - Project Info System6HIENMGroup Namenvarchar150
TOPInteractive Drilldown Reporting
40TRSTHVBRST directory of hierarchies8HIENMName of hierarchynvarchar300
41TRSTHVTBRST Texts for hierarchies9HIENMName of hierarchynvarchar300
42TRSTHV_VPBRST Repository of Hierarchies - Virtual InfoProvider9HIENMName of hierarchynvarchar300
TOPOLAP Technology
43RSDDAGGRCOMPDescription of the aggregates10HIENMHierarchy namenvarchar300
44RSDDTPS_HIER_HNMHierarchies for Use in Polestar3HIENMHierarchy namenvarchar300
45RSDDTPS_HIER_IPAssignment of Hiers to InfoProvider/InfoObject Combination5HIENMHierarchy namenvarchar300
46RSSAUTHHIERDefinition of the Authorizations for Hierarchies4HIENMHierarchy namenvarchar300
TOPOverhead Cost Controlling
47BWOM_RHIERBCT-CO: Report Row Hierarchies3HIENMHierarchy namenvarchar300
48BWOM_RHIERTBCT-CO: Texts for Report Row Hierarchies4HIENMHierarchy namenvarchar300
49BWOM_RHIER_LINEBCT-CO: Rows for Report Row Hierarchies3HIENMHierarchy namenvarchar300
50BWOM_RHIER_LINETBCT-CO: Row Texts for Report Row Hierarchies4HIENMHierarchy namenvarchar300
TOPPlanning
51RSPLF_SRV_CONDRule Condition in Planning Service15HIENMHierarchy namenvarchar300
52RSPLF_SRV_PSParameter Value (Selection Type)17HIENMHierarchy namenvarchar300
53RSPLS_CR_RANGEChar.Relationship: Range (for example, for DataStore Object)15HIENMHierarchy namenvarchar300
54RSPLS_CR_STEPSRelationships Between Characteristics in Basic InfoProvider7HIENMHierarchy namenvarchar300
55RSPLS_DS_RANGEData Slices: Selection15HIENMHierarchy namenvarchar300
TOPPlant Maintenance
56TEQUI_HIERDefinition of Hierarchies for Equipment2HIENMHierarchy namenvarchar300
57TEQUI_HIERTText Table for TEQUI_HIER2HIENMHierarchy namenvarchar300
58TFUNCT_LOC_HIERDefinition of Hierarchies for Functional Locations2HIENMHierarchy namenvarchar300
59TFUNCT_LOC_HIERTText Table for TFUNCT_LOC_HIER2HIENMHierarchy namenvarchar300
TOPProfitability Analysis
60CEFORMFCO: Definition of contents of element in row/col.str.17HIENMName of hierarchynvarchar300
TOPStakeholder Relationship Management
61USS_BW_HIERARCHYUSTH0: BW Hierarchy3HIENMHierarchynvarchar300
TOPWithout Description
62RSBCTCBHIENMContent Broswer Hierarchy Technical Names1HIENMHierarchy namenvarchar300
63RSBCTCBHIENMTContent Browser Hierarchy Texts1HIENMHierarchy namenvarchar300
64RSRBDIMDimension table including the print settings25HIENMHierarchy namenvarchar300
65RSROLEHIENMList of available role hierarchies1HIENMHierarchy namenvarchar300
66RSROLEHIENMTTexts for available role hierarchies1HIENMHierarchy namenvarchar300
67RSROLENODESNodes for role hierarchy1HIENMHierarchy namenvarchar300
68RSROLENODESTnode texts for role hierarchy1HIENMHierarchy namenvarchar300