I_IN_SubcontrgChallanDocBasic

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 I_IN_SubcontrgChallanDocBasic.
-- 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 I_IN_SubcontrgChallanDocBasic AS
SELECT
  bukrs AS CompanyCode,
  mblnr AS MaterialDocument,
  mjahr AS MaterialDocumentYear,
  zeile AS MaterialDocumentItem,
  chln_inv AS SubcontrgChallan,
  item AS BillingDocumentItem,
  fkart AS BillingDocumentType,
  budat AS PostingDate,
  bwart AS GoodsMovementType,
  werks AS Plant,
  menge AS Quantity,
  gr_rqty AS IN_GRItemRemainingQuantity,
  ch_qty AS IN_ChallanItemQuantity,
  ch_oqty AS IN_ChallanItemOpenQuantity,
  ch_meins AS BaseUnit,
  matnr AS Product,
  lifnr AS Supplier,
  rec_qty AS IN_SubcontrgItmRcnldQty,
  status AS IN_ChallanItemStatus,
  ernam AS CreatedByUser,
  erdat AS CreationDate,
  cputm AS CreationTime,
  aenam AS LastChangedByUser,
  aedat AS LastChangeDate,
  utime AS LastChangeTime,
  sobkz AS InventorySpecialStockType,
  charg AS Batch
FROM j_1ig_subcon AS _Subcon
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_Product AS _Product ON Product = _Product.Product  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [0..1]
LEFT OUTER JOIN I_GoodsMovementType AS _GoodsMovementType ON GoodsMovementType = _GoodsMovementType.GoodsMovementType  -- association [0..1]
LEFT OUTER JOIN I_BillingDocument AS _BillingDocument ON SubcontrgChallan = _BillingDocument.BillingDocument  -- association [0..1]
LEFT OUTER JOIN I_BillingDocumentItem AS _BillingDocumentItem ON _BillingDocumentItem.BillingDocument = SubcontrgChallan AND _BillingDocumentItem.BillingDocumentItem = BillingDocumentItem  -- association [1..1]
LEFT OUTER JOIN I_MaterialDocumentHeader_2 AS _MaterialDocumentHeader ON MaterialDocument = _MaterialDocumentHeader.MaterialDocument AND MaterialDocumentYear = _MaterialDocumentHeader.MaterialDocumentYear  -- association [0..1]
LEFT OUTER JOIN I_MaterialDocumentItem_2 AS _MaterialDocumentItem ON MaterialDocument = _MaterialDocumentItem.MaterialDocument AND MaterialDocumentYear = _MaterialDocumentItem.MaterialDocumentYear AND MaterialDocumentItem = _MaterialDocumentItem.MaterialDocumentItem  -- association [0..1]
LEFT OUTER JOIN I_MaterialDocumentYear AS _MaterialDocumentYear ON MaterialDocumentYear = _MaterialDocumentYear.MaterialDocumentYear  -- association [1..1]
LEFT OUTER JOIN I_BillingDocumentType AS _BillingDocumentType ON BillingDocumentType = _BillingDocumentType.BillingDocumentType  -- association [0..1]
LEFT OUTER JOIN I_InventorySpecialStockType AS _InventorySpecialStockType ON InventorySpecialStockType = _InventorySpecialStockType.InventorySpecialStockType  -- association [0..1]
LEFT OUTER JOIN I_IN_SubcontrgChallanItmSts AS _SubcontrgChallanItmSts ON _SubcontrgChallanItmSts.IN_ChallanItemStatus = IN_ChallanItemStatus  -- association [1..1]
LEFT OUTER JOIN I_IN_SubcontrgChallanItmStsTxt AS _SubcontrgChallanItmStsTxt ON IN_ChallanItemStatus = _SubcontrgChallanItmStsTxt.IN_ChallanItemStatus  -- association [0..*]
LEFT OUTER JOIN I_Batch AS _Batch ON Plant = _Batch.Plant AND Product = _Batch.Material AND Batch = _Batch.Batch  -- association [0..1]
;