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

91 columns | Print definition?ERP 6.0  | KNUMV

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/1CADMC/00000439KONV5KNUMVnvarchar100
2CNVTDMS_05_KONVCollected Header condition Numbers for TDMS_Time-KONV3KNUMVKONV for CNVTDMS_05_*nvarchar100
3CNVTDMS_05_OIANFFill Header for Tbles OIANF, OIAF7, OIAF8, OIAF93KNUMVKONV for CNVTDMS_05_*nvarchar100
4CNVTDMS_05_VBAKFill Header for Sales Document: Header Data3KNUMVBELNR for CNVTDMS_05_*nvarchar100
5CNV_20551_KNUMVTCondition numbers selected for deletion (Domain KNUMV)3KNUMVNumber of the document conditionnvarchar100
6FIEUD_SBINV_ISAFT: Self Billing Invoices ( Line Items)32KNUMVNumber of the document conditionnvarchar100
7FIEUD_SDINV_ISAFT: Invoices from SD module(Item)31KNUMVNumber of the document conditionnvarchar100
8FUDT_VDOCBKPFVerification Document Header110KNUMVNumber of the document conditionnvarchar100
9FUDT_VDOCBKPFHVerification Document Header(History)110KNUMVNumber of the document conditionnvarchar100
10GLPOS_C_CTFI Document: Entry View348KNUMVNumber of the document conditionnvarchar100
11GLPOS_C_DEB_CTGLPOS_C_CT Customer Line Items342KNUMVNumber of the document conditionnvarchar100
12GLPOS_C_GL_CTGLPOS_C_CT G/L Line Items342KNUMVNumber of the document conditionnvarchar100
13GLPOS_C_VEN_CTGLPOS_C_CT Vendor Line Items342KNUMVNumber of the document conditionnvarchar100
14GLPOS_N_CTNew General Ledger: Line Item with Currency Type357KNUMVNumber of the document conditionnvarchar100
15GLPOS_N_GL_CTNew General Ledger: Line Item with Currency Type351KNUMVNumber of the document conditionnvarchar100
16J_3RFGTD_HEADERImport Customs Declaration Header22KNUMVNumber of the Document Conditionnvarchar100
17KOCLU2KNUMVnvarchar100
18KONVConditions (Transaction Data)2KNUMVNumber of the document conditionnvarchar100
19KONVTOCPFGUIDLinking of document condition to CPF2KNUMVNumber of the document conditionnvarchar100
20KONV_SUPPL_LINKLink table for supplementary KONV data2KNUMVNumber of the document conditionnvarchar100
21MEV_D_AD_ITEM_MMPeriod-End Valuation: Accruals Document Item MM19KNUMVNumber of the document conditionnvarchar100
22MEV_D_WL_MMPeriod-end valuation: Worklist - Materials Management Data19KNUMVNumber of the document conditionnvarchar100
23PRCD_CLUST2KNUMVvarbinary160
24ZEIM_VBAKSales Document: Header Data28KNUMVNumber of the document conditionnvarchar100
TOPAccounting Interface
25GLE_FI_ITEM_MODFECS: Modified FI Line Items (Header/Item/Currency Data)17KNUMVNumber of the document conditionnvarchar100
26GLE_FI_ITEM_ORIGECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F)17KNUMVNumber of the document conditionnvarchar100
TOPAdvertising Management
27JHAKIS-M/AM: Order-Publishing-Media (Header Data)19KNUMVNumber of the document conditionnvarchar100
28JHTFKIS-M/AM: Settlement Documents (Billing, Commission) - Header21KNUMVNumber of the document conditionnvarchar100
TOPAgency Business Global Trade
29WBRKAgency business: Header57KNUMVNumber of the document conditionnvarchar100
TOPBilling
30VBRKBilling Document: Header Data10KNUMVNumber of the document conditionnvarchar100
TOPChargeback
31WCOCOFCondition Contract: Document Flow Data2KNUMVNumber of the document conditionnvarchar100
TOPContract Accounts Receivable and Payable
32FKK_JFRK_SHORTHeader Data for IS-M/SD Billing Document - Extracts21KNUMVNumber of the document conditionnvarchar100
33FKK_JLRK_SHORTHeader Data for IS-M/SD Service Settlement - Extracts19KNUMVNumber of the document conditionnvarchar100
TOPCPE in SD
34CPED_KNUMVTOGUIDCPE Caller - Mapping KNUMV and Document Item to GUID2KNUMVNumber of the document conditionnvarchar100
TOPCross-Application Components
35VKONVConditions (Transaction Data)2KNUMVNumber of the document conditionnvarchar100
36VVBAKSales Document: Header Data28KNUMVNumber of the document conditionnvarchar100
TOPData Collection
37S136Index: conditions in document6KNUMVNumber of the document conditionnvarchar100
38S136ES136 - Structural Information7KNUMVNumber of the document conditionnvarchar100
TOPData Retention Tool
39TXW_S_VBRKRetrieve VBRK from archive27KNUMVNumber of the document conditionnvarchar100
TOPExchanges
40OIAF7Formula Condition Txn Data-Header (enhance CI-Incl.in OICF1)2KNUMVNumber of the document conditionnvarchar100
41OIAF8Formula Condition Data - Terms (enhance CI-Incl.in OICF2)2KNUMVNumber of the document conditionnvarchar100
42OIAF9Formula Condition Data-Term Items (enhance CI-Incl.in OICF3)2KNUMVNumber of the document conditionnvarchar100
43OIAFEFee history table10KNUMVNumber of the document conditionnvarchar100
44OIANFFee Condition Records2KNUMVNumber of the document conditionnvarchar100
TOPExternal Services
45ESLHService Package Header Data6KNUMVNumber of the document conditionnvarchar100
TOPFinancial Accounting
46BKPFAccounting Document Header112KNUMVNumber of the document conditionnvarchar100
47KONV_CONV_TRGKONV Conversion Trigger3KNUMVNumber of the document conditionnvarchar100
TOPFreight Processing
48VFKONV(Freight) Conditions2KNUMVNumber of the document conditionnvarchar100
49VFKPShipment Costs: Item Data17KNUMVNumber of the document conditionnvarchar100
50VFSIShipment Costs: Sub-item Data2KNUMVNumber of the document conditionnvarchar100
51VFZPCorrect Original Assignmen of Conditions2KNUMVNumber of the document conditionnvarchar100
TOPIntegration
52FKK_KONV_SHORTPrice Conditions for SD Billing Document - Extracts6KNUMVNumber of the document conditionnvarchar100
53FKK_VBRK_SHORTHeader Data for SD Billing Document - Extracts24KNUMVNumber of the document conditionnvarchar100
TOPInventory Management
54MKPFHeader: Material Document33KNUMVNumber of the document conditionnvarchar100
TOPInvoice Verification
55RBDIFFKOInvoice Verification - Conditions5KNUMVNumber of the document conditionnvarchar100
56RBDRSEGBatch IV: Invoice Document Items77KNUMVNumber of the document conditionnvarchar100
TOPJoint Venture und Production Sharing Accounting
57ARC_IDX_PRArchiving index for JV_PRICING archives3KNUMVNumber of the document conditionnvarchar100
58JVKONVIS-Oil / Joint Venture / Data table for CRP pricing data2KNUMVNumber of the document conditionnvarchar100
TOPLocalization
59J_1IKONVExcise recalculated conditions2KNUMVNumber of the document conditionnvarchar100
60J_3RSCCDHEADERCargo Customs Declaration Header25KNUMVNumber of the Document Conditionnvarchar100
TOPMarketing, Accounting and Pricing
61OICQ7Formula Condition Txn Data-Header (enhance CI-Incl.in OICF1)2KNUMVNumber of the document conditionnvarchar100
62OICQ8Formula Condition Data - Terms (enhance CI-Include in OICF2)2KNUMVNumber of the document conditionnvarchar100
63OICQ9Formula Condition Data-Term Items (enhance CI-Incl.in OICF3)2KNUMVNumber of the document conditionnvarchar100
64OIC_KONVConditions (Procedure Data)2KNUMVNumber of the document conditionnvarchar100
65OIC_OIANFFee Condition Records2KNUMVNumber of the document conditionnvarchar100
TOPPatient Accounting
66NVBRKIS-H: Billing document header data11KNUMVNumber of the document conditionnvarchar100
67NVKONVIS-H: Conditions2KNUMVNumber of the document conditionnvarchar100
TOPPeriodical Sales and Distribution
68AMOKONVKOMPIS-M/SD: Condition Index for Amortization3KNUMVNumber of the document conditionnvarchar100
69JFRKIS-M/SD: Billing - Header Data9KNUMVNumber of the document conditionnvarchar100
70JKAKSales Order Header Data21KNUMVNumber of the document conditionnvarchar100
71JKONVIS-M/SD: Conditions (Transaction Data)2KNUMVNumber of the document conditionnvarchar100
72JLRKIS-M/SD: Settlement Header Data7KNUMVNumber of the document conditionnvarchar100
73JLTP1PKZIS-M/SD: Settlemt Data for Each Postal Sales Indicator (New)8KNUMVNumber of the document conditionnvarchar100
74JVTZAEM2Sales Order Header Data23KNUMVNumber of the document conditionnvarchar100
TOPPricing
75PRCD_CONDPrice Condition - Item - Condition (KONV)2KNUMVPricing Document GUIDvarbinary160
76PRCD_HEADPrice Condition Set (Header)2KNUMVPricing Document GUIDvarbinary160
77PRCD_ITEMPricing Condition Item2KNUMVPricing Document GUIDvarbinary160
TOPProduction and Revenue Accounting
78OIUCM_CONTRACTPRA Contracts19KNUMVNumber of the document conditionnvarchar100
79OIUQ9Formula Condition Data - Formula group items2KNUMVNumber of the document conditionnvarchar100
TOPPurchasing
80EKBEHistory per Purchasing Document37KNUMVNumber of the document conditionnvarchar100
81EKBEHRemoved PO History Records37KNUMVNumber of the document conditionnvarchar100
82EKKIPurchasing Condition Index8KNUMVNumber of the document conditionnvarchar100
83EKKOPurchasing Document Header51KNUMVNumber of the document conditionnvarchar100
TOPRemaining Beverage - Obsolete Objects
84/BEV1/RBVBAKSales Document: Header Data28KNUMVNumber of the document conditionnvarchar100
TOPRevenues and Earnings
85VPKHEADSales Pricing Header Data5KNUMVNumber of the document conditionnvarchar100
TOPSales
86VBAKSales Document: Header Data28KNUMVNumber of the document conditionnvarchar100
TOPShipping
87LIKPSD Document: Delivery Header Data52KNUMVNumber of the document conditionnvarchar100
TOPSimulation
88VSVBAK_CNVersion: Sales document: Header data29KNUMVNumber of the document conditionnvarchar100
TOPVendor Outline Agreements
89MMBSI_PO_SRM_INFDB table for storing additional SRM data related to PO4KNUMVNumber of the document conditionnvarchar100
TOPWarranty Claim Processing
90PNWTYVWarranty Claim Version (PVS Node)14KNUMVNumber of the document conditionnvarchar100
91WTY_COND_ACCOUNTAuxiliary Account Assignment of Conditions2KNUMVNumber of the Document Conditionnvarchar100