You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 237 Next »

Status

``   In Progress

Owner
Stakeholders

Purpose

The purpose of this document is to define the conversion approach to create Service Master records in S/4HANA. It follows the Procurement Master Data Design Standard and is based on data being migrated from legacy SAP ECC systems (PF2, WP2) into SAP S/4HANA.

The purpose of this document is to define the conversion approach to upload data in S/4 HANA.


This file is aligned with the Conversion Specification Guidelines


---CHECKLIST IT---

  • Logical Source and Target Systems are identified.
  • Processing Type is specified (i.e. Direct Input, BAPI, IDoc, Web Service, OData API, etc.)
  • Standard or custom load program name/BAPI/IDoc is specified to support this functionality.
  • Data Mapping is provided for mappings which are not obvious to a suitably-skilled and experienced developer
  • All translation requirements are clearly defined (including data validation rules, data derivation/calculation and default values, if applicable)Input and/or Output file layouts are provided for all record types possible
  • Transaction volume is specified Execution frequency is specified Restart/Recovery requirements havee been defined
  • Error handling requirements are specified, including alerting requirement and expected action on failure.
  • Application log requirement if applicable to be specified. 


---Process Flow---

  • 1) Legacy systems
  • 2) Extraction methods and file types
  • 3) Scope relevancy criteria
  • 4) Target structure/ Rules
  • 5) MDS links
  • 6) Cleansing rules
    • 6a) Cleansing reports with technical information
    • 6b) Profiling
    • 6c) deduplication (with technical details of Table-Fields, Conditions)
    • 6d) Frequency of running reports
  • 7) Transformation - and for this DOMD template must be populate and final version of DOMD template should be copied to Transformation section in CSpecs
  • 8) Configuration/Value mapping file link
  • 9) Value Mappings
  • 10) Load template link
  • 11) Loading method
  • 12) Loading sequence or dependency
  • 13) Pre load validation
  • 14) Post load validation
  • 15) any Exceptions
  • 16) Signoff


--- Additional topics to check---

  • Rules for Data Merging (all systems) - DEDUPLICATION RULES


Conversion Scope

The migration will consolidate two existing legacy object types into a single Lean Service model in S/4HANA:

  1. Materials created as Services – Material Master records with service-related material types (PF2 = DIEN, Z710, Z720, Z732, ZB10, ZB20, ZESE, ZFS1, ZPSE, ZU10, ZU20 or WP2 = DIEN, ZDIE) ==> main table = MARA
  2. Service Master Data – Maintained in SAP ECC ==> main table = ASMD


Both object types are currently used in parallel to support service procurement. While they may sometimes represent similar business needs, they are maintained and processed independently in the legacy systems.

In the target system (S/4HANA), all services will be represented exclusively as Lean Services within the Material Master (Material Type = SERV or ZSER), in line with the Procurement Master Data Design Standard. This approach eliminates the need for separate Service Master objects and service material types, providing:

  • A single master data object for all services.

  • Standardized naming, classification, and valuation.

  • Harmonized Material Groups for enterprise-wide reporting and spend analysis.


The conversion scope includes:

  • Extracting both Service Master (ASMD) and Materials-as-Services records (MARA).

  • Cleansing, harmonizing, and deduplicating entries across both object types.

  • Mapping legacy keys to new Lean Service material numbers for traceability.

  • Excluding obsolete, incomplete, or unused records.



List of source systems and approximate number of records

SourceScope

Source Approx No. of Records

Target SystemTarget Approx

No. of Records

PF2 - 020

The Service Master Records (ASMD) and the Material Master Records created as Services (MARA with Service Material Types such as DIEN or equivalent) will be extracted and collected via the Data Collection Template (DCT).

An initial extract of the relevant data will be provided in Google Sheet format to support the business in reviewing and deciding which records should be included in scope for migration from the Source Systems.

Any additional Service data required to support the Lean Services design may also be added directly in the DCT by the business.


A data review, harmonization, and standardization exercise will be carried out across both Service Master and Service-as-Material records. This includes:

-Consolidation of overlapping entries.-Standardization of descriptions, units of measure, and language usage.
-
Identification and removal of obsolete or redundant Services.
-
Ensuring consistency in classification and purchasing-related fields.
- The final, validated dataset will represent the merged and standardized Services to be migrated into SAP S/4HANA Lean Services.

924 Materials (MARA)


34.756 Services (ASMD)


S4H

924 Materials (MARA)


34.756 Services (ASMD)

WP2 - 400

355 Materials (MARA)


624 Services(ASMD)

S4H

355 Materials (MARA)


624 Services(ASMD)

Relevancy Rules

gear ***SERVICES AS MATERIALS (MARA TABLE) - System PF2/WP2


Relevant Tables for the Extraction

GroupsTablePurposeKey fields (core)Link to MARATypical filters / notes








Group

A

MARACentral Material Master (type, base UoM, dimensions, weights, creation date, status flags).MANDT, MATNR--- Root Table

Filter by client (MANDT), material type (MTART), deletion flag (LVORM), etc. In ECC MATNR is 18-char (leading zeros); in S/4 it’s up to 40.


MAKTLanguage-dependent short descriptions (MAKTX).MANDT, MATNR, SPRASMAKT.MATNR = MARA.MATNR

Filter SPRAS (e.g., ‘E’, ‘F’…), or pick “best language”.


MARA → MAKT: MAKT.MANDT = MARA.MANDT and MAKT.MATNR = MARA.MATNR (1 material : many language texts).

MARMAlternative UoMs and conversion factors.MANDT, MATNR, MEINHMARM.MATNR = MARA.MATNR

Base UoM is MARA.MEINS; conversions via UMREZ/UMREN.


MARA → MARM: MARM.MANDT = MARA.MANDT and MARM.MATNR = MARA.MATNR (1 : many UoMs).

MEANEAN/UPC/GTINs for a material (often per UoM).MANDT, MATNR, EAN11 (+ MEINH)MEAN.MATNR = MARA.MATNR

Join to MARM on MATNR+MEINH when you need UoM-specific GTINs.


MARA → MEAN: MEAN.MANDT = MARA.MANDT and MEAN.MATNR = MARA.MATNR (1 : many GTINs).
Optional: if MEAN.MEINH is populated, it also corresponds to MARM.MEINH for that material.

STXHSAPscript long-text header for material texts.TDOBJECT, TDNAME, TDID, TDSPRASTDOBJECT='MATERIAL' and TDNAME = MATNR (padded)

Typical TDIDs: ‘GRUN’ (Basic Data), ‘SALES’, ‘PURCH’.


MARA ↔ STXH/STXL (long texts):
STXH.TDOBJECT = 'MATERIAL' and STXH.TDNAME = MARA.MATNR (padded);
STXL holds the lines for the same (TDOBJECT, TDNAME, TDID, TDSPRAS) key.
Common TDIDs for Basic Data: GRUN (basic), SALES, PURCH.

STXLSAPscript long-text lines (content).(cluster key matching STXH)via STXH keys

Read/display via text functions; storage is clustered.


MARA ↔ STXH/STXL (long texts):
STXH.TDOBJECT = 'MATERIAL' and STXH.TDNAME = MARA.MATNR (padded);
STXL holds the lines for the same (TDOBJECT, TDNAME, TDID, TDSPRAS) key.
Common TDIDs for Basic Data: GRUN (basic), SALES, PURCH.









Group

B

CABNCharacteristic definitions (metadata: name ATNAM, data type, length, value domain).ATINN (internal), ATNAMvia ATINN (through KSML/AUSP)

Use to resolve internal ATINN → external ATNAM.


KSML → CABN (characteristic catalog): KSML.ATINN = CABN.ATINN (characteristic technical definition).

CABNTCharacteristic texts (language-dependent).ATINN, SPRASvia CABN.ATINN

Bring characteristic descriptions by language.


CABN → CABNT (characteristic texts): CABNT.ATINN = CABN.ATINN (language-dependent).

CAWNPredefined values for a characteristic (for value-lists).ATINN, ATZHL (+ ATWRT)via CABN.ATINN

One row per allowed value; position ATZHL is the value key.


CABN → CAWN → CAWNT (value lists and texts):
CAWN.ATINN = CABN.ATINN; each allowed value is keyed by ATZHL.
CAWNT provides texts per (ATINN, ATZHL, SPRAS).

CAWNTTexts for the predefined values.ATINN, ATZHL, SPRASvia CAWN(ATINN,ATZHL)

Language-dependent value labels.


Use the same logic of CAWN

KLAHClass header (e.g., class type 001 for material classes).CLINT (internal), KLART, CLASSvia CLINT (to KSML/KSSK)

Filter KLART='001' for material classification.


KSSK → KLAH (class header): KSSK.CLINT = KLAH.CLINT and KLAH.KLART = '001'.

KLATClass texts (language-dependent).CLINT, SPRASvia KLAH.CLINT

Get the class description.


KLAH → KLAT (class texts): KLAT.CLINT = KLAH.CLINT (language-dependent class names).

KSMLClass ↔ Characteristic assignments.CLINT, ATINNvia KLAH.CLINT & CABN.ATINN

Which characteristics belong to a class.


KLAH → KSML (class ↔ characteristic): KSML.CLINT = KLAH.CLINT (which characteristics the class contains).

KSSKObject (material) ↔ Class assignments.OBJEK, CLINT, KLARTKSSK.OBJEK = MARA.MATNR(padded)

Filter OBTAB='MARA', KLART='001'. OBJEK = material number with leading zeros (ECC: 18 chars).


MARA → KSSK (object ↔ class):
KSSK.OBJEK = padded(MARA.MATNR) and KSSK.KLART = '001'; each row links a material to a class (KSSK.CLINT).

AUSPAssigned characteristic values for an object.OBJEK, ATINN, KLART (+ ATWRT/ATFLV)AUSP.OBJEK = MARA.MATNR(padded)MARA → AUSP (assigned values):
AUSP.OBJEK = padded(MARA.MATNR) and AUSP.KLART = '001';
AUSP.ATINN = CABN.ATINN; value stored in AUSP.ATWRT (char) or AUSP.ATFLV (numeric).

Execution Logic:

>>>========================================================================================

SINGLE

- All materials created in the previous 6 months will be included unless flagged for deletion.


GLOBAL
We will only include materials that are extended to the following:
- We will only include plants that are in-scope
- We will only include company codes that are in-scope
- We will only include purchasing orgs that are in-scope
- We will only include sales orgs that are in-scope

===========================================================================================

TO BE EXCLUDED

Evaluated in this exact order; first match wins:


Scope prerequisites

- Client: MANDT = (PF2 = '020' or WP2 = '400') 
- Material types in scope (MARA-MTART): (PF2 = DIEN, Z710, Z720, Z732, ZB10, ZB20, ZESE, ZFS1, ZPSE, ZU10, ZU20 or WP2 = DIEN, ZDIE)
- Plant in scope (MARC-WERKS): Material must be extended to at least one plant in
- Exclusion indicator (MARA-MSTAE): exclude materials with the following status (PF2 = Z3/Z4/ZZ; WP2 = Z0).



1) EXCLUDED (No activity, when >= 6m and <=3y)targeted recency rule


2) EXCLUDED (Obsolete text)
If MAKT-MAKTX indicates obsolescence:
   - contains word OBSOLETE or DELETED, or
   - after removing * and spaces, contains OBS.

3) EXCLUDED (MSTAE)
System-specific status code (PF2: Z3/Z4/ZZ; WP2: Z0).

4) EXCLUDED (LVORM)
If LVORM = 'X' and there is no open order within the last 3 years across SO/PO/PP:
HasOpenSO3Y = 0 AND HasOpenPO3Y = 0 AND HasOpenPP3Y = 0 exclude entry


5) EXCLUDED (No plant in scope)
If HasInScopePlant = 0 (and @RequirePlantExtension = 1).

6) EXCLUDED (No activity, 6m-3y)targeted recency rule
Exclude when all are true: 
   -
Created window: ERSDA_date <= @From6Months and ERSDA_date >= @From3Years, and
   -
