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

38 columns | Print definition?ERP 6.0  | RANKING

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/NAKISA/TMCRANKQualification Value Table2RANKINGRankingnvarchar40
2/NAKISA/TZNBAdditional Data Table For Relationship ZNB9RANKINGRankingnvarchar40
3/NAKISA/TZNCAdditional Data Table For Relationship ZNC10RANKINGRankingnvarchar40
4/NAKISA/TZNDAdditional Data Table For Relationship ZND10RANKINGRankingnvarchar40
5DODP_MAP_SOURCEDBOSC-DP: Map Data Provider to Data Source11RANKINGint100
6DODP_PROCESSORDBOSC-DP: Data Provider Processor7RANKINGint100
7TLRC_FICLASSFinancial Instrument Classification used in Report Type6RANKINGRankingtinyint30
8TLRC_TARO_ALLIDTrade Repository: Allowed ID Categories6RANKINGRankingtinyint30
9TLRC_TARO_FICLASTrade Repository: Allowed Product Classification6RANKINGRankingtinyint30
10HRP1719DB Table for Infotype 171925RANKINGRanknvarchar40
TOPBusiness Partner
11TPZ22Business Partner: Ratings4RANKINGRank of Ratingnvarchar30
TOPDownstream
12TOI0_REL_RES_RNKRanking of Reservation relevance fields4RANKINGIS-OIL: Ranking of relvance fieldsnvarchar30
TOPE-Recruiting
13T77RCF_SRCH_ATBTO BE DELETED - OBSOLETE5RANKINGEnable Rankingnvarchar10
14T77RCF_SRCH_ATBCTO BE DELETED - OBSOLETE6RANKINGEnable Rankingnvarchar10
15T77RCF_SRCH_ATTBTO BE DELETED - OBSOLETE6RANKINGEnable Rankingnvarchar10
16T77RCF_SRCH_ATTCSet Up Attributes for Flexible Search Applications6RANKINGEnable Rankingnvarchar10
17T77RCF_SRCH_ATTRSet Up Attributes for Flexible Search Applications5RANKINGEnable Rankingnvarchar10
TOPIndustry Solution Oil
18TOI0_REL_MM_RANKRanking of MM relevance fields6RANKINGIS-OIL: Ranking of relvance fieldsnvarchar30
19TOI0_REL_NOM_RNKIS-OIL: Ranking of Nomination relvance fields5RANKINGIS-OIL: Ranking of relvance fieldsnvarchar30
20TOI0_REL_PL_RANKRanking of Planned Order relevance fields5RANKINGIS-OIL: Ranking of relvance fieldsnvarchar30
21TOI0_REL_PP_RANKRanking of PP relevance fields5RANKINGIS-OIL: Ranking of relvance fieldsnvarchar30
22TOI0_REL_SD_RANKIS-OIL: Ranking of SD relvance fields5RANKINGIS-OIL: Ranking of relvance fieldsnvarchar30
TOPInterface to Terminal Automation System
23OIKTPIPDTPI Rel.Fields - obsolete - but needed for XPRA ROIKXTPIREL4RANKINGRanking of TAS Relevant fieldsnvarchar30
24TOIKTRVFTAS Relevance Fields and Ranking - Pickup3RANKINGRanking of TAS Relevant fieldsnvarchar30
25TOIKTRVFSTAS Relevance Fields and Ranking - Shipment3RANKINGRanking of TAS Relevant fieldsnvarchar30
TOPOnline Text Repository
26BTFR_TREX_COMPValid TREX Components for OTR Texts3RANKINGDummy for B20 int1 (Local Everywhere)tinyint30
27BTFR_TREX_PACKValid TREX Packages for OTR Texts3RANKING2 byte integer (signed)smallint50
TOPProduct Cost Planning
28TCWB_OBJECTS_HISHistorie zum Testobjekt9RANKINGObjekt-ID für Objekte im Bereich COPC-CATTnvarchar80
29TCWB_PROCESSProzess: Prozeßablauf6RANKINGnvarchar80
TOPRegulatory reporting for insurance companies
30TISSR_IDENT_NRISSR: Definitionstabelle für Identnummer15RANKINGISSR: Feld zur Festlegung der Sortierreihenfolgenvarchar30
31TISSR_TP_C_DYNFISSR: Tabelle zur Feldaussteuerung DSUMB15RANKINGISSR: Feld zur Festlegung der Sortierreihenfolgenvarchar30
TOPTalent Management
32HRPAD740Additional Data for Relationship 'Is Successor Of'11RANKINGRankingnvarchar40
33HRPAD743Additional Data for Relationship 'Is Talent In'10RANKINGRankingnvarchar40
34HRPAD744Additional Data for Relationship ''Has Potential For''11RANKINGRankingnvarchar40
35T77TMCRANKINGRankings2RANKINGRankingnvarchar40
36T77TMCRANKINGTRanking Descriptions3RANKINGRankingnvarchar40
TOPTraders and Schedulers Workbench
37TOI0_REL_TC_RANKTSW relevance ranking for trading contract4RANKINGIS-OIL: Ranking of relvance fieldsnvarchar30
TOPWorkbench Utilities
38SACC_STATESCharacteristic groups3RANKINGtinyint30