P_AdvncdPlngPrdscm_Matkey

Advanced Planning Product key | view: PAPPRDMAT | Extraction: Not supported | Component: Detailed Scheduling
Tables used: INOBMARAMARMINOBKLAHKSSKMARC/SAPAPO/TCLSYS
Column Name Description
Column Name Description
Column Name Description
📏 Weight Unit (GEWEI):
BRGEW Gross weight
NTGEW Net weight
📏 Volume unit (VOLEH):
VOLUM Volume
📏 UoM of Abs. Height Threshold (Stacking on Non-Flat Surface) (HEIGHT_NONFLAT_UOM):
HEIGHT_NONFLAT Absolute Height Threshold for Stacking on Non-Flat Surface
Column Name Description
PHIN_FROM null
PHIN_TO null
PHOUT_FROM null
PHOUT_TO null
Column Name Description
PRODUCT_TYPE Product Type Show values
LVORM Flag Material for Deletion at Client Level Show values
FLAGPACK Packing Data for a Product Show values
ATTYP Trading Goods Category Show values
CWREL EWM CW: Material Is a Catch Weight Material Show values
TY2TQ EWM-CW: Category of Unit of Measure Show values
IPRKZ Period Indicator for Shelf Life Expiration Date Show values
SLDRND Rounding Rule for Calculation of Shelf Life Expiration Date Show values
BOD_DEPLVL Carry Out Push Deployment from Supplier Show values
EXCL_EXPEDITE Exclude from Express Shipment Show values
PROD_PAOOPT Product can be used for Procure-to-Order Show values
RESTRICT_INVBAL Inventory Balancing Not Allowed Show values
DRP_GL_STOCK Global Stock on Entry Location DRP Show values
BATCH_REQ Batch Management Requirement Indicator Show values
KITCOMP Product for Kit-to-Order Show values
KZKFG Configurable Material Show values
TEMPRPBLOCK Temporary Replenishment Blocking Show values
PROD_SHAPE Product Shape Show values
Column Name Description Domain name
MATID Internal Number (UID) for Product /SAPAPO/MATID
MATNR Material Number MATNR
FLAGCLASS null
DISST Low-Level Code DISST
SHELF_LIFE_FLAG null
SHELF_LIFE_DUR Shelf Life TSTRDURAG
MATURITY_DUR Maturation Time TSTRDURAG
SHLF_LFE_REQ_MIN Required Minimum Shelf Life TSTRDURAG
SHLF_LFE_REQ_MAX Required Maximum Shelf Life TSTRDURAG
MHDLP Storage percentage DEC3
SLED_BBD null
ATT01 Free Attribute 1 CHAR40
ATT02 Free Attribute 2 CHAR30
ATT03 Free Attribute 3 CHAR20
ATT04 Free Attribute CHAR10
ATT05 Free Attribute CHAR10
STFAC Stacking Factor NUMC2
TS_SDP_USE null
GTIN_IND null
DISPLAY null
PRDSET_IND null
DATA_CHECK_BY Name of Person Who Checked the Product XUBNAME
DATA_CHECK_AT Date on Which the Product Was Checked /SCMB/TZNTSTMPS
KOSCH_GRP Prod. Allocations: Sequence of Product Allocation Procedures /SAPAPO/KOSCH_GRP
VMIKOSCH Allocations: Product Allocation Procedure /SAPAPO/KOSCH
VMIKOSCH_GRP Prod. Allocations: Sequence of Product Allocation Procedures /SAPAPO/KOSCH_GRP
RMATP Ref. Prod. GUID for Products That Can Be Packed The Same Way /SAPAPO/MATID
RMATID_PB Reference Product ID for Package Building /SAPAPO/MATID
CUOBJ Internal object number CUOBJ
SATID Internal Number (UID) for Configurable Product /SAPAPO/MATID
MATVERS_HEAD Header Product for Version /SAPAPO/MATID
MATVERS_TYPE null
MATVERS_CHNR Change Number /SAPAPO/AENNR
TEMPRPFROM Start Date/Time for Temporary Replenishment Blocking TZNTSTMPS
TEMPRPTO End Date/Time for Temporary Replenishment Blocking TZNTSTMPS
dummy_prd_incl_eew_ps Dummy Field PRD_INCL_EEW
LIKEID Profile ID for Like Dependency in Material Forecast SYSUUID_22
PHIN_TSID null
PHOUT_TSID null
LIFE_CYCLE_LOCID null
CREATEUSER Name of Person Responsible for Creating the Object USNAM
CHANGEUSER Name of Person Who Changed Object USNAM
MO_PROFILE_ID Product Orientation Profile /SCMB/DO_PB_PROFILE_ID
OVERHANG_TRESH Overhang Threshold [%] DEC03_2
BRIDGE_TRESH Bridge Threshold [%] DEC03_2
BRIDGE_MAX_SLOPE Maximum Slope for Bridges [°] DEC03_2
CREATEUTC Date and Time at Which Object Was Created /SAPAPO/U_TZNTSTMPS
CHANGEUTC null
Master Data Relations Join Conditions
Material completion level
  • Material completion level
  • Client
