Article master canonical guidelines

Optional header for article master canonical.

Note: X12 832 and EDIFACT PRODAT both include header data. IDoc MATMAS.MATMAS05 has no header data. It's an extract of an SAP material master record and follows the structure of the material master record in SAP.

The header segment of the IDoc MATMAS.MATMAS05 E1MARAM is a looping segment that recreates material master general data from table MARA. The required transaction identifier value for the GUI and search screens will need to be generated from the IDoc, perhaps a concatenation of sender identifier and material number.

Processing function, transaction set purpose code.

Valid values include:

• CREATE

• CHANGE

• DELETE

• CANCEL

• ORIGINAL

• REPLACE

• RESEND

BCT10 =

• 00 - (ORIGINAL) or

• 01 - (CANCEL) or

• 02 - (CREATE) or

• 03 - (DELETE) or

• 04 - (CHANGE) or

• 05 - (REPLACE) or

• 15 - (RESEND)

BCT01 Possible Codes:

• SC - Sales Catalog

• PC - Price Catalog

• RC - ReSale Catalog

Referenced document type.

Valid values:

• ARTICLEMASTER (required from all formats IB)

• VERSION

• PRICESALESCATALOG

b2bTransactionIdentifierType = "ARTICLEMASTERDATA" IB mapping.

Note: No transaction doc identifier in header data in IDoc. Need to create unique identifier … suggest concatenate: EDI_DC40/SNDLAD + E1MARAM/MATNR

Only IB mapping.

Suggesting concatenation to build unique identifier: SNDLAD + MATNR

Date type at header level for article master record in date format YYYYMMDD and time format (IDoc, X12) HHMMSS.

Valid values:

• EFFECTIVE

• AVAILABILITY

• EXPIRATION

• WARRANTY

• DOCUMENT

DTM01 -

• 007 - (EFFECTIVE) or

• 018 - (AVAILABILITY) or

• 036 - (EXPIRATION) or

• 512 - (WARRANTY) or

• 999 - (DOCUMENT)

Date defined by referenced date type in date format YYYY-MM-DD.

Transform will pass thru whatever it finds in IDoc date and time fields.

DTM02 where DTM01 -

• 007 or

• 018 or

• 036 or

• 999

Date defined by referenced date type generated in epoch integer date format.

Each string date recorded will have an epoch date format generated by a java exit.

Segment CUR

Example:CUR*SE*USD

Processing function code at the line item level.

Valid values:

• CHANGE

• REPLACE

• ORIGINAL

• DELETE

• DONOTIMPORT

• RESEND

MSGFN =

• 003 - (DELETE) or

• 004 - (CHANGE) or

• 005 - (REPLACE) or

• 009 - (ORIGINAL) or

• 023 - (DONOTIMPORT) or

• 018 - (RESEND)

G5301 =

• 001 - (CHANGE) or

• 002 - (DELETE) or

• 050 - (ORIGINAL)

Product identifier type.

Valid values include:

• CUSTOMER

• SUPPLIER

• GTIN14

For X12 and EDIFACT, use java call-out to lookup table CL_ProductCodeType.txt

SAP does not support item type in this IDoc. There will only be a material identifier which will most likely represent the internal product number of the sending SAP system.

If message sent by the buyer, productCodeType would = CUSTOMER

If message sent by the seller, productCodeType would = SUPPLIER

LIN02 If more than one entry in productCodesIdentifiers, loop and pass values also to:

LIN04, LIN06, LIN08, LIN10, LIN12, LIN14, LIN16

Use java call-out to lookup table CL_ProductCodeType.txt

Alternate language code for description of product.

In this instance, this would be a one character SAP code for the language of the product description used in conjunction with the ISO language code.

Processing function code at the line item level.

Valid values:

• CHANGE

• REPLACE

• ORIGINAL

• DELETE

• DONOTIMPORT

• RESEND

Segment E1MAKTM MSGFN

• 003 - DELETE

• 004 - CHANGE

• 005 - REPLACE

• 009 - ORIGINAL

