C_TranspOrdInvcgBlockStsC

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_TranspOrdInvcgBlockStsC.
-- 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_TranspOrdInvcgBlockStsC AS
SELECT
  cast(bintohex(TransportationOrderUUID) as /scmtms/vdm_tor_db_key_hex) AS TransportationOrderUUID,
  cast(bintohex(SuplrFrtInvcReqUUID) as /scmtms/vdm_sfir_db_key_hex) AS SuplrFrtInvcReqUUID,
  TranspChargeItemUUID,
  TransportationChargesObjUUID,
  TranspChargeItemElementUUID,
  TransportationOrderBlockUUID,
  TransportationOrder,
  TransportationOrderCategory,
  TransportationOrderType,
  DangerousGoodsAreContained,
  TranspOrdResponsiblePerson,
  TranspOrdPlanningBlock,
  TranspOrdExecutionIsBlocked,
  InvoicingIsBlocked,
  InvoicingBlockReason,
  InvoicingBlockCategory,
  Carrier,
  cast(_Carrier.AuthorizationGroup as /scmtms/vdm_carrier_auth_grp preserving type) AS CarrierAuthorizationGroup,
  cast(_Carrier.IsBusinessPurposeCompleted as /scmtms/vdm_carrier_xpcpt preserving type) AS CarrierBusPurposeIsCompleted,
  CarrierOriginOfEntry,
  Shipper,
  cast(_Shipper.AuthorizationGroup as /scmtms/vdm_shipper_auth_grp preserving type) AS ShipperAuthorizationGroup,
  cast(_Shipper.IsBusinessPurposeCompleted as /scmtms/vdm_shipper_xpcpt preserving type) AS ShipperBusPurposeIsCompleted,
  ConsigneeUUID,
  Consignee,
  cast(_Consignee.AuthorizationGroup as /scmtms/vdm_consignee_auth_grp preserving type) AS ConsigneeAuthorizationGroup,
  cast(_Consignee.IsBusinessPurposeCompleted as /scmtms/vdm_consignee_xpcpt preserving type) AS ConsigneeBusPurposeIsCompleted,
  TranspOrdShippingType,
  TranspOrdTrafficDirection,
  PlngAndExecOrganization,
  PlngAndExecGroup,
  PurchasingOrganization,
  PurchasingGroup,
  PlngAndExecOrgExternalID,
  PlngAndExecGroupExternalID,
  PurchasingOrgExternalID,
  PurchasingGroupExternalID,
  TranspOrdLifeCycleStatus,
  TranspOrdPlanningStatus,
  TransportationOrderExecSts,
  TranspOrdLfcycStsChgDteTime,
  TranspOrdLfcycStsChgDte,
  cast(_TranspOrdLfcycStsChgDte.YearWeek as /scmtms/vdm_lc_sts_chg_yrwk preserving type) AS TranspOrdLfcycStsChgDteYrWeek,
  cast(_TranspOrdLfcycStsChgDte.YearMonth as /scmtms/vdm_lc_sts_chg_yrmnth preserving type) AS TranspOrdLfcycStsChgDteYrMnth,
  cast(_TranspOrdLfcycStsChgDte.YearQuarter as /scmtms/vdm_lc_sts_chg_yrqtr preserving type) AS TranspOrdLfcycStsChgDteYearQtr,
  cast(_TranspOrdLfcycStsChgDte.CalendarYear as /scmtms/vdm_lc_sts_chg_yr preserving type) AS TranspOrdLfcycStsChgDteYear,
  SourceLocationUUID,
  SourceLocation,
  SourceLocationType,
  SourceLocationCountry,
  SourceLocationRegion,
  DestinationLocationUUID,
  DestinationLocation,
  DestinationLocationType,
  DestinationLocationCountry,
  DestinationLocationRegion,
  MeansOfTransport,
  TransportationMode,
  TransportationModeCategory,
  cast( cast(1 as abap.dec(10,0)) as /scmtms/vdm_num_tor preserving type ) AS NumberOfTransportationOrders,
  _SuplrFrtInvcReqEnrcd.SupplierFreightInvoiceRequest AS SupplierFreightInvoiceRequest,
  _SuplrFrtInvcReqEnrcd.SuplrFrtInvcReqType AS SuplrFrtInvcReqType,
  _SuplrFrtInvcReqEnrcd.SuplrFrtInvcReqCategory AS SuplrFrtInvcReqCategory,
  _SuplrFrtInvcReqEnrcd.SuplrFrtInvcReqBlockReason AS SuplrFrtInvcReqBlockReason,
  _SuplrFrtInvcReqEnrcd.SuplrFrtInvcReqLifeCycSts AS SuplrFrtInvcReqLifeCycSts,
  _SuplrFrtInvcReqEnrcd.SuplrFrtInvcReqBlockStatus AS SuplrFrtInvcReqBlockStatus,
  _SuplrFrtInvcReqEnrcd.SuplrFrtInvcReqConstcySts AS SuplrFrtInvcReqConstcySts,
  _SuplrFrtInvcReqEnrcd.SuplrFrtInvcReqArchStatus AS SuplrFrtInvcReqArchStatus,
  _SuplrFrtInvcReqEnrcd.SuplrFrtInvcReqConfStatus AS SuplrFrtInvcReqConfStatus,
  _SuplrFrtInvcReqEnrcd.InvoiceDate AS InvoiceDate,
  cast(_SuplrFrtInvcReqEnrcd._InvoiceDate.YearWeek as /scmtms/vdm_invc_year_week preserving type) AS InvoiceDateYearWeek,
  cast(_SuplrFrtInvcReqEnrcd._InvoiceDate.YearMonth as /scmtms/vdm_invc_year_month preserving type) AS InvoiceDateYearMonth,
  cast(_SuplrFrtInvcReqEnrcd._InvoiceDate.YearQuarter as /scmtms/vdm_invc_year_quarter preserving type) AS InvoiceDateYearQuarter,
  cast(_SuplrFrtInvcReqEnrcd._InvoiceDate.CalendarYear as /scmtms/vdm_invc_year preserving type) AS InvoiceDateYear,
  _SuplrFrtInvcReqEnrcd.BillFromParty AS BillFromParty,
  cast(_SuplrFrtInvcReqEnrcd._BillFromParty.AuthorizationGroup as /scmtms/vdm_billfrpty_auth_grp preserving type) AS BillFromPtyAuthorizationGroup,
  cast(_SuplrFrtInvcReqEnrcd._BillFromParty.IsBusinessPurposeCompleted as /scmtms/vdm_billfrpty_xpcpt preserving type) AS BillFromPtyBusPrpsIsCompleted,
  _TranspChargeObjectEnrcd.TranspChargeDocumentCurrency AS TranspChargeDocumentCurrency,
  _TranspChargeObjectEnrcd.TranspChargeLocalCurrency AS TranspChargeLocalCurrency,
  _TranspChargeObjectEnrcd.InvoicingStatus AS InvoicingStatus,
  _TranspChargeObjectEnrcd.TranspChargeCalcStatus AS TranspChargeCalcStatus,
  _TranspChargeObjectEnrcd.CarrierInvoicingStatus AS CarrierInvoicingStatus,
  _TranspChargeItemEnrcd.RefTransportationOrderNodeUUID AS RefTransportationOrderNodeUUID,
  _TranspChargeItemEnrcd.RefTransportationOrderUUID AS RefTransportationOrderUUID,
  _TranspChargeItemEnrcd.TranspChargeItmInvcgStatus AS TranspChargeItmInvcgStatus,
  _TranspChargeItemEnrcd.TranspChargeCalcLevel AS TranspChargeCalcLevel,
  cast($parameters.P_DisplayCurrency as /scmtms/vdm_v_display_currency preserving type) AS DisplayCurrency,
  cast($parameters.P_DisplayWeightUnit as /scmtms/vdm_dsp_weight_unit preserving type) AS DisplayWeightUnit,
  cast($parameters.P_DisplayVolumeUnit as /scmtms/vdm_dsp_volume_unit preserving type) AS DisplayVolumeUnit,
  cast($parameters.P_DisplayQuantityUnit as /scmtms/vdm_dsp_quantity_unit preserving type) AS DisplayQuantityUnit,
  cast($parameters.P_DisplayNmbrOfCtnsUnit as /scmtms/vdm_dsp_nmbrctns_unit preserving type) AS DisplayNmbrOfCtnsUnit,
  _SuplrFrtInvcReqEnrcd._SuplrFrtInvcReqBlockReason AS _SuplrFrtInvcReqBlockReason,
  _SuplrFrtInvcReqEnrcd._SuplrFrtInvcReqBlockStatus AS _SuplrFrtInvcReqBlockStatus,
  _SuplrFrtInvcReqEnrcd._SuplrFrtInvcReqCategory AS _SuplrFrtInvcReqCategory,
  _SuplrFrtInvcReqEnrcd._SuplrFrtInvcReqConfStatus AS _SuplrFrtInvcReqConfStatus,
  _SuplrFrtInvcReqEnrcd._SuplrFrtInvcReqArchStatus AS _SuplrFrtInvcReqArchStatus,
  _SuplrFrtInvcReqEnrcd._SuplrFrtInvcReqConstcySts AS _SuplrFrtInvcReqConstcySts,
  _SuplrFrtInvcReqEnrcd._SuplrFrtInvcReqLifeCycSts AS _SuplrFrtInvcReqLifeCycSts,
  _SuplrFrtInvcReqEnrcd._SuplrFrtInvcReqType AS _SuplrFrtInvcReqType,
  _SuplrFrtInvcReqEnrcd._BillFromParty AS _BillFromParty,
  _SuplrFrtInvcReqEnrcd._InvoiceDate AS _InvoiceDate,
  _TranspChargeObjectEnrcd._TranspChargeDocumentCurrency AS _TranspChargeDocumentCurrency,
  _TranspChargeObjectEnrcd._TranspChargeLocalCurrency AS _TranspChargeLocalCurrency,
  _TranspChargeObjectEnrcd._InvoicingStatus AS _InvoicingStatus,
  _TranspChargeObjectEnrcd._TranspChargeCalcStatus AS _TranspChargeCalcStatus,
  _TranspChargeObjectEnrcd._CarrierInvoicingStatus AS _CarrierInvoicingStatus,
  _TranspChargeItemEnrcd._TranspChargeItmInvcgStatus AS _TranspChargeItmInvcgStatus,
  _TranspChargeItemEnrcd._TranspChargeCalcLevel AS _TranspChargeCalcLevel,
  _TranspChargeItemEnrcd._TransportationOrderEnrcd AS _TransportationOrderEnrcd
