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

110 columns | Print definition?ERP 6.0  | AUGDT

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/BIC/B0000165000PSA for 0FI_AP_4 T90CLNT090 FI-AP: Items Delta22AUGDTnvarchar80
2/BIC/B0000166000PSA for 0FI_AR_4 T90CLNT090 FI-AR Items Delta22AUGDTnvarchar80
3/BIC/B0000168000PSA for 0FI_GL_40 T90CLNT090 G/L Accounts: Items9AUGDTnvarchar80
4/BIC/B0000169000PSA for 0FI_GL_41 T90CLNT090 Documents, Compact9AUGDTnvarchar80
5/BIC/B0000170000PSA for 0FI_GL_4 T90CLNT090 FI-GL Items Delta21AUGDTnvarchar80
6/BIC/B0000172000PSA for 0FI_GL_14 T90CLNT090 Gen. Ledger: Items9AUGDTnvarchar80
7/OPT/VIM_1CLEAR/OPT/VIM_1HEAD Extension with Clearing Documents (BSAK)9AUGDTClearing Datenvarchar80
8/OPT/VIM_2HEADAdditional Fields for Table /OPT/VIM_1HEAD22AUGDTClearing Datenvarchar80
9/OPT/WT_3S_PYMNTSupplier Self Service Payment Information11AUGDTClearing Datenvarchar80
10BSAD_BAKAccounting: Secondary index for customers (cleared items)6AUGDTClearing Datenvarchar80
11BSAK_BAKAccounting: Secondary Index for Vendors (Cleared Items)6AUGDTClearing Datenvarchar80
12BSAS_BAKAccounting: Secondary Index for G/L Accounts (Cleared Items)4AUGDTClearing Datenvarchar80
13BSEGAccounting Document Segment7AUGDTClearing Datenvarchar80
14BSID_BAKAccounting: Secondary Index for Customers6AUGDTClearing Datenvarchar80
15BSIK_BAKAccounting: Secondary index for vendors6AUGDTClearing Datenvarchar80
16BSIS_BAKAccounting: Secondary Index for G/L Accounts4AUGDTClearing Datenvarchar80
17BSSEGAccounting Document Segment7AUGDTClearing Datenvarchar80
18CNVA_PCREA_GRIROGR/IR Items - Results (Level 2)5AUGDTClearing Datenvarchar80
19CNVTDMS_05_BSADHeader table for BSAD8AUGDTDate for TDMSnvarchar80
20CNVTDMS_05_BSAD1Header table for BSAD8AUGDTDate for TDMSnvarchar80
21CNVTDMS_05_BSAKHeader table for BSAK8AUGDTDate for TDMSnvarchar80
22CNVTDMS_05_BSAK1Header table for BSAK8AUGDTDate for TDMSnvarchar80
23CNVTDMS_05_BSASFill Header BSAS - P&G5AUGDTDate for TDMSnvarchar80
24CNVTDMS_05_BSEGFILL Header BSEG5AUGDTDate for TDMSnvarchar80
25CNVTDMS_05_BSEG1FILL Header BSEG5AUGDTDate for TDMSnvarchar80
26CNVTDMS_05_BSISFill Header BSIS - P&G5AUGDTDate for TDMSnvarchar80
27FAGLBSAS_BAKAccounting: Secondary Index for G/L Accounts (Cleared Items)4AUGDTClearing Datenvarchar80
28FAGLBSIS_BAKAccounting: Secondary Index for G/L Accounts4AUGDTClearing Datenvarchar80
29FIAPPLD_INV_DATECleared Overdue Invoice Details (Poland)9AUGDTClearing Datenvarchar80
30FIDOC_EOPDocument extract for EOP check7AUGDTClearing Datenvarchar80
31FIEUD_FIDOC_ISAFT: FI Transaction Document Item65AUGDTClearing Datenvarchar80
32FIWTQAD_CERTWithholding tax certificate details10AUGDTClearing Datenvarchar80
33FIWTQAD_MCLWithholding Tax Monthly Clearing for Qatar10AUGDTClearing Datenvarchar80
34FUDT_VDOCBSEGVerification Document Item with Additional Info7AUGDTClearing Datenvarchar80
35FUDT_VDOCBSEGEVVerification Document Item in the Entry View7AUGDTClearing Datenvarchar80
36FUDT_VDOCBSEGHVerification Document Segment with Additional Info(History)7AUGDTClearing Datenvarchar80
37GLPOS_C_CTFI Document: Entry View50AUGDTClearing Datenvarchar80
38GLPOS_C_DEB_CTGLPOS_C_CT Customer Line Items50AUGDTClearing Datenvarchar80
39GLPOS_C_GL_CTGLPOS_C_CT G/L Line Items50AUGDTClearing Datenvarchar80
40GLPOS_C_VEN_CTGLPOS_C_CT Vendor Line Items50AUGDTClearing Datenvarchar80
41GLPOS_N_CTNew General Ledger: Line Item with Currency Type50AUGDTClearing Datenvarchar80
42GLPOS_N_GL_CTNew General Ledger: Line Item with Currency Type50AUGDTClearing Datenvarchar80
43IDSAU_WT_CERTWithholding tax certificate details10AUGDTClearing Datenvarchar80
44ZARIXFI1Archive Information Structure SAP_FI_DOC_00211AUGDTClearing Datenvarchar80
TOPAccounting Interface
45GLE_FI_ITEM_MODFECS: Modified FI Line Items (Header/Item/Currency Data)287AUGDTClearing Datenvarchar80
46GLE_FI_ITEM_ORIGECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F)287AUGDTClearing Datenvarchar80
TOPAutomatic Payments
47PAYRQPayment Requests137AUGDTClearing Datenvarchar80
TOPBasic Functions
48REGUPWW/tax information per w/tax type/FI line item in pmnt run37AUGDTClearing Datenvarchar80
49WITH_ITEMWitholding tax info per W/tax type and FI line item36AUGDTClearing Datenvarchar80
TOPCash Budget Management
50FMCLHDCash Budget Management: Clearing Information for Posting5AUGDTClearing Datenvarchar80
TOPCollectionsDisbursements
51VVKKCFRECCash Receipts to be Transferred to Claims System23AUGDTClearing datenvarchar80
TOPContract Accounts Receivable and Payable
52DFKKCIBWFICA: Extraction of Cleared Items21AUGDTClearing datenvarchar80
53DFKKCOLI_LOGCollection Agency Information File: Communication Log12AUGDTClearing Date (Batch Input)nvarchar80
54DFKKCOLLP_IP_WBuffer: Collection Agency Info File (Item for Payments)19AUGDTClearing Date (Batch Input)nvarchar80
55DFKKIPBW_ITEMInstallment Plan Items for Business Warehouse18AUGDTClearing datenvarchar80
56DFKKIPBW_ORIGInstallment Plan Original Items for Business Warehouse21AUGDTClearing datenvarchar80
57DFKKMOPItems in contract account document60AUGDTClearing datenvarchar80
58DFKKMOPWItems in contract account document16AUGDTClearing datenvarchar80
59DFKKOPItems in contract account document60AUGDTClearing datenvarchar80
60DFKKOPWItems in contract account document16AUGDTClearing datenvarchar80
61DFKKOP_REPOpen Items from FPO464AUGDTClearing datenvarchar80
62DFKKOP_SHORTPartner Items for FI-CA Document - Extracts15AUGDTClearing datenvarchar80
63DFKKRAPClearing/Reversal History (Line Item Level) < 4.627AUGDTClearing datenvarchar80
64DFKKRAPTClearing/Reversal History (Line Item Level)7AUGDTClearing datenvarchar80
TOPCross-Application Components
65BBSIDAccounting: Secondary index for customers6AUGDTClearing Datenvarchar80
TOPData Retention Tool
66TXW_S_BSEGRetrieve BSEG from archive52AUGDTClearing Datenvarchar80
TOPDown Payment Chains
67/SAPPCE/TDPCIDXCDown Payment Chain: Index for Cleared Items10AUGDTClearing Datenvarchar80
68/SAPPCE/TDPCIDXODown Payment Chain: Index for Open Items10AUGDTClearing Datenvarchar80
TOPFinancial Accounting
69AGKOCleared Accounts7AUGDTClearing Datenvarchar80
70ARIX_BSADFI_DOCUMNT: Line-Oriented Index for Archiving Customer Accts9AUGDTClearing Datenvarchar80
71ARIX_BSAKFI_DOCUMNT: Line-Oriented Indx for Archiving Vendor Accounts9AUGDTClearing Datenvarchar80
72ARIX_BSASFI_DOCUMNT: Line-Oriented Index for Archiving G/L Accounts9AUGDTClearing Datenvarchar80
73BFIT_AFI Subsequent BA/PC Adjustment: G/L Account Items10AUGDTClearing Datenvarchar80
74BFOD_AFI Subsequent BA/PC Adjustment: Customer Items12AUGDTClearing Datenvarchar80
75BFOK_AFI subsequent BA/PC adjustment: Vendor items12AUGDTClearing Datenvarchar80
76BFO_A_RAVersions for Resetting Cleared Items10AUGDTClearing Datenvarchar80
77BSADAccounting: Secondary Index for Customers (Cleared Items)6AUGDTClearing Datenvarchar80
78BSAKAccounting: Secondary Index for Vendors (Cleared Items)6AUGDTClearing Datenvarchar80
79BSASAccounting: Secondary Index for G/L Accounts (Cleared Items)4AUGDTClearing Datenvarchar80
80BSIDAccounting: Secondary Index for Customers6AUGDTClearing Datenvarchar80
81BSIKAccounting: Secondary Index for Vendors6AUGDTClearing Datenvarchar80
82BSISAccounting: Secondary Index for G/L Accounts4AUGDTClearing Datenvarchar80
TOPFunds Management
83FMPU_MIG_OPITEMSMigration of Payment Update: Doc. Bundle to Be Closed8AUGDTClearing Datenvarchar80
TOPFunds Management-Specific Postings
84PAYRCAdditional Header Data for Recovery Order41AUGDTClearing Datenvarchar80
TOPGeneral Ledger Accounting
85BSEG_ADDEntry View of Accounting Document for Additional Ledgers100AUGDTClearing Datenvarchar80
86FAGLBSASAccounting: Secondary Index for G/L Accounts (Cleared Items)4AUGDTClearing Datenvarchar80
87FAGLBSISAccounting: Secondary Index for G/L Accounts4AUGDTClearing Datenvarchar80
88FAGL_BW_LOG_ITEMFI-GL: Log for BW Extraction: Line Items17AUGDTClearing Datenvarchar80
TOPGL Account Posting
89TCJ_WTAX_ITEMSWithholding Tax Items for Cash Journal Document Items45AUGDTClearing Datenvarchar80
TOPInformation System
90DKKOPBalance Audit Trail42AUGDTClearing Datenvarchar80
91DKOKPOpen Item Account Balance Audit Trail12AUGDTClearing Datenvarchar80
92DSKOPBalance Audit Trail47AUGDTClearing Datenvarchar80
TOPInvoicing
93DEABPSCustomer change table: Logical view of BB amounts53AUGDTClearing datenvarchar80
94EABPS_CORRSub Budget Billing Plan for Correspondence Print37AUGDTClearing datenvarchar80
TOPLocal Currency Changeover
95EWUFI_SCAEMU conversion: Table of the clearings to be adjusted9AUGDTClearing Datenvarchar80
TOPLocalization
96J_1AWITHWithholding transaction data32AUGDTClearing Datenvarchar80
97J_1IEWTCHLNTable for Internal and external Challan nos-EWT India.10AUGDTClearing Datenvarchar80
98J_3RFTAX_EXTRDTax Extract Detail Lines12AUGDTClearing Datenvarchar80
99RFITEMAP_NO_ITEMItem wise detail for the Vendor Transactions12AUGDTClearing Datenvarchar80
100RFITEMAR_NO_ITEMItem wise detail for the Customer Transactions12AUGDTClearing Datenvarchar80
101RFITEMGL_NO_ITEMItem wise detail for the GL Account Transactions12AUGDTClearing Datenvarchar80
TOPPayment Transactions
102FPIN_T_POSTENDatabase for Penalty Interest (Chorus)11AUGDTClearing Datenvarchar80
103REGUHSettlement data from payment program113AUGDTClearing Datenvarchar80
104REGUHHREGUH version before the 'n'th change32AUGDTClearing Datenvarchar80
TOPReal Estate Management
105VIAKBSEGDocument Line Item from SCS for Interface133AUGDTClearing Datenvarchar80
106VIMIIPInvoice Items11AUGDTClearing Datenvarchar80
TOPRemaining Beverage - Obsolete Objects
107/BEV3/CH1030BSG1Document Segment CH Event Ledger Part19AUGDTClearing Datenvarchar80
TOPRental Accounting
108VIRALSRHDStatistics - Returned Debit Memos in RE: Header Data13AUGDTClearing Datenvarchar80
TOPTechnical Application Support
109CNV_20425_SCAEMU conversion: Table of the clearings to be adjusted6AUGDTClearing Datenvarchar80
TOPTransaction Manager
110VTBSIZUHedge Allocation22AUGDTClearing Datenvarchar80