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

37 columns | Print definition?ERP 6.0  | TYPE_CODE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/MRSS/C_CAR_UNITDay Unit Conversion table2TYPE_CODETime Unit Used in Capacity and Demand Overviewnvarchar10
2DCFLD_TAXEVNT_TVCode List: Product Tax Event Type Code2TYPE_CODETax Event Typenvarchar30
3DCFLD_TAXRATE_TVCode List: Product Tax Rate Type Code3TYPE_CODETax Rate Typenvarchar50
4DCFLD_TAXTYPE_TVCode List: Tax Type Code2TYPE_CODETax Typenvarchar30
5DCFLD_TXEVNTT_TVCode List: Product Tax Event Type Code3TYPE_CODETax Event Typenvarchar30
6DCFLD_TXRATET_TVCode List: Product Tax Rate Type Code4TYPE_CODETax Rate Typenvarchar50
7DCFLD_TXTYPET_TVCode List: Tax Type Code3TYPE_CODETax Typenvarchar30
8EHFNDD_ACTT_TMPLTemplate for Action8TYPE_CODETypenvarchar210
9SADL_RS_BP_ADDRSADL Reference Scenario BusinessPartner~Address4TYPE_CODESADL Reference Scenario Type Codenvarchar50
10SADL_RS_BP_ROOTSADL Reference Scenario BusinessPartner~Root3TYPE_CODESADL Reference Scenario Type Codenvarchar50
11SADL_RS_PR_ROOTSADL Reference Scenario Product~Root4TYPE_CODESADL Reference Scenario Type Codenvarchar50
12SADL_RS_SO_ITEMSSADL Reference Scenario SalesOrder~Items4TYPE_CODESADL Reference Scenario Type Codenvarchar50
13SADL_RS_SO_ROOTSADL Reference Scenario SalesOrder~Root6TYPE_CODESADL Reference Scenario Type Codenvarchar50
14SADL_RS_SO_SLINESADL Reference Scenario SalesOrder~ScheduleLine4TYPE_CODESADL Reference Scenario Type Codenvarchar50
TOPBank Customer Accounts
15RTP_US_PLANRetirement plan data (US enhancement)4TYPE_CODEType code for a retirement plannvarchar20
16TRTP_US_AGE_LIMAge limits for contributions made to a retirement plan2TYPE_CODEType code for a retirement plannvarchar20
17TRTP_US_CONT_DATContribution dates for a retirement plan2TYPE_CODEType code for a retirement plannvarchar20
18TRTP_US_CONT_TYPContribution limits for a retirement plan type2TYPE_CODEType code for a retirement plannvarchar20
19TRTP_US_DFLTDefault values for screen input fields3TYPE_CODEType code for a retirement plannvarchar20
20TRTP_US_FSTATField status for screen fields2TYPE_CODEType code for a retirement plannvarchar20
21TRTP_US_PLANTYPEType of retirement plan1TYPE_CODEType code for a retirement plannvarchar20
22TRTP_US_PLANTYPTType of retirement plan1TYPE_CODEType code for a retirement plannvarchar20
23TRTP_US_PLAN_INFPlan information for a type of retirement plan3TYPE_CODEType code for a retirement plannvarchar20
TOPBusiness Objects, Common Components
24EHFNDC_ACTSUBSubtypes - Dependent on Type2TYPE_CODETypenvarchar210
25EHFNDC_ACTSUB_TSubtypes - Dependent on Type3TYPE_CODETypenvarchar210
TOPConnection to External Systems
26DPR_OBJLINK_SCObject Link to SRM Shopping Carts18TYPE_CODECategory of Shopping Cart/Item (1 = Material, 2 = Service)nvarchar20
27DPR_OBJLINK_SC_IItems for SRM Shopping Cart16TYPE_CODECategory of Shopping Cart/Item (1 = Material, 2 = Service)nvarchar20
TOPMaintenance Orders
28/MRSS/C_PLB_UNITTime unit for planning board profile3TYPE_CODEPlanning Type Code for Assignment Time Unitnvarchar10
TOPNetWeaver Demonstration
29SDEMO_PDSAP NetWeaver Demo Model - Product4TYPE_CODEProduct Type Codenvarchar20
30SDEMO_POPurchase Order Header4TYPE_CODEOrder Typenvarchar40
31SDEMO_SOSAP NetWeaver Demo Model - Sales Order Header4TYPE_CODEOrder Typenvarchar40
32SNWD_PDEPM: Product Data Table4TYPE_CODEEPM: Product Type Codenvarchar20
TOPReusable Components of Business Suite Foundation
33/BOBF/I_ONTCCode List: Object Node Type Code1TYPE_CODEObject Node Type Codenvarchar100
34/BOBF/I_ONTC_TCode List: Object Node Type Code2TYPE_CODEObject Node Type Codenvarchar100
35/BOBF/I_OTCCode List: Object Type Code1TYPE_CODEObject Type Codenvarchar50
36/BOBF/I_OTC_TCode List: Object Type Code2TYPE_CODEObject Type Codenvarchar50
TOPSAP Healthcare - Industry-Specific Components for Hospitals
37TNLGGZ_PRODUCTGeisteskrankheit productkode11TYPE_CODEGeisteskrankheit productkode typenvarchar200