ROIJLOCMAT SAP (OIL-TSW: Structure for int. table OIJLOCMAT_TAB) Structure details

Dictionary Type: Structure
Description: OIL-TSW: Structure for int. table OIJLOCMAT_TAB




ABAP Code to SELECT data from ROIJLOCMAT
Related tables to ROIJLOCMAT
Access table ROIJLOCMAT




Structure field list including key, data, relationships and ABAP select examples

ROIJLOCMAT is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "OIL-TSW: Structure for int. table OIJLOCMAT_TAB" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_ROIJLOCMAT TYPE ROIJLOCMAT.

The ROIJLOCMAT table consists of various fields, each holding specific information or linking keys about OIL-TSW: Structure for int. table OIJLOCMAT_TAB data available in SAP. These include MANDT (Client), LOCID (Location ID), PMATNR (Material Number), LOCNAME (Location name (used by system owner)).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP ROIJLOCMAT structure fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3T000MANDT
LOCIDLocation ID OIJ_LOCIDCHAR10OIJLOCOIJ_LOCIDOIX
PMATNRMaterial Number MATNRCHAR18MARAMATN1MATNRMATS_MAT1
LOCNAMELocation name (used by system owner) OIJ_LOCNAMCHAR60OIJ_LOCNAM
PMATNAMEMaterial Description (Short Text) MAKTXCHAR40TEXT40
PWERKPlant for location Stock Projection and Replenishment Planng OIJ_PWERKCHAR4T001WWERKS
CHARGBatch / Valuation type OIJ_CHARGCHAR10MCHBCHARGCHA
RDUOMStock Projection unit of measure (UoM) OIJ_RDUOMUNIT3T006CUNITMEINS
RDCONVOIL-TSW: Stock Projection conversion factor OIJ_RDCONVNUMC5NUMC5
PERIODOIL-TSW: Rolling period OIJ_PERIODNUMC3ANZTA
PASTOIL-TSW: Number of days in the past OIJ_PASTNUMC3ANZTA
TOLPCTQuantity tolerance under (%) OIJ_BUTOLDEC4(1) DEC3_1
TOLABSAbsolute tolerance qty under OIJ_TOLABSQUAN13(3) MENG13
PASTDATAOIL-TSW: No. of days in past for safety stock calculation OIJ_SFPASTNUMC3ANZTA
PHY_INV_FLGOIL-TSW: Flag indicating physical inventory input OIJ_FLGCHAR1XFELD
PHY_INVOIL-TSW: Phy inventory at loc.(from external source) OIJ_PHY_INVQUAN13(3) MENG13V
PHY_DATEOIL-TSW: Date for last physical inventory update OIJ_PHY_DATEDATS8DATUM
FCPASTOIL-TSW: History horizon for automated rack issue forecast OIJ_FCPASTNUMC3ANZTA
FCOFFSETOIL-TSW: Number of offset days in forecast calculation OIJ_FCOFFSETNUMC3ANZTA
FCTYPEOIL-TSW: Rack issue forecast type OIJ_FCTYPECHAR4OIJ_FCTYPE
PHYTMSTimestamp for previous physical inventory update OIJ_PHYTMSNUMC14TSTAMP
SRCTYPEOIL-TSW: Physical inventory type / source OIJ_SRCTYPECHAR1OIJSRCTYPEOIJ_SRCTYPE
FCHORIZOil-TSW: Rack issue / Throughput forecast history horizon OIJ_FCHORIZNUMC3OIJ_FCHORIZ
RVPRVP value OIJ_RVPDEC4(1) DEC3_1
PLTYPOIL-TSW: Planning type OIJ_PLTYPCHAR3OIJ_PLTYP
CALFLGOIL-TSW: Calendar use indicator OIJ_CALFLGCHAR1OIJ_CALFLG
PLCALPlanning calendar OIJ_PLCALCHAR3Assigned to domainOIJ_PLCAL
COVEROIL-TSW: Safety stock coverage period (in plan period UoM) OIJ_COVERQUAN3OIJ_PERIOD
PLHOZOIL-TSW: Planning horizon OIJ_PLHOZQUAN3OIJ_PERIOD
DATUOMOIL-TSW: Planning period UoM OIJ_DATUOMUNIT3T006CUNITMEINS
PTSYSTOIL-TSW: Planning transport system OIJ_PTSYSTCHAR10OIJTSOIJ_TSYST
PLUOMOIL-TSW: Planning UoM OIJ_PLUOMUNIT3T006CUNITMEINS
CYCLEOIL-TSW: Planning cycle period OIJ_CYCPERQUAN3OIJ_PERIOD
CYCUOMOIL-TSW: Cycle period UoM OIJ_CYCUOMUNIT3T006CUNITMEINS
MAXLOTOIL-TSW: Planning maximum batch (lot) size OIJ_MAXLOTQUAN13(3) MENG13
MINLOTOIL-TSW: Planning minimum batch (lot) size OIJ_MINLOTQUAN13(3) MENG13
INCLOTOIL-TSW: Planning incremental batch (lot) size - rounding OIJ_INCLOTQUAN13(3) MENG13
INVUOMOIL-TSW: Planning inventory UoM OIJ_INVUOMUNIT3T006CUNITMEINS
MAXINVOIL-TSW: Planning maximum inventory level OIJ_MAXINVQUAN13(3) MENG13V
TARGETOIL-TSW: Planning target inventory level OIJ_TGTINVQUAN13(3) MENG13V
REORDEROIL-TSW: Planning reorder point inventory level OIJ_REORDQUAN13(3) MENG13V
SAFETYOIl-TSW: Planning safety inventory level OIJ_SFTINVQUAN13(3) MENG13V
UNPUMPOIL-TSW: Unpumpable (blocked) inventory OIJ_UNPUMPQUAN13(3) MENG13V
MININVOIL-TSW: Planning minimum inventory level OIJ_MININVQUAN13(3) MENG13V
STSYSTOIL-TSW: Planning source transport system OIJ_STSYSTCHAR10OIJTSOIJ_TSYST
SLOCIDOIL-TSW: Planning source location ID OIJ_SLOCIDCHAR10OIJLOCOIJ_LOCID
SPARTOIl-TSW: Planning source partner (supplier) OIJ_SPARTCHAR10ALPHAOIJ_PARTNR
SPOBJOIL-TSW: Planning source partner object type (vend/plant) OIJ_SPOBJCHAR2CHAR2
OFFPEROIL-TSW: Planning source offset period OIJ_OFFPERQUAN3OIJ_PERIOD
OFFUOMOIL-TSW: Planning source offset period UoM OIJ_OFFUOMUNIT3T006CUNITMEINS
RADIONOSRCOIL-TSW: Radio button - no planning source OIJ_RADNSCCHAR1XFELD
RADIOTSSRCOIL-TSW: Radio button for TS sourcing OIJ_RADTSCHAR1XFELD
RADIOLOCSCOIL-TSW: Radio button for TSW location sourcing OIJ_RADLOCCHAR1XFELD
PLANAMPELOIL-TSW: Traffic light indicating presence of plan details OIJ_PAMPELCHAR80TEXT80
PLANFLAGOIL-TSW: Planning run flag (X = plan run done since RD) OIJ_PLFLAGCHAR1XFELD
SCFLAGOIL_TSW : Source object planning run flag OIJ_SCFLAGCHAR1XFELD
SERVICEOIL-TSW: Safety stock service level OIJ_SRVCDEC3DEC3
COVPROFOIL-TSW: Safety stock coverage profile OIJ_COVPRFCHAR3OIJCOVOIJ_COVPRF
CALPROFOIL-TSW: Safety stock calendar usage profile OIJ_CALPRFCHAR3OIJSCALOIJ_CALPRF
FACTORYOIL-TSW: Factory calendar ID OIJ_FACTRYCHAR2TFACDWFCID
SFTTYPEOIL-TSW: Safety stock calculation type OIJ_SFTTYPCHAR3OIJSFTYPOIJ_SFTTYP
HISTHOZOIL-TSW: Safety stock history horizon OIJ_HISTHZNUMC3ANZTA
TSERVICEOIL-TSW: Target stock service level OIJ_TSRVCDEC3DEC3
TCOVPROFOIL-TSW: Target stock coverage profile OIJ_TCOVPRFCHAR3OIJ_TCOVPRF
TCALPROFOIL-TSW: Target stock calendar usage profile OIJ_TCALPRFCHAR3OIJ_TCALPRF
TFACTORYOIL-TSW: Factory calendar ID for Target stock calculation OIJ_TFACTRYCHAR2Assigned to domainWFCID
TGTTYPEOIL-TSW: Target stock calculation type OIJ_TGTTYPCHAR3OIJTGTYPOIJ_TGTTYP
THISTHOZOIL-TSW: Target stock history horizon OIJ_THISTHZNUMC3ANZTA
FCCALOIL-TSW: Stock Projection rack forecast calendar OIJ_FCCALCHAR2TFACDWFCID
FCPRFOIL-TSW: Stock Projection rack forecast profile OIJ_FCPRFCHAR3OIJFCPRFOIJ_FCPRF
TANKUPDFlag to indicate update by tank interface file OIJ_TANKUPDCHAR1XFELD
SFTLVLPreferred Safety Level OIJ_SFTLVLQUAN13(3) MENG13V
HRLVLPreferred Headroom Level OIJ_HRLVLQUAN13(3) MENG13V
SFTTDINDCalculate time-dependent safety stock OIJ_SFTTDINDCHAR1XFELD
TGTTDINDCalculate time-dependent target stock OIJ_TGTTDINDCHAR1XFELD
PPTYPProduction planning type OIJ_PPTYPCHAR4OIJ_PPTYP
BALANCEIndicator to supress balance quantities in Stock Projection OIJ_BALANCECHAR1XFELD
PVFLAGOIL-TSW: Flag indicating that PV use is active OIJ_PVFLAGCHAR1XFELD
VERIDOIL-TSW: Version ID currently assigned OIJ_VERIDCHAR4MKALVERID
TODATOIL-TSW: To date of active PV OIJ_TDATEDATS8DATUM
FROMDATOIL-TSW: From date of active PV OIJ_FDATEDATS8DATUM
BOMALTOIL-TSW: Alternative BOM OIJ_BOMALTCHAR2ALPHAALTNR
BOMUSEOIL-TSW: BOM use indicator OIJ_BOMUSECHAR1T416STLAN
BOMMATOIL-TSW: BOM material assigned OIJ_BOMMATCHAR18MARAMATN1MATNR
ERDATDate on Which Record Was Created ERDATDATS8DATUM
ERZEITTime of creation OI0_ERTIMTIMS6UZEIT
ERNAMName of Person who Created the Object ERNAMCHAR12USNAM
AEDATChanged On AEDATDATS8DATUM
AEZEITTime of day the record was changed OI0_AETIMTIMS6UZEIT
AENAMName of Person Who Changed Object AENAMCHAR12USNAM
BLOINDBlocking indicator OIJ_BLOINDCHAR1XFELD
DELINDDeletion indicator OIJ_DELINDCHAR1XFELD
TCONSIndicator for location/material time dependent data OIJ_TCONSCHAR1XFELD
AUTOCONFIRMAutomatic confirmation Flag OIJ_AUTOCONFCHAR1XFELD
VRMODConsumption mode VRMODCHAR1VRMOD
VINT1Consumption period: backward VINT1NUMC3VRINT
VINT2Consumption period: forward VINT2NUMC3VRINT
DEFSITYPDefault schedule type OIJ_DEFSITYPCHAR2TOIJ_EL_SITYPESOIJ_SITYP
DEFDOCINDReference document indicator (PSX) OIJ_DOCINDCHAR1OIJ_DOCIND
LBUOMLocation Balancing UOM OIJ_LBUOMUNIT3Assigned to domainCUNITMEINS
SELECTFLAGGeneral Flag FLAGCHAR1FLAG
UPDATEFLAGTransaction type TRTYPCHAR1TRTYP

Key field Non-key field



How do I retrieve data from SAP structure ROIJLOCMAT using ABAP code?

As ROIJLOCMAT is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on ROIJLOCMAT as there is no data to select.

How to access SAP table ROIJLOCMAT

Within an ECC or HANA version of SAP you can also view further information about ROIJLOCMAT and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!