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

71 tablesERP 6.0 

Financial Accounting :: Contract Accounts Receivable and Payable :: Business transactions
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0DFKKTXINV141Tax InvoicesBusiness transactions
Financial Accounting :: Contract Accounts Receivable and Payable :: Business transactions :: Customer Contact
ProductVersionTableColumnsIndexesDescriptionModule
2ERP EHP76.0BCONT253Business Partner ContactCustomer Contact
3ERP EHP76.0BCONTA71Contact ActivitiesCustomer Contact
4ERP EHP76.0BCONTAI21Additional Contact InformationCustomer Contact
5ERP EHP76.0BCONTAIT41Additional Information: TextsCustomer Contact
6ERP EHP76.0BCONTAO61Allowed Contact Objects (obsolete as of 4.51)Customer Contact
7ERP EHP76.0BCONTAOT61Contact Object Types: Texts (obsolete as of 4.51)Customer Contact
8ERP EHP76.0BCONTAT51Contact Activities: TextsCustomer Contact
9ERP EHP76.0BCONTBPOBJTYP21Business Partner Object TypeCustomer Contact
10ERP EHP76.0BCONTC31Contact ClassesCustomer Contact
11ERP EHP76.0BCONTCAOR71Assignment of Object Roles to Contact Classes/ActivityCustomer Contact
12ERP EHP76.0BCONTCD21DirectionCustomer Contact
13ERP EHP76.0BCONTCDT41Contact Directions: TextsCustomer Contact
14ERP EHP76.0BCONTCFIND51Contact Configuration DeterminationCustomer Contact
15ERP EHP76.0BCONTCI21Customer InformationCustomer Contact
16ERP EHP76.0BCONTCIT41Customer Information: TextsCustomer Contact
17ERP EHP76.0BCONTCONF211Contact ConfigurationCustomer Contact
18ERP EHP76.0BCONTCONFT41Contact Configuration: TextsCustomer Contact
19ERP EHP76.0BCONTCT41Contact Classes: TextsCustomer Contact
20ERP EHP76.0BCONTF71Additional Contact Fields (obsolete as of 4.51)Customer Contact
21ERP EHP76.0BCONTFORM51Determination of Contact Class, Activity and ConfigurationCustomer Contact
22ERP EHP76.0BCONTFORMCLASS51Determination of Contact Class, Activity and ConfigurationCustomer Contact
23ERP EHP76.0BCONTFR71Supply Additional Fields with DataCustomer Contact
24ERP EHP76.0BCONTO62Objects for Business Partner Contact (obsolete as of 4.51)Customer Contact
25ERP EHP76.0BCONTOR41Object Roles for Business Partner ContactCustomer Contact
26ERP EHP76.0BCONTORT41Object Roles for Business Partner Contact: TextsCustomer Contact
27ERP EHP76.0BCONTP21Contact PriorityCustomer Contact
28ERP EHP76.0BCONTPT41Contact Priority: TextsCustomer Contact
29ERP EHP76.0BCONTT21Contact TypeCustomer Contact
30ERP EHP76.0BCONTTT41Contact Types: TextsCustomer Contact
31ERP EHP76.0BPCTOBJTR31Customer Contact: Transformation Rules for Object CatgoriesCustomer Contact
32ERP EHP76.0BPCTPOSFORM61Object Relationships for BP Contact: Attribute ValuesCustomer Contact
33ERP EHP76.0BPCTSRGBINREL63Business Partner Contact: Generic Binary RelationshipsCustomer Contact
34ERP EHP76.0BPCT_CRM_CLASS121Display Contact Type/Class on CRM ActivitiesCustomer Contact
35ERP EHP76.0BPCT_CRM_DIRECT31Creation of Contact Direction from Contact -> ActivityCustomer Contact
36ERP EHP76.0BPCT_CRM_GUIDS52Assignment: Contact Key -> Activity GUIDCustomer Contact
37ERP EHP76.0BPCT_CRM_PRIO31Creation of Priority Contact -> ActivityCustomer Contact
38ERP EHP76.0BPCT_CRM_TDID31Creation of Text ID Contact -> ActivityCustomer Contact
Financial Accounting :: Contract Accounts Receivable and Payable :: Business transactions :: Interest Calculation
ProductVersionTableColumnsIndexesDescriptionModule
39ERP EHP76.0T056G121Interest calculation rulesInterest Calculation
40ERP EHP76.0T056H41Text tab. for int.calc.ruleInterest Calculation
41ERP EHP76.0T056I121Time-dep.terms for interest calc.ruleInterest Calculation
42ERP EHP76.0T056J61Time-dependent terms for interest calc.rule - accessInterest Calculation
Financial Accounting :: Contract Accounts Receivable and Payable :: Business transactions :: Payments
ProductVersionTableColumnsIndexesDescriptionModule
43ERP EHP76.0DFKKBLTO21Boleto (help table for lock object EFKKNR_BOLETO)Payments
44ERP EHP76.0DFKKBOH434Boleto: Header dataPayments
45ERP EHP76.0DFKKBOLXT21Boleto (Help table for lock object EFKKNR_BOLEXTPayments
46ERP EHP76.0DFKKBOL_BANKID111Boleto: Bank ID Determination ResultsPayments
47ERP EHP76.0DFKKBOP222Boleto: Item DataPayments
48ERP EHP76.0TFK015W161Boleto: InstructionPayments
49ERP EHP76.0TFK015W1T61Boleto: Instruction Keys - DescriptionPayments
50ERP EHP76.0TFK015WT61Boleto: Instruction Code - DescriptionPayments
51ERP EHP76.0TFKBOL_BANKID51Boleto: Bank ID Determination CustomizingPayments
52ERP EHP76.0TFKBOL_BOLEXT81Boleto: Number range for external BoletoPayments
53ERP EHP76.0TFKBOL_BOLXT61Boleto: external Boleto number rangesPayments
54ERP EHP76.0TFKBOL_ICODET51Boleto: Internal code - instruction key 1- textPayments
55ERP EHP76.0TFKBOL_INSTR61Boleto: Instruction KeysPayments
56ERP EHP76.0TFKBOL_INST_CODE91Boleto: Instruction KeysPayments
57ERP EHP76.0TFKBOL_TEXT61Boleto: Instruction Keys - DescriptionPayments
Financial Accounting :: Contract Accounts Receivable and Payable :: Business transactions :: Security Deposits
ProductVersionTableColumnsIndexesDescriptionModule
58ERP EHP76.0FKK_SEC244Security DepositSecurity Deposits
59ERP EHP76.0FKK_SEC_C52Contracts for Security DepositSecurity Deposits
60ERP EHP76.0FKK_SEC_N93Noncash Security DepositSecurity Deposits
61ERP EHP76.0FKK_SEC_REQ92Request Documents for Security DepositsSecurity Deposits
62ERP EHP76.0TFK_SEC151General settings for security depositsSecurity Deposits
63ERP EHP76.0TFK_SEC_APPLK51Fixed Settings for Security Deposits (Obsolete)Security Deposits
64ERP EHP76.0TFK_SEC_REASON21Reason for requesting a security depositSecurity Deposits
65ERP EHP76.0TFK_SEC_REASON_T41Reason for requesting a security deposit (texts)Security Deposits
66ERP EHP76.0TFK_SEC_REV21Reversal Reason for Security DepositSecurity Deposits
67ERP EHP76.0TFK_SEC_REV_T41Reversal Reason for Security Deposit (Texts)Security Deposits
68ERP EHP76.0TFK_SEC_STATUS21Noncash security deposit statusSecurity Deposits
69ERP EHP76.0TFK_SEC_STATUS_T41Noncash security deposit status (texts)Security Deposits
70ERP EHP76.0TFK_SEC_TYPE21Noncash security deposit categorySecurity Deposits
71ERP EHP76.0TFK_SEC_TYPE_T41Noncash Security Deposit Category (Texts)Security Deposits