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

60 columns | Print definition?ERP 6.0  | PTEXT

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/SAPSRM/SH_PSTYPText Table for ERP Search Help Process Type5PTEXTText for Item Categorynvarchar200
2CNVTDMS16_PARAMSParameter List For System Analysis4PTEXTData Element for Parameter textnvarchar600
3NWS_EXT_PROJNTData Transport Management Tool Project Texts3PTEXTText, 40 Characters Longnvarchar400
4T510VCheck Table For Processing Types in T510S (WT Generation)4PTEXTProcessing type textnvarchar250
5T569WTexts for Recalculation Categories4PTEXTText for retroactive accounting categorynvarchar200
6T5A5TPrint Position Texts for Sickness Certificates5PTEXTText Fieldnvarchar500
7T5UPBS12TText for Visa subtype4PTEXTText for visa subtypenvarchar400
8T5UPBS13TTax treaty text table4PTEXTText for primary purposenvarchar300
9T800WRW: Texts for Parameter Contents5PTEXTText of parameter entrynvarchar200
10TBP1BBudget / Plan Profile Texts4PTEXTText (30 Characters)nvarchar300
11ZSA_D_PROJNTxSA Project Texts4PTEXTText, 40 Characters Longnvarchar400
TOPABAP Authorization and Role Management
12AGR_PROFProfile name for role5PTEXTTexts in user master/authorizationsnvarchar600
13TPRPROFProfile name for role7PTEXTTexts in user master/authorizationsnvarchar600
14TPRVORTTemplates Profile Generator: Entity Table3PTEXTTexts for templatesnvarchar600
TOPAdd-Ons for Progress Analysis
15AD03PHPTPlan data handling profile text4PTEXTText (30 Characters)nvarchar300
TOPBills of Material
16T418TItem Category Texts4PTEXTItem category textnvarchar300
TOPChina
17T7CN5RPolitical status text4PTEXTPolitical status textnvarchar400
TOPClinical System
18N2BKIS-H*MED: Basic Nursing Catalog6PTEXTText of the Basic Nursing Catalog Entrynvarchar800
TOPCollectionsDisbursements
19TKKVPOGRUTItem Grouping Texts4PTEXTName of Open Item Groupingnvarchar500
20TKKVPOVEROPKTItem Summarization Texts4PTEXTDescription of Summarization for OInvarchar500
21TKKVPOVERTItem Summarization Texts4PTEXTDescription of Summarization for OInvarchar500
22TVS040ATIS-IS Scheduling: Clearing Algorithm for Cust.-Init. Payts4PTEXTName of Open Item Groupingnvarchar500
23TVS040BFETItem Sort Texts6PTEXTName of Open Item Groupingnvarchar500
24TVS040BTCustomer-Initiated Payment: Text Sorting4PTEXTSort Descriptionnvarchar500
TOPContract Accounts Receivable and Payable
25TFK080FTText Table on Lock Processes for Business Locks3PTEXTLanguage-dependent text in Customizingnvarchar400
TOPForms
26T514RPage Type Texts5PTEXTPage Type Descriptionnvarchar250
TOPFunds Management
27KBLPDocument Item: Manual Document Entry9PTEXTItem Textnvarchar500
28TBP1TBudget / Plan Profile Texts6PTEXTText (30 Characters)nvarchar300
29TBPCEPTCover Eligibility Profile Texts5PTEXTText (30 Characters)nvarchar300
30TBPFPTCommitment Type Profile Texts5PTEXTText (30 Characters)nvarchar300
TOPGreat Britain
31T5G3TPension Scheme Names4PTEXTPension scheme namenvarchar300
TOPIndia
32T77WWW_GAHLP_TIN ESS: Tax Declaration Details Text Table10PTEXTCharacter field length 200nvarchar2000
TOPJoint Venture und Production Sharing Accounting
33T8JPTSTPayment Term Schema Description5PTEXTPayment term schemat textnvarchar400
TOPLocal Currency Changeover
34EWUPAKTEMU conversion: Name of the packages4PTEXTPackage descriptionnvarchar400
35EWUPTEMU conversion: Name of the packages per client4PTEXTPackage descriptionnvarchar400
TOPMaterial Maintenance
36T189TConditions: Price List Categories: Texts4PTEXTText (20 Characters)nvarchar200
TOPNorway
37PA3275Pension variant (Norway)25PTEXTCommentnvarchar400
38T5VM1TPension type text4PTEXTTextnvarchar400
39T5VM2TPension variant text4PTEXTTextnvarchar400
TOPOrganizational Management
40T777PPlan Versions4PTEXTPlan Version Textnvarchar250
41T77TTProfiles for RHDESC20 Texts6PTEXTText Field of Length 60nvarchar600
TOPOverhead Cost Orders
42TKB1BText Table for Settlement Keys4PTEXTText (30 Characters)nvarchar300
TOPPayroll
43T7ROA1Bank transfer - interface table24PTEXTText for bank transfernvarchar300
44T7SIA6Bank transfer - interface table27PTEXTText for virmannvarchar300
45T7SIAPTranfer code for APP8PTEXTText for virmannvarchar300
46T7SIBPStandardna klasifikacija dejavnosti6PTEXTTekst (100 znakov)nvarchar1000
47T7SIBTVirman configuration (WT->Accounts)18PTEXTText for virmannvarchar300
TOPPension Administration
48T7PBSCA2DTIndicator Public Services Regulation - Texts5PTEXTHR-PBS: Text Public Services Regulationnvarchar800
TOPPersonnel Administration
49T501TEmployee Group Names4PTEXTName of Employee Groupnvarchar200
50T503TEmployee Subgroup Names4PTEXTName of Employee Subgroupnvarchar200
51T7PL13TTekst ustawien dla HCM Polska4PTEXTTekst (80 znaków)nvarchar800
52T7PL4TInsurance Title Codes texts3PTEXTBasic subject with extensionnvarchar500
TOPPersonnel Time Management
53T510TPremium Texts4PTEXTPremium Namenvarchar200
TOPPurchasing
54T163X"Zombie" T163X5PTEXTText for Item Categorynvarchar200
55T163YTexts for Item Categories4PTEXTText for Item Categorynvarchar200
TOPSales Plan
56T445ZTText for Period Split4PTEXTDescription of specific period splitnvarchar200
TOPTransfer Prices and Decentralized Responsibility
57KFPPDocument Header: Transfer Prices for Tasks9PTEXTItem Textnvarchar500
TOPUser Administration
58USR09Entries for user menus (work areas)4PTEXTSAP application (function)nvarchar360
TOPUser and Authorization Management
59USR11User Master Texts for Profiles (USR10)5PTEXTTexts in user master/authorizationsnvarchar600
60USRSYSPRFTCUA: Profile Text in Distributed Systems5PTEXTTexts in user master/authorizationsnvarchar600