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
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPCH386A/P Invoice
8OVTG52Tax Definition
9OPOR386Purchase Order
10JDT1124Journal Entry - Rows

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OVPM154Outgoing Payments
5OIVL77Whse Journal
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

44 columns | Print definition?ERP 6.0  | MANUAL

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/SAPPSSRM/INASGNAssignment of Process Types to Procurement Instruments4MANUALManual Processing Onlynvarchar10
2/SAPPSSRM/MQ_DOCIBU PS: "Maximum Quantity per Period" Documents in Periods15MANUALCheckboxnvarchar10
3/SDF/IVISALETRCVIntegration visibility ALE Receiver ports configuration4MANUALEquivalent of ABAP_BOOLnvarchar10
4CIAP_D_RECORDCIAP Record33MANUALCIAP Manual Recordnvarchar10
5CNVCMIS_A_20_WLHHeader data for Cross-Client Customizing Comparison13MANUALManually Alterednvarchar10
6CNV_10400_ATINNIdentified ATINNs per table10MANUALIndicator: Changed manuallynvarchar10
7CNV_10400_TABTables for analysis8MANUALIndicator: Changed manuallynvarchar10
8EAM_REG_PLANRegular Task Planning Schedule17MANUALAssign manuallynvarchar10
9FTBCVA_EECALCMETExpected Exposure Calculation Method Definition2MANUALManual Entry of Expected Exposurenvarchar10
10IUUC_RL_TABLESIUUC ReplicationLogging Tables10MANUALboolean value for manual entry or notnvarchar10
11TIVXCITIRESTATIRE Statuses4MANUALIRE Manual Record Entrynvarchar10
12ZSK_CATTCATTs for Automation15MANUALnvarchar300
TOPAgency Business Global Trade
13TCWBCSAB-CWB: Complaints Status4MANUALAB_CWB: Complaints Status Manually Changeablenvarchar10
TOPClaims Management
14TICL301Participant Role4MANUALManual Addition of Participants Permittednvarchar10
TOPClinical System
15N1FORMULARYMedication: Drug Formulary8MANUALMedication: Manually Added Data Record Indicatornvarchar10
TOPCross-Application Components
16J_2GLPP3Print Task codes Series and numbers4MANUALManual entry documents( on/off )nvarchar10
TOPData Staging
17RSPCABAPASYNCLogging for ABAP Processes(Synchronously and Asynchronously)7MANUALBooleannvarchar10
18RSREQDONEMonitor: Saving of the QM entries24MANUALBooleannvarchar10
TOPEnergy Data Management
19EEDMREPLACEIS-U: EDM Replacement Value Procedure14MANUALReplacement Value Procedure Requires Manual Entrynvarchar10
TOPExpense-Related Billing
20PRSD_DMRP_ACC_CHEngagement Mgmt: Accrual Characteristics for DMR Lines8MANUALCheckboxnvarchar10
TOPFunctions for U.S. Federal Government
21FMROLINEFM Recurring Obligations - schedule lines10MANUALManually input recurring obligation linenvarchar10
TOPGlobal Trade Services
22/SAPSLL/PREVDPreference: Long-Term Vendor Declaration - Header34MANUALManual Preference Statementnvarchar10
TOPInterfaces
23VXSITDLExpress Delivery Company: Meta Description Data Field19MANUALManual entries allowednvarchar10
TOPLoans Management
24TDCUSTFIELDSTField Catalog - Customizing Field Status13MANUALField Status can be Overriddennvarchar10
25TDFIELDCATALOGField Catalog - Field Catalog12MANUALField Status can be Overriddennvarchar10
26TDPROFILEFIELDField Catalog - Field Status for Profiles9MANUALField Status can be Overriddennvarchar10
TOPLocalization
27J_1BALScreen control group assignment3MANUALCreated manuallynvarchar10
28J_1BNFDOCNota Fiscal Header23MANUALCreated manuallynvarchar10
29J_1BNFFTXNota Fiscal header message6MANUALCreated manuallynvarchar10
TOPLogistics Basic Data
30WRF_REF_HEADAssignment of a Reference Module to Material/Plant7MANUALMaintained Manually Indicatornvarchar10
31WRF_REF_MODULEHeader Data for a Reference Module18MANUALMaintained Manually Indicatornvarchar10
TOPMaster Data
32GMIDCRULESIndirect cost rules3MANUALGM IDC Indicator Manual Allowednvarchar10
TOPMaterials Management
33T160EXCriteria Table für External BAnfen5MANUALManual Processingnvarchar10
TOPMedia Product Sales and Distribution
34JKSDCOLLECTISSUERecall Dates for Issues17MANUALRecord Was Changed/Created Manuallynvarchar10
35JKSDISSUEDATERecall Dates for Media Issues23MANUALRecord Was Changed/Created Manuallynvarchar10
TOPMonitoring
36SGLWLSLISTSAP Workload: User-Specific System List for Global Analysis16MANUALSAP workload: Indicator for Various Uses ("X" or space)nvarchar10
TOPOLAP Technology
37RSDDSTATWHMStatistics Data: BW for Warehouse Management9MANUALSingle-Character Indicatornvarchar10
TOPPatient Accounting
38NEHCHealth Insurance Card EHC15MANUALIS-H: Manual Entry of Card Datanvarchar10
TOPReal Estate Localization Czech Republic
39/CEERE/KOEFMPSIMKoeficients for municipalities parts15MANUALThe record was manually altered/creatednvarchar10
40/CEERE/KOEF_K15Koeficient 1,5 from § 11, 3b7MANUALThe record was manually altered/creatednvarchar10
41/CEERE/OBCEMunicipalities14MANUALThe record was manually altered/creatednvarchar10
TOPRevenues and Earnings
42AD01DLIDynamic items (DI)7MANUALCheckboxnvarchar10
TOPWarranty Claim Processing
43CWTYR06Connection Message - Decision - Processing Mode6MANUALWarranty Claim to Manual Processingnvarchar10
44PNWTYHWarranty Claim Header (PVS Node)41MANUALWarranty Claim to Manual Processingnvarchar10