C_SlsDocFlfmtSlsDocItem

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_SlsDocFlfmtSlsDocItem.
-- 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: CSOFSLSDOCITEM

CREATE VIEW C_SlsDocFlfmtSlsDocItem AS
SELECT
  Item.SalesDocument AS SalesDocument,
  cast(Item.SalesDocumentItem as sales_doc_item preserving type) AS SalesDocumentItem,
  Item.SalesDocumentItemCategory AS SalesDocumentItemCategory,
  cast(Item.Material as productnumber preserving type ) AS Material,
  Item._MaterialText[1:Language=$session.system_language].MaterialName AS MaterialName,
  cast(Item.MaterialGroup as productgroup preserving type ) AS MaterialGroup,
  Item.Batch AS Batch,
  Item.Plant AS Plant,
  Item.MaterialByCustomer AS MaterialByCustomer,
  Item.SalesDocumentItemText AS SalesDocumentItemText,
  Item.RequestedQuantity AS RequestedQuantity,
  Item.RequestedQuantityUnit AS RequestedQuantityUnit,
  Item.ConfdDelivQtyInOrderQtyUnit AS ConfdDelivQtyInOrderQtyUnit,
  ItemDeliveredQuantity.DeliveredQtyInOrderQtyUnit AS DeliveredQtyInOrderQtyUnit,
  Item.OrderQuantityUnit AS OrderQuantityUnit,
  Item.CommittedDelivQtyInOrdQtyUnit AS CommittedDelivQtyInOrdQtyUnit,
  Item.CommittedDelivCreationDate AS CommittedDelivCreationDate,
  Item.CommittedDeliveryDate AS CommittedDeliveryDate,
  Item.SalesDocumentRjcnReason AS SalesDocumentRjcnReason,
  Item.CustomerPaymentTerms AS CustomerPaymentTerms,
  Item.NetAmount AS NetAmount,
  Item.TransactionCurrency AS TransactionCurrency,
  Item.ItemBillingBlockReason AS ItemBillingBlockReason,
  Item.ShippingPoint AS ShippingPoint,
  Item._ShippingPointText[1:Language=$session.system_language].ShippingPointName AS ShippingPointName,
  Item.StorageLocation AS StorageLocation,
  cast( Item._SlsDocItemEnhancedFields._RequestedDeliveryDate.RequestedDeliveryDate as reqd_deliv_date) AS RequestedDeliveryDate,
  cast(Item._ShippingPoint._ActiveDepartureCountry.Country as shippingpointcountry) AS ShippingPointCountry,
  cast(Item._ShippingPoint._ActiveDepartureCountry._Text[1:Language=$session.system_language].CountryName as shippingpointcountryname) AS ShippingPointCountryName,
  cast(Item._Plant._Address.Country as shipfrompartycountry) AS ShipFromPartyCountry,
  Item.ShipToParty AS ShipToParty,
  Item._ShipToParty.CustomerName AS ShipToPartyName,
  cast( '' as shiptopartycountry ) AS ShipToPartyCountry,
  cast( '' as shiptopartycountryname ) AS ShipToPartyCountryName,
  Item.DeliveryStatus AS DeliveryStatus,
  Item.SDProcessStatus AS SDProcessStatus,
  cast(Item.PurchaseConfirmationStatus as purchaseconfsts preserving type ) AS PurchaseConfirmationStatus,
  Item.OrderRelatedBillingStatus AS OrderRelatedBillingStatus,
  Item.SDDocumentRejectionStatus AS SDDocumentRejectionStatus,
  cast( Item.ChmlCmplncStatus as mon_tdd_pcsta preserving type ) AS ChmlCmplncStatus,
  cast( Item.DangerousGoodsStatus as mon_tdd_dgsta preserving type ) AS DangerousGoodsStatus,
  cast( Item.SafetyDataSheetStatus as mon_tdd_sdssta preserving type ) AS SafetyDataSheetStatus,
  cast( Item.TrdCmplncEmbargoSts as embargochksts preserving type ) AS TrdCmplncEmbargoSts,
  cast( Item.TrdCmplncSnctndListChkSts as watchlistscrngchksts preserving type ) AS TrdCmplncSnctndListChkSts,
  cast( Item.OvrlTrdCmplncLegalCtrlChkSts as lglctrlchksts preserving type ) AS OvrlTrdCmplncLegalCtrlChkSts,
  Item._ChmlCmplncStatus AS _ChmlCmplncStatus,
  Item._DangerousGoodsStatus AS _DangerousGoodsStatus,
  Item._SafetyDataSheetStatus AS _SafetyDataSheetStatus,
  Item._TrdCmplncEmbargoSts AS _TrdCmplncEmbargoSts,
  Item._TrdCmplncSnctndListChkSts AS _TrdCmplncSnctndListChkSts,
  Item._OvrlTrdCmplncLegalCtrlChkSts AS _OvrlTrdCmplncLegalCtrlChkSts,
  Item._Route AS _Route
FROM I_SalesDocumentItem AS Item
LEFT OUTER JOIN E_SalesDocumentItemBasic AS _Extension ON SalesDocument = _Extension.SalesDocument AND SalesDocumentItem = _Extension.SalesDocumentItem  -- association [0..1]
;