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

23 columns | Print definition?ERP 6.0  | PPA_RSN_CD

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPProduction and Revenue Accounting
1OIUREP_TAXBACKUPBackup tax table for old tax reporting SOL20PPA_RSN_CDPrior Period Adjustment Reason Codenvarchar20
2OIUREP_TIKBACKUPBackup tik table for old tax reporting SOL20PPA_RSN_CDPrior Period Adjustment Reason Codenvarchar20
3OIU_CM_PPARSNPrior Period Adjustments - TBLCM0282PPA_RSN_CDPrior Period Adjustment Reason Codenvarchar20
4OIU_CM_PPARSN_TXPrior Period Adjustment Reason Codes - TBLCM028 - TEXT3PPA_RSN_CDPrior Period Adjustment Reason Codenvarchar20
5OIU_RV_RVTRejected Valuation Transactions17PPA_RSN_CDPrior Period Adjustment Reason Codenvarchar20
6OIU_RV_VLRPTValuation Reporting14PPA_RSN_CDPrior Period Adjustment Reason Codenvarchar20
7OIU_RV_VLRVSValuation Reversal Notificaton13PPA_RSN_CDPrior Period Adjustment Reason Codenvarchar20
8OIU_RV_VLTXNSValuation Transactions21PPA_RSN_CDPrior Period Adjustment Reason Codenvarchar20
9OIU_RV_VPPNValuation Prior Period Notification12PPA_RSN_CDPrior Period Adjustment Reason Codenvarchar20
10OIU_RV_VPPNMManually Created Valuation Prior Period Notifications12PPA_RSN_CDPrior Period Adjustment Reason Codenvarchar20
11OIU_RV_VPPNUValuation Prior Period Notification12PPA_RSN_CDPrior Period Adjustment Reason Codenvarchar20
TOPRevenue
12OIURV03_DTL_BKValuation Transactions Level 1 - Vltxns21PPA_RSN_CDPrior Period Adjustment Reason Codenvarchar20
13OIURV03_DTL_ZEValuation Transactions Level 1 - Zero Volume34PPA_RSN_CDPrior Period Adjustment Reason Codenvarchar20
TOPTax Reporting
14OIUX1_ADJ_TAXHCTax adjustments header for reporting22PPA_RSN_CDPrior Period Adjustment Reason Codenvarchar20
15OIUX1_TRN_TAXHCTax transaction header for reporting19PPA_RSN_CDPrior Period Adjustment Reason Codenvarchar20
16OIUX1_TRN_TAXHLTax transaction header for reporting19PPA_RSN_CDPrior Period Adjustment Reason Codenvarchar20
TOPValuation
17OIURV_DOC_DTL_BKValuation Transactions Level 1 - Vltxns21PPA_RSN_CDPrior Period Adjustment Reason Codenvarchar20
18OIURV_DOC_DTL_RVValuation Reversal Notificaton16PPA_RSN_CDPrior Period Adjustment Reason Codenvarchar20
19OIURV_DOC_DTL_ZEValuation Transactions Level 1 - Zero Volume34PPA_RSN_CDPrior Period Adjustment Reason Codenvarchar20
20OIURV_SSTDSettlement statement detail12PPA_RSN_CDPrior Period Adjustment Reason Codenvarchar20
21OIUVL_PPN_REJSELPPN - Reject Selection4PPA_RSN_CDPrior Period Adjustment Reason Codenvarchar20
22OIUVL_SCAUDITSettlement statement batch81PPA_RSN_CDPrior Period Adjustment Reason Codenvarchar20
23OIUVL_SEVSeverance tax13PPA_RSN_CDPrior Period Adjustment Reason Codenvarchar20