C_MRPSalesOrderWithoutChrgCard

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_MRPSalesOrderWithoutChrgCard.
-- 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_MRPSalesOrderWithoutChrgCard AS
SELECT
  SalesOrderWithoutCharge,
  SalesOrderWithoutChargeItem,
  ScheduleLine,
  cast ( _ShipToParty.Customer as kunwe ) AS ShipToParty,
  cast('' as ad_namtext ) AS ShipToPartyName,
  _SalesOrderWithoutCharge.SalesOrderWithoutChargeDate AS SalesOrderWithoutChargeDate,
  LoadingDate,
  _ReqdDeliveryDate.RequestedDeliveryDate AS RequestedDeliveryDate,
  DeliveredQuantityInBaseUnit,
  _SalesOrderWithoutChargeItem.OrderQuantityUnit AS OrderQuantityUnit,
  BaseUnit,
  cast ( concat( ltrim ( SalesOrderWithoutCharge, '0' ), concat( '-', ltrim ( SalesOrderWithoutChargeItem, '0' ) ) ) as abap.char( 18 ) ) as SourceOrderName AS char18asSourceOrderName,
  _SalesOrderWithoutChargeItem.DeliveryBlockStatus AS DeliveryBlockStatus,
  _SalesOrderWithoutChargeItem._DeliveryBlockStatus._Text[1: Language = $session.system_language ].DeliveryBlockStatusDesc AS DeliveryBlockStatusDesc,
  OpenConfdDelivQtyInBaseUnit,
  _SalesOrderWithoutChargeItem.OrderQuantity AS OrderQuantity,
  _SalesOrderWithoutChargeItem.MaterialByCustomer AS MaterialByCustomer,
  _SalesOrderWithoutChargeItem.Product AS Material,
  _SalesOrderWithoutChargeItem._ProductText[1: Language = $session.system_language ].ProductName AS ProductName,
  _SalesOrderWithoutCharge.SalesOrderWithoutChargeType AS SalesOrderWithoutChargeType,
  cast ( case when _ShipToParty.Customer is initial then 'X' else '' end as boolean preserving type ) AS UICT_ShipToParty,
  cast ( case when _SalesOrderWithoutCharge.SalesOrderWithoutChargeDate is initial then 'X' else '' end as boolean preserving type ) AS UICT_DocumentDate,
  cast ( case when LoadingDate is initial then 'X' else '' end as boolean preserving type ) AS UICT_LoadingDate,
  cast ( case when _ReqdDeliveryDate.RequestedDeliveryDate is initial then 'X' else '' end as boolean preserving type ) AS UICT_DeliveryDate,
  cast ( case when DeliveredQuantityInBaseUnit is initial then 'X' else '' end as boolean preserving type ) AS UICT_DeliveryQuantity,
  cast ( case when _SalesOrderWithoutChargeItem.OrderQuantity is initial then 'X' else '' end as boolean preserving type ) AS UICT_OrderQuantity,
  cast ( case when OpenConfdDelivQtyInBaseUnit is initial then 'X' else '' end as boolean preserving type ) AS UICT_OpenConfdDelivQtyBaseUnit,
  cast ( case when _SalesOrderWithoutChargeItem.MaterialByCustomer is initial then 'X' else '' end as boolean preserving type ) AS UICT_MaterialByCustomer
FROM I_SlsOrdWthoutChrgSchedLine
LEFT OUTER JOIN I_SalesDocItemCompletePartner AS _ShipToParty ON SalesOrderWithoutCharge = _ShipToParty.SalesDocument AND SalesOrderWithoutChargeItem = _ShipToParty.SalesDocumentItem AND _ShipToParty.PartnerFunction = 'WE'  -- association [0..1]
LEFT OUTER JOIN I_SlsDocItemReqdDeliveryDate AS _ReqdDeliveryDate ON SalesOrderWithoutCharge = _ReqdDeliveryDate.SalesDocument AND SalesOrderWithoutChargeItem = _ReqdDeliveryDate.SalesDocumentItem  -- association [0..1]
LEFT OUTER JOIN I_MRPElementCategoryText AS _MRPElementCategoryText ON _MRPElementCategoryText.MRPElementCategory = 'VI' AND _MRPElementCategoryText.Language = $session.system_language  -- association [0..1]
;