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

49 columns | Print definition?ERP 6.0  | DFLAG

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPConsolidation
1TF9N1Master Data Table: &5DFLAGFlag for connection of documentsnvarchar10
TOPData Collection
2T242BCharacteristic values per characteristic6DFLAGFlag for connection of documentsnvarchar10
3T2700Master data table: Region5DFLAGFlag for connection of documentsnvarchar10
4T2701Master data table: Brand5DFLAGFlag for connection of documentsnvarchar10
5T2702Master data table: Production group5DFLAGFlag for connection of documentsnvarchar10
6T2703Master data table: Manufacturer5DFLAGFlag for connection of documentsnvarchar10
7T2704Master data table: Region5DFLAGFlag for connection of documentsnvarchar10
8T2705Master data table: Area5DFLAGFlag for connection of documentsnvarchar10
9T2706Master data table: Trade channel5DFLAGFlag for connection of documentsnvarchar10
10T2707Master data table: Area5DFLAGFlag for connection of documentsnvarchar10
11T2708Master data table: Country5DFLAGFlag for connection of documentsnvarchar10
12T2709Master data table: Plant5DFLAGFlag for connection of documentsnvarchar10
13T270AMaster data table: Division5DFLAGFlag for connection of documentsnvarchar10
14T270BMaster data table: Product Group5DFLAGFlag for connection of documentsnvarchar10
15T270CMaster data table: Customer Group5DFLAGFlag for connection of documentsnvarchar10
16T270DMaster data table: Distribution Channel5DFLAGFlag for connection of documentsnvarchar10
17T270EMaster data table: Company5DFLAGFlag for connection of documentsnvarchar10
18T270FMaster data table: Month5DFLAGFlag for connection of documentsnvarchar10
19T270GMaster data table: Division5DFLAGFlag for connection of documentsnvarchar10
20T270HMaster data table: Region5DFLAGFlag for connection of documentsnvarchar10
21T270IMaster data table: Product type5DFLAGFlag for connection of documentsnvarchar10
22T270JMaster data table: Source of data5DFLAGFlag for connection of documentsnvarchar10
23T2710Master data table: Area (Countries)5DFLAGFlag for connection of documentsnvarchar10
24T2711Master data table: Continent5DFLAGFlag for connection of documentsnvarchar10
25T2712Master data table: countries5DFLAGFlag for connection of documentsnvarchar10
26T2713Master data table: regions5DFLAGFlag for connection of documentsnvarchar10
27T2714Master data table: product groups5DFLAGFlag for connection of documentsnvarchar10
28T2715Master data table: Continent5DFLAGFlag for connection of documentsnvarchar10
29T2716Master data table: Land5DFLAGFlag for connection of documentsnvarchar10
30T2717Master data table: State5DFLAGFlag for connection of documentsnvarchar10
31T2718Master data table: Prod. Group5DFLAGFlag for connection of documentsnvarchar10
32T2719Master data table: Sales Channel5DFLAGFlag for connection of documentsnvarchar10
33T271AMaster Data Table: Company5DFLAGFlag for connection of documentsnvarchar10
34T271BMaster Data Table: Strategic Business U5DFLAGFlag for connection of documentsnvarchar10
35T271CMaster Data Table: demo5DFLAGFlag for connection of documentsnvarchar10
36T271DMaster Data Table: xxrk15DFLAGFlag for connection of documentsnvarchar10
37T271EStammdatentabelle: T-Segment5DFLAGKennzeichen für Dokumenten-Anschlußnvarchar10
38T271FStammdatentabelle: T-Business Unit6DFLAGKennzeichen für Dokumenten-Anschlußnvarchar10
39T271GStammdatentabelle: T-Division6DFLAGKennzeichen für Dokumenten-Anschlußnvarchar10
40T271HStammdatentabelle: T-Product Line6DFLAGKennzeichen für Dokumenten-Anschlußnvarchar10
41T271IMaster data table: town xx6DFLAGFlag for connection of documentsnvarchar10
42T2720Master data table: xarea (Description)5DFLAGFlag for connection of documentsnvarchar10
43T2721Master data table: CITY (X)6DFLAGFlag for connection of documentsnvarchar10
44T2722Master data table: PRODUCTS (X)8DFLAGFlag for connection of documentsnvarchar10
45T2723Master data table: MAYOR (X)6DFLAGFlag for connection of documentsnvarchar10
46T2737Master Data Table: Customer Group 005DFLAGFlag for connection of documentsnvarchar10
47T2738Master Data Table: Customer 006DFLAGFlag for connection of documentsnvarchar10
48T27NNMaster Data Table: &5DFLAGFlag for connection of documentsnvarchar10
TOPSyntax, Compiler, Runtime
49SABP_ACC_CLASSESINTERNAL * NO ACCESS OUTSIDE PACKAGE * Restricted Classes5DFLAGINTERNAL * NO REUSE OUTSIDE PACKAGE - Soft Deletionnvarchar10