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

56 columns | Print definition?ERP 6.0  | ART

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1CNV_COA_LANGTexts for accounts/cost elements for other languages5ARTGeneral object number type for language tablenvarchar10
2T164ASAPcomm: System Parameters1ARTSingle-Character Indicatornvarchar10
3TC29SDistribution strategy4ARTType of distribution (continuous or discrete)nvarchar20
4TKO01Control parameters for order type2ARTOrder Typenvarchar40
5TQ32Assignment of inspection type to origin4ARTInspection Typenvarchar80
6TSDOCUser Parameters for Documentation3ARTProcessing typenvarchar10
7T7PIQ_GB_TITLEUCAS: Mapping table UCAS Titles -> SAP Title/Form of Addre4ARTType of name affixnvarchar10
TOPBasic Data
8QMATInspection type - material parameters2ARTInspection Typenvarchar80
TOPBasic Data for Certificates
9QCVKCertificate profile header20ARTInspection Typenvarchar80
10QCVVCertificate Profile: List of Preliminary Products11ARTInspection Typenvarchar80
TOPBasic Functions
11T884Currency translation3ARTRounding indicatornvarchar10
TOPClinical System
12N2DGAISTISH*MED : Steuerung Schnittstelle Datenexport7ARTIS-H*MED: Zorunlu alan göstergesinvarchar10
TOPConstruction Equipment Management
13J_3GAUSARTSettlement Calendar2ARTActivity Types for Settlement Calendarnvarchar10
14J_3GAUSATXSettlement Calendar, Acty Type Times, Language-Dependent3ARTActivity Types for Settlement Calendarnvarchar10
15J_3GKALENDSettlement Calendar5ARTActivity Types for Settlement Calendarnvarchar10
TOPData Collection
16S068ES068 - Structural Information5ARTInspection Typenvarchar80
17S069Material Statistics9ARTInspection Typenvarchar80
18S069ES069 - Structural Information4ARTInspection Typenvarchar80
19S072Individual Records for Inspection Lot20ARTInspection Typenvarchar80
20S104Customer Statistics10ARTInspection Typenvarchar80
21S104ES104 - Structural Information5ARTInspection Typenvarchar80
TOPGermany
22T5D4ODEUEV Permissible Name Extensions1ARTType of DEUEV Name Affixnvarchar10
TOPInformation System
23S068Vendor statistics10ARTInspection Typenvarchar80
TOPInvoicing
24DEABPTable: Customer Change Header Data for BB Amounts25ARTCreation type: budget billing plannvarchar10
25EABPBudget Billing Plan25ARTCreation type: budget billing plannvarchar10
TOPMaintenance Task Lists
26MPOSMaintenance item63ARTInspection Typenvarchar80
TOPMaterial Categories
27/ISDFPS/MPO_TEXTStructure of Long Text MPO3ARTType of Long Text Rownvarchar10
TOPMigration
28TEMCHECKIS-U migration: check table3ARTMigration: Table or Report Namenvarchar300
TOPNon-Ferrous Metal enhancements
29/NFM/TRATESRate Table2ARTRate Typenvarchar10
TOPOverhead Cost Orders
30TKO03Order status2ARTOrder Typenvarchar40
31TKO04Order Status Descriptions3ARTOrder Typenvarchar40
TOPPension Administration
32PA0788HR Master Record Infotype 078824ARTType of Bonus-Relevant Periodnvarchar40
33PA0789HR Master Record Infotype 078924ARTType of Bonus (Child-Rear/Suppl.Child-Rear/Care/Care Child)nvarchar40
34PA0845HR Master Record Infotype 0845 (Work Relationships)36ARTOwn Role Regarding Change of Public Sector Employernvarchar10
TOPPeriodical Sales and Distribution
35JYTREORGIS-M/SD: Reorganization Periods and Areas2ARTIS-M: Reorganization typenvarchar20
36JYTSTREORGIS-M/SD: Reorganization Status2ARTIS-M: Reorganization typenvarchar20
37TJ535NUName Affixes2ARTType of name affixnvarchar10
TOPPersonnel Management
38/BKC/S21_COMPBC&T! - Time evaluation results7ARTSingle-Character Indicatornvarchar10
39/BKC/S21_COMPBNPC&T! - Time evaluation results6ARTSingle-Character Indicatornvarchar10
TOPProcess Data Documentation
40MCHPVSBatch Record: Shadow Table for Link to Archive11ARTInspection Typenvarchar80
41REBR4EBR: Inspection Scope of Insp. Lot in Deviation Analysis3ARTInspection Typenvarchar80
TOPQM Control in Procurement
42TQ32AInspection type to status assignment from status profile5ARTInspection Typenvarchar80
TOPQM Control in Sales and Distribution
43TQ32BFind insp.type for quality insp. for delivery note4ARTInspection Typenvarchar80
TOPQuality Inspection
44QALSInspection lot record4ARTInspection Typenvarchar80
45TQ30Inspection types2ARTInspection Typenvarchar80
46TQ30TTexts for inspection types3ARTInspection Typenvarchar80
47TQ34Default values for inspection type2ARTInspection Typenvarchar80
TOPReport Selection for Product Costing
48TKKB1Costing Reports9ARTObject Typenvarchar40
TOPResourcen Management
49RMXTT_TRIAL_QMPLTrial: Assigned Inspection Plans for Post-Process Control16ARTInspection Typenvarchar80
TOPResults Recording
50QIWLTransfer table for QM subsystems18ARTInspection Typenvarchar80
51TQEC30Settings for Copy Inspection Results Function/Operation UD2ARTInspection Typenvarchar80
TOPReuse Services for Country Development
52T535NName affixes2ARTType of name affixnvarchar10
TOPSAP Media
53J_1SWEMF03IS-M/SD CH/W: WEMF Specific Category Processing2ARTIS-M: CH/W: Category Processing Typenvarchar20
TOPSAP Query
54AQGSCATSAP Query: Functional Area Catalog2ARTSAP Query (S): Flagnvarchar10
55AQLSCATSAP Query: Functional Area Catalog3ARTSAP Query (S): Flagnvarchar10
TOPTax
56P01E2_STATUSELStAM Procedure: Status Table3ARTELStAM: Notification Typenvarchar20