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
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

43 columns | Print definition?ERP 6.0  | BTEXT

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/IBS/CRB_BWTXT_TRBD: Different Description for Risk Provision Position Texts4BTEXTRBD: Text - Descriptionnvarchar500
2/SAPF15/XXKBLPSF15 FI DUMMY12BTEXTnvarchar500
3/SAPSRM/SH_MOVTYTable for ERP Search Help Movement Type5BTEXTMovement Type Text (Inventory Management)nvarchar200
4FIEUD_GOODS_HSAFT:XML:Goods Movement Header6BTEXTMovement Type Text (Inventory Management)nvarchar200
5T5B0AText Table SI Categories Employees (B)4BTEXTText (20 Characters)nvarchar200
6T5B0BText Table SI Categories Employers (B)4BTEXTText (20 Characters)nvarchar200
7T5F3APayment reasons for profit sharing4BTEXTPayment reason : short textnvarchar60
TOPActivation Program, Conversion Program, DB Utility, MC, SPDD
8UKRSBCourse Descriptions4BTEXTCourse descriptionnvarchar600
TOPASAP AcceleratedSAP
9SQABRANCHTIndustry sector table table3BTEXTTexts for industriesnvarchar1000
TOPBasic Data
10TNDBTIS-H: Authorization Group Texts for Screen Modifications4BTEXTIS-H: Description Text for User Groupnvarchar500
TOPBills of Material
11T417TMaterials Provided Indicator Texts4BTEXTMaterials provided indicator textsnvarchar300
TOPCompany Pension Scheme Germany
12T5DVBTPEP: Calc. Control Pension Equalization Payment - Texts4BTEXTPEP: Text for Calculation Control Regulationnvarchar400
TOPConstruction Industry
13T5DBQTexts for Construction Keys4BTEXTName of Construction Work Keynvarchar250
TOPDenmark
14T5M3TTexts for Transfer Types (Denmark)3BTEXTText, 40 Characters Longnvarchar400
TOPFunds Management
15KBLPSEarmarked Funds: Value Adjustment Documents12BTEXTValue adjustment docmument: Descriptionnvarchar500
TOPGermany
16T5D0OProcessing Category for Absences3BTEXTText (20 Characters)nvarchar200
TOPInventory Management
17MWZDM07M1ZDM07M128BTEXTMovement Type Text (Inventory Management)nvarchar200
18T064BStock Types and Texts for Physical Inventory3BTEXTText for stock typenvarchar200
19T156HTMain Text for Movement Type4BTEXTMovement Type Text (Inventory Management)nvarchar200
20T156TMovement Type Text8BTEXTMovement Type Text (Inventory Management)nvarchar200
TOPJoint Venture und Production Sharing Accounting
21T8J0DPosting Method Text5BTEXTPosting method Textnvarchar350
22T8J4ACash Call Header table6BTEXTCash Call Descriptionnvarchar350
23T8JATBilling Indicator Name4BTEXTBilling Indicator Namenvarchar350
TOPLogistics - General
24BEWARTMovement type texts for Swiss specifics5BTEXTText for stock typenvarchar200
TOPMaster Data
25T449APeriod split3BTEXTDescription of specific period splitnvarchar200
26T449BPeriod split: language-dependent description4BTEXTDescription of specific period splitnvarchar200
TOPMaterial Master
27MGVBUNDLETShort text for fild packages4BTEXTShort text field packagenvarchar400
TOPNetherlands
28T5N2CMarital Status for Wage Tax [Loonheffing] (NL)4BTEXTMarital Status Textnvarchar110
29T5N3ASocial Fund Decisions (NL)4BTEXTText (20 Characters)nvarchar200
TOPOrganizational Management
30T77MBAction Texts4BTEXTAction Textnvarchar400
TOPPatient Accounting
31NICPIS-H: Surgical Procedure Codes Performed22BTEXTIS-H: User-Defined Comment on Procedurenvarchar500
32NICP2IS-H: INACTIVE since 4.71 - DO NOT USE !22BTEXTIS-H: User-Defined Comment on Procedurenvarchar500
TOPPayroll
33T5H1XTK32 urlap: blokkok szövegei3BTEXTK32 urlap: blokkok szövegeinvarchar400
34T7TRS07Belge Türü Isimleri3BTEXTMetin Alaninvarchar200
TOPPersonnel Administration
35T001PPersonnel Area/Subarea4BTEXTPersonnel Subarea Textnvarchar150
36T523TChallenge Types4BTEXTName of challengenvarchar200
TOPPersonnel Time Management
37T559QTexts for Time Balance Limits7BTEXTCommentnvarchar500
TOPSpare Part Sharing and Stock Providede by Customer
38DICS_T156TMovement Type Text8BTEXTMovement Type Text (Inventory Management)nvarchar200
TOPValue Adjustment
39/IBS/CRB_BTCML_TRBD Selection Excluded Flow Category for CML Flow Type (Text4BTEXTRBD: Text - Descriptionnvarchar500
40/IBS/TRB_UIRBD: RBD Record Data Table (Actual)12BTEXTRBD: Posting Textnvarchar500
41/IBS/TRB_UPRBD RBD Record Data Table (PLANNED)21BTEXTRBD: Posting Textnvarchar500
TOPWarehouse Management
42T338TTexts for Bulk Storage Indicators5BTEXTDescription of bulk storage indicatornvarchar250
TOPWorkbench Tools Editors, Painters, Modelers
43BEISPIELRepository Infosystem: Sample Table for Template Report3BTEXTExplanatory short textnvarchar600