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

83 columns | Print definition?ERP 6.0  | TEXT30

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1DVKTXR/2-R/3 Link: Delivery texts R2 -> R337TEXT30Text R/2-R/3 Linknvarchar720
2T159QInventory Management Print Function: Value Table for KZDRU3TEXT30Text (30 Characters)nvarchar300
3T159TInvntry Mgmt. Printing: Text Table for Table T159Q4TEXT30Text (30 Characters)nvarchar300
TOPBasic Functions
4T007DTexts for Tax Groups5TEXT30Text (30 Characters)nvarchar300
5T059WReasons for exemption per withholding tax type5TEXT30Text (30 Characters)nvarchar300
6WITH_CTNCLTNumbering class text table for withholding tax certificate4TEXT30Text (30 Characters)nvarchar300
7WITH_CTNGRTNumbering group text table for withholding tax certificate4TEXT30Text (30 Characters)nvarchar300
TOPBilling
8J_1ADOCCL2Texts for official document class in Argentina4TEXT30Text (30 Characters)nvarchar300
TOPBudgeting
9FMBTGROUPTText for Budget Type Group6TEXT30Budget Type group descriptionnvarchar300
10FMBUDTYPETTexts for Budget Types8TEXT30Budget type long text (30)nvarchar300
11FMCUPRPTTexts for Field Profiles for Provisionally Posted Bdgt Docs4TEXT30Text (30 Characters)nvarchar300
12FMFSGTText for Field Status Group4TEXT30Field Status Group descriptionnvarchar300
13FMFSSTText for Field Status definition4TEXT30Field Status String descriptionnvarchar300
14FMFSVTText for Field Status Variant definition4TEXT30Field Status Variant descriptionnvarchar300
TOPBusiness Partner
15TP019TBusiness Partner: Key for Blank Fields5TEXT30Text (30 Characters)nvarchar300
16TPZ18TBusiness Partner: Key for Blank Fields4TEXT30Text (30 Characters)nvarchar300
TOPCollectionsDisbursements
17TKKVITVORTText Table Internal Subtransactions FS-CD4TEXT30Text (30 Characters)nvarchar300
TOPContract Accounts Receivable and Payable
18TFK010TText Table for Set of Rules for Sales/Purchase Tax Recording4TEXT30Text (30 Characters)nvarchar300
19TFK_NUMGR_IT_TTexts for numbering group for official documents Italy5TEXT30Text (30 Characters)nvarchar300
20TFK_ODNGRP_TText for Grouping for Official Document Numbers4TEXT30Description of Grouping for Official Document Numbersnvarchar300
TOPContract Billing
21EDSCTDisct Header Data (Txts)4TEXT30Text (30 Characters)nvarchar300
22EOPGROUPTOperand Group (Text)4TEXT30Text (30 Characters)nvarchar300
23EPREITMstr Pricing Table for All Prices (Texts)6TEXT30Text Fieldnvarchar500
24KJCCSJ3DBI03TNaming Convention for Operands for Installed Demand4TEXT30Text (30 Characters)nvarchar300
25TE021TReas.for Blocking Billg (Txts)4TEXT30Text (30 Characters)nvarchar300
26TE023TReas.for Releas.(Txts)4TEXT30Text (30 Characters)nvarchar300
27TE067TRate Fact Groups (Texts)4TEXT30Text (30 Characters)nvarchar300
28TE069TRate Types (Texts)4TEXT30Text (30 Characters)nvarchar300
29TE093TDoc.Type (Texts)4TEXT30Text (30 Characters)nvarchar300
30TE127TManual Bill Outsorting (Texts)4TEXT30Text (30 Characters)nvarchar300
31TE128TManual Bill Outsorting (Texts)4TEXT30Text (30 Characters)nvarchar300
32TE187TUtility Company (Texts)4TEXT30Text (30 Characters)nvarchar300
33TE191TOutsorting Check Groups for Billing (Texts)4TEXT30Text (30 Characters)nvarchar300
34TE192TOutsorting Check Groups for Invoicing (Texts)4TEXT30Text (30 Characters)nvarchar300
35TE221TOperands (Texts)4TEXT30Text (30 Characters)nvarchar300
36TE369TVoltage Level (Texts)4TEXT30Text (30 Characters)nvarchar300
37TE375TOperand Categories (Texts)3TEXT30Text (30 Characters)nvarchar300
38TE432TPeriod Control (Texts)4TEXT30Text (30 Characters)nvarchar300
39TE473TIndustry (Txts)4TEXT30Text (30 Characters)nvarchar300
40TE497TOperation Type for Lighting Unit4TEXT30Text (30 Characters)nvarchar300
41TE667TDoc.Type Cat.4TEXT30Text (30 Characters)nvarchar300
42TE677THeating Inst. Descript. (Texts)4TEXT30Text (30 Characters)nvarchar300
43TE681TProcess. Status of Spec. Agreement for Heating Inst. (Texts)4TEXT30Text (30 Characters)nvarchar300
44TE696TGas Pressure Level at Installation Level (Grid) (Texts)4TEXT30Text (30 Characters)nvarchar300
45TE697TClassification of Employees (Texts)4TEXT30Text (30 Characters)nvarchar300
46TE835TLine Item Type (Texts)4TEXT30Text (30 Characters)nvarchar300
TOPData Collection
47TMC5TDescription of Events for Statistics Updating3TEXT30Text (30 Characters)nvarchar300
48TMC6TDescription of Units for Statistics Updating3TEXT30Text (30 Characters)nvarchar300
TOPDevice installation
49TE791TRec. Reasons (Txt)4TEXT30Text (30 Characters)nvarchar300
TOPIncentive and Commission Management ICM
50TCACS_AVAD1TType of AVAD message: Text4TEXT30AVAD Message Type Descriptionnvarchar300
TOPInformation System
51T007XText for Grouping Tax Amounts7TEXT30Text (30 Characters)nvarchar300
TOPLocalization
52DOCCLSSTTexts for official document class5TEXT30Text (30 Characters)nvarchar300
53J_1AACTTTexts for activity codes for social security withholding4TEXT30Text (30 Characters)nvarchar300
54J_1ACFOPTTexts for codes for foreign natural or legal persons6TEXT30Text (30 Characters)nvarchar300
55J_1ACITITTexts for C.I.T.I. codes5TEXT30Text (30 Characters)nvarchar300
56J_1ACMCDTTexts for customs codes4TEXT30Text (30 Characters)nvarchar300
57J_1ACTYPTC.I.T.I. transaction type5TEXT30Text (30 Characters)nvarchar300
58J_1ADRVERTTexts for versions of VAT daily report5TEXT30Text (30 Characters)nvarchar300
59J_1ADTYPTTexts for distribution types for Gross Income Tax5TEXT30Text (30 Characters)nvarchar300
60J_1AFITPTTexts for Fiscal Types5TEXT30Text (30 Characters)nvarchar300
61J_1AINFSKTText Table: Inflation Keys - G/L Account5TEXT30Inflation Key - G/L Account (Description)nvarchar300
62J_1ANUGR1TTexts for numbering group for official documents4TEXT30Text (30 Characters)nvarchar300
63J_1ANUGR3TTexts for numbering groups for withh. cert. numbering4TEXT30Text (30 Characters)nvarchar300
64J_1AOFTPTTexts for official document types5TEXT30Text (30 Characters)nvarchar300
65J_1APRTCH2Capital letters - texts4TEXT30Text (30 Characters)nvarchar300
66J_1ARFZTTexts for reasons for zero VAT4TEXT30Text (30 Characters)nvarchar300
67J_1ASKCLSTAccount class text table5TEXT30Text (30 Characters)nvarchar300
68J_1ASNRTTexts for subsidiary numbers5TEXT30Text (30 Characters)nvarchar300
69J_1ATODCTTexts for types of identification4TEXT30Text (30 Characters)nvarchar300
70J_1AZFSCHTText Table: Allocation Key: Branch - Company Code4TEXT30Text (30 Characters)nvarchar300
TOPMaster Data
71TE687TTexts: Contract Cat. of Heat. Installation4TEXT30Text (30 Characters)nvarchar300
TOPMeter Reading
72TE017TMR Group (Text)4TEXT30Text (30 Characters)nvarchar300
73TE115TMtr Rdr (Text)4TEXT30Text (30 Characters)nvarchar300
74TE408TCheck Classes of Independent Validations (Texts)4TEXT30Text (30 Characters)nvarchar300
75TE438TMeter Reading Control (Texts)4TEXT30Text (30 Characters)nvarchar300
76TE439TInstlltn Ty.(Txts)4TEXT30Text (30 Characters)nvarchar300
TOPRemaining Beverage - Obsolete Objects
77/BEV3/CHCKTGWEAccount group of the ship-to party3TEXT30Account Group Namenvarchar300
TOPReuse Services for Country Development
78T5F99FCTForms: Condition description6TEXT30Textnvarchar300
TOPSAP Business Partner
79TB930TBusiness Partner: Marital Property Regime: Texts4TEXT30Descriptionnvarchar300
TOPSAP Healthcare - Industry-Specific Components for Hospitals
80NLVERZF_002Konversion SAP Facharzt nach VEKTIS Sorge arzt7TEXT30Tekst 30 positiesnvarchar300
81NLVERZF_003Konversion SAP Entlassung nach VEKTIS Entlassung5TEXT30Tekst 30 positiesnvarchar300
TOPTraders and Schedulers Workbench
82OIJWLRCSTWorklist reason code source texts4TEXT30OIL-TSW: Short text 30 char'snvarchar300
TOPUse AP-MD-BP Components
83TB905TBP Relationship Types: Texts5TEXT30Descriptionnvarchar300