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

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/ATL/LHTMBNKReconciled bank lines6ANWNDApplication using bank data storagenvarchar40
2/SAPF15/ELKOSAPF15 Rückmeldung vergebene Kontoauszugsnummer3ANWNDAnwendung die den Bankdatenspeicher nutztnvarchar40
3BKKPOMNDPayment order Enriched with Mandate details23ANWNDSEPA: Application for Which Mandate Relevantnvarchar10
4FIPYXXD_INSTMTBank Statement File Identification Table2ANWNDApplication using bank data storagenvarchar40
5SEPA_CI_PROCSEPA CI Limits and CI Whitelist3ANWNDSEPA: Application for Which Mandate Relevantnvarchar10
6SEPA_CI_PROC_ENQSEPA CI Limit: Auxilliary Table for ENQUEUE2ANWNDSEPA: Application for Which Mandate Relevantnvarchar10
7SEPA_CI_PROC_HISSEPA CI Limits and CI Whitelist4ANWNDSEPA: Application for Which Mandate Relevantnvarchar10
8SEPA_CUST_SDSEPA Mandate Management: Customizing SD2ANWNDSD-SEPA: Applicationnvarchar20
9SEPA_MDTENQ_MULTSEPA Mandate: Auxilliary Table for Multiple Enqueue3ANWNDSEPA: Application for Which Mandate Relevantnvarchar10
10SEPA_PARAMSAdditional Parameters for the Management of SEPA Mandates2ANWNDSEPA: Application for Which Mandate Relevantnvarchar10
11SEPA_SPARAMSAdditional Parameters for the Management of SEPA Mandates1ANWNDSEPA: Application for Which Mandate Relevantnvarchar10
12SEPA_STATUS_CUSTSEPA Mandate: Customizing for Status Transition2ANWNDSEPA: Application for Which Mandate Relevantnvarchar10
13T021AForms for Additional Information2ANWNDApplication for Additional Formnvarchar100
14T021DLine Layout Fast Entry: Administration2ANWNDFast Entry: Applicationnvarchar50
15T021FLine Layout Fast Entry: Variants2ANWNDFast Entry: Applicationnvarchar50
16T021GLine Layout Fast Entry: Description of Variants3ANWNDFast Entry: Applicationnvarchar50
17T021JFast Entry: Inactive Standard Variants2ANWNDFast Entry: Applicationnvarchar50
18T021NName of Sort Variants4ANWNDApplicationnvarchar50
19T021QFast Entry Line Layout: Control2ANWNDFast Entry: Applicationnvarchar50
20T033AAccount Determination: Applications1ANWNDAccount Determination: Applicationnvarchar40
21T033BAccount Determination: Name of Applications2ANWNDAccount Determination: Applicationnvarchar40
22T033DAccount Determination: Account Determination Key Names2ANWNDAccount Determination: Applicationnvarchar40
23T033EAccount Determination: Control Data2ANWNDAccount Determination: Applicationnvarchar40
24T033FAccount Determination: Posting Rules2ANWNDAccount Determination: Applicationnvarchar40
25T033GAcct determination: Replacing the account symbols2ANWNDAccount Determination: Applicationnvarchar40
26T033IAcct Determination: Account Symbols2ANWNDAccount Determination: Applicationnvarchar40
27T033JAccount Determination: Account Symbol Descriptions3ANWNDAccount Determination: Applicationnvarchar40
28T033OAccount Determination: Account Determination Key Values1ANWNDAccount Determination: Applicationnvarchar40
29T033PAccout Determination: Name of Acct Determination Key Values2ANWNDAccount Determination: Applicationnvarchar40
30TFK021KASFI-CA: Detail Screen Layout for Add-On Developments4ANWNDApplicationnvarchar50
TOPBank
31NBNKNumber range for banks2ANWNDApplication for number rangenvarchar100
32SEPA_CTRLSEPA Mandate Management: System Control1ANWNDSEPA: Application for Which Mandate Relevantnvarchar10
33SEPA_CTRLTSEPA Mandate Management: System Control2ANWNDSEPA: Application for Which Mandate Relevantnvarchar10
34SEPA_CUSTSEPA Mandate Management: Customizing2ANWNDSEPA: Application for Which Mandate Relevantnvarchar10
35SEPA_FIELDSSEPA Mandate Management: Modifiable Fields2ANWNDSEPA: Application for Which Mandate Relevantnvarchar10
36SEPA_MANDATESEPA Mandate23ANWNDSEPA: Application for Which Mandate Relevantnvarchar10
37SEPA_SFIELDSSEPA Mandate Management: Modifiable Fields1ANWNDSEPA: Application for Which Mandate Relevantnvarchar10
TOPBasic Functions
38FEBKOElectronic Bank Statement Header Records2ANWNDApplication using bank data storagenvarchar40
39FEBVWElectronic Banking Management Records2ANWNDApplication using bank data storagenvarchar40
TOPContract Accounts Receivable and Payable
40FKKBSTMCAcct Statement Tfr:History of Processed MultiCash Statements5ANWNDApplication using bank data storagenvarchar40
41TFK021DScreen variants: Administration2ANWNDScreen Variants: Applicationnvarchar50
42TFK021FScreen variants: Number of lines2ANWNDScreen Variants: Applicationnvarchar50
43TFK021GScreen variants: Description of variants3ANWNDScreen Variants: Applicationnvarchar50
44TFK021IFast entry line layout: Variant fields2ANWNDScreen Variants: Applicationnvarchar50
45TFK021KSubscreen Management (SAP)2ANWNDApplicationnvarchar50
46TFK021KCDetail Screen Structure for Document Display (Customer)2ANWNDApplicationnvarchar50
47TFK021PCScreen Variants: Reference Screens (Customer)3ANWNDScreen Variants: Applicationnvarchar50
48TFK021SScreen variants (standard): Management2ANWNDScreen Variants: Applicationnvarchar50
49TFK021XScreen variants (standard): Meaning of variants3ANWNDScreen Variants: Applicationnvarchar50
TOPFinancial Accounting
50T021HLine Layout Fast Entry: Screen Variants2ANWNDFast Entry: Applicationnvarchar50
51T021ILine Layout Fast Entry: Variant Fields2ANWNDFast Entry: Applicationnvarchar50
52T021MSort Variants3ANWNDApplicationnvarchar50
53T021STDFFast Entry: Standard Variant Fields2ANWNDFast Entry: Applicationnvarchar50
54T021STDTFast Entry: Standard Variants (Texts)3ANWNDFast Entry: Applicationnvarchar50
55T021STDVFast Entry: Standard Variants2ANWNDFast Entry: Applicationnvarchar50
56T033CAccount Determination: Administration Data1ANWNDAccount Determination: Applicationnvarchar40
TOPFlexible Real Estate Management
57TIVPROTPK1Kontenfindung zum Buchungsvorgang: primär5ANWNDKontenfindung: Anwendungnvarchar40
58TIVPROTPK2Kontenfindung zum Buchungsvorgang: sekundär6ANWNDKontenfindung: Anwendungnvarchar40
TOPReal Estate Management
59TIVC5RE: Determine Factors for Account Determination1ANWNDAccount Determination: Applicationnvarchar40
60TIVCN06RE Contract: Product Category <-> AcctDet. Application2ANWNDAccount Determination: Applicationnvarchar40