Optimization Input Log
Definition
Log generated during an optimization run in Supply Network Planning (SNP). It contains all input data considered by the system during the optimization run (that is, master data and transaction data). The data is utilized in numerous tables (such as ET_LOCMAT).
Use
The input log is part of the application log. To access the log, on the SAP Easy Access screen, choose Advanced Planning and Optimization → Supply Network Planning → Reporting → Optimizer Log Data. For more information, see Application Logs for Optimizers.
You can download the log and give it to SAP support as a text file for analysis.
Structure
The individual sections of the log are detailed below.
Legend
|
Flag: |
X = Active, ' ' = Inactive |
|
Prof: |
SNP optimizer profile |
|
Units: |
BTime = Base unit of time (days) |
|
|
BCurr = Base currency |
|
|
BProd = Base unit of measure of the product |
|
|
HanUn = Handling unit |
|
|
StoUn = Storage unit |
|
|
BRes = Base unit of measure of the resource |
ES_CTRL
These entries describe the general properties of the model. The entries are determined from the SNP optimizer profile or directly from the model. Discrete (integer value) transport lots are displayed in the History (‘trace file’) of Optimization Runs (choose Tools → APO Administration → Optimization → Log Display).
|
NBUCK |
Number of buckets |
|
NPROD |
Number of products |
|
NLOCS |
Number of locations |
|
NSUBL |
Number of sublocations |
|
NPROM |
Number of production process models |
|
NRESO |
Number of resources |
|
NREFA |
Number of resource families |
|
NARCS |
Number of arcs |
|
NFLEE |
Number of fleets |
|
NDEMC |
Actual number of demand classes |
|
NDEMA |
Number of demand vectors |
|
DISRF |
Prof: End bucket for increasing production resource discretely |
|
DISRZ |
Prof: End bucket for using fixed production resource consumption |
|
DISTR |
Prof: End bucket for using discrete fleet on transportation lanes |
|
DISPR |
Prof: End bucket for using integral PPM |
|
KAMPA |
Prof: End bucket for campaign + D416 planning |
|
TRLOS |
Prof: End bucket for using minimum transportation lot size |
|
PRLOS |
Prof: End bucket for using minimum production lot size |
|
COSTR |
Prof: End bucket for using transportation cost function |
|
COSPD |
Prof: End bucket for using production cost function |
|
COSPC |
Prof: End bucket for using procurement cost function |
|
SEQLS |
End bucket for sequence resource planning |
|
NPENG |
Number of penalty groups |
|
NQTAA |
Number of quota arrangements |
|
NCHAI |
Number of supersession chains |
|
NFFC |
Number of form-fit-function classes |
|
NSTUP |
Number setup matrices |
|
NPROG |
Number of product groups |
ET_INEXKEY
These entries are the external keys for internal object keys. In particular, there is a list of calendar data for the day numbers, and a list of product and location numbers for the GUIDs.
|
INKEY |
GUID (unique internal key) |
|
EXKEY |
Corresponding external key |
ET_BUCKDF
These entries show the bucket definition (time intervals) upon which all optimizer planning is based. The source of this information is either the selected planning buckets profile or the planning start and end date.
|
BUCKE* |
Bucket no. |
|
|
VALTO |
End date of the bucket (day no., 1st day is 1/1/1970) |
BTime |
|
VALFR |
Begin date of the bucket (day no., 1st day is 1/1/1970) |
BTime |
ET_MATERIAL
The validity period of all products selected for optimization is stored here. At present, this always encompasses the entire planning horizon.
|
MATID* |
Product GUID |
|
BCKTO |
Valid to bucket no. |
|
BCKFR |
Valid from bucket no. |
ET_LOC
Information about the existence or non-existence of a defined handling capacity (handling resource) is stored here for locations.
|
LOCID* |
Location GUID |
|
RESIN |
Handling-in resource GUID or dummy resource, if no handling-in resource is maintained |
|
MAXIN |
Prof: Flag: Handling-in resource active (not activated, if dummy resource is used) |
|
RESOU |
Handling-out resource GUID or dummy resource, if no handling-out resource is maintained |
|
MAXOU |
Prof: Flag: Handling-out resource active (not activated, if dummy resource is used) |
ET_SUBLOC
A storage resource is defined here with information about whether it can be extended. SUBID is currently the resource ID. The source of this information is the location master and, if in existence, storage resource maintenance. Extension is allowed if the resource has two capacity variants.
|
SUBID* |
Storage resource GUID or dummy resource, if no storage resource is maintained |
|
MAXFL |
Prof: Flag: Storage resource active (not activated, if dummy resource is used) |
ET_LOCMAT
The properties of location-dependent products are shown here. Resource consumption is listed, in particular. The source for this is the location product master.
|
LOCID* |
Location GUID |
|
|
MATID* |
Product GUID |
|
|
SUBID |
Storage GUID |
|
|
HCOST |
Storage cost |
BCurr/BProd |
|
BUCFL |
Prof: Flag: Storage cost: Multiply by bucket length |
|
|
SSPEN |
Penalty for not covering safety stock |
BCurr/BProd |
|
MAXST |
Maximum stock level of the product |
|
|
MAXFL |
Flag: Maximum stock level active |
|
|
STOCK |
Initial stock |
BProd |
|
CONIN |
Consumption of input handling capacity |
HanUn/BProd |
|
COSIN |
Handling-in cost |
BCurr/BProd |
|
CONOU |
Consumption of output handling capacity |
HanUn/BProd |
|
COSOU |
Handling-out cost |
BCurr/BProd |
|
RECTI |
Goods receipt processing time in days |
BTime |
|
ISSTI |
Goods issue processing time in days |
BTime |
|
CACON |
Storage capacity consumption |
StoUn/BProd |
|
WASFL |
Flag: Shelf life penalty is active |
|
|
WASTE |
Shelf life: Penalty for wasted quantity |
BCurr/BProd |
|
STODU |
Shelf life: Storage duration |
BTime |
|
FCOST |
Linear procurement cost |
BCurr/BProd |
|
FPERF |
Procurement permitted and/or product subject to incremental optimization |
|
|
SSMTH |
Safety stock method |
|
|
PLREL |
X if PPM/PDS relevant for planning |
|
ET_PROGRP
This table contains the master data of the product groups for which you can define quota arrangements.
|
MATID |
Product ID |
|
PROGR |
Product group |
ET_QTAHEAD
This table contains the header master data of the quota arrangements.
|
QTAID |
Unique key for quota arrangement header |
|
LOCID |
Location ID |
|
MATID |
Product ID |
|
PROGR |
Product group |
|
VALFR |
Valid-from date |
|
VALTO |
Valid-to date |
ET_QTAITEM
This table contains the item master data of the quota arrangements.
|
QTAID |
Unique key for quota arrangement header |
|
SRCLO |
Source location ID |
|
ARCID |
Relationship between two locations |
|
PROID |
Source PPM |
|
FPERF |
Switch external procurement (‘X’ = external procurement, ‘ ‘ = otherwise) |
|
QUOTA |
Quota arrangement number |
|
LOPEN |
Penalty for deviation below target quantity |
|
UPPEN |
Penalty for deviation above upper quantity |
ET_RCPBND
This table contains the data for the receipt bound that you can define as a time-based constraint.
|
LOCID |
Location ID |
|
MATID |
Product ID |
|
BUCKE |
Bucket |
|
LOWBN |
Lower limit |
|
UPPBN |
Upper limit |
|
LOPEN |
Penalty for deviation below lower bound |
|
UPPEN |
Penalty for deviation above upper bound |
|
BNDFL |
Upper limit active flag |
ET_RESOURCE
Production resources that are used in the production process models are listed here (see the ET_PRORES section below). UNIVO is currently always equal to 1.
|
RESID* |
Resource GUID |
|
|
RFAID |
Resource family GUID (currently the same as resource) |
|
|
UNIVO |
Unitary volume |
BRes |
|
KAMPA |
Flag: Resource is a campaign resource |
|
|
SETID |
ID of setup matrix |
|
ET_SETUPMATRIX
This table contains the data for the setup matrix.
|
SETID |
Setup matrix ID |
|
GRFRO |
Setup group ID |
|
GROTO |
Setup group ID |
|
SCOST |
Setup cost |
|
STIME |
Setup times in sec. |
ET_RESFAM
Production resources are allowed to be extended here if a second capacity variant has been defined in the resource master. The resource family is currently always the same as the production resources (one-to-one).
|
RFAID* |
Resource family ID |
|
MAXFL |
Flag: Resource has a capacity constraint |
|
DISCR |
Prof: Flag: Discrete increase of resource family |
ET_FLEET
Fleet refers to the transportation resource that has been specified for a transportation lane. A possible extension and the costs related to it are determined from the resource’s second capacity variant.
|
FLEID* |
Fleet GUID |
|
|
MAXFL |
Flag: Consider maximum fleet capacity |
|
|
TUNIA |
Capacity 1 of one truck |
TraUn1 |
|
TUNIB |
Capacity 2 of one truck (not used) |
TraUn2 |
|
TUNIC |
Capacity 3 of one truck (not used) |
TraUn3 |
ET_ARC
All the transportation lanes that have been defined for the model in the Supply Chain Engineer are listed here. ARC refers to a transportation lane/means of transport combination.
|
ARCID* |
Arc GUID |
|
|
FLEID |
Fleet GUID |
|
|
LOCFR |
Location from GUID |
|
|
LOCTO |
Location to GUID |
|
|
TTYPE |
ID for means of transport |
|
|
DURAT |
Duration of shipment (base time unit) |
BTime |
|
RNDTR |
Bucket offset (rounding limit for transportation times) |
|
|
TCTYP |
Variable transportation cost for the fleet |
BCurr/TraUn1 |
|
DISCR |
Flag: Using discrete transportation fleets |
|
|
RLDUR |
Resource load duration |
BTime |
ET_ARCMAT
Product-dependent properties for the transportation lane are shown here. Data is taken from the Supply Chain Engineer. Standard entries are generated if the product has not been assigned to the transportation lane and the All Products indicator has been set at the transportation lane. The lot size information is taken from the lot size profile (transportation lanes) defined at the transportation lane.
|
ARCID* |
Arc GUID |
|
|
MATID* |
Product GUID |
|
|
VALTO |
Valid to date (base unit of time) |
BTime |
|
VALFR |
Valid from date (base unit of time) |
BTime |
|
MINLO |
Minimum number of lots |
TRVOL |
|
MAXLO |
Maximum number of lots |
TRVOL |
|
MAXFL |
Flag: MAXLO active |
|
|
TRVOL |
Lot size in product units |
BProd |
|
TCONA |
Capacity consumption for 24 hours |
TraUn1/BProd |
|
TCONB |
Capacity consumption for the transportation time that is less than 24 hours |
TraUn1/BProd |
|
TCONC |
Capacity consumption (not used) |
|
|
TCOST |
Variable transportation cost for "arc product" |
BCurr/BProd |
|
SUBCO |
Flag: ‘X’ Product will be subcontracted |
|
ET_LOCC
The handling resource’s available capacity is listed here. Figures are determined from the resource’s first capacity variant. Gaps in the intervals are defined by the resource calendar or shipping calendar of the location.
|
RESID* |
Handling resource GUID |
|
|
VALTO* |
Valid to date (base unit of time) |
BTime |
|
VALFR |
Valid from date (base unit of time) |
BTime |
|
MAXHA |
Handling capacity |
HanUn/BTime |
|
COUND |
Minimum resource consumption |
|
|
UNPEN |
Penalty per unitary volume dropping minimum capacity |
BCurr/Univo |
ET_LOCUC
A possible extension of the handling resource’s available capacity is listed here. Figures are determined from the resource’s second capacity variant by subtracting the first capacity variant values. Gaps in the intervals are defined by the resource calendar or shipping calendar of the location.
|
RESID* |
Handling resource GUID |
|
|
VALTO* |
Valid to date (base unit of time) |
BTime |
|
VALFR |
Valid from date (base unit of time) |
BTime |
|
INCHA |
Upper bound for increasing handling capacity |
HanUn/BTime |
|
INPEN |
Penalty per unitary volume for increasing capacity |
BCurr/Univo |
ET_SUBLOCC
The storage resource’s available capacity is listed here. Figures are determined from the resource’s first capacity variant. The interval gaps are defined by the resource calendar.
|
SUBID* |
Sublocation GUID |
|
|
VALTO* |
Valid to date (base unit of time) |
BTime |
|
VALFR |
Valid from date (base unit of time) |
BTime |
|
MAXSL |
Capacity volume of storage (sublocation) |
StoUn |
|
COUND |
Minimum resource consumption |
|
|
UNPEN |
Penalty per unitary volume dropping minimum capacity |
BCurr/Univo |
ET_SUBLOCUC
A possible extension of the storage resource’s available capacity at a location is listed here. Figures are determined from the resource’s second capacity variant by subtracting the first capacity variant values. The interval gaps are defined by the resource calendar.
|
SUBID* |
Sublocation (storage) GUID |
|
|
VALTO* |
Valid to date (base unit of time) |
BTime |
|
VALFR |
Valid from date (base unit of time) |
BTime |
|
INCSL |
Upper bound for increasing storage capacity |
StoUn |
|
INPEN |
Penalty per unitary volume for increasing capacity |
BCurr/Univo |
ET_RESC
The production resource’s available capacity is listed here. Figures are determined from the resource’s first capacity variant. The interval gaps are defined by the resource calendar.
|
RESID* |
Resource GUID |
|
|
VALTO* |
Valid to date (base unit of time) |
BTime |
|
VALFR |
Valid from date (base unit of time) |
BTime |
|
MAXRE |
Production resource capacity |
BRes/BTime |
|
COUND |
Minimum resource consumption |
|
|
UNPEN |
Penalty per unitary volume dropping minimum capacity |
BCurr/Univo |
|
CCOST |
Cost per unitary volume for capacity |
BCurr/Univo |
ET_RESFAMC
A possible extension of the production resource’s available capacity is listed here. Figures are determined from the resource’s second capacity variant by subtracting the first capacity variant values. The interval gaps are defined by the resource calendar.
|
RFAID* |
Resource family GUID |
|
|
VALTO* |
Valid to date (base unit of time) |
BTime |
|
VALFR |
Valid from date (base unit of time) |
BTime |
|
INCRF |
Upper bound for increasing production resource |
Univo/BTime |
|
INPEN |
Penalty per unitary volume for increasing capacity |
BCurr/Univo |
ET_FLEETC
The transportation resource’s available capacity is listed here. Figures are determined from the resource’s first capacity variant. The interval gaps are defined by the resource calendar.
|
FLEID* |
Fleet GUID |
|
|
VALTO* |
Valid to date (base unit of time) |
BTime |
|
VALFR |
Valid from date (base unit of time) |
BTime |
|
MAXFL |
Capacity measured in trucks |
Truck/BTime |
|
COUND |
Minimum resource consumption |
|
|
UNPEN |
Penalty per unitary volume dropping minimum capacity |
BCurr/Truck |
ET_FLEETUC
A possible extension of the transportation resource’s available capacity is listed here. Figures are determined from the resource’s second capacity variant by subtracting the first capacity variant values. The interval gaps are defined by the resource calendar.
|
FLEID* |
Fleet GUID |
|
|
VALTO* |
Valid to date (base unit of time) |
BTime |
|
VALFR |
Valid from date (base unit of time) |
BTime |
|
INCFL |
Upper bound for increasing fleet capacity |
Truck/BTime |
|
INPEN |
Penalty per unitary volume for increasing capacity |
BCurr/Truck |
ET_PROMO
The properties of the production process model (plan or PPM) are stored here. A prerequisite, however, is that the PPM has been assigned to the model in the Supply Chain Engineer. This information is defined in master data maintenance for the PPM. Time-dependent PPMs are converted into multiple entries for the optimizer, and the validity period of each one is set accordingly. The master resource is the PPM calendar resource.
|
PROID* |
Production process model GUID |
|
|
LOCID |
Location GUID |
|
|
MATID |
Product GUID |
|
|
LOTSZ |
Fixed lot size of the location product |
BProd |
|
BCKTO |
Valid to date in buckets |
|
|
BCKFR |
Valid from date in buckets |
|
|
PMINQ |
Minimum production lot size |
ProMod |
|
PMAXQ |
Maximum production lot size |
ProMod |
|
MAXFL |
Flag: PMAXQ active |
|
|
DURAT |
Duration: 0 = one day, 1 = two days |
BTime |
|
DISCR |
Flag for using discrete production |
|
|
PCOST |
Variable cost of PPM |
BCurr/ProMod |
|
RNDPR |
Bucket offset |
|
|
RESID |
Resource GUID for calendar |
|
|
GRFRO |
Setup group of this PPM/PDS |
|
|
PLREL |
X if PPM/PDS relevant for planning |
|
ET_PRORES
Consumption of production resources for the PPM is listed here, as defined in the production process model master data in Mode → Bucket consumption.
|
PROID* |
Production process model GUID |
|
|
RESID* |
Resource GUID |
|
|
OFSTO* |
Consumption time offset |
BTime |
|
BCKTO* |
Valid to date of bucket interval |
|
|
VCONS |
Variable consumption of the resource |
BRes |
|
FCONS |
Fixed consumption of the resource |
BRes |
ET_PROMAT
The product flow for the PPM, as defined in the Products section of production process model master data, is listed here. It represents the bill of materials (BOM) structure, where finished products have a plus sign and input products a minus sign.
|
PROID* |
Production process model GUID |
|
|
MATID* |
Product GUID |
|
|
OFSTO* |
Input/output time offset |
BTime |
|
LOCID* |
Location GUID |
|
|
BCKTO* |
Valid to date of bucket interval |
|
|
OUTIN |
Output(+) or input(-) quantity |
BProd |
|
FCONS |
Fixed input(-) quantity |
BProd |
ET_RESINI
This table contains the initial setup statuses of the resources for cross-period lot size planning (set up or not set up).
|
RESID* |
Resource GUID |
|
|
PROID* |
Production process model GUID |
|
|
EDATE* |
End date |
BTime |
|
BDATE* |
Start date |
BTime |
|
QUANT |
Output quantity for master product |
BProd |
|
APPLI |
Application: P->PP/DS S->SNP |
|
|
SETUP |
Flag: Order with setup |
|
|
SEQID |
Sequence ID |
|
ET_LOCPROD
The required safety stock (target stock levels), fixed demands (FPROD with minus sign), and receipts for the products are defined in this table. The latter entries result from planned orders and stock transfers that had been fixed before the optimizer was run. This fixing is done both manually and when orders are transferred to the PP/DS application. Receipts and issues are also fixed when the optimizer has been run incrementally (for a subset of products from the model).
|
LOCID* |
Location GUID |
|
|
MATID* |
Product GUID |
|
|
BUCKE* |
Date bucket of safety stock and FPROD |
|
|
SAFTY |
Safety stock (not a demand!) |
BProd |
|
MAXST |
Maximum stock level of the product |
BProd |
|
SAPEN |
Penalty for not covering safety stock |
BCurr/BProd |
|
STPEN |
Penalty for violating the maximum stock level |
BCurr/BProd |
|
FPROD |
Confirmed production, includes intransit quantities |
BProd |
|
SVTTY |
Safety days’ supply |
|
|
FDIST |
Aggregated distribution quantity |
|
|
FSUBST |
Aggregated substitution quantity |
|
ET_DEMCLTIM
The maximum delay that is to be allowed for finished products is defined here. The values are taken from the product master (the SNP 1 tab). There are currently only three categories: 1 for customer demands, 2 for corrected demand forecasts, and 3 for demand forecasts. Costs for delivering the finished products late, or for not delivering them are also defined. The values are taken from the product master (the SNP 1 tab). The values are not defined as time-dependent in SAP APO, meaning that BCKTO is the same as the planning end date.
|
DEMCL* |
Demand class (highest priority = 1) |
|
|
LOCID* |
Location GUID |
|
|
MATID* |
Product GUID |
|
|
BCKTO* |
Valid to bucket |
|
|
LAPEN |
Penalty for lateness |
BCurr/(BTime*BProd) |
|
MAXLA |
Maximum lateness |
BTime |
|
NDPEN |
Penalty for not delivering |
BCurr/BProd |
ET_DEMAND
This table contains all the customer demands and forecast demands that have been read for the model from liveCache.
|
LOCID* |
Location GUID |
|
|
MATID* |
Product GUID |
|
|
DEMCL* |
Demand class (highest priority = 1) |
|
|
BUCKE* |
Demand date given in bucket |
|
|
DEMAN |
Quantity of demand |
BProd |
ET_PROCBND
Target procurement corridor.
|
LOCID* |
Location GUID |
|
|
MATID* |
Product GUID |
|
|
BUCKE* |
Bucket |
|
|
LOWBN |
Lower bound |
BProd |
|
UPPBN |
Upper bound |
BProd |
|
INITV |
Initial value (result of previous run) |
BProd |
|
BNDFL |
Flag: Upper bounds are active |
|
ET_PRODBND
Target production corridor.
|
PROID* |
Production process model GUID |
|
|
BUCKE* |
Bucket |
|
|
LOWBN |
Lower bound |
ProMod |
|
UPPBN |
Upper bound |
ProMod |
|
INITV |
Initial value (result of previous run) |
ProMod |
|
BNDFL |
Flag: Upper bounds are active |
|
ET_TRANBND
Target stock transfer corridor.
|
ARCID* |
Arc GUID |
|
|
MATID* |
Product GUID |
|
|
BUCKE* |
Bucket |
|
|
LOWBN |
Lower bound |
BProd |
|
UPPBN |
Upper bound |
BProd |
|
INITV |
Initial value (result of previous run) |
BProd |
|
BNDFL |
Flag: Upper bounds are active |
|
ET_STCKBND
Target stock level corridor.
|
LOCID* |
Location GUID |
|
|
MATID* |
Product GUID |
|
|
BUCKE* |
Bucket |
|
|
LOWBN |
Lower bound |
BProd |
|
UPPBN |
Upper bound |
BProd |
|
INITV |
Initial value (result of previous run) |
BProd |
|
BNDFL |
Flag: Upper bounds are active |
|
ET_DELIBND
Target demand fulfillment corridor.
|
LOCID* |
Location GUID |
|
|
MATID* |
Product GUID |
|
|
DEMCL* |
Demand class (highest priority = 1) |
|
|
DELAY* |
Lateness measured in buckets |
|
|
BUCKE* |
Bucket |
|
|
LOWBN |
Lower bound |
BProd |
|
UPPBN |
Upper bound |
BProd |
|
INITV |
Initial value (result of previous run) |
BProd |
|
BNDFL |
Flag: Upper bounds are active |
|
ET_TRANCOS
Stock transfer cost functions are defined here. These functions are analyzed on the basis of this formula: Cost = FIXCO + VARCO* (X – ORIGN). The cost function is assigned to the product-dependent transportation lane in the Supply Chain Engineer.
|
ARCID* |
Arc GUID |
|
|
ORIGN* |
Smallest value |
TraUn1 |
|
FIXCO |
Fixed cost |
BCurr |
|
VARCO |
Variable cost |
BCurr/TraUn1 |
ET_PRODCOS
Production cost functions are defined here. These functions are analyzed on the basis of this formula: Cost = FIXCO + VARCO* (X – ORIGN). The cost function is assigned to the plan in master data maintenance for the production process model.
|
PROID* |
Production process model GUID |
|
|
ORIGN* |
Smallest value |
ProMod |
|
FIXCO |
Fixed cost |
BCurr |
|
VARCO |
Variable cost |
BCurr/ProMod |
ET_PROCCOS
Procurement cost functions are defined here. These functions are analyzed on the basis of this formula: Cost = FIXCO + VARCO* (X – ORIGN). This cost function is assigned to the product in the location product master.
|
LOCID* |
Location GUID |
|
|
MATID* |
Product GUID |
|
|
ORIGN* |
Smallest value |
BProd |
|
FIXCO |
Fixed cost |
BCurr |
|
VARCO |
Variable cost |
BCurr/BProd |
ET_CHAIN
This table contains the master data for the supersession chains (product interchangeability).
|
GROUPID |
Interchangeability group identification |
|
LOCID |
Location ID |
|
PRODOLD |
Old product ID |
|
PRODNEW |
New product ID |
|
VALIDFROM |
Validation date from |
|
DIRECTION |
Direction of interchangeability (‘F’ = forward, ‘I’ = full ) |
|
USEUP |
Use-up date |
ET_FFF
This table contains the master data for form-fit-function classes (FFF classes, product interchangeability).
|
GROUPID |
Interchangeability group identification |
|
LOCID |
Location ID |
|
PRODID |
Product ID |
|
LEADPRODFLAG |
Flag for leading product (‘X’ = leading product, space = non-leading product) |