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
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPCH386A/P Invoice
8OVTG52Tax Definition
9OPOR386Purchase Order
10JDT1124Journal Entry - Rows

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
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

174 tablesERP 6.0 

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