P_CollabnApplCarrInvcCharge

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 P_CollabnApplCarrInvcCharge.
-- 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 P_CollabnApplCarrInvcCharge AS
SELECT
  TranspChargeItemElement.TranspChargeItemElementUUID AS TranspChargeItemElementUUID,
  TranspChargeItemElement.TranspChrgRefElementUUID AS TranspChrgRefElementUUID,
  TranspChargeItemElement.RefTransportationOrderUUID AS RefTransportationOrderUUID,
  TranspChargeItemElement.TranspChargeHostDocumentUUID AS TranspChargeHostDocumentUUID,
  TranspChargeItemElement.TransportationChargesObjUUID AS TransportationChargesObjUUID,
  TranspChargeItemElement.TranspChargeItemUUID AS TranspChargeItemUUID,
  _TranspChargeItem.TranspChargeCalcLevel AS TranspChargeCalcLevel,
  TranspChargeItemElement.TranspChargeType AS TranspChargeType,
  TranspChargeItemElement.TranspChargeTypeDesc AS TranspChargeTypeDesc,
  TranspChargeItemElement.TranspChargeCalcReslnBase AS TranspChargeCalcReslnBase,
  TranspChargeItemElement.TranspChargeCalcReslnBaseDesc AS TranspChargeCalcReslnBaseDesc,
  TranspChargeItemElement.TranspChrgRateCurrency AS TranspChrgRateCurrency,
  cast( FrtOrdChrgDisputeItem._FrtSettlmtDisputeCaseValue[1:FrtDsputCaseItemChangedAttrib is initial and FrtDsputCaseValueIsFinal = 'X'].FrtDsputCaseValProposedAmount as /scmtms/vdm_frt_dsp_rate_amt preserving type ) AS TranspChrgPrpsdAmtInRateCrcy,
  TranspChargeItemElement.TranspChargeDocumentCurrency AS TranspChargeDocumentCurrency,
  cast(FrtOrdChrgDisputeItem._FrtSettlmtDisputeCaseValue[1: FrtDsputCaseItemChangedAttrib = '01' and FrtDsputCaseValueIsFinal = 'X'].FrtDsputCaseValProposedAmount as /scmtms/vdm_frt_dsp_amount preserving type ) AS TranspChrgPrpsdFnlAmtInDocCrcy,
  TranspChargeItemElement.TranspChrgCalcRuleUnit AS TranspChrgCalcRuleUnit,
  cast( FrtOrdChrgDisputeItem._FrtSettlmtDisputeCaseValue[1: FrtDsputCaseItemChangedAttrib = '04' and FrtDsputCaseValueIsFinal = 'X'].FrtDsputCaseValProposedQty as /scmtms/vdm_frt_dsp_quantity preserving type ) AS TranspChrgProposedDataSrceQty,
  cast( FrtOrdChrgDisputeItem._FrtSettlmtDisputeCaseValue[1: FrtDsputCaseItemChangedAttrib = '03' and FrtDsputCaseValueIsFinal = 'X'].FrtDsputCaseValProposedQty as /scmtms/vdm_frt_dsp_ppu preserving type ) AS TranspChrgPrpsdPricePerQty,
  TranspChargeItemElement.TranspChargeIsInactive AS TranspChargeIsInactive,
  TranspChargeItemElement.TranspChrgLogisticalRefDesc AS TranspChrgLogisticalRefDesc,
  _TranspChargeItem.TranspChargeCalcLevelRefUUID AS TranspChargeCalcLevelRefUUID,
  TranspChargeItemElement.TranspChrgRefFromLineNumber AS TranspChrgRefFromLineNumber,
  TranspChargeItemElement.TranspChrgRefToLineNumber AS TranspChrgRefToLineNumber,
  TranspChargeItemElement.TranspChrgCalculationBase AS TranspChrgCalculationBase,
  TranspChargeItemElement.TranspCalculationBaseText AS TranspCalculationBaseText,
  TranspChargeItemElement.TranspChargeCalcSheetLineNmbr AS TranspChargeCalcSheetLineNmbr,
  TranspChargeItemElement.TranspCalculationMethodType AS TranspCalculationMethodType,
  TranspChargeItemElement.TranspChargeCategoryDesc AS TranspChargeCategoryDesc,
  FrtOrdChrgDisputeItem.FrtDsputCaseIsActive AS FrtDsputCaseIsActive,
  NewChrgDisputeItem.FrtDsputCaseVersion AS FrtDsputCaseVersion
FROM P_CollabnApplCarrInvcChrgElmnt AS TranspChargeItemElement
INNER JOIN I_SupplierFreightInvoiceReq ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_TranspChargeItem AS _TranspChargeItem ON TranspChargeItemUUID = _TranspChargeItem.TranspChargeItemUUID  -- association [1..1]
LEFT OUTER JOIN I_TranspChargeItemElement AS _TranspChargeItemElement ON TranspChargeItemElementUUID = _TranspChargeItemElement.TranspChargeItemElementUUID  -- association [1..1]
LEFT OUTER JOIN I_TranspChargeType AS _FrtDsputCaseItemChargeType ON TranspChargeType = _FrtDsputCaseItemChargeType.TranspChargeType  -- association [0..1]
-- UNION with additional select branch(es): P_CollabnFrtOrdChrgInvDispItem
;