FROM I_TranspOrdInvcgBlockSts
LEFT OUTER JOIN I_UnitOfMeasure AS _DisplayWeightUnit ON _DisplayWeightUnit.UnitOfMeasureDimension = 'MASS' AND DisplayWeightUnit = _DisplayWeightUnit.UnitOfMeasure  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _DisplayVolumeUnit ON _DisplayVolumeUnit.UnitOfMeasureDimension = 'VOLUME' AND DisplayVolumeUnit = _DisplayVolumeUnit.UnitOfMeasure  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _DisplayQuantityUnit ON _DisplayQuantityUnit.UnitOfMeasureDimension = 'AAAADL' AND DisplayQuantityUnit = _DisplayQuantityUnit.UnitOfMeasure  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _DisplayNmbrOfCtnsUnit ON _DisplayNmbrOfCtnsUnit.UnitOfMeasureDimension = 'AAAADL' AND DisplayNmbrOfCtnsUnit = _DisplayNmbrOfCtnsUnit.UnitOfMeasure  -- association [1..1]
LEFT OUTER JOIN I_Currency AS _DisplayCurrency ON DisplayCurrency = _DisplayCurrency.Currency  -- association [1..1]
LEFT OUTER JOIN I_TranspChargeObjectEnrcd AS _TranspChargeObjectEnrcd ON TransportationChargesObjUUID = _TranspChargeObjectEnrcd.TransportationChargesObjUUID  -- association [1..1]
LEFT OUTER JOIN I_TranspChargeItemEnrcd AS _TranspChargeItemEnrcd ON TranspChargeItemUUID = _TranspChargeItemEnrcd.TranspChargeItemUUID  -- association [1..1]
LEFT OUTER JOIN I_TranspChargeItemElementEnrcd AS _TranspChargeItemElementEnrcd ON TranspChargeItemElementUUID = _TranspChargeItemElementEnrcd.TranspChargeItemElementUUID  -- association [1..1]
;