SAP Downstream Tables

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

Top 10 tables in Downstream

TableDescription
OIJ07_PEGGING_TYMap pegging usage to pegging type
TOI0_BCSETSBC-Sets to be activated externally / log for activated
OIJ07_WEATH_APIAPI Url For Weather
OIJNMTPSNomination Mobile Ticketing Personalization Settings
OIGSJ1BIBrazilian Taxes for Delivery Item
OIJ07_VISU_USRSTUser Setting Visualization
OIJNMTC1Nomination Download to Mobile
OIJ07_VISU_GPSTable for Storing GPS details of Vehicle
VDOIJ_07TKTYPEI_OIJ07_NOMTICKET_TKTTYPEVH I_OIJ07_NOMTICKET_TKTTYPEVH
TOI0TWBIS-OIL Application Test dynamic modifications

List of tables in Downstream

TableDescription
OIJ07_PEGGING_TYMap pegging usage to pegging type
TOI0_BCSETSBC-Sets to be activated externally / log for activated
OIJ07_WEATH_APIAPI Url For Weather
OIJNMTPSNomination Mobile Ticketing Personalization Settings
OIGSJ1BIBrazilian Taxes for Delivery Item
OIJ07_VISU_USRSTUser Setting Visualization
OIJNMTC1Nomination Download to Mobile
OIJ07_VISU_GPSTable for Storing GPS details of Vehicle
VDOIJ_07TKTYPEI_OIJ07_NOMTICKET_TKTTYPEVH I_OIJ07_NOMTICKET_TKTTYPEVH
TOI0TWBIS-OIL Application Test dynamic modifications
OIJ07_IPD_SCHEDStaging table for IPD scheduling simulations
ITKTTHEADTP_DI_TICKETHEADTP I_TICKETHEADTP
S410BIW1S410BIW1 * SIS: Business Location Statistics via 'Ship-to' (
OIJ07_LOCDETAILSTable to store Location Coordinates
OIJ07_IF_MOVSCNIF: Define Movement Scenarios
OIJ07_WEATH_PARAWeather Parameter
OIJ07_TEMP_SCALEWeather Scale
OIJ07_PUMP_PHASEPumping phase
TOI0_REL_RES_RNKRanking of Reservation relevance fields
OIJ07_REPUOM_TYPReporting UoM
OIJ07_NOTIF_TXTNotification Field Text
OIJ07_NOTIF_FLDNotification Fields
OI0_TSW_CPE_MAPMap TSW Events to CPE Reference Date Routine
OIJ07_IPD_FORCASStaging table for IPD forecast
OIJ07_MOT_EVEEvent Type Per Mode Of Transport
ITKTADDNLQTY_DI_TICKETHEADTP I_TICKETADDITIONALQTYTP
VDOIJ_07PARAMI_OIJ07_NOMTICKET_MAIN I_OIJ07_NOMTICKET_PARAM
OIJ07_WEATHER_ARWeather Configuration Area
OIJ07_MESSAGELOGOdata Service IPW : Messages
OIJ07_NOTIF_FLDSTable for Fields Names for Email Table Body (Notify)
OIJ06_RIKPI_TRegional Inventory : KPI filter Data
S414BIW1S414BIW1 * SSR DTF statistics
ITKTTITEMTP_DI_TICKETHEADTP I_TICKETITEMTP
S036BIW1S036BIW1 * LIS: Exchange balance 'Lifts/Receipts' (IS-Oil EX
OIJ06_RIALERT_TTSW:Table to temporarily store alerts for Regional Inventory
OIJ06_ADVANCETable for Advance copy of my nominations
OIJ07_WEATHECONFWeather Json Node Constants
TOIJNOMDOWNTOMBLNomination Download to Mobile
OI001Company Code Parameters
OIJ07_TICKETGUIDTemporary table for Create Ticket by Reference
OIJ07_CITY_AREAWeather Polygon Area
OIJ07_SHAPE_TEXTTank Shape Text
OIJ07_MOVMNT_TYPTSW - Types Of Movement
OIJ07_TICKETTYPETicketing App : Ticket Type in App Settings
OIJ07_PEG_USAGETSW - Pegging Usage Text
OIJ07_PUMP_TEXTPump Phase text table
OIJ07_PUMP_EVENTMode of Transport for Event Categorization
ITKTADDNLPAR_DI_TICKETHEADTP I_TICKETADDITIONALPARAMTP
OIJ07_PEG_TY_USGTSW - Pegging Usage
OIJ07_IPD_PKGIntegration from Interface Data Packages
OIJ07_MOT_EVE_BOEvent Type Per Mode Of Transport for SAP Analytics Cloud
OIGSJ1BHBrazilian Taxes for Delivery Header
OIJ07_SHIPMENTVisualization Shipments
OIJ06_RIMESSAGERegional Inventory : Messages
OIJ07_TANKSHAPETank Shape ID
TOI0OBJTObject status text table (oil cross application)
S410BIW2S410BIW2 * SIS: Business Location Statistics via 'Ship-to' (
OIJ07_TANK_SHAPEConfiguration table to define Tank Shape
OIJ07_VIS_MOVSCNCustomizing Table to capture Movement Scenarios
OIJ07_WEATH_CONDConfigure Weather According To Company Code
TOI0_000Client-depend. function inactive flag(no entry=active)
OIJ07_VISU_USRVAUser default variant
OIJ07_WEATHERWeather Data
OIJNOMMBLTKTTMPSNomination Ticket details
OIJ09_COST_DATAStoring temporary cost data for visualization
S414BIW2S414BIW2 * SSR DTF statistics
S036BIW2S036BIW2 * LIS: Exchange balance 'Lifts/Receipts' (IS-Oil EX
OIJ07_T_WEA_PARMWeather Parameter Text