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  | ATEXT

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1T506TLoan Condition Texts5ATEXTLoan Conditions Textnvarchar250
2T5F3APayment reasons for profit sharing3ATEXTLong text for payment reasonnvarchar500
3T5FPBS4TTTextes des types d'ancienneté4ATEXTDésignation sous-typenvarchar400
4T7RUADVTYPETPayment types: Texts4ATEXTPayment Namenvarchar1000
5T7RU_T554TAttendance and Absence Long Texts5ATEXTText (length 132)nvarchar1320
6TAPLTProgram Application Long Texts3ATEXTApplication texts (program attributes)nvarchar300
TOPABAP Authorization and Role Management
7AGR_1250Authorization data for the activity group12ATEXTTexts in user master/authorizationsnvarchar600
8HRT1250Table section authorizations12ATEXTTexts in user master/authorizationsnvarchar600
TOPArgentina
9T7AR03Activity code (CIIU): T7AR01 Texts4ATEXTActivity description (CIIU)nvarchar600
TOPAustria
10T5A1TSocial insurance institutes4ATEXTName of SI Bodynvarchar200
TOPBusiness Package for Manager Self-Service FI
11FPB_AUTHSAuthorizations for FG FPB_Berechtigungen6ATEXTTexts in user master/authorizationsnvarchar600
TOPCollectionsDisbursements
12TKKVIACTDEFTCurr. Chge Acct Bal. Int. Calc. - Def. of Activities (Texts)4ATEXTName of Activitynvarchar600
13TVS030ATIS-IS Scheduling: Activity Definition for Paymt Plan Change4ATEXTName of Activitynvarchar600
14TVS030CTIS-IS Scheduling: Activity Def. Payment Plan Posting Events4ATEXTName of Activitynvarchar600
15TVS030ETIS-IS Scheduling: Activity Def. Payment Plan Change Events4ATEXTName of Activitynvarchar600
TOPCompany Pension Scheme Germany
16T5DCCTexts for Benefit Types5ATEXTEntitlement/Benefit Type Textnvarchar400
TOPContract Accounts Receivable and Payable
17DFKKCOMAKTCorrespondence Dunning Activities7ATEXTName of Activitynvarchar600
18FKKMAKTDunning activities8ATEXTName of Activitynvarchar600
19TFK047LTFI-CA Dunning: Definition of dunning activities (texts)4ATEXTName of Activitynvarchar600
TOPFinancial Accounting
20ACCRBDAccruals/Deferrals Master Data - Basic Data15ATEXTText (30 Characters)nvarchar300
TOPFunds Management
21KBLEDocument Item Processing: Manual Document Entry11ATEXTReduction textnvarchar500
TOPGermany
22T5D3HInvestment Types for Capital Formation4ATEXTAsset type textnvarchar200
23T5DL2Texts for Absence Events5ATEXTName of Absence Eventnvarchar400
TOPGreat Britain
24T5GEF01HR-GB: filing - Store parsed recording coming in from GG36ATEXTAdditional Informationnvarchar2550
TOPIndia
25T77WWW_GAHLP_TIN ESS: Tax Declaration Details Text Table11ATEXTCharacter field length 200nvarchar2000
TOPInternal Collection Procedure
26UHC_T001_TActions - Definition of Actions (Texts)4ATEXTName of Actionnvarchar600
TOPNetherlands
27T5N2RText: Wage Tax [Loonheffing] Exemptions (NL)4ATEXTText for Special EE Group Indicator/No Tablenvarchar600
TOPNorway
28T5VS5Tax codes - text table4ATEXTDescription of <lønns- og trekkoppgave> codesnvarchar600
TOPOrganizational Management
29T77ASAspects4ATEXTAspect Namenvarchar400
30T77OMATTRTGeneral Attribute Maintenance: Text Tables for Attributes4ATEXTGeneral Attribute Maintenance: Attribute textnvarchar400
TOPPatient Accounting
31TN21TIS-H: Texts for Billing Types6ATEXTIS-H: Description of Billing Typenvarchar300
TOPPatient Management
32TNR00IS-H: Report Control: Applications and Texts4ATEXTIS-H: Report control: text on the applicationnvarchar300
TOPPayroll
33T7SI18BVocation Descriptions4ATEXTEduc./train. textnvarchar400
TOPPayroll General Parts
34T52BSTexts for Attributes of HR Objects3ATEXTNamenvarchar400
35T546TEE Subgroup Groupings for Personnel Calculation Rules4ATEXTShort text for EE subgroup grouping for personnel calc.rulesnvarchar30
TOPPension Administration
36T7DEPBSVAVG06TText Table for T7DEPBSVAVG067ATEXTText (30 Characters)nvarchar300
37T7PBSCA2JTText Table for T7PBSCA2J6ATEXTExplanatory short textnvarchar600
TOPPersonnel Administration
38T518BVocation Descriptions4ATEXTEduc./train. textnvarchar400
39T522TForms of Address4ATEXTForm of address textnvarchar50
40T549NPeriod Modifiers4ATEXTPeriod parameter - namenvarchar200
41T549TPayroll areas4ATEXTPayroll Area Textnvarchar200
42T577SFamily Characteristics Texts6ATEXTText (20 Characters)nvarchar200
43T5T53Pension type/insurance5ATEXTTextnvarchar500
44T5T63Druh duchodu/pojištení6ATEXTTextnvarchar500
45T7SK53Druh dôchodku/pojistenia5ATEXTTextnvarchar500
TOPPersonnel Management
46T7HRVTVocation Descriptions - Croatia4ATEXTEduc./train. text - Croatianvarchar1000
TOPPersonnel Time Management
47T554TAbsence and Attendance Texts5ATEXTText for Attendance/Absence Typenvarchar250
48T555MPDC Accounting Types4ATEXTText (20 Characters)nvarchar200
49T705GTexts for Work Time Event Type Groups4ATEXTText (30 Characters)nvarchar300
TOPPublic Sector
50T5D81Control Indicator Pension - Texts5ATEXTText (30 Characters)nvarchar300
51T5QPBS2CTTexts for master leave code5ATEXTText for Attendance/Absence Typenvarchar250
TOPRussia
52T7RU_554TAbsence and Attendance Texts5ATEXTLong Text for Attendance/Absence Typenvarchar2000
TOPShipping
53TAVGTDecsription of Warehouse Activities4ATEXTDescriptionnvarchar200
TOPSpain
54T5EAEBusiness activities3ATEXTBusiness activity textnvarchar1200
TOPSwitzerland
55T5C1BTexts for AHV Keys4ATEXTAHV textnvarchar300
TOPUser and Authorization Management
56USR13Short Texts for Authorizations6ATEXTTexts in user master/authorizationsnvarchar600