No 3y activity: HasSO3Y = 0 AND HasPO3Y = 0 AND HasPP3Y = 0.

7) EXCLUDED Material Group Mapping (ZZM_GPS_MATKL)
Match MARA‑MATKL to ZZM_GPS_MATKL‑MATKL with ZZMGOODSER='S'. If a match exists and LOEVM is not initial, the record is excluded. The solution publishes MAPPED/UNMAPPED reports for governance visibility.

If none of the above exclusions apply, the material is included (see topic 4 for more details).

===========================================================================================

TO BE INCLUDED


Scope prerequisites

- Client: MANDT = (PF2 = '020' or WP2 = '400') 
- Material types in scope (MARA-MTART): (PF2 = DIEN, Z710, Z720, Z732, ZB10, ZB20, ZESE, ZFS1, ZPSE, ZU10, ZU20 or WP2 = DIEN, ZDIE)
- Plant in scope (MARC-WERKS): Material must be extended to at least one plant in
- Exclusion indicator (MARA-MSTAE): exclude materials with the following status (PF2 = Z3/Z4/ZZ; WP2 = Z0).

2) Time windows (used everywhere)

- Materials with <= 6 month since its creation, don't need to have any activity (PurchOrder, SalesOrder, Production)
Newness: @Today – 6 months

3) Activity & Open definitions (last 3 years)

Sales Orders (SO)
- Activity (HasSO3Y): exists VBAP line joined to VBAK with VBAK.ERDAT >= @From3Years.
-
Open (HasOpenSO): line is open if any:
   - VBUK.GBSTK NOT IN ('C','D'), or
   - VBUP.GBSTA NOT IN ('C','D'), or
   - no VBUP and VBAP.ABGRU = '' (blank).
- Open within 3y (LVORM override): same open condition AND VBAK.ERDAT >= @From3Years >>> HasOpenSO3Y.


Purchase Orders (PO)
- Activity (HasPO3Y): EKKO header date COALESCE(AEDAT,BEDAT) >= @From3Years on a matching EKPO.
- Open (HasOpenPO): EKPO.ELIKZ <> 'X' AND EKPO.LOEKZ <> 'X'.
- Open within 3y (LVORM override): open AND COALESCE(AEDAT,BEDAT) >= @From3Years >>> HasOpenPO3Y.


Production Orders (PP)
- Activity (HasPP3Y): COALESCE(AUFK.ERDAT, AFKO.GLTRP) >= @From3Years on a matching AFPO.
- Open (HasOpenPP): AUFK.LOEKZ <> 'X' AND (AFKO.GLTRP IS NULL OR AFKO.GLTRP >= @Today).
- Open within 3y (LVORM override): open AND COALESCE(AUFK.ERDAT, AFKO.GLTRP) >= @From3Years >>> HasOpenPP3Y.


4) Inclusion triggers (exceptional list)

- If the material is in the manual table, it must be included.


5) Available Stock (note this migration regards SERVICES, therefore this rule should be treated as an exceptional situation)

If any of the below table-fields are greater than 0 and the material has current stock, it should be included for migration, even if other activity rules (PO, SO, PP) are not met. This has priority over all other rules.

- Check if Storage Location Stock (MARD) <> 0
MARD-LABST = Unrestricted stock
MARD-INSME = Stock in quality inspection
MARD-SPEME = Blocked stock
MARD-UMLME = Stock in transfer (to another storage location)

 - Special Stocks (as needed in migration scope)
MKOL-KALAB = Consignment stock (vendor consignment)
MSLB-LABST = Special stock with customer (sales order stock)
MSKA-LABST = Sales order stock
MSPR-LABST = Project stock


6) Final filters before output

Even if a row/material has an INCLUDED reason, it must still pass all of these steps:

   - IsObsoleteText = 0
   -
ExcludeByMSTAE = 0
   -
Not (LVORM='X' AND HasOpenSO3Y=0 AND HasOpenPO3Y=0 AND HasOpenPP3Y=0)
   - And (IsForceIncluded = 1 OR EligibilityReason LIKE 'INCLUDED%')


========================================================================================<<<


gear ***SERVICES MASTER DATA (ASMD TABLE) - System PF2/WP2


 Relevant Tables for the Extraction

GroupsTablePurposeKey fields (core)Link to ASMDTypical filters / notes


Group
A

ASMDCore Service Master under evaluation (creation date, deletion flag, basic attributes).MANDT, ASNUM, ERDAT (ERSDA), AEDAT, LVORM (LOEKZ), MATKL, MEINS— Root tableFilter by client (MANDT); deletion flag is later overridden if there is open activity within 3 years.
ASMDTLanguage-dependent short descriptions (used for “obsolete/deleted” text heuristic).MANDT, ASNUM, SPRAS, KTEXTASMDT.ASNUM = ASMD.ASNUMChoose “best language” (e.g., E). Detect “OBSOLETE/DELETED/OBS” (case-insensitive; trim spaces/asterisks).



Group

B

EKKOPurchase Order header (dates; organizational scope: BUKRS, EKORG).MANDT, EBELN, BUKRS, EKORG, AEDAT/BEDATVia EKPOESLL to reach ASMDFilter by client. Dates used for “last 3 years” window. Org scope checked against in-scope BUKRS/EKORG lists.
EKPOPO item lines (service items, open/closed flags, optional plant).MANDT, EBELN/EBELP, PSTYP, ELIKZ, LOEKZ, WERKS, PACKNOEKPO.PACKNO → ESLL.PACKNO → ESLL.SRVPOS = ASMD.ASNUMPSTYP = ‘9’ (service). Open item = ELIKZ ≠ ‘X’ and LOEKZ ≠ ‘X’. WERKS used only if plant scoping is enforced.
ESLLService package lines; bridges PO/SES packages to ASMD (service number).MANDT, PACKNO, SRVPOS (service number)ESLL.SRVPOS = ASMD.ASNUM; ESLL.PACKNO links to EKPO/ESSREssential link table; no direct date filters here.
ESSRService Entry Sheet header (evidence of recent/open SES activity).MANDT, PACKNO, BUDAT, LOEKZ, EBELN, EBELPESSR.PACKNO → ESLL.PACKNO → ESLL.SRVPOS = ASMD.ASNUM“Recent” if BUDAT ≥ Today − 3 years. Open if LOEKZ ≠ ‘X’. Org scope derived via EKKO/EKPO on EBELN/EBELP (LEFT JOIN).

Execution Logic:

>>>========================================================================================

SINGLE

- All materials created in the previous 6 months will be included unless flagged for deletion.


GLOBAL
We will only include materials that are extended to the following:
- We will only include plants that are in-scope
- We will only include company codes that are in-scope
- We will only include purchasing orgs that are in-scope
- We will only include sales orgs that are in-scope


===========================================================================================

SINGLE

- All services created in the previous 6 months (ASMD-ERDAT >= @From6Months) are included unless excluded by LVORM/MSTAE/text rules. (Services are client-level; no plant extension applies.)


GLOBAL

- Client: MANDT IN (PF2-020, WP2-400)

- Company codes / purchasing orgs in scope: restrict via your in-scope lists, applied through the documents that reference the service (POs/Entry Sheets).

- Purchasing Organization in scope: restrict via your in-scope lists, applied through the documents that reference the service (POs/SOs/Entry Sheets).

===========================================================================================


TO BE EXCLUDED

Evaluated in this exact order; first match wins:


1) EXCLUDED (No activity, when >= 6m and <=3y)targeted recency rule


2) EXCLUDED (Obsolete text)
Obsolete text detected in ASMDT (OBSOLETE / DELETED / (OBS) / “ obs ”).

3) EXCLUDED (MSTAE)
System-specific status code (PF2: Z3/Z4/ZZ; WP2: Z0).

4) EXCLUDED (LVORM)
Deletion flag (LVORM=X) and no open PO/SES in the last 3 years.


5) EXCLUDED No activity and AEDAT between 6 months and 3 years ago.


6) EXCLUDED Plant is not Empty and in not in scope 

If WERKS = '' then there is no verification to be done.

Elseif Plant is in Scope


7) EXCLUDED Material Group Mapping (ZZM_GPS_MATKL)

Match ASMD‑MATKL to ZZM_GPS_MATKL‑MATKL with ZZMGOODSER='S'. If a match exists and LOEVM is not initial, the record is excluded. The solution publishes MAPPED/UNMAPPED reports for governance visibility.

If none of the above exclusions apply, the material is included (see topic 4 for more details).

===========================================================================================


TO BE INCLUDED


1) INCLUDED AEDAT (last change) within the last 6 months.


2) INCLUDED Any PO/SES activity within 3 years.


3) INCLUDED Default pass (no negatives matched).


========================================================================================<<<


gear *** Canonical Key & Duplication Detection

 

Deduplication of records from MARA and ASMD tables

Sequency

Table

International Version

Description

 ASMDText/Description MatchingCompare ASMD-KTEXT (service description) vs. MAKT-MAKTX (material description).
 ASMDUnit of Measure HarmonizationASMD-MEINS vs. MARA-MEINS (ensure consistency).
 ASMDLanguage-Dependent TextsCheck for alignment in key languages (EN, FR, DE, PT, etc.).
 ASMDFuzzy/Exact Match Rules

Normalize description strings (remove stop-words, punctuation, upper/lowercase).

Apply fuzzy matching thresholds (e.g., 90%) to detect duplicates between ASMD & MARA.


TableInternational VersionDescription
1MARACanonical Key & Core AttributesUse MATNR (normalized/padded), MTART=DIEN, MEINS, MATKL, BISMT (old material no.). Build canonical keys and compare base UoM, material group, and legacy numbers across systems.
2MAKTText/Description MatchingCompare short descriptions across languages; pick best language (e.g., EN > FR > DE > …), normalize text (case, punctuation, stop-words), and apply fuzzy/exact thresholds to detect duplicates.
3STXH/STXLLong-Text AlignmentRetrieve material long texts (TDOBJECT=‘MATERIAL’, TDNAME=MATNR padded). Normalize and compare paragraphs to consolidate duplicates with different short texts but same detailed content.
4MARMUnit-of-Measure HarmonizationAlign base/alternate UoMs and conversion factors; deduplicate only if UoM sets are compatible (UMREZ/UMREN); flag conflicts for review.
5MEANGTIN/EAN Cross-CheckUse EAN11/GTIN as high-confidence match key (often per UoM). Detect 1:n GTIN-to-material issues and reconcile where GTINs collide across systems.
6T006 / T006AUoM Dictionary (Intl.)Normalize UoM codes and texts across languages/systems before matching (ISO code, commercial vs technical UoM).
7T023 / T023TMaterial Group StandardizationHarmonize material groups and their texts to avoid false positives when different groups imply distinct services. Useful as a similarity feature and post-match validation.
8AUSP / INOB / CABN / CAWN / CAWNTClassification FingerprintIf classification is used, compare class/characteristic values as a strong dedup signal (same class & equal value set ⇒ higher confidence). Helps separate near-synonyms.
9EINA / EINE Vendor Catalog SignalsVendor material numbers/descriptions in Info Records can corroborate duplicates (same vendor ref across systems). Useful when GTINs are missing for DIEN.
10MVKESales View ConsistencyIf sales data exists, use product hierarchy and status as soft features; avoid merging items intentionally separated for commercial reasons.
11MARCPlant Extension OverlapPlant assignments can be used as a weak feature (same service used in same plants) and for post-merge impact checks.
  