• 023 - DONOTIMPORT

• 018 - RESEND

Deletion indicator for article.

Valid values:

• True - Article record flagged for deletion

• False - Do not delete item (default)

Indicator that specifies whether batch management is active for the article in the master record.

Valid values:

• True - Batch management is active

• False - Batch management is NOT active (default)

Material type. Defines groups of materials according to common attributes and/or usage such as finished goods, raw materials, semi-finished products, operating supplies, trading goods, samples.

Note: When we start mapping from an Idoc (or any other format) to any other format, we'll probably need to add enumerations for materialType -- could be a lookup file.

Article family code. Groups articles with common attributes.

Typically articles within the same material type or family have similar material handling characteristics.

Indicator that identifies new article.

Valid values:

• True - Article record flagged for deletion

• False - Do not delete item (default)

Base unit of measure for the article master record. This is the UOM in which stocks of the article are managed.

Quantity UOMs include:

• CA - Case

• CP - Crate

• CT - Carton

• DS - Display

• DZ - Dozen

• EA - Each

• PH - Pack

• PC - Piece

• PF - Pallet

• PK - Package

• T3 - Thousand Pieces

• TH - Thousand

• TY - Tray

• UN - Unit

An alternative or base unit of measure for the article master used by the message sender or a third party.

Quantity UOMs include:

• CA - Case

• CP - Crate

• CT - Carton

• DS - Display

• DZ - Dozen

• EA - Each

• PH - Pack

• PC - Piece

• PF - Pallet

• PK - Package

• T3 - Thousand Pieces

• TH - Thousand

• TY - Tray

• UN - Unit

Code identifying type of expiration date for article. SAP pass thru.

SAP values:

• B - Expiration date

• E - Shelf life expiration

Indicator that specifies whether an origin code for the article must be entered when the article is received or identified.

Valid values:

• True - Entering origin code for article is required

• False - Origin code for article is NOT required

Time period type used to determine the lead time before the shelf life expiration date for the article.

Valid values:

• DAYS

• HOURS

• MINUTES

• WEEKS

• MONTHS

• YEARS

Segment E1MARAM IPRKZ =

• not populated (DAYS) default or

• 1 (WEEKS) or

• 2 (MONTHS) or

• 3 (YEARS)

Lead time before the shelf life expiration date for the article as determined by the expiryLeadTimeType.

Can also determine when the article is locked and can no longer be available for ordering

Identifies class set up in warehouse management that identifies lead time for product.

If not present, lead time is determined by expiryLeadTimeType and/or expiryLeadTime.

Indicator that identifies whether the article is expiry date controlled.

Valid values:

• True - Article is expiry date controlled

• False - Article is NOT expiry date controlled (default)

Indicator that specifies whether the article can be delivered in double stacked pallets.

Valid values:

• True - Article can be double-stacked on pallet (default)

• False - Article is NOT double-stacked on pallet

Indicator that specifies whether the article required special handling it is a dangerous or hazardous article.

Valid values:

• True - Article is expiry date controlled

• False - Article is NOT expiry date controlled (default)

Indicator that specifies whether samples will be taken on receipt of the article.

Valid values:

• True - Samples will be taken on receipt of the Article

• False - Samples will NOT be taken on receipt (default)

Groups materials that share the same route and mode of transportation requirements.

For example, all items that need to be shipped frozen could be in the same transportation group. Same with all articles that are shipped by lot and truck or in liquid form, and so on.

Indicator that specifies whether picking is done for the article at the UM level.

Valid values:

• True - Picking will be done at UM level for article

• False - Picking will NOT be done at UM level

Indicator that specifies whether picking is done for the article at the carton level.

Valid values:

• True = Picking will be done at carton level for article

• False = Picking will NOT be done at the carton level

Indicator that specifies whether picking is done for the article at the box level.

Valid values:

• True - Picking will be done at box level for article

• False - Picking will NOT be done at the box level

Indicator that specifies whether picking is done for the article at the unit level.

Valid values:

• True - Picking will be done at the unit level for article

