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

38 columns | Print definition?ERP 6.0  | ABDAT

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1ZEIM_VBAPSales Document: Item Data26ABDATReconciliation Date for Agreed Cumulative Quantitynvarchar80
TOPActual Revenues and Forecast
2TEBCOCO/SD Interface: Product Number Determination from CO8ABDATCO/SC key conversion: Entry valid from ...nvarchar80
TOPBasic Functions
3T035ZLiquidity Forecast: Payment Date Determinations/Assignments8ABDATStart Date for Regular Payment Date Determinationnvarchar80
TOPCollectionsDisbursements
4VKKINTERESTHISTInt. Calc. History for Deposit Acct4ABDATTime Stamp (Date and Time)nvarchar140
5VVKKICLARDepost Int Calc: Clarif. Cases for Int Calc4ABDATTime Stamp (Date and Time)nvarchar140
6VVKKICLARIOBSec. Acct Int. Calc. Acc. to Ins. Obj.: Clarification Cases5ABDATBase date for interest calculationnvarchar80
7VVKKIHISTDeposit Acct Interest Calc: History (Detail)8ABDATBase date for interest calculationnvarchar80
8VVKKIHISTIOBSec. Acct Int. Calc. Acc. to Ins. Obj.: History (Detail)14ABDATBase date for interest calculationnvarchar80
9VVKKRKBEZLegal Relationships-Account4ABDATTime Stamp (Date and Time)nvarchar140
TOPContract Accounts Receivable and Payable
10DFKKBOLBollo: Italy14ABDATBollo: Payment Datenvarchar80
11DFKKIAFI-CA: Database table for FKKIA - intrst supp9ABDATBase date for interest calculationnvarchar80
12DFKKIAPTInterest Calculation: Log for Interest Run14ABDATBase date for interest calculationnvarchar80
13DFKKIHFI-CA: Table with Interest History9ABDATBase date for interest calculationnvarchar80
14DFKKWOHWrite-Off History13ABDATDatenvarchar80
15DFKKWOHTMPTemporary Write-Off History13ABDATDatenvarchar80
16FKK_JLRK_SHORTHeader Data for IS-M/SD Service Settlement - Extracts9ABDATIS-M: Settlement Datenvarchar80
TOPCross-Application Components
17VVBAPSales Document: Item Data26ABDATReconciliation Date for Agreed Cumulative Quantitynvarchar80
TOPGeneric Contract Accounts Receivable and Payable
18DFSCICLARIOBBal. Int. Calculation at Contract Acct Level: Clarif. Cases4ABDATBase date for interest calculationnvarchar80
19DFSCIHISTIOBBalance Int. Calculation at Contract Account Level: History13ABDATBase date for interest calculationnvarchar80
TOPPeriodical Sales and Distribution
20JLCOMMINDIS-M: Commission Index10ABDATIS-M: Billing/Settlement Datenvarchar80
21JLRKIS-M/SD: Settlement Header Data8ABDATIS-M: Settlement Datenvarchar80
22TJL53IS-M/SD: Log for Settlement Transfer6ABDATReconciliation Date for Agreed Cumulative Quantitynvarchar80
TOPPosition Budgeting and Control
23HRFPM_CHANGE_LOGHRFPM: change_log12ABDATError datenvarchar80
24HRFPM_ENGINE_LOGHRFPM: Central Log of Commitment Run10ABDATError datenvarchar80
25HRFPM_OBJECTSHRFPM: Object table of the commitment engine14ABDATError datenvarchar80
TOPProduct Catalog
26WWMIProduct catalog8ABDATProduct catalog valid fromnvarchar80
TOPProduct Cost Planning
27CKTC_CBEWCosting Master Data - Attributes21ABDATValidity Date Fromnvarchar80
TOPPurchasing
28EKPOPurchasing Document Item63ABDATReconciliation Date for Agreed Cumulative Quantitynvarchar80
TOPReal Estate Management
29VIWB01Teile der Hauptwirtschaftlichkeitsberechnung7ABDATWB: Gültig-bis-Datumnvarchar80
TOPRemaining Beverage - Obsolete Objects
30/BEV1/CLSCHShip Information4ABDATDeparture Datenvarchar80
31/BEV1/RBVBAPSales Document: Item Data26ABDATReconciliation Date for Agreed Cumulative Quantitynvarchar80
TOPRouting
32PLKOTask list - header25ABDATDate of the last callnvarchar80
33PLKZTask list: main header5ABDATDate of the last callnvarchar80
TOPSales
34VBAPSales Document: Item Data26ABDATReconciliation Date for Agreed Cumulative Quantitynvarchar80
TOPSample Management
35QPRSMaster record for phys. samples27ABDATStorage Deadline for Physical Samplenvarchar80
TOPSAP Healthcare - Industry-Specific Components for Hospitals
36NWCH90Fee-Based Services31ABDATDepreciation Datenvarchar80
37NWCHPAKLZIS-H CH: Patientenabrechnung - LstVerteilung Nachträge10ABDATIS-H CH: data della fatturazione corrispondentenvarchar80
TOPSimulation
38VSVBAP_CNVersion: Sales document: Item data27ABDATReconciliation Date for Agreed Cumulative Quantitynvarchar80