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

47 columns | Print definition?ERP 6.0  | SORT2

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/FLDQ/AD_CHKSTATTable to temporarily hold the check status values46SORT2Search Term 2nvarchar200
2/FLDQ/AD_INI_ERRRecord records which encounter an error in RSADRINI42SORT2Search Term 2nvarchar200
3/FLDQ/AD_INI_IDXCopy of Shadow Table /fldq/ad_mtc_sh42SORT2Search Term 2nvarchar200
4/FLDQ/AD_MTCCODEFirstLogic Match Code Index Table42SORT2Search Term 2nvarchar200
5/FLDQ/AD_MTCRSLTMatch Results table to store results from RSADRINI program43SORT2Search Term 2nvarchar200
6/FLDQ/AD_MTC_SHFirstLogic Shadow table for /FLDQ/AD_MTCCODE42SORT2Search Term 2nvarchar200
7/FLDQ/AD_MTC_SH2FirstLogic Shadow table for /FLDQ/AD_MTCCODE42SORT2Search Term 2nvarchar200
8/FLDQ/AD_PUPDATEMatchcode Records pending to be updated42SORT2Search Term 2nvarchar200
9/FLDQ/HNACLNSOUTDQM for SAP output table for transactional cleanse TASK47SORT2Search Term 2nvarchar200
10/FLDQ/HNACLNSTSKDQM for SAP input table for transactional cleanse TASK47SORT2Search Term 2nvarchar200
11/FLDQ/HNA_BM_INHANA task Batch Match Input Records35SORT2Search Term 2nvarchar200
12/SAPSRM/SH_PLANTTable for ERP Search Help Plants6SORT2Search Term 2nvarchar200
13BBP_PCPOSProcurement Card Statement: Position Data35SORT2Search Term 2nvarchar200
14CNVTDMS_11_SCADRScrambling Addresses25SORT2Search Term 2nvarchar200
15COPC_ACCOUNTCash Account35SORT2Search Term 2nvarchar200
16REQADDRESSDelivery Address for Requirement Coverage Request Lines79SORT2Search Term 2nvarchar200
17TCY09List profiles (standard settings for lists)6SORT2Sort accord. to start datenvarchar10
TOPAddress ManagementBusiness Address
18ADCPPerson/Address Assignment (Business Address Services)17SORT2(Not Supported) Search Termnvarchar200
19ADCPSShadow Table: Assignment Person/Addr. (Bus. Addr. Services)18SORT2(Not Supported) Search Termnvarchar200
20ADRCAddresses (Business Address Services)57SORT2Search Term 2nvarchar200
21ADRCSShadow Table: Addresses (Business Address Services)58SORT2Search Term 2nvarchar200
22ADRCS2Shadow Table 2: Addresses (Business Address Services)59SORT2Search Term 2nvarchar200
23ADRPPersons (Business Address Services)29SORT2Search Term 2nvarchar200
24ADRPSShadow Table: Persons (Business Address Services)30SORT2Search Term 2nvarchar200
25SADRAddress Management: Company Data20SORT2Sort fieldnvarchar200
26SADRPAddress Management: Personal Data24SORT2Sort fieldnvarchar200
TOPAdvertising Management
27TJHCENTACCESSIS-M/AM: Default Settings for Order Accesses18SORT2IS-M/AM: Item Overview Sort Field in Central Accessnvarchar300
TOPBasic Functions
28T850Company data for Consolidation10SORT2Sort key 2nvarchar10
TOPBasis Services Communication Interfaces
29NASTMessage Status78SORT2Sort criteria for message status recordsnvarchar200
TOPBusiness Partner Enhancements for Financial Services
30BP000Business Partner Master (General Data)19SORT2Sort Field 2nvarchar200
TOPEmployee Interaction Center
31THREIC_IBSEARCHEIC Inbox Initial Search Profile12SORT2EIC: Sort Criteria for Inboxnvarchar40
TOPFinancial Accounting
32AC400ADRCP01 Adressen für Programm AC400DEBITOR57SORT2Suchbegriff 2nvarchar200
TOPGlobal Trade Services
33/SAPSLL/PREVDAUDSLL: Preference: Vend.Decl. for Customer Purp.: Audit61SORT2Search Term 2nvarchar200
34/SAPSLL/SPLAUDLegal Control - SPL - Audit94SORT2Search Term 2nvarchar200
TOPLocalization
35J_1BNFCPDNota Fiscal one-time accounts74SORT2Search Term 2nvarchar200
TOPMaster Data
36EFISELField Selection Control for Address Data6SORT2Search term 2nvarchar10
37JGTSADRIS-M: Extended Address Management60SORT2IS-M: Sort Field 2 (for Internal Use)nvarchar200
38MDTBMRP Table8SORT2Sort indicator 02nvarchar20
TOPMigration
39TEMGENFORMIS-U migration: report generation form parameters8SORT2Sort sequencenvarchar60
TOPOperative Structures
40PRPSWBS (Work Breakdown Structure) Element Master Data101SORT2Sort string 2 for production lotnvarchar100
TOPOutput Determination
41T685BCondition Types: Additional Data for Sending Output36SORT2WFMC: Field name in structurenvarchar610
TOPPatient Accounting
42TN19SIS-H: Sort Procedure for Insurance Verification Requests4SORT2IS-H: 2nd Sort Criterion for Sort Procedurenvarchar100
TOPRecycling Administration Core Functions
43J_7LSADRAddress Management: Company Data20SORT2Sort fieldnvarchar200
TOPService Station Retailing
44OIRBDSSORTSort definition table for table control (IS-Oil SSR)5SORT2Sort field 2 for table control (IS-Oil SSR)nvarchar620
TOPSimulation
45VSPRPS_CNVersion: WBS Element (Work Breakdwn Struc. Elem.) Mast. Data102SORT2Sort string 2 for production lotnvarchar100
TOPWaste Management
46EPROP_ADRFLD_SELField Selection Control for Address Screen of Property6SORT2Search term 2nvarchar10
47EROB_ADDRFLD_SELField Selection Control for Add. Screen of Cleaning Object6SORT2Search term 2nvarchar10