1.Functional Description
1.1Purpose
The purpose of this function is to check the existence of the MRP parameters and return the values to
the program. This is executed once in the beginning of the MRP program to get the common values to be
used for all the items in the run.
1.2Setup Notes and Prerequisites
None
1.3Special Logic
None.
2.Technical Specifications
1. Open Tables and Initialize Data
Open F0005 table
If Error in Opening, Exit function with Error Code = '1'
Initialize all Output @Q, Messages flag and File flags to blanks
Output $$MRP = 'N'
2. Get Quantity Type Data
Do While Wk Exit flag <> '1'
Read F0005 using SY (='34') and Input RT as keys Sequentially
If not found
Break
Endif
Begin Case
Case KY = '05'
Output @Q[05] = '1'
Break
Case KY = '10'
Output @Q[10] = '1'
Break
Case KY = '13'
Output @Q[13] = '1'
Break
Case KY = '15'
Output @Q[15] = '1'
Break
Case KY = '20'
Output @Q[20] = '1'
Break
Case KY = '25'
Output @Q[25] = '1'
Break
Case KY = '30'
Output @Q[30] = '1'
Break
Case KY = '35'
Output @Q[35] = '1'
Break
Case KY = '40'
Output @Q[40] = '1'
Break
Case KY = '42'
Output @Q[42] = '1'
Break
Case KY = '45'
Output @Q[45] = '1'
Break
Case KY = '50'
Output @Q[50] = '1'
Break
Case KY = '52'
Output @Q[52] = '1'
Break
Case KY = '55'
Output @Q[55] = '1'
Break
Case KY = '60'
Output @Q[65] = '1'
Break
Case KY = '70'
Output @Q[70] = '1'
Break
Case KY = '75'
Output @Q[75] = '1'
Break
Case KY = '80'
Output @Q[80] = '1'
Break
Case KY = '85'
Output @Q[85] = '1'
Break
Case KY = '90'
Output @Q[90] = '1'
Break
Case KY = '95'
Output @Q[95] = '1'
Break
Case KY = '96'
Output @Q[96] = '1'
Break
Case KY = '97'
Output @Q[97] = '1'
Break
Case KY = '98'
Output @Q[98] = '1'
Break
Case KY = '99'
Output @Q[99] = '1'
Break
EndCase
End While
3. Get Message Type Data
Get Data Dictionary Value (SY) and (RT) for 'MSGT' DD field
Get F0005 row using SY and RT from DD and KY = 'A'
If found
@$A = '1'
Endif
Get F0005 row using SY and RT from DD and KY = 'F'
If found
@$F = '1'
Endif
Get F0005 row using SY and RT from DD and KY = 'G'
If found
@$G = '1'
Endif
Get F0005 row using SY and RT from DD and KY = 'L'
If found
@$L = '1'
Endif
Get F0005 row using SY and RT from DD and KY = 'T'
If found
@$T = '1'
Endif
4. Check and Set File Existence flags
If Input $$GEN = '3'/'4'/'5'
$$MRP = 'Y'
Open F3412 Table
If @Q[25/30] = '1'
Open F3111 table
Endif
If Any Open failed
$$MANP = '1'
Endif
Endif
If @Q[25/30/70/75] = '1'
Open F4801 table
If Open failed
$$MANH = '1'
Endif
Endif
If Input Forecast Consumption Logic Flag = '1' then
Open F3405
If Failed then
Set Input Forecast Consumption Logic Flag = ' '
End If
End If
If Input Forecast Consumption Logic Flag And Output @Q[52] = '1' then
Open F3463
If Failed then
Set Output @Q[52] =' '
End If
End If
Open F3404.
If Failed then
Set Output F3404 Code = '2'
Else
Set Output F3404 Code = '1'
End iF
If Input Consolidation Method = '2'
Open F3403
If Failed
Set Input Consolidation Method = '1'
End If
End If
Close all Opened Tables
D3400490 - MRP, Get MRP Parameters
| Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
|---|---|---|---|---|
| szReportingCode | RT | char | NONE | NONE |
A code that identifies the table that contains user defined codes. The table is also referred to as a UDC type. | ||||
| cGenerationType | EV01 | char | NONE | NONE |
An option that specifies the type of processing for an event. | ||||
| cBegAvailUnadjusted | EV01 | char | NONE | NONE |
An option that specifies the type of processing for an event. | ||||
| cBeginningAvailable | EV02 | char | NONE | NONE |
An option that specifies the type of processing for an event. | ||||
| cReceiptRouting | EV03 | char | NONE | NONE |
A radio button that specifies the level at which trace/track result is to be displayed. Select the Detail to display all transactions except IB, IX,
| ||||
| cPurchOrderUnadjusted | EV04 | char | NONE | NONE |
PeopleSoft event point processing flag 04. | ||||
| cPurchOrderAdjusted | EV05 | char | NONE | NONE |
A flag that indicates whether automatic spell check is turned on. | ||||
| cWorkOrderUnadjusted | EV06 | char | NONE | NONE |
An option that specifies the type of processing for an event. | ||||
| cWorkOrderAdjusted | EV07 | char | NONE | NONE |
An option that specifies the type of processing for an event. | ||||
| cRateScheduleUnadjusted | EV08 | char | NONE | NONE |
An option that specifies the type of processing for an event. | ||||
| cRateScheduleAdjusted | EV09 | char | NONE | NONE |
An option that specifies the type of processing for an event. | ||||
| cLotExpiration | EV10 | char | NONE | NONE |
An option that specifies the type of processing for an event. | ||||
| cForecastUnadjusted | EV01 | char | NONE | NONE |
An option that specifies the type of processing for an event. | ||||
| cForecastAdjusted | EV02 | char | NONE | NONE |
An option that specifies the type of processing for an event. | ||||
| cSalesOrderUnadjusted | EV03 | char | NONE | NONE |
A radio button that specifies the level at which trace/track result is to be displayed. Select the Detail to display all transactions except IB, IX,
| ||||
| cSalesOrderAdjusted | EV04 | char | NONE | NONE |
PeopleSoft event point processing flag 04. | ||||
| cInterPlantDemand | EV05 | char | NONE | NONE |
A flag that indicates whether automatic spell check is turned on. | ||||
| cPartsListUnadjusted | EV06 | char | NONE | NONE |
An option that specifies the type of processing for an event. | ||||
| cFirmPartsList | EV07 | char | NONE | NONE |
An option that specifies the type of processing for an event. | ||||
| cPlanPartsList | EV08 | char | NONE | NONE |
An option that specifies the type of processing for an event. | ||||
| cEndingAvailUnadjusted | EV09 | char | NONE | NONE |
An option that specifies the type of processing for an event. | ||||
| cEndingAvailable | EV10 | char | NONE | NONE |
An option that specifies the type of processing for an event. | ||||
| cPlannedOrders | EV01 | char | NONE | NONE |
An option that specifies the type of processing for an event. | ||||
| cATPUnadjusted | EV02 | char | NONE | NONE |
An option that specifies the type of processing for an event. | ||||
| cATPAdjusted | EV03 | char | NONE | NONE |
A radio button that specifies the level at which trace/track result is to be displayed. Select the Detail to display all transactions except IB, IX,
| ||||
| cCATPUnadjusted | EV04 | char | NONE | NONE |
PeopleSoft event point processing flag 04. | ||||
| cCATPAdjusted | EV05 | char | NONE | NONE |
A flag that indicates whether automatic spell check is turned on. | ||||
| cActionMessage | EV06 | char | NONE | NONE |
An option that specifies the type of processing for an event. | ||||
| cFrozenOrderMessage | EV07 | char | NONE | NONE |
An option that specifies the type of processing for an event. | ||||
| cIncreaseOrderMessage | EV08 | char | NONE | NONE |
An option that specifies the type of processing for an event. | ||||
| cDecreaseOrderMessage | EV09 | char | NONE | NONE |
An option that specifies the type of processing for an event. | ||||
| cPastDueOrderMessage | EV10 | char | NONE | NONE |
An option that specifies the type of processing for an event. | ||||
| cWOFileExists | EV01 | char | NONE | NONE |
An option that specifies the type of processing for an event. | ||||
| cPartsListExists | EV02 | char | NONE | NONE |
An option that specifies the type of processing for an event. | ||||
| cMultiLevelFlag | EV03 | char | NONE | NONE |
A radio button that specifies the level at which trace/track result is to be displayed. Select the Detail to display all transactions except IB, IX,
| ||||
| cSuppressErrorMessage | EV01 | char | NONE | NONE |
An option that specifies the type of processing for an event. | ||||
| szErrorMessageID | DTAI | char | NONE | NONE |
A code that identifies and defines a unit of information. It is an alphanumeric code up to 8 characters long that does not allow blanks or
| ||||
| cErrorCode | ERRC | char | NONE | NONE |
This error code indicates if any errors occurred during the creation of the Trip Document Detail (F4914) records by the Delivery Document
| ||||
| cShippedAdjusted | EV02 | char | NONE | NONE |
An option that specifies the type of processing for an event. | ||||
| cForecastConsumptionFlag | EV04 | char | NONE | NONE |
PeopleSoft event point processing flag 04. | ||||
| cF3404TableExistenceCode | EV01 | char | NONE | NONE |
An option that specifies the type of processing for an event. | ||||
| cConsolidationMethod | EV02 | char | NONE | NONE |
An option that specifies the type of processing for an event. | ||||
| cFirmInterplantDemand | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
| cTotalIndependentDemandUnadj | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
| cTotalIndependentDemandAdj | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
| cFirmInterplantDemandUnadj | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
| szPlanningControlUDCType | RT | char | OPT | NONE |
A code that identifies the table that contains user defined codes. The table is also referred to as a UDC type. | ||||
| None |
| F0005 User Defined Codes | ||||
| F3111 Work Order Parts List | ||||
| F3403 Branch Relationships Master File | ||||
| F3404 Co-Products Planning/Costing Table | ||||
| F3405 Forecast Consumption Periods | ||||
| F3412 MPS/MRP/DRP Lower Level Requirements File | ||||
| F3462 Forecast Shipment Summary | ||||
| F4101 Item Master | ||||
| F4102 Item Branch File | ||||
| F4801 Work Order Master File |