SAP Tables - SAP Business One/ERP Table Definition reference

 Module:  Table: 

icon of database logic symbol SAP  TABLESv1Made in Britain - the webs number one JD Edwards Table Definition reference

ERP 6.0: Top 10 requests

1BBP_PD_XML8Table for Persistent Class CL_XML_PPF_BBP
2FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
3/ISDFPS/CHVW_E34External Batch Where-Used List
4FMARCPAR4Parallelization of FMARC_BATCH
5CEKRS5Movement type parameters for automatic ERS
6/1RA/0SD010MI170Items for Class SD01 - Raw Data
7/ATL/AANLCP79Periodic Asset-value fields, like anlc, for all areas
8AUDLORIPR7KPro: Logical Information Object Attribute Values
9BSEG345Accounting Document Segment
10/OPT/Z1344Reporting table: Text table for exception definitions

B1 9.2: Top 10 requests

1OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPCH386A/P Invoice
8JDT1124Journal Entry - Rows
9OPOR386Purchase Order
10OACT114G/L Accounts

B1 8.8: Top 10 requests

2OINV268A/R Invoice
3OVPM154Outgoing Payments
4ORCT154Incoming Payment
5OPCH268A/P Invoice
6OIVL77Whse Journal
7OOCR9Loading Factors
8JDT1110Journal Entry - Rows
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction - the webs number one PHP Function reference tool

66 columns | Print definition?B1 9.2  | LINEID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
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
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
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
60FCT1Sales Forecast - Rows2LineIDRow NumberInt110
61MSN3MRP Pegging Information11LineIDRow NumberInt110
62TRS1Tax Report Saving Object - Approved Documents3LineIDInternal Row NumberInt110
63TRS2Tax Rpt Sav Obj Man Chgd Vals3LineIDInternal Row NumberInt110
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