• False - Picking will NOT be done at the unit level

Indicator that specifies whether the article is enabled for count back, a picking verification task that applies when the operator is picking less than a full pallet from a location.

Valid values:

• True = Count back is enabled

• False = Count back is NOT enabled

Weight type for article master.

Valid values:

• NETWEIGHT

• GROSSWEIGHT

• ALLOWED

• PERUNIT

• TARE

• PALLET

• GROSSWEIGHT

• CARTON

• INNERPACK

MEA02 =

• G - (GROSSWEIGHT) or

• N - (NETWEIGHT)

• BRGEW if weightType = GROSSWEIGHT

• NTGEW if weightType = NETWEIGHT

• ERGEW if weightType = ALLOWED

Unit of measure for weights.

Use java call-out to lookup table UOM_TableLookup2.txt

• GEWEI if weightType = GROSSWEIGHT or NETWEIGHT

• ERGEI if weightType = ALLOWED

Use java call-out to lookup table UOM_TableLookup2.txt

Type of volume recorded for article master.

Valid vales:

• ALLOWED

• TOTAL

• PERUNIT

• VOLUM if volumeType = TOTAL

• ERVOL if volumeType = ALLOWED

• VOLEH where volumeType = TOTAL

• ERVOE where volumeType = ALLOWED

Use java call-out to lookup table UOM_TableLookup2.txt

Type of dimension recorded for the article master.

Valid values:

• LENGTH

• WIDTH

• HEIGHT

• DEPTH

MEA02 =

• LN - (LENGTH) or

• WD - (WIDTH) or

• HT - (HEIGHT)

• LAENG if dimenstionType = LENGTH

• BREIT if dimenstionType = WIDTH

• HOEHE if dimenstionType = HEIGHT

Processing function code at the line item level.

Valid values:

• CHANGE

• REPLACE

• ORIGINAL

• DELETE

• DONOTIMPORT

• RESEND

MSGFN =

• 003 - (DELETE) or

• 004 - (CHANGE) or

• 005 - (REPLACE) or

• 009 - (ORIGINAL) or

• 023 - (DONOTIMPORT) or

• 018 - (RESEND)

Type of dimension recorded for the article master.

Valid values:

• LENGTH

• WIDTH

• HEIGHT

• LAENG if dimenstionType = LENGTH

• BREIT if dimenstionType = WIDTH

• HOEHE if dimenstionType = HEIGHT

VOLEH where volumeType = TOTAL

Use java call-out to lookup table UOM_TableLookup2.txt

Weight type for article master.

Valid value is GROSSWEIGHT.

Processing function code at the line item level.

Valid values:

• CHANGE

• REPLACE

• ORIGINAL

• DELETE

• DONOTIMPORT

• RESEND

MSGFN =

• 003 - (DELETE) or

• 004 - (CHANGE) or

• 005 - (REPLACE) or

• 009 - (ORIGINAL) or

• 023 - (DONOTIMPORT) or

• 018 - (RESEND)

Plant to which article is assigned.

A material master record may be assigned to one or more plants.

Purchasing group.

Identifies a buyer or a group of buyers responsible for purchasing activities for the article.

MRP type.

Key that determines whether and how requirements for the article are planned in articles resource planning.

Planned delivery time in days, with no decimals.

Number of calendar days needed to obtain the article or service if it is procured externally.

Goods receipt processing time in days, with no decimals.

Number of workdays required after receiving the article for inspection and placement into storage.

Lot size in article planning.

Key that determines which lot-sizing procedure the system uses within articles planning to calculate the quantity to be procured or produced. SAP pass thru mapping.

The procurement type Indicator defines how the article is procured.

This includes in-house production, external procurement, or a combination of both in-house production and external procurement.

BESKZ =

• E - (in-house production) or

• F - (external procurement) or

• X - (both) or

• not populated (no procurement)

The period indicator specifies the periods in which the article's consumption values and forecast values are managed.

This can be monthly, weekly, daily or based on the fiscal year variant.

Percentage of scrap that occurs during production of the article if the article is an assembly.

