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

51 columns | Print definition?ERP 6.0  | MAHNS

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1IDUN_C_ASDCAdditional Customizing for ASDC4MAHNSDunning levelnvarchar10
2MHNDDunning Data31MAHNSOld dunning levelnvarchar10
3T047AAccount Level Dunning Control11MAHNSDunning level from which all due items are to be totalednvarchar10
4T047BDunning level control3MAHNSDunning levelnvarchar10
5T047CDunning charges4MAHNSDunning levelnvarchar10
6T047EForm selection for dunning notices6MAHNSDunning levelnvarchar10
7T047HMarginal amounts4MAHNSDunning levelnvarchar10
8TZR3Application area / external role allocation8MAHNSDunning levelnvarchar10
TOPAccounting
9VDDUNN_DISPDunning run data per loan and dunning run7MAHNSDunning Levelnvarchar10
TOPAccounts Receivable Accounting Process Integration
10FDM_COLL_DUNNLEVHarmonized Dunning Levels3MAHNSDunning levelnvarchar10
TOPBasic Functions
11KNKKF1Credit Management: FI Status Data12MAHNSA/R Summary: Dunning Level (Highest Dunning Level)nvarchar10
TOPCollectionsDisbursements
12TKKINFCOV01Info Container: Reaching/Ending a Dunning Level3MAHNSDunning Levelnvarchar20
13TKKVMAKTDunning Activities3MAHNSDunning Levelnvarchar20
14TKKVTELE010AIns. Dunning: Telephone Collections: STATUS Determination3MAHNSDunning Levelnvarchar20
15VVKKMAKTExecuted Dunning Activities9MAHNSDunning Levelnvarchar20
16VVKKMHISTContract-Related Dunning History11MAHNSDunning Levelnvarchar20
TOPContract Accounts Receivable and Payable
17DFKKCFDUNTELTelephone List for Dunning14MAHNSDunning Levelnvarchar20
18DFKKCIBWFICA: Extraction of Cleared Items15MAHNSDunning Levelnvarchar20
19DFKKCOMACorrespondence Dunning12MAHNSDunning Levelnvarchar20
20DFKKOPBWOI Extraction19MAHNSDunning Levelnvarchar20
21DFKKWLIWork Items21MAHNSDunning Levelnvarchar20
22DFKKWLIAWork Items (Work Item Type)21MAHNSDunning Levelnvarchar20
23FKKMAKODunning History Header36MAHNSDunning Levelnvarchar20
24FKKMAZEDunning history of line items17MAHNSDunning Levelnvarchar20
25IST_C_BTACTDUNAssignment of Dunning Levels and Disconnection Activities3MAHNSDunning Levelnvarchar20
26IST_LOCK_PROP_DBDis/Reconnection Proposals Table for IS-T Services in RM-CA12MAHNSDunning Levelnvarchar20
27IST_WLTELIS-T/CA: Work List: Reconnect Tel. No. <- Post Document 002013MAHNSDunning Levelnvarchar20
28TFK047BDunning level control3MAHNSDunning Levelnvarchar20
29TFK047BTDunning level texts4MAHNSDunning Levelnvarchar20
30TFK047CUpper/lower amounts for dunning4MAHNSDunning Levelnvarchar20
31TFK047MFI-CA Dunning: Dunning Activities3MAHNSDunning Levelnvarchar20
32TFK047OUpper/lower amounts for dunning4MAHNSDunning Levelnvarchar20
TOPDunning
33MHNKDunning data (account entries)18MAHNSDunning levelnvarchar10
34MHNKODunning data (acct entries) version before the next change19MAHNSDunning levelnvarchar10
TOPFinancial Accounting
35KNB5Customer master (dunning data)8MAHNSDunning levelnvarchar10
36LFB5Vendor master (dunning data)8MAHNSDunning levelnvarchar10
TOPInformation System
37DKKOSBalance Audit Trail67MAHNSDunning levelnvarchar10
38DKOKSOpen Item Account Balance Audit Trail Master Record70MAHNSDunning levelnvarchar10
TOPLoans Management
39TD47EForm selection for dunning notices5MAHNSDunning levelnvarchar10
40TDSOZSpecial interest indicator for loans3MAHNSDunning levelnvarchar10
41TTONFTVDARLTest neue Fima: Grunddaten und VDARL84MAHNSMahnstufenvarchar10
42VDARLLoans70MAHNSDunning levelnvarchar10
43VDDUNNDunning run data per loan and dunning run7MAHNSDunning levelnvarchar10
TOPReceivablesPayment Management
44TDPAYMSAssignment Dunning Level Payment Status Stop Codes3MAHNSDunning levelnvarchar10
TOPRental Accounting
45TIVEXFIDUNNBPDunning Parameters per BP Role5MAHNSDunning levelnvarchar10
TOPTreasury
46TZV07Alloc.of application/role category/dunning parameters5MAHNSDunning levelnvarchar10
TOPValue Adjustment
47/IBS/CRB_PWVKKRBD Valuation Basis for Flat-Rate Value Adjustment Procedure4MAHNSRBD: Dunning Level Source Systemnvarchar10
48/IBS/TRB_TTY_BALRBD RBD Balances per Flow Type19MAHNSRBD: Dunning Level Source Systemnvarchar10
49/IBS/TRB_UERBD RBD Individual Documents44MAHNSRBD: Dunning Level Source Systemnvarchar10
50/IBS/TRB_UE_HISTRBD RBD History of Individual Documents45MAHNSRBD: Dunning Level Source Systemnvarchar10
51/IBS/TRB_VS_SALDRBD Individual Document Table15MAHNSRBD: Dunning Level Source Systemnvarchar10