TableInternational VersionDescription
 1ASMDCanonical Key & Core AttributesUse ASNUM (normalized), MEINS, MATKL, ERDAT/AEDAT, LVORM. Build canonical keys and compare base UoM and service group across systems. Compare ASMD-KTEXT (service description) vs. MAKT-MAKTX (material description).
 2ASMDTText/Description MatchingCompare language-dependent short descriptions (KTEXT) across locales; pick a “best language” (e.g., EN ), normalize text (case, punctuation, stop-words), then run exact/fuzzy thresholds to detect duplicates.
 3STXH / STXLLong-Text AlignmentRetrieve service long texts (SAPscript TDOBJECT = 'SERV'; typical TDIDs like GRUN). Normalize and compare paragraphs to catch duplicates with similar detailed content but differing short texts.
 4T006 / T006AUnit-of-Measure HarmonizationStandardize UoMs and texts before matching (ISO code mapping, singular/plural, commercial vs technical UoM) so MEINS comparisons are reliable.
 5T023 / T023TService Group StandardizationHarmonize MATKL and its texts across languages/systems; use as a similarity feature and post-match validation to prevent merging fundamentally different service groups.
 6AUSP / INOB / CABN / CAWN / CAWNT (if used)Classification FingerprintWhen services are classified, compare class/characteristic values (class type for services per your template) as a strong dedup signal—same class & equal value set ⇒ higher confidence.
 7EINA / EINE (optional)Vendor Catalog SignalsVendor service numbers/descriptions in Info Records can corroborate duplicates across systems when texts differ or UoMs are inconsistent.


...



Additional Information



Source Field InformationTransform RulesTarget Field Information
SequenceTechnical Source TableField NameTechnical Source FieldField FormatField LengthCommentsMapping TypeTransform Rule or Default ValueValidation RuleCommentsDataload TemplateSheet NameGroupField DescriptionBusiness DescriptionCheck TableBusiness Mandatory
Y/N/C
System Mandatory
Y/N/C
TypeLengthDecimalSap Table NameSap Field Name
xMARA - Material Basic Data

















MAKT - Material Descriptions
xMARAMATNRProduct NumberText (CHAR)18







Product NumberMaterial Number
YESYESText (CHAR)18
S_MARAMATNR
xMARAMTARTProduct TypeText (CHAR)80    MandatoryFixed ValueDefault Value = 'ZSER'




Product TypeProduct Type
YESYESText (CHAR)80    
S_MARAMTART
xMARAATTYPProduct CategoryText (CHAR)80    Mandatory






Product CategoryProduct Category
YESYESText (CHAR)80    
S_MARAATTYP
xMARASATNRConfiguration Product for Retail VariantText (CHAR)80    







Configuration Product for Retail VariantConfiguration Product for Retail Variant
YESYESText (CHAR)80    
S_MARASATNR
xMARAMATKLProduct Group (material group)Text (CHAR)80    MandatoryConversionUse the mapping table to apply the proper data conversion




Product GroupProduct Group
YESYESText (CHAR)80    
S_MARAMATKL
xMARAMBRSHIndustry SectorText (CHAR)80    MandatoryFixed ValueDefault Value = 'M'




Industry SectorIndustry Sector
YESYESText (CHAR)80    
S_MARAMBRSH
xMARAMAKTXDescriptionText (CHAR)40    Mandatory






DescriptionDescription
YESYESText (CHAR)40    
S_MARAMAKTX
xMARASPRASLanguage KeyText (CHAR)80    Mandatory






Language KeyLanguage Key
YESYESText (CHAR)80    
S_MARASPRAS
xMARAMEINSBase Unit of Measure (ISO Format)Text (CHAR)80    MandatoryConversionUse the mapping table to apply the proper data conversion




Base Unit of Measure (ISO Format)Base Unit of Measure (ISO Format)
YESYESText (CHAR)80    
S_MARAMEINS
xMARAAENNRChange NumberText (CHAR)80    







Change NumberChange Number
NONOText (CHAR)80    
S_MARAAENNR
xMARAREVLVRevision LevelText (CHAR)80    







Revision LevelRevision Level
NONOText (CHAR)80    
S_MARAREVLV
xMARAEAN11GTINText (CHAR)18    







GTINGTIN
NONOText (CHAR)18    
S_MARAEAN11
xMARANUMTPGTIN CategoryText (CHAR)80    







GTIN CategoryGTIN Category
NONOText (CHAR)80    
S_MARANUMTP
xMARASPARTDivisionText (CHAR)80    







DivisionDivision
NONOText (CHAR)80    
S_MARASPART
xMARABISMTOld Product NumberText (CHAR)40    







Old Product NumberOld Product Number
NONOText (CHAR)40    
S_MARABISMT
xMARAPRDHAProduct HierarchyText (CHAR)80    







Product HierarchyProduct Hierarchy
NONOText (CHAR)80    
S_MARAPRDHA
xMARABRAND_IDBrandText (CHAR)80    







BrandBrand
NONOText (CHAR)80    
S_MARABRAND_ID
xMARAXCHPFBatch Management Required Ind.Text (CHAR)1     







Batch Management Required Ind.Batch Management Required Ind.
NONOText (CHAR)1     
S_MARAXCHPF
xMARAMLGUTHas EmptiesText (CHAR)1     







Has EmptiesHas Empties
NONOText (CHAR)1     
S_MARAMLGUT
xMARADATABValid FromDate10







Valid FromValid From
NONODate10
S_MARADATAB
xMARALIQDTDeletion DateDate10







Deletion DateDeletion Date
NONODate10
S_MARALIQDT
xMARAKUNNRCompetitorText (CHAR)80    







CompetitorCompetitor
NONOText (CHAR)80    
S_MARAKUNNR
xMARANORMTIndustry Standard DescriptionText (CHAR)18    







Industry Standard DescriptionIndustry Standard Description
NONOText (CHAR)18    
S_MARANORMT
xMARAGROESSize/DimensionsText (CHAR)32    







Size/DimensionsSize/Dimensions
NONOText (CHAR)32    
S_MARAGROES
xMARALABORLaboratory / Design OfficeText (CHAR)80    







Laboratory / Design OfficeLaboratory / Design Office
NONOText (CHAR)80    
S_MARALABOR
xMARAINHALNet ContentsNumber (NUMC)13    







Net ContentsNet Contents
NONONumber (NUMC)13    
S_MARAINHAL
xMARAINHMENet Contents Unit (ISO Format)Text (CHAR)80    







Net Contents Unit (ISO Format)Net Contents Unit (ISO Format)
NONOText (CHAR)80    
S_MARAINHME
xMARAINHBRGross ContensNumber (NUMC)13    







Gross ContensGross Contens
NONONumber (NUMC)13    
S_MARAINHBR
xMARAVPREHComparison Price UnitNumber (NUMC)5     







Comparison Price UnitComparison Price Unit
NONONumber (NUMC)5     
S_MARAVPREH
xMARAEXTWGExternal Product GroupText (CHAR)80    







External Product GroupExternal Product Group
NONOText (CHAR)80    
S_MARAEXTWG
xMARAMTPOS_MARAGeneral Item Category GroupText (CHAR)80    







General Item Category GroupGeneral Item Category Group
NONOText (CHAR)80    
S_MARAMTPOS_MARA
xMARABEGRUAuthorization GroupText (CHAR)4     







Authorization GroupAuthorization Group
NONOText (CHAR)4     
S_MARABEGRU
xMARAMSTAECross-Plant Product StatusText (CHAR)80    







Cross-Plant Product StatusCross-Plant Product Status
NONOText (CHAR)80    
S_MARAMSTAE
xMARAMSTDEValid-From DateDate








Valid-From DateValid-From Date
NONODate10
S_MARAMSTDE
xMARASERLVLevel of Explicitness for Serial NumberText (CHAR)80    







Level of Explicitness for Serial NumberLevel of Explicitness for Serial Number
NONOText (CHAR)80    
S_MARASERLV
xMARAQMPURQuality Manag. in Procurement Is ActiveText (CHAR)1     







Quality Manag. in Procurement Is ActiveQuality Manag. in Procurement Is Active
NONOText (CHAR)1     
S_MARAQMPUR
xMARAANIMAL_ORIGINAnimal OriginText (CHAR)1     







Animal OriginAnimal Origin
NONOText (CHAR)1     
S_MARAANIMAL_ORIGIN
xMARAANPANP CodeText (CHAR)80    







ANP CodeANP Code
NONOText (CHAR)80    
S_MARAANP
xMARABRGEWGross WeightNumber (NUMC)13    







Gross WeightGross Weight
NONONumber (NUMC)13    
S_MARABRGEW
xMARANTGEWNet WeightNumber (NUMC)13    







Net WeightNet Weight
NONONumber (NUMC)13    
S_MARANTGEW
xMARAGEWEIUnit of Weight (ISO Format)Text80    







Unit of Weight (ISO Format)Unit of Weight (ISO Format)
NONOText80    
S_MARAGEWEI
xMARALAENGLengthNumber (NUMC)13    







LengthLength
NONONumber (NUMC)13    
S_MARALAENG
xMARABREITWidthNumber (NUMC)13    







WidthWidth
NONONumber (NUMC)13    
S_MARABREIT
xMARAHOEHEHeightNumber (NUMC)13    







HeightHeight
NONONumber (NUMC)13    
S_MARAHOEHE
xMARAMEABMUnit for Length/Width/Height(ISO Format)Text (CHAR)80    







Unit for Length/Width/Height(ISO Format)Unit for Length/Width/Height(ISO Format)
NONOText (CHAR)80    
S_MARAMEABM
xMARAVOLUMVolumeNumber (NUMC)13    







VolumeVolume
NONONumber (NUMC)13    
S_MARAVOLUM
xMARAVOLEHVolume UnitText (CHAR)80    







Volume UnitVolume Unit
NONOText (CHAR)80    
S_MARAVOLEH
xMARACAPAUSECapacity UsageNumber (NUMC)15    







Capacity UsageCapacity Usage
NONONumber (NUMC)15    
S_MARACAPAUSE
xMARACHML_CMPLNC_RLVNCE_INDCompliance RelevantText (CHAR)80    







Compliance RelevantCompliance Relevant
NONOText (CHAR)80    
S_MARACHML_CMPLNC_RLVNCE_IND
xMARAKZKFGProduct Is ConfigurableText (CHAR)1     







Product Is ConfigurableProduct Is Configurable
NONOText (CHAR)1     
S_MARAKZKFG
xMARABSTMEOrder Unit of Measure (ISO Format)Text (CHAR)80    







Order Unit of Measure (ISO Format)Order Unit of Measure (ISO Format)
NONOText (CHAR)80    
S_MARABSTME
xMARAEKWSLPurchasing Value KeyText (CHAR)80    







Purchasing Value KeyPurchasing Value Key
NONOText (CHAR)80    
S_MARAEKWSL
xMARAVABMEState of Variable Purchase Order UnitText (CHAR)80    







State of Variable Purchase Order UnitState of Variable Purchase Order Unit
NONOText (CHAR)80    
S_MARAVABME
xMARABMATNInternal Product NumberText (CHAR)80    







Internal Product NumberInternal Product Number
NONOText (CHAR)80    
S_MARABMATN
xMARAMFRPNManufacturer Part NumberText (CHAR)40    







Manufacturer Part NumberManufacturer Part Number
NONOText (CHAR)40    
S_MARAMFRPN
xMARAMFRNRManufacturer NumberText (CHAR)80    







Manufacturer NumberManufacturer Number
NONOText (CHAR)80    
S_MARAMFRNR
xMARAMPROFManufacturer Part ProfileText (CHAR)80    







Manufacturer Part ProfileManufacturer Part Profile
NONOText (CHAR)80    
S_MARAMPROF
xMARATRAGRTransportation GroupText (CHAR)80    







Transportation GroupTransportation Group
NONOText (CHAR)80    
S_MARATRAGR
xMARAMSTAV Cross-Distribution Chain Product StatusText (CHAR)80    







Cross-Distribution Chain Product StatusCross-Distribution Chain Product Status
NONOText (CHAR)80    
S_MARAMSTAV 
xMARAMSTDVValid From Date for StatusDate10







Valid From Date for StatusValid From Date for Status
NONODate10
S_MARAMSTDV
xMARAPMATAPricing Reference ProductText (CHAR)80    







Pricing Reference ProductPricing Reference Product
NONOText (CHAR)80    
S_MARAPMATA
xMARASPROFPricing Profile for VariantsText (CHAR)80    







Pricing Profile for VariantsPricing Profile for Variants
NONOText (CHAR)80    
S_MARASPROF
xMARAALLOW_PMAT_IGNOVariant Price AllowedText (CHAR)1     







