Material 360 > Material 360 assets > Data model attributes
  

Data model attributes

The Material 360 package includes the following business entities:
The following image shows the Material 360 business entities and their relationships:
The image shows the relationship types between the business entities and the direction of the relationships.

Material business entity model

Material business entity stores information about materials that an organization uses, such as material plant, material description, and industry sector. This business entity contains some basic fields and some field groups.

General fields of the Material business entity

The general fields store basic information about a material, such as material type, material number, and basic constituents of a material.
The following table describes the general fields of the Material business entity:
Display Name
Internal ID
Field Type
Length
Reference Data
Description
Authorization Group
infap360mm_authorizationGroup
Text
4
NA
Group of users with authorizations to control access to a material.
Base Unit of Measurement
infap360mm_baseUnitOfMeasure
Lookup
NA
infap360mm_UOM
Unit to measure the quantity of a material. For example, pound, each, and box of 12.
Basic Constituent of Material
infap360mm_basicConstituentOfMaterial
Text
50
NA
The basic constituents that the material is made of.
Bulk or Liquid Indicator
infap360mm_ind_isBulkLiquid
Boolean
NA
NA
Indicates whether a material is in bulk or a liquid form.
Configurable Material Indicator
infap360mm_ind_configurableMaterial
Text
1
NA
Indicates whether a material can be produced in different variants.
Cross Plant Material Status
infap360mm_xPlantMatStatus
Lookup
NA
infap360mm_XPlantMatStatus
Status to indicate the usability of a material for multiple plants. For example, for approval, or obsolete.
Division
infap360mm_division
Lookup
NA
infap360mm_Division
Division of the organization that a material belongs to.
Environmentally Relevant Indicator
infap360mm_ind_environmentallyRelevant
Text
1
NA
Indicates whether a material is part of the environmental footprint of a company.
General Item Category Group
infap360mm_generalItemCategoryGroup
Lookup
NA
infap360mm_GeneralItemCatGrp
Group to determine a material category in a sales order.
Highly Viscous Indicator
infap360mm_ind_isHighlyViscous
Boolean
NA
NA
Indicates whether the material is highly viscous.
Industry Sector
infap360mm_industrySector
Lookup
NA
infap360mm_IndustrySector
Branch of an industry for the assignment of a material. For example, plant engineering and construction, chemical industry, mechanical engineering, and pharmaceuticals industry.
Material Group
infap360mm_materialGroup
Lookup
NA
infap360mm_MaterialGroup
Group of materials and services with the same attributes. For example, office supplies, beverages, and maintenance work.
Material Group - Packaging Materials
infap360mm_materialGroupPackagingMaterials
Lookup
NA
infap360mm_MaterialGroupPackagingMaterials
Grouping parameter to group materials that need similar packaging materials.
Material Number
infap360mm_materialNumber
Text
40
NA
Unique identifier for a material.
Material Number Type
infap360mm_matNumType
Lookup
NA
infap360mm_MaterialNumType
Source from which the material number is obtained.
Material Type
infap360mm_materialType
Lookup
NA
infap360mm_MaterialType
Type of material based on basic attributes.
Net Weight
infap360mm_netWeight
Decimal
13(3)
NA
Delivery of net weight of a material in a shipment.
Old Material Number
infap360mm_oldMaterialNumber
Text
40
NA
Old identifier for a material under which the material was managed so far.
Transportation Group
infap360mm_transportationGroup
Lookup
NA
infap360mm_TransportationGroup
Group of materials that have similar transportation requirements. For example, trucks, tankers, and trains.
Unit of Measurement for Weight
infap360mm_weightUnit
Lookup
NA
infap360mm_UOM
Unit of measurement for the weight of a material.
Valid From
infap360mm_validFrom
Date
NA
NA
The date from when the material details become valid.

Alternative Unit of Measurement field group of the Material business entity

