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

42 columns | Print definition?ERP 6.0  | PRI_GEO_LOC

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1OIURV_TAXTYPESState applicable Tax Types are maintained2PRI_GEO_LOCPrimary geographical location (PRI geo. loc.)nvarchar20
TOPCheck Write
2OIUCW_NRIT_WHStates with Withholding requirement3PRI_GEO_LOCPrimary geographical location (PRI geo. loc.)nvarchar20
TOPContractual Allocation
3OIUCA_ENT_VTCA Allocation Entitlement Volume Types3PRI_GEO_LOCPrimary geographical location (PRI geo. loc.)nvarchar20
TOPProduction and Revenue Accounting
4OIUREP_TAXBACKUPBackup tax table for old tax reporting SOL3PRI_GEO_LOCPrimary geographical location (PRI geo. loc.)nvarchar20
5OIUREP_TIKBACKUPBackup tik table for old tax reporting SOL3PRI_GEO_LOCPrimary geographical location (PRI geo. loc.)nvarchar20
6OIU_CM_LXPGLCountry and Primary Geo. Location Xref3PRI_GEO_LOCPrimary geographical location (PRI geo. loc.)nvarchar20
7OIU_CM_LXPGL_TXDescription of Primary Geographical Locations4PRI_GEO_LOCPrimary geographical location (PRI geo. loc.)nvarchar20
8OIU_CM_LXSGLCross Reference Between Country and Secondary Geo. Locatio3PRI_GEO_LOCPrimary geographical location (PRI geo. loc.)nvarchar20
9OIU_CM_LXSGL_TXDescription of Secondary Geographical Locations4PRI_GEO_LOCPrimary geographical location (PRI geo. loc.)nvarchar20
10OIU_CM_PRESLocation to Pressure Base Xref3PRI_GEO_LOCPrimary geographical location (PRI geo. loc.)nvarchar20
11OIU_CM_SCHDCDSchool district code3PRI_GEO_LOCPrimary geographical location (PRI geo. loc.)nvarchar20
12OIU_CM_SEVTGRPSeverance Type Group Table4PRI_GEO_LOCPrimary geographical location (PRI geo. loc.)nvarchar20
13OIU_CM_TAXCLSTax Class - Table3PRI_GEO_LOCPrimary geographical location (PRI geo. loc.)nvarchar20
14OIU_CM_TAXCLS_TXTax Class - Text4PRI_GEO_LOCPrimary geographical location (PRI geo. loc.)nvarchar20
15OIU_DO_DIBase Venture/DOI Relationship9PRI_GEO_LOCPrimary geographical location (PRI geo. loc.)nvarchar20
16OIU_DO_JVPRA venture extension10PRI_GEO_LOCPrimary geographical location (PRI geo. loc.)nvarchar20
17OIU_PR_DNDelivery Network6PRI_GEO_LOCPrimary geographical location (PRI geo. loc.)nvarchar20
18OIU_PR_MPPRA Measurement Points9PRI_GEO_LOCPrimary geographical location (PRI geo. loc.)nvarchar20
19OIU_PR_WCPRA: Well Completion20PRI_GEO_LOCPrimary geographical location (PRI geo. loc.)nvarchar20
20OIU_RV_CPTDContract Product Tax Reimbursement Detail5PRI_GEO_LOCPrimary geographical location (PRI geo. loc.)nvarchar20
21OIU_RV_MULT_DNMultiple DN for same well10PRI_GEO_LOCPrimary geographical location (PRI geo. loc.)nvarchar20
TOPRevenue
22OIUE2_RUN_HDRProc 2.0 - Run Header11PRI_GEO_LOCPrimary geographical location (PRI geo. loc.)nvarchar20
23OIURV03_CONFIGMP to Well Completion Split Out Config3PRI_GEO_LOCPrimary geographical location (PRI geo. loc.)nvarchar20
24OIURV03_VOLDTLValuation Transaction Level 2 -Volume7PRI_GEO_LOCPrimary geographical location (PRI geo. loc.)nvarchar20
TOPRoyalty Reporting
25OIUREP_VL_VOLGross Volume and Value after VL/RD19PRI_GEO_LOCPrimary geographical location (PRI geo. loc.)nvarchar20
TOPTax Reporting
26OIUX1_ADJ_TAXHCTax adjustments header for reporting23PRI_GEO_LOCPrimary geographical location (PRI geo. loc.)nvarchar20
27OIUX1_TRN_TAXHCTax transaction header for reporting20PRI_GEO_LOCPrimary geographical location (PRI geo. loc.)nvarchar20
28OIUX1_TRN_TAXHLTax transaction header for reporting20PRI_GEO_LOCPrimary geographical location (PRI geo. loc.)nvarchar20
29OIUX3_RPTTax Reporting - Reports5PRI_GEO_LOCPrimary geographical location (PRI geo. loc.)nvarchar20
30OIUX5_OOSWOTax 2.0 - Out Of Statute Write Off3PRI_GEO_LOCPrimary geographical location (PRI geo. loc.)nvarchar20
TOPValuation
31OIURV_DOC_RDSUMRD summary(VL interface records to RD)28PRI_GEO_LOCPrimary geographical location (PRI geo. loc.)nvarchar20
32OIURV_DOC_VOLDTLValuation Transaction Level 2 -Volume7PRI_GEO_LOCPrimary geographical location (PRI geo. loc.)nvarchar20
33OIURV_TAXCONFDState tax configuration detail2PRI_GEO_LOCPrimary geographical location (PRI geo. loc.)nvarchar20
34OIURV_TAXCONFHState tax configuration header2PRI_GEO_LOCPrimary geographical location (PRI geo. loc.)nvarchar20
35OIURV_TCDTax calculation data3PRI_GEO_LOCPrimary geographical location (PRI geo. loc.)nvarchar20
36OIUVL_MTAHMarketing Cost Tax Exemption - Header11PRI_GEO_LOCPrimary geographical location (PRI geo. loc.)nvarchar20
37OIUVL_SEVSeverance tax14PRI_GEO_LOCPrimary geographical location (PRI geo. loc.)nvarchar20
38OIUVL_STTRState Tax Rates2PRI_GEO_LOCPrimary geographical location (PRI geo. loc.)nvarchar20
39OIUVL_TCJVTax Class - Venture DOI's10PRI_GEO_LOCPrimary geographical location (PRI geo. loc.)nvarchar20
40OIUVL_TCMPTax Class Measurement Points8PRI_GEO_LOCPrimary geographical location (PRI geo. loc.)nvarchar20
41OIUVL_TCWCTax Class - Well Completion9PRI_GEO_LOCPrimary geographical location (PRI geo. loc.)nvarchar20
42OIUVL_TTRPDTax Tier Rate by Project - Data6PRI_GEO_LOCPrimary geographical location (PRI geo. loc.)nvarchar20