Variant Price AllowedVariant Price Allowed
NONOText (CHAR)1     
S_MARAALLOW_PMAT_IGNO
xMARASOM_CYCLEBilling CycleText (CHAR)80    







Billing CycleBilling Cycle
NONOText (CHAR)80    
S_MARASOM_CYCLE
xMARASOM_CYCLE_RULEBilling Cycle Determination RuleText (CHAR)80    







Billing Cycle Determination RuleBilling Cycle Determination Rule
NONOText (CHAR)80    
S_MARASOM_CYCLE_RULE
xMARASOM_TC_SCHEMAAssignment SchemaText (CHAR)80    







Assignment SchemaAssignment Schema
NONOText (CHAR)80    
S_MARASOM_TC_SCHEMA
xMARABBTYPAssortment List TypeText (CHAR)80    







Assortment List TypeAssortment List Type
NONOText (CHAR)80    
S_MARABBTYP
xMARASERVVService AgreementText (CHAR)80    







Service AgreementService Agreement
NONOText (CHAR)80    
S_MARASERVV
xMARAMAGRVProduct Group: Packaging MaterialsText (CHAR)80    







Product Group: Packaging MaterialsProduct Group: Packaging Materials
NONOText (CHAR)80    
S_MARAMAGRV
xMARAVHIARTPackaging Product TypeText (CHAR)80    







Packaging Product TypePackaging Product Type
NONOText (CHAR)80    
S_MARAVHIART
xMARAERGEWAllowed Packaging WeightNumber (NUMC)13    







Allowed Packaging WeightAllowed Packaging Weight
NONONumber (NUMC)13    
S_MARAERGEW
xMARAERGEIUnit of Allowed Packaging WeightText (CHAR)80    







Unit of Allowed Packaging WeightUnit of Allowed Packaging Weight
NONOText (CHAR)80    
S_MARAERGEI
xMARAGEWTOExcess Weight Tolerance for HUNumber (NUMC)3     







Excess Weight Tolerance for HUExcess Weight Tolerance for HU
NONONumber (NUMC)3     
S_MARAGEWTO
xMARAERVOLAllowed Packaging VolumeNumber (NUMC)13    







Allowed Packaging VolumeAllowed Packaging Volume
NONONumber (NUMC)13    
S_MARAERVOL
xMARAERVOEUnit of Allowed Packaging VolumeText (CHAR)80    







Unit of Allowed Packaging VolumeUnit of Allowed Packaging Volume
NONOText (CHAR)80    
S_MARAERVOE
xMARAKZGVHPackaging Product Is Closed PackagingText (CHAR)1     







Packaging Product Is Closed PackagingPackaging Product Is Closed Packaging
NONOText (CHAR)1     
S_MARAKZGVH
xMARAVOLTOExcess Volume Tolerance for HUNumber (NUMC)3     







Excess Volume Tolerance for HUExcess Volume Tolerance for HU
NONONumber (NUMC)3     
S_MARAVOLTO
xMARAIPRKZPeriod Indicator for Shelf LifeText (CHAR)80    







Period Indicator for Shelf LifePeriod Indicator for Shelf Life
NONOText (CHAR)80    
S_MARAIPRKZ
xMARARAUBEStorage ConditionsText (CHAR)80    







Storage ConditionsStorage Conditions
NONOText (CHAR)80    
S_MARARAUBE
xMARATEMPBTemperature Conditions IndicatorText (CHAR)80    







Temperature Conditions IndicatorTemperature Conditions Indicator
NONOText (CHAR)80    
S_MARATEMPB
xMARABEHVOContainer RequirementsText (CHAR)80    







Container RequirementsContainer Requirements
NONOText (CHAR)80    
S_MARABEHVO
xMARASTOFFHazardous Product NumberText (CHAR)40    







Hazardous Product NumberHazardous Product Number
NONOText (CHAR)40    
S_MARASTOFF
xMARAETIARLabel TypeText (CHAR)80    







Label TypeLabel Type
NONOText (CHAR)80    
S_MARAETIAR
xMARAETIFOLabel FormText (CHAR)80    







Label FormLabel Form
NONOText (CHAR)80    
S_MARAETIFO
xMARAWESCHNumber of Goods Receipt/Issue SlipsNumber (NUMC)13    







Number of Goods Receipt/Issue SlipsNumber of Goods Receipt/Issue Slips
NONONumber (NUMC)13    
S_MARAWESCH
xMARAXGCHPIndicator: Approved Batch Rec. RequiredText (CHAR)1     







Indicator: Approved Batch Rec. RequiredIndicator: Approved Batch Rec. Required
NONOText (CHAR)1     
S_MARAXGCHP
xMARAMHDHBTotal Shelf LifeNumber (NUMC)4     







Total Shelf LifeTotal Shelf Life
NONONumber (NUMC)4     
S_MARAMHDHB
xMARAMHDRZMinimum Remaining Shelf LifeNumber (NUMC)4     







Minimum Remaining Shelf LifeMinimum Remaining Shelf Life
NONONumber (NUMC)4     
S_MARAMHDRZ
xMARASLED_BBDIndi. for the Shelf Life Expiration DateText (CHAR)80    







Indi. for the Shelf Life Expiration DateIndi. for the Shelf Life Expiration Date
NONOText (CHAR)80    
S_MARASLED_BBD
xMARAMHDLPStorage PercentageNumber (NUMC)3     







Storage PercentageStorage Percentage
NONONumber (NUMC)3     
S_MARAMHDLP
xMARARDMHDRounding Rule for Calculation of SLEDText (CHAR)80    







Rounding Rule for Calculation of SLEDRounding Rule for Calculation of SLED
NONOText (CHAR)80    
S_MARARDMHD
xMARAHNDLCODEHandling IndicatorText (CHAR)80    







Handling IndicatorHandling Indicator
NONOText (CHAR)80    
S_MARAHNDLCODE
xMARAWHMATGRWarehouse Product GroupText (CHAR)80    







Warehouse Product GroupWarehouse Product Group
NONOText (CHAR)80    
S_MARAWHMATGR
xMARAWHSTCWarehouse Storage ConditionText (CHAR)80    







Warehouse Storage ConditionWarehouse Storage Condition
NONOText (CHAR)80    
S_MARAWHSTC
xMARAHUTYP_DFLTStandard Handling Unit TypeText (CHAR)80    







Standard Handling Unit TypeStandard Handling Unit Type
NONOText (CHAR)80    
S_MARAHUTYP_DFLT
xMARASERIALSerial Number ProfileText (CHAR)80    







Serial Number ProfileSerial Number Profile
NONOText (CHAR)80    
S_MARASERIAL
xMARAPILFERABLEPilferableText (CHAR)1     







PilferablePilferable
NONOText (CHAR)1     
S_MARAPILFERABLE
xMARAHAZMATRelevant for Hazardous SubstancesText (CHAR)1     







Relevant for Hazardous SubstancesRelevant for Hazardous Substances
NONOText (CHAR)1     
S_MARAHAZMAT
xMARAQQTIMEQuarantine PeriodNumber (NUMC)3     







Quarantine PeriodQuarantine Period
NONONumber (NUMC)3     
S_MARAQQTIME
xMARAQQTIMEUOMTime Unit for Quarantine PeriodText (CHAR)80    







Time Unit for Quarantine PeriodTime Unit for Quarantine Period
NONOText (CHAR)80    
S_MARAQQTIMEUOM
xMARAQGRPQuality Inspection GroupText (CHAR)80    







Quality Inspection GroupQuality Inspection Group
NONOText (CHAR)80    
S_MARAQGRP
xMARAHUTYPHandling Unit TypeText (CHAR)80    







Handling Unit TypeHandling Unit Type
NONOText (CHAR)80    
S_MARAHUTYP
xMARAMAXCMaximum CapacityNumber (NUMC)15    







Maximum CapacityMaximum Capacity
NONONumber (NUMC)15    
S_MARAMAXC
xMARAMAXC_TOLOvercapacity ToleranceNumber (NUMC)3     







Overcapacity ToleranceOvercapacity Tolerance
NONONumber (NUMC)3     
S_MARAMAXC_TOL
xMARATARE_VARVariable Tare WeightText (CHAR)1     







Variable Tare WeightVariable Tare Weight
NONOText (CHAR)1     
S_MARATARE_VAR
xMARAMAXLMax. Pack. LengthNumber (NUMC)15    







Max. Pack. LengthMax. Pack. Length
NONONumber (NUMC)15    
S_MARAMAXL
xMARAMAXDIM_UOMUoM for Max. Pack. Length (ISO Format)Text (CHAR)80    







UoM for Max. Pack. Length (ISO Format)UoM for Max. Pack. Length (ISO Format)
NONOText (CHAR)80    
S_MARAMAXDIM_UOM
xMARAMAXBMax. Pack. WidthNumber (NUMC)15    







Max. Pack. WidthMax. Pack. Width
NONONumber (NUMC)15    
S_MARAMAXB
xMARAMAXHMax. Pack. HeightNumber (NUMC)15    







Max. Pack. HeightMax. Pack. Height
NONONumber (NUMC)15    
S_MARAMAXH
xMARARBNRMCatalog ProfileText (CHAR)80    







Catalog ProfileCatalog Profile
NONOText (CHAR)80    
S_MARARBNRM
xMARASSTUFAssortment GradeText (CHAR)80    







Assortment GradeAssortment Grade
NONOText (CHAR)80    
S_MARASSTUF
xMARALSTVZListing ProcedureText (CHAR)80    







Listing ProcedureListing Procedure
NONOText (CHAR)80    
S_MARALSTVZ
xMARALDVZLListing Period Start DateDate10







Listing Period Start DateListing Period Start Date
NONODate10
S_MARALDVZL
xMARALDBZLListing Period End DateDate10







Listing Period End DateListing Period End Date
NONODate10
S_MARALDBZL
xMARALSTFLListing ProcedureText (CHAR)80    







Listing ProcedureListing Procedure
NONOText (CHAR)80    
S_MARALSTFL
xMARALDVFLListing Period Start DateDate10







Listing Period Start DateListing Period Start Date
NONODate10
S_MARALDVFL
xMARALDBFLListing Period End DateDate10







Listing Period End DateListing Period End Date
NONODate10
S_MARALDBFL
xMARAVDVZLSales Period Start DateDate10







Sales Period Start DateSales Period Start Date
NONODate10
S_MARAVDVZL
xMARAVDBZLSales Period End DateDate10







Sales Period End DateSales Period End Date
NONODate10
S_MARAVDBZL
xMARAVDVFLSales Period Start DateDate10







Sales Period Start DateSales Period Start Date
NONODate10
S_MARAVDVFL
xMARAVDBFLSales Period End DateDate10







Sales Period End DateSales Period End Date
NONODate10
S_MARAVDBFL
xMARAWAUSMDelivery Unit of Measure (ISO Format)Text (CHAR)80    







Delivery Unit of Measure (ISO Format)Delivery Unit of Measure (ISO Format)
NONOText (CHAR)80    
S_MARAWAUSM
xMARAWVRKMSales Unit of Measure (ISO Format)Text (CHAR)80    







Sales Unit of Measure (ISO Format)Sales Unit of Measure (ISO Format)
NONOText (CHAR)80    
S_MARAWVRKM
xMARAWMAABABC IndicatorText (CHAR)80    







ABC IndicatorABC Indicator
NONOText (CHAR)80    
S_MARAWMAAB
xMARAWBKLAValuation ClassText (CHAR)80    







Valuation ClassValuation Class
NONOText (CHAR)80    
S_MARAWBKLA
xMARAWHERLCountry/Region of OriginText (CHAR)80    







Country/Region of OriginCountry/Region of Origin
NONOText (CHAR)80    
S_MARAWHERL
xMARAWHERRRegion of OriginText (CHAR)80    







Region of OriginRegion of Origin
NONOText (CHAR)80    
S_MARAWHERR
xMARAWEKGRPurchasing GroupText (CHAR)80    







Purchasing GroupPurchasing Group
NONOText (CHAR)80    
S_MARAWEKGR
xMARABWSCLSource of SupplyText (CHAR)80    







