/ACCGO/T_HLR_DET

HLR Detail Data for storage location | #transactional | Component: SAP Agricultural Contract Management
Column Name Description
MANDT Client
HLR_EVENT_ID FK HLR Event ID
STORAGE_LOCATION FK Storage location
LOCATION Source or Destination Show values
MATNR FK Material Number
Column Name Description
Column Name Description
📏 Purchase Order Unit of Measure (EKPO.MEINS):
QUANTITY Quantity
LOSS_QUAN Quantity
SHRINK_QUAN Quantity
📏 Base Unit of Measure (CMM_VLOGP_KONVD.LAGME):
PHY_GROSS_QTY Commodity Quantity
PHY_NET_QTY Commodity Quantity
UNREALIZED_QTY Commodity Quantity
REALIZED_QTY Commodity Quantity
Column Name Description
Column Name Description
LOCATION Source or Destination Show values
BY_PROD_MATNR General Flag Show values
Column Name Description Domain name
QREP_GUID Application GUID SYSUUID_X16
QREP_VERSION Version /ACCGO/D_QREP_ID
LOSS_PERCENTAGE Loss Percentage /ACCGO/D_LOSS_PERCENTAGE
Master Data Relations Join Conditions
Material Number
  • Material Number
  • Client
  • /ACCGO/T_HLR_DET.MATNR == MARA.MATNR
  • /ACCGO/T_HLR_DET.MANDT == MARA.MANDT
Storage location
  • Storage location
  • Client
  • Plant
  • /ACCGO/T_HLR_DET.STORAGE_LOCATION == T001L.LGORT
  • /ACCGO/T_HLR_DET.MANDT == T001L.MANDT
  • /ACCGO/T_HLR_DET.WERKS == T001L.WERKS
TSW Location
  • /ACCGO/T_HLR_DET.MANDT == OIJLOC.MANDT
  • /ACCGO/T_HLR_DET.TSW_LOC == OIJLOC.LOCID
Plant
  • /ACCGO/T_HLR_DET.MANDT == T001W.MANDT
  • /ACCGO/T_HLR_DET.WERKS == T001W.WERKS