I_TranspChargeItemElement

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 I_TranspChargeItemElement.
-- 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 I_TranspChargeItemElement AS
SELECT
  cast(db_key as /scmtms/vdm_chrg_itm_el_db_key preserving type) AS TranspChargeItemElementUUID,
  root_key AS TransportationChargesObjUUID,
  parent_key AS TranspChargeItemUUID,
  linenr AS TranspChargeCalcSheetLineNmbr,
  tccalcresins040 AS TranspChargeInstrnType,
  tcet084 AS TranspChargeType,
  tcclass037 AS TranspChargeSubCategory,
  chrgcatcd021_i AS TranspChargeCategory,
  clcresbas036 AS TranspChargeCalcReslnBase,
  calc_date_type AS TranspCalculationDateType,
  calc_date_tstmp AS TranspChargeItmElmntCalcDteTme,
  inactive AS TranspChargeIsInactive,
  cast( cast( calc_amount as abap.dec(31,6) ) * 10000 as abap.curr(31,2) ) AS TranspChargeCalcdAmount,
  cast(calc_amount_curr as /scmtms/vdm_calc_amount_crcy preserving type) AS TranspChargeCalcdAmountCrcy,
  cast( cast( credit_amount as abap.dec(31,6) ) * 10000 as abap.curr(31,2) ) AS CreditAmount,
  cast(credit_amount_curr as /scmtms/vdm_credit_amount_crcy preserving type) AS CreditAmountCurrency,
  cast( cast( invoiced_amt as abap.dec(31,6) ) * 10000 as abap.curr(31,2) ) AS InvoicedAmount,
  cast(invoiced_amt_curr as /scmtms/vdm_invc_amount_crcy preserving type) AS InvoicedAmountCurrency,
  exceptionind AS TranspChrgIsException,
  ref_desc AS TranspChrgLogisticalRefDesc,
  cast(rate_amount_curr as /scmtms/vdm_rate_amount_crcy preserving type) AS TranspChrgRateCurrency,
  cast( cast( rate_amount as abap.dec(31,6) ) * 10000 as abap.curr(31,2) ) AS TranspChrgRateAmount,
  fixatincod179_i AS TranspRateAmtIsManuallyChanged,
  cast(my_tce_linenr as /scmtms/tcc_from_line_no preserving type) AS TranspChrgLineNumber,
  calc_ref_line_no AS TranspChrgRefFromLineNumber,
  calc_ref_to_no AS TranspChrgRefToLineNumber,
  cast(currcode016 as /scmtms/doc_currency preserving type) AS TranspChargeDocumentCurrency,
  cast( cast( amount as abap.dec(31,6) ) * 10000 as abap.curr(31,2) ) AS TranspChrgAmountInDocCurrency,
  cast(currcode016lcl as /scmtms/vdm_local_amount_crcy preserving type) AS TranspChargeLocalCurrency,
  cast( cast( amountlcl as abap.dec(31,6) ) * 10000 as abap.curr(31,2) ) AS TranspChrgAmountInLoclCurrency,
  index_base_date_ts AS TranspChargeIndexBaseDateTime,
  uuid_index_rate AS TranspChrgIndexRateTableUUID,
  rate_id AS TransportationRate,
  mandatory AS TranspChargeIsMandatory,
  round_rule AS TranspChargeRoundingProfile,
  dim_wt_profile AS TranspDimnWeightProfile,
  calc_meth_code AS TranspCalculationMethodType,
  calc_meth_name AS TranspCalculationMethodName,
  invoicing AS TranspChargePostingStatus,
  rateval_ind AS TranspChargeRateValue,
  uuid026 AS TransportationRateUUID,
  ref_elem_key AS TranspChrgRefElementUUID,
  is_technical AS TranspChargeIsTechnical,
  charge_is_tax AS TranspChargeIsTax,
  setl_not_relev AS TranspChargeIsInvcNotRlvt
