1.Functional Description
This business function will Create/Update Current Component Costs in F3102 Variance Master file.
It will also accumulate the Material and Scrap Costs in order to obtain Parent Material Costs.
1.1Purpose
This is to be used to Create/Update the Current Costs for the Components in the WO Variance file.
1.2Setup Notes and Prerequisites
The Input Data for the business function is obtained from the Parts List Record (F3111). The
Operation Quantity and the Scrap Quantity are obtained from the Copy Parts List From BOM (B3100550).
1.3Special Logic
2.Technical Specifications
2.4Processing
The following actions have to be performed by the Business Function.
1. Calculate the Total Standard Component rate from the Cost Component Table (F30026).
Wk TCSL = 0.
Load th following fields for the Cost Component Table
ITM = Input CPITMMCU = Input CMCULOCN = Blanks
LOTN = Blanks LEDG ='07'
Do Until End of file
Read a row from the F30026 table using the above partial keys
If row found
Wk TCSL = Wk TCSL + IECSL
Endif
End
2. Convert the Operation Quantity from Primary to Input UM for loading units to the Variance table
Get Item Master (F4101) using Input CPIT as the key.
Get Line Type using Input LNTY from F40205.
If LFIVI = 'Y'/'D'
Wk UM = IMUOM1
Else
Wk UM = Input UM.
Endif
Wk CNVF = 1.0.
If Input UM <> Wk UM
Get Item Balance (F4102) using Input CPIT and Input CMCU as the keys.
Get Item Location (F41021) using Input CPIT, CMCU, LOCN, LOTN.
Wk LOTN = Blanks.
If LIPBIN <> 'P'
Wk LOTN = LILOTN
Endif
Get Conversion Factor Using Business Function (B4100520) From Wk UM to Input UM.
If No Errors
Wk CNVF = Output from B4100520.
Endif
Endif.
Wk CCCU = Wk CNVF * Input SOQS
3. Calculate the Component Cost and Scrap Costs
Wk CCCA = Wk TCSL * Input SOQS
Wk SCCCA = Wk TCSL * Input SOCN
4. Create or Update the Variance record for the Component
Read the Variance table(F3102) using Input DOCO and CPIT as the key.
If the row is found
IGCCCU = IGCCCU + Wk CCCU
IGCCCA = IGCCCA + Wk CCCA.
IGUOM = Input UM
Update F3102
Else
IGCCCU = Wk CCCU
IGCCCA = Wk CCCA
IGUOM = Input UM
IGPART = 'C'
IGDOCO = Input DOCO
IGITM = Input ITM
IGLITM = Input LITM
IGAITM = Input AITM
Load Audit information
IGPID = Input PID
Write F3102 row.
Endif
5. Accumulate the Total Costs in Order to determine Parent Material Costs and Output it.
Output Cost CCCA = Output Cost CCCA + Wk CCCA.
Output Scrap CCCA = Output Scrap CCCA + Wk SCCCA.
^
D3100560 - Update Current Component Costs
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
mnDocumentNumber | DOCO | MATH_NUMERIC | NONE | NONE |
A number that identifies an original document. This document can be a voucher, a sales order, an invoice, unapplied cash, a journal entry,
| ||||
mnShortItemNumber | CPIT | MATH_NUMERIC | NONE | NONE |
The short identifier for the component item number. | ||||
szLongItemNumber | CPIL | char | NONE | NONE |
The system provides three separate item numbers.
They are:
1. Item Number (short) - An eight digit, computer assigned, completely
| ||||
szAlphaItemNumber | CPIA | char | NONE | NONE |
The system provides three separate item numbers plus an extensive cross reference capability to alternate item numbers.
These item
| ||||
szBranch | CMCU | char | NONE | NONE |
A secondary or lower-level business unit. The system uses the value that you enter to indicate that a branch or plant contains several
| ||||
szCompLocation | LOCN | char | NONE | NONE |
The storage location from which goods will be moved. | ||||
szCompLotNumber | LOTN | char | NONE | NONE |
A number that identifies a lot or a serial number. A lot is a group of items with similar characteristics. | ||||
mnOperationQtyInPrimary | SOQS | MATH_NUMERIC | NONE | NONE |
The number of units committed for shipment in Sales Order Entry, using either the entered or the primary unit of measure defined for this
| ||||
mnScrapQtyInPrimary | SOCN | MATH_NUMERIC | NONE | NONE |
The number of units canceled in Sales Order or Work Order Processing, using either the entered or the primary unit of measure defined for
| ||||
szCompUnitOfMeasure | UM | char | NONE | NONE |
A user defined code (00/UM) that identifies the unit of measurement for an amount or quantity. For example, it can represent a barrel, box,
| ||||
szLineType | LNTY | char | NONE | NONE |
A code that controls how the system processes lines on a transaction. It controls the systems with which the transaction interfaces, such as
| ||||
szProgramID | PID | char | NONE | NONE |
The number that identifies the batch or interactive program (batch or interactive object). For example, the number of the Sales Order Entry
| ||||
cSuppressErrorMessage | EV01 | char | NONE | NONE |
An option that specifies the type of processing for an event. | ||||
mnCurrentCosts | CCCA | MATH_NUMERIC | NONE | NONE |
The current amount to produce a given amount of product. | ||||
mnCurrentScrapCosts | CCCA | MATH_NUMERIC | NONE | NONE |
The current amount to produce a given amount of product. | ||||
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
|
B4000460 Free Ptr To Data Structure | ||||
B4000520 Get Item UoM Conversion Factor | ||||
B9800100 Get Audit Information | ||||
X4101 Validate and Retrieve Item Master | ||||
XF41021 Update F41021 Locations |
F30026 Item Cost Component Add-Ons | ||||
F3102 Production Cost | ||||
F40205 Line Type Control Constants File | ||||
F4101 Item Master | ||||
F4102 Item Branch File | ||||
F41021 Item Location File |