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

48 columns | Print definition?ERP 6.0  | SORT1

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/FLDQ/AD_CHKSTATTable to temporarily hold the check status values45SORT1Search Term 1nvarchar200
2/FLDQ/AD_INI_ERRRecord records which encounter an error in RSADRINI41SORT1Search Term 1nvarchar200
3/FLDQ/AD_INI_IDXCopy of Shadow Table /fldq/ad_mtc_sh41SORT1Search Term 1nvarchar200
4/FLDQ/AD_MTCCODEFirstLogic Match Code Index Table41SORT1Search Term 1nvarchar200
5/FLDQ/AD_MTCRSLTMatch Results table to store results from RSADRINI program42SORT1Search Term 1nvarchar200
6/FLDQ/AD_MTC_SHFirstLogic Shadow table for /FLDQ/AD_MTCCODE41SORT1Search Term 1nvarchar200
7/FLDQ/AD_MTC_SH2FirstLogic Shadow table for /FLDQ/AD_MTCCODE41SORT1Search Term 1nvarchar200
8/FLDQ/AD_PUPDATEMatchcode Records pending to be updated41SORT1Search Term 1nvarchar200
9/FLDQ/HNACLNSOUTDQM for SAP output table for transactional cleanse TASK46SORT1Search Term 1nvarchar200
10/FLDQ/HNACLNSTSKDQM for SAP input table for transactional cleanse TASK46SORT1Search Term 1nvarchar200
11/FLDQ/HNA_BM_INHANA task Batch Match Input Records34SORT1Search Term 1nvarchar200
12/SAPSRM/SH_PLANTTable for ERP Search Help Plants5SORT1Search Term 1nvarchar200
13BBP_PCPOSProcurement Card Statement: Position Data34SORT1Search Term 1nvarchar200
14CNVTDMS_11_SCADRScrambling Addresses24SORT1Search Term 1nvarchar200
15COPC_ACCOUNTCash Account34SORT1Search Term 1nvarchar200
16REQADDRESSDelivery Address for Requirement Coverage Request Lines78SORT1Search Term 1nvarchar200
17TCY09List profiles (standard settings for lists)5SORT1Sort accord. to sort criterion "order number"nvarchar10
TOPAddress ManagementBusiness Address
18ADCPPerson/Address Assignment (Business Address Services)16SORT1(Not Supported) Search Termnvarchar200
19ADCPSShadow Table: Assignment Person/Addr. (Bus. Addr. Services)17SORT1(Not Supported) Search Termnvarchar200
20ADRCAddresses (Business Address Services)56SORT1Search Term 1nvarchar200
21ADRCSShadow Table: Addresses (Business Address Services)57SORT1Search Term 1nvarchar200
22ADRCS2Shadow Table 2: Addresses (Business Address Services)58SORT1Search Term 1nvarchar200
23ADRPPersons (Business Address Services)28SORT1Search Term 1nvarchar200
24ADRPSShadow Table: Persons (Business Address Services)29SORT1Search Term 1nvarchar200
25SADRPAddress Management: Personal Data23SORT1Sort fieldnvarchar100
TOPAdvertising Management
26TJHCENTACCESSIS-M/AM: Default Settings for Order Accesses17SORT1IS-M/AM: Item Overview Sort Field in Central Accessnvarchar300
TOPAerospace Defence Industry Solution
27ADPMPRIOHDCustomizing : Priority for rotable orders (Header)11SORT1Sort indicator 01nvarchar10
28ADPMSTATHDCMC User Status Profile3SORT1Sort indicator 01nvarchar10
TOPAvailability Check
29LATP_ENQPersistent Lock Records for ATP in R/3 from External Systems21SORT1Sort indicator 01nvarchar10
TOPBasic Functions
30T850Company data for Consolidation9SORT1Sort key 1nvarchar10
TOPBasis Services Communication Interfaces
31NASTMessage Status77SORT1Sort criteria for message status recordsnvarchar200
TOPBusiness Partner Enhancements for Financial Services
32BP000Business Partner Master (General Data)18SORT1Sort Field 1nvarchar200
TOPEmployee Interaction Center
33THREIC_IBSEARCHEIC Inbox Initial Search Profile11SORT1EIC: Sort Criteria for Inboxnvarchar40
TOPExternal Services
34TMP_SPECModel Service Specifications9SORT1Search termnvarchar200
TOPFinancial Accounting
35AC400ADRCP01 Adressen für Programm AC400DEBITOR56SORT1Suchbegriff 1nvarchar200
TOPGlobal Trade Services
36/SAPSLL/PREVDAUDSLL: Preference: Vend.Decl. for Customer Purp.: Audit60SORT1Search Term 1nvarchar200
37/SAPSLL/SPLAUDLegal Control - SPL - Audit93SORT1Search Term 1nvarchar200
TOPLocalization
38J_1BNFCPDNota Fiscal one-time accounts73SORT1Search Term 1nvarchar200
TOPMaster Data
39EFISELField Selection Control for Address Data4SORT1Search term 1nvarchar10
40MDTBMRP Table7SORT1Sort indicator 01nvarchar10
TOPMigration
41TEMGENMAINIS-U migration: control report generation4SORT1Sort sequencenvarchar60
TOPOperative Structures
42PRPSWBS (Work Breakdown Structure) Element Master Data100SORT1Sort string 1 for production lotnvarchar100
TOPOutput Determination
43T685BCondition Types: Additional Data for Sending Output35SORT1WFMC: Field name in structurenvarchar610
TOPPatient Accounting
44TN19SIS-H: Sort Procedure for Insurance Verification Requests3SORT1IS-H: 1st Sort Criterion for Sort Procedurenvarchar100
TOPService Station Retailing
45OIRBDSSORTSort definition table for table control (IS-Oil SSR)3SORT1Sort field 1 for table control (IS-Oil SSR)nvarchar620
TOPSimulation
46VSPRPS_CNVersion: WBS Element (Work Breakdwn Struc. Elem.) Mast. Data101SORT1Sort string 1 for production lotnvarchar100
TOPWaste Management
47EPROP_ADRFLD_SELField Selection Control for Address Screen of Property4SORT1Search term 1nvarchar10
48EROB_ADDRFLD_SELField Selection Control for Add. Screen of Cleaning Object4SORT1Search term 1nvarchar10