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

213 columns | Print definition?ERP 6.0  | APPLI

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/CCEE/FISC_CROAFiscalization Croatia: Fiscalized documents7APPLIApplicationnvarchar10
2CF002Human Resources77APPLIApplicationdecimal153
3CFAFOIACT_DETL_2FO Integration: Selection of Details (Risk Category)3APPLIComponent of the Financial Objectnvarchar40
4MEV_D_AD_ROOTPeriod-End Valuation: Accruals Document Root8APPLIApplication MM or SDnvarchar10
5T042IYAccount Determination for Payment Programs6APPLIApplication IDnvarchar10
6T512CLU2APPLInvarchar10
7T512ISystem Documentation - Kwic Index3APPLIApplicationnvarchar10
8T512UHR System Documentation2APPLIApplicationnvarchar10
9T512VRPDSYS00 - Cross References6APPLIApplicationnvarchar10
10T513MRPDSYS00 - Origin of Documentation2APPLIApplicationnvarchar10
11T513NRPDSYS00 - Supplementary Information2APPLIApplicationnvarchar10
12T513QRPDSYS00 - Print Control for Chapters2APPLIApplicationnvarchar10
13T731Key Figures in Info Library (Transport Table)11APPLINumber of applicationnvarchar20
14T77PAYES_RELAPRelevant fields to apply2APPLIApplication of relevant fieldsnvarchar40
15TPGPABAP/4 Authorization Groups1APPLIApplicationnvarchar10
16TPGPTLong Texts for ABAP/4 Program Groups2APPLIApplicationnvarchar10
17TR01Archiving basis table2APPLIApplication areanvarchar20
18TR01TBase Table Reorganization: Texts3APPLIApplication areanvarchar20
19YIT_CUTYPIDA: Customizing for Applications2APPLICATT: Applicationnvarchar20
20YIT_ORTYPIDA: Organizational Units2APPLICATT: Applicationnvarchar20
21YIT_RELNIDA: Release Notes from TNODE01R2APPLICATT: Applicationnvarchar20
22YIT_RELN_TITELIDA: Text Table for High-Performance Help Function2APPLICATT: Applicationnvarchar20
TOPABAP List-Based PI Sheet
23TCOPCApplication-Specific Passwords3APPLICharacter Field Length = 10nvarchar100
TOPAccount Determination
24T180BReporting: Totals Variants6APPLIApplication for reportingnvarchar20
25TRSE1Reset objects to be made productive1APPLIReset objectnvarchar100
26TRSE2Reset objects to be made productive: Texts2APPLIReset objectnvarchar100
27TRSETReset Data Before Production Start-up1APPLIReset objectnvarchar100
TOPArchive Development Kit
28TRK00Reorg objects: Characteristics8APPLIApplication areanvarchar20
TOPAuto-ID Infrastructure
29/AIN/TBC_AIDEFBarcode Customizing: Definition of Application Identifier12APPLIApplication for Application Identifier Typenvarchar20
TOPBasic Functions
30T181GGeneration Specifications2APPLIApplication for reportingnvarchar20
31TPAMASearch Strings for Pattern Matching2APPLIApplication to which the string is assignednvarchar40
32TPAMATText Table for Search String TPAMA3APPLIApplication to which the string is assignednvarchar40
TOPBusiness Partner
33TIVBPCHECKAssignment: "Calling Application" BP for Dataset (see Docu)2APPLIApplicationnvarchar40
34TPZ40Protected Applications3APPLIApplicationnvarchar40
35TPZ41Use of Protected Applications3APPLIApplicationnvarchar40
TOPConfirmations
36TPARUControl parallelized confirmation processes2APPLIApplication of confirmation processnvarchar10
TOPContract Accounts Receivable and Payable
37CFC_APPLCTSCFC: Applications3APPLICFC: Applicationnvarchar40
38CFC_APPLCTS_TXTCFC: Applications: Texts4APPLICFC: Applicationnvarchar40
39CFC_EVENT_FCTCFC events -> Function modules assignment5APPLICFC: Applicationnvarchar40
TOPCost Center Accounting
40COO0SFNCO object planning: interfaces, application function modules1APPLICO: Application abbreviation (C=cost centers, O=orders, ...)nvarchar10
41KPPTCO planning: planning area entity table3APPLICO: Application abbreviation (C=cost centers, O=orders, ...)nvarchar10
TOPCross-Application Components
42YTSS_SCANTSS: Zulässige Applikations-Identifikation9APPLIAnwendung für den Barcode-Typnvarchar20
TOPEnhancements to scheduling agreements MM Outbound
43T163RControl of Parallel Processing in Inbound Logistics2APPLIApplications in Inbound Logisticsnvarchar10
TOPForms
44T59_PROTERPDSYS-SE61 Conversion: Log Table Error3APPLIApplicationnvarchar10
45T59_PROTLRPDSYS-SE61 Conversion: Log Table Reference3APPLIApplicationnvarchar10
46T59_PROTMRPDSYS-SE61 Conversion: Log Table Modules3APPLIApplicationnvarchar10
TOPGermany
47T5D37Applications for Classification3APPLIApplication for Classificationnvarchar40
48T5D38Wage Type Classification2APPLIApplication for Classificationnvarchar40
TOPHR Information Systems
49T72B0_BWHR-PF-BW: Permitted PC Activities for BW Extraction3APPLISubapplication codenvarchar20
50T72B1_BWHR-PF-BW: Permitted Value Type per PC Activities for BW3APPLISubapplication codenvarchar20
51T770QAdditional Fields and Table Fields HR Query5APPLIApplicationnvarchar10
TOPInterface to SAP record feedback
52BCOS_CUSTCreate Messages: Customizing1APPLIApplic./user for customizing message creation in cust. syst.nvarchar120
TOPliveCache Applications
53/SAPAPO/ORDKEYKey and descriptive data for order6APPLIApplication in APOtinyint30
TOPLocalization
54J_1IREJAPPLRejection code for Applications2APPLIApplicationnvarchar20
55J_1IREJAPPL_TRejection code description for Applications2APPLIApplicationnvarchar20
TOPLogistics Information Library
56MCLIKey Figures in Information Library11APPLINumber of applicationnvarchar20
57MCLINInfo Sets in LIL12APPLINumber of applicationnvarchar20
TOPMobile data entry
58T313DDefinition of Application Identification17APPLIApplication for bar code typenvarchar20
TOPOff-Cycle
59T52OCVVariants for Off-Cycle Payroll Runs3APPLITech. application for off-cycle activitiesnvarchar40
TOPPayroll General Parts
60T512JObjects in T512U (Not Language Dependent)1APPLIApplicationnvarchar10
61T513JRPDSYS00 - Default Values8APPLIApplicationnvarchar10
TOPPension fund General Parts
62T5CA2PC Value Types3APPLISubapplication codenvarchar20
63T5CA3HR-CH: Value type descriptions4APPLISubapplication codenvarchar20
64T5CA4Processing Schedules3APPLISubapplication codenvarchar20
65T5CA5Processing Schedule Names4APPLISubapplication codenvarchar20
66T5CA6PC Method Types3APPLISubapplication codenvarchar20
67T5CA7PC Method Type Names4APPLISubapplication codenvarchar20
68T5CA8PC Method Determination3APPLISubapplication codenvarchar20
69T5CA9PC Method Variant Determination3APPLISubapplication codenvarchar20
70T5CAAParameter Areas3APPLISubapplication codenvarchar20
71T5CABParameter Area Name4APPLISubapplication codenvarchar20
72T5CACParameter Range Determination3APPLISubapplication codenvarchar20
73T5CADPC Parameter Values3APPLISubapplication codenvarchar20
74T5CAEPC Operations2APPLISubapplication codenvarchar20
75T5CAFOperation Descriptions3APPLISubapplication codenvarchar20
76T5CAGPC Method Definitions3APPLISubapplication codenvarchar20
77T5CAHSchedule Value Types3APPLISubapplication codenvarchar20
78T5CAIEE Groupings for PC Method Assignment3APPLISubapplication codenvarchar20
79T5CAJName of EE Groupings for PC Method Assignment4APPLISubapplication codenvarchar20
80T5CAKPC: Text Templates for Operation Conditions3APPLISubapplication codenvarchar20
81T5CAKEPC: Text Templates for Operation Conditions2APPLISubapplication codenvarchar20
82T5CALPC: Operation Parameter Descriptions2APPLISubapplication codenvarchar20
83T5CAMOperation Parameter Names3APPLISubapplication codenvarchar20
84T5CAOLine Selection of Processing Schedules3APPLISubapplication codenvarchar20
85T5CATPC Value Type Attributes3APPLISubapplication codenvarchar20
86T5CAUTexts for PC Value Type Attributes4APPLISubapplication codenvarchar20
87T5CAVValue Type Attribute Assignment3APPLISubapplication codenvarchar20
88T5CAWParameter Range Determination Groupings3APPLISubapplication codenvarchar20
89T5CAXParameter Range Determination Grouping Texts4APPLISubapplication codenvarchar20
90T5CAYPC Activities3APPLISubapplication codenvarchar20
91T5CAZTexts for PC Activities4APPLISubapplication codenvarchar20
92T5CB0PC Value Sets3APPLISubapplication codenvarchar20
93T5CB1Texts for PC Value Sets4APPLISubapplication codenvarchar20
94T5CB2PC Data Type Value Sets3APPLISubapplication codenvarchar20
95T5CB3PC Parameter Attributes3APPLISubapplication codenvarchar20
96T5CB4PC Schemas3APPLISubapplication codenvarchar20
97T5CB5Texts for PC Schemas4APPLISubapplication codenvarchar20
98T5CB6PC Forms3APPLISubapplication codenvarchar20
99T5CB7Texts for PC Forms4APPLISubapplication codenvarchar20
100T5CB8PC Evaluation Types3APPLISubapplication codenvarchar20
101T5CB9Texts for PC Evaluation Types4APPLISubapplication codenvarchar20
102T5CBAPC Schema of PC Evaluation Type3APPLISubapplication codenvarchar20
103T5CBBPC Output Sequences of a PC Evaluation Type3APPLISubapplication codenvarchar20
104T5CBCCompatibility of PC Schemas and Output Sequences3APPLISubapplication codenvarchar20
105T5CBDPC Form Attributes3APPLISubapplication codenvarchar20
106T5CBEValue Type Field Assignment3APPLISubapplication codenvarchar20
107T5CBFIndividual Processing of a PC Schema3APPLISubapplication codenvarchar20
108T5CBGOutput Sequences3APPLISubapplication codenvarchar20
109T5CBHTexts for Output Sequences4APPLISubapplication codenvarchar20
110T5CBIGroup Formation Types3APPLISubapplication codenvarchar20
111T5CBJTexts for Group Formation Types4APPLISubapplication codenvarchar20
112T5CBKOutput Assignment Types3APPLISubapplication codenvarchar20
113T5CBLTexts for Output Assignment Types4APPLISubapplication codenvarchar20
114T5CBMOutput Sequence Steps3APPLISubapplication codenvarchar20
115T5CBNMessages for PC Operation Conditions3APPLISubapplication codenvarchar20
116T5CBOAdditional Selection Parameters for Reports3APPLISubapplication codenvarchar20
117T5CBPPC Calculations3APPLISubapplication codenvarchar20
118T5CBQPC Calculation Names4APPLISubapplication codenvarchar20
119T5CBRViews for PC Online Evaluation3APPLISubapplication codenvarchar20
120T5CBSTexts for PC Online Evaluation Views4APPLISubapplication codenvarchar20
121T5CBTControl of PC Calculation3APPLISubapplication codenvarchar20
122T5CBUField Selection for PC Online Evaluation View3APPLISubapplication codenvarchar20
123T5CBWValue Type Attributes for Dialog3APPLISubapplication codenvarchar20
124T5CBXSettings for PC Schema3APPLISubapplication codenvarchar20
125T5CBYProcessing Contexts2APPLISubapplication codenvarchar20
126T5CBZProcessing Context Name3APPLISubapplication codenvarchar20
127T5CC0PC Method Steps Add-Ons3APPLISubapplication codenvarchar20
128T5CC1Characteristics of Output Sequences3APPLISubapplication codenvarchar20
129T5CC2HR-PF: Grouping for Value Types3APPLISubapplication codenvarchar20
130T5CC3HR-PF: Grouping for Value Types (Texts)4APPLISubapplication codenvarchar20
131T5CC4HR-PF: Value Type Grouping3APPLISubapplication codenvarchar20
132T5NP3HR-Gran: Mapping table VALTY - LGART for Simulation3APPLISubapplication codenvarchar20
133T72A2HR-PF: Totals Value Types3APPLISubapplication codenvarchar20
134T72A3HR-PF: Schedule Modifiers3APPLISubapplication codenvarchar20
135T72A3THR-PF: Schedule Modifiers (Texts)4APPLISubapplication codenvarchar20
136T72A4HR-PF: Assignment of Processing Schedule to Schedule Modif.3APPLISubapplication codenvarchar20
137T72A7HR-PF: ESS Control for Universal Evaluations4APPLISubapplication codenvarchar20
138T72A8HR-PF: Control Parameters for ESS Scenarios3APPLISubapplication codenvarchar20
139T72A9HR-PF: Total Compensation Statement Integration3APPLISubapplication codenvarchar20
140T72F0HR-PF: FI Posting Characteristics of Value Types3APPLISubapplication codenvarchar20
141T72F1HR-PF: FI Feature Determination3APPLISubapplication codenvarchar20
142T72F2HR-PF: FI Funds Modifiers3APPLISubapplication codenvarchar20
143T72F2THR-PF: FI Funds Modifier Texts4APPLISubapplication codenvarchar20
144T72F3HR-PF: FI Account Modifiers3APPLISubapplication codenvarchar20
145T72F3THR-PF: FI Account Modifier Texts4APPLISubapplication codenvarchar20
146T72FAHR-PF: FI Index Table30APPLISubapplication codenvarchar20
147T72P0HR-PF: Determination of Payroll Values for PF Value Types3APPLISubapplication codenvarchar20
148T72P1HR-PF: Wage Type Categories for PF2APPLISubapplication codenvarchar20
149T72P1THR-PF: Wage Type Category Texts for PF3APPLISubapplication codenvarchar20
150T72T0HR-PF: TS Processing Reason3APPLISubapplication codenvarchar20
151T72T0THR-PF: TS Processing Reason4APPLISubapplication codenvarchar20
152T72T1HR-PF: TS Person Grouping3APPLISubapplication codenvarchar20
153T72T1THR-PF: TS Person Grouping4APPLISubapplication codenvarchar20
154T72T2HR-PF: TS Data Areas3APPLISubapplication codenvarchar20
155T72T2THR-PF: TS Data Areas4APPLISubapplication codenvarchar20
156T72T3HR-PF: TS Characteristics of Data Areas3APPLISubapplication codenvarchar20
157T72T4HR-PF: TS Master Data3APPLISubapplication codenvarchar20
158T72T4THR-PF: TS Master Data Field Descriptions4APPLISubapplication codenvarchar20
159T72T5HR-PF: TS Account Data3APPLISubapplication codenvarchar20
160T72T6HR-PF: TS Account Data Totals Formation3APPLISubapplication codenvarchar20
161T72T9HR-PF: TS Payroll Data3APPLISubapplication codenvarchar20
162T72TAHR-PF: TS Payroll Data Totals Formation3APPLISubapplication codenvarchar20
163T72TBHR-PF: TS Parameter Values3APPLISubapplication codenvarchar20
164T72TFHR-PF: TS Characteristics of Processing Reason3APPLISubapplication codenvarchar20
TOPPension fund Netherlands
165T5NBCInfotypes voor veldselectie van actuarieel rapportagetool3APPLIDeelapplicatiecodenvarchar20
166T5ND3HR-CH: Pension fund postings3APPLISubapplication codenvarchar20
167T5ND4HR-CH: Pension fund postings4APPLISubapplication codenvarchar20
168T5NDFHR-NL: Output-groeperingen3APPLIDeelapplicatiecodenvarchar20
169T5NDFTHR-NL: Teksten voor gebeurtenissen4APPLIDeelapplicatiecodenvarchar20
170T5NDJHR-NL: Mapping van gebeurtenissen3APPLIDeelapplicatiecodenvarchar20
171T5NDLHR-PF: TS Ereignisse3APPLIDeelapplicatiecodenvarchar20
172T5NE1Groepsdefinitie (VK-rapport)3APPLIDeelapplicatiecodenvarchar20
173T5NE2Omschrijving groepen (VK-rapport)4APPLIDeelapplicatiecodenvarchar20
174T5NE3Standentabel (VK-rapport)3APPLIDeelapplicatiecodenvarchar20
175T5NE4Definitie van VK-rapport3APPLIDeelapplicatiecodenvarchar20
176T5NE5VK-rapport omschrijving4APPLIDeelapplicatiecodenvarchar20
177T5NE6Berekeningsmethode (VK-rapport)3APPLIDeelapplicatiecodenvarchar20
178T5NE7Definitie van variabelen (VK-rapport)3APPLIDeelapplicatiecodenvarchar20
179T5NE8Variabele omschrijving (VK-rapport)4APPLIDeelapplicatiecodenvarchar20
180T5NE9Account (VK rapport)3APPLIDeelapplicatiecodenvarchar20
181T5NEAAccount (VK rapport)3APPLIDeelapplicatiecodenvarchar20
182T5NP0Vastleggen van de relatie tussen werkgever en het fonds3APPLIDeelapplicatiecodenvarchar20
183T5NP1Vastleggen van de relatie tussen werkgever en het product3APPLIDeelapplicatiecodenvarchar20
184T5NP2Vastleggen van relatie tussen wg, fonds en parameter gebied3APPLIDeelapplicatiecodenvarchar20
185T5NU1UPO Infotype fields3APPLIDeelapplicatiecodenvarchar20
TOPPersonnel Administration
186T513IRPDSYS00 - KWIC Index4APPLIApplicationnvarchar10
187T513USecondary System Documentation3APPLIApplicationnvarchar10
188T513VRPDSYS00 - Cross References7APPLIApplicationnvarchar10
TOPPortugal
189T5P1WHR-PT: Relation of wage types in tax calculation11APPLIApplicability for income tax calculationnvarchar10
TOPProject Planning Board
190TBALKScreen sequence control: paths between processing locations1APPLIApplication calling up the project planning boardnvarchar20
191TCBPGantt chart settings29APPLIApplication calling up the project planning boardnvarchar20
TOPRisk Analysis
192CFAFOIACTFO Integration - Activation3APPLIComponent of the Financial Objectnvarchar40
193CFAFOIACT_DETAILFO Integration: Selection of Details3APPLIComponent of the Financial Objectnvarchar40
194CFAFOIACT_DETL_1FO Integration: Selection of Details (Valuation Area)3APPLIComponent of the Financial Objectnvarchar40
TOPSales Plan
195T440PProfiles for Function Module PROGNOSE_DIALOG24APPLIApplication areanvarchar20
TOPSAP Business Partner
196TBZ0ABDT Applications3APPLIApplicationnvarchar40
197TBZ0BBDT Applications: Texts4APPLIApplicationnvarchar40
198TBZ0CAssign BDT Object Part -> BDT Applications4APPLIApplicationnvarchar40
199TBZ1FAssign BDT Events -> Function Modules7APPLIApplicationnvarchar40
200TBZ3EBDT Views10APPLIApplicationnvarchar40
201TBZ3GBDT-Views: Further checks4APPLIApplicationnvarchar40
202TBZ3JBDT: Field Groups Additional FMOD2 Modules6APPLIApplicationnvarchar40
203TBZ4BDT GUI Functions8APPLIApplicationnvarchar40
204TBZ9IBP relationship cat -> calling application allocation4APPLIApplicationnvarchar40
TOPSwitzerland
205T5C1CPension funds10APPLISubapplicationnvarchar40
206T5CA0Employee Attributes3APPLISubapplication codenvarchar20
207T5CA1Texts for EE Attributes4APPLISubapplication codenvarchar20
208T5CAPEE Attribute Classes3APPLISubapplication codenvarchar20
209T5CAQHR-CH: Identification of EE attribute classes4APPLISubapplication codenvarchar20
210T5CARMessage for Employee Attribute Combination3APPLISubapplication codenvarchar20
211T5CASAssignment of EE Attr.classes to IT Entry Fields3APPLISubapplication codenvarchar20
212T5CR0HR-CH: Rules for Determining the Pension Start3APPLISubapplicationnvarchar40
TOPUnited Kingdom
213T5G9AGross to net control report options4APPLISubapplicationnvarchar40