Used in articles planning to calculate the lot size of the assembly. The system increases the quantity to be produced by the scrap quantity calculated.

Quantity of the article that may not be exceeded during procurement.

The lot size of individual orders cannot exceed this value.

Rounding value for ordering quantity.

Used in planning. Value to a multiple of which the system rounds up the procurement quantity for the article.

Dependent requirements indicator for individual and collective requirements.

Determines whether individual or collective requirements are allowed for the dependent requirements of the article.

Dependent requirements are automatically created by the MRP procedure for the components required to produce a planned order.

Scheduling margin key for floats.

Determines floats required for scheduling an order. SAP pass thru.

A grouping of materials that share the same loading requirements.

For example, different loading groups could include materials that require the same equipment (ie, a fork-lift) or amount of time for loading, or the same loading point.

Identifies the group or role responsible for controlling the production of an article.

The production supervisor also determines how capacity requirements are calculated for an article during a scheduling run. This is a code in SAP. Pass thru mapping.

The number of workdays required for the transition of a produced article between work centers or work center groups.

The total includes the following times:

• Queue time

• Wait time

• Float before production

• Float after production

• Planned delivery time of an operation processed externally

Identifies a period in which no automatic changes are made to the master plan.

Only used for articles that are planned with an MRP type that includes a firming type, which determines how order proposals are created or scheduled within the planning time fence.

The consumption mode controls the direction on the time axis in which the system consumes requirements.

Can be backward or forward or any combination of the two. Backward consumption is about planned requirements that lie before the requirements date. Forward consumption is about planned requirements that lie after the requirements date.

The storage location that is copied to the planned order, process order, or the quantities of the article that are produced during a specified period.

If article is a component, this is the issuing storage location that is backflushed on completion. If the article is a finished good, this is the receiving storage location for the goods receipt on the finished product.

Indicator that specifies whether inventory adjustments are allowed for the article.

Valid values:

• True - Inventory adjustments allowed for article

• False - Inventory adjustments are NOT allowed for article

Physical inventory cycle count code identifies an article that is subject to the cycle counting method of inventory.

It also defines time intervals for taking a physical count for the article. Pass thru mapping.

The speed that inventory in a location moves in and out of the warehouse.

Optimizes warehouse space and inventory handling by placing fast moving articles in optimal locations for quick picking.

Indicator that specifies whether a cycle count must be performed immediately if the article's inventory level drops below the threshold defined for a count near zero quantity.

Valid values:

• True - Cycle count automatic if near zero quantity reached

• False - Cycle count NOT automatic for near zero quantity

Processing function code at the line item level.

Valid values:

• CHANGE

• REPLACE

• ORIGINAL

• DELETE

• DONOTIMPORT

• RESEND

MSGFN =

• 003 - (DELETE) or

• 004 - (CHANGE) or

• 005 - (REPLACE) or

• 009 - (ORIGINAL) or

• 023 - (DONOTIMPORT) or

• 018 - (RESEND)

Processing function code for forecasting parameters.

Valid values:

• CHANGE

• REPLACE

• ORIGINAL

• DELETE

• DONOTIMPORT

• RESEND

MSGFN =

• 003 - (DELETE) or

• 004 - (CHANGE) or

• 005 - (REPLACE) or

• 009 - (ORIGINAL) or

• 023 - (DONOTIMPORT) or

• 018 - (RESEND)

Processing function code at the line item level.

Valid values:

• CHANGE

• REPLACE

• ORIGINAL

• DELETE

• DONOTIMPORT

• RESEND

MSGFN =

• 003 - (DELETE) or

• 004 - (CHANGE) or

• 005 - (REPLACE) or

• 009 - (ORIGINAL) or

• 023 - (DONOTIMPORT) or

• 018 - (RESEND)

Processing function code at the line item level.

Valid values:

• CHANGE

• REPLACE

• ORIGINAL

• DELETE

• DONOTIMPORT

• RESEND

MSGFN =

• 003 - (DELETE) or

