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

46 columns | Print definition?ERP 6.0  | AOTYPE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/CFMFND/AREA_ALMFlächenumlage: Umlageebenen2AOTYPEArchitektonischer Objekttypnvarchar40
2/CFMFND/AREA_AOTFlächenumlage: AO-Typen und Quellbemessungen2AOTYPEArchitektonischer Objekttypnvarchar40
3/CFMFND/MEAS_AOTBemessungsgenerierung: AO-Typen und Quellbemessungen2AOTYPEArchitektonischer Objekttypnvarchar40
4/CFMFND/MEAS_CTMBerechnung der Zielbemessung2AOTYPEArchitektonischer Objekttypnvarchar40
5/CFMFND/MEAS_TFMZuordnung von Funktionen und Bemessungen2AOTYPEArchitektonischer Objekttypnvarchar40
6/CFMFND/RE_ANIDCCustomizing der automatischen Vergabe des Kürzel AOID2AOTYPEArchitektonischer Objekttypnvarchar40
7/CFMFND/RE_AOTYFCustomizing Tabelle für Filter auf Architektonische Objekte3AOTYPEArchitektonischer Objekttypnvarchar40
8/CFMFND/TDAOF_CCustomizing: Architektonische Objekttypen2AOTYPEArchitektonischer Objekttypnvarchar40
9VIXCITCADAOTemporary architectural object data8AOTYPEArchitectural Object Typenvarchar40
TOPApplication System
10/SAPTRX/AOTPARAMApplication system parameter assignment3AOTYPEApplication Object Typenvarchar200
TOPBasic Data
11TIVBDAOIDPARTGeneration Rule for AOID2AOTYPEArchitectural Object Typenvarchar40
12TIVBDARFSTATUSField Status per Architectural Object Type2AOTYPEArchitectural Object Typenvarchar40
13TIVBDARFUNCFunction per Arch. Object Type2AOTYPEArchitectural Object Typenvarchar40
14TIVBDARFUNCTFunction per Architectural Object (Text)3AOTYPEArchitectural Object Typenvarchar40
15TIVBDARNODEAllowed Superordinate Architectural Object Type2AOTYPEArchitectural Object Typenvarchar40
16TIVBDAROBJTYPEArchitectural Object Type2AOTYPEArchitectural Object Typenvarchar40
17TIVBDAROBJTYPETObject Type of Architecture (Text)3AOTYPEArchitectural Object Typenvarchar40
18TIVBDMEASAOMeasurement Type: Settings per Arch. Object Type3AOTYPEArchitectural Object Typenvarchar40
19TIVBDMEASAOFUMeasurement Types: Settings per Arch. Object Type and Funct.3AOTYPEArchitectural Object Typenvarchar40
20TIVBDMEASCALCDerivable Measurement Type6AOTYPEArchitectural Object Typenvarchar40
21TIVBDPMAOPM Integration: Settings for Each Architect. Object Type2AOTYPEArchitectural Object Typenvarchar40
22VIBDAOArchitectural Object4AOTYPEArchitectural Object Typenvarchar40
23VIBDARNUMRANGENumber Range3AOTYPEArchitectural Object Typenvarchar40
TOPDFPS Authorized Infrastructure
24/ISDFPS/CREIPLYAssignment of Architectural Object Type to Planning Level3AOTYPEArchitectural Object Typenvarchar40
TOPEvent Management
25/SAPTRX/AOTREFReference between application objects and event handlers2AOTYPEApplication Object Typenvarchar200
26/SAPTRX/AOTYPESApplication object types3AOTYPEApplication Object Typenvarchar200
27/SAPTRX/AOTYPESTApplication object type descriptions (texts)4AOTYPEApplication Object Typenvarchar200
28/SAPTRX/EXT_AOTAdditional table w Application Object Types for Extraction3AOTYPEApplication Object Typenvarchar200
29/SAPTRX/EXT_EEExtraction of Expected Events3AOTYPEApplication Object Typenvarchar200
30/SAPTRX/EXT_PARParameter and IDs for EM generic extraction3AOTYPEApplication Object Typenvarchar200
31/SAPTRX/SCAOTMAPScenario AOT Mapping Table3AOTYPEApplication Object Typenvarchar200
TOPFlexible Real Estate Management
32TIVXCITAOTYPEAssign object type to architectural object type2AOTYPEArchitectural Object Typenvarchar40
33VIBDARINTNUMOBSOLETE: Current Number Status3AOTYPEArchitectural Object Typenvarchar40
TOPOffer and Rental Request
34TIVORHMATTRAAccommodation Attributes2AOTYPEArchitectural Object Typenvarchar40
35TIVORHMATTRATText Table for Person Attributes3AOTYPEArchitectural Object Typenvarchar40
36TIVORHMATTRPPersonnel Attributes2AOTYPEArchitectural Object Typenvarchar40
37TIVORHMATTRPTText Table for Person Attributes3AOTYPEArchitectural Object Typenvarchar40
38TIVORHMBLOCKLock Reasons2AOTYPEArchitectural Object Typenvarchar40
39TIVORHMBLOCKTText Table for Lock Reasons3AOTYPEArchitectural Object Typenvarchar40
40TIVORHMCAPTIONTitles for WD Popup2AOTYPEArchitectural Object Typenvarchar40
41TIVORHMCAPTIONTTitles for WD Popup3AOTYPEArchitectural Object Typenvarchar40
42TIVORHMCMPATTRComparison Pairs for Attrib. of Person and Accommod.Profiles3AOTYPEArchitectural Object Typenvarchar40
43TIVORHMICONStatus Icon HM2AOTYPEArchitectural Object Typenvarchar40
44TIVORHMICONTStatus Icon Text3AOTYPEArchitectural Object Typenvarchar40
45TIVORPOSDEFSeat Definition: Arch. Object Types3AOTYPEArchitectural Object Typenvarchar40
TOPRoom Reservations and Seating Arrangements
46TIVORRSOBJBODerivation of Reservation Object Type from Business Object2AOTYPEArchitectural Object Typenvarchar40