C_TranspChargeCalcBase

DDL: C_TRANSPCHARGECALCBASE Type: view CONSUMPTION Package: CVIEW_TM_TCC

Transportation Charge Calculation Base

C_TranspChargeCalcBase is a Consumption CDS View that provides data about "Transportation Charge Calculation Base" in SAP S/4HANA. It reads from 1 data source (I_TranspChargeCalcBase) and exposes 13 fields with key fields TranspChrgCalcBaseNodeUUID, TranspChrgCalcBaseUUID. It has 1 association to related views. Part of development package CVIEW_TM_TCC.

1 data source(s) 13 fields

Data Sources (1)

SourceAliasJoin Type
I_TranspChargeCalcBase I_TranspChargeCalcBase from

Associations (1)

CardinalityTargetAliasCondition
[1..1] C_TranspChargeItemElement _TranspChargeItemElement $projection.TranspChargeItemElementUUID = _TranspChargeItemElement.TranspChargeItemElementUUID

Annotations (13)

NameValueLevelField
EndUserText.label Transportation Charge Calculation Base view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName CTCCBASE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ObjectModel.representativeKey TranspChrgCalcBaseUUID view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
AccessControl.personalData.blocking #NOT_REQUIRED view
VDM.viewType #CONSUMPTION view
Metadata.allowExtensions true view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY TranspChrgCalcBaseNodeUUID TranspChrgCalcBaseNodeUUID
KEY TranspChrgCalcBaseUUID TranspChrgCalcBaseUUID
TranspChargeItemElementUUID TranspChargeElementUUID
TransportationChargesObjUUID TransportationChargeUUID
TranspChrgCalculationBase
TranspCalculationBaseText
TranspScaleItemQuantityUnit TranspScaleItemQuantityUnit
TranspScaleItemQuantity
TranspDataSourceQtyUnit TranspDataSourceQtyUnit
TranspDataSourceQuantity
TranspDataSourceQtyIsNumeric TranspDataSourceQtyIsNumeric
_TransportationChargeElement _TransportationChargeElement
_TransportationCharge _TransportationCharge 
@EndUserText:   {label:             'Transportation Charge Calculation Base'}
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog:   {sqlViewName:        'CTCCBASE',
                 compiler.compareFilter: true,
                 preserveKey:        true                }
@ObjectModel:   {representativeKey:  'TranspChrgCalcBaseUUID',
                 usageType:          { serviceQuality: #C,
                                       sizeCategory:   #XXL,
                                       dataClass:      #MIXED}}
@AccessControl: {authorizationCheck: #PRIVILEGED_ONLY,
                 personalData.blocking:#NOT_REQUIRED}
@VDM:           {viewType:          #CONSUMPTION}
@Metadata.allowExtensions: true
define view C_TranspChargeCalcBase
  as select from I_TranspChargeCalcBase
  /* Business Object related Node Associations*/
  association [1..1] to C_TranspChargeItemElement as _TranspChargeItemElement on $projection.TranspChargeItemElementUUID = _TranspChargeItemElement.TranspChargeItemElementUUID
{
  key TranspChrgCalcBaseNodeUUID,
  key TranspChrgCalcBaseUUID,
      TranspChargeElementUUID                                                                                                      as TranspChargeItemElementUUID,
      TransportationChargeUUID                                                                                                     as TransportationChargesObjUUID,
      @ObjectModel.text.element: ['TranspCalculationBaseText']
      cast(TransportationCalculationBase as /scmtms/vdm_calc_base_dim)                                                             as TranspChrgCalculationBase,
      @Semantics.text: true
      _TranspCalculationBase._Text[1: Language = $session.system_language].TranspCalculationBaseText,
      @Consumption.filter.hidden: true
      TranspScaleItemQuantityUnit,
      @Semantics.quantity.unitOfMeasure: 'TranspScaleItemQuantityUnit'
      cast( TranspScaleItemQuantity as /scmtms/quantity_13_3)                                                                      as TranspScaleItemQuantity,
      TranspDataSourceQtyUnit,
      @Semantics.quantity.unitOfMeasure: 'TranspDataSourceQtyUnit'
      cast( TranspDataSourceQuantity as /scmtms/quantity_13_3)                                                                     as TranspDataSourceQuantity,
      TranspDataSourceQtyIsNumeric,

      cast( case
        when TranspScaleItemQtyIsNumeric = 'X' and TransportationCalculationBase = 'DAYS'
             then concat(cast(cast(TranspScaleItemQuantity as /scmtms/quantity_13_3 ) as abap.char( 33 )), TransportationCalculationBase )
        when TranspScaleItemQtyIsNumeric = 'X' and TransportationCalculationBase <> 'DAYS'
             then concat(cast(cast(TranspScaleItemQuantity as /scmtms/quantity_13_3 ) as abap.char( 33 )), TranspScaleItemQuantityUnit )
        when TranspScaleItemQtyIsCurrency = 'X'
             then concat(cast(TranspScaleItemAmount as abap.char( 33 )), TranspScaleItemCurrency )
        else
             TranspScaleItemQtyChar
        end                                                                                            as /scmtms/vdm_scale_value) as TranspScaleItemValue,

      cast( case
       when TranspDataSourceQtyIsNumeric = 'X' and TransportationCalculationBase = 'DAYS'
            then concat(cast(cast( TranspDataSourceQuantity as /scmtms/quantity_13_3 ) as abap.char( 33 )), TransportationCalculationBase )
       when TranspDataSourceQtyIsNumeric = 'X' and TransportationCalculationBase <> 'DAYS'
            then concat(cast(cast( TranspDataSourceQuantity as /scmtms/quantity_13_3 ) as abap.char( 33 )), TranspDataSourceQtyUnit )
       when TranspDataSourceQtyIsCurrency = 'X'
            then concat(cast(TranspDataSourceAmount as abap.char( 33 )), TranspDataSourceCurrency )
       else
            TranspDataSourceQtyChar
       end                                                                                      as /scmtms/vdm_data_src_value)     as TranspDataSourceValue,

      /* Associations */
      @ObjectModel.association.type:  [ #TO_COMPOSITION_PARENT]
      _TransportationChargeElement,
      @ObjectModel.association.type:  [ #TO_COMPOSITION_ROOT]
      _TransportationCharge
}

Learn More