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

39 columns | Print definition?ERP 6.0  | VZSKZ

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/SMD/MD_____003CSID-Tabelle fuer Interest indicator3VZSKZInterest calculation indicatornvarchar20
2/SMD/MD_____00ANSID-Tabelle fuer Interest indicator3VZSKZInterest calculation indicatornvarchar20
3/SMD/MD_____00KDSID-Tabelle fuer Interest indicator3VZSKZInterest calculation indicatornvarchar20
4/SMD/MD_____010DSID-Tabelle fuer Interest indicator3VZSKZInterest calculation indicatornvarchar20
5BBP_PDHSSHdr Extension for SAP Internal Enhancements (IBUs and so on)153VZSKZInterest Calculation Indicatornvarchar20
6CNV_20100_SKB1CNV backup copy for SKB120VZSKZInterest calculation indicatornvarchar20
7T047AAccount Level Dunning Control9VZSKZInterest calculation indicator for calc. of dunning interestnvarchar20
8T056Interest settlement2VZSKZInterest calculation indicatornvarchar20
9T056ATime-dependent conditions2VZSKZInterest calculation indicator or account numbernvarchar100
10T056CFixed Amounts in Interest Calculation2VZSKZInterest calculation indicator or account numbernvarchar100
11T056DForm names for interest for days overdue2VZSKZInterest calculation indicator or account numbernvarchar100
12T056SInterest scale interest terms (acct bal.int.calc.)2VZSKZInterest calculation indicator or account numbernvarchar100
13T056UControl table for calculation of interest on arrears2VZSKZInterest calculation indicator or account numbernvarchar100
14T056XText table for interest indicators3VZSKZInterest calculation indicatornvarchar20
15T056YAssign special G/L indicator to interest indicator2VZSKZInterest calculation indicator or account numbernvarchar100
16TZD0BDarwin: Customer default values per co.cd/trn.type for KNB122VZSKZInterest calculation indicatornvarchar20
TOPBasic Functions
17SKB1G/L account master (company code)19VZSKZInterest calculation indicatornvarchar20
18SKM1Sample G/L accounts19VZSKZInterest calculation indicatornvarchar20
TOPBusiness Partner
19TIVBPVENDORCMPVendor Preassignment (CoCd Data)11VZSKZInterest calculation indicatornvarchar20
TOPDunning
20MHNKDunning data (account entries)19VZSKZInterest calculation indicatornvarchar20
21MHNKODunning data (acct entries) version before the next change20VZSKZInterest calculation indicatornvarchar20
TOPFinancial Accounting
22F107_TPROVMETDProvision Calculation Methods6VZSKZInterest calculation indicatornvarchar20
23KNB1Customer Master (Company Code)25VZSKZInterest calculation indicatornvarchar20
24LFB1Vendor Master (Company Code)12VZSKZInterest calculation indicatornvarchar20
25T056ZInterest Rates2VZSKZInterest calculation indicatornvarchar20
TOPFunds Management-Specific Postings
26FMPSOINTTable for Deferral Interest Formula4VZSKZInterest calculation indicatornvarchar20
TOPInformation System
27DKKOSBalance Audit Trail69VZSKZInterest calculation indicatornvarchar20
28DKOKSOpen Item Account Balance Audit Trail Master Record72VZSKZInterest calculation indicatornvarchar20
29DSKOSBalance Audit Trail22VZSKZInterest calculation indicatornvarchar20
TOPInterest
30TPI02Interest Calculation Profile and Interest Indicator3VZSKZInterest calculation indicatornvarchar20
31TPI04Interest Relevance of Cost Element/Commitment Item Groups4VZSKZInterest calculation indicatornvarchar20
32TZIN2Interest Document:Segment Int.Indicator & Valuation Category3VZSKZInterest calculation indicatornvarchar20
33TZIN3Interest Document: Currency Type Segment3VZSKZInterest calculation indicatornvarchar20
TOPLocalization
34FPIA_INTCAL_INDAssign Successive Interest Indicators2VZSKZInterest calculation indicatornvarchar20
35FPIA_INTERESTTable for Penalty Interest10VZSKZInterest calculation indicatornvarchar20
36FPIA_INT_VZSKZIOA: VZSKZ for Interest Documents1VZSKZInterest calculation indicatornvarchar20
TOPPayment Transactions
37FPIN_T_POSTENDatabase for Penalty Interest (Chorus)17VZSKZInterest calculation indicatornvarchar20
TOPPurchasing
38EKKOPurchasing Document Header100VZSKZInterest calculation indicatornvarchar20
TOPTreasury
39VZKNB1Collector for batch input KNB1 from RF-VV20VZSKZInterest calculation indicatornvarchar20