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

66 columns | Print definition?B1 9.2  | LINEID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPAdministration
1ALR1Queue of messages to be sent2LineIdRow NumberInt110
2AWL1Potential Processor of Tasks3LineIDLine IDInt60
3AWL2Input data for tasks3LineIDLine IDInt110
4AWL3Task Notes3LineIDLine IDInt110
5AWL4Task Output Data3LineIDLine IDnVarChar60
6AWL5Task Field Mapping Information3LineIDLine IDnVarChar60
7MDC1Master Data Cleanup - Log2LineIDLine IDInt110
8WLS1Potential Processor of Tasks3LineIDLine IDInt60
9WLS2Input data for tasks3LineIDLine IDInt110
10WLS3Notes of Tasks3LineIDLine IDInt110
11WLS4Task Output Data3LineIDLine IDnVarChar60
12WLS5Task Field Mapping Information3LineIDLine IDnVarChar60
TOPBanking
13ABO1External Bank Operation Code - Rows - Log6LineIdRowInt60
14ABT1Internal Bank Operation Codes - Accounts - Log2LineIdRowInt60
15ACH1Checks for Payment - Rows - History2LineIdRow NumberInt110
16ARC1Incoming Payment - Checks - History2LineIDRow NumberInt110
17ARC3Credit Vouchers History2LineIDRow No.Int110
18ARC4Incoming Payment - Account List - History2LineIdRow NumberInt110
19BOC1External Bank Operation Code - Rows6LineIdRowInt60
20BOE1Bill of Exchange for Payment - Rows2LineIdRow No.Int110
21BTC1Internal Bank Operation Codes - Accounts2LineIdRowInt60
22CHD1Checks for Payment Drafts - Rows2LineIdRow No.Int110
23CHO1Checks for Payment - Rows2LineIdRow NumberInt110
24PDF1Payment Draft - Checks2LineIDRow NumberInt110
25PDF3Payment Draft - Credit Vouchers2LineIDRow No.Int110
26PDF4Payment Draft - Account List2LineIdRow NumberInt110
27PEX1Payment Results Table - Rows2LineIdRow NumberInt110
28RCC4Incoming Payment - Credit Vouchers2LineIdRow NumberInt110
29RCT1Incoming Payment - Checks2LineIDRow NumberInt110
30RCT3Incoming Pmt - Credit Vouchers2LineIDRow No.Int110
31RCT4Incoming Payment - Account List2LineIdRow NumberInt110
32VPM1Outgoing Payments - Check Rows2LineIDRow NumberInt110
33VPM3Outgoing Payments - Credit Vouchers2LineIDRow No.Int110
34VPM4Outgoing Payments - Accounts2LineIdRow NumberInt110
TOPBusiness Partners
35AWD3WTax Codes Details for BP2LineIdRow NumberInt110
36AWD4WTax Codes Details for Item2LineIdRow NumberInt110
37AWD5WTax Codes Details for Freight2LineIdRow NumberInt110
38WTD3WTax Codes Details for BP2LineIdRow NumberInt110
39WTD4WTax Codes Details for Item2LineIdRow NumberInt110
40WTD5WTax Codes Details for Freight2LineIdRow NumberInt110
TOPFinance
41CASE1Internal Recon. Upgrade 2007A2LineIdInconsistent Amt NumberInt1100
42CDC1Cash Discount - Rows2LineIdRow No.Int110
43CFH1Cash Flow Statement Report - History - Rows2LineIdRow NumberInt110
44RCR1Recurring Postings - Rows2LineIdRow NumberInt1100
45SLM1Special Ledger - Analytical Accounting Report Lines: Material2LineIDLine IdentificationInt110
46SLR1Special Ledger - Analytical Accounting Report Lines: Revenues & Expenses2LineIDLine IdentificationInt110
TOPInventory and Production
47ILM3Non-Inventory and Resource Components Log Msg2LineIDLine IDInt110
48UILM3Non-Inventory and Resource Components Log Msg2LineIDLine IDInt110
49UWKO1Production Instructions - Rows2LineIDRow NumberInt1100
50WKO1Production Instructions - Rows2LineIDRow NumberInt1100
51WTC1WTax Certificates - WT Groups in Certificates2LineIdRow NumberInt110
52WTC2WTax Certificates - Docs in WT Groups3LineIdLine NumberInt110
TOPMarketing Documents
53GPA1Gross Profit Adjustment - Documents2LineIdRow No.Int110
54GPA4Gross Profit Adjustment - JE Details Accounts2LineIdRow No.Int110
55GPA5Product Cost Adjustment - Recalculation of Product Cost2LineIdRow No.Int110
56GPA6Product Cost Adjustment - Applied Material Revaluations2LineIdRow No.Int110
57GPA8Product Cost Adjustment - MRV Document Lines2LineIdRow No.Int110
58GPA9Applied Gross Profit Adjustments2LineIdRow No.Int110
59TGPAGross Profit Adjustment - Log4LineIDLine IDInt110
TOPMRP
60FCT1Sales Forecast - Rows2LineIDRow NumberInt110
61MSN3MRP Pegging Information11LineIDRow NumberInt110
TOPReports
62TRS1Tax Report Saving Object - Approved Documents3LineIDInternal Row NumberInt110
63TRS2Tax Rpt Sav Obj Man Chgd Vals3LineIDInternal Row NumberInt110
TOPService
64REQ1External System Call Request - Message List2LineIdMessage Line IDInt110
65REQ2External System Call Request - Argument List2LineIdMessage Line IDInt1101
66REQ3External System Call Request - Message Argument List2LineIdMessage Line IDInt110