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

32 columns | Print definition?ERP 6.0  | PRTYP

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1TCO60Sequence keys for input facility and verification7PRTYPChecking type: X = validation " " = entry toolnvarchar10
TOPActivity-Based Costing
2CBPRCO-ABC: Activity Master Table11PRTYPCO-ABC: Business Process Typenvarchar20
3CMDT_BPGeneric master record business process enhancements22PRTYPCO-ABC: Business Process Typenvarchar20
TOPActual CostingMaterial Ledger
4CKMLPRKEKOMaterial Ledger: Cost Component Split (Header) for Prices6PRTYPType of Pricenvarchar10
5CKMLPRKEPHMaterial Ledger: Cost Component Split (Elements) for Prices7PRTYPType of Pricenvarchar10
6MLPRKEKOML Document: Cost Component Split (Header)for Prices7PRTYPType of Pricenvarchar10
7MLPRKEPHML Document: Cost Component Split (Components)for Prices8PRTYPType of Pricenvarchar10
TOPBasic Functions
8T061PFI-ARI: External partner products3PRTYPFI-ARI: Product typenvarchar20
9T857PValidation Rules4PRTYPProcessing indicatornvarchar10
TOPBasis-Related Help Functions, Appl. Log, Formula Intepreter
10TPS01Library of the Process Business Transaction Events4PRTYPCall type to alternative processnvarchar10
TOPClinical System
11N2BATMPIS-H*MED: Temporary treatment order17PRTYPLog Type for Temporary Treatment Ordernvarchar10
TOPContract Accounts Receivable and Payable
12DFKKBOLBollo: Italy3PRTYPProcess Typenvarchar20
13TFK007BDTime-Dependent Bollo Amounts (Italy)2PRTYPProcess Typenvarchar20
TOPGlobal Trade Services
14/SAPSLL/PNTPRLegal and Logistics Services: Product Master Mapping4PRTYPProd. Cat. fr. Backend System for Legal and Logistics Serv.nvarchar20
15/SAPSLL/RXPMRe-Export: Log: Products6PRTYPProd. Cat. fr. Backend System for Legal and Logistics Serv.nvarchar20
16/SAPSLL/RXPMRARe-Export: Log: Assemblies in Bill of Product9PRTYPProd. Cat. fr. Backend System for Legal and Logistics Serv.nvarchar20
17/SAPSLL/RXPMRACRe-Export: Log: Components in Assembly6PRTYPProd. Cat. fr. Backend System for Legal and Logistics Serv.nvarchar20
18/SAPSLL/TPRCTSGTS: Product Master: Control Table for Number Procedures2PRTYPProduct Type from Feeder System for Global Trade Servicesnvarchar20
TOPGreat Britain
19PA0085HR Master Record: Infotype 0085 (Work Incapacity Periods GB)29PRTYPIndicator PIW duration limit reached/previous employernvarchar10
TOPIndustry Solution Oil
20TOI0_REL_DOCPRTSelect production document types for relevance (text table)4PRTYPIS-Oil: Production Document Typenvarchar10
21TOI0_REL_PLIS-OIL: Relevance customizing for planned orders3PRTYPIS-Oil: Production Document Typenvarchar10
22TOI0_REL_PL_RANKRanking of Planned Order relevance fields3PRTYPIS-Oil: Production Document Typenvarchar10
23TOI0_REL_PP_RANKRanking of PP relevance fields3PRTYPIS-Oil: Production Document Typenvarchar10
TOPPatient Accounting
24NICPIS-H: Surgical Procedure Codes Performed32PRTYPIS-H: Procedure Typenvarchar20
TOPRouting
25PLKOTask list - header52PRTYPProcess typenvarchar10
TOPSample Management
26QPRSMaster record for phys. samples6PRTYPSample Categorynvarchar10
27TQ44Phys. sample types1PRTYPSample Categorynvarchar10
28TQ44TDescriptions of Physical-Sample Categories2PRTYPSample Categorynvarchar10
29TQREOSQM: Archiving Parameter(s) for Physical Samples3PRTYPSample Categorynvarchar10
TOPTraders and Schedulers Workbench
30TOI0_REL_DOCPRSelect production document types for relevance assignment3PRTYPIS-Oil: Production Document Typenvarchar10
31TOI0_REL_PPIS-OIL: Relevance customizing for PP Documents3PRTYPIS-Oil: Production Document Typenvarchar10
TOPWarehouse Management
32T325WM: QM Interface for Handling Insptection Samples4PRTYPInsp.storage type for stock placementnvarchar30