The Alternative Unit of Measurement field group stores the detailed measurements of a material in addition to the base unit of measurement.
The following table describes the fields of the Alternative Unit of Measurement field group:
Display Name
Internal ID
Field Type
Length
Reference Data
Description
Alternative Unit of Measurement
infap360mm_dimAlternativeUnitOfMeasureSKU
Lookup
NA
infap360mm_AlternateUOM
Unit of measurement in addition to the base unit of measurement to manage the stocks of a material.
Denominator of Conversion Factor
infap360mm_dimDenominatorToBaseUom
Decimal
5(0)
NA
Denominator of the quotient that specifies the ratio of the alternative unit of measurement to the base unit of measurement.
Gross Weight
infap360mm_dimGrossWeight
Decimal
13(3)
NA
Gross weight of a material.
Height
infap360mm_dimHeight
Decimal
13(3)
NA
Height of a material.
Length
infap360mm_dimLength
Decimal
13(3)
NA
Length of a material.
Numerator of Conversion Factor
infap360mm_dimNumeratorToBaseUom
Decimal
5(0)
NA
Numerator of the quotient that specifies the ratio of the alternative unit of measurement to the base unit of measurement.
Unit of Measurement for Dimensions
infap360mm_dimUnitOfDimensions
Lookup
NA
infap360mm_UOM
Unit of measurement for the dimensions of a material.
Unit of Measurement for Volume
infap360mm_dimVolumeUnit
Lookup
NA
infap360mm_UOM
Unit of measurement for the volume of a material.
Unit of Measurement for Weight
infap360mm_dimWeightUnit
Lookup
NA
infap360mm_UOM
Unit of measurement for the weight of a material.
Volume
infap360mm_dimVolume
Decimal
13(3)
NA
Volume of a material.
Width
infap360mm_dimWidth
Decimal
13(3)
NA
Width of a material.

Identifier field group of the Material business entity

The Identifier field group stores the identifier related information of a material, such as identifier type and status of the identifier.
The following table describes the fields that the Identifier field group contains:
Display Name
Internal ID
Field Type
Length
Reference Data
Description
Identifier Status
infap360mm_identifierStatus
Lookup
NA
infap360mm_IdentifierStatus
Status of the identifier. For example, active or inactive.
Identifier Type
infap360mm_idType
Lookup
NA
infap360mm_IdentifierType
Source of the identifier. For example, SAP ECC or SAP S/4HANA.
Identifier Value
infap360mm_altIdValue
Text
40
NA
Value of the identifier.

Material Description field group of the Material business entity

The Material Description field group stores the description of a material.
The following table describes the fields of the Material Description field group:
Display Name
Internal ID
Field Type
Length
Reference Data
Description
Description
infap360mm_description
Text
40
NA
Description of a material.
Language
infap360mm_language
Lookup
NA
Crosswalk-Language
Language of a material description.

Material Plant field group of the Material business entity

The Material Plant field group stores the details of a material plant.
The following table describes the fields of the Material Plant field group:
Display Name
Internal ID
Field Type
Length
Reference Data
Description
Commodity - Import Code Number for Foreign Trade
infap360mm_commodityCode
Lookup
NA
infap360mm_CommodityCode
Code from the Harmonized Commodity Description and Coding System to identify a commodity for import.
Country of Origin
infap360mm_countryOfOrigin
Lookup
NA
Country
Country where a material is manufactured.
Export and Import Material Group
infap360mm_exportImportMaterialGroup
Lookup
NA
infap360mm_expImpMaterialGrp
Group of materials with similar export and import attributes.
Loading Group
infap360mm_loadingGroup
Lookup
NA
infap360mm_LoadingGrp
Group of materials with similar loading requirements for transportation. For example, cranes, forklifts, and trolleys.
Plant
infap360mm_plant
Lookup
NA
infap360mm_Plant
Location that holds the stock of a material.
Profit Center
infap360mm_profitCenter
Text
10
NA
Profit center of a material.
Region of Origin of Material
infap360mm_regionOfOrigin
Lookup
NA
infap360mm_Region
Region from where a material is manufactured.
Storage Location
infap360mm_storageLoc
Lookup
NA
infap360mm_StorLoc
Place where a material is stored.
Unit of Measurement for Commodity Code
infap360mm_unitOfMeasure
Lookup
NA
infap360mm_UOM
Unit of measurement for the commodity code of a material.

Record Status field group of the Material business entity

The Record Status field group stores the status of the Material business entity record.
The following table describes the fields of the Record Status field group:
Display Name
Internal ID
Field Type
Length
Reference Data
Description
Status Type
infap360mm_statusType
Lookup
NA
infap360mm_ErrorStatusType
Type of the record status. For example, S4Hana Integration Status.
Description
infap360mm_errorDescription
Text
255
NA
A brief description about the record status.
Last Updated
infap360mm_date
Date and Time
NA
NA
The latest date and time when the status was updated.
Status
infap360mm_status
Lookup
NA
infap360mm_ErrStatus
Status of the record. For example, success or failure.

Material Category business entity model

Material Category business entity stores information about categories of materials, such as the category ID, description, and the level of a material category. This business entity contains some basic fields.

General fields of the Material Category business entity

The general fields store basic information about the category of materials with the same attributes or purpose.
The following table describes the general fields of the Material Category business entity:
Display Name
Internal ID
Field Type
Length
Reference Data
Description
Category ID
infap360mm_categoryID
Text
20
NA
Unique identifier for the category of a material.
Description
infap360mm_description
Text
50
infap360mm_UOM
Description of the category of a material.
Level Number
infap360mm_leveNo
Integer
NA
NA
Unique number for the level of a material category.