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

19 columns | Print definition?ERP 6.0  | PRODUCT_CAT

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1TEXT_CTY_EXPOSCommodity Price Exposure61PRODUCT_CATProduct Categorynvarchar30
2TISSR_RATING_HBHistorie des Wertpapier-Ratings5PRODUCT_CATMeldewesen-Produkttypnvarchar30
3ZMTMPERSCM MtM Persistency12PRODUCT_CATProduct Categorynvarchar30
TOPLoans Management
4TDCOTYP_ACTAssignment Business Operation/Role ---> Correspondence Type10PRODUCT_CATProduct Categorynvarchar30
TOPRegulatory reporting for insurance companies
5ISSRFLDEAActual line item table30PRODUCT_CATnvarchar30
6ISSRFLDECObject table 24PRODUCT_CATnvarchar30
7ISSRFLDEPPlan line items table30PRODUCT_CATnvarchar30
8ISSRFLDETSummary table29PRODUCT_CATnvarchar30
9ISSRPREFLOWISSR: Basistabelle/Bewegungstabelle9PRODUCT_CATISSR: categoria prodotto reportingnvarchar30
10TISSR_ADMIN_FVALFestwertsteuerung für Meldewesen-Stammdatenverwaltung4PRODUCT_CATMeldewesen-Produkttypnvarchar30
11TISSR_IFPCATISSR: Beziehung MW-Produkttyp zu Vorsyst.-Produkttyp3PRODUCT_CATProdukttypnvarchar30
12TISSR_RATING_HHistorie des Wertpapier-Ratings4PRODUCT_CATMeldewesen-Produkttypnvarchar30
TOPTransaction Manager
13TCORT_CODMDDeal: Main Data17PRODUCT_CATProduct Categorynvarchar30
14TCORT_EXT_ASSIGNAssignments of Profiles & BP groups to external recipients7PRODUCT_CATProduct Categorynvarchar30
15TCORT_INB_ASSIGNBP group assignment for Inbound Correspondence5PRODUCT_CATProduct Categorynvarchar30
16TCORT_INT_ASSIGNAssignments of Profiles & BP groups to internal recipients7PRODUCT_CATProduct Categorynvarchar30
17TCORT_SI_DERIVESettlement Instructions: Derivation table5PRODUCT_CATProduct Categorynvarchar30
18TRGC_TAXCFM: Derivation Rules for Tax Flows3PRODUCT_CATProduct Categorynvarchar30
TOPTransfer to Financial Accounting
19TRILT_DTRANSDerived Business Transactions in the Income Ledger7PRODUCT_CATProduct Categorynvarchar30