I_FreightUnitVH

DDL: I_FREIGHTUNITVH SQL: IFREIGHTUNIT_VH Type: view COMPOSITE Package: VDM_TM_BO_TOR

TM Freight Unit value help

I_FreightUnitVH is a Composite CDS View that provides data about "TM Freight Unit value help" in SAP S/4HANA. Part of development package VDM_TM_BO_TOR.

19 fields

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName IFREIGHTUNIT_VH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.viewType #COMPOSITE view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.representativeKey TransportationOrderUUID view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
Search.searchable true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label TM Freight Unit value help view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY TransportationOrderUUID
FreightUnit TransportationOrder Freight Unit
TransportationOrderType TransportationOrderType Freight Unit Type
PurchasingOrganization PurchasingOrganization Purch. Organization
CreatedByUser CreatedByUser Created By
CreationDateTime CreationDateTime Created On
TranspOrdLifeCycleStatus TranspOrdLifeCycleStatus Life Cycle Status
TranspOrderDngrsGdsSts TranspOrderDngrsGdsSts Dangerous Goods Status
Shipper Shipper Shipper
Consignee Consignee Ship-to Party
PurchasingGroup PurchasingGroup
PlngAndExecGroup PlngAndExecGroup
PlngAndExecOrganization PlngAndExecOrganization
MeansOfTransport MeansOfTransport
TranspOrdResponsiblePerson TranspOrdResponsiblePerson
BusinessTransactionDocument BusinessTransactionDocument
BusinessTransactionDocType BusinessTransactionDocType
SourceLocation _SourceStop LocationId
DestinationLocation _DestinationStop LocationId 
@AbapCatalog.sqlViewName: 'IFREIGHTUNIT_VH'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@VDM.viewType: #COMPOSITE
@ObjectModel.dataCategory: #VALUE_HELP
@ObjectModel.representativeKey: 'TransportationOrderUUID'
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #MASTER
@Search.searchable: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE

@Metadata.ignorePropagatedAnnotations: true

@EndUserText.label: 'TM Freight Unit value help'

define view I_FreightUnitVH
  as select distinct from I_TransportationOrder
{
  @Consumption.filter.hidden: true
  @UI.hidden: true
  key cast(TransportationOrderUUID     as /scmtms/vdm_tor_db_key preserving type )      as TransportationOrderUUID,
      @Search.defaultSearchElement: true
      @Search.ranking: #HIGH
      @EndUserText.label: 'Freight Unit'
      TransportationOrder                                                               as FreightUnit,
      @EndUserText.label: 'Freight Unit Type'
      TransportationOrderType                                                           as TransportationOrderType,
      @EndUserText.label: 'Purch. Organization'
      PurchasingOrganization                                                            as PurchasingOrganization,
      @EndUserText.label: 'Created By'
      CreatedByUser                                                                     as CreatedByUser,
      @EndUserText.label: 'Created On'
      CreationDateTime                                                                  as CreationDateTime,
      @EndUserText.label: 'Life Cycle Status'
      TranspOrdLifeCycleStatus                                                          as TranspOrdLifeCycleStatus,
      @EndUserText.label: 'Dangerous Goods Status'
      TranspOrderDngrsGdsSts                                                            as TranspOrderDngrsGdsSts,
      @EndUserText.label: 'Shipper'
      Shipper                                                                           as Shipper,
      @EndUserText.label: 'Ship-to Party'
      Consignee                                                                         as Consignee,

      @UI.hidden: true
      PurchasingGroup                                                                   as PurchasingGroup,
      @UI.hidden: true
      PlngAndExecGroup                                                                  as PlngAndExecGroup,
      @UI.hidden: true
      PlngAndExecOrganization                                                           as PlngAndExecOrganization,
      @UI.hidden: true
      MeansOfTransport                                                                  as MeansOfTransport,
      @UI.hidden: true
      TranspOrdResponsiblePerson                                                        as TranspOrdResponsiblePerson,
      
      @Consumption.filter.hidden: true
      @UI.hidden: true  
      BusinessTransactionDocument                                                       as BusinessTransactionDocument,
      @Consumption.filter.hidden: true
      @UI.hidden: true
      BusinessTransactionDocType                                                        as BusinessTransactionDocType,
      @Consumption.filter.hidden: true
      @UI.hidden: true
      _SourceStop.LocationId                                                            as SourceLocation,
      @Consumption.filter.hidden: true
      @UI.hidden: true
      _DestinationStop.LocationId                                                       as DestinationLocation                                                    
}

where
      TransportationOrderCategory = 'FU' // /SCMTMS/IF_TOR_CONST=>SC_TOR_CATEGORY-ACTIVE

  and TransportationOrder         is not initial

Learn More