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

95 columns | Print definition?ERP 6.0  | ACNUM_INT

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1BKK_SEPA_LIM_EVEvent Table for Mandate Limits3ACNUM_INTInternal Account Number for Current Accountnvarchar100
2BKK_SEPA_LIM_HISHistory Table for Mandate Limits3ACNUM_INTInternal Account Number for Current Accountnvarchar100
TOPAccount Management
3BKK42_NTCMaster Data for Notice and Allowances3ACNUM_INTInternal Account Number for Current Accountnvarchar100
4BKKITNTCNotice: Payment Item with Notice Lock Period > 04ACNUM_INTInternal Account Number for Current Accountnvarchar100
5BKKNTCNotice: Partial Amount and Full Amount Notice3ACNUM_INTInternal Account Number for Current Accountnvarchar100
6BKKVRSAvailable Balance Series3ACNUM_INTInternal Account Number for Current Accountnvarchar100
7BKK_FA_USEDUtilization of Allowance3ACNUM_INTInternal Account Number for Current Accountnvarchar100
TOPBank Customer Accounts
8BCA_US_BKK44ACurrent account master data: Amount-dependent blocks3ACNUM_INTInternal Account Number for Current Accountnvarchar100
9BCA_US_BKK_TDBCA: Time deposit account data3ACNUM_INTInternal Account Number for Current Accountnvarchar100
10BCA_US_DEA_ESCHEscheat Accounts Data7ACNUM_INTInternal Account Number for Current Accountnvarchar100
11BCA_US_MEM_ITEMSMemo item table5ACNUM_INTInternal Account Number for Current Accountnvarchar100
12BCA_US_OD_PLANAccount master data: Overdraft plan3ACNUM_INTInternal Account Number for Current Accountnvarchar100
13BCA_US_OD_RELAccounts - US specific overdraft relation details3ACNUM_INTInternal Account Number for Current Accountnvarchar100
14BCA_US_OD_TRANSTransaction details for Overdraft protection3ACNUM_INTInternal Account Number for Current Accountnvarchar100
15BKK45_CORRCorrespondence Receiver Administration3ACNUM_INTInternal Account Number for Current Accountnvarchar100
16BKK58Master Data Savings Prod: Fxd-Term Deposit, Installmnt Savgs3ACNUM_INTInternal Account Number for Current Accountnvarchar100
17BKKCORRACCNTAuxiliary Table: Accounts for Adjustments3ACNUM_INTInternal Account Number for Current Accountnvarchar100
18BKKCORRITEMAuxiliary Table: Payment Items for Adjustments5ACNUM_INTInternal Account Number for Current Accountnvarchar100
19BKKSOBCA: Standing Orders3ACNUM_INTInternal Account Number for Current Accountnvarchar100
20BKKSONTPayment Notes of Standing Orders3ACNUM_INTInternal Account Number for Current Accountnvarchar100
21BKKSO_PACKSaving Packages for Standing Order Posting4ACNUM_INTInternal Account Number for Current Accountnvarchar100
22BKKSO_PAORNBCA: Payment Orders of a Standing Order3ACNUM_INTInternal Account Number for Current Accountnvarchar100
23BKKSO_VAR_AMNTStanding Order: Variable Amounts3ACNUM_INTInternal Account Number for Current Accountnvarchar100
24BKKTERMTerm Agreement for Fixed-Term Deposit and Installmt Savings3ACNUM_INTInternal Account Number for Current Accountnvarchar100
25BKKTERMPPRCTerm Agreements in Postprocessing Status3ACNUM_INTInternal Account Number for Current Accountnvarchar100
26BKK_PRENOTEPrenotes3ACNUM_INTInternal Account Number for Current Accountnvarchar100
27BKK_RATEMaster Data for Installment Savings3ACNUM_INTInternal Account Number for Current Accountnvarchar100
28RTP_US_ACCLinking table between a retirement plan and an account4ACNUM_INTRetirement plan: Internal account numbernvarchar150
TOPCondition
29BKK84Bank Account - Individual Condition3ACNUM_INTInternal Account Number for Current Accountnvarchar100
30BKK84TTexts for Bank Account Individual Condition4ACNUM_INTInternal Account Number for Current Accountnvarchar100
31BKK85Bank Account - Individual Condition Position3ACNUM_INTInternal Account Number for Current Accountnvarchar100
32BKK91Value Date Transaction Figures3ACNUM_INTInternal Account Number for Current Accountnvarchar100
33BKK92Account Balancing (Interest and Charges)3ACNUM_INTInternal Account Number for Current Accountnvarchar100
34BKK93Oldest Period for Return Posting3ACNUM_INTInternal Account Number for Current Accountnvarchar100
35BKK94Number of Items3ACNUM_INTInternal Account Number for Current Accountnvarchar100
36BKK95Account Specific Amount Limits for Graduated Conditions3ACNUM_INTInternal Account Number for Current Accountnvarchar100
37BKK96Account Balancing Detail Data3ACNUM_INTInternal Account Number for Current Accountnvarchar100
38BKK97Acct Balancing: Posting Data (Temporary Data)(for Deletion)3ACNUM_INTInternal Account Number for Current Accountnvarchar100
39BKK98Dispatch Expenses Number of Items3ACNUM_INTInternal Account Number for Current Accountnvarchar100
40BKK9APosting and Value Date Balances Carried Forward3ACNUM_INTInternal Account Number for Current Accountnvarchar100
41BKK9ACCInterest Accrual/Deferral (Accounts With No Result)3ACNUM_INTInternal Account Number for Current Accountnvarchar100
42BKK9AICarryforward of Interest Penalty3ACNUM_INTInternal Account Number for Current Accountnvarchar100
43BKK9BValue Date Transaction Figures3ACNUM_INTInternal Account Number for Current Accountnvarchar100
44BKK9CAcct Balancing (Interest and Charges) Enhancement to BKK923ACNUM_INTInternal Account Number for Current Accountnvarchar100
45BKK9IWVariant Condition Fixings3ACNUM_INTInternal Account Number for Current Accountnvarchar100
46BKK9RKOldest Period for Retroactive Condition Changes3ACNUM_INTInternal Account Number for Current Accountnvarchar100
TOPCorrespondence Tool
47DFKKCOHCorrespondence - Correspondence Header66ACNUM_INTInternal Account Number for Current Accountnvarchar100
48DFKKCOHICorrespondence - Correspondence History43ACNUM_INTInternal Account Number for Current Accountnvarchar100
TOPGL transfer
49BKKC10Gen. Ledger: Balances in FI per BCA Cust.Acct. / Bal.Sh.Prep3ACNUM_INTInternal Account Number for Current Accountnvarchar100
50BKKC11Gen. Ledger: BCA Balances per GL Transac. for Bal.Sh.Prep.3ACNUM_INTInternal Account Number for Current Accountnvarchar100
51BKKC12Gen. Ledger: New Balances for Bal. Sheet Preparation7ACNUM_INTInternal Account Number for Current Accountnvarchar100
52BKKC13Gen.Ledger: Changes GL Fields in Account Master4ACNUM_INTInternal Account Number for Current Accountnvarchar100
53BKKC30Gen. Ledger: Log for Transfer Postings (Bal.Sh.Prep., etc.)3ACNUM_INTInternal Account Number for Current Accountnvarchar100
54BKKCNOITGLTable of Items not Updated on the Account7ACNUM_INTInternal Account Number for Current Accountnvarchar100
55BKKCVAAdministration Table Individual Value Adjustment3ACNUM_INTInternal Account Number for Current Accountnvarchar100
TOPInterestCharge Calculation
56BKKM1BCA: Bank Statement Data3ACNUM_INTInternal Account Number for Current Accountnvarchar100
57BKKM2Account Time Periods3ACNUM_INTInternal Account Number for Current Accountnvarchar100
58BKKM2_NPnonperiodic runs for periodic applications3ACNUM_INTInternal Account Number for Current Accountnvarchar100
59BKKM5BCA: Periods of Account Balancing to be Calculated (New)3ACNUM_INTInternal Account Number for Current Accountnvarchar100
60BKKMBALNOTBCA: Balance Notification Data3ACNUM_INTInternal Account Number for Current Accountnvarchar100
61BKKM_TSBank statement time stamp3ACNUM_INTInternal Account Number for Current Accountnvarchar100
TOPMaster Data
62BCA_US_HLD2RELHold Records which have not been released - Dual Control3ACNUM_INTPaying Account Reference-Internalnvarchar100
63BCA_US_HOLDHold Amounts Which Affect Available Balance3ACNUM_INTPaying Account Reference-Internalnvarchar100
64BKK40Current Account Master Data: General3ACNUM_INTInternal Account Number for Current Accountnvarchar100
65BKK40_ENQ_HYDummy Block Table for Accounts for Hierarchy Creation3ACNUM_INTInternal Account Number for Current Accountnvarchar100
66BKK42Current Account Master Data: Operative Data3ACNUM_INTInternal Account Number for Current Accountnvarchar100
67BKK42_CCBCA Account Master Data: Currency Changeover3ACNUM_INTInternal Account Number for Current Accountnvarchar100
68BKK43BCA: Reference Accounts3ACNUM_INTInternal Account Number for Current Accountnvarchar100
69BKK44Current Account Master Data: Blocks3ACNUM_INTInternal Account Number for Current Accountnvarchar100
70BKK45Relationship: Current Account - Business Partner3ACNUM_INTInternal Account Number for Current Accountnvarchar100
71BKK45_HISTORYHistory Table for Table BKK453ACNUM_INTInternal Account Number for Current Accountnvarchar100
72BKK46Current Account Master Data: Customer Appends3ACNUM_INTInternal Account Number for Current Accountnvarchar100
73BKK47BCA: Direct Debit Orders3ACNUM_INTInternal Account Number for Current Accountnvarchar100
74BKK48Control Indicator for Account Balancing3ACNUM_INTInternal Account Number for Current Accountnvarchar100
75BKK50Account balance3ACNUM_INTInternal Account Number for Current Accountnvarchar100
76BKK51Subj.Fin.Pay. Balance3ACNUM_INTInternal Account Number for Current Accountnvarchar100
77BKK54Account Balance of Hierarchies5ACNUM_INTInternal Account Number for Current Accountnvarchar100
78BKK55Subject to Final Payment Balance of Hierarchies5ACNUM_INTInternal Account Number for Current Accountnvarchar100
79BKK56Account Resubmission3ACNUM_INTInternal Account Number for Current Accountnvarchar100
80BKK62_CCValue Date Transaction Figures for Cash Concentration3ACNUM_INTInternal Account Number for Current Accountnvarchar100
81BKK9B_CCValue Date Transaction Figures for Cash Concentration3ACNUM_INTInternal Account Number for Current Accountnvarchar100
82BKKE1Current Account: Limits3ACNUM_INTInternal Account Number for Current Accountnvarchar100
83BKKOVR_ACCNTItem Table: Accounts with Tolerated Overdraft4ACNUM_INTInternal Account Number for Current Accountnvarchar100
TOPPayment Item
84BKKI3Turnover Items Not Posted for Last Bank Statement5ACNUM_INTInternal Account Number for Current Accountnvarchar100
85BKKITPayment Item5ACNUM_INTInternal Account Number for Current Accountnvarchar100
86BKKITAIInfo Items for Interest Penalty at Balancing5ACNUM_INTInternal Account Number for Current Accountnvarchar100
87BKKITENQBlocked Payment Items5ACNUM_INTInternal Account Number for Current Accountnvarchar100
88BKKITRELPayment Item5ACNUM_INTInternal Account Number for Current Accountnvarchar100
89BKKITTMPPlanned Payment Items6ACNUM_INTInternal Account Number for Current Accountnvarchar100
90BKKITTMP_DELPlanned Payment Items - Completed6ACNUM_INTInternal Account Number for Current Accountnvarchar100
TOPPayment Order
91BKKPOITItem in Payment Order6ACNUM_INTInternal Account Number for Current Accountnvarchar100
92BKKPOIT_TMPItems in Planned Payment Order7ACNUM_INTInternal Account Number for Current Accountnvarchar100
93BKKPOIT_TMP_DELItems in Planned Payment Order7ACNUM_INTInternal Account Number for Current Accountnvarchar100
TOPPosition Management
94BKKA4Current Account: Position Types Checks3ACNUM_INTInternal Account Number for Current Accountnvarchar100
95BKKA6Means of Payt Mgmt: Stack Mgmt - Issued/Blocked Checks9ACNUM_INTInternal Account Number for Current Accountnvarchar100