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

46 columns | Print definition?ERP 6.0  | BLTYP

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1BBP_PDICFSet for Tabluar Customer and Solution Fields on Itm10BLTYPEarmarked Funds Document Categorynvarchar30
2T77WWW_CLLTCSCHMLTC Schemes Master Table12BLTYPLTC Block Typenvarchar20
TOPBasic Functions
3FDM1Cash Management & Forecast: Line Items of MM Documents2BLTYPReference Document Categorynvarchar10
4FDMVCash Planning Line Items of Earmarked Funds2BLTYPEarmarked Funds Document Categorynvarchar30
5T036MLevel Assignment for Earmarked Funds2BLTYPEarmarked Funds Document Categorynvarchar30
TOPCollectionsDisbursements
6TKKVBLTYPTable for Doc Categories1BLTYPDocument Categorynvarchar20
7TKKVBLTYPTText Table for Doc Cats2BLTYPDocument Categorynvarchar20
8TKKVVKKCControl Table for Invoice Fields1BLTYPDocument Categorynvarchar20
9TVSC_FSTATUSField Status for Fields in Scheduling2BLTYPPayment Plan Item Categorynvarchar20
10VVKKFKODoc Header Posting Data Interface8BLTYPDocument Categorynvarchar20
11VVKKFKOTTable for FS-CD Test Data of Structure vkkkfko6BLTYPDocument Categorynvarchar20
12VVSCITEMBill Scheduling: Scheduling Document7BLTYPPayment Plan Document Categorynvarchar20
13VVSCITEM_MANScheduling Items: Temp. Storage for Manual -> Auto Change7BLTYPPayment Plan Document Categorynvarchar20
14VVSCPOSPayment Plan Item6BLTYPPayment Plan Item Categorynvarchar20
TOPContract Accounts Receivable and Payable
15DFKKKOHeader Data in Open Item Accounting Document23BLTYPDocument Classnvarchar10
16DFKKMKOHeader data for sample contract accounting document23BLTYPDocument Classnvarchar10
TOPData Collection
17S111Index: Subsequent Settlement4BLTYPDocument category for document index updatesnvarchar20
18S111ES111 - Structure Information3BLTYPDocument category for document index updatesnvarchar20
19S136Index: conditions in document4BLTYPDocument category for document index updatesnvarchar20
20S136ES136 - Structural Information5BLTYPDocument category for document index updatesnvarchar20
TOPFunctions for U.S. Federal Government
21TFMFG_MM_AACTDocument Type for Account Assignment Category4BLTYPEarmarked funds document categorynvarchar30
TOPFunds Management
22FMRESINI1Earmarked Funds: Initialization Information6BLTYPEarmarked Funds Document Categorynvarchar30
23FMRESINI2Earmarked Funds: Initialization Data1BLTYPEarmarked Funds Document Categorynvarchar30
24FMRSCVARScenario variants4BLTYPEarmarked funds document categorynvarchar30
25KBLKDocument Header: Manual Document Entry12BLTYPEarmarked Funds Document Categorynvarchar30
26TKBBADocument Types2BLTYPEarmarked funds document categorynvarchar30
27TKBBATTexts for Document Types3BLTYPEarmarked funds document categorynvarchar30
28TKBLAFunds reservation document type2BLTYPEarmarked Funds Document Categorynvarchar30
29TKBLATDocument type text table2BLTYPEarmarked Funds Document Categorynvarchar30
TOPIncentive and Commission Management ICM
30CACSCD_ACSCDAccount Assignment of Stt.Types for FS-CD Settlement System7BLTYPDocument Type for Connection with FS-CDnvarchar20
31CACSCD_DOCCD_PDSettlement to FS-CD: Reference Document Line Items9BLTYPDocument Type for Connection with FS-CDnvarchar20
TOPLocalization
32ESFMD_PD_EFD_LNKLink between RFx and EFD6BLTYPEarmarked Funds Document Categorynvarchar30
TOPOther Functions
33WAPPTAppointments5BLTYPAppointments: Internal document categorynvarchar20
34WAPPTVAppointments: Worklist5BLTYPAppointments: Internal document categorynvarchar20
TOPPurchase Orders
35T6I1Document Index: Allowed Condition Types/Tables2BLTYPDocument category for document index updatesnvarchar20
36T6I2Document Category WIND Direct Entry2BLTYPDocument category for document index updatesnvarchar20
37T6I2AAssignment of Table Fields to Document Category2BLTYPDocument category for document index updatesnvarchar20
38T6I2SStructure of the Variable Fields per Doc. Cat.1BLTYPDocument category for document index updatesnvarchar20
39WINDDocument Index: Conditions for Automatic Document Adjustment2BLTYPDocument category for document index updatesnvarchar20
TOPRecycling Administration Core Functions
40J_7LE09REA Partner Master: Document Types5BLTYPREA Document Categorynvarchar10
41J_7LV1AREA Document: Consecutive Document Types for Main Doc. Type4BLTYPREA Document Categorynvarchar10
42J_7LV1KREA Document: Header Data5BLTYPREA Document Categorynvarchar10
TOPRetail Enterprise Services
43WESD_WINDSAddtional Status for Table WIND3BLTYPDocument category for document index updatesnvarchar20
TOPTransfer Prices and Decentralized Responsibility
44KFPKDocument Header: Transfer Price Agreement/Allocation4BLTYPDocument category: Transfer price agreement/allocationnvarchar30
45TKFPATransfer Price Document Types2BLTYPDocument category: Transfer price agreement/allocationnvarchar30
46TKFPATTexts for Transfer Price Document Types2BLTYPDocument category: Transfer price agreement/allocationnvarchar30