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

108 columns | Print definition?ERP 6.0  | BWAPPL

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1RSBPCA_APPLBPC model information8BWAPPLBW Application (Namespace)nvarchar100
2RSBPCA_APPSETBPC Environment information8BWAPPLBW Application (Namespace)nvarchar100
3RSBPCA_ENVMBPC Environment information7BWAPPLBW Application (Namespace)nvarchar100
4RSBPCB_SOBJBPC: BPF Semantic Object9BWAPPLBW Application (Namespace)nvarchar100
5RSBPCB_SOBJ_LKBPC: Semantic object link12BWAPPLBW Application (Namespace)nvarchar100
6RSBPCB_TEMPLATEBPC: BPF Template header10BWAPPLBW Application (Namespace)nvarchar100
7RSBPCE_PROFILEProfile/Role Mapping12BWAPPLBW Application (Namespace)nvarchar100
8RSBPCE_TEAMBPC: Team10BWAPPLBW Application (Namespace)nvarchar100
9RSBPCK_AOBPC IP Extension : Primary Object Table11BWAPPLBW Application (Namespace)nvarchar100
10RSBPCR_RESOURCEBPC: Persistence Resource10BWAPPLBW Application (Namespace)nvarchar100
11RSCNVRRHDRemodeling rule header8BWAPPLBW Application (Namespace)nvarchar100
12RSDHAMAPHANA Analysis Processes15BWAPPLBW Application (Namespace)nvarchar100
13RSDHAOBJTYPETypes of Analysis Elements15BWAPPLBW Application (Namespace)nvarchar100
14RSDHA_PROC_MDProcedure Metadata15BWAPPLBW Application (Namespace)nvarchar100
15RSFBPOpen ODS View8BWAPPLBW Application (Namespace)nvarchar100
16RSOADSODatastore Object6BWAPPLBW Application (Namespace)nvarchar100
17RSOADSOCONVADSO: Pending conversions (must be identical to RSOADSO)6BWAPPLBW Application (Namespace)nvarchar100
18RSOHCPRHanaCompositeProvider7BWAPPLBW Application (Namespace)nvarchar100
TOPAnalysis Process Designer
19RSANT_PROCESSRepository for Process Definitions9BWAPPLBW Application (Namespace)nvarchar100
TOPCorporate Performance Monitor
20UMK_MB000Measure Catalog7BWAPPLBW Application (Namespace)nvarchar100
21UMK_MB100Key Figures: Header Table7BWAPPLBW Application (Namespace)nvarchar100
22UMR_RI000Risk: Category8BWAPPLBW Application (Namespace)nvarchar100
23UMR_RI010Risk: Group8BWAPPLBW Application (Namespace)nvarchar100
24UMR_RI100Risk: Master10BWAPPLBW Application (Namespace)nvarchar100
TOPData Basis
25RSBOHDESTDirectory of Open Hub Destinations10BWAPPLBW Application (Namespace)nvarchar100
26RSBSPOKEInfoSpokes Directory20BWAPPLBW Application (Namespace)nvarchar100
27RSBSPOKEVInfoSpoke Directory: Versions20BWAPPLBW Application (Namespace)nvarchar100
28RSCNVCGHEADERRemodeling Rule header8BWAPPLBW Application (Namespace)nvarchar100
29RSDCUBEDirectory of InfoCubes / InfoProvider7BWAPPLBW Application (Namespace)nvarchar100
30RSDODSODirectory of all DataStores7BWAPPLBW Application (Namespace)nvarchar100
31RSLPOLogical Partitioning: Directory of LPOs11BWAPPLBW Application (Namespace)nvarchar100
TOPData Mining
32RSDMTPN_COL_PARAParameters for the Model Columns15BWAPPLBW Application (Namespace)nvarchar100
33RSDMTPN_COL_VALModel Column Values19BWAPPLBW Application (Namespace)nvarchar100
34RSDMTPN_MODELAnalytical Models using the services available15BWAPPLBW Application (Namespace)nvarchar100
35RSDMTPN_MOD_COLColumns that make the analytical model19BWAPPLBW Application (Namespace)nvarchar100
36RSDMTPN_MOD_DSCDescription in Different Language9BWAPPLBW Application (Namespace)nvarchar100
37RSDMTPN_MOD_PARAParameters for the Model14BWAPPLBW Application (Namespace)nvarchar100
38RSDMTP_COL_MAPMapping Model column to Data Source11BWAPPLBW Application (Namespace)nvarchar100
39RSDMTP_COL_PARAMParameters for the Model Columns15BWAPPLBW Application (Namespace)nvarchar100
40RSDMTP_COL_VALModel Column Values16BWAPPLBW Application (Namespace)nvarchar100
41RSDMTP_DATA_SRCData source for Training or Prediction20BWAPPLBW Application (Namespace)nvarchar100
42RSDMTP_DSRC_BWDMining Source to Datasource Relation18BWAPPLBW Application (Namespace)nvarchar100
43RSDMTP_MODELAnalytical Models using the services available15BWAPPLBW Application (Namespace)nvarchar100
44RSDMTP_MOD_COLColumns that make the analytical model19BWAPPLBW Application (Namespace)nvarchar100
45RSDMTP_MOD_DSCDescription in Different Language9BWAPPLBW Application (Namespace)nvarchar100
46RSDMTP_MOD_PARAMParameters for the Model14BWAPPLBW Application (Namespace)nvarchar100
TOPData Staging
47RSAFORMBW Formulas - Check Table10BWAPPLBW Application (Namespace)nvarchar100
48RSAROUTABAP routine - check table10BWAPPLBW Application (Namespace)nvarchar100
49RSBKDTPBW: Data Transfer Process Header Data32BWAPPLBW Application (Namespace)nvarchar100
50RSBKDTPHDTP: Historic Versions32BWAPPLBW Application (Namespace)nvarchar100
51RSDADAPBW: Data Archiving Process Header Data6BWAPPLBW Application (Namespace)nvarchar100
52RSEVENTHEADHeader for the event chain16BWAPPLBW Application (Namespace)nvarchar100
53RSINSPInspection Plan8BWAPPLBW Application (Namespace)nvarchar100
54RSISNInfoSource - Header Table7BWAPPLBW Application (Namespace)nvarchar100
55RSLDPIOLog.data packet: No.15BWAPPLBW Application (Namespace)nvarchar100
56RSLDPIOSHLog.data packet: No.12BWAPPLBW Application (Namespace)nvarchar100
57RSLGRHIEHierarchy of the InfoPackage groups of the Scheduler14BWAPPLBW Application (Namespace)nvarchar100
58RSTRANTransformation7BWAPPLBW Application (Namespace)nvarchar100
59RSUPDINFOUpdate info (status and program)14BWAPPLBW Application (Namespace)nvarchar100
TOPData Warehousing Workbench
60RSDFDMODDirectory of Data Flows8BWAPPLBW Application (Namespace)nvarchar100
61RSGMDDMODDirectory for Data Model8BWAPPLBW Application (Namespace)nvarchar100
62RSIWADFLOWListing of the Data Flow7BWAPPLBW Application (Namespace)nvarchar100
TOPEnd User Technology
63RSAOOBJAnalysis Office: Primary Object Table10BWAPPLBW Application (Namespace)nvarchar100
64RSDASDirectory of Data Access Services7BWAPPLBW Application (Namespace)nvarchar100
65RSERHEADERReport Designer: Header Table BEx Report9BWAPPLBW Application (Namespace)nvarchar100
66RSER_ELEM_HEADERReport Designer: Header Table BEx Report Elements10BWAPPLBW Application (Namespace)nvarchar100
67RSKPI_CATKPI Catalog: Node13BWAPPLBW Application (Namespace)nvarchar100
68RSKPI_KPIKPI: Header Data16BWAPPLBW Application (Namespace)nvarchar100
69RSKPI_VNTKPI Variant: Header Data15BWAPPLBW Application (Namespace)nvarchar100
70RSRA_PACKAGEScheduling Packages for the Report Agent9BWAPPLBW Application (Namespace)nvarchar100
71RSRA_SETTINGSettings for the Report Agent7BWAPPLBW Application (Namespace)nvarchar100
72RSRD_SETTINGBroadcasting Settings17BWAPPLBW Application (Namespace)nvarchar100
73RSXCLSHEADXcelsius Header Table13BWAPPLBW Application (Namespace)nvarchar100
74RSZCOMPDIRDirectory of reporting components10BWAPPLBW Application (Namespace)nvarchar100
75RSZWBITMHEADHeader Table for BW Web Items18BWAPPLBW Application (Namespace)nvarchar100
76RSZWBTMPHEADHeader Table for BW HTML Templates20BWAPPLBW Application (Namespace)nvarchar100
77RSZWITEMHeader Table for BW Web Items18BWAPPLBW Application (Namespace)nvarchar100
78RSZWMDITEMBW Web Metadata: Template Item ( Dataprovider, Item, ... ).22BWAPPLBW Application (Namespace)nvarchar100
79RSZWMDPARAMWeb Item, Dataprovider and command parameters23BWAPPLBW Application (Namespace)nvarchar100
80RSZWTEMPLATEHeader Table for BW HTML Templates20BWAPPLBW Application (Namespace)nvarchar100
81RSZWVIEWHeader Table for BW Views21BWAPPLBW Application (Namespace)nvarchar100
TOPMetadata Repository
82RSDAREADirectory of InfoAreas7BWAPPLBW Application (Namespace)nvarchar100
83RSDIOBCInfoObject catalogs7BWAPPLBW Application (Namespace)nvarchar100
84RSDIOBJDirectory of all InfoObjects8BWAPPLBW Application (Namespace)nvarchar100
85RSOBIXPHeader Data for BIXP Conversion Objects11BWAPPLBW Application (Namespace)nvarchar100
86RSPSPACEPartner Namespace for BW Objects3BWAPPLBW Application (Namespace)nvarchar100
87RSQISETDirectory of all InfoSets7BWAPPLBW Application (Namespace)nvarchar100
TOPOLAP Technology
88RSBBSCUBEDIRBW: Directory of the InfoCube Sender7BWAPPLBW Application (Namespace)nvarchar100
89RSBBSQUERYDIRBW: Directory of the Query Sender8BWAPPLBW Application (Namespace)nvarchar100
90RSCURTRTCurrency Translation Types23BWAPPLBW Application (Namespace)nvarchar100
91RSDDAGGRDIRDirectory of the aggregates28BWAPPLBW Application (Namespace)nvarchar100
92RSECBIAUHeader Table for TLOGO BI Authorization BIAU7BWAPPLBW Application (Namespace)nvarchar100
93RSHIERTHJT"Temporal Hierarchy Join" - Types12BWAPPLBW Application (Namespace)nvarchar100
94RSRVARIANTDIRDirectory of Variants for Queries and Selection Objects7BWAPPLBW Application (Namespace)nvarchar100
95RSUOMTRTQuantity Conversion Types16BWAPPLBW Application (Namespace)nvarchar100
TOPPlanning
96RSISCPCall Package: Catalog7BWAPPLBW Application (Namespace)nvarchar100
97RSPLF_SRVPlanning Service9BWAPPLBW Application (Namespace)nvarchar100
98RSPLF_SRVTYPEDefinition of Planning Service Type9BWAPPLBW Application (Namespace)nvarchar100
99RSPLS_ALVLPlanning: Primary Table for Aggregation Levels8BWAPPLBW Application (Namespace)nvarchar100
100RSPLS_CR_HEADCharacteristic Relationships: Header Table9BWAPPLBW Application (Namespace)nvarchar100
101RSPLS_DS_HEADData Slices: Header Table9BWAPPLBW Application (Namespace)nvarchar100
102RSPLS_SEQUENCEPlanning Sequence9BWAPPLBW Application (Namespace)nvarchar100
TOPWithout Description
103RSAPPLApplication components directory11BWAPPLBW Application (Namespace)nvarchar100
104RSNSPACENamespace and Namespace Assignments for BW Objects1BWAPPLBW Application (Namespace)nvarchar100
105RSNSPACETEMPLTemplates for BW Applications1BWAPPLBW Application (Namespace)nvarchar100
106RSRBPRINTPROPGlobal print settings for printing27BWAPPLBW Application (Namespace)nvarchar100
107RSRPRVARGROUPVariant groups for batch printing8BWAPPLBW Application (Namespace)nvarchar100
108RSRVPACKAGEDirectory of Contents of Test Packages of Test/Repair Tool7BWAPPLBW Application (Namespace)nvarchar100