Unit of Weight
  • Weight Unit
  • Client
  • P_ADVNCDPLNGPRDSCM_MATKEY.GEWEI == T006.MSEHI
  • P_ADVNCDPLNGPRDSCM_MATKEY.MANDT == T006.MANDT
Country/Region of Origin of Material (Non-Preferential Ori.)
  • Client
  • Country/Region of Origin of Material (Non-Preferential Ori.)
  • P_ADVNCDPLNGPRDSCM_MATKEY.MANDT == T005.MANDT
  • P_ADVNCDPLNGPRDSCM_MATKEY.HERKL == T005.LAND1
Standard HU Type
  • Client
  • Standard HU Type
  • P_ADVNCDPLNGPRDSCM_MATKEY.MANDT == THUTYP.MANDT
  • P_ADVNCDPLNGPRDSCM_MATKEY.HUTYP_DFLT == THUTYP.HUTYP
Product Allocation Determination Procedure
  • Client
  • Product allocation determination procedure
  • P_ADVNCDPLNGPRDSCM_MATKEY.MANDT == T190S.MANDT
  • P_ADVNCDPLNGPRDSCM_MATKEY.KOSCH == T190S.KOSCH
EWM CW: Logistics Unit of Measure
  • EWM CW: Logistics Unit of Measure
  • Client
  • Material Number
  • P_ADVNCDPLNGPRDSCM_MATKEY.LOGUNIT == MARM.MEINH
  • P_ADVNCDPLNGPRDSCM_MATKEY.MANDT == MARM.MANDT
  • P_ADVNCDPLNGPRDSCM_MATKEY.MATNR == MARM.MATNR
Material Group
  • Material Group
  • Client
  • P_ADVNCDPLNGPRDSCM_MATKEY.MATKL == T023.MATKL
  • P_ADVNCDPLNGPRDSCM_MATKEY.MANDT == T023.MANDT
Unit of Measure
  • Client
  • Base Unit of Measure
  • P_ADVNCDPLNGPRDSCM_MATKEY.MANDT == T006.MANDT
  • P_ADVNCDPLNGPRDSCM_MATKEY.MEINS == T006.MSEHI
Material Group: Packaging Materials
  • Material Group: Packaging Materials
  • Client
  • P_ADVNCDPLNGPRDSCM_MATKEY.PACKGR == TVEGR.MAGRV
  • P_ADVNCDPLNGPRDSCM_MATKEY.MANDT == TVEGR.MANDT
Product Hierarchy
  • Client
  • Product hierarchy
  • P_ADVNCDPLNGPRDSCM_MATKEY.MANDT == T179.MANDT
  • P_ADVNCDPLNGPRDSCM_MATKEY.PRDHA == T179.PRODH
Serial Number Profile
  • Client
  • Serial Number Profile
  • P_ADVNCDPLNGPRDSCM_MATKEY.MANDT == TSERIAL.MANDT
  • P_ADVNCDPLNGPRDSCM_MATKEY.SERIAL == TSERIAL.SERIAL
Carr. Group
  • Client
  • Transportation Group
  • P_ADVNCDPLNGPRDSCM_MATKEY.MANDT == TTGR.MANDT
  • P_ADVNCDPLNGPRDSCM_MATKEY.TRAGR == TTGR.TRAGR
Volume Unit
  • Client
  • Volume unit
  • P_ADVNCDPLNGPRDSCM_MATKEY.MANDT == T006.MANDT
  • P_ADVNCDPLNGPRDSCM_MATKEY.VOLEH == T006.MSEHI