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

83 columns | Print definition?ERP 6.0  | STUNR

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/1CADMC/00000439KONV7STUNRnvarchar30
2/BIC/B0000181000PSA for 2LIS_11_VAKON T90CLNT090 Sales Document Cond.81STUNRnvarchar30
3/BIC/B0000186000PSA for 2LIS_13_VDKON T90CLNT090 Billing Docu. Cond.70STUNRnvarchar30
4CNVTDMS_05_FMIFIFill Header for Funds Management9STUNRHeadid für DIMPnvarchar160
5CNVTDMS_05_FMIOIFill Header for Funds Management15STUNRHeadid für DIMPnvarchar160
6KONVConditions (Transaction Data)4STUNRStep numbernvarchar30
7KONVTOCPFGUIDLinking of document condition to CPF4STUNRStep numbernvarchar30
8KONV_SUPPL_LINKLink table for supplementary KONV data5STUNRStep numbernvarchar30
9T683S_VARIANTProcessing Variant Definition of a Procedure (Pricing,...)7STUNRStep numbernvarchar30
10VFPRCC_PRCE2VIEWPricing Elements to View Mapping5STUNRStep numbernvarchar30
TOPAccounting Interface
11GLE_FI_ITEM_MODFECS: Modified FI Line Items (Header/Item/Currency Data)241STUNRStep numbernvarchar30
12GLE_FI_ITEM_ORIGECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F)241STUNRStep numbernvarchar30
TOPActual CostingMaterial Ledger
13MLWEREConversion Table between Purchasing and Material Ledger5STUNRStep numbernvarchar30
TOPActual Payments and Forecast
14COFPDocument Lines (project cash management)32STUNRStep numbernvarchar30
TOPBasic Functions
15FDM1Cash Management & Forecast: Line Items of MM Documents10STUNRStep numbernvarchar30
TOPChargeback
16WCOCOFCondition Contract: Document Flow Data4STUNRStep numbernvarchar30
TOPCondition Technique
17/SAPCND/CTLISTIElements in Determ. Procedure5STUNRLevel Number in a Determ. Procedurenvarchar30
TOPConditions
18T683SPricing Procedure: Data5STUNRStep numbernvarchar30
19T683TPricing Procedures: Texts6STUNRStep numbernvarchar30
TOPCosting
20COERSales Order Value Revenue18STUNRStep numbernvarchar30
TOPCross-Application Components
21VKONVConditions (Transaction Data)4STUNRStep numbernvarchar30
TOPData Collection
22S008Communications Table SD -> CO/Projects14STUNRStep numbernvarchar30
TOPExchanges
23OIAF7Formula Condition Txn Data-Header (enhance CI-Incl.in OICF1)4STUNRStep numbernvarchar30
24OIAF8Formula Condition Data - Terms (enhance CI-Incl.in OICF2)4STUNRStep numbernvarchar30
25OIAF9Formula Condition Data-Term Items (enhance CI-Incl.in OICF3)4STUNRStep numbernvarchar30
26OIANFFee Condition Records4STUNRStep numbernvarchar30
TOPFinancial Accounting
27VBSEGSDocument Segment for Document Parking - G/L Account Database94STUNRStep numbernvarchar30
TOPFree goods
28FGDC_COND_PFree Goods Procedures5STUNRLevel Numbernvarchar30
TOPFreight Processing
29VFKONV(Freight) Conditions4STUNRStep numbernvarchar30
TOPFunds Management
30FCABPFI-CA: Document Item39STUNRStep numbernvarchar30
31FMCFSIFFI-FM: Selected Open Documents from FI Update7STUNRNumber that clearly identifies the line key in databasenvarchar160
32FMCFSIF_TRSelected Open FI Documents (Settlement)7STUNRNumber that clearly identifies the line key in databasenvarchar160
33FMCFSIOFI-FM: Selected Open Commitment Documents13STUNRNumber that clearly identifies the line key in databasenvarchar160
34FMCFSIO_TRFI-FM: Selected Open Commitment Documents13STUNRNumber that clearly identifies the line key in databasenvarchar160
35FMEPFI-FM Line Items34STUNRStep numbernvarchar30
36FMIFIITFI Line Item Table in Funds Management8STUNRNumber that clearly identifies the line key in databasenvarchar160
37FMIOICommitment Documents Funds Management14STUNRNumber that clearly identifies the line key in databasenvarchar160
38FMUDBSEGPPart.Payt Item for Customer Invoice of a Rev. Incr. the Bgt11STUNRNumber that clearly identifies the line key in databasenvarchar160
39FMUDIFIITAdditional Data for FI Line Items f. Revenues Incr. the Bdgt8STUNRNumber that clearly identifies the line key in databasenvarchar160
40FMUDKBLPPItem Revenues Increasing Budget for Forecast of Revenue9STUNRNumber that clearly identifies the line key in databasenvarchar160
TOPFunds Management-Specific Postings
41FMFUNDTRANSYEARAdditional Documents for Funds Transfer to Diff. Years93STUNRStep numbernvarchar30
42PSOSEGSRecurring Request Document Segment, G/L Accounts92STUNRStep numbernvarchar30
TOPIndustry Solution Catch Weight Management
43/CWM/MIG_PROT_EKSaving EKBE and EBKZ with DMBTR = 010STUNRStep numbernvarchar30
TOPIntegration
44FKK_KONV_SHORTPrice Conditions for SD Billing Document - Extracts8STUNRStep numbernvarchar30
TOPInventory Management
45MMINKON_UPCorrections due to Technical Problems with Stock40STUNRStep numbernvarchar30
TOPInvoice Verification
46RBDRSEGBatch IV: Invoice Document Items50STUNRStep numbernvarchar30
47RSEGDocument Item: Incoming Invoice65STUNRStep numbernvarchar30
TOPJoint Venture und Production Sharing Accounting
48JVKONVIS-Oil / Joint Venture / Data table for CRP pricing data4STUNRStep numbernvarchar30
TOPLocalization
49J_1IKONVExcise recalculated conditions4STUNRStep numbernvarchar30
TOPMarketing, Accounting and Pricing
50OICQ7Formula Condition Txn Data-Header (enhance CI-Incl.in OICF1)4STUNRStep numbernvarchar30
51OICQ8Formula Condition Data - Terms (enhance CI-Include in OICF2)4STUNRStep numbernvarchar30
52OICQ9Formula Condition Data-Term Items (enhance CI-Incl.in OICF3)4STUNRStep numbernvarchar30
53OIC_CPE_FO_LINKRelationship Between F&A Formula and CPE Formula5STUNRStep numbernvarchar30
54OIC_FORM_ATTRIBAttributes of Business Context for F&A Formula5STUNRStep numbernvarchar30
55OIC_KONVConditions (Procedure Data)4STUNRStep numbernvarchar30
56OIC_OIANFFee Condition Records4STUNRStep numbernvarchar30
TOPMaster Data
57FMALE_SETNUMFM Document Numbers to be Converted FI Line Item Table FM8STUNRNumber that clearly identifies the line key in databasenvarchar160
TOPMaster Data Distribution
58/ISDFPS/FMSETNUMLast Converted Document Number FI Line Item Table FM8STUNRNumber that clearly identifies the line key in databasenvarchar160
TOPPatient Accounting
59NVKONVIS-H: Conditions4STUNRStep numbernvarchar30
TOPPeriodical Sales and Distribution
60JFREVACCIS-M/SD: Pl.Cir.f.Rev. - Revenue per Liab.Acct + G/L Account7STUNRStep numbernvarchar30
61JKONVIS-M/SD: Conditions (Transaction Data)4STUNRStep numbernvarchar30
62TJY05IS-M/SD: Dyn.Menu Entries for Master Data Maint.for Cond.7STUNRStep numbernvarchar30
63TJY17IS-M/SD: Condition Class for Usage and Application5STUNRStep numbernvarchar30
TOPPricing
64PRCC_COND_PPPricing Procedure Data (T683S)5STUNRLevel Numbernvarchar30
65PRCC_COND_PPTTexts for Line in Pricing Procedure (T683T)6STUNRLevel Numbernvarchar30
66PRCD_CONDPrice Condition - Item - Condition (KONV)4STUNRLevel Numbernvarchar30
TOPProduction and Revenue Accounting
67OIUQ9Formula Condition Data - Formula group items4STUNRStep numbernvarchar30
TOPProfitability Analysis
68CEERRORCO-PA: Incorrect records from SD9STUNRStep numbernvarchar30
TOPPurchasing
69EKBZHistory per Purchasing Document: Delivery Costs4STUNRStep numbernvarchar30
70EKBZHHistory per Purchasing Document: Delivery Costs4STUNRStep numbernvarchar30
71EKBZH_MAHistory Table Delivery Costs at Account Assignment Level4STUNRStep numbernvarchar30
72EKBZ_MADelivery Costs at Account Assignment Level4STUNRStep numbernvarchar30
73EKDFDocument Flow for Logistics Differential Invoice12STUNRStep numbernvarchar30
74EKRSDCERS Procedure: Planned Delivery Costs to be Invoiced5STUNRStep numbernvarchar30
TOPTransaction Manager
75IDCFMFLCALCRLADescription of simplified flow calc.procedure (amounts)3STUNRStep number for Flow Calculationnvarchar30
76IDCFMFLCALCRLNDescription of simplified flow calculation procedure (lines)3STUNRStep number for Flow Calculationnvarchar30
77IDCFMFLCALCRLPDescription of simplified flow calc.procedure (percentages)3STUNRStep number for Flow Calculationnvarchar30
78VTBSIANF**Caution! Do not use. Will be deleted!!26STUNRStep numbernvarchar30
79VTBSIZUHedge Allocation34STUNRStep numbernvarchar30
TOPTransaction Tax Engine
80TTE2C_TAX_MAPMapping between Tax Type and Procedure5STUNRLevel Numbernvarchar30
TOPTreasury
81FLQITEMPO_FCLiquidity Calculation - Forecast Line Items for MM POs6STUNRStep numbernvarchar30
TOPVendor Outline Agreements
82MMBSI_PO_SRM_INFDB table for storing additional SRM data related to PO6STUNRStep numbernvarchar30
TOPWarranty Claim Processing
83WTY_COND_ACCOUNTAuxiliary Account Assignment of Conditions4STUNRStep numbernvarchar30