Source of SupplySource of Supply
NONOText (CHAR)80    
S_MARABWSCL
xMARATAKLVTax ClassificationText (CHAR)80    







Tax ClassificationTax Classification
NONOText (CHAR)80    
S_MARATAKLV
xMARAWLADGLoading GroupText (CHAR)80    







Loading GroupLoading Group
NONOText (CHAR)80    
S_MARAWLADG
xMARAWBWSPValuation MarginNumber (NUMC)6     







Valuation MarginValuation Margin
NONONumber (NUMC)6     
S_MARAWBWSP
xMARAPSTATQIndicator: QualityText (CHAR)1     







Indicator: QualityIndicator: Quality
NONOText (CHAR)1     
S_MARAPSTATQ
xMARAPSTATVIndicator: SalesText (CHAR)1     







Indicator: SalesIndicator: Sales
NONOText (CHAR)1     
S_MARAPSTATV
xMARAPSTATLIndicator: StorageText (CHAR)1     







Indicator: StorageIndicator: Storage
NONOText (CHAR)1     
S_MARAPSTATL
xMARAPSTATEIndicator: PurchasingText (CHAR)1     







Indicator: PurchasingIndicator: Purchasing
NONOText (CHAR)1     
S_MARAPSTATE
























xMAKT - Material Descriptions

















MAKT - Material Descriptions
xMAKTMATNRProduct NumberText (CHAR)18Mandatory






Product NumberMaterial Number
YESYESText (CHAR)18
S_MAKTMATNR
xMAKTSPRASLanguage KeyText (CHAR)2    Mandatory






Language KeyLanguage Key
YESYESText (CHAR)2    
S_MAKTSPRAS
xMAKTMAKTXProduct DescriptionText (CHAR)40    Mandatory






Product DescriptionProduct Description
YESYESText (CHAR)40    
S_MAKTMAKTX
























xMARM - Units of Measure for Material

















MARM - Units of Measure for Material
xMARMPRODUCTProduct NumberText (CHAR)80    Mandatory






Product NumberMaterial Number
YESYESText (CHAR)80    
S_MARMMATNR
xMARMMEINHAlternative Unit of Measure (ISO Format)Text (CHAR)80    Mandatory






Alternative Unit of Measure (ISO Format)Alternative Unit of Measure (ISO Format)

YESText (CHAR)80    
S_MARMMEINH
xMARMUMRENDenominator for Conversion to Base UnitNumber (NUMC)5     Mandatory






Denominator for Conversion to Base UnitDenominator for Conversion to Base Unit
YESYESNumber (NUMC)5     
S_MARMUMREN
xMARMUMREZNumerator for Conversion to Base UnitNumber (NUMC)5     Mandatory






Numerator for Conversion to Base UnitNumerator for Conversion to Base Unit
YESYESNumber (NUMC)5     
S_MARMUMREZ
xMARMEAN11GTINText (CHAR)18    







GTINGTIN
NONOText (CHAR)18    
S_MARMEAN11
xMARMNUMTPGTIN CategoryText (CHAR)80    







GTIN CategoryGTIN Category
NONOText (CHAR)80    
S_MARMNUMTP
xMARMLAENGLengthNumber (NUMC)13    







LengthLength
NONONumber (NUMC)13    
S_MARMLAENG
xMARMBREITWidthNumber (NUMC)13    







WidthWidth
NONONumber (NUMC)13    
S_MARMBREIT
xMARMHOEHEHeightNumber (NUMC)13    







HeightHeight
NONONumber (NUMC)13    
S_MARMHOEHE
xMARMMEABMUnit for Length/Width/Height(ISO Format)Text (CHAR)80    







Unit for Length/Width/Height(ISO Format)Unit for Length/Width/Height(ISO Format)
NONOText (CHAR)80    
S_MARMMEABM
xMARMBRGEWGross WeightNumber (NUMC)13    







Gross WeightGross Weight
NONONumber (NUMC)13    
S_MARMBRGEW
xMARMGEWEIUnit of Weight (ISO Format)Text (CHAR)80    







Unit of Weight (ISO Format)Unit of Weight (ISO Format)
NONOText (CHAR)80    
S_MARMGEWEI
xMARMVOLUMVolumeNumber (NUMC)13    







VolumeVolume
NONONumber (NUMC)13    
S_MARMVOLUM
xMARMVOLEHVolume Unit (ISO Format)Text (CHAR)80    







Volume Unit (ISO Format)Volume Unit (ISO Format)
NONOText (CHAR)80    
S_MARMVOLEH
xMARMCAPAUSECapacity UsageNumber (NUMC)15    







Capacity UsageCapacity Usage
NONONumber (NUMC)15    
S_MARMCAPAUSE
























xMLAN - Tax Classification for Material

















S_MLAN - Tax Classification for Material
xMLANPRODUCTProduct NumberText (CHAR)80    Mandatory






Product NumberMaterial Number
YESYESText (CHAR)80    
S_MLANMATNR
xMLANALANDCountry/RegionText (CHAR)80    Mandatory






Country/RegionCountry/Region
YESYESText (CHAR)80    
S_MLANALAND
xMLANTATYP1Tax Category 1Text (CHAR)80    Mandatory






Tax Category 1Tax Category 1
YESYESText (CHAR)80    
S_MLANTATYP1
xMLANTAXM1Tax Classification 1Text (CHAR)80    Mandatory






Tax Classification 1Tax Classification 1
YESYESText (CHAR)80    
S_MLANTAXM1
xMLANTATYP2Tax Category 2Text (CHAR)80    







Tax Category 2Tax Category 2
NONOText (CHAR)80    
S_MLANTATYP2
xMLANTAXM2Tax Classification 2Text (CHAR)80    







Tax Classification 2Tax Classification 2
NONOText (CHAR)80    
S_MLANTAXM2
xMLANTATYP3Tax Category 3Text (CHAR)80    







Tax Category 3Tax Category 3
NONOText (CHAR)80    
S_MLANTATYP3
xMLANTAXM3Tax Classification 3Text (CHAR)80    







Tax Classification 3Tax Classification 3
NONOText (CHAR)80    
S_MLANTAXM3
xMLANTATYP4Tax Category 4Text (CHAR)80    







Tax Category 4Tax Category 4
NONOText (CHAR)80    
S_MLANTATYP4
xMLANTAXM4Tax Classification 4Text (CHAR)80    







Tax Classification 4Tax Classification 4
NONOText (CHAR)80    
S_MLANTAXM4
xMLANTATYP5Tax Category 5Text (CHAR)80    







Tax Category 5Tax Category 5
NONOText (CHAR)80    
S_MLANTATYP5
xMLANTAXM5Tax Classification 5Text (CHAR)80    







Tax Classification 5Tax Classification 5
NONOText (CHAR)80    
S_MLANTAXM5
xMLANTATYP6Tax Category 6Text (CHAR)80    







Tax Category 6Tax Category 6
NONOText (CHAR)80    
S_MLANTATYP6
xMLANTAXM6Tax Classification 6Text (CHAR)80    







Tax Classification 6Tax Classification 6
NONOText (CHAR)80    
S_MLANTAXM6
xMLANTATYP7Tax Category 7Text (CHAR)80    







Tax Category 7Tax Category 7
NONOText (CHAR)80    
S_MLANTATYP7
xMLANTAXM7Tax Classification 7Text (CHAR)80    







Tax Classification 7Tax Classification 7
NONOText (CHAR)80    
S_MLANTAXM7
xMLANTATYP8Tax Category 8Text (CHAR)80    







Tax Category 8Tax Category 8
NONOText (CHAR)80    
S_MLANTATYP8
xMLANTAXM8Tax Classification 8Text (CHAR)80    







Tax Classification 8Tax Classification 8
NONOText (CHAR)80    
S_MLANTAXM8
xMLANTATYP9Tax Category 9Text (CHAR)80    







Tax Category 9Tax Category 9
NONOText (CHAR)80    
S_MLANTATYP9
xMLANTAXM9Tax Classification 9Text (CHAR)80    







Tax Classification 9Tax Classification 9
NONOText (CHAR)80    
S_MLANTAXM9
























xCLASS - Class Header Data (KLAH)

















CLASS - Class Header Data (KLAH)
xCLASSPRODUCTProduct NumberText (CHAR)18Mandatory






Product NumberMaterial Number
YESYESText (CHAR)18
S_CLASSMATNR
xCLASSCLASSClassText (CHAR)80    Mandatory






Class

YESYESText (CHAR)80    
S_CLASSCLASS
xCLASSCLASSTYPEClass TypeText (CHAR)80    Mandatory






Class Type

YESYESText (CHAR)80    
S_CLASSCLASSTYPE
























xCHARACT - Characteristic (CABN)

















S_CHARACT - Characteristic (CABN)
xCHARACTPRODUCTProduct NumberText (CHAR)80    Mandatory






Product NumberMaterial Number
YESYESText (CHAR)80    
S_CHARACTMATNR
xCHARACTCLASSClassText (CHAR)80    Mandatory






Class

YESYESText (CHAR)80    
S_CHARACTCLASS
xCHARACTCLASSTYPEClass TypeText (CHAR)80    Mandatory






Class Type

YESYESText (CHAR)80    
S_CHARACTCLASSTYPE
xCHARACTATNAMCharacteristic NameText (CHAR)80    Mandatory






Characteristic Name

YESYESText (CHAR)80    
S_CHARACTATNAM
xCHARACTPOSNRItemText (CHAR)3     







Item

NONOText (CHAR)3     
S_CHARACTPOSNR
xCHARACTVALUE_CHARCharacter ValueText (CHAR)70    







Character Value

NONOText (CHAR)70    
S_CHARACTVALUE_CHAR
xCHARACTVALUE_NUMCNumeric ValueNumber (NUMC)16    







Numeric Value

NONONumber (NUMC)16    
S_CHARACTVALUE_NUMC
xCHARACTVALUE_DATEDateDate








Date

NONODate10
S_CHARACTVALUE_DATE
xCHARACTVALUE_TIMETimeTime








Time

NONOTime8
S_CHARACTVALUE_TIME
xCHARACTVALUE_CURRCurrency ValueNumber (NUMC)23    







Currency Value

NONONumber (NUMC)23    
S_CHARACTVALUE_CURR
























xSTXH - SAPscript Text Header

















STXH - SAPscript Text Header
xSTXHTDOBJECTText Object (e.g., MATERIAL, VENDOR, etc.)CHAR10Mandatory






Text Object (e.g., MATERIAL, VENDOR, etc.)

NONOCHAR10
STXHTDOBJECT
xSTXHTDNAMEText Name (object key, e.g., material number, PO number)CHAR70Mandatory






Text Name (object key, e.g., material number, PO number)

NONOCHAR70
STXHTDNAME
xSTXHTDIDText ID (text type, e.g., F01 = Header Text, L01 = Item Text)CHAR4Mandatory






Text ID (text type, e.g., F01 = Header Text, L01 = Item Text)

NONOCHAR4
STXHTDID
xSTXHTDSPRASLanguage KeyLANG1Mandatory






Language Key

NONOLANG1
STXHTDSPRAS
xSTXHTDTITLETitle of the text (optional short description)CHAR60Mandatory






Title of the text (optional short description)

NONOCHAR60
STXHTDTITLE
xSTXHTDFUSERLast Changed by (user)CHAR12







Last Changed by (user)

NONOCHAR12
STXHTDFUSER
xSTXHTDFDATEDate of Last ChangeDATS8







Date of Last Change

NONODATS8
STXHTDFDATE
xSTXHTDFTIMETime of Last ChangeTIMS6







Time of Last Change

NONOTIMS6
STXHTDFTIME
xSTXHTDVERSIONVersion Number of TextNUMC4







Version Number of Text

NONONUMC4
STXHTDVERSION
xSTXHTDLOCKLock IndicatorCHAR1







Lock Indicator

NONOCHAR1
STXHTDLOCK
xSTXHTDTRANSTATTranslation StatusCHAR1







Translation Status

NONOCHAR1
STXHTDTRANSTAT
xSTXHTDOSPRASOriginal LanguageLANG1







