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
4OVPM154Outgoing Payments
5OIVL77Whse Journal
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

102 columns | Print definition?ERP 6.0  | IBAN

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/GSINS/INH_EXTDEExternal Transfers (in HCM infotype 0011)68IBANIBAN (International Bank Account Number)nvarchar340
2/OPT/VIM_STG_LIFTable: Staging data - Vendor master for ICC29IBANIBAN (International Bank Account Number)nvarchar340
3/OPT/WT_3S_PYMNTSupplier Self Service Payment Information29IBANIBAN (International Bank Account Number)nvarchar340
4BBP_SUS_STG_BANKStaging Bank table14IBANIBAN (International Bank Account Number)nvarchar340
5BKK_OPD_RCN_ACReconciliation Accounts for Outgoing Payment Dispatcher9IBANInternational Bank Account Numbernvarchar350
6BKK_PXPO_ORDERCollective Payment Order12IBANInternational Bank Account Numbernvarchar350
7FIAPSAD_ORDR_HDOrder Number Header KSA32IBANIBAN (International Bank Account Number)nvarchar340
8P05EIR_ADM_UNITElectronic Illness Reporting: Administrative Unit Data12IBANIBAN (International Bank Account Number)nvarchar420
9P05EIR_PERSOONElectronic Illness Reporting: Natural Person Data11IBANIBAN (International Bank Account Number)nvarchar420
10P2RB_I0125Garnishment payroll Belgium45IBANIBAN (International Bank Account Number)nvarchar340
11P2RF_SARPayroll Results: Garnishment28IBANIBAN (International Bank Account Number)nvarchar340
12P2RG_COURTTypes of Court Order (GB)38IBANIBAN (International Bank Account Number)nvarchar340
13P2RX_BTPayroll Results: Bank Transfers33IBANIBAN (International Bank Account Number)nvarchar340
14P2RX_BT_PERSONPayment-Related Information (Person)35IBANIBAN (International Bank Account Number)nvarchar340
15SEPA_CI_PROCSEPA CI Limits and CI Whitelist5IBANIBAN (International Bank Account Number)nvarchar340
16SEPA_CI_PROC_ENQSEPA CI Limit: Auxilliary Table for ENQUEUE4IBANIBAN (International Bank Account Number)nvarchar340
17SEPA_CI_PROC_HISSEPA CI Limits and CI Whitelist6IBANIBAN (International Bank Account Number)nvarchar340
18T536C_BANKBank Details for Public Sector Employer13IBANIBAN (International Bank Account Number)nvarchar340
19T5D1KKAccount Data from Contribution Rate File6IBANIBAN (International Bank Account Number)nvarchar340
20T77PAYKZBTBank Transfer Table Image (BTKZ)50IBANIBAN (International Bank Account Number)nvarchar340
21VDZNB_SEPAPmnt Postproc.: Storage of SEPA Return Data9IBANIBAN (International Bank Account Number)nvarchar340
22HRP1890DB Table for Infotype 189073IBANIBAN (International Bank Account Number)nvarchar340
TOPAdvertising Management
23JHAISZIS-M/AM: Assignment Table of Advertisers for OPM Order53IBANIBAN (International Bank Account Number)nvarchar340
24JHTFKIS-M/AM: Settlement Documents (Billing, Commission) - Header62IBANIBAN (International Bank Account Number)nvarchar340
25JHWWWTEMP_ORDERIS-M/AM: Temporary Table for Order Data from the Internet57IBANIBAN (International Bank Account Number)nvarchar340
TOPAustria
26PA0136HR Master Record: Infotype 0136 (Garn. Transfer A)48IBANIBAN (International Bank Account Number)nvarchar340
27PA0526HR Master Record: Infotype 0526144IBANIBAN (International Bank Account Number)nvarchar340
28PA0662HR Master Record: Infotype 066233IBANIBAN (International Bank Account Number)nvarchar340
TOPBank
29TIBANIBAN6IBANIBAN (International Bank Account Number)nvarchar340
TOPBank Master Data
30TBCHAIN0Definition bank chains10IBANIBAN (International Bank Account Number)nvarchar340
31TBCHAIN21Bank chains per business partner account (allocation)14IBANIBAN (International Bank Account Number)nvarchar340
TOPBelgium
32PA0125HR Master Record: Infotype 0125 (Garnishment B)52IBANIBAN (International Bank Account Number)nvarchar340
33T5B1SCompanies17IBANIBAN (International Bank Account Number)nvarchar340
34T5B9AInstitutions (B)35IBANIBAN (International Bank Account Number)nvarchar340
TOPBrazil
35PA0736Alimony order for Brazil53IBANIBAN (International Bank Account Number)nvarchar340
TOPChile
36PA3235HR Master Record: Infotype 323543IBANIBAN (International Bank Account Number)nvarchar340
TOPCompany Pension Scheme Germany
37P01CBTTransfer Records for Reimbursement of Contributions CPS28IBANIBAN (International Bank Account Number)nvarchar340
TOPConstruction Industry
38PDBKANConstruction Industry Social Fund Proced: ANMEL Data Records45IBANIBANnvarchar340
TOPContract Accounts Receivable and Payable
39DFKKRHReturns History27IBANIBAN (International Bank Account Number)nvarchar340
40DFKKRPReturns lot: Data for payment46IBANIBAN (International Bank Account Number)nvarchar340
41DFKKZARepayment Request41IBANIBAN (International Bank Account Number)nvarchar340
42DFKKZPPayment lot: Data for payment73IBANIBAN (International Bank Account Number)nvarchar340
43FKK_GPSHADData Extract: Business Partner Data (Faster Access)44IBANIBAN (International Bank Account Number)nvarchar340
44TFK006YIBAN Exceptions for Clarification Proposal2IBANIBAN (International Bank Account Number)nvarchar340
45TFK006YSIBAN Exceptions for Clarification Proposal2IBANIBAN (International Bank Account Number)nvarchar340
46TFK006YTException Accounts for Clarification Proposal3IBANIBAN (International Bank Account Number)nvarchar340
TOPCross-Application Objects in HR
47HRP5584DB Table for Infotype 558422IBANIBAN (International Bank Account Number)nvarchar340
TOPFinancial Accounting
48/OPT/VIM_1HEADDocument Header151IBANIBAN (International Bank Account Number)nvarchar340
TOPFrance
49PA0272Infotype 0272 (Garnishment)49IBANIBAN (International Bank Account Number)nvarchar340
TOPGeneric Contract Accounts Receivable and Payable
50BCA_DIM_BU_PAY_DPayment Details of a Business Partner3IBANIBAN (International Bank Account Number)nvarchar340
TOPGermany
51PA0010HR Master Record: Infotype 0010 (Capital Formation)52IBANIBAN (International Bank Account Number)nvarchar340
52PA0026HR Master Record: Infotype 0026 (Company Insurance)55IBANIBAN (International Bank Account Number)nvarchar340
53PA0116HR Master Record: Infotype 0116 (Garn. Transfer D)46IBANIBAN (International Bank Account Number)nvarchar340
54PA0699Personnel Master Record Infotype 0699137IBANIBAN (International Bank Account Number)nvarchar340
55T5D1HSupplementary Insurance17IBANIBAN (International Bank Account Number)nvarchar340
56T5D1KBranch Offices26IBANIBAN (International Bank Account Number)nvarchar340
TOPGreat Britain
57PA0070HR Master Record: Infotype 0070 (Court Orders - GB)57IBANIBAN (International Bank Account Number)nvarchar340
TOPHong Kong
58T7HK2HProvider Attributes19IBANIBAN (International Bank Account Number)nvarchar340
TOPIntercompany Data Exchange
59TINV_INV_BANKBank Data for Bill or Payment Advice Note10IBANIBAN (International Bank Account Number)nvarchar340
TOPLoans Management
60VDAUSZDrawings on Disbursement58IBANIBAN (International Bank Account Number)nvarchar340
61VDZNB_USAGEPayment Postprocessing: Usage of a Payment Postpr. Activity78IBANIBAN (International Bank Account Number)nvarchar340
62VZFZE_VDAUSZCentral Entry Table for Release Procedure60IBANIBAN (International Bank Account Number)nvarchar340
63VZFZE_VDNBZECentral Entry Table for Release Procedure86IBANIBAN (International Bank Account Number)nvarchar340
TOPMaster Data
64BKK615Data for External Root Accounts Cash Concentration4IBANInternational Bank Account Numbernvarchar350
65VDDISBTEMPDisbursements That Were Not Released32IBANIBAN (International Bank Account Number)nvarchar340
TOPMedia Sales and Distribution
66/NAM/PAY_CHWorkload for Check Payments22IBANIBAN (International Bank Account Number)nvarchar340
TOPMexico
67PA0426Garnishment50IBANIBAN (International Bank Account Number)nvarchar340
TOPMove-InOut
68ECAMIOPRBANKIS-U: Pre-entry Document: Bank Details10IBANIBAN (International Bank Account Number)nvarchar340
TOPNetherlands
69T5N9RRelationship Repr. Legal Person and External Agencies10IBANIBAN (International Bank Account Number)nvarchar420
TOPPayment Transactions
70TFIBLAPARPVAROnline Payment: Variants13IBANIBAN (International Bank Account Number)nvarchar340
TOPPayroll
71T5T1LBank accounts of authorities (tax,insurance)27IBANIBAN (International Bank Account Number)nvarchar340
72T5TA1External transfers64IBANIBAN (International Bank Account Number)nvarchar340
73T7SIA6Bank transfer - interface table14IBANIBAN (International Bank Account Number)nvarchar340
74T7SIBTVirman configuration (WT->Accounts)13IBANIBAN (International Bank Account Number)nvarchar340
75T7SK1LBank accounts of authorities (tax,insurance)29IBANIBAN (International Bank Account Number)nvarchar340
76T7SKA1External transfers64IBANIBAN (International Bank Account Number)nvarchar340
77T7SKEC0009Logovacia tabulka pre EURO konverziu - IT 000962IBANIBAN (International Bank Account Number)nvarchar340
78T7SKEC0011Logovacia tabulka pre EURO konverziu - IT 001162IBANIBAN (International Bank Account Number)nvarchar340
TOPPension fund Netherlands
79T5NH5Werkgeversdata van de aan het pensioenfonds verbonden deeln.17IBANIBAN (International Bank Account Number)nvarchar340
TOPPension Fund Switzerland
80PA3230Personnel Master Record for Infotype 323048IBANIBAN (International Bank Account Number)nvarchar340
TOPPeriodical Sales and Distribution
81JFRKIS-M/SD: Billing - Header Data89IBANIBAN (International Bank Account Number)nvarchar340
82JKWWWTEMP_ORDERIS-M/SD: WWW Temporary Table for Order Data from Internet83IBANIBAN (International Bank Account Number)nvarchar340
83JKWWWTEMP_PAYIS-M: Temporary Internet Table: Payment Data Change9IBANIBAN (International Bank Account Number)nvarchar340
84JNTRECHIS-M/SD: Research72IBANIBAN (International Bank Account Number)nvarchar340
TOPPersonnel Administration
85PA0009HR Master Record: Infotype 0009 (Bank Details)59IBANIBAN (International Bank Account Number)nvarchar340
86PA0011HR Master Record: Infotype 0011 (Ext.Bank Transfers)59IBANIBAN (International Bank Account Number)nvarchar340
87PA0226Személyzeti törzsrekord 0164 infotípus tábla (TB - Magyaro.)86IBANIBAN (International Bank Account Number)nvarchar340
88T521BPayee Keys27IBANIBAN (International Bank Account Number)nvarchar340
TOPPersonnel Management
89T7HRA1Bank transfer - interface table14IBANIBAN (International Bank Account Number)nvarchar340
TOPPublic Sector
90T5D8S_BANKBank Details for Payroll Numbers12IBANIBAN (International Bank Account Number)nvarchar340
TOPPublic Sector Contract Accounts Receivable and Payable
91DFMCA_BRF650BRF: Business Partner Reading16IBANBRF: Expressionnvarchar200
92DFMCA_BRF800BRF: Create/Update Bank Details ID13IBANBRF: Expressionnvarchar200
93DFMCA_BRF890BRF: Business Partner Determination from Form17IBANBRF: Expressionnvarchar200
TOPReceivablesPayment Management
94VDAD_RESULTResult Table for Auto Debit Collection22IBANIBAN (International Bank Account Number)nvarchar340
TOPRecruitment
95PB0009HR Master Record: Infotype 0009 (Bank Details)59IBANIBAN (International Bank Account Number)nvarchar340
TOPReporting
96P05TPRNL_EE_PDPension Return: Personal Data - Pers Level34IBANIBAN (International Bank Account Number)nvarchar340
TOPRussia
97T7RU1BPayee Keys of receiving orders (Russia standard)28IBANIBAN (International Bank Account Number)nvarchar340
TOPSocial Insurance
98T5D31Professionals Pension Organization (PPO)17IBANIBAN of a Professionals Pension Organizationnvarchar340
TOPSpain
99PA0887HR master record, infotype 088751IBANIBAN (International Bank Account Number)nvarchar340
TOPThird Party ManagementCOA
100VIMMHBACCHouse Bank Account10IBANIBAN (International Bank Account Number)nvarchar340
TOPUse AP-MD-BP Components
101BUT0BKBP: Bank Details17IBANIBAN (International Bank Account Number)nvarchar340
TOPVenezuela
102PA0401HRMS-VE: Table for Benefits Infotype (IT401)38IBANIBAN (International Bank Account Number)nvarchar340