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

35 columns | Print definition?ERP 6.0  | PSGRP

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1DFKKPARTADJTrigger for Adjustment of Partner Billable Items3PSGRPGrouping Key for Document Itemsnvarchar40
2T7UNCMT_HSFACMT Interface: Hardship Element4PSGRPnvarchar120
3T7UNCMT_MBFACMT Interface: Mobility Element4PSGRPnvarchar120
4T7UNCMT_NRFACMT Interface: Non Removal Element4PSGRPnvarchar120
TOPBasic Functions
5TVAPSales Document: Item Categories7PSGRPApplicationnvarchar40
TOPContract Accounts Receivable and Payable
6DFKKMOPItems in contract account document133PSGRPGrouping Key for Document Itemsnvarchar40
7DFKKMOPKItems in contract account document58PSGRPGrouping Key for Document Itemsnvarchar40
8DFKKOPItems in contract account document133PSGRPGrouping Key for Document Itemsnvarchar40
9DFKKOPKItems in contract account document58PSGRPGrouping Key for Document Itemsnvarchar40
10DFKKOPUSTAXIN00Basic Data for Tax Calculation - Telco Tax (U.S.A.)33PSGRPGrouping Key for Document and Tax Itemsnvarchar40
11DFKKOPUSTAXIN01Basic Data for Tax Calculation - Telco Tax (U.S.A.)33PSGRPGrouping Key for Document and Tax Itemsnvarchar40
12DFKKOPUSTAXIN02Basic Data for Tax Calculation - Telco Tax (U.S.A.)33PSGRPGrouping Key for Document and Tax Itemsnvarchar40
13DFKKOPUSTAXIN03Basic Data for Tax Calculation - Telco Tax (U.S.A.)33PSGRPGrouping Key for Document and Tax Itemsnvarchar40
14DFKKOPUSTAXIN04Basic Data for Tax Calculation - Telco Tax (U.S.A.)33PSGRPGrouping Key for Document and Tax Itemsnvarchar40
15DFKKOPUSTAXIN05Basic Data for Tax Calculation - Telco Tax (U.S.A.)33PSGRPGrouping Key for Document and Tax Itemsnvarchar40
16DFKKOPUSTAXIN06Basic Data for Tax Calculation - Telco Tax (U.S.A.)33PSGRPGrouping Key for Document and Tax Itemsnvarchar40
17DFKKOPUSTAXIN07Basic Data for Tax Calculation - Telco Tax (U.S.A.)33PSGRPGrouping Key for Document and Tax Itemsnvarchar40
18DFKKOPUSTAXIN08Basic Data for Tax Calculation - Telco Tax (U.S.A.)33PSGRPGrouping Key for Document and Tax Itemsnvarchar40
19DFKKOPUSTAXIN09Basic Data for Tax Calculation - Telco Tax (U.S.A.)33PSGRPGrouping Key for Document and Tax Itemsnvarchar40
20DFKKOPUSTAXIN10Basic Data for Tax Calculation - Telco Tax (U.S.A.)33PSGRPGrouping Key for Document and Tax Itemsnvarchar40
21DFKKOPUSTAXIN11Basic Data for Tax Calculation - Telco Tax (U.S.A.)33PSGRPGrouping Key for Document and Tax Itemsnvarchar40
22DFKKOPUSTAXIN12Basic Data for Tax Calculation - Telco Tax (U.S.A.)33PSGRPGrouping Key for Document and Tax Itemsnvarchar40
23DFKKOP_REPOpen Items from FPO4139PSGRPGrouping Key for Document Itemsnvarchar40
24DFKKORDERPOSRequests: Items73PSGRPGrouping Key for Document Itemsnvarchar40
25DFKKORDERPOS_SRequest Templates: Items56PSGRPGrouping Key for Document Itemsnvarchar40
TOPInvoicing in Contract Accounts Receivable and Payable
26DFKKINVDOC_IItems of Invoicing Document60PSGRPGrouping Key for Document Itemsnvarchar40
TOPNon Profit Organizations
27T7UNPAD_EVE_GAGrade Adjustment for Allowances in EVE13PSGRPPay Scale Group(NPO)nvarchar40
28T7UNPAD_GAGrade Adjustment for Mobility Allowances12PSGRPPay Scale Group(NPO)nvarchar40
29T7UNPAD_HSFAHardship flat amounts4PSGRPPay Scale Group(NPO)nvarchar40
30T7UNPAD_MBFAMobility Flat amounts4PSGRPPay Scale Group(NPO)nvarchar40
31T7UNPAD_NRFARemoval/Non Removal Flat amounts4PSGRPPay Scale Group(NPO)nvarchar40
32T7UNPAD_PSGRPY-NPO: Pay Grade Groupings2PSGRPPay Scale Group(NPO)nvarchar40
33T7UNPAD_PSGRTPay Grade Grouping Texttable(NPO)3PSGRPPay Scale Group(NPO)nvarchar40
34T7UNPAD_RSMAGRental Subsidy Maximum Amount Grade Grouping4PSGRPPay Scale Group(NPO)nvarchar40
TOPRoute Settlement
35/DSD/SL_TCSTAMAPDSD Route Settlement:Document Ctrl.Customer Sales Trans.Type12PSGRPApplicationnvarchar40