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

91 columns | Print definition?ERP 6.0  | STAT

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/OPT/VIM_DP_SYNCVIM DP Trigger Program Sync Table3STATnvarchar10
2CNVTDMS_05_JESTTJest Shadow table for TDMS4STATAWTYP for CNVTDMS_05_ACCTHDnvarchar50
3FIKZD_REGINV_INIncoming Invoice Registration Journal46STATVendor Statusnvarchar10
4FIKZD_REGINV_OUTOutgoing Invoice Registration Journal45STATVendor Statusnvarchar10
5TTS_AUDIT_FLGAudit Status Records (Work Tickets)3STATObject statusnvarchar50
6TTS_OT_AUDIT_FLGAudit Status Records (Operation Tickets)3STATObject statusnvarchar50
7PIQ_ISR_STATUSObsolete: Selected Statuses for Notification Monitor4STATSystem statusnvarchar50
TOPBasic Data
8TN11DIS-H: Doors Table for Care Unit Overview Graphic2STATIS-H: Care Unit Identification Keynvarchar80
TOPBasic functions
9HUSSTATIndividual Status for Each Handling Unit3STATObject statusnvarchar50
TOPCATT Computer Aided Test Tool
10CATRCATT: Reset table changes4STATCATT: Save Statusnvarchar10
TOPCollaboration Folders
11CFS_STATUS_PROTCFS: Text for Status Log - Enhancement of CRM_JCDS3STATObject Statusnvarchar50
TOPConstruction Equipment Management
12J_3GSTATUSSingle Display-Relevant Status of Object2STATObject statusnvarchar50
TOPContract Accounts Receivable and Payable
13DFKKCCU_SUCLog: Champion/Challenger Updates with Errors8STATStatus of Log of Champion/Challenger Updatenvarchar10
14DFKKWLIWork Items5STATWork Item: Statusnvarchar10
15DFKKWLIAWork Items (Work Item Type)5STATWork Item: Statusnvarchar10
16DFKKWLIAHWork Items (History, Work Item Type)9STATWork Item: Statusnvarchar10
17DFKKWLIHWork Items (History)9STATWork Item: Statusnvarchar10
18FKKBSTMVAcct Statement Transfer: Admin. Records4STATStatus of transfer run of an electronic account statementnvarchar10
19TFK052FSystem Table Work Item: Status1STATWork Item: Statusnvarchar10
20TFK052FTWork Item Status2STATWork Item: Statusnvarchar10
TOPCosts
21TORS1Statuses Relevant for Key-Date Based Management3STATObject statusnvarchar50
TOPData Collection
22TMCLVBWTransaction Key for SAP BW5STATTransaction Key Relevance for SAP BWnvarchar10
TOPDirectory
23LDAPGATEWLDAP Connector3STATStatus of LDAP Connectornvarchar40
TOPeCATT Extended Computer Aided Test Tool
24ECLOG_RESTABeCATT - Table Changes Reset4STATStatusnvarchar10
TOPEnergy Data Management
25EFORMULASTATUSEDM Status for Status Group (DB Table)3STATSystem statusnvarchar50
26EPROFVALCSTATCSTDisplay for User Status of Profile Values2STATUser Statusnvarchar50
27EPROFVALSTATProfile Value Status5STATObject statusnvarchar50
28EPROFVALSTATCUSTDisplay for System Status of Profile Values2STATSystem statusnvarchar50
29EPROFVALSTATHISTHistory of Profile Value Status5STATObject statusnvarchar50
30EPROFVALSTAT_TMPStatus of Temporary Profile Values5STATObject statusnvarchar50
31EPROFVERSSTATStatus of Profile Version of Version5STATObject statusnvarchar50
32TEDM_STAT_CUST_1Priority for Value-Related Status for Longer Interval Lngths2STATSystem statusnvarchar50
33TEDM_STAT_CUST_2Priority for Cond.-Related Status for Longer Interval Lngths2STATSystem statusnvarchar50
34TEDM_STAT_CUST_3Priority for User Status for Longer Interval Lengths2STATUser Statusnvarchar50
TOPEngineering Change Management
35ECM_GROUPGroup Assignment for Change Number8STATStatus for Departmentnvarchar50
TOPFund Accounting
36FMCCAVCRESERVECCAVC aux table for reserved items20STATDocument Statusnvarchar10
TOPGeneral status management
37CRM_JCDSChange Documents for System/User Statuses (Table JEST)3STATObject Statusnvarchar50
38CRM_JESTIndividual Object Status3STATObject Statusnvarchar50
39DJESTIndividual Status per Object: Key Date Based Management4STATObject statusnvarchar50
40JCDSChange Documents for System/User Statuses (Table JEST)3STATObject statusnvarchar50
41JESTIndividual Object Status3STATObject statusnvarchar50
TOPGovernance, Risk and Compliance
42GRFN_ESIG_TAB2master data table for grc pc fda e-sig, v33STATObject Statusnvarchar50
TOPIncentive and Commission Management ICM
43TCACS_REG1Template Tables and Template Structures for Generating8STATIndicator: Statistics Tablenvarchar10
TOPLease Accounting
44FILA_RE_TR_HTranche Header: Selection Result for Refinancing5STATStatus of Tranche Header Data (Refinancing)nvarchar20
TOPLoans Management
45VDMEKOCondition Table: Header17STATStatus of condition tablenvarchar10
TOPLogistical Requirements
46/ISDFPS/PNEPAApplication-Specific Attributes of Equipment Package8STATObject Statusnvarchar50
47/ISDFPS/PNMPAApplication-Specific MPA Attributes9STATObject Statusnvarchar50
TOPLogistics - General
48ECP_PO_STATUSStatus for completion of PO4STATObject statusnvarchar50
TOPMaintenance Processing
49/ISDFPS/MNTF_HDDFPS: Mass Maintenance9STATObject statusnvarchar50
50/ISDFPS/MNTF_POSDFPS: Mass Maintenance7STATObject statusnvarchar50
TOPManagement of Interested Parties
51TIVAR10RE: REsearch - Relationship Status of Rental Request - Offer2STATStatus of Rental Request - Offer Offernvarchar40
52TIVAR10TRE: REsearch - Text Table for TIVAR102STATStatus of Rental Request - Offer Offernvarchar40
53VIAR04RE: REsearch - Rental Request - Offer6STATStatus of Rental Request - Offer Offernvarchar40
TOPMaterial Categories
54/ISDFPS/PAMPOSComponent Alternatives Status5STATObject Statusnvarchar50
55/ISDFPS/PNMPOApplication-Specific MPO Attributes11STATObject Statusnvarchar50
56/ISDFPS/PNMPOCApplication-Specific Attributes of the Material Container8STATObject Statusnvarchar50
57/ISDFPS/PRMPOCAttributes of Relationships Between Matl Container and MPO9STATObject Statusnvarchar50
TOPOverhead Cost Controlling
58COINT_TPOST_HDControlling Integration: Reposting: Header Data11STATStatisticalnvarchar10
TOPPatient Accounting
59TN30SHCO: Statistical Key Figures7STATIS-H: 'Inpatient Area' Indicatornvarchar10
60TN31MHCO: Supported Characteristics9STATIS-H: 'Inpatient Area' Indicatornvarchar10
61TN32MHCO: Assign Classifying IS-H Characteristics to CO10STATIS-H: 'Inpatient Area' Indicatornvarchar10
TOPPatient Management
62TNCASREVIS-H: Case Revision - Customizing Settings4STATIS-H: Key of Status for Basic Medical Documentationnvarchar50
TOPPayroll
63T5HPBS_HAVIBONTComm. - payments monthly breakdown by persons7STATComm - Processing status (Act, Rev, Old)nvarchar10
64T7ROG7EE register - Contract History36STATnvarchar250
TOPPendulum List Indirect Sales
65/BEV4/PLDANFABHSales Request History14STATRequest Statusnvarchar40
66/BEV4/PLDANFABSSales Request - Header13STATRequest Statusnvarchar40
67/BEV4/PLDANFARTSales Request - Items13STATRequest Statusnvarchar40
68/BEV4/PLDSTATStatus - Pendulum List2STATRequest Statusnvarchar40
69/BEV4/PLDSTAT_TStatus - Translation - Pendulum List3STATRequest Statusnvarchar40
70/BEV4/PLDUMKDNConversion Table Customer/Object Numbers31STATRequest Statusnvarchar40
TOPProcess Controls
71GRPC_ESIG_TABmaster data table for grc pc fda e-sig4STATObject Statusnvarchar50
TOPReal Estate Localization Czech Republic
72/CEERE/RIZENIPT settings for company code23STATCountry Keynvarchar30
TOPReal Estate Management
73TIVWB01WB: Status Teilberechnung2STATStatus Teilwirtschaftlichkeitsberechnungnvarchar10
74TIVWB03WB: Status Hauptberechnung2STATStatus Hauptwirtschaftlichkeitsberechnungnvarchar10
75TIVWB0AWB: Texte zu Status Teilberechnung3STATStatus Teilwirtschaftlichkeitsberechnungnvarchar10
76TIVWB0CWB: Texte zu Status Hauptberechnung3STATStatus Hauptwirtschaftlichkeitsberechnungnvarchar10
77VIMI03Occupancy type history for rental unit5STATObject statusnvarchar50
78VIWB00Hauptwirtschaftlichkeitsberechnung5STATStatus Hauptwirtschaftlichkeitsberechnungnvarchar10
TOPReal Estate Slovakia
79TIVXCSKHLAVPRTax Payer Data11STATCountry Keynvarchar30
TOPResourcen Management
80RMXTC_M04TMS-TLS: Monitor Customizing - Task Relationship Rules6STATSystem statusnvarchar50
TOPSAP Ambulatory Care Management
81TNAMB_ACTFATYPIS-H: Activation of Case Category for Case Types4STATIS-H: Activation of Case Category for Inpatient Casesnvarchar10
TOPSAP Business Workflow
82SWZAIENTRYObject Table for Work Queues (Entries)5STATProcessing Status of a Work Itemnvarchar120
TOPSAP Utilities
83EAMI_DEVICE_STATAMI: Device Status3STATAMI Device Statusnvarchar50
TOPSimulation
84VSJEST_CNVersion: Individual status per object4STATObject statusnvarchar50
TOPTranslation Tools
85LXE_GENFLTranslation2STATSingle-Character Indicatornvarchar10
86LXE_NUMBERNumber3STATSingle-Character Indicatornvarchar10
87LXE_OBJLNumber3STATJob Statusnvarchar10
88LXE_WRK_1Number2STATJob Statusnvarchar10
89LXE_WRK_2Analysis4STATSingle-Character Indicatornvarchar10
90LXE_WRK_3Analysis4STATSingle-Character Indicatornvarchar10
91LXE_WRK_4Analysis5STATSingle-Character Indicatornvarchar10