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

104 columns | Print definition?ERP 6.0  | STSMA

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/GEP/T_STATUSGraphical Planning Table: Status Model for Planning Table6STSMAStatus Profilenvarchar80
2/SAPPSSRM/US_GRPUser Status Grouping and Assignment6STSMAStatus Profilenvarchar80
3/SYCLO/CA000SMobile application - mobile status settings8STSMAStatus Profilenvarchar80
4T371AIB: Installed Base Category3STSMAStatus Profilenvarchar80
5TIV81Real estate object type - Status profile allocation3STSMAStatus Profilenvarchar80
6TKKAS_CONVCopy of TKKAS5STSMAStatus Profilenvarchar80
7CMACGRANTGrant Master Data9STSMAGrants Management Systemnvarchar80
8TCMAC05SGrant Status2STSMAGrants Management Systemnvarchar80
9TCMAC05STFinancial Aid Status Text3STSMAGrants Management Systemnvarchar80
TOPAerospace Defence Industry Solution
10ADPMSTATA&D CMC: Definition of Status Groups3STSMAStatus Profilenvarchar80
11ADPMSTATPRFCMC User Status Profile3STSMAStatus Profilenvarchar80
TOPAudit Management
12PLMC_AUDIT_TYPEInvestigation Type (for Audit, FMEA,...)5STSMAStatus Profilenvarchar80
13PLMC_AUD_OBJTYPSSpecific Settings for Audit Components7STSMAStatus Profilenvarchar80
TOPBasic Data
14TNFASIS-H: Department Status for Basic Medical Documentation4STSMAStatus Profilenvarchar80
TOPBasic Data and Tools
15EHSBC_ST01EHS-BAS: Assignment: Status Profile to Object Type4STSMAStatus Profilenvarchar80
TOPBasic Data for Certificates
16QCVKCertificate profile header9STSMAStatus Profilenvarchar80
TOPBasic functions
17HUSTOBJInformation about HU Status Object4STSMAStatus Profile (Handling Units)nvarchar80
TOPBasic Functions
18TVAKSales Document Types59STSMAStatus Profilenvarchar80
19TVAPSales Document: Item Categories35STSMAStatus Profilenvarchar80
TOPBW Interface
20DPR_BW_USERSTATCustomizing: BW Status Mapping / OLTP User Status4STSMAStatus Profilenvarchar80
TOPCapacity and Resource Planning
21/MRSS/C_RM_ACSUCustomizing table for Automatic Candidate Status Update2STSMAStatus Profilenvarchar80
22/MRSS/C_RM_A_CA1RM Abstract Statuses at the Candidate Level4STSMAStatus Profilenvarchar80
23/MRSS/C_RM_PSTA2Partner Statuses2STSMAStatus Profilenvarchar80
24/MRSS/C_RM_PST_TText Table for Partner Statuses2STSMAStatus Profilenvarchar80
25/MRSS/C_RM_STATRM Request/Role Status management2STSMAStatus Profilenvarchar80
TOPClinical System
26N1CMETHSTAIS-H*MED: Methods of Module - Status Change Assignment6STSMAStatus Profilenvarchar80
27N1SCRMIS-H*MED: Status-Dependent Screen Modification4STSMAStatus Profilenvarchar80
TOPConfirmations
28TRUGSUser status caused by deviation4STSMAStatus Profilenvarchar80
TOPControl Plan
29QPCPC_PLANTYPECustomizing Table for Control-Plan Type5STSMAStatus Profilenvarchar80
TOPCost Object
30CKPHSControl for Cost Object Category13STSMAStatus Profilenvarchar80
31TKKASControl Table for Results Analysis5STSMAStatus Profilenvarchar80
TOPCosts
32TORS1Statuses Relevant for Key-Date Based Management2STSMAStatus Profilenvarchar80
TOPCross-Application Components
33CRMBWCVUSSTATCustomizing: Mapping BW Status/ OLTP User Status5STSMAStatus Profilenvarchar80
TOPDistribution Unit Distribution Packet
34TUPS02ALE Distribution Unit: Packet Types3STSMAUPS: Obsolete Fieldnvarchar80
TOPDistributor-Reseller-Management
35/SAPHT/DRMAGRSTagreement State2STSMAStatus Profilenvarchar80
36/SAPHT/DRMCONEXTDRM Ship and debit agreement extracts46STSMAStatus Profilenvarchar80
TOPEnergy Data Management
37TEDM_STAT_CUSTAllocate Profile Values to Status Profile for User Status2STSMAStatus Profilenvarchar80
TOPEngineering Change Management
38ECM_REQData for Engineering Change Request14STSMAStatus Profilenvarchar80
39TCC11Change Types5STSMAStatus Profilenvarchar80
40TCC13ECM: change types (object management record)5STSMAStatus Profilenvarchar80
41TCC15ECM profile7STSMAStatus Profilenvarchar80
TOPEquipment
42T370TEquipment categories12STSMAStatus Profilenvarchar80
TOPFunctional Locations
43T370FFunctional Location Category3STSMAStatus Profilenvarchar80
44T370RReference Functional Location Category3STSMAStatus Profilenvarchar80
TOPFunds Management
45FMAPSTATFIFM: System Status for FIFM Acct Asst Objects9STSMAStatus Profilenvarchar80
46FMSTATUSFIFM: Status for FIFM Account Assignment Objects7STSMAStatus Profilenvarchar80
TOPGeneral Application Functions
47BSVWCOUP4Status for User Events7STSMAStatus Profilenvarchar80
48BSVWCOUP5User Events for Status Object Types3STSMAStatus Profilenvarchar80
49BSVWCOUP6Status for User Events3STSMAStatus Profilenvarchar80
TOPGeneral status management
50CRM_JSTOStatus Object Information4STSMAStatus Profilenvarchar80
51JSTOStatus object information4STSMAStatus Profilenvarchar80
52TJ20Status profiles2STSMAStatus Profilenvarchar80
53TJ20TTexts for Status Profiles2STSMAStatus Profilenvarchar80
54TJ21Permitted object types for status profile2STSMAStatus Profilenvarchar80
55TJ22Languages, in which a status profile is maintained2STSMAStatus Profilenvarchar80
56TJ30User Status2STSMAStatus Profilenvarchar80
57TJ30TTexts for User Status2STSMAStatus Profilenvarchar80
58TJ31Process control (user status)2STSMAStatus Profilenvarchar80
59TJ48Check Table for Selection IDs3STSMAStatus Profilenvarchar80
60TJ49Table for Selection Conditions per SELID4STSMAStatus Profilenvarchar80
TOPHandling Unit Management
61TVTYPackaging Material Types15STSMAStatus Profile for Handling-Unit User Statusnvarchar80
TOPInformation System
62BWCVUSSTATCustomizing: Mapping BW Status / OLTP User Status4STSMAStatus Profilenvarchar80
TOPInvestment Programs
63TAI05CI Program Types10STSMAStatus Profilenvarchar80
TOPKnowledge Base
64T0KBASDB: Customizing Symptom Type12STSMAStatus Profilenvarchar80
65T0KBBSDB: Customizing Solution Type9STSMAStatus Profilenvarchar80
TOPLine Maintenance
66/ISDFPS/CLMSTADCustomizing Table: Maintenance Status "Signed"2STSMAStatus Profilenvarchar80
67/ISDFPS/CLMSTICCustomizing Table for Assigning Icons to the User Status2STSMAStatus Profilenvarchar80
TOPLogbook
68DIACL_LETYP_TLog Entry Type table3STSMAStatus Profilenvarchar80
TOPMaintenance History
69T370NObject link category3STSMAStatus Profilenvarchar80
TOPMaintenance Notifications
70TQ80Notification Types13STSMAStatus Profilenvarchar80
71TQ8TNotification category11STSMAStatus Profilenvarchar80
TOPMaintenance Orders
72/CUM/CMTYPECU: Construction Measure Type3STSMAStatus Profilenvarchar80
73/CUM/CUTYPECU: Compatible Unit Type4STSMAStatus Profilenvarchar80
74/CUM/DESTYPECU: Number Range Customizing for Compatible Unit Design Type6STSMAStatus Profilenvarchar80
TOPMessages
75DNOC_TYPE_NOTIFMessage Types4STSMAStatus Profilenvarchar80
TOPNetwork and Activity
76MLSTMilestone105STSMAStatus Profilenvarchar80
77SMLSStandard milestone75STSMAStatus Profilenvarchar80
TOPOverhead Cost Orders
78T003OOrder Types7STSMAStatus Profilenvarchar80
TOPPatient Management
79N1CORDTSTAIS-H: Order Type-to-Status Profile Assignment2STSMAStatus Profilenvarchar80
80TNFAS_FSIS-H: Dependency of Case Status on Dept-Related Status3STSMAStatus Profilenvarchar80
TOPPlant Maintenance
81EAMS_CVBUSSTSUser Status and Icon Combination of Objects3STSMAStatus Profilenvarchar80
TOPPool Asset Management
82PAMS_STAGraphical Planning Board: Status Model for Planning Board6STSMAStatus Profilenvarchar80
TOPQM Control in Procurement
83QINFQM-info record for material and vendor28STSMAStatus Profile Assigned to Quality Info Recordnvarchar80
84TQ05QM certificate categories for procurement7STSMAStatus Profilenvarchar80
85TQ32AInspection type to status assignment from status profile2STSMAStatus Profile for QINF Processingnvarchar80
TOPQuality Inspection
86QALSInspection lot record8STSMAStatus Profilenvarchar80
87TQ30Inspection types12STSMAStatus Profilenvarchar80
TOPResourcen Management
88RMXTC_M01TMS-TLS: Monitor Customizing - Task Groups3STSMAStatus Profilenvarchar80
89RMXTC_M04TMS-TLS: Monitor Customizing - Task Relationship Rules7STSMAStatus Profilenvarchar80
TOPSales
90TVSTATDisplay/Maintain Status in Sales Overview4STSMAStatus profile for maintaining status in Sales overviewnvarchar80
TOPSample Management
91QPRSMaster record for phys. samples4STSMAStatus Profile for Physical Samplesnvarchar80
92TQ40Definition of sample types4STSMAStatus Profile for Physical Samplesnvarchar80
TOPSAP Business Partner
93BUTBWCVUSSTATCustomizing: Mapping BW Status/OLTP User Status5STSMAStatus Profilenvarchar80
TOPSAP Healthcare - Industry-Specific Components for Hospitals
94TNWAT_SCOPARAMIS-H AT: Scoring - Parameter3STSMAStatusschemanvarchar80
TOPSAP Utilities
95SEAL_INSeal10STSMAStatus Profilenvarchar80
TOPSimulation
96TCN52Valid user status for version profile3STSMAStatus Profilenvarchar80
97VSJSTO_CNVersion: Information on status object5STSMAStatus Profilenvarchar80
98VSMLST_CNVersion: Milestone106STSMAStatus Profilenvarchar80
TOPTransaction Manager
99AT10Transaction Types38STSMAStatus Profilenvarchar80
TOPWarranties
100T790GWarranty Type6STSMAStatus Profilenvarchar80
TOPWork Center
101TC30Work center category7STSMAStatus Profilenvarchar80
TOPWork Clearance Management
102WCCLVWCM: Lineup9STSMAStatus Profilenvarchar80
103WCCMUWCM: Operational Step9STSMAStatus Profilenvarchar80
104WCCOWCM: WCM Object18STSMAStatus Profilenvarchar80