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

C_TranspChrgCalcSheetItem

DDL: C_TRANSPCHRGCALCSHEETITEM Type: view CONSUMPTION
31 Fields 1 Data Sources 9 Associations

Transportation Charge Calc Sheet Item

C_TranspChrgCalcSheetItem is a Consumption CDS View that provides data about "Transportation Charge Calc Sheet Item" in SAP S/4HANA. It reads from 1 data source (P_TranspChrgeCalcSheetItem) and exposes 31 fields with key field TranspCalcSheetItemUUID. It has 9 associations to related views.

Data Sources (1)

SourceAliasJoin Type
P_TranspChrgeCalcSheetItem TranspChrgCalcSheetItem from

Associations (9)

CardinalityTargetAliasCondition
[0..1] I_UnitOfMeasure _UnitOfMeasureVH $projection.TranspRateCalcRuleQtyUnit = _UnitOfMeasureVH.UnitOfMeasure
[1..1] I_TranspChargeCalcReslnBase _TranspCalcResolutionBase $projection.TranspCalcResolutionBase = _TranspCalcResolutionBase.TranspChargeCalcReslnBase
[1..1] I_TranspCalculationDateType _TranspCalculationDateType $projection.TranspCalculationDateType = _TranspCalculationDateType.TranspCalculationDateType
[0..1] I_TranspRoundingProfile _TranspCalcShtItemRoundingPrfl $projection.TranspCalcShtItemRoundingPrfl = _TranspCalcShtItemRoundingPrfl.TranspChargeRoundingProfile
[1..1] I_TranspRateCalcRule _TranspRateCalcRule $projection.TransportationRateUUID = _TranspRateCalcRule.TransportationRateUUID and $projection.TranspRateClassfctn = 'LOC_RATTBL'
[0..1] I_TranspRateClassification _TranspRateClassification $projection.TranspRateClassfctn = _TranspRateClassification.TranspRateClassfctn
[1..1] I_TranspRateValidity _TranspRateValidity $projection.TransportationRateUUID = _TranspRateValidity.TransportationRateUUID and $projection.TranspRateClassfctn = 'LOC_RATTBL'
[0..*] C_TranspRateScaleReference _TranspRateScaleReference
[0..*] C_TranspRateDimension _TranspRateDimension

Annotations (15)

NameValueLevelField
EndUserText.label Transportation Charge Calc Sheet Item view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName CTCCSITEM view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ObjectModel.representativeKey TranspCalcSheetItemUUID view
ObjectModel.semanticKey TranspCalculationSheetItem view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MASTER view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.status #DEPRECATED view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
AccessControl.personalData.blocking #NOT_REQUIRED view
Metadata.allowExtensions true view

Fields (31)

