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

72 columns | Print definition?ERP 6.0  | FIRMA

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1CF004Stock Prices6FIRMAJoint-stock companynvarchar80
2T5M1PClient/Plant/Plant Section (Denmark)10FIRMAHR_DK: PBS company used in the SAP systemnvarchar20
3YCHDBTAB_TEILNTeilnehmer4FIRMAFirmanvarchar200
TOPDenmark
4T5M5HSAP-PBS Interface: Company (DK)2FIRMAHR_DK: PBS company used in the SAP systemnvarchar20
5T5M5ISAP-PBS Interface: Company (DK)3FIRMAHR_DK: PBS company used in the SAP systemnvarchar20
6T5M5JSAP-PBS Interface: AGRUPPE (DK)2FIRMAHR_DK: PBS company used in the SAP systemnvarchar20
7T5M5KSAP-PBS Interface: AGRUPPE Designations (DK)3FIRMAHR_DK: PBS company used in the SAP systemnvarchar20
8T5M5LSAP-PBS Interface: Leave Schema, OF-CODES (DK)2FIRMAHR_DK: PBS company used in the SAP systemnvarchar20
9T5M5MSAP-PBS Interface: Leave Schema Descriptions OF-CODES (DK)3FIRMAHR_DK: PBS company used in the SAP systemnvarchar20
10T5M71Files2FIRMAHR_DK: PBS company used in the SAP systemnvarchar20
11T5M7BCompany Variant Sets for Payroll Variants2FIRMAHR_DK: PBS company used in the SAP systemnvarchar20
12T5M7DStatus Line for Payroll Run16FIRMAHR_DK: PBS company used in the SAP systemnvarchar20
13T5M7GTax Table Processing2FIRMAHR_DK: PBS company used in the SAP systemnvarchar20
14T5M8GMatchcode W Specifically for Payroll Step (DK)14FIRMAHR_DK: PBS company used in the SAP systemnvarchar20
15T5M8LText table for company variant sets3FIRMAHR_DK: PBS company used in the SAP systemnvarchar20
16T5M8NCompany-specific RFC destinations for PBS links2FIRMAHR_DK: PBS company used in the SAP systemnvarchar20
17T5M8PSAP-PBS interface: Transfer year-end values11FIRMAHR_DK: PBS company used in the SAP systemnvarchar20
18T5M8SEmployer assignment in original period7FIRMAHR_DK: PBS company used in the SAP systemnvarchar20
19T5M8WYear End Corrections for PBS Accumulators (HR-DK)4FIRMAHR_DK: PBS company used in the SAP systemnvarchar20
20T5M8ZEmployer Assignment in Original Period10FIRMAHR_DK: PBS company used in the SAP systemnvarchar20
21T5M9ASAP-PBS Interface: Transfer of New Year Values11FIRMAHR_DK: PBS company used in the SAP systemnvarchar20
22T5M9BSAP-PBS: Year End Values (Revision)12FIRMAHR_DK: PBS company used in the SAP systemnvarchar20
23T5M9CSAP-PBS Interface: New Year Values (Revision)12FIRMAHR_DK: PBS company used in the SAP systemnvarchar20
24T5MFDRetrieval of Official Statistics for DA/DS and FA2FIRMAHR_DK: PBS company used in the SAP systemnvarchar20
25T5MFHSpecial Transfer Days for Wage Types2FIRMAHR_DK: PBS company used in the SAP systemnvarchar20
26T5MFJCorrect FA Absence Statistics2FIRMAHR_DK: PBS company used in the SAP systemnvarchar20
27T5MP1General Messages for the PBS Remuneration Statement2FIRMAHR_DK: PBS company used in the SAP systemnvarchar20
28T5MY0HR-DK: Year-End Activities for PBS2FIRMAHR_DK: PBS company used in the SAP systemnvarchar20
TOPGermany
29P01Y15PAISY: Management Table Subrecord Type 153FIRMAPAISY: Companynvarchar20
TOPItaly
30T5ITPSCompany activity indicator table4FIRMAOwner's or legal representative's signaturenvarchar600
TOPMigration
31TEMACTIS-U migration: Activities for activity groups3FIRMACompany (Client) for Migrationnvarchar50
32TEMBDCIS-U Migration: Recording for BDC Objects1FIRMACompany (Client) for Migrationnvarchar50
33TEMCHECKIS-U migration: check table1FIRMACompany (Client) for Migrationnvarchar50
34TEMCOMPONENTIS-U Mig: Restrict Mig.Objects for Determined Components1FIRMACompany (Client) for Migrationnvarchar50
35TEMCONTROLCIS-U Migration: Control Parameter Customer Settings3FIRMACompany (Client) for Migrationnvarchar50
36TEMDBIS-U Mig.: Structure of Automation Data1FIRMACompany (Client) for Migrationnvarchar50
37TEMDBTIS-U Migration: Structure of Automation Data (Texts)2FIRMACompany (Client) for Migrationnvarchar50
38TEMFIRMAIS-U mig.: company1FIRMACompany (Client) for Migrationnvarchar50
39TEMFIRMATIS-U mig.: company - description2FIRMACompany (Client) for Migrationnvarchar50
40TEMFUIS-U Mig.: Transfer Parameters for Service Mods1FIRMACompany (Client) for Migrationnvarchar50
41TEMGENCODEIS-U migration: coding for report generation1FIRMACompany (Client) for Migrationnvarchar50
42TEMGENFORMIS-U migration: report generation form parameters1FIRMACompany (Client) for Migrationnvarchar50
43TEMGENFUBAIS-U migration: generate report FM parameters1FIRMACompany (Client) for Migrationnvarchar50
44TEMGENMAINIS-U migration: control report generation1FIRMACompany (Client) for Migrationnvarchar50
45TEMJOBIS-U Migration: Definition of Import Job4FIRMACompany (Client) for Migrationnvarchar50
46TEMKSVIS Migration: Key and Status Management2FIRMACompany (Client) for Migrationnvarchar50
47TEMLOCKIS-U Migration: Lock Table2FIRMACompany (Client) for Migrationnvarchar50
48TEMOBIS-U Mig.: Migration Objs1FIRMACompany (Client) for Migrationnvarchar50
49TEMOBSIS-U migration: Blocking status of migration object1FIRMACompany (Client) for Migrationnvarchar50
50TEMOBTIS-U Mig.: Migration Objects (Txts)2FIRMACompany (Client) for Migrationnvarchar50
51TEMRCIS-U Mig: Conversion rule (conversion definitions)1FIRMACompany (Client) for Migrationnvarchar50
52TEMREIS-U Mig.: Conv. Rules (Fields)1FIRMACompany (Client) for Migrationnvarchar50
53TEMRECONIS-U Migration, Customizing Reconciliation9FIRMACompany (Client) for Migrationnvarchar50
54TEMRFIS-U Mig.: Conv. Rules (definition of fixed values)1FIRMACompany (Client) for Migrationnvarchar50
55TEMRTIS-U Mig.: Conversion rules (definition of ABAP statements)1FIRMACompany (Client) for Migrationnvarchar50
56TEMRUIS-U Mig.: Conversion rules (higher-level objects)1FIRMACompany (Client) for Migrationnvarchar50
57TEMRUNMass import: Header data3FIRMACompany (Client) for Migrationnvarchar50
58TEMRUNVARIANTMass import: Number assignment for variant numbers1FIRMACompany (Client) for Migrationnvarchar50
59TEMSCHEDIS-U Migration: Import Runs2FIRMACompany (Client) for Migrationnvarchar50
60TEMSTATISTIKIS-U migration: statistics on performed migrations6FIRMACompany (Client) for Migrationnvarchar50
61TEMUSIS-U Mig.: Managmnt3FIRMACompany (Client) for Migrationnvarchar50
62TEMUS2IS-U Migration: Hidden Objects per User3FIRMACompany (Client) for Migrationnvarchar50
TOPSAP Healthcare - Industry-Specific Components for Hospitals
63TNWATSCDIS-H AT: Systeminformationen für EDI-Scoring8FIRMAIS-H AT: EDV-Firmanvarchar300
TOPSwitzerland
64T5C1MFamily-Related Bonuses11FIRMACompany estimate keynvarchar20
65T5CZUHR-CH: Different Payment of Family-Related Bonuses3FIRMACompany rule for family equalization fundnvarchar20
TOPTravel Expenses
66T702BCredit Card Clearing Assignment Table5FIRMAPaid by Companynvarchar10
67T706BTravel Expense Types20FIRMAPaid by Companynvarchar10
68T706B1Travel Expense Types9FIRMAPaid by Companynvarchar10
TOPTravel Planning
69FTPT_ITEMTravel Service Request Item26FIRMAPaid by Companynvarchar10
70TA20CEnterprise-Specific Travel Service Categories5FIRMAPaid by Companynvarchar10
71TA22AAssignment table expense code - service category4FIRMAPaid by Companynvarchar10
72TA23APayer of Travel Services4FIRMAPaid by Company (Yes/No/Popup)nvarchar10