Original Language

NONOLANG1
STXHTDOSPRAS
























xSTXL - SAPscript Text File (Cluster)

















STXL - SAPscript Text File (Cluster)
xSTXLRELIDCluster Area (ID of cluster; for texts usually "TX")Text (CHAR)2Mandatory






Cluster Area (ID of cluster; for texts usually "TX")

NONOText (CHAR)2
STXLRELID
xSTXLTDOBJECTText Object (e.g., MATERIAL, VENDOR, etc.)Text (CHAR)10Mandatory






Text Object (e.g., MATERIAL, VENDOR, etc.)

NONOText (CHAR)10
STXLTDOBJECT
xSTXLTDNAMEText Name (object key, e.g., material number, purchase order)Text (CHAR)70Mandatory






Text Name (object key, e.g., material number, purchase order)

NONOText (CHAR)70
STXLTDNAME
xSTXLTDIDText ID (text type, e.g., F01 = header text, L01 = item text)Text (CHAR)4Mandatory






Text ID (text type, e.g., F01 = header text, L01 = item text)

NONOText (CHAR)4
STXLTDID
xSTXLTDSPRASLanguage KeyLanguage (LANG)1Mandatory






Language Key

NONOLanguage (LANG)1
STXLTDSPRAS
xSTXLSRTF2Sort number (used to split large texts across several cluster entries)Numeric (NUMC)3







Sort number (used to split large texts across several cluster entries)

NONONumeric (NUMC)3
STXLSRTF2
xSTXLCLUSTRLength field for cluster (internal, technical)Integer (INT2)5







Length field for cluster (internal, technical)

NONOInteger (INT2)5
STXLCLUSTR
xSTXLCLUSTDLength field for cluster (internal, technical)Integer (INT2)5







Length field for cluster (internal, technical)

NONOInteger (INT2)5
STXLCLUSTD
xSTXLVARTEXTCompressed text data (the actual long text, stored in cluster format)(RAW)255







Compressed text data (the actual long text, stored in cluster format)

NONO(RAW)255
STXLVARTEXT


























Extraction Methods and File Types

Data is Extracted and Transformed by Syniti ADM, the stagging area of the Migration Cockpit is updated.

Multi-language Requirement

For all Lean Services in the target S/4HANA system, the default description will be maintaineed in English.

Where available in the source systems (PF2, WP2), additional language-dependent descriptions will also be migrated. This applies to both:

  • Service Master records (ASMD).

  • Materials-as-Services (Material Type DIEN or equivalent).


Migration rules:

  • Only languages available and supported in the target S/4HANA system will be migrated.

  • If a description exists in a custom or unsupported language key in the source, that language entry will be skipped.

  • The migration will preserve the link between the Lean Service material number and each language-specific description.

  • Where the same service exists in multiple languages in the source, all valid language versions will be migrated together with the default English text.

This approach ensures that Lean Services are available in multiple languages for purchasing, reporting, and user interaction, while maintaining compliance with the target system’s supported language set.


Languages to be extracted (available on Source Systems)

SAP standard supports all ISO languages, ensure that all standard languages are considered in scope.


Languages to don't be extracted

The Z9 language code represents “Multilingual / Other,” which is a generic placeholder rather than a specific language. It does not correspond to a standard ISO language code and therefore cannot be mapped reliably to a target language in the S/4HANA environment. Including Z9 would result in ambiguous or duplicate entries, making data validation, reporting, and translation maintenance inconsistent. To ensure data quality and consistency, records with Z9 will be excluded from the extraction scope.

International Version

Description

Z9Multilingual / Other


Document Management

N/A.

Legal Requirement

Minor efforts with taxation are foreseen for some specific countries having specific taxations, the topic is limited to have the tax codes mapping (from Old to New tax code).


Special Requirements

Processing Type ETL: 

  • Transformation (T): Syniti will be responsible for cleansing, transforming, and merging the data, as well as updating the staging areas of the SAP Migration Cockpit.

  • Extraction (E): Data will be extracted from at least two source systems. This activity will be performed by Syniti.

  • Loading (L): The final data load into the target SAP system will be carried out using the standard functionalities of the SAP Migration Cockpit.
    • The decided loading tool is called 'Service Product' and is available on the migration cockpit


Deduplication Rules

Ensure that Lean Service Materials (stored in MARA and related tables) are unique and free of redundancies prior to migration into S/4HANA. The rules mentioned below validate duplicates across standardized descriptions, language, material group, and units of measure, while also considering long texts for confirmation.


Additionally, unsupported or custom languages (such as Z9) are excluded unless explicitly required, ensuring alignment with SAP standard language configurations. This prevents proliferation of redundant Lean Service materials and supports a harmonized catalog in the target system.

SYSTEM

Rule ID

Semantic Rule

PF2

SR01



Deduplication of Services Master (table ASMD) from PF2 & WP2: 
- DEDUP 1: Exclude from the deduplication rule services where the Deletion Flag is set ASMD-LOEKZ <> "" (marked for deletion)
- DEDUP 2: In case the Short Text (ASMD-KTEXT) + Language Key (ASMD-SPRAS) are identical, this is an indication of a duplicated entry
- DEDUP 3: In case the Material Group (ASMD-MATKL) or two or more records are identical, this is an indication of a duplicated entry
- DEDUP 4: In case the Base Unit of Measure (ASMD-MEINS) in combination of the Topics 2 & 3 are identical, this is an indication of a duplicated entry
- DEDUP 5: In case the Long Text / Additional Descriptions (STXL/STXB) are exactly the same, this is an indication of a duplicated entry

SR02

Deduplication of Services Materials (table MARA) from PF2 & WP2:

- DEDUP 1: Drop any record technically blocked or marked for deletion in source. Check field MARA-LOEKZ (or equivalent for Lean Services).
- DEDUP 2: A duplicate exists if the following four attributes are exactly the same between two records (MAKT-MAKTX / MAKT-SPRAS / MARA-MATKL / MARM-MEINH)
- DEDUP 3: A duplicate exists if the long texts (such as Purchase Order Texts or Basic Texts stored in STXL/STXB) are exactly the same (or at least 98% similar), then borderline duplicates can be promoted to confirmed duplicates.
- DEDUP 4: Exclude any records that are only in custom or unsupported languages (e.g., Z9) unless explicitly required by the business.
SR03

Deduplication of Services between Material Master - Service (MARA oriented) X Service Master (ASMD oriented)

In order to proceed with this step, apply the selection criteria below:

  • If same service exists in both tables (MARA and ASMD): Keep one representation (normally the Material as Lean Service) and retire ASMD.
    • Check using the fields MAKTX and MEINS
  • If service exists only in MARA: Retain and convert as Lean Service (if material type = in-scope).
  • If service exists only in ASMD: Assess usage — migrate as Lean Service Material or exclude if obsolete.
  • If neither is used in recent years: Exclude.




Target Design

The technical design of the target for this conversion approach.


To be decided what to do with the Z Fields below:

Source SystemSource TableSource FieldLong DescriptionExpectation

PF2

ASMD

ZZMBISMT

This fields regards the Old Service Number

To be decided what to do with the source field



Tables to be migrated as Basic Data:

TableDescription

MARA

General Material Data

Stores material master data that is valid for all organizational levels (client-level data such as base unit of measure, material type, industry sector).

MARM

Units of Measure

Holds all alternative units of measure and conversion factors for each material.

MAKTMaterial Descriptions (multi language)Contains the material short texts (descriptions) in different languages.
MANTText per UoMHolds long texts for materials, used for extended descriptions.


Table / Staging AreaFieldData ElementField DescriptionData TypeLengthDecimalImportance

MARA - General Material Data

S_MARAMATNR
Product NumberText (CHAR)18

Mandatory


MDS: OK

S_MARAMTART
Product TypeText (CHAR)80    
Mandatory
S_MARAATTYP
Product CategoryText (CHAR)80    

S_MARASATNR
Configuration Product for Retail VariantText (CHAR)80    

S_MARAMATKL
Product GroupText (CHAR)80    
MDS: OK
S_MARAMBRSH
Industry SectorText (CHAR)80    

S_MARAMAKTX
DescriptionText (CHAR)40    

Mandatory


MDS: OK

S_MARASPRAS
Language KeyText (CHAR)80    
Mandatory
S_MARAMEINS
Base Unit of Measure (ISO Format)Text (CHAR)80    

Mandatory


MDS: OK

S_MARAAENNR
Change NumberText (CHAR)80    

S_MARAREVLV
Revision LevelText (CHAR)80    

S_MARAEAN11
GTINText (CHAR)18    

S_MARANUMTP
GTIN CategoryText (CHAR)80    

S_MARASPART
DivisionText (CHAR)80    
MDS: OK
S_MARABISMT
Old Product NumberText (CHAR)40    
MDS: OK
S_MARAPRDHA
Product HierarchyText (CHAR)80    
MDS: OK
S_MARABRAND_ID
BrandText (CHAR)80    

S_MARAXCHPF
Batch Management Required Ind.Text (CHAR)1     

S_MARAMLGUT
Has EmptiesText (CHAR)1     

S_MARADATAB
Valid FromDate


S_MARALIQDT
Deletion DateDate


S_MARAKUNNR
CompetitorText (CHAR)80    

S_MARANORMT
Industry Standard DescriptionText (CHAR)18    

S_MARAGROES
Size/DimensionsText (CHAR)32    

S_MARALABOR
Laboratory / Design OfficeText (CHAR)80    

S_MARAINHAL
Net ContentsNumber (NUMC)13    3     
S_MARAINHME
Net Contents Unit (ISO Format)Text (CHAR)80    

S_MARAINHBR
Gross ContensNumber (NUMC)13    3     
S_MARAVPREH
Comparison Price UnitNumber (NUMC)5     

S_MARAEXTWG
External Product GroupText (CHAR)80    
MDS: OK
S_MARAMTPOS_MARA
General Item Category GroupText (CHAR)80    
MDS: OK
S_MARABEGRU
Authorization GroupText (CHAR)4     
MDS: OK
S_MARAMSTAE
Cross-Plant Product StatusText (CHAR)80    

S_MARAMSTDE
Valid-From DateDate


S_MARASERLV
Level of Explicitness for Serial NumberText (CHAR)80    

S_MARAQMPUR
Quality Manag. in Procurement Is ActiveText (CHAR)1     

S_MARAANIMAL_ORIGIN
Animal OriginText (CHAR)1     

S_MARAANP
ANP CodeText (CHAR)80    

S_MARABRGEW
Gross WeightNumber (NUMC)13    3     
S_MARANTGEW
Net WeightNumber (NUMC)13    3     
S_MARAGEWEI
Unit of Weight (ISO Format)Text80    

S_MARALAENG
LengthNumber (NUMC)13    3     
S_MARABREIT
WidthNumber (NUMC)13    3     
S_MARAHOEHE
HeightNumber (NUMC)13    3     
S_MARAMEABM
Unit for Length/Width/Height(ISO Format)Text (CHAR)80    

S_MARAVOLUM
VolumeNumber (NUMC)13    3     
S_MARAVOLEH
Volume UnitText (CHAR)80    

S_MARACAPAUSE
Capacity UsageNumber (NUMC)15    3     
S_MARACHML_CMPLNC_RLVNCE_IND
Compliance RelevantText (CHAR)80    

S_MARAKZKFG
Product Is ConfigurableText (CHAR)1     
MDS: OK
S_MARABSTME
Order Unit of Measure (ISO Format)Text (CHAR)80    

S_MARAEKWSL
Purchasing Value KeyText (CHAR)80    

S_MARAVABME
State of Variable Purchase Order UnitText (CHAR)80    

S_MARABMATN
Internal Product NumberText (CHAR)80    

S_MARAMFRPN
Manufacturer Part NumberText (CHAR)40    

S_MARAMFRNR
Manufacturer NumberText (CHAR)80    

S_MARAMPROF
Manufacturer Part ProfileText (CHAR)80    

S_MARATRAGR
Transportation GroupText (CHAR)80    

