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

33 columns | Print definition?ERP 6.0  | HERKUNFT

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/SAPF15/RMF15 Rückmeldung Klärungsbestand7HERKUNFTnvarchar20
2/SAPF15/SMF15 SEPA Mandat30HERKUNFTHerkunft SEPA Mandatsbelegnvarchar10
3TQ32Assignment of inspection type to origin2HERKUNFTInspection Lot Originnvarchar20
4TQ33Relevant fields for origin2HERKUNFTInspection Lot Originnvarchar20
5TQ55Assign inspection lot origin for update group2HERKUNFTInspection Lot Originnvarchar20
TOPAdvertising Management
6JJTPRDH_AVORZIS-M/AM: Product Hierarchy (S&P): Assignments Worklist2HERKUNFTIS-M/AM: Origin Keynvarchar20
7JJTPRDH_DACHPRIS-M/AM Product Hierarchy (S&P): Umbrella Products2HERKUNFTIS-M/AM: Origin Keynvarchar20
8JJTPRDH_PRFAGIS-M/AM Prd.Hier.(S&P): Product/External Agency Assignment2HERKUNFTIS-M/AM: Origin Keynvarchar20
9JJTPRDH_PRFAMIS-M/AM Product Hierarchy (S&P): Product Families2HERKUNFTIS-M/AM: Origin Keynvarchar20
10JJTPRDH_PRFGPIS-M/AM: Prdh(S&P) Product/External Business Partner Assgmt2HERKUNFTIS-M/AM: Origin Keynvarchar20
11JJTPRDH_PRGRIS-M/AM Product Hierarchy (S&P): Product Groups2HERKUNFTIS-M/AM: Origin Keynvarchar20
12JJTPRDH_PRODIS-M/AM: Products (S&P Product Hierarchy)2HERKUNFTIS-M/AM: Origin Keynvarchar20
13JJTPRDH_VKTABIS-M/AM Product Hierarchy (S&P): Link Table2HERKUNFTIS-M/AM: Origin Keynvarchar20
14JJTPRDH_WBIS-M/AM (S&P Product Hierarchy): Economic Sectors2HERKUNFTIS-M/AM: Origin Keynvarchar20
TOPBasic Data for Certificates
15QCVKCertificate profile header19HERKUNFTInspection Lot Originnvarchar20
16QCVVCertificate Profile: List of Preliminary Products10HERKUNFTInspection Lot Originnvarchar20
TOPCross-Application Components
17PDS_OPERPDS Data for Operations and Dependent Data14HERKUNFTRouting Sourcenvarchar10
TOPData Collection
18S072Individual Records for Inspection Lot21HERKUNFTInspection Lot Originnvarchar20
TOPEmpties Management
19/BEV1/EMLGKTOEmpties Account9HERKUNFTID for Delivery Note/Invoicenvarchar10
TOPInput Tax Treatment
20VIBEITEMGebuchte Berichtigungen29HERKUNFTHerkunft der Buchungnvarchar10
TOPInspection Lot Completion
21TQ07MQM: Inventory postings with usage decision3HERKUNFTInspection Lot Originnvarchar20
TOPProcess Data Documentation
22MCHPVSBatch Record: Shadow Table for Link to Archive12HERKUNFTInspection Lot Originnvarchar20
TOPQM Control in Procurement
23TQ32AInspection type to status assignment from status profile4HERKUNFTInspection Lot Originnvarchar20
TOPQuality Inspection
24QALSInspection lot record5HERKUNFTInspection Lot Originnvarchar20
25TQ31Inspection Lot Origins1HERKUNFTInspection Lot Originnvarchar20
26TQ31TDescriptions of Inspection Lot Origins2HERKUNFTInspection Lot Originnvarchar20
27TQ32CLot creation allowed values for the origin1HERKUNFTInspection Lot Originnvarchar20
28TQ32C_TTexts for lot creation indicator2HERKUNFTInspection Lot Originnvarchar20
29TQHU2QM assignment of packing object for inspection lot origin2HERKUNFTInspection Lot Originnvarchar20
TOPRemaining Beverage - Obsolete Objects
30/BEV1/RBWEItemized Proof Rebate Settlement53HERKUNFTOrigin Rebate Basis/Rebate Planningnvarchar40
TOPResults Recording
31QIWLTransfer table for QM subsystems20HERKUNFTInspection Lot Originnvarchar20
TOPTreasury
32INDEXWIndex Values (Secur. Index)6HERKUNFTSourcenvarchar100
33THERKPrice source2HERKUNFTSourcenvarchar100