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

106 columns | Print definition?B1 9.3  | 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
8MPO1Value Mapping Data2LineIdLine IdInt110
9RLS1Reference Links Sources Definition2LineIDLine IdInt110
10WLS1Potential Processor of Tasks3LineIDLine IDInt60
11WLS2Input data for tasks3LineIDLine IDInt110
12WLS3Notes of Tasks3LineIDLine IDInt110
13WLS4Task Output Data3LineIDLine IDnVarChar60
14WLS5Task Field Mapping Information3LineIDLine IDnVarChar60
TOPBanking
15ABO1External Bank Operation Code - Rows - Log6LineIdRowInt60
16ABT1Internal Bank Operation Codes - Accounts - Log2LineIdRowInt60
17ACH1Checks for Payment - Rows - History2LineIdRow NumberInt110
18ARC1Incoming Payment - Checks - History2LineIDRow NumberInt110
19ARC3Credit Vouchers History2LineIDRow No.Int110
20ARC4Incoming Payment - Account List - History2LineIdRow NumberInt110
21BOC1External Bank Operation Code - Rows6LineIdRowInt60
22BOE1Bill of Exchange for Payment - Rows2LineIdRow No.Int110
23BTC1Internal Bank Operation Codes - Accounts2LineIdRowInt60
24CHD1Checks for Payment Drafts - Rows2LineIdRow No.Int110
25CHO1Checks for Payment - Rows2LineIdRow NumberInt110
26PDF1Payment Draft - Checks2LineIDRow NumberInt110
27PDF3Payment Draft - Credit Vouchers2LineIDRow No.Int110
28PDF4Payment Draft - Account List2LineIdRow NumberInt110
29PEX1Payment Results Table - Rows2LineIdRow NumberInt110
30RCC4Incoming Payment - Credit Vouchers2LineIdRow NumberInt110
31RCT1Incoming Payment - Checks2LineIDRow NumberInt110
32RCT3Incoming Pmt - Credit Vouchers2LineIDRow No.Int110
33RCT4Incoming Payment - Account List2LineIdRow NumberInt110
34VPM1Outgoing Payments - Check Rows2LineIDRow NumberInt110
35VPM3Outgoing Payments - Credit Vouchers2LineIDRow No.Int110
36VPM4Outgoing Payments - Accounts2LineIdRow NumberInt110
TOPBusiness Partners
37AWD3WTax Codes Details for BP2LineIdRow NumberInt110
38AWD4WTax Codes Details for Item2LineIdRow NumberInt110
39AWD5WTax Codes Details for Freight2LineIdRow NumberInt110
40WTD3WTax Codes Details for BP2LineIdRow NumberInt110
41WTD4WTax Codes Details for Item2LineIdRow NumberInt110
42WTD5WTax Codes Details for Freight2LineIdRow NumberInt110
TOPFinance
43CASE1Internal Recon. Upgrade 2007A2LineIdInconsistent Amt NumberInt1100
44CDC1Cash Discount - Rows2LineIdRow No.Int110
45CFH1Cash Flow Statement Report - History - Rows2LineIdRow NumberInt110
46RCR1Recurring Postings - Rows2LineIdRow NumberInt1100
47SLM1Special Ledger - Analytical Accounting Report Lines: Material2LineIDLine IdentificationInt110
48SLR1Special Ledger - Analytical Accounting Report Lines: Revenues & Expenses2LineIDLine IdentificationInt110
TOPGeneral
49APH1Project Management - Stages - History2LineIDRow No.Int110
50APH2Project Management - Stages - Open Issues - History2LineIDRow No.Int110
51APH3Project Management - Stages - Attachments - History2LineIDRow No.Int110
52APH4Project Management - Stages - Documents - History2LineIDRow No.Int110
53APH5Project Management - Stages - Resources - History2LineIDRow No.Int110
54APH6Project Management - Stages - Activities - History2LineIDRow No.Int110
55APH7Project Management - Workorders - History2LineIDRow No.Int110
56APH8Project Management - Summary - History2LineIDRow No.Int110
57APM1Project Management - Stages - History2LineIDRow No.Int110
58APM2Project Management - Stages - Open Issues - History2LineIDRow No.Int110
59APM3Project Management - Stages - Attachments - History2LineIDRow No.Int110
60APM4Project Management - Stages - Documents - History2LineIDRow No.Int110
61APM5Project Management - Stages - Resources - History2LineIDRow No.Int110
62APM6Project Management - Stages - Activities - History2LineIDRow No.Int110
63APM7Project Management - Workorders - History2LineIDRow No.Int110
64APM8Project Management - Summary - History2LineIDRow No.Int110
65ASH1Project Management Time Sheet - Rows - History2LineIDRow No.Int110
66PHA1Project Management - Stages2LineIDRow No.Int110
67PHA2Project Management - Stages - Open Issues2LineIDRow No.Int110
68PHA3Project Management - Stages - Attachments2LineIDRow No.Int110
69PHA4Project Management - Stages - Documents2LineIDRow No.Int110
70PHA5Project Management - Stages - Resources2LineIDRow No.Int110
71PHA6Project Management - Stages - Activities2LineIDRow No.Int110
72PHA7Project Management - Workorders2LineIDRow No.Int110
73PHA8Project Management - Summary2LineIDRow No.Int110
74PMG1Project Management - Stages2LineIDRow No.Int110
75PMG2Project Management - Stages - Open Issues2LineIDRow No.Int110
76PMG3Project Management - Stages - Attachments2LineIDRow No.Int110
77PMG4Project Management - Stages - Documents2LineIDRow No.Int110
78PMG5Project Management - Stages - Resources2LineIDRow No.Int110
79PMG6Project Management - Stages - Activities2LineIDRow No.Int110
80PMG7Project Management - Workorders2LineIDRow No.Int110
81PMG8Project Management - Summary2LineIDRow No.Int110
82PMG9Project Management - Charged Document Lines Log - Used by Billing Wizard2LineIDRow No.Int110
83TSH1Project Management Time Sheet - Rows2LineIDRow No.Int110
TOPInventory and Production
84ILM3Non-Inventory and Resource Components Log Msg2LineIDLine IDInt110
85IVL2Inventory Components for Production3LineIDLine IDInt110
86SIVL2Inventory Components for Production3LineIDLine IDInt110
87UILM3Non-Inventory and Resource Components Log Msg2LineIDLine IDInt110
88UIVL2Inventory Components for Production3LineIDLine IDInt110
89UWKO1Production Instructions - Rows2LineIDRow NumberInt1100
90WKO1Production Instructions - Rows2LineIDRow NumberInt1100
91WTC1WTax Certificates - WT Groups in Certificates2LineIdRow NumberInt110
92WTC2WTax Certificates - Docs in WT Groups3LineIdLine NumberInt110
TOPMarketing Documents
93GPA1Gross Profit Adjustment - Documents2LineIdRow No.Int110
94GPA4Gross Profit Adjustment - JE Details Accounts2LineIdRow No.Int110
95GPA5Product Cost Adjustment - Recalculation of Product Cost2LineIdRow No.Int110
96GPA6Product Cost Adjustment - Applied Material Revaluations2LineIdRow No.Int110
97GPA8Product Cost Adjustment - MRV Document Lines2LineIdRow No.Int110
98GPA9Applied Gross Profit Adjustments2LineIdRow No.Int110
99TGPAGross Profit Adjustment - Log4LineIDLine IDInt110
TOPMRP
100FCT1Sales Forecast - Rows2LineIDRow NumberInt110
101MSN3MRP Pegging Information11LineIDRow NumberInt110
TOPReports
102TRS1Tax Report Saving Object - Approved Documents3LineIDInternal Row NumberInt110
103TRS2Tax Rpt Sav Obj Man Chgd Vals3LineIDInternal Row NumberInt110
TOPService
104REQ1External System Call Request - Message List2LineIdMessage Line IDInt110
105REQ2External System Call Request - Argument List2LineIdMessage Line IDInt1101
106REQ3External System Call Request - Message Argument List2LineIdMessage Line IDInt110