S_MARAMSTAV 
Cross-Distribution Chain Product StatusText (CHAR)80    

S_MARAMSTDV
Valid From Date for StatusDate


S_MARAPMATA
Pricing Reference ProductText (CHAR)80    

S_MARASPROF
Pricing Profile for VariantsText (CHAR)80    

S_MARAALLOW_PMAT_IGNO
Variant Price AllowedText (CHAR)1     

S_MARASOM_CYCLE
Billing CycleText (CHAR)80    

S_MARASOM_CYCLE_RULE
Billing Cycle Determination RuleText (CHAR)80    

S_MARASOM_TC_SCHEMA
Assignment SchemaText (CHAR)80    

S_MARABBTYP
Assortment List TypeText (CHAR)80    

S_MARASERVV
Service AgreementText (CHAR)80    

S_MARAMAGRV
Product Group: Packaging MaterialsText (CHAR)80    

S_MARAVHIART
Packaging Product TypeText (CHAR)80    

S_MARAERGEW
Allowed Packaging WeightNumber (NUMC)13    3     
S_MARAERGEI
Unit of Allowed Packaging WeightText (CHAR)80    

S_MARAGEWTO
Excess Weight Tolerance for HUNumber (NUMC)3     1     
S_MARAERVOL
Allowed Packaging VolumeNumber (NUMC)13    3     
S_MARAERVOE
Unit of Allowed Packaging VolumeText (CHAR)80    

S_MARAKZGVH
Packaging Product Is Closed PackagingText (CHAR)1     

S_MARAVOLTO
Excess Volume Tolerance for HUNumber (NUMC)3     1     
S_MARAIPRKZ
Period Indicator for Shelf LifeText (CHAR)80    

S_MARARAUBE
Storage ConditionsText (CHAR)80    

S_MARATEMPB
Temperature Conditions IndicatorText (CHAR)80    

S_MARABEHVO
Container RequirementsText (CHAR)80    

S_MARASTOFF
Hazardous Product NumberText (CHAR)40    

S_MARAETIAR
Label TypeText (CHAR)80    

S_MARAETIFO
Label FormText (CHAR)80    

S_MARAWESCH
Number of Goods Receipt/Issue SlipsNumber (NUMC)13    3     
S_MARAXGCHP
Indicator: Approved Batch Rec. RequiredText (CHAR)1     

S_MARAMHDHB
Total Shelf LifeNumber (NUMC)4     

S_MARAMHDRZ
Minimum Remaining Shelf LifeNumber (NUMC)4     

S_MARASLED_BBD
Indi. for the Shelf Life Expiration DateText (CHAR)80    

S_MARAMHDLP
Storage PercentageNumber (NUMC)3     

S_MARARDMHD
Rounding Rule for Calculation of SLEDText (CHAR)80    

S_MARAHNDLCODE
Handling IndicatorText (CHAR)80    

S_MARAWHMATGR
Warehouse Product GroupText (CHAR)80    

S_MARAWHSTC
Warehouse Storage ConditionText (CHAR)80    

S_MARAHUTYP_DFLT
Standard Handling Unit TypeText (CHAR)80    

S_MARASERIAL
Serial Number ProfileText (CHAR)80    

S_MARAPILFERABLE
PilferableText (CHAR)1     

S_MARAHAZMAT
Relevant for Hazardous SubstancesText (CHAR)1     

S_MARAQQTIME
Quarantine PeriodNumber (NUMC)3     

S_MARAQQTIMEUOM
Time Unit for Quarantine PeriodText (CHAR)80    

S_MARAQGRP
Quality Inspection GroupText (CHAR)80    

S_MARAHUTYP
Handling Unit TypeText (CHAR)80    

S_MARAMAXC
Maximum CapacityNumber (NUMC)15    3     
S_MARAMAXC_TOL
Overcapacity ToleranceNumber (NUMC)3     1     
S_MARATARE_VAR
Variable Tare WeightText (CHAR)1     

S_MARAMAXL
Max. Pack. LengthNumber (NUMC)15    3     
S_MARAMAXDIM_UOM
UoM for Max. Pack. Length (ISO Format)Text (CHAR)80    

S_MARAMAXB
Max. Pack. WidthNumber (NUMC)15    3     
S_MARAMAXH
Max. Pack. HeightNumber (NUMC)15    3     
S_MARARBNRM
Catalog ProfileText (CHAR)80    

S_MARASSTUF
Assortment GradeText (CHAR)80    

S_MARALSTVZ
Listing ProcedureText (CHAR)80    

S_MARALDVZL
Listing Period Start DateDate


S_MARALDBZL
Listing Period End DateDate


S_MARALSTFL
Listing ProcedureText (CHAR)80    

S_MARALDVFL
Listing Period Start DateDate


S_MARALDBFL
Listing Period End DateDate


S_MARAVDVZL
Sales Period Start DateDate


S_MARAVDBZL
Sales Period End DateDate


S_MARAVDVFL
Sales Period Start DateDate


S_MARAVDBFL
Sales Period End DateDate


S_MARAWAUSM
Delivery Unit of Measure (ISO Format)Text (CHAR)80    

S_MARAWVRKM
Sales Unit of Measure (ISO Format)Text (CHAR)80    

S_MARAWMAAB
ABC IndicatorText (CHAR)80    

S_MARAWBKLA
Valuation ClassText (CHAR)80    

S_MARAWHERL
Country/Region of OriginText (CHAR)80    

S_MARAWHERR
Region of OriginText (CHAR)80    

S_MARAWEKGR
Purchasing GroupText (CHAR)80    

S_MARABWSCL
Source of SupplyText (CHAR)80    

S_MARATAKLV
Tax ClassificationText (CHAR)80    

S_MARAWLADG
Loading GroupText (CHAR)80    

S_MARAWBWSP
Valuation MarginNumber (NUMC)6     2     
S_MARAPSTATQ
Indicator: QualityText (CHAR)1     

S_MARAPSTATV
Indicator: SalesText (CHAR)1     

S_MARAPSTATL
Indicator: StorageText (CHAR)1     

S_MARAPSTATE
Indicator: PurchasingText (CHAR)1     









MAKT - Material Descriptions
S_MAKTMATNR
Product NumberText (CHAR)18
Mandatory
S_MAKTSPRAS
Language KeyText (CHAR)2    
Mandatory
S_MAKTMAKTX
Product DescriptionText (CHAR)40    
Mandatory








MARM - Units of Measure for Material
S_MARMPRODUCT
Product NumberText (CHAR)80    
Mandatory
S_MARMMEINH
Alternative Unit of Measure (ISO Format)Text (CHAR)80    
Mandatory
S_MARMUMREN
Denominator for Conversion to Base UnitNumber (NUMC)5     
Mandatory
S_MARMUMREZ
Numerator for Conversion to Base UnitNumber (NUMC)5     
Mandatory
S_MARMEAN11
GTINText (CHAR)18    

S_MARMNUMTP
GTIN CategoryText (CHAR)80    

S_MARMLAENG
LengthNumber (NUMC)13    3     
S_MARMBREIT
WidthNumber (NUMC)13    3     
S_MARMHOEHE
HeightNumber (NUMC)13    3     
S_MARMMEABM
Unit for Length/Width/Height(ISO Format)Text (CHAR)80    

S_MARMBRGEW
Gross WeightNumber (NUMC)13    3     
S_MARMGEWEI
Unit of Weight (ISO Format)Text (CHAR)80    

S_MARMVOLUM
VolumeNumber (NUMC)13    3     
S_MARMVOLEH
Volume Unit (ISO Format)Text (CHAR)80    

S_MARMCAPAUSE
Capacity UsageNumber (NUMC)15    3     








CLASS - Class Header Data (KLAH)
S_CLASSPRODUCT
Product NumberText (CHAR)18
Mandatory
S_CLASSCLASS
ClassText (CHAR)80    
Mandatory
S_CLASSCLASSTYPE
Class TypeText (CHAR)80    
Mandatory








S_CHARACT - Characteristic (CABN)
S_CHARACTPRODUCT
Product NumberText (CHAR)80    
Mandatory
S_CHARACTCLASS
ClassText (CHAR)80    
Mandatory
S_CHARACTCLASSTYPE
Class TypeText (CHAR)80    
Mandatory
S_CHARACTATNAM
Characteristic NameText (CHAR)80    
Mandatory
S_CHARACTPOSNR
ItemText (CHAR)3     

S_CHARACTVALUE_CHAR
Character ValueText (CHAR)70    

S_CHARACTVALUE_NUMC
Numeric ValueNumber (NUMC)16    16    
S_CHARACTVALUE_DATE
DateDate


S_CHARACTVALUE_TIME
TimeTime


S_CHARACTVALUE_CURR
Currency ValueNumber (NUMC)23    2     








S_MLAN - Tax Classification for Material
S_MLANPRODUCT
Product NumberText (CHAR)80    
Mandatory
S_MLANALAND
Country/RegionText (CHAR)80    
Mandatory
S_MLANTATYP1
Tax Category 1Text (CHAR)80    
Mandatory
S_MLANTAXM1
Tax Classification 1Text (CHAR)80    
Mandatory
S_MLANTATYP2
Tax Category 2Text (CHAR)80    

S_MLANTAXM2
Tax Classification 2Text (CHAR)80    

S_MLANTATYP3
Tax Category 3Text (CHAR)80    

S_MLANTAXM3
Tax Classification 3Text (CHAR)80    

S_MLANTATYP4
Tax Category 4Text (CHAR)80    

S_MLANTAXM4
Tax Classification 4Text (CHAR)80    

S_MLANTATYP5
Tax Category 5Text (CHAR)80    

S_MLANTAXM5
Tax Classification 5Text (CHAR)80    

S_MLANTATYP6
Tax Category 6Text (CHAR)80    

S_MLANTAXM6
Tax Classification 6Text (CHAR)80    

S_MLANTATYP7
Tax Category 7Text (CHAR)80    

S_MLANTAXM7
Tax Classification 7Text (CHAR)80    

S_MLANTATYP8
Tax Category 8Text (CHAR)80    

S_MLANTAXM8
Tax Classification 8Text (CHAR)80    

S_MLANTATYP9
Tax Category 9Text (CHAR)80    

S_MLANTAXM9
Tax Classification 9Text (CHAR)80    









STXH - SAPscript Text Header

TDOBJECT
Text Object (e.g., MATERIAL, VENDOR, etc.)CHAR10

STXHTDNAME
Text Name (object key, e.g., material number, PO number)CHAR70

STXHTDID
Text ID (text type, e.g., F01 = Header Text, L01 = Item Text)CHAR4

STXHTDSPRAS
Language KeyLANG1

STXHTDTITLE
Title of the text (optional short description)CHAR60

STXHTDFUSER
Last Changed by (user)CHAR12

STXHTDFDATE
Date of Last ChangeDATS8

STXHTDFTIME
Time of Last ChangeTIMS6

STXHTDVERSION
Version Number of TextNUMC4

STXHTDLOCK
Lock IndicatorCHAR1

STXHTDTRANSTAT
Translation StatusCHAR1

STXHTDOSPRAS
Original LanguageLANG1









STXL - SAPscript Text File (Cluster)

STXLRELID
Cluster Area (ID of cluster; for texts usually "TX")Text (CHAR)2

STXLTDOBJECT
Text Object (e.g., MATERIAL, VENDOR, etc.)Text (CHAR)10

STXLTDNAME
Text Name (object key, e.g., material number, purchase order)Text (CHAR)70

STXLTDID
Text ID (text type, e.g., F01 = header text, L01 = item text)Text (CHAR)4

STXLTDSPRAS
Language KeyLanguage (LANG)1

STXLSRTF2
Sort number (used to split large texts across several cluster entries)Numeric (NUMC)3

STXLCLUSTR
Length field for cluster (internal, technical)Integer (INT2)5

STXLCLUSTD
Length field for cluster (internal, technical)Integer (INT2)5

STXLVARTEXT
Compressed text data (the actual long text, stored in cluster format)(RAW)255




Data Cleansing

All data cleansing should take place in the data source system as defined in this document, unless system limitations prevent it.


