sap oil chapter2

Upload: raks-thuruthiyil

Post on 04-Apr-2018

244 views

Category:

Documents


3 download

TRANSCRIPT

  • 7/29/2019 SAP Oil Chapter2

    1/20

    &KDSWHU

    +\GURFDUERQ3URGXFW0DQDJHPHQW+30DVSDUWRI,62LO'RZQVWUHDP

    +LJK/HYHO6XPPDU\

    The SAP R/3 Logistics modules, Materials Management (MM) and Sales andDistribution (SD), provide a comprehensive information system for theeffective and efficient management of all standard activities within thesupply chain. The objective of the Inventory and Hydrocarbon ProductManagement (HPM) functionality within the R/3 IS-Oil Downstreamcomponent is to enable these Core modules to address certain specific oilindustry requirements.

    With regard to general hydrocarbon inventory management, IS-Oil amendsexisting Core SAP functionality in order to:

    q Incorporate ASTM/API petroleum measurement standards. Thesestandards are used to convert volume quantities and product densitiesat ambient temperatures to volume quantities and densities at welldefined standard temperatures for material movements and measure-

    ments.q Provide additional quantity fields enabling stock balances to be stored in

    multiple units of measure (for example volume at ambient temperature,corrected volume based on standard temperature and apparent mass).

    q Allow stock balances to become negative as the result of a movement,and handling the financial impact of such a movement.

    q Provide a tracking function to link material movements from one plantto another in order to calculate and post gains and losses (two-steptransfer).

    .H\)XQFWLRQ%HQHILWVThe key function benefits are outlined below:

    HPMs functionality can be viewed as a tool for creating business benefits inother design categories within IS-Oil. Principally, it allows oil companies toeffectively manage their supply chain of continuous and discrete product tominimize costs and maximize the reliability and quality of service providedto the customers.

    (IIHFWLYH3URGXFW0DQDJHPHQW

  • 7/29/2019 SAP Oil Chapter2

    2/20

    +\GURFDUERQ3URGXFW0DQDJHPHQW+30DVSDUWRI,62LO'RZQVWUHDP

    The ASTM/API calculation function enables highly accurate automatic

    conversions between alternative units of measure, based on internationallyaccepted petroleum measurement standards (ISO 91-1), which areperformed within the SAP R/3 System. Thus, the company gains savings interms of time and effort by not having to perform these calculations outsidethe system.

    As there is no limit to the number of units of measure that can be calculatedfor a material, the system provides complete flexibility for tracking andreporting material quantities.

    The ability to calculate material quantities using the ASTM/API conversionsin HPM provides a high level of integration with the other modules. Thisenables the company to view the product in the particular unit of measure

    (UoM) desired.

    )LJ6\VWHP0RGXOH,QWHJUDWLRQ

    The ability to convert units of measure and to post movements of materialsimultaneously provides the company with accurate quantity levels of

    material in real time.The weight ( i.e. apparent mass) and volume of a product required forshipment is calculated and saved to aid in the delivery and shipping process.

    Issues and receipts for plant-to-plant transfers are linked by R/3 IS-OilDownstream functionality.

    The enhancement to the intra-company movement (plant-to-plant transfer)functionality enables an issue quantity from one plant and a receipt quantityat a second plant to be reconciled, and the resulting gain/loss associatedwith the movement to be automatically calculated and posted.

    $XWRPDWLF4XDQWLW\&RQYHUVLRQDQG0DWHULDO

    7UDFNLQJ

    ,QWHJUDWLRQRI6\VWHP0RGXOHV

    7LPHOLQHVVRI'DWD

    6KLSPHQW3URFHVV)DFLOLWDWLRQ

    3ODQWWRSODQW7UDQVIHUVDQG+DQGOLQJRI*DLQV/RVVHV

  • 7/29/2019 SAP Oil Chapter2

    3/20

    +\GURFDUERQ3URGXFW0DQDJHPHQW+30DVSDUWRI,62LO'RZQVWUHDP

    .H\,62LO)XQFWLRQV6XSSRUWHGE\WKH,62LO'RZQVWUHDP+30&RPSRQHQW

    The following HPM enhancements are provided within the R/3 IS-OilDownstream component:

    9ROXPH&RUUHFWLRQV$FFRUGLQJWR$PHULFDQ6RFLHW\IRU7HVWLQJDQG0DWHULDOV$PHULFDQ3HWUROHXP,QVWLWXWH6WDQGDUGV$670$3,

    IS-Oil incorporates an interface to ASTM/API c-code routines to convertvolume quantities and product densities at ambient temperatures to volume

    quantities and densities at standard temperatures for material movementsand inventory measurements. The system supports the standard ASTMTables 53 and 54, including the German rounding rules, ASTM Tables 23and 24 for relative densities and ASTM Tables 5 and 6 for API gravitycalculations. The calculation is performed on goods movements relating tooil materials, with the ability to calculate specific units of measure. Theuser can configure whether the calculations are performed in display mode,or in the background, and whether the values calculated can be overwritten

    by manual entry or not. The system also provides an ASTM/API desk topcalculator to perform quantity conversions when no goods movement hasoccurred.

    ,QYHQWRU\$GGLWLRQDO8R0

    Storing of multiple units of measure is made available through additionalappendix tables to the material master for each material, thereby providingadditional information for ABAP reporting capability.

    3ODQWWRSODQW7UDQVIHUVDQG+DQGOLQJRI*DLQV/RVVHV

    Issues and receipts for plant-to-plant transfers are linked by R/3 IS-OilDownstream functionality. The enhancement to the intra-company movement(plant-to-plant transfer) functionality enables an issue quantity from one plantand a receipt quantity at a second plant to be reconciled and the resultinggain/loss associated with the movement to be automatically calculated andposted.

    Material movements can occur between plants belonging to the same company,or between storage locations within a single plant. These movements can bemonitored in the R/3 IS-Oil Downstream system.

  • 7/29/2019 SAP Oil Chapter2

    4/20

    +\GURFDUERQ3URGXFW0DQDJHPHQW+30DVSDUWRI,62LO'RZQVWUHDP

    A transaction exists in R/3 IS-Oil Downstream in which the issue from the

    first plant is linked by a transfer tracking number to the receipt of thesecond. Thus, the tracking number allows for the calculation of gains andlosses associated with a company movement, as well as tracking the statusof the material movement. The corresponding excise duty gain/loss is alsocalculated.

    1HJDWLYH,QYHQWRU\

    Negative inventory allows for stock balances to become negative as a resultof a goods movement. This allows an issue of a material to be made eventhough there is insufficient stock available in the system to complete theissue.

    For example, if a hydrocarbon movement occurs over several days, certaintransactions will be booked several days after the initial part of the movement.This could result in a shortage of inventory, from a system perspective, if agoods issue is made.

    .H\,62LO)XQFWLRQV6HUYHGE\WKH&RUH56\VWHP

    The following features in the Core R/3 System are particulary applicable tothe oil and gas industry.

    %OHQGLQJDQG5HEUDQGLQJ

    The ability to change the material code of a product when two differentproducts are mixed together, creating a new product, or to change thedescription of one product to another.

    3K\VLFDO,QYHQWRU\

    Post to physical inventory balancing is simplified in R/3 by the detail storedin the inventory. All movements and physical counts are retained by thesystem, which provides for numerous ABAP reports to be developed forinventory reconciliation. R/3 also provides the flexibility of a companydefined grouping of products that enable the company to create customABAP reports.

  • 7/29/2019 SAP Oil Chapter2

    5/20

    +\GURFDUERQ3URGXFW0DQDJHPHQW+30DVSDUWRI,62LO'RZQVWUHDP

    6SHFLDO6WRFNV

    Consignment and subcontract stocks are easily accounted for and tracked inthe standard R/3 System, regardless of their actual physical location (forexample, stocks at customer or vendor sites). Functionality available forspecial stocks is similar to that of normal inventory stocks, which includesphysical counts, stock reservations, and pricing.

    )LJ)XQFWLRQDOLW\IRU6SHFLDO6WRFNV

    /,)2),)2,QYHQWRU\9DOXDWLRQ0HWKRGVIRU$FFRXQWLQJDQG5HSRUWLQJ

    LIFO/FIFO valuation is provided by R/3 IS-Oil as part of the Core System.

  • 7/29/2019 SAP Oil Chapter2

    6/20

    +\GURFDUERQ3URGXFW0DQDJHPHQW+30DVSDUWRI,62LO'RZQVWUHDP

    'HWDLOHG'HVFULSWLRQRI%XVLQHVV)XQFWLRQV6XSSRUWHG

    E\WKH,62LO'RZQVWUHDP+30&RPSRQHQW

    /RFDWLRQ+LHUDUFK\

    Within the SAP R/3 System, much of the master data information isstructured within a common hierarchy. This hierarchy consists of four levels:client, company, plant and storage location. All information in the hierarchyapplies equally to all lower levels. Thus, the hierarchical structure ensures

    that data redundancy is kept to a minimum.

    )LJ/RFDWLRQ+LHUDUFK\

    The common hierarchy is applied to several different master file structures,one of which is the location structure.

    Clients and Companies

    For any given organization, there may be a variety of ways that the locationstructure could be represented within the SAP R/3 System. This is done bymirroring current or desired organizational structures of the business. The

    decision is driven primarily by how corporate information is gathered,aggregated and reported.

    /RFDWLRQ+LHUDUFK\

  • 7/29/2019 SAP Oil Chapter2

    7/20

    +\GURFDUERQ3URGXFW0DQDJHPHQW+30DVSDUWRI,62LO'RZQVWUHDP

    An oil company (the SAP client) may have divided its organization into

    business functions. Thus, the SAP companies would be the independentbusiness units of the oil company, as illustrated in the figure below.

    )LJ2UJDQL]DWLRQ'LYLGHGLQWR%XVLQHVV)XQFWLRQV

    Alternatively, separate SAP companies could be used to represent eachnational subsidiary of a multi-national organization (the SAP client).

    Plant

    A plant is a strategic business unit. The plant is the highest level in thehierarchy where inventory balances are stored, so the assignment of plantswill determine how an organizations inventory position can be reflected.The plant field is a four digit alphanumeric field. For an oil company, typicaluses of the plant entity in SAP might be to define:

    q Crude storage terminals

    q Finished product marketing terminals

    q Refineries and manufacturing complexes

    q Pipelines, or pipeline segments

    In addition to these physical sites, where an organizations inventory ismaintained and reported, it is possible to define so called logical plants.An oil company might use logical plants:

    q To store and report inventory in a summarized manner

    q To represent third party inventory sites, for example exchange partnerlocations

    q To store in-transit inventory, possibly by mode of transport

  • 7/29/2019 SAP Oil Chapter2

    8/20

    +\GURFDUERQ3URGXFW0DQDJHPHQW+30DVSDUWRI,62LO'RZQVWUHDP

    )LJ3K\VLFDODQG/RJLFDO3ODQWV

    Storage Location

    A storage location is a subdivision within a plant, enabling inventory to bemanaged at a more detailed level. Each plant must contain at least one

    storage location. The storage location field is a four digit alphanumeric field.Storage locations enable the management of inventory in smaller units.

    Within a physical plant, an oil company might use storage locations:

    q To track and report volumes of individual product, for example establishindividual or groups of tanks at a terminal (plant) as storage locations.

    Within a logical plant, an oil company might use storage locations:

    q To define individual third party sites (within a summary third partyplant)

    q To define stock being transported by different modes of transport(within an in-transit plant)

    The assignment of a companys physical and logical inventory sites as plantsor storage locations is completely flexible within the SAP R/3 System. An oilcompany would assign entities as plants or storage locations dependent onfactors such as:

    q The number of inventory sites to be defined in the SAP R/3 System

    q The level of inventory tracking and reporting required at the inventorysite

  • 7/29/2019 SAP Oil Chapter2

    9/20

    +\GURFDUERQ3URGXFW0DQDJHPHQW+30DVSDUWRI,62LO'RZQVWUHDP

    )LJ3ODQWVDQG6WRUDJH/RFDWLRQV

    3URGXFW+LHUDUFK\

    This is another area to which the common hierarchy is applied in thematerial master record.

    Client

    The Client level is the highest level at which material information can bemaintained. Information maintained at this level includes:

    q Material number and description

    q Stockkeeping unit of measure

    q Material type

    q Industry sector

    q Quantity calculation method

    The stockkeeping unit of measure is the base unit of measure, or the unit inwhich the stock is managed. The standard system converts all quantitiesentered in other units to this unit. In R/3 IS-Oil Downstream, for oilmaterials, these conversions can be performed using ASTM/API conversionroutines (see the section Quantity Conversions Incorporating ASTM/APIProcedures). All implicit financial transactions (material valuations, accountspayable updates, etc.) associated with a goods movement are performed

    based on the quantity in the stockkeeping UoM.

    The material type provides one method for grouping materials together inthe SAP R/3 System. Examples of material types are raw materials, tradinggoods and finished products. The material type defines certain features of

    3URGXFW+LHUDUFK\

  • 7/29/2019 SAP Oil Chapter2

    10/20

    +\GURFDUERQ3URGXFW0DQDJHPHQW+30DVSDUWRI,62LO'RZQVWUHDP

    the material and has important control functions. For example, the material

    type determines which department-specific data the user can enter for thematerial.

    Company

    In the oil industry, a requirement exists to hold material information at thecompany level, since some information, for example, that pertaining to taxand excise duty, is country-specific. R/3 IS-Oil Downstream provides thefollowing information at that level:

    q Additional units of measure for maintaining inventory quantities inmaster files and reports

    q Conversion group

    The units of measure that are calculated automatically for a material (inaddition to the stockkeeping unit) when a material movement occurs, aredefined at this level.

    It is possible to group individual units of measure, by a key, simplifying theassignment of the units of measure to a country code. The units of measurethat are reported in the standard stock reports (see the section entitledInventory Information and Reporting) are also defined at this level.

    The R/3 IS-Oil Downstream System provides a number of methods forconverting between the different units of measure defined for a material (seethe section Quantity Conversions Incorporating ASTM/API Procedures).The conversion group defines which set of formulas will be used in the

    conversion calculations.Plant

    The plant level is the highest level in the SAP hierarchy where stock balancesare stored in the SAP R/3 System. Material information held at this levelincludes:

    q Stock balances, in stockkeeping unit of measure, for different types ofmaterial quantity

    q Stock balances in additional unit of measure for total stock and valuatedstock with unrestricted use

    At plant level, stock balances in the stockkeeping unit of measure are held for

    a number of different types of stock. These include total stock, unrestricteduse stock, stock in transfer, consignment stock and reserved stock.

    In addition to these quantities held in the stockkeeping unit of measure, thetotal stock and valuated stock with unrestricted use are held in theadditional UoM and are available for reporting.

    The batch managed indicator is maintained at plant level. If this indicator isset, then a material is managed in batches.

  • 7/29/2019 SAP Oil Chapter2

    11/20

    +\GURFDUERQ3URGXFW0DQDJHPHQW+30DVSDUWRI,62LO'RZQVWUHDP

    Storage Location

    Information maintained for a material at this level in the R/3 IS-OilDownstream system includes:

    q Stock balances in stockkeeping UoM for different types of materialquantity

    q Stock balances in additional UoM for total stock and valuated stock withunrestricted use.

    Batches

    Storage location stock can be subdivided into batches in order to facilitatethe management and valuation of inventory at a more detailed level.

    Special StocksSAP R/3 provides functionality to manage stock owned by third parties, orstocks stored at third party locations. Special stocks are typically stored inthe system as logical plants and storage locations, as described in thesection entitled Location Hierarchy. Some examples of special stocksinclude:

    q Vendor Consignment Stock - Stock owned by a vendor, but stored atyour site

    q Subcontract Stock - Stock owned by your company, but stored at a sitebelonging to a supplier

    q Customer Consignment Stock - Stock owned by your company, but

    stored at a site belonging to a customer

    q Suppliers and Customers packaging to be returned

    q Project Stock - Stocks allocated to projects defined in the SAP R/3project system

    One example of the way special stocks could be used by an oil company is asfollows: customer consignment stock could be used to keep track ofinventory quantities at certain dealer-operated retail stations. After deliveryof the product, it is still owned by the delivering company until it is finallysold. Inventory at retail stations can be tracked in the system using customerconsignment stock.

  • 7/29/2019 SAP Oil Chapter2

    12/20

    +\GURFDUERQ3URGXFW0DQDJHPHQW+30DVSDUWRI,62LO'RZQVWUHDP

    4XDQWLW\&RQYHUVLRQV,QFRUSRUDWLQJ$670$3,3URFHGXUHV

    In the oil industry, it is a requirement to be able to hold material quantitiesin multiple units of measure (UoM). The volume quantities and densities ofoil materials are temperature-dependent; Raising the temperature of a liquidor gaseous material increases the materials volume and thus decreases itsdensity. In order to compare one volume quantity of material to anothervolume quantity of the same material, the comparison must be made at acommon temperature.

    )LJ4XDQWLW\&RQYHUVLRQV

    Thus, it is usual (and a legal requirement for excise duty calculations) tomaintain inventory balances in a UoM at a fixed temperature (for exampleliters at 15 Celsius, L15). However, most goods movements occur at ambienttemperature, with the temperature at which the movement occurred beingmeasured along with the density of material moved. The quantity correctionfunctionality provided by R/3 IS-Oil Downstream system enables conversion

    between volumes measured at different temperatures into UoM at a standardtemperature, for inventory management and reporting. It is also possible tocalculate the weight of a material. All UoMs relevant to a material can bedefined and calculated automatically when a movement of the material takesplace.

    Functions Utilizing Different Units of Measure

    A particular UoM may be required in order to calculate the excise duty. TheTDP functionality uses the conversion routines to calculate and reportinventory balances in the required UoM.

    A companys marketing department might require various UoMs, due topricing procedures for different customers in international markets.

    The pricing functionality in MAP can use any of the UoMs as the basis forpricing.

    4XDQWLW\&RQYHUVLRQV,QFRUSRUDWLQJ$670$3,

    3URFHGXUHV

  • 7/29/2019 SAP Oil Chapter2

    13/20

    +\GURFDUERQ3URGXFW0DQDJHPHQW+30DVSDUWRI,62LO'RZQVWUHDP

    Since all UoMs defined for a material are calculated for every movement

    type, the Exchanges functionality is able to track exchange balances inmultiple UoMs.

    Quantity Calculation Method

    The following description of the quantity conversion routines applies to oilmaterials. These are defined by assigning a conversion group to thematerial master record of the material. If this group is set to indicate an oilmaterial, then the quantity conversion routines will be performed for thematerial.

    Quantity Determination

    There are two possibilities for entering quantities in the R/3 IS-Oil

    Downstream system:The first is to enter the movement quantity along with the density andtemperature of the material when the movement occurred. Automaticinternal conversion routines then convert this quantity into all the UoMmaintained for that material.

    The alternative is to enter all quantities required, with associatedtemperature and density information, directly in the system. This procedureis used if the quantities are calculated outside of the SAP R/3 System. Thesystem checks all mandatory fields for a manual entry of that kind.

    Quantity Conversion

    The automatic conversion of one UoM to another UoM can be performed inone of two ways:

    The R/3 IS-Oil Downstream system contains ASTM/API conversionroutines. This functionality performs conversions based on the rules andformulas defined by the American Petroleum Institute (API), based on thedescriptions created by the American Society for Testing and Materials(ASTM). The system supports the standard ASTM Tables 53 and 54,including the German rounding rules, the ASTM Tables 23 and 24 forrelative densities and ASTM Tables 5 and 6 for gravities. The conversioncalculations use formulas based on these standard tables.

    The alternative is to perform the calculations by an external customerfunction module.

    An external interface to the SAP R/3 System allows conversions that are notsupported by the ASTM/API routines, as described above.

    The two methods are illustrated in the following diagram.

  • 7/29/2019 SAP Oil Chapter2

    14/20

    +\GURFDUERQ3URGXFW0DQDJHPHQW+30DVSDUWRI,62LO'RZQVWUHDP

    )LJ&RQYHUVLRQRIRQH8R0WR$QRWKHU

    Units of Measure Available

    The standard UoM for a material is the stockkeeping unit defined at clientlevel in the material master record. This is the base UoM for storing andreporting inventory balances. R/3 IS-Oil Downstream enables an unrestrictedadditional number of UoMs to be defined for each material. The systemautomatically converts transaction quantities to these UoM for each goodsmovement of the material. Quantity balances are maintained for the materialin all of these additional UoMs, as described below.

    The total stock and available stock balances are held in the additional UoMat the following levels:

    q Plant

    q Storage location

    q Batch level

    q Special stock

    The transaction quantity in the following transaction types are converted tothe additional UoM:

    q Material movements: goods receipts, goods issues, . . .

    q Deliveries

    q Physical inventory documents

  • 7/29/2019 SAP Oil Chapter2

    15/20

    +\GURFDUERQ3URGXFW0DQDJHPHQW+30DVSDUWRI,62LO'RZQVWUHDP

    Material-Specific Information Used in the Quantity Conversion Calculations

    The quantity conversion routines require the material density and temperatureto perform their calculations. This information may be obtained from theconversion routines in one of the following ways:

    q The values for density and standard temperature can be stored at, anddefaulted from, plant, storage location and batch-level. This informationcan be updated at those hierarchical levels, based on the date.

    q For each individual goods movement, it is possible to manually enter thetemperature and material density associated with the transaction.

    Carrying out the Quantity Conversion Calculations

    For some transactions, it is a requirement to be able to enter temperature and

    density measurements made at the time of the goods movement. The R/3 IS-Oil Downstream system provides this capability. Dependent on transactiontype, it is possible to configure the R/3 IS-Oil Downstream system to performthe quantity conversion calculations by one of four different methods:

    )LJ0HWKRGVWRSHUIRUPWKHTXDQWLW\FRQYHUVLRQFDOFXODWLRQV

    Automatic Conversion Calculation

    The system uses default values for density and temperature. The quantityconversions are performed in background calculations, based on thetransaction quantity and associated UoM.

    Semi-Automatic Conversion Calculation

    The system uses default values for density and temperature. The quantityconversions are performed in background calculations, based on thetransaction quantity and associated UoM. The results of the calculations aredisplayed to the user and can be changed manually before being posted.

  • 7/29/2019 SAP Oil Chapter2

    16/20

    +\GURFDUERQ3URGXFW0DQDJHPHQW+30DVSDUWRI,62LO'RZQVWUHDP

    Manual Conversion Calculation

    The system uses default values for density and temperature. The systemdisplays these values to the user, and may be changed by manual input. It isalso possible to manually input values for the transaction quantity in any ofthe alternative UoMs. The system then performs conversion calculations tothe UoM that have not been manually input. The results of the calculationsare redisplayed and can be changed by the user.

    Semi-Manual Conversion Calculation

    The system uses default values for density and temperature and allows onlythese values to be changed. The system performs the volume conversions inthe background, based on the transaction quantity and associated UoM.

    Calculation of Gross/Net Weights and VolumesThe R/3 IS-Oil Downstream system performs automatic ASTM/APIcalculations of weights and volume in the shipment process.

    Base Sediment and Water Calculation

    Base Sediment and Water (BS&W) is a percentage of the total quantity that isnon-oil material. This value is to be subtracted from the ASTM-correctedquantity and is applied to volumes when activated. Activation takes place

    by product type specified in a table. The BS&W is an integral part of allmaterial movements. The meter calibration factor is applied to all targetvolumes, when BS&W is activated.

    Gain/Loss Handling with Plant-to-Plant TransfersThe two-step plant-to-plant transfer functionality has been enhanced toenable the reconciliation of individual goods issues and goods receiptsassociated with a physical shipment.

    Performing Quantity Conversion Calculations When No Goods

    Movement Has Occurred

    The R/3 IS-Oil Downstream system provides the functions for performingquantity conversions when no goods movement has occurred. A desk topcalculator is provided to perform stand-alone calculations, using eitherASTM/API or customer conversion function modules.

    )LJ'HVNWRS&DOFXODWRUIRU6WDQGDORQH&DOFXODWLRQV

  • 7/29/2019 SAP Oil Chapter2

    17/20

    +\GURFDUERQ3URGXFW0DQDJHPHQW+30DVSDUWRI,62LO'RZQVWUHDP

    Checking the Results of Quantity Conversion Calculations

    Functionality is provided to be used for checking the results of systemcalculations, performed either using the ASTM/API or the customerfunction modules. The result is a report that compares the system calculationwith values in the standard ASTM/API tables.

    The following table illustrates the use of the R/3 IS-Oil Downstreamquantity conversion functionality. In this example, a material has astockkeeping UoM of barrels at 60 degrees Fahrenheit (B60), while goodsmovements of the material are recorded in barrels at ambient temperature(BBL). The material has an API gravity of 40 and the initial stock of theproduct is 500 B60. The table shows the changes in quantity for the followingscenario:

    A supplier delivers 950 BBL of the material. The temperature measured atthe time of delivery is 50 degrees Fahrenheit. Subsequently, 500 BBL of thematerial is issued to a retail station. The temperature measured at the time ofissue is 70 degrees Fahrenheit.

    )LJ,OOXVWUDWLRQRI4XDQWLW\&RQYHUVLRQ)XQFWLRQDOLW\

    ,QYHQWRU\,QIRUPDWLRQDQG5HSRUWLQJ

    Standard Inventory Information Available

    The R/3 IS-Oil Downstream component provides extensive functionality forstoring and reporting inventory information. The inventory information

    stored at the different levels of the common hierarchy were discussed in thesection entitled Product Hierarchy. Other inventory management functionsand the reporting capabilities of the system will now be considered.

    Physical Inventory

    The real-time nature of SAP inventory functionality assumes that transactionsare entered into the SAP R/3 System as they occur.

    When a goods movement occurs, the corresponding posting should be madeimmediately, to ensure that the system reflects an accurate view of the trueinventory position. Thus, all transactions for a given location must beentered into the system before a physical inventory count is performed atthat location. The physical inventory count consists of the following steps:

    ,QYHQWRU\,QIRUPDWLRQDQG5HSRUWLQJ

  • 7/29/2019 SAP Oil Chapter2

    18/20

    +\GURFDUERQ3URGXFW0DQDJHPHQW+30DVSDUWRI,62LO'RZQVWUHDP

    q Select the materials and locations to be included in the count

    q Perform the physical inventory count and record the results in thephysical inventory document

    q Enter the physical inventory measurements in the system. These can beentered either manually, from the physical inventory document, or usingan interface to the SAP R/3 System. The quantity conversion routines,discussed in the section Quantity Conversions Incorporating ASTM/APIProcedures are used to calculate measured quantities into the UoMdefined for the material

    q Create a post to physical inventory difference list

    q If possible, correct the physical inventory measurements, for example if

    differences can be traced to input errorsq Post the differences. This involves adjusting the book inventory to reflect

    the physical inventory measured and the generation of the associatedfinancial adjustments.

    All physical inventory results are stored in a physical inventory documentfile. The document file can be displayed online, covering multiple years.Inventory information is stored in the storage location, batch and specialstock segments of the material master.

    Inventory Balancing

    Each material movement is posted in the SAP R/3 System as a document,and stored in a movements history file. Material movements are categorized

    by movement type. The movement type defines the nature of the movement,for example goods issue to production or plant-to-plant transfer.

    Inventory balances are updated in real-time, as each transaction is recordedin the system. This ensures that the risk of reconciliation errors is small. It isassumed that any errors will ultimately be identified during physicalinventory counting.

    The user can reconcile transactions and physical balances using themovements history file and the physical inventory history file. CustomizedABAP reports could be produced to display information from these files ifrequired, for example, for estimating production and consumption, storagelosses and gains or trend analysis.

    Inventory Reporting

    The inventory balances that are held at each level of the location hierarchywere discussed in the section Product Hierarchy. These balances can bedisplayed through the location structure using the stock overviewtransaction. This transaction provides an inventory on-line report, for asingle material number, at all, or selected, levels of the hierarchy.

    The user can drill-down in the hierarchy to see all of the product inventoryfor the company, plants and storage locations within a plant. Individual

    batches at a storage location are also displayed by this transaction.

    In R/3 IS-Oil Downstream, this transaction enables the additional, oil-specific information recorded in the system to be displayed. The transaction

  • 7/29/2019 SAP Oil Chapter2

    19/20

    +\GURFDUERQ3URGXFW0DQDJHPHQW+30DVSDUWRI,62LO'RZQVWUHDP

    enables inventory balances in additional UoM, as well as the stockkeeping

    UoM, to be reported.

    The SAP R/3 System provides several capabilities for assigning a material to auser-defined product grouping, for example material group. This functionalityallows the user to create his or her own product hierarchy. Customized ABAPreports can then be produced to report material balances within the user-defined hierarchy.

    %OHQGLQJDQG5HEUDQGLQJ

    Blending is a common transaction in the oil industry. Product blendingincludes:

    q The mixing of two different materials to obtain a new material

    )LJ0L[LQJ'LIIHUHQW0DWHULDOV

    q The mixing of similar materials

    %OHQGLQJDQG5HEUDQGLQJ

  • 7/29/2019 SAP Oil Chapter2

    20/20

    +\GURFDUERQ3URGXFW0DQDJHPHQW+30DVSDUWRI,62LO'RZQVWUHDP

    )LJ0L[LQJ6LPLODU0DWHULDOV

    Rebranding is available as a function of the Standard SAP R/3 System.

    The blending (mixing) of products is supported by a bill of materials withsub-items for a given delivery of a product. The density for the new materialis recalculated based on the sub-item densities.

    The rebranding is provided by a material-to-material transfer posting. Inorder to perform a material-to-material transfer posting in R/3, it is

    necessary that both materials be managed in the same stockkeeping unit.ASTM/API quantity conversions are provided for both functions.