C_SalesOrderWithoutChargeItmFS

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_SalesOrderWithoutChargeItmFS.
-- 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.
-- SQL view name: CORDWOCHARGEITFS

CREATE VIEW C_SalesOrderWithoutChargeItmFS AS
SELECT
  OrderWOChargeItem.SalesOrderWithoutCharge AS SalesOrderWithoutCharge,
  OrderWOChargeItem.SalesOrderWithoutChargeItem AS SalesOrderWithoutChargeItem,
  OrderWOChargeItem.SalesOrderWthoutChrgItemText AS SalesOrderWthoutChrgItemText,
  cast(_SalesOrderWithoutCharge.SoldToParty as kunag preserving type ) AS SoldToParty,
  cast('' as ad_namtext ) AS SoldToPartyName,
  cast ( _ShipToParty.Customer as kunwe ) AS ShipToParty,
  cast('' as ad_namtext ) AS ShipToPartyName,
  OrderWOChargeItem.SDProcessStatus AS SDProcessStatus,
  OrderWOChargeItem.DeliveryStatus AS DeliveryStatus,
  SDDocumentRejectionStatus,
  SalesDocumentRjcnReason,
  OrderWOChargeItem.OrderQuantity AS OrderQuantity,
  OrderWOChargeItem.OrderQuantityUnit AS OrderQuantityUnit,
  OrderWOChargeItem.NetAmount AS NetAmount,
  OrderWOChargeItem.TransactionCurrency AS TransactionCurrency,
  _MaterialText[1:Language=$session.system_language].MaterialName AS MaterialName,
  cast(OrderWOChargeItem.Material as productnumber preserving type ) AS Material,
  OrderWOChargeItem.MaterialByCustomer AS MaterialByCustomer,
  cast(OrderWOChargeItem.MaterialGroup as productgroup preserving type ) AS MaterialGroup,
  OrderWOChargeItem.Batch AS Batch,
  OrderWOChargeItem.Plant AS ProductionPlant,
  OrderWOChargeItem.StorageLocation AS StorageLocation,
  OrderWOChargeItem._StorageLocation.StorageLocationName AS StorageLocationName,
  _ShippingPointText[1:Language=$session.system_language].ShippingPointName AS ShippingPointName,
  OrderWOChargeItem.ShippingPoint AS ShippingPoint,
  OrderWOChargeItem.SlsOrdWthoutChrgItemCategory AS SlsOrdWthoutChrgItemCategory,
  OrderWOChargeItem.DeliveryBlockStatus AS DeliveryBlockStatus,
  OrderWOChargeItem.HigherLevelItem AS HigherLevelItem,
  _ReqdDeliveryDate.RequestedDeliveryDate AS RequestedDeliveryDate,
  _ConfDeliveryDate.ConfirmedDeliveryDate AS ConfirmedDeliveryDate,
  cast( OrderWOChargeItem.ConfdDelivQtyInOrderQtyUnit as confirmed_quantity preserving type ) AS ConfdDelivQtyInOrderQtyUnit
FROM I_SalesOrderWithoutChargeItem AS OrderWOChargeItem
LEFT OUTER JOIN C_SDDocumentPartnerCard AS _SDDocumentPartnerCard ON SalesOrderWithoutCharge = _SDDocumentPartnerCard.SDDocument AND SalesOrderWithoutChargeItem = _SDDocumentPartnerCard.SDDocumentItem  -- association [0..*]
LEFT OUTER JOIN I_SlsDocItemReqdDeliveryDate AS _ReqdDeliveryDate ON SalesOrderWithoutCharge = _ReqdDeliveryDate.SalesDocument AND SalesOrderWithoutChargeItem = _ReqdDeliveryDate.SalesDocumentItem  -- association [0..1]
LEFT OUTER JOIN C_SlsOrdWthoutChrgSchedLine AS _SlsOrdWthoutChrgSchedLine ON SalesOrderWithoutCharge = _SlsOrdWthoutChrgSchedLine.SalesOrderWithoutCharge AND SalesOrderWithoutChargeItem = _SlsOrdWthoutChrgSchedLine.SalesOrderWithoutChargeItem  -- association [0..*]
LEFT OUTER JOIN C_PrecdgSalesOrderItem AS _PrecdgSalesOrderItem ON SalesOrderWithoutCharge = _PrecdgSalesOrderItem.SubsequentDocument AND SalesOrderWithoutChargeItem = _PrecdgSalesOrderItem.SubsequentDocumentItem  -- association [0..*]
LEFT OUTER JOIN C_RelatedBillingDocumentItem AS _PrecdgBillingDocumentItem ON SalesOrderWithoutCharge = _PrecdgBillingDocumentItem.SubsequentDocument AND SalesOrderWithoutChargeItem = _PrecdgBillingDocumentItem.SubsequentDocumentItem  -- association [0..*]
LEFT OUTER JOIN C_PrecdgCustomerReturnItem AS _PrecdgCustomerReturnItem ON SalesOrderWithoutCharge = _PrecdgCustomerReturnItem.SubsequentDocument AND SalesOrderWithoutChargeItem = _PrecdgCustomerReturnItem.SubsequentDocumentItem  -- association [0..*]
LEFT OUTER JOIN C_SubsqntOutbDeliveryItem AS _SubsqntOutbDeliveryItem ON SalesOrderWithoutCharge = _SubsqntOutbDeliveryItem.PrecedingDocument AND SalesOrderWithoutChargeItem = _SubsqntOutbDeliveryItem.PrecedingDocumentItem  -- association [0..*]
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_SlsDocItemConfDeliveryDate AS _ConfDeliveryDate ON SalesOrderWithoutCharge = _ConfDeliveryDate.SalesDocument AND SalesOrderWithoutChargeItem = _ConfDeliveryDate.SalesDocumentItem  -- association [0..1]
LEFT OUTER JOIN E_SalesDocumentItemBasic AS _Extension ON SalesOrderWithoutCharge = _Extension.SalesDocument AND SalesOrderWithoutChargeItem = _Extension.SalesDocumentItem  -- association [1]
;