I_EWM_HANDLINGUNITHEADERLOG
EWM Handling Unit Header Log
I_EWM_HANDLINGUNITHEADERLOG is a CDS View in S/4HANA. EWM Handling Unit Header Log. It contains 38 fields. 3 CDS views read from this table.
CDS Views using this table (3)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_EWM_HandlingUnitHdrCombined | view | union_all | COMPOSITE | EWM HU Header Combined |
| P_EWM_HandlingUnitHeaderLog01 | view | from | COMPOSITE | |
| P_EWM_HandlingUnitHeaderLog02 | view | inner | COMPOSITE |
Fields (38)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | HandlingUnitExternalID | HandlingUnitExternalID | 1 |
| KEY | Warehouse | Warehouse | 1 |
| CreatedByUser | CreatedByUser | 1 | |
| CreationUTCDateTime | CreationUTCDateTime | 1 | |
| GrossVolume | GrossVolume | 1 | |
| GrossWeight | GrossWeight | 1 | |
| HandlingUnitHeight | HandlingUnitHeight | 1 | |
| HandlingUnitLength | HandlingUnitLength | 1 | |
| HandlingUnitLogUUID | HandlingUnitLogUUID | 1 | |
| HandlingUnitMaxDimensionUnit | HandlingUnitMaxDimensionUnit | 1 | |
| HandlingUnitMaxHeight | HandlingUnitMaxHeight | 1 | |
| HandlingUnitMaxLength | HandlingUnitMaxLength | 1 | |
| HandlingUnitMaxVolume | HandlingUnitMaxVolume | 1 | |
| HandlingUnitMaxWeight | HandlingUnitMaxWeight | 1 | |
| HandlingUnitMaxWidth | HandlingUnitMaxWidth | 1 | |
| HandlingUnitNetVolume | HandlingUnitNetVolume | 1 | |
| HandlingUnitStatus | HandlingUnitStatus | 1 | |
| HandlingUnitTareVolume | HandlingUnitTareVolume | 1 | |
| HandlingUnitTareVolumeUnit | HandlingUnitTareVolumeUnit | 1 | |
| HandlingUnitTareWeight | HandlingUnitTareWeight | 1 | |
| HandlingUnitTareWeightUnit | HandlingUnitTareWeightUnit | 1 | |
| HandlingUnitTopLevelInd | HandlingUnitTopLevelInd | 1 | |
| HandlingUnitType | HandlingUnitType | 1 | |
| HandlingUnitUUID | HandlingUnitUUID | 1 | |
| HandlingUnitVolumeTolerance | HandlingUnitVolumeTolerance | 1 | |
| HandlingUnitWidth | HandlingUnitWidth | 1 | |
| LastChangedByUser | LastChangedByUser | 1 | |
| LastChangeUTCDateTime | LastChangeUTCDateTime | 1 | |
| NetWeight | NetWeight | 1 | |
| PackagingMaterialType | PackagingMaterialType | 1 | |
| PackagingMaterialUUID | PackagingMaterialUUID | 1 | |
| ParentHandlingUnitUUID | ParentHandlingUnitUUID | 1 | |
| StorageBin | StorageBin | 1 | |
| StorageSection | StorageSection | 1 | |
| StorageType | StorageType | 1 | |
| UnitOfMeasureDimension | UnitOfMeasureDimension | 1 | |
| VolumeUnit | VolumeUnit | 1 | |
| WeightUnit | WeightUnit | 1 |
@AbapCatalog.sqlViewName: 'IEWMHUHDRLOG'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #NOT_REQUIRED
@EndUserText.label: 'EWM Handling Unit Header Log'
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType:#BASIC
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.sizeCategory: #L
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: 'I_EWM_HandlingUnitHeaderLog_2'
define view I_EWM_HandlingUnitHeaderLog as select from /scwm/gmhuhdr as _HandlingUnitHeaderLog {
key cast(_HandlingUnitHeaderLog.huident as char20 preserving type ) as HandlingUnitExternalID,
key _HandlingUnitHeaderLog.lgnum as Warehouse,
key _HandlingUnitHeaderLog.log as HandlingUnitLogUUID,
_HandlingUnitHeaderLog.letyp as HandlingUnitType,
cast(_HandlingUnitHeaderLog.pmat_guid as raw16 preserving type ) as PackagingMaterialUUID,
_HandlingUnitHeaderLog.pmtyp as PackagingMaterialType,
_HandlingUnitHeaderLog.phystat as HandlingUnitStatus,
_HandlingUnitHeaderLog.wstyp as StorageType,
_HandlingUnitHeaderLog.wssec as StorageSection,
_HandlingUnitHeaderLog.wsbin as StorageBin,
_HandlingUnitHeaderLog.max_weight as HandlingUnitMaxWeight,
_HandlingUnitHeaderLog.g_weight as GrossWeight,
_HandlingUnitHeaderLog.n_weight as NetWeight,
_HandlingUnitHeaderLog.unit_gw as WeightUnit,
_HandlingUnitHeaderLog.t_weight as HandlingUnitTareWeight,
_HandlingUnitHeaderLog.unit_tw as HandlingUnitTareWeightUnit,
_HandlingUnitHeaderLog.max_volume as HandlingUnitMaxVolume,
_HandlingUnitHeaderLog.g_volume as GrossVolume,
_HandlingUnitHeaderLog.n_volume as HandlingUnitNetVolume,
_HandlingUnitHeaderLog.tolv as HandlingUnitVolumeTolerance,
_HandlingUnitHeaderLog.unit_gv as VolumeUnit,
_HandlingUnitHeaderLog.t_volume as HandlingUnitTareVolume,
_HandlingUnitHeaderLog.unit_tv as HandlingUnitTareVolumeUnit,
_HandlingUnitHeaderLog.length as HandlingUnitLength,
_HandlingUnitHeaderLog.width as HandlingUnitWidth,
_HandlingUnitHeaderLog.height as HandlingUnitHeight,
_HandlingUnitHeaderLog.unit_lwh as UnitOfMeasureDimension,
_HandlingUnitHeaderLog.max_length as HandlingUnitMaxLength,
_HandlingUnitHeaderLog.max_width as HandlingUnitMaxWidth,
_HandlingUnitHeaderLog.max_height as HandlingUnitMaxHeight,
_HandlingUnitHeaderLog.unit_max_lwh as HandlingUnitMaxDimensionUnit,
_HandlingUnitHeaderLog.guid_hu as HandlingUnitUUID,
_HandlingUnitHeaderLog.guid_parent as ParentHandlingUnitUUID,
_HandlingUnitHeaderLog.created_by as CreatedByUser,
_HandlingUnitHeaderLog.created_at as CreationUTCDateTime,
_HandlingUnitHeaderLog.changed_by as LastChangedByUser,
_HandlingUnitHeaderLog.changed_at as LastChangeUTCDateTime,
_HandlingUnitHeaderLog.top as HandlingUnitTopLevelInd,
_HandlingUnitHeaderLog.hu_guid_ext as EWMHandlingUnitExternalUUID
} where vhi = ' '
or vhi = 'B'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"/SCWM/GMHUHDR"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/