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

46 columns | Print definition?ERP 6.0  | INACT

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/PICM/C_STATUSPICM: Status Code6INACTData element for domain BOOLE: TRUE (='X') and FALSE (=' ')nvarchar10
2/SAPPSSRM/MCNSTAstatus of mass change/novation objects7INACTIndicator: Mass Change/Novation Object Is Inactivenvarchar10
3/SMERP/STG_PM004Data staging - Equipment list set - Measuring Points22INACTIndicator: Measuring Point Inactivenvarchar10
4/SMERP/STG_PM009Data staging - Func. Loc. List Set - Meas. Pts - cmplex tab22INACTIndicator: Measuring Point Inactivenvarchar10
5CNVTDMS_05_JESTTJest Shadow table for TDMS5INACTTDMS: Active Flagnvarchar10
6PPH_HANA_ACTIVEObjects in Which DB Optimization Is to Be Used4INACTIndicator defining whether table is inactivenvarchar10
7T5UPBSPOOLASick Leave Pool Attributes23INACTReturn Unused Donation Balance to Inactive Donor Employeesnvarchar10
8TIS02Real estate status control: Set status and subsequent status7INACTIndicator: Status Is Inactivenvarchar10
TOPBasic Data
9TN18IS-H: Insurance Provider Types45INACTIS-H: 'Inactive' Indicatornvarchar10
TOPBasic functions
10HUSSTATIndividual Status for Each Handling Unit4INACTIndicator: Status Is Inactivenvarchar10
TOPConfirmations
11AFFWGoods Movements with Errors from Confirmations68INACTIndicator: Planned confirmationnvarchar10
TOPeCATT Extended Computer Aided Test Tool
12ECDBG_USERUser-Specific Debug Data5INACTeCATT Switch On/Offnvarchar10
TOPEnergy Data Management
13EPROFVALSTATProfile Value Status8INACTIndicator: Status Is Inactivenvarchar10
14EPROFVALSTATHISTHistory of Profile Value Status14INACTIndicator: Status Is Inactivenvarchar10
15EPROFVALSTAT_TMPStatus of Temporary Profile Values8INACTIndicator: Status Is Inactivenvarchar10
16EPROFVERSSTATStatus of Profile Version of Version8INACTIndicator: Status Is Inactivenvarchar10
TOPGeneral Application Functions
17BSVWCOUP2Status restrictions5INACTIndicator: Status Is Inactivenvarchar10
18BSVWCOUP4Status for User Events9INACTIndicator: Status Is Inactivenvarchar10
19BSVWCOUP6Status for User Events9INACTIndicator: Status Is Inactivenvarchar10
TOPGeneral status management
20CRM_JCDSChange Documents for System/User Statuses (Table JEST)9INACTIndicator: Status Is Inactivenvarchar10
21CRM_JESTIndividual Object Status4INACTIndicator: Status Is Inactivenvarchar10
22JCDSChange Documents for System/User Statuses (Table JEST)10INACTIndicator: Status Is Inactivenvarchar10
23JESTIndividual Object Status4INACTIndicator: Status Is Inactivenvarchar10
24TJ06System statuses set/deleted by process3INACTIndicator: Status Is Inactivenvarchar10
25TJ49Table for Selection Conditions per SELID9INACTIndicator that maintenance item is inactivenvarchar10
TOPGlobal Trade Services
26/SAPSLL/BOMHDSLL: BOM - Header30INACTIndicator: Status Is Inactivenvarchar10
27/SAPSLL/BOMITSLL: BOM - Item26INACTIndicator: Status Is Inactivenvarchar10
28/SAPSLL/LEGACTSLL: Customs Document: Activities12INACTCommunication Activity Is Active/Inactivenvarchar10
TOPMaintenance Task Lists
29MPOSMaintenance item31INACTIndicator that maintenance item is inactivenvarchar10
TOPMeasuring Points and Counters
30IMPTTMeasuring Point (Table)16INACTIndicator: Measuring Point Inactivenvarchar10
TOPOperative Structures
31PROJProject definition60INACTIndicator: Project definition inactivenvarchar10
TOPPatient Management
32NPATIS-H: Patient Master Data (General)109INACT'Inactive' Indicatornvarchar10
33TN14HIS-H: Referral Types8INACTIS-H: 'Inactive' Indicatornvarchar10
34TN15CIS-H: Case Category13INACTIS-H: 'Inactive' Indicatornvarchar10
TOPProfitability Analysis
35CESETSSet Administration in the Report Painter20INACTDisplay indicator for sets in the Report Painternvarchar10
36TKES1Row/column structures17INACTRPT: Report Painter object is inactivenvarchar10
TOPReal Estate Management
37VIMI03Occupancy type history for rental unit6INACTIndicator: Status Is Inactivenvarchar10
TOPSAP Healthcare - Industry-Specific Components for Hospitals
38TNCH13IS-H CH: Convention5INACTIS-H: 'Inactive' Indicatornvarchar10
TOPSimulation
39VSAFVC_CNVersion: Operation in order184INACTVersion inactive indicatornvarchar10
40VSAUFK_CNVersion: Order master data106INACTVersion inactive indicatornvarchar10
41VSJEST_CNVersion: Individual status per object5INACTIndicator: Status Is Inactivenvarchar10
42VSPROJ_CNVersion: Project definition61INACTIndicator: Project definition inactivenvarchar10
TOPSpain
43PA0799AFI message data37INACTInactivity typenvarchar10
44T5E30Adjust Social Insurance reasons and actions9INACTRED system: inactivitynvarchar10
TOPTemplates
45PROJSStandard project definition60INACTIndicator: Project definition inactivenvarchar10
TOPTreasury
46FLQGRP_QRLiquidity Calculation - Queries for Sequence6INACTLiquidity Calculation: Query Ignorednvarchar10