C_SlsDocItemBillingBlkd

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_SlsDocItemBillingBlkd.
-- 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: CSLSDOCITEMSO04

CREATE VIEW C_SlsDocItemBillingBlkd AS
SELECT
  Item.SalesDocument AS SalesDocument,
  cast(Item.SalesDocumentItem as sales_doc_item preserving type) AS SalesDocumentItem,
  Issue.DueDays AS DueDays,
  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,
  Item.OrderQuantityUnit AS OrderQuantityUnit,
  Item.CustomerPaymentTerms AS CustomerPaymentTerms,
  Item.NetAmount AS NetAmount,
  Item.TransactionCurrency AS TransactionCurrency,
  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,
  Item.ItemBillingBlockReason AS ItemBillingBlockReason,
  cast( _ConObjStatusBillgBlocked.CtrlgObjStatusIsBillingBlkd as user_status_inv_block preserving type ) AS CtrlgObjStatusIsBillingBlkd,
  Item.DeliveryStatus AS DeliveryStatus,
  Item.SDProcessStatus AS SDProcessStatus,
  Item.OrderRelatedBillingStatus AS OrderRelatedBillingStatus,
  cast( case when ItemBillingBlockReason <> '' and DueDays > 0 then 2 when ItemBillingBlockReason <> '' and DueDays <= 0 then 1 else 9 end as abap.int1 ) as ItmBillgBlockReasonCriticality AS int1asItmBillgBlockReasonCriticality,
  cast( case when _ConObjStatusBillgBlocked.CtrlgObjStatusIsBillingBlkd = 'X' and DueDays > 0 then 2 when _ConObjStatusBillgBlocked.CtrlgObjStatusIsBillingBlkd = 'X' and DueDays <= 0 then 1 else 3 end as abap.int1 ) as CtrlgObjStsIsBillgBlkdCritlty AS int1asCtrlgObjStsIsBillgBlkdCritlty
FROM I_SalesDocumentItem AS Item
INNER JOIN I_SalesOrderBillingBlkd AS Issue ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN E_SalesDocumentItemBasic AS _Extension ON SalesDocument = _Extension.SalesDocument AND SalesDocumentItem = _Extension.SalesDocumentItem  -- association [0..1]
;