C_CollabnMngFrtOrdChrgElement

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_CollabnMngFrtOrdChrgElement.
-- 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_CollabnMngFrtOrdChrgElement AS
SELECT
  FrtOrdChrgElement.TransportationOrderUUID AS TransportationOrderUUID,
  FrtOrdChrgElement.TranspChrgRefElementUUID AS TranspChrgRefElementUUID,
  FrtOrdChrgElement.TranspChargeItemElementUUID AS TranspChargeItemElementUUID,
  FrtOrdChrgElement.TranspChargeItemUUID AS TranspChargeItemUUID,
  FrtOrdChrgElement.TranspChargeType AS TranspChargeType,
  FrtOrdChrgElement.TranspChargeCalcReslnBase AS TranspChargeCalcReslnBase,
  FrtOrdChrgElement.TranspChrgLogisticalRefDesc AS TranspChrgLogisticalRefDesc,
  FrtOrdChrgElement.TranspChrgRefFromLineNumber AS TranspChrgRefFromLineNumber,
  FrtOrdChrgElement.TranspChrgRefToLineNumber AS TranspChrgRefToLineNumber,
  case when FrtOrdChrgElement.TranspChrgRateCurrency = '%' then cast( cast( FrtOrdChrgElement.TranspChrgRateAmount as abap.dec(31,6) ) as abap.quan( 31, 2 )) else cast( cast( 0 as abap.dec(31,6) ) as abap.quan( 31, 2 )) end as TransportationRateAmountPct AS quan312endasTransportationRateAmountPct,
  case when FrtOrdChrgElement.TranspChrgRateCurrency = '%' then cast( cast( FrtOrdChrgElement.TranspChrgPrpsdAmtInRateCrcy as abap.dec(31,6) ) as abap.quan( 31, 2 )) else cast( cast( 0 as abap.dec(31,6) ) as abap.quan( 31, 2 )) end as TranspChrgPrpsdAmountInPct AS quan312endasTranspChrgPrpsdAmountInPct,
  FrtOrdChrgElement.TranspChargeDocumentCurrency AS TranspChargeDocumentCurrency,
  FrtOrdChrgElement.TranspChrgAmountInDocCurrency AS TranspChrgAmountInDocCurrency,
  FrtOrdChrgElement.TranspChrgPrpsdFnlAmtInDocCrcy AS TranspChrgPrpsdFnlAmtInDocCrcy,
  FrtOrdChrgElement.TranspChargeCalcLevelRefUUID AS TranspChargeCalcLevelRefUUID,
  FrtOrdChrgElement.TranspChrgCalcRuleUnit AS TranspChrgCalcRuleUnit,
  cast( cast(FrtOrdChrgElement.TranspChrgDataSourceQuantity as abap.quan( 31,3) ) as /scmtms/vdm_frt_quantity preserving type ) AS TranspChrgDataSourceQuantity,
  cast( cast(FrtOrdChrgElement.TranspChrgProposedDataSrceQty as abap.quan( 31,3) ) as /scmtms/vdm_frt_dsp_qty preserving type ) AS TranspChrgProposedDataSrceQty,
  cast( cast(FrtOrdChrgElement.TranspChrgPricePerQuantity as abap.quan( 31,3) ) as /scmtms/vdm_frt_chrg_ppu_qty preserving type ) AS TranspChrgPricePerQuantity,
  cast( cast(FrtOrdChrgElement.TranspChrgPrpsdPricePerQty as abap.quan( 31,3) ) as /scmtms/vdm_frt_dsp_ppu_qty preserving type ) AS TranspChrgPrpsdPricePerQty,
  FrtOrdChrgElement.TranspChrgCalculationBase AS TranspChrgCalculationBase,
  _FrtOrderCharge.TransportationOrderType AS TransportationOrderType,
  _FrtOrderCharge.TransportationOrderCategory AS TransportationOrderCategory,
  FrtOrdChrgElement.TranspOrdResponsiblePerson AS TranspOrdResponsiblePerson,
  FrtOrdChrgElement.TranspOrdShippingType AS TranspOrdShippingType,
  FrtOrdChrgElement.TranspChargeCalcSheetLineNmbr AS TranspChargeCalcSheetLineNmbr,
  FrtOrdChrgElement.TranspChargeCategoryDesc AS TranspChargeCategoryDesc,
  FrtOrdChrgElement.TranspChrgItmElmntCriticality AS TranspChrgItmElmntCriticality,
  cast( FrtOrdChrgElement.TranspChrgItemElmntDsputStatus as /scmtms/vdm_chrg_elmnt_dsp_sts preserving type ) AS TranspChrgItemElmntDsputStatus
INNER JOIN P_CollabnApplFrtOrdParty AS CollabnApplAddlAgrmtPty ON /* join condition not captured in parsed metadata */
INNER JOIN P_CollabnApplCarrierUser AS CollabnApplCarrierUser ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN C_CollabnApplFrtOrdRespPersn AS _CollabnApplFrtOrdRespPersn ON TranspOrdResponsiblePerson = _CollabnApplFrtOrdRespPersn.TranspOrdResponsiblePerson  -- association [0..1]
LEFT OUTER JOIN I_TranspChargeType AS _TranspChargeType ON TranspChargeType = _TranspChargeType.TranspChargeType  -- association [0..1]
;