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

208 columns | Print definition?ERP 6.0  | HKTID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/ATL/FI_CAMaintain FI or BP indicators4HKTIDID for account detailsnvarchar50
2/ATL/KPFASRCashir system - credit card company18HKTIDID for account detailsnvarchar50
3/SMD/MD_____00CSSID-Tabelle fuer Account ID5HKTIDID for account detailsnvarchar50
4BOE_DOCBoe Document83HKTIDID for account detailsnvarchar50
5BSAD_BAKAccounting: Secondary index for customers (cleared items)168HKTIDID for account detailsnvarchar50
6BSAK_BAKAccounting: Secondary Index for Vendors (Cleared Items)173HKTIDID for account detailsnvarchar50
7BSEGAccounting Document Segment321HKTIDID for account detailsnvarchar50
8BSID_BAKAccounting: Secondary Index for Customers168HKTIDID for account detailsnvarchar50
9BSIK_BAKAccounting: Secondary index for vendors173HKTIDID for account detailsnvarchar50
10CID_DB_INB_TARGTClearing Partner for PEXR200215HKTIDID for account detailsnvarchar50
11CNV_10993_HKTIDRemoved HKTID from Coding Scan based on HBKID3HKTIDID for account detailsnvarchar50
12CNV_20100_SKB1CNV backup copy for SKB115HKTIDID for account detailsnvarchar50
13COPC_ACCOUNTCash Account26HKTIDID for account detailsnvarchar50
14COPC_ACCTCOPC Org and Account Relationship9HKTIDID for account detailsnvarchar50
15COPC_PAYRQ_DTLCOPC: PAYRQ Detail5HKTIDID for account detailsnvarchar50
16COPC_RECON_STATSCOPC_RECON_STATS4HKTIDID for account detailsnvarchar50
17COPC_SEL_CCONSelection for Cash Concentration4HKTIDID for account detailsnvarchar50
18COPC_SET_CCONSettings for Cash Concentration4HKTIDID for account detailsnvarchar50
19EPIC_BACOM_DATBank Communication Program Data5HKTIDID for account detailsnvarchar50
20EPIC_BC_UAEPIC: User Assignment Bank Communication4HKTIDID for account detailsnvarchar50
21EPIC_BRS_EBS_BUFepic: brs ebs line item value date period snap shot5HKTIDID for account detailsnvarchar50
22EPIC_C_BCDBank Communication Details4HKTIDID for account detailsnvarchar50
23EPIC_C_BCSBank Communication Steps4HKTIDID for account detailsnvarchar50
24EPIC_C_BSTBank Statement Format4HKTIDID for account detailsnvarchar50
25EPIC_EBOE_HISTTable of EBoE History6HKTIDID for account detailsnvarchar50
26EPIC_EBR_BALBank Account Balance by Bank Receipt4HKTIDID for account detailsnvarchar50
27EPIC_EBR_DUMMYBank receipt lock table4HKTIDID for account detailsnvarchar50
28EPIC_EBR_HDROBSOLETE!!!4HKTIDID for account detailsnvarchar50
29EPIC_EBR_KEYBank Receipt Key Fields4HKTIDID for account detailsnvarchar50
30EPIC_EBR_REQBank Receipt Request Record4HKTIDID for account detailsnvarchar50
31EPIC_EBR_SEGOBSOLETE!!!4HKTIDID for account detailsnvarchar50
32EPIC_EBR_SEG_REFOBSOLETE!!!4HKTIDID for account detailsnvarchar50
33FUDT_VDOCBSEGVerification Document Item with Additional Info310HKTIDID for account detailsnvarchar50
34FUDT_VDOCBSEGEVVerification Document Item in the Entry View310HKTIDID for account detailsnvarchar50
35FUDT_VDOCBSEGHVerification Document Segment with Additional Info(History)310HKTIDID for account detailsnvarchar50
36GLPOS_C_CTFI Document: Entry View133HKTIDID for account detailsnvarchar50
37GLPOS_C_DEB_CTGLPOS_C_CT Customer Line Items133HKTIDID for account detailsnvarchar50
38GLPOS_C_GL_CTGLPOS_C_CT G/L Line Items133HKTIDID for account detailsnvarchar50
39GLPOS_C_VEN_CTGLPOS_C_CT Vendor Line Items133HKTIDID for account detailsnvarchar50
40GLPOS_N_CTNew General Ledger: Line Item with Currency Type135HKTIDID for account detailsnvarchar50
41GLPOS_N_GL_CTNew General Ledger: Line Item with Currency Type135HKTIDID for account detailsnvarchar50
42T042DAvailable amounts for payment program4HKTIDID for account detailsnvarchar50
43T042IAccount determination for payment program6HKTIDID for account detailsnvarchar50
44T042IYAccount Determination for Payment Programs8HKTIDID for account detailsnvarchar50
45T042VValue date for automatic payments5HKTIDID for account detailsnvarchar50
46T045BExpense/Bank Accounts and Tax Codes for Bill Presentation4HKTIDID for account detailsnvarchar50
47T045DAvailable amounts for bill of exchange presentation4HKTIDID for account detailsnvarchar50
48T045EPresentation to Bank6HKTIDID for account detailsnvarchar50
49T045GBank charges table for bill of exchange presentation4HKTIDID for account detailsnvarchar50
50TFKBOL_BANKID2Boleto: Bank ID Determination Customizing II-payment method5HKTIDID for account detailsnvarchar50
51TFKB_015WInstruction keys6HKTIDID for account detailsnvarchar50
TOPAccounting Interface
52GLE_FI_ITEM_MODFECS: Modified FI Line Items (Header/Item/Currency Data)336HKTIDID for account detailsnvarchar50
53GLE_FI_ITEM_ORIGECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F)336HKTIDID for account detailsnvarchar50
TOPAutomatic Payments
54PAYRQPayment Requests69HKTIDID for account detailsnvarchar50
55T018VAcct Transfer: Determine Receiving Bank's Clearing Account6HKTIDID for account detailsnvarchar50
56T042YAccount Determination for Bank to Bank Payments6HKTIDID for account detailsnvarchar50
TOPBank Accounting
57DFPAYGPayment date: Grouping11HKTIDID for account detailsnvarchar50
58DFPAYVPayment Medium: Selection Variants7HKTIDID for account detailsnvarchar50
TOPBank Customer Accounts
59TBKKIHB4FI Data for Manual Outgoing Payments In-House Bank10HKTIDID for account detailsnvarchar50
60TBKKIHB5Payt Method Determination HQ FI for Payment In-House Bank13HKTIDID for account detailsnvarchar50
TOPBasic Functions
61FEBKOElectronic Bank Statement Header Records48HKTIDID for account detailsnvarchar50
62FEBPIPolling Statement Line Item Information8HKTIDID for account detailsnvarchar50
63SKB1G/L account master (company code)14HKTIDID for account detailsnvarchar50
64SKM1Sample G/L accounts14HKTIDID for account detailsnvarchar50
65T012AAllocation pmnt methods -> Bank trans.6HKTIDID for account detailsnvarchar50
66T012BDescription of trans. types4HKTIDID for account detailsnvarchar50
67T012CTerms for bank transactions4HKTIDID for account detailsnvarchar50
68T028PAssign Search Strings to Bank Statement Transactions4HKTIDID for account detailsnvarchar50
69T028RRepetitive Funds Transfer Types6HKTIDID for account detailsnvarchar50
70T045FBank selection for bill of exchange presentation8HKTIDID for account detailsnvarchar50
71TFBWEPersonal Customizing for Transaction FBWE18HKTIDBank Account for Bill of Exchange Presentationnvarchar50
72TFTE_BSM_CUSTCustomizing: Bank Statement Monitor4HKTIDID for account detailsnvarchar50
TOPBusiness Partner
73VTBSTC1Components of Payment Details for Standing Instruction8HKTIDID for account detailsnvarchar50
TOPCash Desk
74FMSHERLOCKClarification List (Payments to be Clarified)22HKTIDID for account detailsnvarchar50
TOPCollectionsDisbursements
75ITAGCYHBNKHouse Banks for Agencies7HKTIDID for account detailsnvarchar50
76ITAGCYPYMETSETSetting Payment Methods in Agency Collections14HKTIDID for account detailsnvarchar50
77TKKVBAKTBanks for Payment5HKTIDID for account detailsnvarchar50
TOPContract Accounts Receivable and Payable
78DFKKBRLEVYRECLevy Way: Data from Payment Lot for Levy Way report (Brazil)6HKTIDID for account detailsnvarchar50
79DFKKCFPAYRUNClarif. Worklist: Payment Program (Obsolete)15HKTIDID for account detailsnvarchar50
80DFKKCFPAYRUN2Calrification Worklist: Payment Program (New Version)13HKTIDID for account detailsnvarchar50
81DFKKCMKManually Issued Checks Lot: Header Data8HKTIDID for account detailsnvarchar50
82DFKKCMPManually Issued Checks Lot: Item Data9HKTIDID for account detailsnvarchar50
83DFKKCRRepository For Checks6HKTIDID for account detailsnvarchar50
84DFKKCR2PCheck Repository: Additional Payees6HKTIDID for account detailsnvarchar50
85DFKKCRADDCR: Additional Information for Payment Medium6HKTIDID for account detailsnvarchar50
86DFKKCRCASHCR: Cashed Checks Not Yet Entered in Register6HKTIDID for account detailsnvarchar50
87DFKKCRCLTable for Checks To Be Clarified6HKTIDID for account detailsnvarchar50
88DFKKCRCL_DOCSTable for Checks To Be Clarified6HKTIDID for account detailsnvarchar50
89DFKKCRDELCR: Deleted Payment Medium / Basic Data6HKTIDID for account detailsnvarchar50
90DFKKCRDEL2PCR: Deleted Payment Medium / Payee Data6HKTIDID for account detailsnvarchar50
91DFKKCRDELADDCR: Deleted Payment Medium / Additional Data6HKTIDID for account detailsnvarchar50
92DFKKCRDELD2Check Register: Deleted Payment Media/Partial Encashments6HKTIDID for account detailsnvarchar50
93DFKKCRDELESCHCheck Register: Escheatment Data6HKTIDID for account detailsnvarchar50
94DFKKCRDOC2Check Management: Partial Encashments6HKTIDID for account detailsnvarchar50
95DFKKCRESCHCheck Register: Escheatment Data6HKTIDID for account detailsnvarchar50
96DFKKCRESCHCClarification Cases for Manual Escheatment Process6HKTIDID for account detailsnvarchar50
97DFKKCROWNCR: Information on Issued Check Forms4HKTIDID for account detailsnvarchar50
98DFKKPAHPayment Notification4HKTIDID for account detailsnvarchar50
99DFKKPNBKAPrenotification data (latest)20HKTIDID for account detailsnvarchar50
100DFKKPNBKHPrenotification data (history)20HKTIDID for account detailsnvarchar50
101DFKKPOHPayment Order: Header Data6HKTIDID for account detailsnvarchar50
102DFKKRHReturns History31HKTIDID for account detailsnvarchar50
103DFKKRKReturns lot: Header data43HKTIDID for account detailsnvarchar50
104DFKKRPReturns lot: Data for payment48HKTIDID for account detailsnvarchar50
105DFKKZARepayment Request19HKTIDID for account detailsnvarchar50
106DPAYCHKHHeader: Accounting Using Creation of Payment Media6HKTIDID for account detailsnvarchar50
107DPAYCHKH1Supplemental Assignments with Creation of Payment Media6HKTIDID for account detailsnvarchar50
108DPAYCHKNUMCheck Number Lot: Header4HKTIDID for account detailsnvarchar50
109DPAYCHKNUMPCheck Number Lot: Single Numbers4HKTIDID for account detailsnvarchar50
110DPAYCHKPHeader: Accounting Using Creation of Payment Media6HKTIDID for account detailsnvarchar50
111DPAYCHKSETCheck: Settings for Check Creation for House Banks4HKTIDID for account detailsnvarchar50
112DPAYGPayment program - payment group9HKTIDID for account detailsnvarchar50
113DPAYHPayment program - data for payment73HKTIDID for account detailsnvarchar50
114DPAYVPayment program: Variants for payment medium and list8HKTIDID for account detailsnvarchar50
115DPAY_CHEZAGZTF Switzerland: Assignment of POR Number to Document Number8HKTIDID for account detailsnvarchar50
116TFK012Bank clearing accounts5HKTIDID for account detailsnvarchar50
117TFK012AAllocation pmnt methods -> Bank trans.5HKTIDID for account detailsnvarchar50
118TFK012DCVElectronic Bank Statement: Payment Agreements (Brazil)4HKTIDID for account detailsnvarchar50
119TFK042APayment Program: Bank Selection6HKTIDID for account detailsnvarchar50
120TFK042AXLPayment Program: Bank Selection - ID (Values)7HKTIDID for account detailsnvarchar50
121TFK042HOwn Bank Details5HKTIDID for account detailsnvarchar50
122TFK042UPayment Medium: Internal Note to Payee12HKTIDID for account detailsnvarchar50
123TFK042VPayment Program: Determination of Value Date5HKTIDID for account detailsnvarchar50
124TFK045TUser ID for Bank Transactions5HKTIDID for account detailsnvarchar50
125TFKBBOL_DEFLTBoleto: default instruction keys5HKTIDID for account detailsnvarchar50
126TFKBOL_ICODEBoleto: Internal action code for the instruction key5HKTIDID for account detailsnvarchar50
TOPElectronic Bank Statement
127FEBKO_TRANSFERTransferred Bank Statements10HKTIDID for account detailsnvarchar50
128FEB_IMP_POSTPosting Parameters for Electronic Bank Statement4HKTIDID for account detailsnvarchar50
129FEB_IMP_SELOPTSelection Options of Posting Parameters4HKTIDID for account detailsnvarchar50
TOPFinancial Accounting
130/BGLOCS/BNK_DATAHouse bank for print in invoice5HKTIDID for account detailsnvarchar50
131/OPT/VIM_1HEADDocument Header170HKTIDID for account detailsnvarchar50
132BSADAccounting: Secondary Index for Customers (Cleared Items)168HKTIDID for account detailsnvarchar50
133BSAKAccounting: Secondary Index for Vendors (Cleared Items)173HKTIDID for account detailsnvarchar50
134BSIDAccounting: Secondary Index for Customers168HKTIDID for account detailsnvarchar50
135BSIKAccounting: Secondary Index for Vendors173HKTIDID for account detailsnvarchar50
136T046AAssignment:1 Bank Cmmt Acct - diverse Bill of Ex.Return Acts4HKTIDID for account detailsnvarchar50
137T048YCompany Code Data on Attached Payment Mediums7HKTIDID for account detailsnvarchar50
138VBSEGDDocument Segment for Customer Document Parking124HKTIDID for account detailsnvarchar50
139VBSEGKDocument Segment for Vendor Document Parking136HKTIDID for account detailsnvarchar50
TOPFinancial Supply Chain Management
140IHC_PI_INB_TARGTPI: Payment Parameters for Inbound IDOC15HKTIDID for account detailsnvarchar50
TOPFSCM In-House Cash
141IHC_DB_CL_XBSIHC Bank Statement: Determine Sender or Clearing Partner4HKTIDID for account detailsnvarchar50
142IHC_DB_INB_TARGTClearing Partner for PEXR200215HKTIDID for account detailsnvarchar50
TOPFunds Management
143KBLK_USERFields for addtl funds commt, funds precommt etc. hdr data54HKTIDID for account detailsnvarchar50
144TBKCBHouse Bank per Currency5HKTIDID for account detailsnvarchar50
145TBKCRHouse Bank per Super Region and Currency6HKTIDID for account detailsnvarchar50
TOPFunds Management-Specific Postings
146PAYRCAdditional Header Data for Recovery Order28HKTIDID for account detailsnvarchar50
TOPInformation System
147T049APosting Data For Autocash With Lockbox8HKTIDID for account detailsnvarchar50
TOPJoint Venture und Production Sharing Accounting
148T8JVBCC_HBHousebank for cash call direct bill6HKTIDID for account detailsnvarchar50
TOPLoans Management
149TTONFTVDARLTest neue Fima: Grunddaten und VDARL33HKTIDKurzschlüssel für eine Kontenverbindungnvarchar50
150TTONFTVZZBEPPTest neue FIMA: VZZBEPP237HKTIDKurzschlüssel für eine Kontenverbindungnvarchar50
151VDARLLoans19HKTIDID for account detailsnvarchar50
152VDBEPIPosted line items for document header129HKTIDID for account detailsnvarchar50
153VDBEPI_SHADOWShadow Table for VDBEPI (Restrictions)129HKTIDID for account detailsnvarchar50
154VDBEPPFlow Data - Planned Item153HKTIDID for account detailsnvarchar50
155VDBOBEPPBusiness Operation: Entered and Activated Flow Data153HKTIDID for account detailsnvarchar50
156VDORDERBorrower's note loan order data70HKTIDID for account detailsnvarchar50
157VDZVPayment Details for the Loan15HKTIDID for account detailsnvarchar50
158VZFZE_VDBEPPCentral Entry Table for Release Procedure156HKTIDID for account detailsnvarchar50
TOPLocalization
159EPIC_C_BPSOTC_ASEPIC: Bank Payment Service Operation Type Code Assignment4HKTIDID for account detailsnvarchar50
160EPIC_C_HB_COMMElectronic Payment Integration: House Bank Commun. Settings4HKTIDID for account detailsnvarchar50
TOPMaster Data
161T012KHouse Bank Accounts4HKTIDID for account detailsnvarchar50
162T012THouse Bank Account Names5HKTIDID for account detailsnvarchar50
TOPPayment Transactions
163CUP_T012K_ITHouse bank details for CUP/CIG6HKTIDID for account detailsnvarchar50
164FIBL_RPCODEMaster Data for Repetitive Code5HKTIDID for account detailsnvarchar50
165FPRL_ITEMItem Data137HKTIDID for account detailsnvarchar50
166PAYRPayment Medium File4HKTIDID for account detailsnvarchar50
167PCECPrenumbered Checks4HKTIDID for account detailsnvarchar50
168PYORDHPayment order header data9HKTIDID for account detailsnvarchar50
169REGUHSettlement data from payment program48HKTIDID for account detailsnvarchar50
170REGUHHREGUH version before the 'n'th change17HKTIDID for account detailsnvarchar50
171REGUHMPayment Data for Cross-Payment Run Payment Medium12HKTIDID for account detailsnvarchar50
172REGUHOREGUH version before the 'n'th change21HKTIDID for account detailsnvarchar50
173T042YPAccount Determination for HR Payments6HKTIDID for account detailsnvarchar50
174T045TUser ID for bank transactions6HKTIDID for account detailsnvarchar50
175TFIBLHBG1Group of House Bank Accounts: Details5HKTIDID for account detailsnvarchar50
TOPPayments
176DFKKBOHBoleto: Header data7HKTIDID for account detailsnvarchar50
177DFKKBOL_BANKIDBoleto: Bank ID Determination Results4HKTIDID for account detailsnvarchar50
178TFKBOL_BANKIDBoleto: Bank ID Determination Customizing4HKTIDID for account detailsnvarchar50
179TFKBOL_BOLEXTBoleto: Number range for external Boleto4HKTIDID for account detailsnvarchar50
180TFKBOL_BOLXTBoleto: external Boleto number ranges5HKTIDID for account detailsnvarchar50
181TFKBOL_INST_CODEBoleto: Instruction Keys4HKTIDID for account detailsnvarchar50
TOPPayroll
182T5H4YCompany data to contribution computation4HKTIDID for account detailsnvarchar50
183T5H8YTransfer download formates of banks4HKTIDID for account detailsnvarchar50
184T5H8ZBank transfer download log6HKTIDID for account detailsnvarchar50
185T5T1LBank accounts of authorities (tax,insurance)16HKTIDID for account detailsnvarchar50
186T5TA1External transfers60HKTIDID for account detailsnvarchar50
187T5TPS1LBank accounts of authorities (tax,insurance)18HKTIDID for account detailsnvarchar50
188T7BGA1Bank transfer - interface table9HKTIDID for account detailsnvarchar50
189T7ROA1Bank transfer - interface table7HKTIDID for account detailsnvarchar50
190T7SIA6Bank transfer - interface table7HKTIDID for account detailsnvarchar50
191T7SK1LBank accounts of authorities (tax,insurance)19HKTIDID for account detailsnvarchar50
192T7SKA1External transfers60HKTIDID for account detailsnvarchar50
TOPPension Fund Switzerland
193T5CD3House Bank Pension Fund for Non-Recurring Payments9HKTIDID for account detailsnvarchar50
TOPPersonnel Management
194T7HRA1Bank transfer - interface table7HKTIDID for account detailsnvarchar50
TOPReal Estate Localization Czech Republic
195/CEERE/RIZENIPT settings for company code10HKTIDID for account detailsnvarchar50
TOPReal Estate Management
196RFVIAUSZUGTest Data for RE Multicash Statement Data4HKTIDID for account detailsnvarchar50
197RFVIBK01ABank Procedure Test Data - A-Record4HKTIDID for account detailsnvarchar50
198RFVIBK01CBank Procedure Test Data - C-Record4HKTIDID for account detailsnvarchar50
199RFVIBK01EBank Procedure Test Data: E-Record4HKTIDID for account detailsnvarchar50
200RFVIBK01VBank Procedure Test Data - C-Record - File Extension4HKTIDID for account detailsnvarchar50
201RFVIUMSATZTest Data for RE Multicash Sales Data4HKTIDID for account detailsnvarchar50
TOPReal Estate Slovakia
202TIVXCSKHLAVPRTax Payer Data26HKTIDID for account detailsnvarchar50
TOPRental Accounting
203VIRALSRHDStatistics - Returned Debit Memos in RE: Header Data4HKTIDID for account detailsnvarchar50
204VIRALSRITStatistics - Returned Debit Memos in RE: Source Items4HKTIDID for account detailsnvarchar50
TOPThird Party ManagementCOA
205VIMMHBACCHouse Bank Account5HKTIDID for account detailsnvarchar50
TOPTransaction Manager
206REFCCReferences between CO object numbers, currency differences15HKTIDID for account detailsnvarchar50
207VTBZVPayment Details for Transaction15HKTIDID for account detailsnvarchar50
TOPTreasury
208FLQBANK_GRPLiquidity Calculation - Assignemnt of Acct to Query Sequence4HKTIDID for account detailsnvarchar50