SAP Marketing, Accounting and Pricing Tables
Are you looking for the right table related to SAP Marketing, Accounting and Pricing Tables to query in an ABAP Program, Class, Function Module and OData API?
There are number of standard tables in SAP S/4HANA system. The data of an application is distributed across several database fields. Finding the right table is important, in this post we'll look at list of all the tables in Marketing, Accounting and Pricing (IS-OIL-DS-MAP) module.
Top 10 tables in Marketing, Accounting and Pricing
| Table | Description |
|---|---|
| OICF1_MIGR_REQ | Header Patterns per Run |
| OIC_OIANF | Fee Condition Records |
| A431 | DRC: Sales Area/Material/DRC Region |
| OIC_ANALLVL | Pattern analysis level |
| OICQCNTL | Control Table for F&A Repository |
| OICMT | Metropolitan Indicator - Texts |
| OICQ5 | Formula Condition Data - Formula Terms |
| OIC_CPE_FO_LINK | Relationship Between F&A Formula and CPE Formula |
| A404 | Customer/Material/Plant |
| OICQ7 | Formula Condition Txn Data-Header (enhance CI-Incl.in OICF1) |
List of tables in Marketing, Accounting and Pricing
| Table | Description |
|---|---|
| OICF1_MIGR_REQ | Header Patterns per Run |
| OIC_OIANF | Fee Condition Records |
| A431 | DRC: Sales Area/Material/DRC Region |
| OIC_ANALLVL | Pattern analysis level |
| OICQCNTL | Control Table for F&A Repository |
| OICMT | Metropolitan Indicator - Texts |
| OICQ5 | Formula Condition Data - Formula Terms |
| OIC_CPE_FO_LINK | Relationship Between F&A Formula and CPE Formula |
| A404 | Customer/Material/Plant |
| OICQ7 | Formula Condition Txn Data-Header (enhance CI-Incl.in OICF1) |
| A432 | DRC: Sales Area/Material/DRC Country/DRC Region |
| A422 | DRC: Sales Area/Material/Wide Area Pricing |
| OIC_ANALLVL_T | Description of Level in Pattern Analysis |
| OIC_FORM_ATTRIB | Attributes of Business Context for F&A Formula |
| OICINT_SPL | Special interest table |
| OICF2_MIGR | Results from Pattern Analysis for Structure OICF2 |
| OICINT_CAL | Interest calculation |
| A429 | DRC: Sales Area/Material/State License Fee Zone |
| OICST | State License Fee Zone - Texts |
| OICWT | Wide Area Pricing Zone - Texts |
| OICF1_MIGR | Results from Pattern Analysis for Structure OICF1 |
| A430 | DRC: Sales Area/Material/DRC Country |
| OIC_FO_PER_MIGR | Formula Structure Pattern - Header and Period Pattern |
| OICF3_MIGR | Results from Pattern Analysis for Structure OICF3 |
| OICQ2 | Formula Repository - Formula Term |
| OICQ1 | Formula Repository - Formula Header |
| OICNU | Gross/Net volume UoM relationships |
| OIC_LSMW_PROJ | Used LSMW Project for Data exchange |
| OIC_FO_MIGR_REQ | Formula Patterns per Run |
| OICQ3 | Formula Repository - Formula Term Item |
| OIC_ANALLVL_FLDS | Fields Used in Pattern Analysis Levels |
| A428 | SalesOrg/DistChann/CustGrp/DRCMetrInd/ProdHier |
| A421 | SalesOrg/DistCh/CustGrp/Plant/ProdHier/PricDRC |
| A403 | SalesOrg/DistribCh/SDContractNo/Plant/Material |
| OICGN | Gross/Net Rule Defaulting |
| OIC_KONV | Conditions (Procedure Data) |
| A402 | SalesOrg/DistribCh/SDContractNo/Material |
| OICDC | Differential Reference Code |
| OICQ4 | Formula Condition Data - Formula Header |
| OICQ6 | Formula Condition Data - Formula Term Items |
| OICMI | Metropolitan Indicator |
| OICDT | Differential Reference Code - Texts |
| OICF2_MIGR_REQ | Period Patterns per Run |
| OICF3_MIGR_REQ | Item Patterns per Run |
| A406 | Plant/material |
| OICQ8 | Formula Condition Data - Terms (enhance CI-Include in OICF2) |
| OICPL | Customer price list |
| OICRDT | Report column description |
| OICSDPCDVER | Change document version management |
| OICSL | State License Fee Zone |
| OIC_FO_ITM_MIGR | Formula Structure Pattern - Term Item Pattern |
| A420 | SalesOrg/DistCh/CustGrp/ProdHier/PricDRC |
| OICINT_MASTER | Interest master data |
| OICWA | Wide Area Pricing Zone |
| OICQ9 | Formula Condition Data-Term Items (enhance CI-Incl.in OICF3) |
| OICRD | Second level pricing report output definition table |
| OICQOIL | F&A Oil Table for Repository Default |