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

103 columns | Print definition?ERP 6.0  | GRPID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/PERSOS/GROUPTable for storing Group IProfile data(Group and System data)3GRPIDGroup IDnvarchar320
2/PERSOS/GROUPSTable for storing Group Ids2GRPIDGroup IDnvarchar320
3/SSF/ATABService Software Framework:Binary Analysis data for Download3GRPIDnvarchar300
4/XLSO/T77S0System Table2GRPIDGroup Namenvarchar50
5/XLSO/T77STSystem Tables3GRPIDGroup Namenvarchar50
6/XLSO/XLSOURLSpecify URL Address for WEC and Content Player2GRPIDGroup Namenvarchar60
7EHPRCC_OLGRAAssignment of Object List categories to Object List Groups2GRPIDObject List Groupnvarchar100
8EHPRCC_OLGRPObject List Group2GRPIDObject List Groupnvarchar100
9EHPRCC_OLGRPTText Table for Object List Group2GRPIDObject List Groupnvarchar100
10FUDT_VDOCBKPFVerification Document Header31GRPIDBatch Input Session Namenvarchar120
11FUDT_VDOCBKPFHVerification Document Header(History)31GRPIDBatch Input Session Namenvarchar120
12GLPOS_C_CTFI Document: Entry View128GRPIDBatch Input Session Namenvarchar120
13GLPOS_C_DEB_CTGLPOS_C_CT Customer Line Items128GRPIDBatch Input Session Namenvarchar120
14GLPOS_C_GL_CTGLPOS_C_CT G/L Line Items128GRPIDBatch Input Session Namenvarchar120
15GLPOS_C_VEN_CTGLPOS_C_CT Vendor Line Items128GRPIDBatch Input Session Namenvarchar120
16GLPOS_N_CTNew General Ledger: Line Item with Currency Type130GRPIDBatch Input Session Namenvarchar120
17GLPOS_N_GL_CTNew General Ledger: Line Item with Currency Type130GRPIDBatch Input Session Namenvarchar120
18J_1UF_ORD_IN_TAXOrder data used in tax vouchers and corrections26GRPIDBatch Input Session Namenvarchar120
19J_1UF_TAX_POSExtended data of tax document positions40GRPIDBatch Input Session Namenvarchar120
20T2410Language table system control parameters2GRPIDParameter groupnvarchar50
21T2411Description of parameter groups2GRPIDParameter groupnvarchar50
22T2421Parameter groups for system control parameters in SAP-EIS1GRPIDParameter groupnvarchar50
23T242ISender information5GRPIDTransfer methodnvarchar50
24T5T1M_NHealth insurers - data for XML2GRPIDGroup Namenvarchar50
25T5T77S0HRCZ system parameter table3GRPIDGroup Namenvarchar50
26T5T77S1Texty k tab.systému2GRPIDNázev skupinynvarchar50
27T5T77STSystem Tables3GRPIDGroup Namenvarchar50
28T7CNTPM_NODRELTPM: Node and Group Relationship4GRPIDOrganization Group IDnvarchar320
29T7CNTPM_ORGGRPTPM: Organization Group2GRPIDOrganization Group IDnvarchar320
30T7INPEI1P2E: Policy Master Table10GRPIDPolicy Groupnvarchar30
31T7INPEI2P2E: Policy Type to the Policy group Mapping table2GRPIDPolicy Groupnvarchar30
32T7INPEI2TP2E: Policy type text table4GRPIDPolicy Groupnvarchar30
33T7INPEI3P2E: Policy Group Master Table2GRPIDPolicy Groupnvarchar30
34T7INPEI3TP2E: Policy Group Master Text table3GRPIDPolicy Groupnvarchar30
35T7INPEI7P2E : Mapping of policy group with template2GRPIDPolicy Groupnvarchar30
36T7INPEW10P2E: Policy Workflow Log Table for Reminder Mails5GRPIDPolicy Groupnvarchar30
37T7INPEW5P2E: Workflow Levels and Approvers at Policy Level2GRPIDPolicy Groupnvarchar30
38T7INPEW8P2E: Follow On Actions for Policy Level Workflows2GRPIDPolicy Groupnvarchar30
39T7PIQSWITCHGeneral Setting Options for Customers1GRPIDGroup Name (ID)nvarchar100
40T7PIQSWITCHTTexts for General Setting Options2GRPIDGroup Name (ID)nvarchar100
41T7PIQSWITCHVALUESetting Option Values2GRPIDGroup Name (ID)nvarchar100
42T7PIQ_GB_SWITCHUCAS : Switch table to activate ucaslink2GRPIDGroup Name (ID)nvarchar100
TOPAccounting Interface
43GLE_FI_ITEM_MODFECS: Modified FI Line Items (Header/Item/Currency Data)20GRPIDBatch Input Session Namenvarchar120
44GLE_FI_ITEM_ORIGECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F)20GRPIDBatch Input Session Namenvarchar120
TOPBasis Components
45/SSF/DTABService Software Framework:Packed analysis data for Download3GRPIDnvarchar300
46ZDS400_BKPFBelegkopf für Buchhaltung31GRPIDName der Batch-Input-Mappenvarchar120
TOPBasis Services Communication Interfaces
47KCDSMData transfer: Sender structure6GRPIDData transfer: Sourcenvarchar50
TOPBrazil
48T7BRG1Alimony: calculation models6GRPIDGroup identifiernvarchar20
TOPCompany Pension Scheme Germany
49T5DC7CPS Groupings3GRPIDGroupingnvarchar20
50T5DC7TTexts for CPS Groupings4GRPIDGroupingnvarchar20
TOPCross-Application Components
51BKKPFAccounting document header31GRPIDBatch Input Session Namenvarchar120
TOPData Collection
52T242XSAP-EIS: Data Transfer: Origin Parameters3GRPIDData transfer: Sourcenvarchar50
TOPData Transfer
53T241YTexts for transfer parameters3GRPIDData transfer: Sourcenvarchar50
54T2420System control parameters1GRPIDParameter groupnvarchar50
55T242YTransfer parameters2GRPIDData transfer: Sourcenvarchar50
TOPEnvironment, Health and Safety
56/TDAG/RCSA_OLHDRObject List Header11GRPIDObject List Groupnvarchar100
57/TDAG/RCSC_OLGRAAssignment of Object List categories to Object List Groups2GRPIDObject List Groupnvarchar100
58/TDAG/RCSC_OLGRPObject List Group2GRPIDObject List Groupnvarchar100
59/TDAG/RCSC_OLGRTText Table for Object List Group2GRPIDObject List Groupnvarchar100
TOPFinancial Accounting
60BKPFAccounting Document Header31GRPIDBatch Input Session Namenvarchar120
TOPGeneral Application Functions
61BAMGROUPSApplication Analysis: Analysis Groups2GRPIDApplication Analysis: Analysis Groupnvarchar50
62BAMGROUPSTApplication Analysis: Analysis Group Descriptions3GRPIDApplication Analysis: Analysis Groupnvarchar50
63BAMUIApplication Analysis: UI: Main List8GRPIDApplication Analysis: Analysis Groupnvarchar50
64BAMUIDTLApplication Analysis: UI: Detail Lists2GRPIDApplication Analysis: Analysis Groupnvarchar50
65BAMUIDTLCApplication Analysis: UI: Detail Lists: Columns2GRPIDApplication Analysis: Analysis Groupnvarchar50
66BAMUIDTLCTApplication Analysis: UI Detail Lists, Column Headings3GRPIDApplication Analysis: Analysis Groupnvarchar50
TOPGeneral Ledger Accounting
67BKPF_ADDAccounting Document Header31GRPIDBatch Input Session Namenvarchar120
TOPMaster data
68PACKPOPacking Object Item23GRPIDGroup identificationnvarchar80
TOPOrganizational Management
69T77S0System Table2GRPIDGroup Namenvarchar50
70T77SCCustomizing: Grouping Entries in T77S04GRPIDGroup Namenvarchar50
71T77STSystem Tables3GRPIDGroup Namenvarchar50
TOPPatient Management
72TNGRP1IS-H: DRG Grouper Assignment6GRPIDIS-H: DRG Grouper Identificationnvarchar100
73TNGRP2IS-H: DRG Grouper3GRPIDIS-H: DRG Grouper Identificationnvarchar100
TOPPayroll
74T5TPS77S0System Table2GRPIDGroup Namenvarchar50
75T5TPS77S0TSystem Tables3GRPIDGroup Namenvarchar50
TOPPension fund Netherlands
76T5NA4Constante tabel2GRPIDGroepsnaamnvarchar50
TOPPersonnel Administration
77T7SIA2Annual tax - Earnings6GRPIDnvarchar40
TOPProduct Safety
78TCGGRPEHS: Groups2GRPIDGroupnvarchar100
79TCGGRPNAEHS: Language-Dependent Description of Group3GRPIDGroupnvarchar100
80TCGGRPOBJEHS: Relationship of Groups to Specification Category2GRPIDGroupnvarchar100
81TCGGRPTREEEHS: Group tree - group - assignment4GRPIDGroupnvarchar100
82TCGHITEHS: No. of hits13GRPIDGroupnvarchar100
83TCGOUTVAREHS: Output variants13GRPIDGroupnvarchar100
84TCGQUEEHS: Queries13GRPIDGroupnvarchar100
85TCGRULEHS: Easy Expert Set of Rules13GRPIDGroupnvarchar100
86TCGTPLHEHS: Inheritance Template Header13GRPIDGroupnvarchar100
TOPPublic Sector
87PA0490HR-PS-SG: Employee Suggestion Scheme27GRPIDGroup name used in employee suggestion schemenvarchar250
88T5QPBS2LLeave Provision for Australia - Public sector2GRPIDGroup identifier for leave provision (AU-PBS)nvarchar40
89T5RPBS8MInterest Rates3GRPIDEligibility grouping for Interest Ratesnvarchar60
90T5RPBS8NPensions Scheme Eligibility Grouping2GRPIDEligibility grouping for Interest Ratesnvarchar60
91T5RPBS8NTText Table for Pensions Scheme Eligibility Grouping3GRPIDEligibility grouping for Interest Ratesnvarchar60
92T5RPBSG1Salary Conversions for GNP9GRPIDGroup Idnvarchar20
TOPRemaining Beverage - Obsolete Objects
93/BEV3/CH1030BKPFHeader Data for CH Event Ledger 0000103033GRPIDBatch Input Session Namenvarchar120
TOPService Data Download
94/BDL/BDLST14KEYService Definition, Key figure table for ST14 data downloa3GRPIDnvarchar50
95BDLST14KEYKey figure table for ST14 data download2GRPIDnvarchar50
TOPSpecification
96/PLMI/SPC_CPDEFDefault Values for Copying Specifications2GRPIDTemplate Groupnvarchar100
TOPSyntax, Compiler, Runtime
97SLIN_CHCKDescription of SLIN Subchecks4GRPIDCheckman Group Affiliationnvarchar300
TOPTraining Management
98LSO_CUSTOMIZET_CTexts for Customizing Table in Learning Solution2GRPIDGroup Namenvarchar50
99LSO_CUSTOMIZE_CGeneral Customizing Table in Learning Solution2GRPIDGroup Namenvarchar50
100LWMLSO_CUSTTXT_CTexts for Customizing Table in Mobile Learning Solution2GRPIDGroup Namenvarchar50
101LWMLSO_CUST_CCustomizations for Mobile Learning Solution2GRPIDGroup Namenvarchar50
TOPUSA
102T5UA0Interface Default Values Table2GRPIDGroup Namenvarchar50
103T5UA0TInterface Default Values Text Table3GRPIDGroup Namenvarchar50