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

26 columns | Print definition?ERP 6.0  | OFFIC

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1DFKKCJT_WDRWHCash Journal: Historical Data for Withdrawal Posting2OFFICBranch in Cash Journalnvarchar30
2DFKKEXC_BAppendix to External Payment Information2OFFICBranch in Cash Journalnvarchar30
3T7SA17HSponsor ID Entity Table11OFFICSponsor officer in charge namenvarchar200
TOPBenefits
4PA0171HR Master Record: Infotype 0171 (Gen. Benefits Information)33OFFICBenefit company officernvarchar10
5PA0375HR Master Data Record: Infotype 0375 (Add. Benefits Inform.)24OFFICBenefit company officernvarchar10
TOPContract Accounts Receivable and Payable
6DFKKCDLOTSLot Management for Cash Desk and External Cash Desk Services6OFFICBranch in Cash Journalnvarchar30
7DFKKCJCCash Desk Closing Data2OFFICBranch in Cash Journalnvarchar30
8DFKKCJFTransfer Accepted Payments2OFFICBranch in Cash Journalnvarchar30
9DFKKCJMCash Journal Master Data2OFFICBranch in Cash Journalnvarchar30
10DFKKCJMTText Table for Cash Journal Master Data3OFFICBranch in Cash Journalnvarchar30
11DFKKCJTTransaction Data for Cash Journal2OFFICBranch in Cash Journalnvarchar30
12DFKKCJT_CHDSKText Table for Internal IDs of Cash Desks3OFFICBranch in Cash Journalnvarchar30
13DFKKCJT_OFFICText Table for Internal IDs of Branches3OFFICBranch in Cash Journalnvarchar30
14DFKKCJ_CHDSKInternal ID of Cash Desks2OFFICBranch in Cash Journalnvarchar30
15DFKKCJ_CHDSK_EXExternal ID for Cash Desks for Offline Branches and Agents4OFFICBranch in Cash Journalnvarchar30
16DFKKCJ_OFFICInternal ID of Offline or Agent Branches2OFFICBranch in Cash Journalnvarchar30
17DFKKCJ_OFFIC_EXExternal ID for Offline Branch/Agent and Assgt to Intern. ID3OFFICBranch in Cash Journalnvarchar30
18DFKKEXCExternal Payment Information2OFFICBranch in Cash Journalnvarchar30
19DFKKEXCJCash Journal: Data Store for Inbound Services2OFFICBranch in Cash Journalnvarchar30
20DFKKEXC_CLExternal Payment Information - Clearing Proposals2OFFICBranch in Cash Journalnvarchar30
21DFKKEXC_PAYINFOInformation for Payment Medium2OFFICBranch in Cash Journalnvarchar30
22DFKKEXC_SUMExternal Payment Information: Totals Records2OFFICBranch in Cash Journalnvarchar30
23DFKKEXC_SUM_HISTCash Desk Closing History (DFKKEXC_SUM)2OFFICBranch in Cash Journalnvarchar30
24DFKKEXC_TMPExternal Payment Information: Account Assignment Parameters2OFFICBranch in Cash Journalnvarchar30
25DFKKREPTCLClearing Information for Receipt Documents18OFFICBranch in Cash Journalnvarchar30
26TFK100KDefault Account Assignment for Cash Desk and Cash Journal3OFFICBranch in Cash Journalnvarchar30