WRF_MATGRP_MD7 SAP table for – Hierarchy Level 7 – Time-Dependent

Here we would like to draw your attention to WRF_MATGRP_MD7 table in SAP. As we know it is being mainly used with the SAP LO-MD (Logistics Basic Data in LO) component which is coming under LO module (Logistics). WRF_MATGRP_MD7 is a SAP standard transparent table used for storing Hierarchy Level 7 – Time-Dependent related data in SAP. It comes under the package WRF_CM_MD.

SAP WRF_MATGRP_MD7 table

Table WRF_MATGRP_MD7 technical data

TableWRF_MATGRP_MD7
Data storingHierarchy Level 7 – Time-Dependent
ModuleLO
ComponentLO-MD
SAP PackageWRF_CM_MD
Delivery ClassA – Application table (master and transaction data)
Table CategoryTRANSPARENT

SAP WRF_MATGRP_MD7 Table Fields

Here is the details of each fields in this table.You can find the discription, data type and assigned lenth of each of the fields in WRF_MATGRP_MD7 table.

  • MANDT : Client
    Its a key field. Its data type is C (Character String) with field length 3
  • HIERNODE2
    Its data type is C (Character String) with field length 18
  • HIERNODE3
    Its data type is C (Character String) with field length 18
  • HIERNODE4
    Its data type is C (Character String) with field length 18
  • HIERNODE5
    Its data type is C (Character String) with field length 18
  • HIERNODE6
    Its data type is C (Character String) with field length 18
  • VKORG : Sales Organization
    Its data type is C (Character String) with field length 4
  • VTWEG : Distribution Channel
    Its data type is C (Character String) with field length 2
  • TREE_LEVEL : Natural number
    Its data type is N (Character String with Digits Only) with field length 2
  • SHLFSPC
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 5
  • LINSPC
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 5
  • NODE : Node in Hierarcy Tree
    Its a key field. Its data type is C (Character String) with field length 18
  • SPACEUNIT
    Its data type is C (Character String) with field length 3
  • LINUNIT
    Its data type is C (Character String) with field length 3
  • STORES
    Its data type is N (Character String with Digits Only) with field length 9
  • CHKDATE
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • TIMESTAMP : UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • DELETEFLAG
    Its data type is C (Character String) with field length 1
  • EPRGR
    Its data type is C (Character String) with field length 6
  • PRODUCTCLF
    Its data type is C (Character String) with field length 2
  • PRICE_GROUP
    Its data type is C (Character String) with field length 6
  • REFERENCE : Flag (character 1)
    Its data type is C (Character String) with field length 18
  • HIER_ID
    Its a key field. Its data type is C (Character String) with field length 2
  • RESPONSIBILITY
    Its data type is C (Character String) with field length 20
  • DATE_FROM : From Date of an Entry
    Its a key field. Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • DATE_TO : To Date of Accrual Item
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • ROLE : AOC role
    Its data type is C (Character String) with field length 20
  • STRATEGY
    Its data type is C (Character String) with field length 20
  • PARENT : Internal: Node ID
    Its data type is C (Character String) with field length 18
  • HIERNODE1
    Its data type is C (Character String) with field length 18