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

11 columns | Print definition?ERP 6.0  | ALC

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/SAPPSSRM/DEF_BPIBU PS: Enhancement of Business Partner6ALCAgency Location Code - U.S. Federal Governmentnvarchar80
TOPCentral Cash Desk Procedure
2FMFGT_FSNUS Federal Fiscal Station Number2ALCAgency Location Codenvarchar80
3FMFGT_IPCD_BLRTDocument Type for Auto Creation of IPACed Invoices5ALCAgency Location Codenvarchar80
TOPCustomer Master
4KNA1General Data in Customer Master173ALCAgency Location Codenvarchar80
TOPFinancial Accounting
5LFA1Vendor Master (General Section)124ALCAgency Location Codenvarchar80
TOPFunctions for U.S. Federal Government
6FMFGT_ALC_GWAAssign. of Business Act. Type and Reporter Category to ALC2ALCAgency Location Codenvarchar80
TOPFunds Management
7FMFGT_ALCAgency Location Code - U.S. Federal Government2ALCAgency Location Codenvarchar80
8FMFGT_ALCTText Table for Agency Location Codes - U.S. Fed Gov3ALCAgency Location Codenvarchar80
9FMTC_RFCTable for Treasury Regional Financial Center4ALCAgency Location Codenvarchar80
10FMTC_SCHNOTreasury Confirmation Schedule No status6ALCAgency Location Codenvarchar80
11T042F_FMFG_TCPmt Method Supp map to ALC and Pmt Office - US Treas Conf3ALCAgency Location Codenvarchar80