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

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1J_1UF_TP_GROUPTTransfer pricing groups definition table13TXT30Short textnvarchar400
2J_1UF_TP_SCRTransfer pricing selection criteria definition6TXT30Short textnvarchar400
3J_3RF_TP_GROUPTTransfer pricing groups definition table37TXT30Short textnvarchar400
4J_3RF_TP_SCRTransfer pricing selection criteria definition13TXT30Short textnvarchar400
5J_3RF_TP_SCRMATMaterials list for selection group5TXT30Short textnvarchar400
6T001JCompany Code - Parameter Type Names3TXT30Textnvarchar300
7T031TName of Bill of Exchange Status5TXT30Textnvarchar300
8T042HText table for additional payment methods4TXT30Textnvarchar300
9T077TTable no longer in use5TXT30Account Group Namenvarchar300
10T077XAccount Group Names (Table T077D)4TXT30Account Group Namenvarchar300
11T077YAccount Group Names (Table T077K)4TXT30Account Group Namenvarchar300
12T077ZAccount Group Names (Table T077S)5TXT30Account Group Namenvarchar300
13TFK005DTTexts for TFK005D3TXT30Textnvarchar500
TOPBasic Functions
14T082HField string name: Asset master data maintenance5TXT30Name of screen layout rulenvarchar300
TOPBasis-Related Help Functions, Appl. Log, Formula Intepreter
15TBE32TP&S BTE: Partner Function Module Descriptions8TXT30Text on additional components per function modulenvarchar300
TOPCentral Cash Desk Procedure
16FMFGT_FSNTText table for Fiscal Station Number - US. Fed. Government4TXT30Textnvarchar300
TOPCollectionsDisbursements
17TIBRSELTYPTSelection Category Texts for the Broker Report4TXT30Textnvarchar300
18TKKVHVTVTFS-CD Transactions: Texts8TXT30Textnvarchar300
19TKKVIHVORTFS-CD Internal Transactions3TXT30Textnvarchar300
20TKKVVKKMTText Table for Modif. No. for Invoice Fields6TXT30Text (30 Characters)nvarchar300
TOPContract Accounts Receivable and Payable
21TE305TTransactions for Company Code and Division (Texts)9TXT30Textnvarchar300
22TEIHVORTIS-U Internal Transactions (Obsolete)3TXT30Textnvarchar300
23TEIIVORTInternal Transactions for Collective Bills5TXT30Textnvarchar300
24TEISVORTCollective Bill Transactions5TXT30Textnvarchar300
25TEITVORTText Tables: Internal Subtransactions (Obsolete)4TXT30Textnvarchar300
26TFK000KTDescription of account assignment categories3TXT30Textnvarchar300
27TFK001GTName of Company Code Groups4TXT30Group Namenvarchar300
28TFK004TSelection categories for manual payment processing5TXT30Textnvarchar300
29TFK056STBlocking Reasons for Interest Calculation (Text Table)4TXT30Name of Interest Lock Reasonnvarchar300
30TFK059ETAdditional Withholding Tax : Texts5TXT30Text (30 Characters)nvarchar300
31TFKAVARITWrite-Off Variants4TXT30Language-Related Text Fieldnvarchar300
32TFKAVARTWrite-Off Variants: Age and Amount Grid7TXT30Language-Related Text Fieldnvarchar300
33TFKHVOTMain transactions in contract accts receivable and payable5TXT30Name of Main Transactionnvarchar300
34TFKIHVORTInternal Main Transactions - Text Table4TXT30Textnvarchar300
35TFKITVORTInternal Sub-Transactions5TXT30Textnvarchar300
36TFKTVOTSub-transactions in Contract Accounts Receivable and Payable6TXT30Name of Subtransactionnvarchar300
37TFKZGRTDesription of Reasons for Doubtful Items/IVA4TXT30Language-Related Text Fieldnvarchar300
38TFKZMETHTText Table for TFKZMETH4TXT30Language-Related Text Fieldnvarchar300
39TFKZRGRTDescription of Reset Reasons for Doubtful Items/IVA4TXT30Textnvarchar300
40TFKZVARITValue Adjustment Variants4TXT30Language-Related Text Fieldnvarchar300
41TFKZVARTValue Adjustment Variants - Definition of Age Grid5TXT30Language-Related Text Fieldnvarchar300
TOPFinancial Accounting
42F107_TPROVMETH_TTexts for Provision Calculation Method4TXT30Textnvarchar300
43T043GTName of Business Partner's Tolerance Groups5TXT30Name of Tolerance Groupnvarchar300
44T043STName of Business Partner's Tolerance Groups5TXT30Name of Tolerance Groupnvarchar300
TOPFunds Management
45FMFGT_ALCTText Table for Agency Location Codes - U.S. Fed Gov4TXT30Agency Location Code Textnvarchar300
46FMFGT_POTText table for Payment Office - U.S. Federal Government4TXT30Textnvarchar300
TOPGeneral status management
47TJ02TSystem status texts4TXT30Object statusnvarchar300
48TJ30TTexts for User Status6TXT30Object statusnvarchar300
49TJ48TText Table for Selection IDs4TXT30Text (30 Characters)nvarchar300
TOPGeneric Contract Accounts Receivable and Payable
50TFSCHVTVTTransactions for Company Code and Division (Texts)9TXT30Textnvarchar300
TOPInformation System
51T044KTFurther Specifications for Sorted List7TXT30Textnvarchar300
52T044LTSorted List of Open Items4TXT30Textnvarchar300
TOPPlant Maintenance
53EAMS_CVBSYSSTATSystem Status and Icon Combination of Objects5TXT30Status Descriptionnvarchar300
54EAMS_CVBSYSTSTSystem Status and Priority Combination of Objects (Text)5TXT30Status Descriptionnvarchar300
55EAMS_CVBUSSTSUser Status and Icon Combination of Objects6TXT30Status Descriptionnvarchar300
TOPReal Estate Management
56S406Rental units79TXT30Occupancy type (text)nvarchar300
57VIRPS406Rental units78TXT30Occupancy type (text)nvarchar300
TOPSAP Business Partner
58TBZ0NBDT Activities: Texts5TXT30BDT: Name of Activitynvarchar300
TOPTraders and Schedulers Workbench
59OIJWLRCTOIL-TSW: Reason code text4TXT30OIL-TSW: Short text 30 char'snvarchar300
TOPTransaction Manager
60ATR1TText table for reference categories4TXT30Name of reference category (long)nvarchar300