Deprecated
This CDS view is deprecated in S/4HANA. View all deprecated CDS views →

C_TranspRateDimension

DDL: C_TRANSPRATEDIMENSION Type: view CONSUMPTION

Rate Table Dimensional Rates

C_TranspRateDimension is a Consumption CDS View that provides data about "Rate Table Dimensional Rates" in SAP S/4HANA. It reads from 1 data source (I_TranspRateDimension) and exposes 120 fields with key fields TranspRateDimensionUUID, TransportationRateUUID.

Data Sources (1)

SourceAliasJoin Type
I_TranspRateDimension TranspRateDimn from

Annotations (13)

NameValueLevelField
EndUserText.label Rate Table Dimensional Rates view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName CRATEDIMN view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ObjectModel.representativeKey TranspRateDimensionUUID view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MASTER view
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
Metadata.allowExtensions true view
VDM.lifecycle.status #DEPRECATED view

Fields (120)

KeyFieldSource TableSource FieldDescription
KEY TranspRateDimensionUUID TranspRateDimensionUUID
KEY TransportationRateUUID TransportationRateUUID
TranspCalcSheetItemUUID
TranspRateDimnScaleItem01UUID TranspRateDimnScaleItem01UUID
TranspRateDimnScaleItem02UUID TranspRateDimnScaleItem02UUID
TranspRateDimnScaleItem03UUID TranspRateDimnScaleItem03UUID
TranspRateDimnScaleItem04UUID TranspRateDimnScaleItem04UUID
TranspRateDimnScaleItem05UUID TranspRateDimnScaleItem05UUID
TranspRateDimnScaleItem06UUID TranspRateDimnScaleItem06UUID
TranspRateDimnScaleItem07UUID TranspRateDimnScaleItem07UUID
TranspRateDimnScaleItem08UUID TranspRateDimnScaleItem08UUID
TranspRateDimnScaleItem09UUID TranspRateDimnScaleItem09UUID
TranspRateDimnScaleItem10UUID TranspRateDimnScaleItem10UUID
TranspRateDimnScaleItem11UUID TranspRateDimnScaleItem11UUID
TranspRateDimnScaleItem12UUID TranspRateDimnScaleItem12UUID
TranspRateDimnScaleItem13UUID TranspRateDimnScaleItem13UUID
TranspRateDimnScaleItem14UUID TranspRateDimnScaleItem14UUID
TransportationRateCurrency TransportationRateCurrency
TranspRateAmountInRateCrcy TranspRateAmountInRateCrcy
TranspRateDimensionIndex TranspRateDimensionIndex
TransportationCalcBase01
TranspCalculationBaseText01
TransportationCalcBase02
TranspCalculationBaseText02
TransportationCalcBase03
TranspCalculationBaseText03
TransportationCalcBase04
TranspCalculationBaseText04
TransportationCalcBase05
TranspCalculationBaseText05
TransportationCalcBase06
TranspCalculationBaseText06
TransportationCalcBase07
TranspCalculationBaseText07
TransportationCalcBase08
TranspCalculationBaseText08
TransportationCalcBase09
TranspCalculationBaseText09
TransportationCalcBase10
TranspCalculationBaseText10
TransportationCalcBase11
TranspCalculationBaseText11
TransportationCalcBase12
TranspCalculationBaseText12
TransportationCalcBase13
TranspCalculationBaseText13
TransportationCalcBase14
TranspCalculationBaseText14
datsasTranspScaleItemValueDate01
datsasTranspScaleItemValueDate02
datsasTranspScaleItemValueDate03
datsasTranspScaleItemValueDate04
datsasTranspScaleItemValueDate05
datsasTranspScaleItemValueDate06
datsasTranspScaleItemValueDate07
datsasTranspScaleItemValueDate08
datsasTranspScaleItemValueDate09
datsasTranspScaleItemValueDate10
datsasTranspScaleItemValueDate11
datsasTranspScaleItemValueDate12
datsasTranspScaleItemValueDate13
datsasTranspScaleItemValueDate14
_TransportationRate _TransportationRate
_TranspChrgCalcSheetItem _TranspChrgCalcSheetItem
TranspScaleItemCurrency01 _TransportationScaleItem01 TranspScaleItemCurrency
TranspScaleItemQuantityUnit01 _TransportationScaleItem01 TranspScaleItemQuantityUnit
TranspScaleItemValueChar01 _TransportationScaleItem01 TranspScaleItemValueChar
TranspScaleItemValueRaw01 _TransportationScaleItem01 TranspScaleItemValueRaw
TranspScaleItemCurrency02 _TransportationScaleItem02 TranspScaleItemCurrency
TranspScaleItemQuantityUnit02 _TransportationScaleItem02 TranspScaleItemQuantityUnit
TranspScaleItemValueChar02 _TransportationScaleItem02 TranspScaleItemValueChar
TranspScaleItemValueRaw02 _TransportationScaleItem02 TranspScaleItemValueRaw
TranspScaleItemCurrency03 _TransportationScaleItem03 TranspScaleItemCurrency
TranspScaleItemQuantityUnit03 _TransportationScaleItem03 TranspScaleItemQuantityUnit
TranspScaleItemValueChar03 _TransportationScaleItem03 TranspScaleItemValueChar
TranspScaleItemValueRaw03 _TransportationScaleItem03 TranspScaleItemValueRaw
TranspScaleItemCurrency04 _TransportationScaleItem04 TranspScaleItemCurrency
TranspScaleItemQuantityUnit04 _TransportationScaleItem04 TranspScaleItemQuantityUnit
TranspScaleItemValueChar04 _TransportationScaleItem04 TranspScaleItemValueChar
TranspScaleItemValueRaw04 _TransportationScaleItem04 TranspScaleItemValueRaw
TranspScaleItemCurrency05 _TransportationScaleItem05 TranspScaleItemCurrency
TranspScaleItemQuantityUnit05 _TransportationScaleItem05 TranspScaleItemQuantityUnit
TranspScaleItemValueChar05 _TransportationScaleItem05 TranspScaleItemValueChar
TranspScaleItemValueRaw05 _TransportationScaleItem05 TranspScaleItemValueRaw
TranspScaleItemCurrency06 _TransportationScaleItem06 TranspScaleItemCurrency
TranspScaleItemQuantityUnit06 _TransportationScaleItem06 TranspScaleItemQuantityUnit
TranspScaleItemValueChar06 _TransportationScaleItem06 TranspScaleItemValueChar
TranspScaleItemValueRaw06 _TransportationScaleItem06 TranspScaleItemValueRaw
TranspScaleItemCurrency07 _TransportationScaleItem07 TranspScaleItemCurrency
TranspScaleItemQuantityUnit07 _TransportationScaleItem07 TranspScaleItemQuantityUnit
TranspScaleItemValueChar07 _TransportationScaleItem07 TranspScaleItemValueChar
TranspScaleItemValueRaw07 _TransportationScaleItem07 TranspScaleItemValueRaw
TranspScaleItemCurrency08 _TransportationScaleItem08 TranspScaleItemCurrency
TranspScaleItemQuantityUnit08 _TransportationScaleItem08 TranspScaleItemQuantityUnit
TranspScaleItemValueChar08 _TransportationScaleItem08 TranspScaleItemValueChar
TranspScaleItemValueRaw08 _TransportationScaleItem08 TranspScaleItemValueRaw
TranspScaleItemCurrency09 _TransportationScaleItem09 TranspScaleItemCurrency
TranspScaleItemQuantityUnit09 _TransportationScaleItem09 TranspScaleItemQuantityUnit
TranspScaleItemValueChar09 _TransportationScaleItem09 TranspScaleItemValueChar
TranspScaleItemValueRaw09 _TransportationScaleItem09 TranspScaleItemValueRaw
TranspScaleItemCurrency10 _TransportationScaleItem10 TranspScaleItemCurrency
TranspScaleItemQuantityUnit10 _TransportationScaleItem10 TranspScaleItemQuantityUnit
TranspScaleItemValueChar10 _TransportationScaleItem10 TranspScaleItemValueChar
TranspScaleItemValueRaw10 _TransportationScaleItem10 TranspScaleItemValueRaw
TranspScaleItemCurrency11 _TransportationScaleItem11 TranspScaleItemCurrency
TranspScaleItemQuantityUnit11 _TransportationScaleItem11 TranspScaleItemQuantityUnit
TranspScaleItemValueChar11 _TransportationScaleItem11 TranspScaleItemValueChar
TranspScaleItemValueRaw11 _TransportationScaleItem11 TranspScaleItemValueRaw
TranspScaleItemCurrency12 _TransportationScaleItem12 TranspScaleItemCurrency
TranspScaleItemQuantityUnit12 _TransportationScaleItem12 TranspScaleItemQuantityUnit
TranspScaleItemValueChar12 _TransportationScaleItem12 TranspScaleItemValueChar
TranspScaleItemValueRaw12 _TransportationScaleItem12 TranspScaleItemValueRaw
TranspScaleItemCurrency13 _TransportationScaleItem13 TranspScaleItemCurrency
TranspScaleItemQuantityUnit13 _TransportationScaleItem13 TranspScaleItemQuantityUnit
TranspScaleItemValueChar13 _TransportationScaleItem13 TranspScaleItemValueChar
TranspScaleItemValueRaw13 _TransportationScaleItem13 TranspScaleItemValueRaw
TranspScaleItemCurrency14 _TransportationScaleItem14 TranspScaleItemCurrency
TranspScaleItemQuantityUnit14 _TransportationScaleItem14 TranspScaleItemQuantityUnit
TranspScaleItemValueChar14 _TransportationScaleItem14 TranspScaleItemValueChar
TranspScaleItemValueRaw14 _TransportationScaleItem14 TranspScaleItemValueRaw

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view C_TranspRateDimension.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW C_TranspRateDimension AS
SELECT
  TranspRateDimensionUUID,
  TransportationRateUUID,
  _TransportationRate._TranspCalcSheetItem.TranspCalcSheetItemUUID AS TranspCalcSheetItemUUID,
  TranspRateDimnScaleItem01UUID,
  TranspRateDimnScaleItem02UUID,
  TranspRateDimnScaleItem03UUID,
  TranspRateDimnScaleItem04UUID,
  TranspRateDimnScaleItem05UUID,
  TranspRateDimnScaleItem06UUID,
  TranspRateDimnScaleItem07UUID,
  TranspRateDimnScaleItem08UUID,
  TranspRateDimnScaleItem09UUID,
  TranspRateDimnScaleItem10UUID,
  TranspRateDimnScaleItem11UUID,
  TranspRateDimnScaleItem12UUID,
  TranspRateDimnScaleItem13UUID,
  TranspRateDimnScaleItem14UUID,
  TransportationRateCurrency,
  TranspRateAmountInRateCrcy,
  TranspRateDimensionIndex,
  _TransportationScaleItem01._TransportationScale._TranspRateScaleReference.TransportationCalculationBase AS TransportationCalcBase01,
  _TransportationScaleItem01._TransportationScale._TranspRateScaleReference._TransportationCalculationBase._Text[1:Language = $session.system_language].TranspCalculationBaseText AS TranspCalculationBaseText01,
  _TransportationScaleItem02._TransportationScale._TranspRateScaleReference.TransportationCalculationBase AS TransportationCalcBase02,
  _TransportationScaleItem02._TransportationScale._TranspRateScaleReference._TransportationCalculationBase._Text[1:Language = $session.system_language].TranspCalculationBaseText AS TranspCalculationBaseText02,
  _TransportationScaleItem03._TransportationScale._TranspRateScaleReference.TransportationCalculationBase AS TransportationCalcBase03,
  _TransportationScaleItem03._TransportationScale._TranspRateScaleReference._TransportationCalculationBase._Text[1:Language = $session.system_language].TranspCalculationBaseText AS TranspCalculationBaseText03,
  _TransportationScaleItem04._TransportationScale._TranspRateScaleReference.TransportationCalculationBase AS TransportationCalcBase04,
  _TransportationScaleItem04._TransportationScale._TranspRateScaleReference._TransportationCalculationBase._Text[1:Language = $session.system_language].TranspCalculationBaseText AS TranspCalculationBaseText04,
  _TransportationScaleItem05._TransportationScale._TranspRateScaleReference.TransportationCalculationBase AS TransportationCalcBase05,
  _TransportationScaleItem05._TransportationScale._TranspRateScaleReference._TransportationCalculationBase._Text[1:Language = $session.system_language].TranspCalculationBaseText AS TranspCalculationBaseText05,
  _TransportationScaleItem06._TransportationScale._TranspRateScaleReference.TransportationCalculationBase AS TransportationCalcBase06,
  _TransportationScaleItem06._TransportationScale._TranspRateScaleReference._TransportationCalculationBase._Text[1:Language = $session.system_language].TranspCalculationBaseText AS TranspCalculationBaseText06,
  _TransportationScaleItem07._TransportationScale._TranspRateScaleReference.TransportationCalculationBase AS TransportationCalcBase07,
  _TransportationScaleItem07._TransportationScale._TranspRateScaleReference._TransportationCalculationBase._Text[1:Language = $session.system_language].TranspCalculationBaseText AS TranspCalculationBaseText07,
  _TransportationScaleItem08._TransportationScale._TranspRateScaleReference.TransportationCalculationBase AS TransportationCalcBase08,
  _TransportationScaleItem08._TransportationScale._TranspRateScaleReference._TransportationCalculationBase._Text[1:Language = $session.system_language].TranspCalculationBaseText AS TranspCalculationBaseText08,
  _TransportationScaleItem09._TransportationScale._TranspRateScaleReference.TransportationCalculationBase AS TransportationCalcBase09,
  _TransportationScaleItem09._TransportationScale._TranspRateScaleReference._TransportationCalculationBase._Text[1:Language = $session.system_language].TranspCalculationBaseText AS TranspCalculationBaseText09,
  _TransportationScaleItem10._TransportationScale._TranspRateScaleReference.TransportationCalculationBase AS TransportationCalcBase10,
  _TransportationScaleItem10._TransportationScale._TranspRateScaleReference._TransportationCalculationBase._Text[1:Language = $session.system_language].TranspCalculationBaseText AS TranspCalculationBaseText10,
  _TransportationScaleItem11._TransportationScale._TranspRateScaleReference.TransportationCalculationBase AS TransportationCalcBase11,
  _TransportationScaleItem11._TransportationScale._TranspRateScaleReference._TransportationCalculationBase._Text[1:Language = $session.system_language].TranspCalculationBaseText AS TranspCalculationBaseText11,
  _TransportationScaleItem12._TransportationScale._TranspRateScaleReference.TransportationCalculationBase AS TransportationCalcBase12,
  _TransportationScaleItem12._TransportationScale._TranspRateScaleReference._TransportationCalculationBase._Text[1:Language = $session.system_language].TranspCalculationBaseText AS TranspCalculationBaseText12,
  _TransportationScaleItem13._TransportationScale._TranspRateScaleReference.TransportationCalculationBase AS TransportationCalcBase13,
  _TransportationScaleItem13._TransportationScale._TranspRateScaleReference._TransportationCalculationBase._Text[1:Language = $session.system_language].TranspCalculationBaseText AS TranspCalculationBaseText13,
  _TransportationScaleItem14._TransportationScale._TranspRateScaleReference.TransportationCalculationBase AS TransportationCalcBase14,
  _TransportationScaleItem14._TransportationScale._TranspRateScaleReference._TransportationCalculationBase._Text[1:Language = $session.system_language].TranspCalculationBaseText AS TranspCalculationBaseText14,
  cast( case when _TransportationScaleItem01._TransportationScale._TransportationScaleBase.TranspScaleBaseIsDate = 'X' and _TransportationScaleItem01.TranspScaleItemValueChar is not initial then _TransportationScaleItem01.TranspScaleItemValueChar else '00000000' end as abap.dats ) as TranspScaleItemValueDate01 AS datsasTranspScaleItemValueDate01,
  cast( case when _TransportationScaleItem02._TransportationScale._TransportationScaleBase.TranspScaleBaseIsDate = 'X' and _TransportationScaleItem02.TranspScaleItemValueChar is not initial then _TransportationScaleItem02.TranspScaleItemValueChar else '00000000' end as abap.dats ) as TranspScaleItemValueDate02 AS datsasTranspScaleItemValueDate02,
  cast( case when _TransportationScaleItem03._TransportationScale._TransportationScaleBase.TranspScaleBaseIsDate = 'X' and _TransportationScaleItem03.TranspScaleItemValueChar is not initial then _TransportationScaleItem03.TranspScaleItemValueChar else '00000000' end as abap.dats ) as TranspScaleItemValueDate03 AS datsasTranspScaleItemValueDate03,
  cast( case when _TransportationScaleItem04._TransportationScale._TransportationScaleBase.TranspScaleBaseIsDate = 'X' and _TransportationScaleItem04.TranspScaleItemValueChar is not initial then _TransportationScaleItem04.TranspScaleItemValueChar else '00000000' end as abap.dats ) as TranspScaleItemValueDate04 AS datsasTranspScaleItemValueDate04,
  cast( case when _TransportationScaleItem05._TransportationScale._TransportationScaleBase.TranspScaleBaseIsDate = 'X' and _TransportationScaleItem05.TranspScaleItemValueChar is not initial then _TransportationScaleItem05.TranspScaleItemValueChar else '00000000' end as abap.dats ) as TranspScaleItemValueDate05 AS datsasTranspScaleItemValueDate05,
  cast( case when _TransportationScaleItem06._TransportationScale._TransportationScaleBase.TranspScaleBaseIsDate = 'X' and _TransportationScaleItem06.TranspScaleItemValueChar is not initial then _TransportationScaleItem06.TranspScaleItemValueChar else '00000000' end as abap.dats ) as TranspScaleItemValueDate06 AS datsasTranspScaleItemValueDate06,
  cast( case when _TransportationScaleItem07._TransportationScale._TransportationScaleBase.TranspScaleBaseIsDate = 'X' and _TransportationScaleItem07.TranspScaleItemValueChar is not initial then _TransportationScaleItem07.TranspScaleItemValueChar else '00000000' end as abap.dats ) as TranspScaleItemValueDate07 AS datsasTranspScaleItemValueDate07,
  cast( case when _TransportationScaleItem08._TransportationScale._TransportationScaleBase.TranspScaleBaseIsDate = 'X' and _TransportationScaleItem08.TranspScaleItemValueChar is not initial then _TransportationScaleItem08.TranspScaleItemValueChar else '00000000' end as abap.dats ) as TranspScaleItemValueDate08 AS datsasTranspScaleItemValueDate08,
  cast( case when _TransportationScaleItem09._TransportationScale._TransportationScaleBase.TranspScaleBaseIsDate = 'X' and _TransportationScaleItem09.TranspScaleItemValueChar is not initial then _TransportationScaleItem09.TranspScaleItemValueChar else '00000000' end as abap.dats ) as TranspScaleItemValueDate09 AS datsasTranspScaleItemValueDate09,
  cast( case when _TransportationScaleItem10._TransportationScale._TransportationScaleBase.TranspScaleBaseIsDate = 'X' and _TransportationScaleItem10.TranspScaleItemValueChar is not initial then _TransportationScaleItem10.TranspScaleItemValueChar else '00000000' end as abap.dats ) as TranspScaleItemValueDate10 AS datsasTranspScaleItemValueDate10,
  cast( case when _TransportationScaleItem11._TransportationScale._TransportationScaleBase.TranspScaleBaseIsDate = 'X' and _TransportationScaleItem11.TranspScaleItemValueChar is not initial then _TransportationScaleItem11.TranspScaleItemValueChar else '00000000' end as abap.dats ) as TranspScaleItemValueDate11 AS datsasTranspScaleItemValueDate11,
  cast( case when _TransportationScaleItem12._TransportationScale._TransportationScaleBase.TranspScaleBaseIsDate = 'X' and _TransportationScaleItem12.TranspScaleItemValueChar is not initial then _TransportationScaleItem12.TranspScaleItemValueChar else '00000000' end as abap.dats ) as TranspScaleItemValueDate12 AS datsasTranspScaleItemValueDate12,
  cast( case when _TransportationScaleItem13._TransportationScale._TransportationScaleBase.TranspScaleBaseIsDate = 'X' and _TransportationScaleItem13.TranspScaleItemValueChar is not initial then _TransportationScaleItem13.TranspScaleItemValueChar else '00000000' end as abap.dats ) as TranspScaleItemValueDate13 AS datsasTranspScaleItemValueDate13,
  cast( case when _TransportationScaleItem14._TransportationScale._TransportationScaleBase.TranspScaleBaseIsDate = 'X' and _TransportationScaleItem14.TranspScaleItemValueChar is not initial then _TransportationScaleItem14.TranspScaleItemValueChar else '00000000' end as abap.dats ) as TranspScaleItemValueDate14 AS datsasTranspScaleItemValueDate14,
  _TransportationScaleItem01.TranspScaleItemCurrency AS TranspScaleItemCurrency01,
  _TransportationScaleItem01.TranspScaleItemQuantityUnit AS TranspScaleItemQuantityUnit01,
  _TransportationScaleItem01.TranspScaleItemValueChar AS TranspScaleItemValueChar01,
  _TransportationScaleItem01.TranspScaleItemValueRaw AS TranspScaleItemValueRaw01,
  _TransportationScaleItem02.TranspScaleItemCurrency AS TranspScaleItemCurrency02,
  _TransportationScaleItem02.TranspScaleItemQuantityUnit AS TranspScaleItemQuantityUnit02,
  _TransportationScaleItem02.TranspScaleItemValueChar AS TranspScaleItemValueChar02,
  _TransportationScaleItem02.TranspScaleItemValueRaw AS TranspScaleItemValueRaw02,
  _TransportationScaleItem03.TranspScaleItemCurrency AS TranspScaleItemCurrency03,
  _TransportationScaleItem03.TranspScaleItemQuantityUnit AS TranspScaleItemQuantityUnit03,
  _TransportationScaleItem03.TranspScaleItemValueChar AS TranspScaleItemValueChar03,
  _TransportationScaleItem03.TranspScaleItemValueRaw AS TranspScaleItemValueRaw03,
  _TransportationScaleItem04.TranspScaleItemCurrency AS TranspScaleItemCurrency04,
  _TransportationScaleItem04.TranspScaleItemQuantityUnit AS TranspScaleItemQuantityUnit04,
  _TransportationScaleItem04.TranspScaleItemValueChar AS TranspScaleItemValueChar04,
  _TransportationScaleItem04.TranspScaleItemValueRaw AS TranspScaleItemValueRaw04,
  _TransportationScaleItem05.TranspScaleItemCurrency AS TranspScaleItemCurrency05,
  _TransportationScaleItem05.TranspScaleItemQuantityUnit AS TranspScaleItemQuantityUnit05,
  _TransportationScaleItem05.TranspScaleItemValueChar AS TranspScaleItemValueChar05,
  _TransportationScaleItem05.TranspScaleItemValueRaw AS TranspScaleItemValueRaw05,
  _TransportationScaleItem06.TranspScaleItemCurrency AS TranspScaleItemCurrency06,
  _TransportationScaleItem06.TranspScaleItemQuantityUnit AS TranspScaleItemQuantityUnit06,
  _TransportationScaleItem06.TranspScaleItemValueChar AS TranspScaleItemValueChar06,
  _TransportationScaleItem06.TranspScaleItemValueRaw AS TranspScaleItemValueRaw06,
  _TransportationScaleItem07.TranspScaleItemCurrency AS TranspScaleItemCurrency07,
  _TransportationScaleItem07.TranspScaleItemQuantityUnit AS TranspScaleItemQuantityUnit07,
  _TransportationScaleItem07.TranspScaleItemValueChar AS TranspScaleItemValueChar07,
  _TransportationScaleItem07.TranspScaleItemValueRaw AS TranspScaleItemValueRaw07,
  _TransportationScaleItem08.TranspScaleItemCurrency AS TranspScaleItemCurrency08,
  _TransportationScaleItem08.TranspScaleItemQuantityUnit AS TranspScaleItemQuantityUnit08,
  _TransportationScaleItem08.TranspScaleItemValueChar AS TranspScaleItemValueChar08,
  _TransportationScaleItem08.TranspScaleItemValueRaw AS TranspScaleItemValueRaw08,
  _TransportationScaleItem09.TranspScaleItemCurrency AS TranspScaleItemCurrency09,
  _TransportationScaleItem09.TranspScaleItemQuantityUnit AS TranspScaleItemQuantityUnit09,
  _TransportationScaleItem09.TranspScaleItemValueChar AS TranspScaleItemValueChar09,
  _TransportationScaleItem09.TranspScaleItemValueRaw AS TranspScaleItemValueRaw09,
  _TransportationScaleItem10.TranspScaleItemCurrency AS TranspScaleItemCurrency10,
  _TransportationScaleItem10.TranspScaleItemQuantityUnit AS TranspScaleItemQuantityUnit10,
  _TransportationScaleItem10.TranspScaleItemValueChar AS TranspScaleItemValueChar10,
  _TransportationScaleItem10.TranspScaleItemValueRaw AS TranspScaleItemValueRaw10,
  _TransportationScaleItem11.TranspScaleItemCurrency AS TranspScaleItemCurrency11,
  _TransportationScaleItem11.TranspScaleItemQuantityUnit AS TranspScaleItemQuantityUnit11,
  _TransportationScaleItem11.TranspScaleItemValueChar AS TranspScaleItemValueChar11,
  _TransportationScaleItem11.TranspScaleItemValueRaw AS TranspScaleItemValueRaw11,
  _TransportationScaleItem12.TranspScaleItemCurrency AS TranspScaleItemCurrency12,
  _TransportationScaleItem12.TranspScaleItemQuantityUnit AS TranspScaleItemQuantityUnit12,
  _TransportationScaleItem12.TranspScaleItemValueChar AS TranspScaleItemValueChar12,
  _TransportationScaleItem12.TranspScaleItemValueRaw AS TranspScaleItemValueRaw12,
  _TransportationScaleItem13.TranspScaleItemCurrency AS TranspScaleItemCurrency13,
  _TransportationScaleItem13.TranspScaleItemQuantityUnit AS TranspScaleItemQuantityUnit13,
  _TransportationScaleItem13.TranspScaleItemValueChar AS TranspScaleItemValueChar13,
  _TransportationScaleItem13.TranspScaleItemValueRaw AS TranspScaleItemValueRaw13,
  _TransportationScaleItem14.TranspScaleItemCurrency AS TranspScaleItemCurrency14,
  _TransportationScaleItem14.TranspScaleItemQuantityUnit AS TranspScaleItemQuantityUnit14,
  _TransportationScaleItem14.TranspScaleItemValueChar AS TranspScaleItemValueChar14,
  _TransportationScaleItem14.TranspScaleItemValueRaw AS TranspScaleItemValueRaw14
FROM I_TranspRateDimension AS TranspRateDimn
;