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

57 columns | Print definition?ERP 6.0  | TRTYP

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1HRP1691DB Table for Infotype 169120TRTYPTrainer Object Typenvarchar20
2PA3319Infotype 331926TRTYPTransfer typenvarchar20
3PA3331HR Master Record: Infotype 333125TRTYPTransfer Typenvarchar20
4T063Screen Control: Inventory Management3TRTYPTransaction typenvarchar10
5T066Screen Selection, Invoice Verification3TRTYPTransaction typenvarchar10
6T158Transaction Control: Inventory Management3TRTYPTransaction typenvarchar10
7T158ITransaction Control: Physical Inventory3TRTYPTransaction typenvarchar10
8T160SAP Transaction Control, Purchasing3TRTYPTransaction typenvarchar10
9T160BSAP Transaction Control, List Displays, Purchasing3TRTYPTransaction typenvarchar10
10T168Screen Control, Purchasing4TRTYPTransaction typenvarchar10
11T169SAP Transaction Control, Invoice Verification/Valuation2TRTYPTransaction typenvarchar10
12T340WM Transactions3TRTYPTransaction typenvarchar10
13T342Control of Screen Sequence in WM4TRTYPTransaction typenvarchar10
14T450PTransaction control for maintaining ind. requirements3TRTYPTransaction typenvarchar10
15T5F99BTEmployee Follow-up : Transfer Type per process/form4TRTYPTransfer Typenvarchar20
16T5F99BTTEmployee Follow-up : Transfer Type per process/form5TRTYPTransfer Typenvarchar20
17TCA05Transaction parameters for routings3TRTYPTransaction typenvarchar10
18TCF06Field groups in the PRT master for reference2TRTYPTransaction typenvarchar10
19TCS05Transaction-Specific Defaults for BOMs4TRTYPTransaction typenvarchar10
20TK180Default Values per Transaction (Screen Sequence Control)4TRTYPTransaction typenvarchar10
TOPAdvertising Management
21B220Output per Organizational Data, Confirmation, No Quasi9TRTYPTransaction typenvarchar10
22B222IS-M/AM: Sales area, transaction type7TRTYPTransaction typenvarchar10
23TJ183IS-M/AM: Customer Function Code Exclusion5TRTYPTransaction typenvarchar10
TOPAllocation
24T623Transaction Control, Standard Distribution3TRTYPTransaction typenvarchar10
TOPBasic Functions
25T180Screen Sequence Control: Transaction Default Values3TRTYPTransaction typenvarchar10
26T856Transaction Types2TRTYPTransaction Typenvarchar30
27T856TTransaction type texts3TRTYPTransaction Typenvarchar30
28T864Reclassifications6TRTYPTransaction type for reclassificationsnvarchar30
TOPClaims Processing Asia
29T7XASTClaims processing transaction table21TRTYPTransaction typenvarchar10
TOPClasses
30TCLRObject-Specific Reports and Transactions4TRTYPFunction typenvarchar10
TOPDemand Management
31T459USettings for Maintaining Planned Independent Requirements3TRTYPTransaction typenvarchar10
TOPEngineering Change Management
32TCC05Transaction-Specific Initial Values for EC Management2TRTYPTransaction Typenvarchar10
TOPExternal Services
33T265Transaction Control: External Services Management3TRTYPTransaction typenvarchar10
TOPFinancial Accounting
34/BGLOCS/FITXCOLVat Tax Codes Assignment to Report Layout Columns7TRTYPTransaction Type reported in VIES declarationnvarchar10
35T856KDefault Transaction Type for FI Accounts5TRTYPTransaction Typenvarchar30
36T856LAssignment of LO Transaction Type to FI Transaction Type4TRTYPTransaction Typenvarchar30
TOPFunds Management
37FMFGAPTRAccountable Property Transaction Type3TRTYPAccountable Property Transaction Typenvarchar30
TOPLease Accounting
38FILA_RE_TR_HTranche Header: Selection Result for Refinancing13TRTYPTranche Typenvarchar10
TOPMarketing Retail Network
39OIFXCUAEXCUA function exclusion (IS-Oil MRN)2TRTYPTransaction typenvarchar10
TOPMaster Data
40TJG68IS-M/SD: Transaction Determination for Business Partner2TRTYPTransaction typenvarchar10
TOPPeriodical Sales and Distribution
41TJ180Initial Values of Transaction in IS-M3TRTYPTransaction typenvarchar10
42TJ181IS-M: GUI Status Control for Function Code Exclusion3TRTYPTransaction typenvarchar10
TOPPersonnel Time Management
43T559FProcessing of Absence Quota Remainders10TRTYPSingle-Character Indicatornvarchar10
TOPProduct Cost Planning
44TCK18Deactivating Functions in Screen Sequence Control4TRTYPTransaction typenvarchar10
TOPProduction Orders
45TCO05CUA status depending on panel, trans. type, funct. type etc.5TRTYPTransaction typenvarchar10
46TCO06Exclusive functions for PP orders3TRTYPTransaction typenvarchar10
TOPRemaining Beverage - Obsolete Objects
47/BEV3/CH180Screen Sequence Control: Transaction Default Values4TRTYPTransaction typenvarchar10
48/BEV3/CH181Subsequent Screen Control: Function Code Exclusion4TRTYPTransaction typenvarchar10
49/BEV3/CH184User-Related Control Table of Transactions6TRTYPTransaction typenvarchar10
TOPRouting
50TC01CUA status table5TRTYPTransaction typenvarchar10
51TC01ASet type of function3TRTYPTransaction typenvarchar10
TOPScreen Sequence Control
52T185FScreen Control: Function Codes2TRTYPTransaction typenvarchar10
TOPTraders and Schedulers Workbench
53OIIXCUAEXCUA Function Exclusion (IS-Oil BDRP)2TRTYPTransaction typenvarchar10
TOPTransaction Manager
54AT02ATransaction Code for Menu TIMN4TRTYPTreasury: Subsequent screen control - initial position groupnvarchar40
55AT185Treasury: Starting Values for Subsequent Screen Control3TRTYPTransaction typenvarchar10
TOPWarehouse Management
56T342TAssignment of Title Bar to PF Status4TRTYPTransaction typenvarchar10
TOPWork Center
57TC10Initial values for CIM screen sequence3TRTYPTransaction typenvarchar10