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

168 columns | Print definition?ERP 6.0  | DMBTR

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/BIC/B0000168000PSA for 0FI_GL_40 T90CLNT090 G/L Accounts: Items94DMBTRdecimal150
2/BIC/B0000169000PSA for 0FI_GL_41 T90CLNT090 Documents, Compact94DMBTRdecimal150
3/BIC/B0000172000PSA for 0FI_GL_14 T90CLNT090 Gen. Ledger: Items135DMBTRdecimal150
4/CCEE/CSFI_CLEARDocuments for clearing10DMBTRAmount in Local Currencydecimal132
5BSAD_BAKAccounting: Secondary index for customers (cleared items)24DMBTRAmount in Local Currencydecimal132
6BSAK_BAKAccounting: Secondary Index for Vendors (Cleared Items)24DMBTRAmount in Local Currencydecimal132
7BSAS_BAKAccounting: Secondary Index for G/L Accounts (Cleared Items)21DMBTRAmount in Local Currencydecimal132
8BSEGAccounting Document Segment31DMBTRAmount in Local Currencydecimal132
9BSID_BAKAccounting: Secondary Index for Customers24DMBTRAmount in Local Currencydecimal132
10BSIK_BAKAccounting: Secondary index for vendors24DMBTRAmount in Local Currencydecimal132
11BSIM_BAKSecondary Index, Documents for Material10DMBTRAmount in Local Currencydecimal132
12BSIS_BAKAccounting: Secondary Index for G/L Accounts21DMBTRAmount in Local Currencydecimal132
13BSSEGAccounting Document Segment20DMBTRAmount in Local Currencydecimal132
14CNVA_PCREA_GRIROGR/IR Items - Results (Level 2)19DMBTRAmount in Local Currencydecimal132
15FAGLBSAS_BAKAccounting: Secondary Index for G/L Accounts (Cleared Items)21DMBTRAmount in Local Currencydecimal132
16FAGLBSIS_BAKAccounting: Secondary Index for G/L Accounts21DMBTRAmount in Local Currencydecimal132
17FIAPSAD_ORDR_LTLine Item for Order Number KSA12DMBTRAmount in Local Currencydecimal132
18FIARQAD_CRV_LTCash Receipt Voucher Line item table13DMBTRAmount in Local Currencydecimal132
19FIBKRUD_CMO_ITConsolidated MO ITEMS18DMBTRAmount in Local Currencydecimal132
20FIBKRUD_MEMORDERMemo Order for Banking RU30DMBTRAmount in Local Currencydecimal132
21FIEUD_GOODS_ISAFT-XML:Goods Movement Line Items18DMBTRAmount in Local Currencydecimal132
22FIEUD_MMINV_ISAFT:MM: Item Details for XML Purchase Invoice23DMBTRAmount in Local Currencydecimal132
23FUDT_VDOCBSECLRHAdditional Data for Document Segment: Clearing Information15DMBTRAmount in Local Currencydecimal132
24FUDT_VDOCBSEGVerification Document Item with Additional Info20DMBTRAmount in Local Currencydecimal132
25FUDT_VDOCBSEGEVVerification Document Item in the Entry View20DMBTRAmount in Local Currencydecimal132
26FUDT_VDOCBSEGHVerification Document Segment with Additional Info(History)20DMBTRAmount in Local Currencydecimal132
27FUDT_VDOCBSE_CLRAdditional Data for Document Segment: Clearing Information15DMBTRAmount in Local Currencydecimal132
28IDCN_3RFF4ADJITMAdjustment Document Item11DMBTRSigned value field for adjustment amountdecimal132
29J_1GPUTITIR doc. & L-IR item to PU account correspondence11DMBTRAmount in Local Currencydecimal132
30J_1GVL_WHB210Material Valuation totals per transaction categ. (2nd curr.)15DMBTRamount with signdecimal152
31J_1GVL_WHB211Material valuation prices (2nd curr.)17DMBTRamount with signdecimal152
32J_1GVL_WHB310Material Valuation totals per transaction categ. (3rd curr.)15DMBTRamount with signdecimal152
33J_1GVL_WHB311Material valuation prices (3rd curr.)17DMBTRamount with signdecimal152
34J_1ILOCCLREXIM : Letter of Credit Clearing Documents9DMBTRAmount in Local Currencydecimal132
35J_1UF_CURR_CONVCurrency convertion documents7DMBTRAmount in local currencydecimal132
36J_1UF_INV_REFDocument references to FI Invoice processed items23DMBTRAmount in Local Currencydecimal132
37J_1UF_ORD_IN_TAXOrder data used in tax vouchers and corrections18DMBTRAmount in Local Currencydecimal132
38J_1UF_TAX_POSExtended data of tax document positions27DMBTRAmount in Local Currencydecimal132
39J_1UF_TP_BSEGCORItems of Corrective documents11DMBTRAmount with signdecimal172
40J_1UF_TP_BSEGORIItems of Original documents11DMBTRAmount with signdecimal172
41J_3RF_SURP_PRICEMarket prices for inventory surplus (Russia)5DMBTRAmount in Local Currencydecimal132
42J_3RF_TP_BSEGCORItems of Corrective documents11DMBTRAmount with signdecimal172
43J_3RF_TP_BSEGORIItems of Original documents11DMBTRAmount with signdecimal172
44REGUPProcessed items from payment program32DMBTRAmount in Local Currencydecimal132
45T7AEPBS07Rental Allocation12DMBTRAmount in Local Currencydecimal132
46VIYCEXPITEMExpense Items52DMBTRNet Amount in Local Currencydecimal132
TOPAccounting Interface
47GLE_FI_ITEM_MODFECS: Modified FI Line Items (Header/Item/Currency Data)454DMBTRAmount in Local Currencydecimal132
48GLE_FI_ITEM_ORIGECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F)454DMBTRAmount in Local Currencydecimal132
TOPActual CostingMaterial Ledger
49CKMVFM_BSEG_OUTDisplay of FI Documents, Transaction CKMVFM, SAP Note 91298416DMBTRAmount in Local Currencydecimal132
TOPAutomatic Payments
50PAYRQPayment Requests18DMBTRAmount in Local Currencydecimal132
TOPBalance Sheet Valuation Procedures
51MYSEG_EXTRACTDocument Segment: Material16DMBTRAmount in Local Currencydecimal132
TOPBasic Functions
52BSIWIndex table for customer bills of exchange used16DMBTRAmount in Local Currencydecimal132
53BSIXIndex table for customer bills of exchange used16DMBTRAmount in Local Currencydecimal132
54FLQITEMC1_FCLiquidity Calculation: Forecast from Securities10DMBTRLiquidity Calculation: Amount in Local Currencydecimal152
55GSBLCABusiness area consolidation: deviating records20DMBTRAmount in Local Currencydecimal132
TOPBW Service API
56ROVERCUBE1Transaction Data for Verification Scenarios10DMBTRAmount in Local Currency for Verification Scenariosdecimal132
57ROVERCUBE3Transaction Data for Verification Scenarios (from 4.0B)10DMBTRAmount in Local Currency for Verification Scenariosdecimal132
TOPCash Desk
58FMSHERLOCKClarification List (Payments to be Clarified)16DMBTRAmount in Local Currencydecimal132
TOPContract Accounts Receivable and Payable
59FMRC01_FICAResults List Comparison of FM/FI (FI-CA Documents)9DMBTRFI Net Amount in Company Code Currencydecimal132
TOPCross-Application Components
60BBSIDAccounting: Secondary index for customers24DMBTRAmount in Local Currencydecimal132
TOPData Retention Tool
61TXW_S_BSEGRetrieve BSEG from archive21DMBTRAmount in Local Currencynvarchar160
62TXW_S_MSEGRetrieve MSEG from archive20DMBTRAmount in Local Currencynvarchar160
TOPExchanges
63OIA10Exchange - Netting document item11DMBTRAmount in Local Currencydecimal132
64OIA12IMovement Based Netting document item23DMBTRAmount in local currencydecimal132
TOPFinancial Accounting
65/CCEE/SIFIDDVSpecial Tax Table13DMBTRAmount in local currencydecimal132
66/CCEE/SIFIPE17Temporary import of goods10DMBTRAmount in Local Currencydecimal132
67BFIT_AFI Subsequent BA/PC Adjustment: G/L Account Items15DMBTRAmount in Local Currencydecimal132
68BFIT_A0FI Subseq.BA/PC Adjustmnt: Zero Bal.Postings for Bus.Area9DMBTRAmount in Local Currencydecimal132
69BFOD_AFI Subsequent BA/PC Adjustment: Customer Items18DMBTRAmount in Local Currencydecimal132
70BFOK_AFI subsequent BA/PC adjustment: Vendor items18DMBTRAmount in Local Currencydecimal132
71BSADAccounting: Secondary Index for Customers (Cleared Items)24DMBTRAmount in Local Currencydecimal132
72BSAKAccounting: Secondary Index for Vendors (Cleared Items)24DMBTRAmount in Local Currencydecimal132
73BSASAccounting: Secondary Index for G/L Accounts (Cleared Items)21DMBTRAmount in Local Currencydecimal132
74BSE_CLRAdditional Data for Document Segment: Clearing Information15DMBTRAmount in Local Currencydecimal132
75BSE_CLR_ASGMTDoc. Segment Add. Data: Clearing Info with Acct Assignment15DMBTRAmount in Local Currencydecimal132
76BSIDAccounting: Secondary Index for Customers24DMBTRAmount in Local Currencydecimal132
77BSIKAccounting: Secondary Index for Vendors24DMBTRAmount in Local Currencydecimal132
78BSISAccounting: Secondary Index for G/L Accounts21DMBTRAmount in Local Currencydecimal132
79EBSEGDoc.Segment of Fin.Accntng External Documents15DMBTRAmount in Local Currencydecimal132
80KMZEIFI: Account Assignment Model Item Information12DMBTRAmount in Local Currencydecimal132
81KOMUAccount Assignment Templates for G/L Account Items12DMBTRAmount in Local Currencydecimal132
82PARCTReceipt Log Table10DMBTRAmount in Local Currencydecimal132
83VBSEGADocument Segment for Document Parking - Asset Database12DMBTRAmount in Local Currencydecimal132
84VBSEGDDocument Segment for Customer Document Parking15DMBTRAmount in Local Currencydecimal132
85VBSEGKDocument Segment for Vendor Document Parking15DMBTRAmount in Local Currencydecimal132
86VBSEGSDocument Segment for Document Parking - G/L Account Database13DMBTRAmount in Local Currencydecimal132
TOPFlexible Real Estate Management
87VIAKHO20WEG-Verwaltung: Guthaben/Forderungen Eigentümerabrechnung26DMBTRBetrag geleistete Vorauszahlung bei NKAdecimal132
88VIAKHOWPWEG-Verwaltung: Eigentümerabrechnung Wirtschaftsplan11DMBTRBetrag in Hauswährungdecimal132
89VIXCOTDOCCOA, Distribution of VAT, Documents14DMBTRAmount in Local Currencydecimal132
TOPFunctions for U.S. Federal Government
90FMRES_INSTMTSComplete log on Rescheduling6DMBTRAmount in Local Currencydecimal132
91FMRES_RECV_LISTList of all rescheduled receivables9DMBTRAmount in Local Currencydecimal132
TOPFund Accounting
92FMPPFUNDItems for Partial Payment by Fund Process26DMBTRAmount in Local Currencydecimal132
TOPFunds Management
93FMRC_BSEGReconciliation of Lines from FI9DMBTRAmount in Local Currencydecimal132
94FMRC_FMIFIITReconciliation of Lines from FM7DMBTRAmount in Local Currencydecimal132
TOPFunds Management-Specific Postings
95FMCJIS-PS: Documents in Cash Desk Subsidiary Ledger11DMBTRAmount in Local Currencydecimal152
96FMFUNDTRANSYEARAdditional Documents for Funds Transfer to Diff. Years15DMBTRAmount in Local Currencydecimal132
97PSKW3Amounts for Day-End Closing6DMBTRCalculated Amount in Local Currencydecimal152
98PSOSEGADocument Segment for Assets Document Parking13DMBTRAmount in Local Currencydecimal132
99PSOSEGDDocument Segment: Recurring Request, Customer16DMBTRAmount in Local Currencydecimal132
100PSOSEGKRecurring Request Document Segment, Vendors16DMBTRAmount in Local Currencydecimal132
101PSOSEGSRecurring Request Document Segment, G/L Accounts14DMBTRAmount in Local Currencydecimal132
TOPGeneral Ledger Accounting
102BSEG_ADDEntry View of Accounting Document for Additional Ledgers12DMBTRAmount in local currencydecimal232
103EWUFI_SPLITEMU Implementation: Table of FAGL_SPLINFO* to Be Corrected16DMBTRAmount in Local Currencydecimal132
104FAGLBSASAccounting: Secondary Index for G/L Accounts (Cleared Items)21DMBTRAmount in Local Currencydecimal132
105FAGLBSISAccounting: Secondary Index for G/L Accounts21DMBTRAmount in Local Currencydecimal132
106FAGL_BW_LOG_ITEMFI-GL: Log for BW Extraction: Line Items35DMBTRAmount in Local Currencydecimal132
TOPInformation System
107DKKOPBalance Audit Trail34DMBTRAmount in Local Currencydecimal132
108DKOKPOpen Item Account Balance Audit Trail37DMBTRAmount in Local Currencydecimal132
109DSKOPBalance Audit Trail33DMBTRAmount in Local Currencydecimal132
TOPInformation system
110FMBKABSTIS-PS: Bestände im Kassennebenbuch11DMBTRBetrag in Hauswährungdecimal132
TOPInformation System
111QSTREFI/HR Withholding Tax Report for Spain30DMBTRAmount in Local Currencydecimal132
TOPInventory Management
112ISEGPhysical Inventory Document Items39DMBTRDifference amount in local currencydecimal132
113MSEGDocument Segment: Material27DMBTRAmount in Local Currencydecimal132
114MWXMSEGZMSEG: Interface for Posting of Value27DMBTRAmount in Local Currencydecimal132
115MWZMSEGZMSEG:Interface for Posting of Value27DMBTRAmount in Local Currencydecimal132
TOPInvoice Verification
116BSIMSecondary Index, Documents for Material10DMBTRAmount in Local Currencydecimal132
117RBDRSEGBatch IV: Invoice Document Items15DMBTRAmount in Local Currencydecimal132
118RBEXPersistent Key Figures Header and Item26DMBTRAmount in Local Currencydecimal132
TOPJoint Venture und Production Sharing Accounting
119T8J_POST_ERROR_CDocuments with errors in JV posting (Open Items)26DMBTRAmount in Local Currencydecimal132
TOPLoans Management
120VDZNB_PAYINFOPayment Postprocessing: Payment Inform. for a PPP Activity19DMBTRAmount in account currencydecimal132
TOPLocal Currency Changeover
121EWUFI_SCAEMU conversion: Table of the clearings to be adjusted43DMBTRAmount in Local Currencydecimal132
122EWUFI_SOPEMU conversion: Table for open items total14DMBTRItems/subledger total in first local currencydecimal152
TOPLocalization
123IDCN_ZJFPLBALP&L Balances for Period Account Entry Closing Method13DMBTRAmount in Local Currencydecimal132
124IDEU_VATEU VAT Posting14DMBTRAmount in Local Currencydecimal132
125J_3RFF4CORRManual correspondense for cash flow statement8DMBTRAmount in Local Currencydecimal132
126J_3RFPM_RATE_CLCDownpayments rate calculator for foreign currency - payments9DMBTRAmount in Local Currencydecimal132
127J_3RF_REGINV_DEOutgoing invoice journal transp tab for IBOOK ver 210DMBTRAmount in Local Currencydecimal132
128J_3RF_REGINV_KIncoming invoice journal transp tab for IBOOK10DMBTRAmount in Local Currencydecimal132
129J_3RKKRSAccount correspondence line items21DMBTRAmount in Local Currencydecimal132
130J_3R_INVDIFFOffsetting inventory differences of goods10DMBTRDifference amount in local currencydecimal132
131RFIDPTAAVPro-Rata Asset Acquisition Value10DMBTRAmount in Local Currencydecimal132
TOPMaintenance Orders
132AUFMGoods movements for order17DMBTRAmount in Local Currencydecimal132
TOPMaterials Management
133J_1GVL_WHB010Material Valuation totals per transaction category15DMBTRamount with signdecimal152
134J_1GVL_WHB011Material valuation prices17DMBTRamount with signdecimal152
TOPPatient Accounting
135NBRKAZIS-H: Assignmt of downpayment/copayment (FI) to billDoc(SD)15DMBTRAmount in Local Currencydecimal132
136NFALACPIS-H: Case Accrual per Day5DMBTRAmount in Local Currencydecimal132
TOPPayment Transactions
137FPIN_T_POSTENDatabase for Penalty Interest (Chorus)13DMBTRAmount in Local Currencydecimal132
138REGUP_COREProcessed Items from Payment Program16DMBTRAmount in local currencydecimal232
TOPPurchasing
139EKBEHistory per Purchasing Document14DMBTRAmount in Local Currencydecimal132
140EKBEHRemoved PO History Records14DMBTRAmount in Local Currencydecimal132
141EKBEH_MARemoved PO History Records at Account Assignment Level20DMBTRAmount in Local Currencydecimal132
142EKBE_MAHistory of Purchasing Document at Account Assignment Level20DMBTRAmount in Local Currencydecimal132
143EKBE_SRV_SUMTotals History for SRV Documents11DMBTRAmount in Local Currencydecimal132
144EKBZHistory per Purchasing Document: Delivery Costs13DMBTRAmount in Local Currencydecimal132
145EKBZHHistory per Purchasing Document: Delivery Costs13DMBTRAmount in Local Currencydecimal132
146EKBZH_MAHistory Table Delivery Costs at Account Assignment Level18DMBTRAmount in Local Currencydecimal132
147EKBZ_MADelivery Costs at Account Assignment Level18DMBTRAmount in Local Currencydecimal132
TOPReal Estate Localization Czech Republic
148/CEERE/BSEGProperty tax: booked FI items8DMBTRAmount in Local Currencydecimal132
TOPReal Estate Management
149VIAK14RA credit memo/receivable:now only used as structure!25DMBTRAmount of advance payments made for SCSdecimal132
150VIAK20RA credit memo/receivable (incid.exp.sttlmnt created)25DMBTRAmount of advance payments made for SCSdecimal132
151VIAKBSEGDocument Line Item from SCS for Interface34DMBTRAmount in Local Currency for Tax Distributiondecimal132
152VIMIIHInvoice Header19DMBTRAmount in Local Currencydecimal132
TOPRemaining Beverage - Obsolete Objects
153/BEV3/CH1030BSG1Document Segment CH Event Ledger Part122DMBTRAmount in Local Currencydecimal132
TOPRepetitive Manufacturing
154COMPMOVEGoods Movement of Components174DMBTRAmount in Local Currencydecimal132
TOPRevenue recognition
155VBREVERevenue Recognition: Revenue Recognition Lines41DMBTRAmount in Local Currencydecimal132
156VBREVKRevenue Recognition: Control Lines28DMBTRAmount in Local Currencydecimal132
157VBREVRRevenue Recognition: Reference Document Lines17DMBTRAmount in Local Currencydecimal132
TOPTechnical Application Support
158CNV_20425_SCAEMU conversion: Table of the clearings to be adjusted38DMBTRAmount in Local Currencydecimal132
159CNV_20425_SOPEMU conversion: Table for open items total13DMBTRItems/subledger total in first local currencydecimal152
TOPTreasury
160FLQITEMBSLiquidity Calculation - Line Items for Bank Statement Docs17DMBTRLiquidity Calculation: Amount in Local Currencydecimal152
161FLQITEMD1_FCLiquidity Calculation: Forecast Line Items from Loans13DMBTRLiquidity Calculation: Amount in Local Currencydecimal152
162FLQITEMFILiquidity Calculation - Line Items for Other FI Documents15DMBTRLiquidity Calculation: Amount in Local Currencydecimal152
163FLQITEMFI_TPLiquidity Calculation: Actual Line Items at Top Level17DMBTRLiquidity Calculation: Amount in Local Currencydecimal152
164FLQITEMMALiquidity Calculation - Line Items for Manual Transfers11DMBTRLiquidity Calculation: Amount in Local Currencydecimal152
165FLQITEMPR_FCLiquidity Calc. Forecast - Line Items, Purchase Requisitions12DMBTRLiquidity Calculation: Amount in Local Currencydecimal152
166FLQITEMT1_FCLiquidity Calculation: Forecast Line Items from TR Trans.14DMBTRLiquidity Calculation: Amount in Local Currencydecimal152
167FLQSUMLiquidity Calculation - Totals Records11DMBTRLiquidity Calculation: Amount in Local Currencydecimal152
168FLQSUM_TPLiquidity Calculation: Totals Records at Top Level11DMBTRLiquidity Calculation: Amount in Local Currencydecimal152