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

79 columns | Print definition?ERP 6.0  | ZAEHK

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/1CADMC/00000439KONV8ZAEHKnvarchar20
2/BIC/B0000181000PSA for 2LIS_11_VAKON T90CLNT090 Sales Document Cond.84ZAEHKnvarchar20
3/BIC/B0000186000PSA for 2LIS_13_VDKON T90CLNT090 Billing Docu. Cond.81ZAEHKnvarchar20
4KONVConditions (Transaction Data)5ZAEHKCondition counternvarchar20
5KONVTOCPFGUIDLinking of document condition to CPF5ZAEHKCondition counternvarchar20
6KONV_SUPPL_LINKLink table for supplementary KONV data6ZAEHKCondition counternvarchar20
7T682ZAConditions: Access Sequences (Fields)5ZAEHKCondition counternvarchar20
8T683S_VARIANTProcessing Variant Definition of a Procedure (Pricing,...)8ZAEHKCondition counternvarchar20
9T6B2FRebate : Permitted Condition Types/Tables per Group4ZAEHKCondition counternvarchar20
TOPAccounting Interface
10GLE_FI_ITEM_MODFECS: Modified FI Line Items (Header/Item/Currency Data)242ZAEHKCondition counternvarchar20
11GLE_FI_ITEM_ORIGECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F)242ZAEHKCondition counternvarchar20
TOPActual CostingMaterial Ledger
12MLWEREConversion Table between Purchasing and Material Ledger6ZAEHKCondition counternvarchar20
TOPActual Payments and Forecast
13COFPDocument Lines (project cash management)60ZAEHKCondition counternvarchar20
TOPBasic Functions
14FDM1Cash Management & Forecast: Line Items of MM Documents11ZAEHKCondition counternvarchar20
TOPChargeback
15T6B2F_WCBCondition Contract: Allowed Condition Types/Tables per Group4ZAEHKCondition Counternvarchar60
16WCOCOFCondition Contract: Document Flow Data5ZAEHKCondition counternvarchar20
TOPCondition Technique
17/SAPCND/CTLISTIElements in Determ. Procedure6ZAEHKCounter for a Level Number for a Collectionnvarchar30
18/SAPCND/T682ZCondition Access Characteristic5ZAEHKCounter for Field Namenvarchar30
TOPConditions
19T682ZConditions: Access Sequences (Fields)5ZAEHKCondition counternvarchar20
20T683SPricing Procedure: Data6ZAEHKCondition counternvarchar20
21T683TPricing Procedures: Texts7ZAEHKCondition counternvarchar20
TOPCosting
22COERSales Order Value Revenue19ZAEHKCondition counternvarchar20
TOPCross-Application Components
23J_2GLPPRGrouping into counters the pricing condition types4ZAEHKCondition counternvarchar20
24VKONVConditions (Transaction Data)5ZAEHKCondition counternvarchar20
TOPData Collection
25S008Communications Table SD -> CO/Projects15ZAEHKCondition counternvarchar20
TOPExchanges
26OIA12ICONDConditions of OIA12I items5ZAEHKCondition counternvarchar20
27OIAF7Formula Condition Txn Data-Header (enhance CI-Incl.in OICF1)5ZAEHKCondition counternvarchar20
28OIAF8Formula Condition Data - Terms (enhance CI-Incl.in OICF2)5ZAEHKCondition counternvarchar20
29OIAF9Formula Condition Data-Term Items (enhance CI-Incl.in OICF3)5ZAEHKCondition counternvarchar20
30OIANFFee Condition Records5ZAEHKCondition counternvarchar20
TOPExtended Rebate
31BON_ENH_CSEQExtended Rebate: VAKEY Structure3ZAEHKCondition counternvarchar20
32BON_ENH_CSEQ_SExtended Rebate: VAKEY Structure, Shadow Table3ZAEHKCondition counternvarchar20
TOPFinancial Accounting
33VBSEGSDocument Segment for Document Parking - G/L Account Database95ZAEHKCondition counternvarchar20
TOPFree goods
34FGDC_COND_PFree Goods Procedures6ZAEHKFG Condition Counternvarchar30
TOPFreight Processing
35VFKONV(Freight) Conditions5ZAEHKCondition counternvarchar20
TOPFunds Management
36FCABPFI-CA: Document Item40ZAEHKCondition counternvarchar20
37FMEPFI-FM Line Items35ZAEHKCondition counternvarchar20
TOPFunds Management-Specific Postings
38FMFUNDTRANSYEARAdditional Documents for Funds Transfer to Diff. Years94ZAEHKCondition counternvarchar20
39PSOSEGSRecurring Request Document Segment, G/L Accounts93ZAEHKCondition counternvarchar20
TOPIndustry Solution Catch Weight Management
40/CWM/MIG_PROT_EKSaving EKBE and EBKZ with DMBTR = 011ZAEHKCondition counternvarchar20
TOPIntegration
41FKK_KONV_SHORTPrice Conditions for SD Billing Document - Extracts9ZAEHKCondition counternvarchar20
TOPInventory Management
42MMINKON_UPCorrections due to Technical Problems with Stock41ZAEHKCondition counternvarchar20
TOPInvoice Verification
43RBDRSEGBatch IV: Invoice Document Items64ZAEHKCondition counternvarchar20
44RSEGDocument Item: Incoming Invoice66ZAEHKCondition counternvarchar20
TOPJoint Venture und Production Sharing Accounting
45JVKONVIS-Oil / Joint Venture / Data table for CRP pricing data5ZAEHKCondition counternvarchar20
TOPLocalization
46J_1IKONVExcise recalculated conditions5ZAEHKCondition counternvarchar20
TOPMarketing, Accounting and Pricing
47OICQ7Formula Condition Txn Data-Header (enhance CI-Incl.in OICF1)5ZAEHKCondition counternvarchar20
48OICQ8Formula Condition Data - Terms (enhance CI-Include in OICF2)5ZAEHKCondition counternvarchar20
49OICQ9Formula Condition Data-Term Items (enhance CI-Incl.in OICF3)5ZAEHKCondition counternvarchar20
50OIC_CPE_FO_LINKRelationship Between F&A Formula and CPE Formula6ZAEHKCondition counternvarchar20
51OIC_FORM_ATTRIBAttributes of Business Context for F&A Formula6ZAEHKCondition counternvarchar20
52OIC_KONVConditions (Procedure Data)5ZAEHKCondition counternvarchar20
53OIC_OIANFFee Condition Records5ZAEHKCondition counternvarchar20
TOPPatient Accounting
54NKONVIS-H: Direct patient billing pat-related/admin. costs4ZAEHKCondition counternvarchar20
55NVKONVIS-H: Conditions5ZAEHKCondition counternvarchar20
TOPPeriodical Sales and Distribution
56JKONVIS-M/SD: Conditions (Transaction Data)5ZAEHKCondition counternvarchar20
TOPPricing
57PRCC_COND_PPPricing Procedure Data (T683S)6ZAEHKCondition Counternvarchar30
58PRCC_COND_PPTTexts for Line in Pricing Procedure (T683T)7ZAEHKCondition Counternvarchar30
59PRCD_CONDPrice Condition - Item - Condition (KONV)5ZAEHKCondition Counternvarchar30
TOPProduction and Revenue Accounting
60OIUQ9Formula Condition Data - Formula group items5ZAEHKCondition counternvarchar20
TOPProfitability Analysis
61CEERRORCO-PA: Incorrect records from SD10ZAEHKCondition counternvarchar20
TOPPurchasing
62EKBZHistory per Purchasing Document: Delivery Costs5ZAEHKCondition counternvarchar20
63EKBZHHistory per Purchasing Document: Delivery Costs5ZAEHKCondition counternvarchar20
64EKBZH_MAHistory Table Delivery Costs at Account Assignment Level5ZAEHKCondition counternvarchar20
65EKBZ_MADelivery Costs at Account Assignment Level5ZAEHKCondition counternvarchar20
66EKDFDocument Flow for Logistics Differential Invoice13ZAEHKCondition counternvarchar20
67EKRSDCERS Procedure: Planned Delivery Costs to be Invoiced6ZAEHKCondition counternvarchar20
TOPRemaining Beverage - Obsolete Objects
68/DSD/ME_CPT_PANUTemplate for the Application-Defined Document Number3ZAEHKCounter for the Template for the Document Numbernvarchar20
TOPSales
69VAPPE_ASGNAssignment of Predefined Price Element to Sales Doc. Type3ZAEHKCondition counternvarchar20
TOPService Station Retailing
70OIRC_VCDEF_COLFDSSR Pricing - Column definition: Fields5ZAEHKCondition counternvarchar20
71OIRC_VCDEF_FSSR Pricing - List variant/cond. type - field definition6ZAEHKCondition counternvarchar20
72OIRC_VCDEF_F_VALSSR Pricing - List variant/condition type - field values6ZAEHKCondition counternvarchar20
TOPTariffs, Duties and Permits
73OIHLOUsed licenses for orders5ZAEHKCondition counternvarchar20
TOPTransaction Manager
74VTBSIANF**Caution! Do not use. Will be deleted!!27ZAEHKCondition counternvarchar20
75VTBSIZUHedge Allocation35ZAEHKCondition counternvarchar20
TOPTransaction Tax Engine
76TTE2C_TAX_MAPMapping between Tax Type and Procedure6ZAEHKCondition Counternvarchar30
TOPTreasury
77FLQITEMPO_FCLiquidity Calculation - Forecast Line Items for MM POs7ZAEHKCondition counternvarchar20
TOPVendor Outline Agreements
78MMBSI_PO_SRM_INFDB table for storing additional SRM data related to PO7ZAEHKCondition counternvarchar20
TOPWarranty Claim Processing
79WTY_COND_ACCOUNTAuxiliary Account Assignment of Conditions5ZAEHKCondition counternvarchar20