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

Home | ERP 6.0 
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

179 tablesERP 6.0 

Financial Accounting :: Accounts Payable
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0/PTGWFI/F_SMIBDC111BDC Table for Creating DocumentAccounts Payable
2ERP EHP76.0/PTGWFI/F_SMIMSG51Message Code for each transaction that carries the objectAccounts Payable
3ERP EHP76.0/PTGWFI/F_SMIMTR291SMI Process MonitorAccounts Payable
4ERP EHP76.0/PTGWFI/F_SMIRSN121Suspend reason definition tableAccounts Payable
5ERP EHP76.0/PTGWFI/F_SMIRST41Supsension Reson DescriptionAccounts Payable
Financial Accounting :: Accounts Payable :: Basic Functions
ProductVersionTableColumnsIndexesDescriptionModule
6ERP EHP76.0KNBW141Customer master record (withholding tax types) XBasic Functions
7ERP EHP76.0LFAT51Vendor master record (tax groupings)Basic Functions
8ERP EHP76.0LFBW131Vendor master record (withholding tax types) XBasic Functions
9ERP EHP76.0LFSSTN751Sustainability details for VendorBasic Functions
10ERP EHP76.0LFSSTN_CERT61Vendor sustainability certificatesBasic Functions
11ERP EHP76.0QSTRCRIT11Grouping Criteria for List Output for W/holding Tax Report.Basic Functions
12ERP EHP76.0QSTRDSR41Data Source for Reporting Extended Withholding TaxBasic Functions
13ERP EHP76.0QSTRDSRT51Texts for Data Sources for Reporting Ext. Withholding TaxBasic Functions
14ERP EHP76.0QSTRLST51List Configuration for Reporting Extended Withholding TaxBasic Functions
15ERP EHP76.0QSTRLST_CRIT151Group.Criteria for List Config. for Ext.W/holding Tax ReportBasic Functions
16ERP EHP76.0QSTRVAR51Reporting Variants RFWTINT10Basic Functions
17ERP EHP76.0QSTRVARF101Free Selection for Generic Withholding Tax ReportingBasic Functions
18ERP EHP76.0QSTRVART71Report Variants RFWTINT10 TextsBasic Functions
19ERP EHP76.0REGUPW771W/tax information per w/tax type/FI line item in pmnt runBasic Functions
20ERP EHP76.0RF07431Withholding tax in Italy : Modello 770 - additional dataBasic Functions
21ERP EHP76.0T001RWT51Rounding rules for company code, withhold.tax type and curr.Basic Functions
22ERP EHP76.0T001WT151Company code-specific information per withholding tax typeBasic Functions
23ERP EHP76.0T007C91Groupings for tax codesBasic Functions
24ERP EHP76.0T007D51Texts for Tax GroupsBasic Functions
25ERP EHP76.0T046R61Texts for the exceptions from cashed bills/exch.fr.vendorsBasic Functions
26ERP EHP76.0T046S71Exceptions from cashed bills of exchange paid to vendorsBasic Functions
27ERP EHP76.0T059C41Types of Recipient: Vendors per Withholding Tax TypeBasic Functions
28ERP EHP76.0T059D61Types of Recipient: Vendors per Withholding Tax TypeBasic Functions
29ERP EHP76.0T059FB121Formulae for calculating withholding tax (new functions)Basic Functions
30ERP EHP76.0T059FBH71W/tax formulae: HeaderBasic Functions
31ERP EHP76.0T059K51Withholding tax code and processing keyBasic Functions
32ERP EHP76.0T059MINMAX121Minimum and maximum amounts for withholding taxBasic Functions
33ERP EHP76.0T059O51Official withholding tax key - DescriptionsBasic Functions
34ERP EHP76.0T059OT51Text table: Official withholding tax key descriptionsBasic Functions
35ERP EHP76.0T059P361Withholding tax typesBasic Functions
36ERP EHP76.0T059REXT81Reporting key (new withholding tax)Basic Functions
37ERP EHP76.0T059U51Text Table: Withholding Tax TypesBasic Functions
38ERP EHP76.0T059V31Reasons for exemption per withholding tax typeBasic Functions
39ERP EHP76.0T059W51Reasons for exemption per withholding tax typeBasic Functions
40ERP EHP76.0T059Z161Withholding tax code (enhanced functions)Basic Functions
41ERP EHP76.0T059ZT61Text table: Withholding tax codesBasic Functions
42ERP EHP76.0T059ZZINS61Withholding tax code for interest calculationBasic Functions
43ERP EHP76.0T059Z_WITHCD231Entity Table: Additional Official Withholding Tax CodeBasic Functions
44ERP EHP76.0T059Z_WITHCD2T51Text Table: Additional Official Withholding Tax CodeBasic Functions
45ERP EHP76.0TRFKREDEB_SYNC41Synchronization of Customer Master DataBasic Functions
46ERP EHP76.0TVENDCUST_SCGR21Definition of Screen Groups for Customers and VendorsBasic Functions
47ERP EHP76.0TVENDCUST_SCGRT41Texts for Screen Groups for Customer and Vendor Master DataBasic Functions
48ERP EHP76.0WITH_CTNCL21Numbering class for withholding tax certificate numbersBasic Functions
49ERP EHP76.0WITH_CTNCLT41Numbering class text table for withholding tax certificateBasic Functions
50ERP EHP76.0WITH_CTNCO131Withholding tax certificate numbering concept 1Basic Functions
51ERP EHP76.0WITH_CTNCO241Withholding tax certificate numbering concept 2Basic Functions
52ERP EHP76.0WITH_CTNCO351Withholding tax certificate numbering concept 3Basic Functions
53ERP EHP76.0WITH_CTNCOKEY11Withholding tax certificate numbering: ConceptsBasic Functions
54ERP EHP76.0WITH_CTNCOKEYTXT31Texts: Withholding tax certificate numbering conceptsBasic Functions
55ERP EHP76.0WITH_CTNGR21Numbering group for withholding tax certificate numbersBasic Functions
56ERP EHP76.0WITH_CTNGRT41Numbering group text table for withholding tax certificateBasic Functions
57ERP EHP76.0WITH_CTNUM41Allocation of numbering group to numbering classBasic Functions
58ERP EHP76.0WITH_EXCL_STR_HD71Derivation Strategies for Exclusion of Lines in Withhold.TaxBasic Functions
59ERP EHP76.0WITH_EXCL_STR_T71Derivation Strategies for Exclusion (Texts)Basic Functions
60ERP EHP76.0WITH_EXCL_WITHT81Assignment to Withholding Tax TypeBasic Functions
61ERP EHP76.0WITH_ITEM841Witholding tax info per W/tax type and FI line itemBasic Functions
62ERP EHP76.0WITH_ITEM_EXCL91Withholding Tax Info per WTax Type (Exclusion)Basic Functions
63ERP EHP76.0WTAD661Cumulative values for accounts receivableBasic Functions
64ERP EHP76.0WTADP561Cumulative values for accounts receivable (payment proposal)Basic Functions
65ERP EHP76.0WTADPN691Cumulative values for accounts receivable (payment proposal)Basic Functions
66ERP EHP76.0WTAK661Cumulative values for accounts payableBasic Functions
67ERP EHP76.0WTAKP561Cumulative values for accounts payable (payment proposal)Basic Functions
68ERP EHP76.0WTAKPN691Cumulative values for accounts payable (payment proposal)Basic Functions
69ERP EHP76.0WTMIGBK62Withholding Tax Changeover - Selected Company CodesBasic Functions
70ERP EHP76.0WTMIGCOUNT21Current Number Level of Withholding Tax Conversion RunsBasic Functions
71ERP EHP76.0WTMIGGJAHR51Withholding Tax Changeover: Year-Dependent Document Convers.Basic Functions
72ERP EHP76.0WTMIGIF61Withholding Tax Changeover: Commands Executed by ToolBasic Functions
73ERP EHP76.0WTMIGJOB51Withholding Tax Changeover: Last Job StartedBasic Functions
74ERP EHP76.0WTMIGMATCH61Withholding Tax Changeover: Creation of Code -> Type/CodeBasic Functions
75ERP EHP76.0WTMIGMESS151Messages Logged for Withholding Tax ChangeoverBasic Functions
76ERP EHP76.0WTMIGMESSEXC41Withholding Tax Changeover: Alternative Message TypesBasic Functions
77ERP EHP76.0WTMIGRUN51Withholding Tax Conversion RunBasic Functions
78ERP EHP76.0WTMIGSTEP71Steps in Conversion RunBasic Functions
79ERP EHP76.0WTMIGTC91Changeover - Assgt of Classic W/Tax Code to Ext.Type/CodeBasic Functions
80ERP EHP76.0WTMIGTEXT41Text for Withholding Tax Changeover RunBasic Functions
81ERP EHP76.0WTMIGTYP41W/Tax Changeover: Number of W/Tax Types in Master RecordBasic Functions
82ERP EHP76.0WTMIG_PROT191Withholding Tax Changeover: Global Log DataBasic Functions
83ERP EHP76.0WTMIG_PROT2101Withholding Tax Changeover: Detailed Log DataBasic Functions
84ERP EHP76.0WTMIG_TABKEY41Withholding Tax Changeover: Keys of Table Entries AddedBasic Functions
Financial Accounting :: Accounts Payable :: Basic Functions :: Payment Transactions
ProductVersionTableColumnsIndexesDescriptionModule
85ERP EHP76.0BANKA_CUP_IT71Bank Account Number maintenance for CUP/CIG NumberPayment Transactions
86ERP EHP76.0CRACC431Payment Cards: Account Assignments in Card Master RecordPayment Transactions
87ERP EHP76.0CRFILEHD101Payment Card File: HeaderPayment Transactions
88ERP EHP76.0CRFILEPOS292Payment Card File: Individual RecordsPayment Transactions
89ERP EHP76.0CRFILESTAT332Payment Card File: Status Information for Individual RecordsPayment Transactions
90ERP EHP76.0CRNUM641Payment cards: Card master recordPayment Transactions
91ERP EHP76.0CUP_DOC_IT91Document relevant for CUP/CIG NumberPayment Transactions
92ERP EHP76.0CUP_T012K_IT61House bank details for CUP/CIGPayment Transactions
93ERP EHP76.0FEDIWF151FI EDI: Person with signing authorityPayment Transactions
94ERP EHP76.0FIPAY_T042_GTS21SAP GTS Check - Activation in FIPayment Transactions
95ERP EHP76.0FIPAY_TROBJ_GTS61Trigger Objects for Supplementary Information to SAP GTSPayment Transactions
96ERP EHP76.0FPCL_ACC_PARA91Parameter for the PostingPayment Transactions
97ERP EHP76.0FPCL_CO_STATUS11Status of GarnishmentPayment Transactions
98ERP EHP76.0FPCL_CO_STATUST31Description of Garnishment StatusPayment Transactions
99ERP EHP76.0FPCL_DETECT_CO82Garnishments for a Payment DocumentPayment Transactions
100ERP EHP76.0FPCRATTRPROTECT21Attributes may not be changed by the user directPayment Transactions
101ERP EHP76.0FPCR_ACC31Garnishment Register AccountantPayment Transactions
102ERP EHP76.0FPCR_ACCT41Garnishment Register Accountant DescriptionPayment Transactions
103ERP EHP76.0FPCR_ACC_BUKRS31Assignment of Company Code to AccountantPayment Transactions
104ERP EHP76.0FPCR_ACC_GSBER31Assignment Business Area to AccountantPayment Transactions
105ERP EHP76.0FPCR_CESS232Garnishment Register AttributesPayment Transactions
106ERP EHP76.0FPCR_LINK_OBJ173Linked Objects for GarnishmentPayment Transactions
107ERP EHP76.0FPCR_NR_ACC31Accountant Number RangePayment Transactions
108ERP EHP76.0FPCR_RDC_REASON21Reduction ReasonPayment Transactions
109ERP EHP76.0FPCR_RDC_REASONT41Reduction Reason DescriptionPayment Transactions
110ERP EHP76.0FPCR_REDUCTION71Reduction Data for GarnishmentPayment Transactions
111ERP EHP76.0FPCR_SRCH_ATTR31Search Fields for GarnishmentPayment Transactions
112ERP EHP76.0FPCR_USER_ACC31Assignment of User to AccountantPayment Transactions
113ERP EHP76.0FPCR_WAITREASON21Waiting Reason for GarnishmentPayment Transactions
114ERP EHP76.0FPCR_WAITREASONT41Description of Wait ReasonPayment Transactions
115ERP EHP76.0FPIN_T_ADMIN21Administrator - Penalty InterestPayment Transactions
116ERP EHP76.0FPIN_T_ADMINT41Administrator - Penalty Interest: DescriptionPayment Transactions
117ERP EHP76.0FPIN_T_POSTEN252Database for Penalty Interest (Chorus)Payment Transactions
118ERP EHP76.0FPIN_T_REASON21Interruption ReasonPayment Transactions
119ERP EHP76.0FPIN_T_REASONT41Interruption Reason DescriptionPayment Transactions
120ERP EHP76.0FPRL_ACTIONS41Action AttributesPayment Transactions
121ERP EHP76.0FPRL_ACTIONST51Define ActionsPayment Transactions
122ERP EHP76.0FPRL_ACTION_DI41Actions for Approval LevelPayment Transactions
123ERP EHP76.0FPRL_ACTION_TAB41Assign Actions to TabsPayment Transactions
124ERP EHP76.0FPRL_APPLIC21ApplicationPayment Transactions
125ERP EHP76.0FPRL_APPLICT31Application AttributesPayment Transactions
126ERP EHP76.0FPRL_APPLIC_ACT21Activate ApplicationPayment Transactions
127ERP EHP76.0FPRL_CLEAR_DI31Disable Clearing/Reverse for Approval LevelsPayment Transactions
128ERP EHP76.0FPRL_DOC_DI41Disable Document Changes for Approval LevelsPayment Transactions
129ERP EHP76.0FPRL_HEADER121List Header DataPayment Transactions
130ERP EHP76.0FPRL_ITEM1744Item DataPayment Transactions
131ERP EHP76.0FPRL_ITEM_STAT11Item StatusPayment Transactions
132ERP EHP76.0FPRL_ITEM_STATT31Item Status AttributesPayment Transactions
133ERP EHP76.0FPRL_LEVELS41Approval LevelsPayment Transactions
134ERP EHP76.0FPRL_LEVELST51Define Approval LevelsPayment Transactions
135ERP EHP76.0FPRL_LOG163List LogPayment Transactions
136ERP EHP76.0FPRL_TABS51Tab AttributesPayment Transactions
137ERP EHP76.0FPRL_TABST41Define TabsPayment Transactions
138ERP EHP76.0FPRL_TAB_ASSIG31Set Tab PositionsPayment Transactions
139ERP EHP76.0FPRL_WARNINGS163System Warning MessagesPayment Transactions
140ERP EHP76.0OPN_J1311Japanese DME Foreign Payment Accounting Data (Open FI)Payment Transactions
141ERP EHP76.0PNBK193Prenotification: New bank data from master recordsPayment Transactions
142ERP EHP76.0PNHD71Prenotification: Files created in ACH formatPayment Transactions
143ERP EHP76.0PYORDH192Payment order header dataPayment Transactions
144ERP EHP76.0PYORDP133Payment order item dataPayment Transactions
145ERP EHP76.0REGUA81Change of payment proposals: user and timePayment Transactions
146ERP EHP76.0REGUH1762Settlement data from payment programPayment Transactions
147ERP EHP76.0REGUHH371REGUH version before the 'n'th changePayment Transactions
148ERP EHP76.0REGUHO491REGUH version before the 'n'th changePayment Transactions
149ERP EHP76.0REGUPO181Line item status before the 'n'th changePayment Transactions
150ERP EHP76.0REGUS72Acounts blocked by payment proposalPayment Transactions
151ERP EHP76.0REGUS_SEPA91SEPA Mandate Lock: Applications To Be RetrievedPayment Transactions
152ERP EHP76.0REGUV171Control records for the payment programPayment Transactions
153ERP EHP76.0SMFIAP71Spec. FI-SL Data in Monitor (See Schedman_specific_fisl)Payment Transactions
154ERP EHP76.0T005_IT_UIC31UIC CodePayment Transactions
155ERP EHP76.0T005_IT_UICREG41UIC Code based on region and country keyPayment Transactions
156ERP EHP76.0T042C51Technical Settings For The Payment ProgramPayment Transactions
157ERP EHP76.0T042FSL31Last additional selections usedPayment Transactions
158ERP EHP76.0T042JB41Customizing table for Japan Bank MergersPayment Transactions
159ERP EHP76.0T042JB151Customizing table for Japan Bank/Branch MergersPayment Transactions
160ERP EHP76.0T042OFI61Events for MT100 and other DME FormatsPayment Transactions
161ERP EHP76.0T042OFIT31Events for MT100 and other DME FormatsPayment Transactions
162ERP EHP76.0T042R51Name of account holder (ref.specifications on bk.details)Payment Transactions
163ERP EHP76.0T042U101Block Entries for Debit Customers/Credit VendorsPayment Transactions
164ERP EHP76.0T045T71User ID for bank transactionsPayment Transactions
165ERP EHP76.0T077D201Customer account groupsPayment Transactions
166ERP EHP76.0T077K231Vendor account groupsPayment Transactions
167ERP EHP76.0T078D111Trans.-dependent screen selection for cust.masterPayment Transactions
168ERP EHP76.0T078K141Transaction-dependent screen selection for vendor masterPayment Transactions
169ERP EHP76.0T079D41Company code-dependent screen sel.for cust.masterPayment Transactions
170ERP EHP76.0T079K41Company code-dependent screen sel.for vend.masterPayment Transactions
171ERP EHP76.0T079M81Vendor master data screen selection (purch.org.)Payment Transactions
172ERP EHP76.0T110_ACT31Activation for changes in F110 accord. to Israel legislationPayment Transactions
173ERP EHP76.0TCRCOBLFL31Payment Cards: Field ControlPayment Transactions
174ERP EHP76.0TCRIN131Payment Cards: Card TypesPayment Transactions
175ERP EHP76.0TCRINT41Payment Cards: Texts for Card TypesPayment Transactions
176ERP EHP76.0TCRSCODE21Payment Cards: Selection CodePayment Transactions
177ERP EHP76.0TCRSCODET41Payment Cards: Texts for Selection CodePayment Transactions
178ERP EHP76.0TFAGS31Definition of FI clearing rulesPayment Transactions
179ERP EHP76.0TFAGT31Texts on FI clearing rulesPayment Transactions

All references to SAP and SAP logo are trademarks of SAP AG in Germany, EU, USA and other territories.
No warranty is provided to data provided by this site. This website is not affiliated with, maintained, authorized, endorsed or sponsored by the SAP AG Company or any of its affiliates.
About :: Terms :: Privacy