FROM /scmtms/d_tchrge
LEFT OUTER JOIN I_TranspChargeItem AS _TranspChargeItem ON TranspChargeItemUUID = _TranspChargeItem.TranspChargeItemUUID  -- association [1..1]
LEFT OUTER JOIN I_TranspChargeObject AS _TranspChargeObject ON TransportationChargesObjUUID = _TranspChargeObject.TransportationChargesObjUUID  -- association [1..1]
LEFT OUTER JOIN I_TranspChargeCalcBase AS _TranspChargeCalcBase ON TranspChargeItemElementUUID = _TranspChargeCalcBase.TranspChargeItemElementUUID  -- association [0..*]
LEFT OUTER JOIN I_TranspChargeCalcRule AS _TranspChargeCalcRule ON TranspChargeItemElementUUID = _TranspChargeCalcRule.TranspChargeItemElementUUID  -- association [0..*]
LEFT OUTER JOIN I_TranspChargeInstrnType AS _TranspChargeInstrnType ON TranspChargeInstrnType = _TranspChargeInstrnType.TranspChargeInstrnType  -- association [0..1]
LEFT OUTER JOIN I_TranspChargeType AS _TranspChargeType ON TranspChargeType = _TranspChargeType.TranspChargeType  -- association [0..1]
LEFT OUTER JOIN I_TranspChargeSubCategory AS _TranspChargeSubCategory ON TranspChargeSubCategory = _TranspChargeSubCategory.TranspChargeSubCategory  -- association [0..1]
LEFT OUTER JOIN I_TranspChargeCategory AS _TranspChargeCategory ON TranspChargeCategory = _TranspChargeCategory.TranspChargeCategory  -- association [0..1]
LEFT OUTER JOIN I_TranspChargeCalcReslnBase AS _TranspChargeCalcReslnBase ON TranspChargeCalcReslnBase = _TranspChargeCalcReslnBase.TranspChargeCalcReslnBase  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _TranspChargeCalcdAmountCrcy ON TranspChargeCalcdAmountCrcy = _TranspChargeCalcdAmountCrcy.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _CreditAmountCurrency ON CreditAmountCurrency = _CreditAmountCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _InvoicedAmountCurrency ON InvoicedAmountCurrency = _InvoicedAmountCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _RateAmountCurrency ON TranspChrgRateCurrency = _RateAmountCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _DocumentAmountCurrency ON TranspChargeDocumentCurrency = _DocumentAmountCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _LocalAmountCurrency ON TranspChargeLocalCurrency = _LocalAmountCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_TranspChargeExchRate AS _TranspChargeExchRate ON TranspChargeItemElementUUID = _TranspChargeExchRate.TranspChargeItemElementUUID AND _TranspChargeExchRate.TranspChrgIsLoclExchRate is initial  -- association [0..1]
LEFT OUTER JOIN I_TranspDimnWeightProfile AS _TranspDimnWeightProfile ON TranspDimnWeightProfile = _TranspDimnWeightProfile.TranspDimnWeightProfile  -- association [0..1]
LEFT OUTER JOIN I_TranspCalculationMethod AS _TranspCalculationMethod ON TranspCalculationMethodType = _TranspCalculationMethod.TranspCalculationMethodType AND TranspCalculationMethodName = _TranspCalculationMethod.TranspCalculationMethodName  -- association [1..1]
LEFT OUTER JOIN I_TranspCalcMethodType AS _TranspCalcMethodType ON TranspCalculationMethodType = _TranspCalcMethodType.TranspCalculationMethodType  -- association [1..1]
LEFT OUTER JOIN I_InvoicingStatus AS _TranspChargePostingStatus ON TranspChargePostingStatus = _TranspChargePostingStatus.InvoicingStatus  -- association [0..1]
LEFT OUTER JOIN I_TranspChargeCalcStatusText AS _TranspChargeCalcStatusText ON TranspChargeCalcStatus = _TranspChargeCalcStatusText.TranspChargeCalcStatus AND _TranspChargeCalcStatusText.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_TranspChargeRateValue AS _TranspChargeRateValue ON TranspChargeRateValue = _TranspChargeRateValue.TranspChargeRateValue  -- association [1..1]
LEFT OUTER JOIN I_TranspCalculationDateType AS _TranspCalculationDateType ON TranspCalculationDateType = _TranspCalculationDateType.TranspCalculationDateType  -- association [1..1]
LEFT OUTER JOIN I_TransportationRate AS _TransportationRate ON TransportationRateUUID = _TransportationRate.TransportationRateUUID  -- association [1..1]
LEFT OUTER JOIN I_TransportationRate AS _TransportationIndexRate ON TranspChrgIndexRateTableUUID = _TransportationIndexRate.TransportationRateUUID  -- association [1..1]
;