SAP Marketing Retail Network Tables

Are you looking for the right table related to SAP Marketing Retail Network 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 Retail Network (IS-OIL-DS-MRN) module.

Top 10 tables in Marketing Retail Network

TableDescription
OIFPBLIndex to point at Business Location
OIFXOLPermissible object links (IS-Oil MRN)
OIFSCTCAPTSSR BASE: screen configuration tool - caption settings
S410SIS: Business Location Statistics via 'Ship-to' (IS-Oil MR
OIFBRF2Bus. par. roles - permissible tech. categories (IS-Oil MRN)
S410ES410 - Structural Information
OIFOT001WObject links - CA Plant (IS-Oil MRN)
OIFSCTDSDEFC_CTCustomer Data Section Customizing -Screen Configuration Tool
OIFSCTDSDEFSData Section Definitions - Screen Configuration Tool
OIFOPROJObject links - PS project or project item (IS-Oil MRN)

List of tables in Marketing Retail Network

TableDescription
OIFPBLIndex to point at Business Location
OIFXOLPermissible object links (IS-Oil MRN)
OIFSCTCAPTSSR BASE: screen configuration tool - caption settings
S410SIS: Business Location Statistics via 'Ship-to' (IS-Oil MR
OIFBRF2Bus. par. roles - permissible tech. categories (IS-Oil MRN)
S410ES410 - Structural Information
OIFOT001WObject links - CA Plant (IS-Oil MRN)
OIFSCTDSDEFC_CTCustomer Data Section Customizing -Screen Configuration Tool
OIFSCTDSDEFSData Section Definitions - Screen Configuration Tool
OIFOPROJObject links - PS project or project item (IS-Oil MRN)
OIFSCTSNDEFSTScreen Definition Texts - Screen Configuration Tool
OIFAAMCSASubscreen assignments (IS-Oil MRN APPEND maint. concept)
OIFCHRS2SRetail Network Contract service hours type description
OIFBRT1TBusiness partner roles - tech. category text (IS-Oil MRN)
OIFCHRS2Retail Network Contract service hours type
OIFBBP1Business partner role assignments (IS-Oil MRN)
OIFDD1Delivery point info for bulk delivery preplannning
OIFSMCADDRLink Table Between OIFSPBL and ADRC for Matchcode
OIFSCTFDCONFCField Selection Customizing - Screen Configuration Tool
OIFOT001LObject links - CA storage location (IS-Oil MRN)
OIFBRT1Business partner roles - technical category (IS-Oil MRN)
OIFSCTCAPTTSSR BASE: screen configuration tool - caption texts
OIFSCTSNCONFCScreen Configuration Customizing - Screen Configuration Tool
OIFXSTTObject status table texts (IS-Oil MRN)
OIFDTT1Tank type table - bulk delivery planning
OIFBPBLTLocation type - permissible partner roles (IS-Oil MRN)
OIFOANLAObject links - FI-AA asset master (IS-Oil MRN)
OIFOLD2SPA/GPA parameters supported for link dialog
OIFSCTFDDEFSField Definitions - Screen Configuration Tool
OIFXELMRN design element (IS-Oil MRN)
OIFSCTAPPSNScreen configur. tool - relevant screens per application
OIFSCTDSDEFSTData Section Definition Texts - Screen Configuration Tool
OIFSCTDSDEFC_CCustomer Data Section Customizing -Screen Configuration Tool
OIFXBRD2Fields supp. as SPA/GPA parameters for partner link dialog
OIFOCOASObject links - CO order (IS-Oil MRN)
OIFDD2SBulk delivery preplanning version description
OIFOPBLTLocation type - permissible object links (IS-Oil MRN)
OIFOLD1TLink dialog descriptive text (IS-Oil MRN)
OIFORACTIVActivation of Oil-Retail Integration Components
OIFOLD1Link dialogs supported for object link type (IS-Oil MRN)
OIFSCTFDDEFSTField Definition Texts - Screen Configuration Tool
OIFXOLTPermissible object links (IS-Oil MRN) - descr. texts
OIFDD2Bulk delivery preplanning version
OIFXELTMRN design element descriptive texts (IS-Oil MRN)
OIFXBPTABPermissible DDIC tables for technical categories
OIFORCOPAOperating Concern fields suppressed for ALE transfer
OIFSCTSNCONFSScreen Configuration Defaults - Screen Configuration Tool
OIFDDM1Del. point/material info for bulk delivery planning
OIFSCTSNDEFCScreen Definition Customizing - Screen Configuration Tool
OIFOIFLOObject links - PM functional location (IS-Oil MRN)
OIFDDM3Del. point/material/meter (bulk delivery planning)
OIFXAMCCSAMC possible general data screens (IS-Oil MRN APPEND maint.)
OIFSCTSNDEFSScreen Definitions - Screen Configuration Tool
OIFXCONLocation management system control
OIFBRD1Link dialogs supported for BP - technical cat. (IS-Oil MRN)
OIFCOPT1SRetail Network Contract option type description
OIFORCAMConversion of article master to material master data (ALE)
OIFXSTObject status table (IS-Oil MRN)
OIFSCTFDDEFCField Definition Customizing - Screen Configuration Tool
OIFDDM2Del. point/material/tank (bulk delivery planning)
OIFBRD1TLink dialog descriptive text (IS-Oil MRN)
OIFOCSKSObject links - CO cost center (IS-Oil MRN)
OIFXCONTLocation management system control texts
OIFXCUAEXCUA function exclusion (IS-Oil MRN)
OIFORCPRTransfer customer expected price into sales condition record
OIFSCTAPPDSScreen configur. tool - Rel. data sections per application
OIFCOPT1Retail Network Contract option type
OIFSCTDSDEFCData Section Customizing - Screen Configuration Tool
OIFOCEPCObject links - CO-PCA profit center (IS-Oil MRN)
OIFBRD2SPA/GPA parameters supported for partner link dialog
OIFSCTFDDEFC1Field Definition Customizing - Screen Configuration Tool