If data cleansing is managed outside of the source system (e.g. Syniti Migrate, 3rd Party Vendor, DCT), the necessary documentation must be produced and appended to this deliverable for sign-off.


IDCriticalityError Message/Report DescriptionRuleOutputSource System
001HighRemove Duplicated Entries - ServicesRemove duplicates based on Service Description + UoM + Service Group (?)
PF2 / WP2

002

High

Remove Duplicated Entries - Materials 

Check for materials with same Long/Short Description

Check Old Material Number field

Check Materials with same Manufacturer Part Number

Check Source List/PIR for identical set ups

Check BOMs for identical components


Where duplicates found, check if either has no activity


PF2 / WP2
003MediumValidation of Service Group, UoM, and active status in target configValidate existence of Service Group, UoM, and active status in target config
PF2 / WP2

004

High

English description missing or EN description not English language

All materials require English description by default, so need to be provided if missing. Current EN descriptions not in English language need to be translated.


The field details for description are the following:

Field Name / Data Element / Domain: MAKTX



PF2 / WP2

005

High

Description format

Material descriptions must adhere to S4 standardization so no special characters, and must not exceed character limit


PF2 / WP2

006

High

UoM alignment

All material UoMs to adhere to S4 standardization. Confirmation regarding EA/PC format.


PF2 / WP2



Conversion Process

The high-level process is represented by the diagram below:

image-2025-6-20_9-51-38.png 


Data Privacy and Sensitivity
N/A


Data Merging / Data Consolidation

The data merging is restricted to the Materia Types Z720 / ZB20 / ZDIE being Deduplicated/Merged into ZSER in combination with the Service Master.




Extraction

Extract data from a source into . There are 2 possibilities:

  1. The data exists. connects to the source and loads the data into . There are 3 methods:
    1. Perform full data extraction from relevant tables in the source system(s).
    2. Perform extraction through the application layer.
    3. Only if ; cannot connect to the source, data is loaded to the repository from the provided source system extract/report.
  2. The data does not exist (or cannot be converted from its current state). The data is manually collected by the business directly in . This is to be conducted using DCT (Data Collection Template) in

The agreed Relevancy criteria is applied to the extracted records to identify the records that are applicable for the Target loads

Extraction Run Sheet

Req #Requirement DescriptionTeam Responsible

All material status not defined as "EXCLUDED" should be included in scope, otherwise must be included in scope (independently of the status)
001Do not extract records where ASMD-LVORM = X (record deleted)Syniti Team
002Do not extract records where ASMD-MATKL (Material Group) is set as out of scopeSyniti Team
003Do not extract records where ASMD-MLANG (Main Language)  is set as out of scopeSyniti Team
004Do not extract records where ASMD-BKLAS (Valuation Class)  is set as out of scopeSyniti Team
005

Service Group (ASMD-ASBGR) must exist in customizing table T023

Syniti Team
006

All Services and Materials (defined as services) that have been created on the last 36 months are relevant to be migrated

Syniti Team
007

All Services and Materials (defined as services) that have a Purchase Order created in the last 6 months or has a goods receipt on the last 6 months, must be included

Syniti Team
008

All Services and Materials that are marked for Deletion should be excluded

Syniti Team
009

All material status not defined as EXCLUDED should be included in scope, otherwise must be included in scope (independently of the status)

Syniti Team


Selection Screen

Selection Ref ScreenParameter NameSelection TypeRequirementValue to be entered/set





















Data Collection Template (DCT)

Target Ready Data Collection Template will be created for data with exception of some fields which require transformation as mentioned in the transformation rule.

DCT Rules

Field NameField DescriptionRule












Extraction Dependencies

Item #Step DescriptionTeam Responsible













Transformation

The Target fields are mapped to the applicable Legacy field that will be its source, this is a 3-way activity involving the Business, Functional team and Data team. This identifies the transformation activity required to allow to make the data Target ready:

  1. Perform value mapping and data transformation rules.
    1. Legacy values are mapped to the to-be values (this could include a default value)
    2. Values are transformed according to the rules defined in
  2. Prepare target-ready data in the structure and format that is required for loading via prescribed Load Tool. This step also produces the load data ready for business to perform Pre-load Data Validation



Transformation Run Sheet

Item #Step DescriptionTeam Responsible

1

Obtain DCT Sign-off from Business

SyWay S2P Data Team

3

Review and Validate Error and Preload Reports

SyWay S2P Data Team

4

Generate Load Files

SyWay S2P Data Team


Transformation Rules

Rule #Source systemSource TableSource FieldSource DescriptionTarget SystemTarget TableTarget FieldTarget DescriptionTransformation Logic
001PF2 - MATERIALMARAMATNRProduct NumberS4/HANAS_MARAMATNRProduct NumberGenerate a new material code and keep the mapping of Old Material and New Material in a dedicated table
002PF2 - MATERIALMARAATTYPProduct CategoryS4/HANAS_MARAATTYPProduct CategoryApply Data Conversion from OLD to NEW value. The 1:1 relation is expected.
003PF2 - MATERIALMARASATNRConfiguration Product for Retail VariantS4/HANAS_MARASATNRConfiguration Product for Retail VariantApply Data Conversion from OLD to NEW value. The 1:1 relation is expected.
004PF2 - MATERIALMARAMATKLProduct GroupS4/HANAS_MARAMATKLProduct GroupApply Data Conversion from OLD to NEW value. The 1:1 relation is expected.
005PF2 - MATERIALMARAMBRSHIndustry SectorS4/HANAS_MARAMBRSHIndustry SectorApply Data Conversion from OLD to NEW value. The 1:1 relation is expected.
006PF2 - MATERIALMARASPRASLanguage KeyS4/HANAS_MARASPRASLanguage KeyApply Data Conversion from OLD to NEW value. The 1:1 relation is expected.
007PF2 - MATERIALMARAMEINSBase Unit of Measure (ISO Format)S4/HANAS_MARAMEINSBase Unit of Measure (ISO Format)Apply Data Conversion from OLD to NEW value. The 1:1 relation is expected.
008PF2 - MATERIALMARANUMTPGTIN CategoryS4/HANAS_MARANUMTPGTIN CategoryApply Data Conversion from OLD to NEW value. The 1:1 relation is expected.
009PF2 - MATERIALMARASPARTDivisionS4/HANAS_MARASPARTDivisionApply Data Conversion from OLD to NEW value. The 1:1 relation is expected.

 


Transformation Mapping

Mapping Table NameMapping Table Description

Material Number

Mapping of legacy Material Number to target system value

Material Type

Mapping of legacy Material Types to target system value

Material Group

Mapping of legacy Material Groups to target system value

Product HierarchyMapping of legacy Product Hierarchies to target system value
Language KeyMapping of legacy Language Key to target system value
Unit of MeasureMapping of legacy Unit of Measure to target system value



Transformation - Special Requirements

Custom Fields - to be identified the usage of those and whether they will be moved into S4/Hana

Tables: MARA / MAKT


Custom Unit of Measures: to be identified the usage of those and whether they will be moved into S4/Hana


Data Mapping: Account Group

Account Group
Source SystemOLD: Legacy Account GroupNEW: S4/Hana Account Group
PF2DIENZSER
PF2Z710 ZSER
PF2Z720 ZSER
PF2Z732 ZSER
PF2ZB10 ZSER
PF2ZB20 ZSER
PF2ZESE ZSER
PF2ZFS1 ZSER
PF2ZPSE ZSER
PF2ZU10 ZSER
PF2ZU20 ZSER



WP2DIENZSER
WP2ZDIEZSER

* some materials were originally created under type ZNLA (e.g., electricity). However, these must be converted to type ZSER. An exception list table should be created to capture all relevant materials, ensuring they are flagged as in-scope for migration.


Transformation Dependencies

List the steps that need to occur before transformation can commence
Item #Step DescriptionTeam Responsible

1

Ensure DCT tables completeness

SyWay S2P Data Team

2

Value Mappings are according to the latest design - <List of Value Mappings>

SyWay S2P Data Team

3Mapping Tables must be properly updatedSyensqo Data Team


Pre-Load Validation

Project Team

Completeness

TaskAction

Verify Record Count

SyWay S2P Data Team to verify that the total number of relevant records from the  DCT is equal to the total number of records in the Preload and Load Sheets.

Mandatory FieldsCheck mandatory fields for completeness
Field FormatValidate field formats (text length, data types)
Service Group and UOMConfirm Service Group and UoM exist in target system
Duplicated RecordsCheck for duplicates before load
Description MultilanguageIdentify whether some examples are being properly loaded. Take few examples to be checked according to the data volume purchased.

Accuracy

TaskAction
DescriptionCheck whether the description matches the with the same value from Legacy System
Legacy CodeCheck whether the Legacy code is maintained as expected. The rule is valid for all legacy systems.
UOM MaintainedCheck whether the Unit of Measure was respected

Business

Completeness

TaskAction





Accuracy

TaskAction





Load

The load process includes:

  1. Execute the automated data load into target system using load tool or product the load file if the load must be done manually
  2. Once the data is loaded to the target system, it will be extracted and prepared for Post Load Data Validation


Load Run Sheet

Item #Step DescriptionTeam Responsible
001The data is save into the staging areas of Migration CockpitSyniti Team
002Data Load is executed by Migration Cockpit respecting the proper sequenceSyensqo Team


Load Phase and Dependencies

N/A

Configuration

List the Configurations required before loading can commence

Item #Configuration Item
001Company Codes (T001-BUKRS)
002Plants (T024-WERKS)
003Material Group (T023-MATKL)
004

EAN Category (MARA-NUMTP)

005

Unit of Measures (T006-MSEHI)

Volume Unit

Weight Unit

006Division (MARA-SPART)
007Lab / Office (MARA-LABOR)
008Authorization Group (MARA-BEGRU)
009Product Allocation (MARA-KOSCH)
010Product Hierarchy (MARA-PRDHA)
012Material Status (MARA-MSTAE)
013General Item Category Group (MTPOS_MARA)
014Dangerous Goods Indicator Profile (MARA-PROFL)
015Dangerous Goods Packaging Status (MARA-DG_PACK_STATUS)
016Packaging Code (MARA-PACKCODE)
017ANP Code - Brazil (MARA-ANP)
018Material Type (MARA-MTART)

Conversion Objects

Object #Preceding Object Conversion Approach






Error Handling

Error TypeError DescriptionAction Taken










Post-Load Validation

Project Team

Completeness

TaskAction
Check record count against DCT and load file.

Verify random samples in S/4 using transaction AC03.

Ensure data appears in standard search helps (e.g., ML81N).

Log any mismatches or errors for remediation.

Accuracy

TaskAction







Business

Completeness

TaskAction





Accuracy

TaskAction






Syniti Reports

#TopicJira TicketCreation DateResolution Date
001




003




004




005




006




007




Open Questions

#TopicJira TicketCreation DateResolution Date
001Multiple Objects being consolidated



003




004




005




006




007





Key Assumptions

  • Master Data Standard is up to date as on the date of documenting this conversion approach and data load.
  • is in scope based on data design and any exception requested by business.


See also

Change log

Version Published Changed By Comment
CURRENT (v. 237) Nov 20, 2025 09:12 BUOSI-ext, Angelo
v. 368 Nov 18, 2025 15:25 BUOSI-ext, Angelo
v. 367 Nov 13, 2025 08:54 BUOSI-ext, Angelo
v. 366 Oct 30, 2025 09:18 BUOSI-ext, Angelo
v. 365 Oct 21, 2025 10:43 BUOSI-ext, Angelo
v. 364 Oct 21, 2025 10:43 BUOSI-ext, Angelo
v. 363 Oct 20, 2025 10:43 BUOSI-ext, Angelo
v. 362 Oct 20, 2025 10:42 BUOSI-ext, Angelo
v. 361 Oct 17, 2025 13:53 BUOSI-ext, Angelo
v. 360 Oct 17, 2025 13:36 BUOSI-ext, Angelo

Go to Page History

Workflow history

Title Last Updated By Updated Status  
There are no pages at the moment.

  • No labels