ERP Production Export

Last modified by Peter Karlsson on 2023/03/31 07:48

Format

Text file, tab-separated values. Numer of columns is 22.

Contents

The export file contains order products and stock items with status Produced.

After the export elements are signed as exported (IMP_CAST_PLANNING.Is_Reported1 = 1)

Configuration

    <!-- Exported file directories -->
    <add key="ERPProductionDirectory" value="C:\IMPACT\StruSoft\ERPProduction\Out" />

    <!-- Rejection reason codes for Move Type - default values is 551 --> (Releases in Q2 2023)
    <add key="Konstruktion" value="221" />
    <add key="Montage" value="222" />

Mapped to the Reason text if the Reason text doesn't match 551 will be used.

image-20230331074708-1.png

Signing Exported Elements

After the production export, the following tables are updated

  • IMP_CAST_PLANNING.IsReported1 is set to 1 (which means that the element is exported to SAP)
  • IMP_ERRAND.Is_Reported1 is set to 1 if the element is rejected
  • IMP_ELEMENT.ITEM_NR_1 is updated with the value: ProjectExternalName + "-" + IMP_ELEMENT.Element_Grp + "000"

Details

When the export function is triggered, it generates 1 file per production factory.

The table IMP_ELEMENT_GRP_STD contains the units e.g. M2, TO, ST

Here is an example of how the file looks like.

File name: INT_SE97GoodsRcptDld_20150814_144811.txt

1220052979-37000        SEYE    1046    470    470    KG        PL2160    1220052979    2021-01-13    2021-01-13    1000    521        4.47    M2    0.7    X    SE97    01    SL010    P6000-764    1    0
1220052979-37000        SEYE    1076    510    510    KG        PL2149    1220052979    2021-01-13    2021-01-13    1000    521        5.02    M2    0.7    X    SE97    01    SL010    P6000-753    0    0
1220052979-37000        SEYE    1083    440    440    KG        PL2151    1220052979    2021-01-13    2021-01-13    1000    521        3.82    M2    0.7    X    SE97    01    SL010    P6000-755    0    0
1220052979-37000        SEYE    1134    490    490    KG        PL2146    1220052979    2021-01-13    2021-01-13    1000    521        4.18    M2    0.8    X    SE97    01    SL010    P6000-750    1    0

Here is an example in table form to show individual columns:

12345678910111213141516171819202122232425
1220050000-312000 SYYY1146549814981KG V6112200500002018-09-262018-09-261000521 15.40M213.8XSE971SL010P6000-76400
1220050000-312000 SYYY504314851485KG V4312200500002018-09-262018-09-261000521 04.37M27.0XSE971SL010P6000-76400
1220050000-312000 SYYY748923172317KG V24512200500002018-09-262018-09-261000521 08.14M210.0XSE971SL010P6000-76400
1220050000-332000 SYYY837829172917KG W1212200500002018-09-262018-09-261000521 07.12M210.1XSE971SL010P6000-76400
1220050000-332000 SYYY1081122672267KG W6312200500002018-09-262018-09-261000521 06.23M213.5XSE971SL010P6000-76400
1220050000-332000 SYYY927743404340KG W1212200500002018-09-262018-09-261000521 12.31M211.0XSE971SL010P6000-76400
1220050000-332000 SYYY927743404340KG W1212200500002018-09-262018-09-261000521 12.31M211.0XSE971SL010P6000-76400
1220050000-332000 SYYY970738583858KG W2012200500002018-09-262018-09-261000521 11.21M212.4XSE971SL010P6000-76400
1220054957-312000 SYYY1353269396939KG V1212200549572018-09-262018-09-261000521 19.43M213.5XSE971SL010P6000-76400
1220054957-332000 SYYY1632570057005KG W1712200549572018-09-262018-09-261000521 19.43M217.6XSE971SL010P6000-76400
1220054957-332000 SYYY1710669956995KG W1812200549572018-09-262018-09-261000521 19.40M219.1XSE971SL010P6000-76400
1220054957-332000 SYYY1798378437843KG W1212200549572018-09-262018-09-261000521 22.11M219.6XSE971SL010P6000-76400
1220055036-332000 SYYY1761472197219KG W1212200550362018-09-262018-09-261000521 19.39M219.6XSE971SL010P6000-76400
1220055036-332000 SYYY1840779067906KG W1512200550362018-09-262018-09-261000521 22.30M220.3XSE971SL010P6000-76400

Column Description

Column NoNameOrdered Products Stock Items
1Old MaterialSales Order Name + "-" + Element Group + "000" Sales Order Name
2MaterialEmpty Empty
3PlantExterna Factory Name (RM/Settings/Factories) Externa Factory Name (RM/Settings/Factories)
4PricePrice 0
5Gross WeightElement Mass (KG) 0
6Net WeightElement Mass (KG) 0
7Unit Of WeightKG KG
8Wbs ElementEmpty Empty
9PositionElement Mark Element Mark
10ERP Order NbrSales Order Name (PM/Properties) Sales Order Name (PM/Properties)
11Posting DateThe date when the sync file was created YYYY-MM-DD
12Document DateThe date when the sync file was created YYYY-MM-DD
13Storage Location1000 (Hard coded) 1000 (Hard coded)
14Move Type

CODE 521: Element is neither rejected not reported
CODE 551: Element  is reported and rejected but not reported as rejected

Connected to the Reason in the rejection

 521 (Hard coded)
15Spec StockEmpty Empty
16Entry QuantitySee table below Count
17Unit Of EntryIMP_ELEMENT_GRP_STD.UNIT ST (Hard coded)
18Max Lot SizeProduction Time (Cost.ElementTotalTime.TotalTime) Production Time (Cost.ElementTotalTime.TotalTime)
19Zzlit1X Empty
20Sales OrganisationSE97 Empty
21Distribution Channel01 Empty
22ProcessSL010 Empty
23Identifier   
24Main Reinforcement above limitKG KG
25Lattice Girder above limitKG KG

Unit Quantity Table

The element group unit defined in the database (IMP_ELEMENT_GRP_STD) decides what element quantity should be used, see the table below.

UNITQuantity
M2,Area
TOMass
STCount