KeyFieldSource TableSource FieldDescription
KEY TranspCalcSheetItemUUID TranspCalcSheetItemUUID
TransportationRateUUID TransportationRateUUID
TranspChrgCalcSheetUUID TranspChrgCalcSheetUUID
TranspCalculationSheetItem TranspCalculationSheetItem
TranspCalcBaselineUUID P_TranspChrgeCalcSheetItem TranspCalcBaselineUUID
TranspChargeType TranspChargeType
TranspChargeTypeDesc
TranspCalcResolutionBase TranspCalcResolutionBase
TranspChargeCalcReslnBaseDesc
TranspCalcSheetItemCurrency TranspCalcSheetItemCurrency
TranspCalcSheetItemAmount TranspCalcSheetItemAmount
TranspCalcShtItemRoundingPrfl TranspCalcShtItemRoundingPrfl
TranspChargeRoundingPrflDesc
TranspCalculationMethodCode TranspCalculationMethodCode
TranspCalcMethodCodeDesc
TranspCalculationDateType TranspCalculationDateType
TranspCalculationDateTypeDesc
TranspRateClassfctn TranspRateClassfctn
TranspRateClassfctnDesc
TranspCalcSheetItemIsMandatory TranspCalcSheetItemIsMandatory
TransportationAgreementUUID
TranspRateCalculationBase _TranspRateCalcRule TranspRateCalculationBase
TranspCalculationBaseText
TranspRateCalcRuleQtyUnit _TranspRateCalcRule TranspRateCalcRuleQtyUnit
TranspRateCalcRuleQuantity
TranspRateValidityCurrency
_TranspRateScaleReference _TranspRateScaleReference
_TranspRateDimension _TranspRateDimension
_UnitOfMeasureVH _UnitOfMeasureVH
_TranspRateCalcRule _TranspRateCalcRule
_TranspRateClassification _TranspRateClassification

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_TranspChrgCalcSheetItem.
-- 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_TranspChrgCalcSheetItem AS
SELECT
  TranspCalcSheetItemUUID,
  TransportationRateUUID,
  TranspChrgCalcSheetUUID,
  TranspCalculationSheetItem,
  TranspChrgCalcSheetItem.TranspCalcBaselineUUID AS TranspCalcBaselineUUID,
  TranspChargeType,
  _TranspChargeType._Text[1: Language = $session.system_language].TranspChargeTypeDesc AS TranspChargeTypeDesc,
  TranspCalcResolutionBase,
  _TranspCalcResolutionBase._Text[1: Language = $session.system_language ].TranspChargeCalcReslnBaseDesc AS TranspChargeCalcReslnBaseDesc,
  TranspCalcSheetItemCurrency,
  TranspCalcSheetItemAmount,
  TranspCalcShtItemRoundingPrfl,
  _TranspCalcShtItemRoundingPrfl._Text[1: Language = $session.system_language ].TranspChargeRoundingPrflDesc AS TranspChargeRoundingPrflDesc,
  TranspCalculationMethodCode,
  _TranspCalcMethodType._Text[1: Language = $session.system_language ].TranspCalcMethodCodeDesc AS TranspCalcMethodCodeDesc,
  TranspCalculationDateType,
  _TranspCalculationDateType._Text[1: Language = $session.system_language ].TranspCalculationDateTypeDesc AS TranspCalculationDateTypeDesc,
  TranspRateClassfctn,
  _TranspRateClassification._Text[1: Language = $session.system_language ].TranspRateClassfctnDesc AS TranspRateClassfctnDesc,
  TranspCalcSheetItemIsMandatory,
  TranspChrgCalcSheetItem._TranspChargeCalcSheet.TransportationAgreementUUID AS TransportationAgreementUUID,
  _TranspRateCalcRule.TranspRateCalculationBase AS TranspRateCalculationBase,
  _TranspRateCalcRule._TranspRateCalculationBase._Text[1: Language = $session.system_language].TranspCalculationBaseText AS TranspCalculationBaseText,
  _TranspRateCalcRule.TranspRateCalcRuleQtyUnit AS TranspRateCalcRuleQtyUnit,
  cast( coalesce( _TranspRateCalcRule.TranspRateCalcRuleQuantity, 0 ) as abap.quan( 31 , 3 ) ) AS TranspRateCalcRuleQuantity,
  _TranspRateValidity[1: TransportationRateUUID = TransportationRateUUID].TranspRateValidityCurrency AS TranspRateValidityCurrency
FROM P_TranspChrgeCalcSheetItem AS TranspChrgCalcSheetItem
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasureVH ON TranspRateCalcRuleQtyUnit = _UnitOfMeasureVH.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_TranspChargeCalcReslnBase AS _TranspCalcResolutionBase ON TranspCalcResolutionBase = _TranspCalcResolutionBase.TranspChargeCalcReslnBase  -- association [1..1]
LEFT OUTER JOIN I_TranspCalculationDateType AS _TranspCalculationDateType ON TranspCalculationDateType = _TranspCalculationDateType.TranspCalculationDateType  -- association [1..1]
LEFT OUTER JOIN I_TranspRoundingProfile AS _TranspCalcShtItemRoundingPrfl ON TranspCalcShtItemRoundingPrfl = _TranspCalcShtItemRoundingPrfl.TranspChargeRoundingProfile  -- association [0..1]
LEFT OUTER JOIN I_TranspRateCalcRule AS _TranspRateCalcRule ON TransportationRateUUID = _TranspRateCalcRule.TransportationRateUUID AND TranspRateClassfctn = 'LOC_RATTBL'  -- association [1..1]
LEFT OUTER JOIN I_TranspRateClassification AS _TranspRateClassification ON TranspRateClassfctn = _TranspRateClassification.TranspRateClassfctn  -- association [0..1]
LEFT OUTER JOIN I_TranspRateValidity AS _TranspRateValidity ON TransportationRateUUID = _TranspRateValidity.TransportationRateUUID AND TranspRateClassfctn = 'LOC_RATTBL'  -- association [1..1]
LEFT OUTER JOIN C_TranspRateScaleReference AS _TranspRateScaleReference ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN C_TranspRateDimension AS _TranspRateDimension ON /* condition not available in parsed metadata */  -- association [0..*]
;

Learn More