/ACCGO/T_HLREVNT

HLR Event Processing -- Event table | #transactional | Component: SAP Agricultural Contract Management
Column Name Description
MANDT Client
HLR_EVENT_ID FK HLR Event ID
HLR_EVENT_ITEM Item number of the SD document
VERSION Version
Column Name Description
Column Name Description
📏 Unit of Measure for Commodity (CMM_VLOGP_KONVD.COMMODITY_UOM):
QUAN_BASE Commodity Quantity
NET_QUAN_BASE Commodity Quantity
QUAN_COMM Commodity Quantity
NET_QUAN_COMM Commodity Quantity
📏 Unit of Measure for Commodity (CMM_VLOGP_KONVD.COMMODITY_MASS_UOM):
QUAN_MASS Open Commodity Quantity In MASS
NET_QUAN_MASS Commodity Quantity
📏 Unit of Measure for Commodity (CMM_VLOGP_KONVD.COMMODITY_VOLUME_UOM):
QUAN_VOLUME Open Commodity Quantity In Volume
NET_QUAN_VOL Commodity Quantity
Column Name Description
Column Name Description
HLR_EVENT_TYPE HLR Event Type Show values
RECIEPT_FWD General Flag Show values
CANCELLED_FWD General Flag Show values
Column Name Description Domain name
TICKET_ITEM OIL-TSW: Ticket item number OIJ_EL_TKT_POSNR
ENTITY_KEY Key of an Business Entity requiring an End-of-day snapshot
STORAGE_LOCATION Storage location LGORT
MATERIAL_DOCUMENT_NO Number of Material Document BELNR
MATERIAL_DOCUMENT_ITEM Item in Material Document MBLPO
MATERIAL_DOC_YEAR Material Document Year GJAHR
UIS_ID Load Data Capture Object ID /ACCGO/D_UIS_ID
HLR_EVENT HLR Event Type /ACCGO/D_HLR_EVENT_TYPE
VALID_FROM UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
VALID_TO UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
Master Data Relations Join Conditions
Material Number
  • Material Number
  • Client
  • /ACCGO/T_HLREVNT.MATERIAL == MARA.MATNR
  • /ACCGO/T_HLREVNT.MANDT == MARA.MANDT
Plant
  • /ACCGO/T_HLREVNT.MANDT == T001W.MANDT
  • /ACCGO/T_HLREVNT.PLANT == T001W.WERKS
TSW Location
  • /ACCGO/T_HLREVNT.MANDT == OIJLOC.MANDT
  • /ACCGO/T_HLREVNT.TSW_LOC == OIJLOC.LOCID