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

125 columns | Print definition?ERP 6.0  | TAB

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/GSINS/BRBPFLSETBrazil: User File settings6TABSeparator for CSV Filesnvarchar10
2/MRSS/C_LN_OBJObjects of a Demand at header level and item level4TABTable Namenvarchar300
3/OPT/COA_UPLCFGTo configure the details of upload file2TABTab typenvarchar50
4FUCN_ITEMCUIBBMaintain Application-Specific Views4TABItem Attribute Tabtinyint30
5GRFNENTTABEntity and Tab Assignment4TABTab IDnvarchar300
6GRFNENTTABCEntity and Tab Assignment4TABTab IDnvarchar300
7GRFNTABTab2TABTab IDnvarchar300
8GRFNTABTTab Text Table3TABTab IDnvarchar300
9GRFNTABUIBBTab and UIBB Assignment2TABTab IDnvarchar300
10T800XFI-SL Set Line Texts (before Release 4.0)3TABnvarchar100
11T804DReport Writer: Texts of Data Field Descriptions2TABnvarchar100
TOPAccount Determination
12TRSETReset Data Before Production Start-up3TABTable Namenvarchar300
TOPActivity Types
13TSC0JTable of Splitting Methods4TABTable Namenvarchar300
TOPAppraisal, Valuation, and Survey Tool
14HRHAP_TAB_DATAAppraisal: Layout Configuration Data15TABTab Configurationnvarchar10
TOPAsset Maintenance
15TAMLAY1Tab pages in master data: Tab titles of layout4TABNumber of tab index in tab for asset master data maint.nvarchar20
16TAMLAY1TTabs in Master Data: Tab Index Titles5TABNumber of tab index in tab for asset master data maint.nvarchar20
17TAMLAY2Tab pages in master data: Assignment of group boxes4TABNumber of tab index in tab for asset master data maint.nvarchar20
TOPAustria
18PC03_SE16N_CD_DATable Display: Change Documents - Data5TABWhere-used list: Tablenvarchar300
19PC03_SE16N_CD_KETable Display: Change Documents - Header3TABWhere-used list: Tablenvarchar300
TOPBasic Functions
20T800AFI-SL tables1TABTable Namenvarchar300
21T800A_KEYFIGFI-SL: Key Figures for Table Group1TABTable Namenvarchar300
22T800BGenerated Archive and Database Reports for FI-SL Tables1TABTable Namenvarchar300
23T800DFields for Master Data Check2TABTotals Tablenvarchar300
24T800GFlexible general ledger installation check1TABTable Namenvarchar300
25T811UTable Information Allocation Sender/Receiver Relationship2TABTable Namenvarchar300
26T881Ledger Master12TABTotals Tablenvarchar300
27T883SFI-SL User Tables3TABTable Namenvarchar300
28T884FTranslation Differences: Additional Account Assignment3TABTable Namenvarchar300
29T884MCurrency translation methods used in Consolidation5TABTable Namenvarchar300
30T884SSets used in currency translation3TABTable for setnvarchar300
31T892URollup Substitution4TABTotals Tablenvarchar300
32TCREPCATT-Test Reporting - Check of logical databases6TABTable Namenvarchar300
TOPBusiness Partner
33TPR1Patner-Object Relationship: Assignment Categories3TABTable Management Indicatornvarchar10
TOPCentral Part of Product Master
34COMM_PRWB_USERTAUser Settings: Locator Tab4TABTab Page in Locatornvarchar20
TOPConsolidation
35TF002SAP Cons.: Assignment of Sets -> Items2TABTable for setnvarchar300
36TF003SAP Cons.: Assignments of Items --> Sets5TABTable for setnvarchar300
37TF090Interactive Excel Attributes3TABTable Namenvarchar300
TOPControlling
38SE16N_CD_DATATable Display: Change Documents - Data5TABWhere-used list: Tablenvarchar300
39SE16N_CD_KEYTable Display: Change Documents - Header3TABWhere-used list: Tablenvarchar300
40SE16N_EXITSE16N: Assigns Exit Events to a Table1TABWhere-used list: Tablenvarchar300
41SE16N_LTSE16N: Initial Screen for Layouts, Basic Data (Table)3TABWhere-used list: Tablenvarchar300
42SE16N_RFSE16N: Assigns Environment Transactions to a Table1TABWhere-used list: Tablenvarchar300
43WUSL10Where-Used List: Dependent Tables2TABWhere-used list: Tablenvarchar300
44WUSL11Where-Used List: Fields to be Output2TABWhere-used list: Tablenvarchar300
45WUSL5BWhere-Used List: Dependent Tables for Primary Selection3TABWhere-used list: Tablenvarchar300
TOPCost Center Accounting
46T811CAllocations: Cycles2TABTable Namenvarchar300
47T811DAllocations: Document Numbers2TABTable Namenvarchar300
48T811DAAllocations: Dependent Document Numbers2TABTable Namenvarchar300
49T811DHAllocations: Header Fields2TABTable Namenvarchar300
50T811DSAllocations: Document Numbers for Segment Reverse/Rebook2TABTable Namenvarchar300
51T811FAllocations: Element Table2TABTable Namenvarchar300
52T811FLAGSAllocations: Global Control Flags2TABTable Namenvarchar300
53T811GField Groups for Allocation Cycle2TABTable Namenvarchar300
54T811HAllocations Data Field Descriptions1TABTable Namenvarchar300
55T811IAllocation Information for key field2TABTable Namenvarchar300
56T811IAAllocations: Customizing2TABTable Namenvarchar300
57T811JAllocations: Information for Field Groups2TABTable Namenvarchar300
58T811KAllocations: Key Fields2TABTable Namenvarchar300
59T811KLAllocations: Determines When CElem/Acty Type Obj. Selected2TABTable Namenvarchar300
60T811LAssessments/Distributions: Long Text3TABTable Namenvarchar300
61T811MAllocations: Text for Field Groups2TABTable Namenvarchar300
62T811MESSAllocations: Message Control2TABTable Namenvarchar300
63T811PCycle Run Group2TABTable Namenvarchar300
64T811PCResults of Checks of Assignments for Cycle Run Groups2TABTable Namenvarchar300
65T811PTCycle Processing Group: Texts3TABTable Namenvarchar300
66T811RAllocation table for receiver assignments2TABTable Namenvarchar300
67T811SAllocations: Segments2TABTable Namenvarchar300
68T811TAllocations: Table Information2TABReport Writer tablenvarchar300
69T811VRSSpecification of Version Change for Cycles2TABTable Namenvarchar300
70T811XAllocations: Fixed Selection Values2TABTable Namenvarchar300
71T811ZAllocations: Data for Runtime Analysis2TABTable Namenvarchar300
TOPEmployee Interaction Center
72THREIC_AT_ENTRYPEIC: Activity Tab: Parameter Values3TABEIC: Tabnvarchar40
73THREIC_AT_PARAMEIC: Parameters3TABEIC: Tabnvarchar40
74THREIC_AT_TABEIC Activity Tab2TABEIC: Tabnvarchar40
75THREIC_AT_TABTEIC: Tab Description2TABEIC: Tabnvarchar40
TOPFrance
76T5F1UCRC-TDS : Links between wage types and fields11TABType of table relevantnvarchar20
TOPFSCM In-House Cash
77IHC_DB_RT_NODEIHC: Routing Node13TABIHC: Table Name of a Condition Fieldnvarchar300
TOPGeneral Ledger Accounting
78FAGL_RMIGR_LOG3Report Migration: Log Detail11TABReport Writer tablenvarchar300
79T000GLFlexible general ledger: Customizing check and activation2TABTable Namenvarchar300
TOPI18N Unicode
80UM4EXCEPSPUMG: Exception table to UMGCCTL3TABnvarchar300
81UMGEXCEPSPUMG: Exception table to UMGCCTL3TABTable Namenvarchar300
TOPInformation System
82T800AISDirectory of InfoSource structures for FI-SL tables1TABTable Namenvarchar300
83T800AIS_PIDirectory of BW Structures for FI-SL Tables1TABTable Namenvarchar300
84T801KReport Writer: Libraries3TABReport Writer tablenvarchar300
85T804AReport Writer: File Description1TABReport Writer tablenvarchar300
86T804BReport Writer: Key figures1TABReport Writer tablenvarchar300
87T804BTReport Writer: Texts for basic key figures2TABReport Writer tablenvarchar300
88T804CReport Writer: Special Fields1TABReport Writer tablenvarchar300
89T804EReport Writer: Summary of Tables3TABTable Namenvarchar300
90T804FReport Writer: Key Figures2TABReport Writer tablenvarchar300
91T804GReport Writer: Texts for Key Figures3TABReport Writer tablenvarchar300
92T804TTexts for reporting table2TABReport Writer tablenvarchar300
TOPLaunchpad
93APB_LPD_FLAGSLaunchpad Global flags2TABData fieldnvarchar400
TOPLocal Currency Changeover
94EUROFISL_TEMU: Information on Table Level for FI-SL3TABTable Namenvarchar300
TOPMaintenance Orders
95/MRSS/C_DEM_SOSubobjects of a Demand Item3TABTable Namenvarchar300
TOPOverhead Cost Controlling
96T823CRevaluation groups2TABTable Namenvarchar300
97T823DRevaluation document numbers2TABTable Namenvarchar300
98T823KRevaluation key fields2TABTable Namenvarchar300
99T823TRevaluation-descriptions3TABTable Namenvarchar300
100T823ZRevaluation percentages (plan)2TABDatabase namenvarchar80
TOPPayment Transactions
101FPRL_ACTION_TABAssign Actions to Tabs2TABTab IDnvarchar100
102FPRL_TABSTab Attributes1TABTab IDnvarchar100
103FPRL_TABSTDefine Tabs2TABTab IDnvarchar100
104FPRL_TAB_ASSIGSet Tab Positions2TABTab IDnvarchar100
TOPPortugal
105T5P1PHR-PT: Table of tax rates1TABTax tablenvarchar30
106T5P1RHR-PT: Tax rates table1TABTax tablenvarchar30
107T5P1SHR-PT: Tax status table10TABTax tablenvarchar30
TOPPrint Workbench
108EFCLXSecondary Tables for Form Class Levels5TABTable name for form output structurenvarchar300
109EFRMXForm Structure: 1:1 Levels7TABTable name for form output structurenvarchar300
TOPRemaining Beverage - Obsolete Objects
110/BEV3/CHCDPTABCDP: CDP Database Tables5TABTable Namenvarchar300
TOPRepetitive Manufacturing
111T435CConfiguration Information for a Table Control2TABTable Namenvarchar300
TOPSAP Business Partner
112TBZS2BDT Search Help: Join Conditions3TABTable Namenvarchar300
113TBZS5BDT Search Help: Tree of Tables Containing Search Fields3TABTable Namenvarchar300
TOPSAP Query
114AQGSBWMAPBI Settings: Field Mapping of a Basis InfoSet2TABTable Namenvarchar300
115IQICATDBInfoSet Query API: InfoSet Catalog5TABTable Namenvarchar300
TOPServices
116UASE16N_CD_DATATable Display: Change Documents - Data5TABTable Display: Tablenvarchar300
117UASE16N_CD_KEYTable Display: Change Documents - Header3TABTable Display: Tablenvarchar300
118UASE16N_LTSE16N: Initial Screen for Layouts, Basic Data (Table)3TABTable Display: Tablenvarchar300
119UASE16N_RFUASE16N: Assigns Environment Transactions to a Table1TABTable Display: Tablenvarchar300
TOPSets
120T800SFI-SL Set Table (before Release 4.0)2TABnvarchar100
121T800YFI-SL Set Texts (before Release 4.0)3TABnvarchar100
122T802GSets: Variables3TABTable for setnvarchar300
TOPSyntax, Compiler, Runtime
123TPDATABTEXTTPDA: Voreistellungen -Texte der Desktops4TABtpda: Aktiver Reiter eines Tabstripnvarchar200
TOPTravel Planning
124TA20LTCurrent Settings for Travel Planning Control Variants3TABNumber of Tabnvarchar20
125TA20LT1Current Settings for Control Variant (Language-Dependent)4TABNumber of Tabnvarchar20