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

67 columns | Print definition?ERP 6.0  | BETRH

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/1RA/0SD010COItems for Class SD01 - Raw Data13BETRHAmount in Local Currencydecimal232
2/1RA/0SD012COItems for Class SD01 - Processable13BETRHAmount in Local Currencydecimal232
3/1RA/0SD014COItems for Class SD01 - Processed13BETRHAmount in Local Currencydecimal232
4/1RA/0SD020COItems for Class SD02 - Raw Data13BETRHAmount in Local Currencydecimal232
5/1RA/0SD022COItems for Class SD02 - Processable13BETRHAmount in Local Currencydecimal232
6/1RA/0SD024COItems for Class SD02 - Processed13BETRHAmount in Local Currencydecimal232
7/1RA/0SD030COItems for Class SD03 - Raw Data13BETRHAmount in Local Currencydecimal232
8/1RA/0SD032COItems for Class SD03 - Processable13BETRHAmount in Local Currencydecimal232
9/1RA/0SD034COItems for Class SD03 - Processed13BETRHAmount in Local Currencydecimal232
10DFKKEPRTLog for Inconsistent FI-CA Documents21BETRHAmount In Local Currency With +/- Signsdecimal132
11DFKKFWKORRNCumul. Table for Adjustment and Inverse Postings (New)16BETRHAmount In Local Currency With +/- Signsdecimal132
12DFKK_ACCADJAdjustment Postings when Implementing Acct Assgmt Chars14BETRHAmount In Local Currency With +/- Signsdecimal132
13DFKK_NEWACCADJObsolete: See DFKK_ACCADJ14BETRHAmount In Local Currency With +/- Signsdecimal132
14FARR_D_INVOICEInvoice Entries12BETRHAmount in Local Currencydecimal232
15FARR_D_POSTINGPosting table12BETRHAmount in Local Currencydecimal232
16T043GTolerances for Groups of Customers/Vendors5BETRHMaximum Payment Difference for Expensedecimal72
17T043STolerances for Groups of G/L Accounts5BETRHMaximum Expense Difference on Clearingdecimal72
18T043TFI tolerance groups for employees5BETRHMaximum Payment Difference for Expensedecimal72
TOPBusiness transactions
19DFKKTXINVTax Invoices14BETRHAmount In Local Currency With +/- Signsdecimal132
TOPContract Accounts Receivable and Payable
20DFKKBRPOPNOTBalance reporting: noticed contract account document items11BETRHAmount In Local Currency With +/- Signsdecimal132
21DFKKCIBWFICA: Extraction of Cleared Items16BETRHAmount in Local Currency with +/- Signsdecimal152
22DFKKDEFREV_POSLine Item Table (Event-Based Deferred Revenues)10BETRHAmount In Local Currency With +/- Signsdecimal132
23DFKKFMBGAINFOTax Information for Public-Owned Commercial Operations20BETRHAmount in Local Currencydecimal132
24DFKKFWKORRCumulation Table for Adjustment and Inverse Postings15BETRHAmount In Local Currency With +/- Signsdecimal132
25DFKKIPBW_ITEMInstallment Plan Items for Business Warehouse16BETRHAmount In Local Currency With +/- Signsdecimal132
26DFKKIPBW_ORIGInstallment Plan Original Items for Business Warehouse19BETRHAmount In Local Currency With +/- Signsdecimal132
27DFKKIP_GRPPayment Specification: Header Data41BETRHAmount In Local Currency With +/- Signsdecimal132
28DFKKIP_GRPHPayment Specification: Payment Data (History)43BETRHAmount In Local Currency With +/- Signsdecimal132
29DFKKMOPItems in contract account document41BETRHAmount In Local Currency With +/- Signsdecimal132
30DFKKMOPKItems in contract account document20BETRHAmount In Local Currency With +/- Signsdecimal132
31DFKKOPItems in contract account document41BETRHAmount In Local Currency With +/- Signsdecimal132
32DFKKOPAADistribution Items with Account Assignment5BETRHAmount In Local Currency With +/- Signsdecimal132
33DFKKOPBWOI Extraction17BETRHAmount in Local Currency with +/- Signsdecimal152
34DFKKOPCOLLCollection: Log of Receivables Submitted24BETRHAmount In Local Currency With +/- Signsdecimal132
35DFKKOPKItems in contract account document20BETRHAmount In Local Currency With +/- Signsdecimal132
36DFKKOPK_SHORTOffsetting Items for FI-CA Document - Extracts8BETRHAmount In Local Currency With +/- Signsdecimal132
37DFKKOP_REPOpen Items from FPO445BETRHAmount In Local Currency With +/- Signsdecimal132
38DFKKOP_SHORTPartner Items for FI-CA Document - Extracts12BETRHAmount In Local Currency With +/- Signsdecimal132
39DFKKORDERPOSRequests: Items23BETRHAmount In Local Currency With +/- Signsdecimal132
40DFKKORDERPOS_SRequest Templates: Items22BETRHAmount In Local Currency With +/- Signsdecimal132
41DFKKPPIOpen Items for Promise to Pay, with Amount8BETRHAmount In Local Currency With +/- Signsdecimal132
42DFKKQSRIndividual Records for Withholding Tax Report14BETRHAmount In Local Currency With +/- Signsdecimal132
43DFKKRAPClearing/Reversal History (Line Item Level) < 4.6211BETRHAmount In Local Currency With +/- Signsdecimal132
44DFKKRAPTClearing/Reversal History (Line Item Level)11BETRHAmount In Local Currency With +/- Signsdecimal132
45DFKKREP01Data for Sales Lists (Belgium)10BETRHAmount In Local Currency With +/- Signsdecimal132
46DFKKREP02Data for Sales Lists (Belgium)10BETRHAmount In Local Currency With +/- Signsdecimal132
47DFKKREP03Payment History: Posting Totals for Debit Entries8BETRHAmount In Local Currency With +/- Signsdecimal132
48DFKKREP04Payment History: Open Items at End of Period10BETRHAmount In Local Currency With +/- Signsdecimal132
49DFKKREPTDAdjusted Tax Data (Currently Not Used)10BETRHAmount In Local Currency With +/- Signsdecimal132
50DFKKRESReserve Postings11BETRHAmount In Local Currency With +/- Signsdecimal132
51DFKKREV06Report for Tax on Sales/Purchases (bill. time or triggered)12BETRHAmount In Local Currency With +/- Signsdecimal132
52DFKKREV07Report on Tax on Sales/Purchases (clearing time)13BETRHAmount In Local Currency With +/- Signsdecimal132
53DFKKRPReturns lot: Data for payment7BETRHAmount In Local Currency With +/- Signsdecimal132
54DFKKRP3Returns: Manual Posting Specifications18BETRHAmount In Local Currency With +/- Signsdecimal132
55DFKKRP3HReturns: History for Manual Posting Items14BETRHAmount In Local Currency With +/- Signsdecimal132
56DFKKSUMPosting totals from FI-CA47BETRHAmount In Local Currency With +/- Signsdecimal132
57DFKKZARepayment Request7BETRHAmount In Local Currency With +/- Signsdecimal132
58DFKKZPPayment lot: Data for payment11BETRHAmount In Local Currency With +/- Signsdecimal132
59DFKK_DUEGRIDOI - Reclassifications14BETRHAmount in Local Currency with +/- Signsdecimal152
60DFKK_IPL_ITEMSInstallment Plan Key Date Recording (Original Items)10BETRHAmount In Local Currency With +/- Signsdecimal132
61DFKK_RECLASSOI - Reclassifications12BETRHAmount In Local Currency With +/- Signsdecimal132
62FKKDEFREVTrigger Table for Deferred Revenue Postings7BETRHAmount In Local Currency With +/- Signsdecimal132
63FKKMAREDUCTDunning Reductions11BETRHAmount In Local Currency With +/- Signsdecimal132
TOPContract Billing
64EPPMDEBTOPBELNRDocuments Transferred to PPM10BETRHAmount In Local Currency With +/- Signsdecimal132
TOPFinancial Services Localization
65/GSINS/UPR_FKUPRUPR - Calculation of unearned insurance premium reserve10BETRHAmount In Local Currency With +/- Signsdecimal132
TOPInvoicing
66DEABPSCustomer change table: Logical view of BB amounts36BETRHAmount In Local Currency With +/- Signsdecimal132
67EABPS_CORRSub Budget Billing Plan for Correspondence Print25BETRHAmount In Local Currency With +/- Signsdecimal132