• 004 - (CHANGE) or

• 005 - (REPLACE) or

• 009 - (ORIGINAL) or

• 023 - (DONOTIMPORT) or

• 018 - (RESEND)

Processing function code at the line item level.

Valid values:

• CHANGE

• REPLACE

• ORIGINAL

• DELETE

• DONOTIMPORT

• RESEND

MSGFN =

• 003 - (DELETE) or

• 004 - (CHANGE) or

• 005 - (REPLACE) or

• 009 - (ORIGINAL) or

• 023 - (DONOTIMPORT) or

• 018 - (RESEND)

Deletion indicator for article.

Valid values:

• True - Article record flagged for deletion

• False - Do not delete item (default)

Unit of measure for capacity usage. Quantity

UOMs include:

• CA - Case

• CP - Crate

• CT - Carton

• DS - Display

• DZ - Dozen

• EA - Each

• PH - Pack

• PC - Piece

• PF - Pallet

• PK - Package

• T3 - Thousand Pieces

• TH - Thousand

• TY - Tray

• UN - Unit

Loading equipment quantity is related to palletiization. It is used to determine how to pack a pallet.

For example, if the loading equipment quantity in the article master = 25, and 100 cartons need to be put into stock, the system would propose 4 pallets for packing.

Unit of measure for loading equipment capacity.

Quantity UOMs include:

• CA - Case

• CP - Crate

• CT - Carton

• DS - Display

• DZ - Dozen

• EA - Each

• PH - Pack

• PC - Piece

• PF - Pallet

• PK - Package

• T3 - Thousand Pieces

• TH - Thousand

• TY - Tray

• UN - Unit

Processing function code at the line item level.

Valid values:

• CHANGE

• REPLACE

• ORIGINAL

• DELETE

• DONOTIMPORT

• RESEND

MSGFN =

• 003 - (DELETE) or

• 004 - (CHANGE) or

• 005 - (REPLACE) or

• 009 - (ORIGINAL) or

• 023 - (DONOTIMPORT) or

• 018 - (RESEND)

Pricing type for price sales catalog.

Valid values include:

• CATALOG - Catalog price

• UNIT - Unit price

• CHANGED - Price change

• CONTRACT - Contract price

• DISCOUNT - Discounted price

• PROMOTION - Promotion price

CTP02 =

• UCP - (UNIT) or

• CAT - (CATALOG) or

• CHG - (CHANGED) or

• CON - (CONTRACT) or

• DPR - (DISCOUNT) or

• PRP - (PROMOTION)

Numerator is used to convert from an alternate unit of measure, ie, KG to a base unit of measure, ie, EA.

The numerator is the number of units of the base UOM (EA) that corresponds to the number of units of the alternative UOM (KG).

If 5 KG = 3 EA, 1 KG = 3/5 EA. 3 is the numerator. In most cases, this value will be 1.

Default value for the valuation class for valuated stocks of this article.

The valuation class has implications for how values of articles post to the same or different G/L accounts.

Indicates the price control procedure used to valuate the stock of a article.

The following values are supported:

• STANDARD

• MOVINGAVERAGE

VPRSV =

• S - (STANDARD) or

• V - (MOVINGAVERAGE)

Moving average price for article, calculated by the ERP system by dividing the article value in the stock account by the total of all storage location stocks in the article plant.

The price changes with each valuation-relevant movement. The valuation of stocks at moving average price means that the price of the article is adapted to the continual fluctuations in the procurement price.

Standard price for the article.

The valuation of article stocks at standard prices means that all goods movements are valuated at the same price over an extended period.

Number of units of the article on which the price is based.

For example, If 12 widgets are priced at $12.00, the unit price basis quantity is 12.

Default value for the valuation class for valuated stocks of this article.

The valuation class has implications for how values of articles post to the same or different G/L accounts.

Indicates the price control procedure used to valuate the stock of a article.

The following values are supported:

• STANDARD

• MOVINGAVERAGE

VMVPR =

• S - (STANDARD) or

• V - (MOVINGAVERAGE)