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

84 columns | Print definition?ERP 6.0  | TXT50

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/ATL/GL1TIndex master Description5TXT50Text, 70 charactersnvarchar700
2/ATL/GL2TCalculation Method Descriptions4TXT50Text Fieldnvarchar500
3CNV_20100_SKATCNV backup copy for implementation of country-spec. CoA - ID7TXT50G/L Account Long Textnvarchar500
4CNV_40305_ANKTCNV backup table for Asset classes: Description7TXT50Description 50 charactersnvarchar500
5FIKZD_TRTAXTransport tax Kazakstan24TXT50Asset descriptionnvarchar500
6FILUD_AA_MASTERSAFT: FI Asset master data and values16TXT50Asset descriptionnvarchar500
7T083SLeasing types-Description4TXT50Name of leasing typenvarchar500
8T087JText4TXT50Textnvarchar500
9TSAKRCreate G/L account with reference5TXT50G/L Account Long Textnvarchar500
TOPAccounts Receivable Accounting Process Integration
10TEBPPCATTText Table for Log Entries3TXT50Meaningful Name for the Log Categorynvarchar500
11TEBPP_COMMEVENTTTexts for Communication Events in Biller Direct3TXT50Text Fieldnvarchar500
TOPAccrual Engine
12TACECOMPTApplication Components of Accrual Function4TXT50Textnvarchar500
13TACEPSRULETACE Account Determination: Account Determination Rule5TXT50Textnvarchar500
14TACE_ACRTYPETText for Accrual Types5TXT50Textnvarchar500
TOPAppropriation Requests
15IMAKTAppropriation request text4TXT50Description of appropriation requestnvarchar500
16TAIF9TValue table for user fields5TXT50Description for the use assigned to user fields 3 and 4nvarchar500
TOPBasic Functions
17ANKTAsset classes: Description6TXT50Asset descriptionnvarchar500
18ANLAAsset Master Record Segment76TXT50Asset descriptionnvarchar500
19ANLTAsset Texts6TXT50Asset descriptionnvarchar500
20GLACCREFIG/L Account Master Record: Create with Reference7TXT50G/L Account Long Textnvarchar500
21T011BFI financial calendar - job text table4TXT50Name of tasknvarchar500
22T011FFI fin.calendar - person responsible for unit text table4TXT50Name of schedulenvarchar500
23T087LText table for reasons for environmental investments4TXT50Textnvarchar500
24T091SText for translation methods4TXT50Textnvarchar500
25T093GTTexts for Cross-System Depreciation Areas4TXT50Textnvarchar500
26TA1MTText Table for Line Item Schema4TXT50Text Fieldnvarchar500
27TA1TVTAsset Transfer Variant4TXT50Textnvarchar500
TOPBasis-Related Help Functions, Appl. Log, Formula Intepreter
28TBE22TComplementary Software Partner Product Description4TXT50Text Fieldnvarchar500
29TBE24TLanguage-Specific Customer Product Descriptions4TXT50Text Fieldnvarchar500
30TBESTTDescriptions for Table TBEST4TXT50Text Fieldnvarchar500
TOPContract Accounts Receivable and Payable
31CFC_APPLCTS_TXTCFC: Applications: Texts5TXT50Descriptionnvarchar500
32CFC_APPLOBJ_TXTCFC: Application objects: Texts4TXT50Descriptionnvarchar500
33CFC_CTRLOBJ_TXTCFC: Control objects: Texts3TXT50Descriptionnvarchar500
34CFC_EVENT_TXTCFC: Events: Texts4TXT50Descriptionnvarchar500
35CFC_ITEM_STATE_TCFC: Status of the application table entries (texts)5TXT50Name of Statusnvarchar300
36CFC_WORKSTATE_TClarification Case Processing State (Texts)5TXT50Name of Processing Statusnvarchar300
37TFK001ATClearing reasons (text table)3TXT50Textnvarchar500
38TFK001PTPeriod key4TXT50Text for Period Keynvarchar500
39TFK006XTException Accounts for Clarification Proposal6TXT50Text Fieldnvarchar500
40TFK006YTException Accounts for Clarification Proposal4TXT50Text Fieldnvarchar500
41TFK007KTTax Item Categories for Other Tax Codes4TXT50Textnvarchar500
42TFK042HTOwn Bank Details5TXT50Textnvarchar500
43TFK058TRules for Additional Receivables (Description)4TXT50Textnvarchar500
44TFK068FTNames of Communication Channels4TXT50Textnvarchar500
45TFK068TName of Document Categories3TXT50Text 50 Charactersnvarchar500
46TFKCALLIDTBAPI Caller (Text Table)4TXT50Textnvarchar500
47TFKEXTSYSTTText Table for TFKEXTSYST4TXT50Textnvarchar500
48TFKP2PCTCategories of Promises to Pay4TXT50Textnvarchar500
49TFKP2PRCTReasons for Activating Promise to Pay4TXT50Textnvarchar500
50TFKP2PRWTReasons for Withdrawal of Promise to Pay4TXT50Textnvarchar500
51TFKRDI_DISGRPTDistribution group4TXT50Name of Distribution Groupnvarchar500
52TFKRFCTReasons Prepaid Refills4TXT50Text Fieldnvarchar500
53TFKRFLTExternal Point of Sale for Prepaid Refills4TXT50Text Fieldnvarchar500
54TFKRFMTNames for Refill Methods4TXT50Text Fieldnvarchar500
TOPData Retention Tool
55TXW_S_BSEGRetrieve BSEG from archive122TXT50Textnvarchar500
TOPFinancial Accounting
56/CEECV/ROFIMASKDescript mask account5TXT50G/L Account Long Textnvarchar500
57F107_TPROVH_TProvisions Content4TXT50Textnvarchar500
58J_1GGLLevel accounts of Greek chart of accounts5TXT50G/L Account Long Textnvarchar500
59SKATG/L Account Master Record (Chart of Accounts: Description)6TXT50G/L Account Long Textnvarchar500
60SKMTSample Account Names5TXT50G/L Account Long Textnvarchar500
TOPFunds Management
61FMUP00TUpdate Profiles3TXT50Text Fieldnvarchar500
TOPGeneral Application Functions
62TFISCATTText Table for Log Categories3TXT50Name of Log Categorynvarchar500
63TFIS_COMMEVENTTTexte for Communication Events in Biller Direct3TXT50Text Fieldnvarchar500
TOPGL transfer
64TBKKC_GLACC_TEXTGL-ACCOUNT-TEXT6TXT50G/L Account Long Textnvarchar500
TOPInformation Retention Manager
65IWP_REPOS_FTRetention Warehouse: Repository Field Description6TXT50Descriptionnvarchar500
66IWP_REPOS_STRetention Warehouse: Repository Structure Description5TXT50Descriptionnvarchar500
TOPInvoicing
67TE530TLong Text for Sort Criterion: Bill Printout4TXT50Commentnvarchar500
TOPLease Accounting
68TFILA_GF_008GTName of Grouping Key5TXT50Textnvarchar500
69TFIOTP_001TDocument Group Characteristic Name5TXT50Textnvarchar500
70TFIOTP_002TDocument Group Characteristic Name5TXT50Textnvarchar500
TOPLocalization
71IDCN_GLACCATTRTG/L account time-depen.attributes-texts(CN)7TXT50G/L Account Long Textnvarchar500
TOPPublic Sector Contract Accounts Receivable and Payable
72TFMCA_FPF_RLGRTFPF: Processing Variant for a Form Bundle Type5TXT50Text 50 Charactersnvarchar500
TOPRetention Warehouse
73IWP_DB_AREATDescription of audit areas4TXT50Descriptionnvarchar500
74IWP_DB_AREA_NDTDescription of a folder in the hierachy5TXT50Descriptionnvarchar500
75IWP_DB_REPOSTRetention Warehouse: Repository Description4TXT50Descriptionnvarchar500
76IWP_DB_REPOS_FTRetention Warehouse: Repository field description6TXT50Descriptionnvarchar500
77IWP_DB_REPOS_STRetention Warehouse: Repository structure description5TXT50Descriptionnvarchar500
78IWP_DB_SETTSet description4TXT50Descriptionnvarchar500
79IWP_WPPTAudit Package Template4TXT50Descriptionnvarchar500
TOPSAP Business Partner
80TBZ1BBDT Events: Texts4TXT50Descriptionnvarchar500
81TBZ3MBDT-Screen Sequence Categories: Texts5TXT50Descriptionnvarchar500
82TBZ3TBDT Screen Sequence Variants: Texts5TXT50Descriptionnvarchar500
TOPSAP Healthcare - Industry-Specific Components for Hospitals
83TNLZR4TIS-H NL: LAZR Integriteitscheck Teksten5TXT50Tekstnvarchar500
TOPUse AP-MD-BP Components
84TB036TAuthorization Group Objects: Texts4TXT50Descriptionnvarchar500