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

168 tablesERP 6.0 

Financial Accounting :: Bank Accounting
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0BSEGC341Document: Data on Payment Card PaymentsBank Accounting
2ERP EHP76.0CCENQ41Payment cards: Primary table for lock object EFCCENQBank Accounting
3ERP EHP76.0DFPAYG151Payment date: GroupingBank Accounting
4ERP EHP76.0DFPAYHT91Note to Payee and Payment Advice Note TextsBank Accounting
5ERP EHP76.0DFPAYMENT_KEY_ID92Contains ID for Payment Data KeyBank Accounting
6ERP EHP76.0DFPAYV111Payment Medium: Selection VariantsBank Accounting
7ERP EHP76.0DFPM_AUTH21Payment medium: Authorization Check Origin ActiveBank Accounting
8ERP EHP76.0FPS_BLOCK41Payment and Dunning Block for Each Payment Service ProviderBank Accounting
9ERP EHP76.0REGUT334TemSe - Administration DataBank Accounting
10ERP EHP76.0REGUTA91Paying Company Codes for DME FilesBank Accounting
11ERP EHP76.0T042ECT51Letter for Payment Correspondence (PDF)Bank Accounting
12ERP EHP76.0T042T131Text modules for payment formsBank Accounting
13ERP EHP76.0T042ZA51Additional specifications for payment methodBank Accounting
14ERP EHP76.0TCCAA121Payment cards: Clearing account/external functionsBank Accounting
15ERP EHP76.0TCCFI81Payment cards: Central FI settingsBank Accounting
16ERP EHP76.0TCCLG221Payment Cards: Settlement Run LogBank Accounting
17ERP EHP76.0TCCLGT51Payment cards: Settlement run log (texts)Bank Accounting
18ERP EHP76.0TCCRC31Payment Cards: Check ResultsBank Accounting
19ERP EHP76.0TCCRCT51Payment cards: Results of checks (texts)Bank Accounting
20ERP EHP76.0TCJ_BALANCE91FI Cash Journal: Totals RecordsBank Accounting
21ERP EHP76.0TFIBLSCREEN51Control of Output of Screen FieldsBank Accounting
22ERP EHP76.0TFIBLSCREEN021Register Programs for Screen ControlBank Accounting
23ERP EHP76.0TFIBLSCREEN131Define Contents of Screen GroupsBank Accounting
24ERP EHP76.0TFIBLSCREEN1T51Define Contents of Screen GroupsBank Accounting
25ERP EHP76.0TFPM042F121Payment medium formats: General attributesBank Accounting
26ERP EHP76.0TFPM042FB31Payment medium formats: EventsBank Accounting
27ERP EHP76.0TFPM042FBC41Payment medium formats: Customer eventsBank Accounting
28ERP EHP76.0TFPM042FD31Payment Medium Formats: Preassignment of Format ParametersBank Accounting
29ERP EHP76.0TFPM042FDC41Payt Medium Formats: Cust. Preassignm. of Format ParametersBank Accounting
30ERP EHP76.0TFPM042FF21Payment medium formats: Format parametersBank Accounting
31ERP EHP76.0TFPM042FFC61Payment medium formats: Customer format parametersBank Accounting
32ERP EHP76.0TFPM042FG61Payment medium formats: Level of detail of payment mediumBank Accounting
33ERP EHP76.0TFPM042FGC71Payt. medium formats: Cust. level of det. of payment mediumsBank Accounting
34ERP EHP76.0TFPM042FM41Payment medium formats: Reqd fields for format parametersBank Accounting
35ERP EHP76.0TFPM042FMC51Payment medium formats: Cust. reqd. fields for format para.Bank Accounting
36ERP EHP76.0TFPM042FPB21Payment Medium Formats: Modules for Payment Doc. ValidationBank Accounting
37ERP EHP76.0TFPM042FSB61Payment Medium Formats: Modules for Writing/Sending FilesBank Accounting
38ERP EHP76.0TFPM042FT71Payment medium formats: TextsBank Accounting
39ERP EHP76.0TFPM042FV51Payment medium formats: Note to payee fieldsBank Accounting
40ERP EHP76.0TFPM042FZ21Payment medium formats: SupplementsBank Accounting
41ERP EHP76.0TFPM042FZT41Payment medium formats: Supplement textBank Accounting
42ERP EHP76.0TFPM042VA51Payment medium: Note to payeeBank Accounting
43ERP EHP76.0TFPM042VAT41Payment medium: Note to payee textsBank Accounting
44ERP EHP76.0TFPM042VI71Payment medium: Note to payee contentsBank Accounting
45ERP EHP76.0TFPM042VJ61Payment Media: Content of Note to Payee Lang. IndependentBank Accounting
Financial Accounting :: Bank Accounting :: Master Data
ProductVersionTableColumnsIndexesDescriptionModule
46ERP EHP76.0T012111House BanksMaster Data
47ERP EHP76.0T012K231House Bank AccountsMaster Data
48ERP EHP76.0T012T61House Bank Account NamesMaster Data
Financial Accounting :: Bank Accounting :: Payment Transactions
ProductVersionTableColumnsIndexesDescriptionModule
49ERP EHP76.0ACRELATION61Relationships in AccountingPayment Transactions
50ERP EHP76.0BUSPROC_FCT_FIEB31FIEB: Function Modules for Business ProcessPayment Transactions
51ERP EHP76.0FIBL_RPCODE241Master Data for Repetitive CodePayment Transactions
52ERP EHP76.0FIBL_RPCODE_GREL51Assign Repetitive Codes/GroupsPayment Transactions
53ERP EHP76.0FIBL_RPCODE_GROU21Groups of Repetitive CodesPayment Transactions
54ERP EHP76.0FIBL_RPCODE_GRTX41Group Names of Repetitive CodePayment Transactions
55ERP EHP76.0FIBL_RPCODE_TDEF81Default Values for Repetitive CodesPayment Transactions
56ERP EHP76.0FIEBCHKF51FIEB: File Name of Last Check-OutPayment Transactions
57ERP EHP76.0FIEBCHKO101FIEB: Check-Out Data on a Physical DocumentPayment Transactions
58ERP EHP76.0FIEBCONT171FIEB: Table for Document Contents (Import/Export)Payment Transactions
59ERP EHP76.0FIEBLOIO181FIEB: Instances of Logical DocumentsPayment Transactions
60ERP EHP76.0FIEBLOIOT51FIEB: Descriptions of Logical DocumentsPayment Transactions
61ERP EHP76.0FIEBLOPR72FIEB: Attribute Values of Logical DocumentsPayment Transactions
62ERP EHP76.0FIEBLORE113FIEB: Outgoing Relationships of Logical DocumentsPayment Transactions
63ERP EHP76.0FIEBLORI113FIEB: Incoming Relationships of Physical DocumentsPayment Transactions
64ERP EHP76.0FIEBPHF101FIEB: Physical document filesPayment Transactions
65ERP EHP76.0FIEBPHHR121FIEB: Outgoing Hyperlinks From Physical DocumentsPayment Transactions
66ERP EHP76.0FIEBPHIO251FIEB: Instances of Physical DocumentsPayment Transactions
67ERP EHP76.0FIEBPHNM123FIEB: Use of Target Anchors in Physical DocumentsPayment Transactions
68ERP EHP76.0FIEBPHPR72FIEB: Physical document attributesPayment Transactions
69ERP EHP76.0FIEBPHRE111FIEB: Outgoing Relationships of Physical DocumentsPayment Transactions
70ERP EHP76.0FIEBPHRI111FIEB: Incoming Relationships of Physical DocumentsPayment Transactions
71ERP EHP76.0FIEBRE113FIEB: Instances of RelationshipsPayment Transactions
72ERP EHP76.0FIEBREPR72FIEB: Attributes of RelationshipsPayment Transactions
73ERP EHP76.0FIEB_BUSPRO11Business Processes in ApplicationsPayment Transactions
74ERP EHP76.0FIEB_BUSPROT31Names of Application Business ProcessesPayment Transactions
75ERP EHP76.0FIEB_OID_LOCK21Used to Lock any Given Objects Using Their OIDPayment Transactions
76ERP EHP76.0FIEB_PASSWORD31Passwords (stored in encrypted form)Payment Transactions
77ERP EHP76.0FIEB_STATUS241FIEB: Status Management, Save StatusPayment Transactions
78ERP EHP76.0FIEB_STATUSV21Status Values for Internet MessagesPayment Transactions
79ERP EHP76.0FIEB_STATUSVT41Names of Status Values for Internet MessagesPayment Transactions
80ERP EHP76.0FIEB_STATUS_LOCK21Dummy to Block Status According to Non-Primary Key FieldsPayment Transactions
81ERP EHP76.0GENERAL_EB_FIEB21General Customizing Table for Electronic BankingPayment Transactions
82ERP EHP76.0HBNK_LOGADR_FIEB41Assignment of House Bank to Logical AddressPayment Transactions
83ERP EHP76.0LOGADR_ATTR_FIEB111Attributes of Logical AddressesPayment Transactions
84ERP EHP76.0LOGADR_PHAD_FIEB41Physical Address for a Logical AddressPayment Transactions
85ERP EHP76.0OFX_BP_MSGS_FIEB31Customizing of OFX Message Sets for Business ProcessesPayment Transactions
86ERP EHP76.0OFX_LA_MSGS_FIEB51Message Sets per Business ProcessPayment Transactions
87ERP EHP76.0OFX_VERSION_FIEB31Attributes for a DTD Version of OFXPayment Transactions
88ERP EHP76.0PAYR635Payment Medium FilePayment Transactions
89ERP EHP76.0PCEC151Prenumbered ChecksPayment Transactions
90ERP EHP76.0REGUHM203Payment Data for Cross-Payment Run Payment MediumPayment Transactions
91ERP EHP76.0REGUP_CORE371Processed Items from Payment ProgramPayment Transactions
92ERP EHP76.0REGUVM31Payment Data for Cross-Payment Run Payment MediumPayment Transactions
93ERP EHP76.0T012D281Parameters for DMEs and foreign pmnt transactionsPayment Transactions
94ERP EHP76.0T015V21Application Area for Instructions in Payment TransactionsPayment Transactions
95ERP EHP76.0T015VT31Long text for application areasPayment Transactions
96ERP EHP76.0T015W021Allocate application areas to instruction fieldsPayment Transactions
97ERP EHP76.0T015W151InstructionsPayment Transactions
98ERP EHP76.0T015W1T51Instructions (explanatory text)Payment Transactions
99ERP EHP76.0T015WT61Explanation of Instruction KeyPayment Transactions
100ERP EHP76.0T042B201Details on the company codes that must payPayment Transactions
101ERP EHP76.0T042E351Company Code-Specific Specifications for Payment MethodsPayment Transactions
102ERP EHP76.0T042Q41Permitted Destination Lands for Payment MethodPayment Transactions
103ERP EHP76.0T042W41Permitted currency keys for payment methodPayment Transactions
104ERP EHP76.0T042YP71Account Determination for HR PaymentsPayment Transactions
105ERP EHP76.0T042Z351Payment Methods for Automatic PaymentPayment Transactions
106ERP EHP76.0T042ZT51Texts of Payment Methods for Automatic PaymentPayment Transactions
107ERP EHP76.0TFIBLAPARPVAR131Online Payment: VariantsPayment Transactions
108ERP EHP76.0TFIBLFFPVAR221Online Payment: VariantsPayment Transactions
109ERP EHP76.0TFIBLHBG31Group of House Bank AccountsPayment Transactions
110ERP EHP76.0TFIBLHBG151Group of House Bank Accounts: DetailsPayment Transactions
111ERP EHP76.0TFIBLHBGT51Name of the House Bank GroupsPayment Transactions
112ERP EHP76.0TFIBLMPAYBLOCK41Reservation for Cross-Payment Run Payment MediaPayment Transactions
113ERP EHP76.0TFIBLMPAYBLOCKID11Run Identification for Cross-Payment Run Payment MediumPayment Transactions
114ERP EHP76.0TFIBLMPVAR211Online Payment: VariantsPayment Transactions
115ERP EHP76.0TFIBLOPAY131Origin of Online PaymentsPayment Transactions
116ERP EHP76.0TFIBLOPAYSTEP61Online Payments: Determine Process StepsPayment Transactions
117ERP EHP76.0TFIBLOPDOCTYPE31Document Types for Online PaymentsPayment Transactions
118ERP EHP76.0TFIBLOPVAR71Online Payment: Administration of VariantsPayment Transactions
119ERP EHP76.0TFIBLORIGIN31Origin IndicatorPayment Transactions
120ERP EHP76.0TFIBLORIGINC61Origin SettingsPayment Transactions
121ERP EHP76.0TFIBLORIGIND21Assignment of Origin to Overriding OriginPayment Transactions
122ERP EHP76.0TFIBLORIGINT31Meaning of an Origin IndicatorPayment Transactions
Financial Accounting :: Bank Accounting :: Master Data :: Bank Master Data
ProductVersionTableColumnsIndexesDescriptionModule
123ERP EHP76.0TBCHAIN0101Definition bank chainsBank Master Data
124ERP EHP76.0TBCHAIN1102Bank chainsBank Master Data
125ERP EHP76.0TBCHAIN281Bank Chains per Business Partner AccountBank Master Data
126ERP EHP76.0TBCHAIN21141Bank chains per business partner account (allocation)Bank Master Data
127ERP EHP76.0TBCHAINC021Assign Scenario for Bank Chain Determination to ClientBank Master Data
128ERP EHP76.0TBCHAINE031Definition of the scenarios for bank chain determinationBank Master Data
129ERP EHP76.0TBCHAINE0T31Definition of scenarios for bank chain determination (texts)Bank Master Data
130ERP EHP76.0TBCHAINE161Character. value of scenarios for determining bank chainBank Master Data
Financial Accounting :: Bank Accounting :: Payment Transactions :: Automatic Payments
ProductVersionTableColumnsIndexesDescriptionModule
131ERP EHP76.0F111G71Global Settings: Payment Program for Payment RequestsAutomatic Payments
132ERP EHP76.0F111PARAM_MODIFY91Note whether RF_F111_PARAMETERS_MODIFY_ONCE has already runAutomatic Payments
133ERP EHP76.0FDZA201Cash Management line items in payment requestsAutomatic Payments
134ERP EHP76.0PAYRQ1703Payment RequestsAutomatic Payments
135ERP EHP76.0PAYRQP143PAYRQ Enhancement (Cross-Country Bank Account Transfers)Automatic Payments
136ERP EHP76.0PAYRQT61Reference Texts for Payment RequestAutomatic Payments
137ERP EHP76.0SMFIBL61Spec. FI-BL Data in MonitorAutomatic Payments
138ERP EHP76.0T018V81Acct Transfer: Determine Receiving Bank's Clearing AccountAutomatic Payments
139ERP EHP76.0T036R51Payment Request LevelsAutomatic Payments
140ERP EHP76.0T042EA31Payment method capability for ALE distributionAutomatic Payments
141ERP EHP76.0T042Y101Account Determination for Bank to Bank PaymentsAutomatic Payments
142ERP EHP76.0TBKDC41Day Difference betw. House Bank and Beneficiary Value DatesAutomatic Payments
143ERP EHP76.0TBKFK51Factory Calendar Identification Using CurrencyAutomatic Payments
144ERP EHP76.0TBKPV61Time Between Payment Run and Value Date at House BankAutomatic Payments
145ERP EHP76.0TPRQPB21Payment Block when using Payment RequestsAutomatic Payments
Financial Accounting :: Bank Accounting :: Payment Transactions :: Bank Statement :: Electronic Bank Statement
ProductVersionTableColumnsIndexesDescriptionModule
146ERP EHP76.0FEBIP101Posting Parameters for PostprocessingElectronic Bank Statement
147ERP EHP76.0FEBKO_TRANSFER191Transferred Bank StatementsElectronic Bank Statement
148ERP EHP76.0FEBRE_ORIG51Original Ref. Record for an Elec. Bank Statement Line ItemElectronic Bank Statement
149ERP EHP76.0FEB_ACCNT_SAVE911Saving of Posting Lines for Postprocessing (Account Assign.)Electronic Bank Statement
150ERP EHP76.0FEB_ACT851Acct Assignment TemplatesElectronic Bank Statement
151ERP EHP76.0FEB_ACTT52Descriptions of Account Assignment TemplatesElectronic Bank Statement
152ERP EHP76.0FEB_AVIR_EXTD141Advice Note Subitem Enhancement (Bank Statement Postproc.)Electronic Bank Statement
153ERP EHP76.0FEB_FILEPATH51Client-Dependent Definition of Logical File PathsElectronic Bank Statement
154ERP EHP76.0FEB_FILEPATHT41Description of Logical File PathsElectronic Bank Statement
155ERP EHP76.0FEB_IMP_FORMAT11Bank Statement Formats for Automatic ImportElectronic Bank Statement
156ERP EHP76.0FEB_IMP_FORMATT31Format DescriptionElectronic Bank Statement
157ERP EHP76.0FEB_IMP_POST141Posting Parameters for Electronic Bank StatementElectronic Bank Statement
158ERP EHP76.0FEB_IMP_SELOPT111Selection Options of Posting ParametersElectronic Bank Statement
159ERP EHP76.0FEB_IMP_SOURCE91Information about Import for Electronic Bank StatementElectronic Bank Statement
160ERP EHP76.0FEB_IMP_STRUCT31Format-Specific Parameter StructuresElectronic Bank Statement
161ERP EHP76.0FEB_IMP_TRANPATH51Transfer Paths for Logical Bank Statement FilesElectronic Bank Statement
162ERP EHP76.0FEB_IMP_TRANS51Transfer of Logical Bank Statement FilesElectronic Bank Statement
163ERP EHP76.0FEB_ITEM_SAVE221Saving of Posting Items for Postprocessing (On Account)Electronic Bank Statement
164ERP EHP76.0FEB_PARMT_POST101Posting Parameters for PostprocessingElectronic Bank Statement
165ERP EHP76.0FEB_TATYP281TransactionElectronic Bank Statement
166ERP EHP76.0FEB_TATYP_C301Transaction - Customer AdjustmentElectronic Bank Statement
167ERP EHP76.0FEB_TATYP_T31Transaction TextElectronic Bank Statement
168ERP EHP76.0FEB_TATYP_TC41Transaction Text - Customer AdjustmentElectronic Bank Statement