R_TrdgDocReltdAssocdItmBasic

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 R_TrdgDocReltdAssocdItmBasic.
-- 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 R_TrdgDocReltdAssocdItmBasic AS
SELECT
  ruuid AS TrdgReltdDocumentUUID,
  cast(doc_type as wb2_reltd_doc_type preserving type ) AS TrdgReltdDocCategory,
  doc_nr AS TrdgDocRelatedDocument,
  doc_year AS TrdgDocReltdDocumentYear,
  doc_bukrs AS TrdgDocReltdDocCoCode,
  item AS TrdgDocItmInGeneralDocument,
  cast(sub_item as wb2_reltd_doc_sub_item preserving type ) AS TrdgDocReltdDocumentSubItem,
  tew_type AS TradingProcessVariantType,
  bus_step AS TradingProcessBusinessStep,
  open_quan_flag AS TrdgDocReltdDocOpnQtyCat,
  tkonn AS TradingDocument,
  cast(tposn as wb2_doc_tposn preserving type ) AS TradingDocumentItem,
  cast(tposn_sub as wb2_doc_tposn_sub preserving type ) AS TradingDocumentSubItem,
  portfolio AS TrdgPortfolioInternalID,
  unit_of_quan AS TrdgDocAssocdUoM,
  base_side AS TradingDocumentSide,
  cast(side as wb2_doc_side preserving type ) AS TrdgDocReltdSideCat,
  matnr AS Product,
  matkl AS ProductGroup,
  unit_doc AS TrdgDocReltdDocUoM,
  progressed_quan AS TrdgDocRlvtItmProgressedQty,
  act_asso_quan AS TrdgDocReltdItmAssociatedQty,
  completed_quan AS TrdgDocItmAssocdCmpltdQty,
  pos_quan_flag AS TrdgDocAssocdQtyIsAvail,
  cast(pred_sub_item as wb2_reltd_precdg_sub_item preserving type ) AS TrdgDocReltdPrecdgSubItem,
  send_compl AS TrdgDocPrevStepCompltnCat,
  erdat AS CreationDate,
  erzet AS CreationTime,
  scenario AS TrdgDocBusinessScenario,
  tkonn_ex AS TrdgDocExternalIdentifier,
  complete AS TrdgDocItemIsComplete,
  del_flag AS TrdgDocReltdDocDeltnCat,
  cast(pred_doc_type as wb2_rlvt_precdg_doc_type preserving type) AS TrdgDocRlvtPrecdgDocType,
  pred_doc_nr AS TrdgDocReltdPrecdgDocument,
  pred_doc_year AS TrdgDocReltdPrecdgDocYear,
  pred_doc_bukrs AS TrdgDocReltdPrecdgDocCoCode,
  cast(pred_item as wb2_precdg_item preserving type ) AS TrdgDocReltdPrecdgItem,
  werks AS Plant,
  lgort AS StorageLocation,
  charg AS Batch,
  umz AS TrdgDocReltdDocBaseQtyNmrtr,
  umn AS TrdgDocQtnDnmntr
FROM wbit
LEFT OUTER JOIN R_TrdgDocProcCompltnCat AS _TrdgDocPrevStepCompltnCat ON TrdgDocPrevStepCompltnCat = _TrdgDocPrevStepCompltnCat.TrdgDocProcCompltnCat  -- association [0..1]
LEFT OUTER JOIN R_TrdgDocAssocdQtyAvailInd AS _TrdgDocAssocdQtyAvailInd ON TrdgDocAssocdQtyIsAvail = _TrdgDocAssocdQtyAvailInd.TrdgDocAssocdQtyIsAvail  -- association [0..1]
LEFT OUTER JOIN R_TrdgDocReltdDocDeltnCat AS _TrdgDocReltdDocDeltnCat ON TrdgDocReltdDocDeltnCat = _TrdgDocReltdDocDeltnCat.TrdgDocReltdDocDeltnCat  -- association [0..1]
LEFT OUTER JOIN R_TrdgDocReltdDocOpnQtyCat AS _TrdgDocReltdDocOpnQtyCat ON TrdgDocReltdDocOpnQtyCat = _TrdgDocReltdDocOpnQtyCat.TrdgDocReltdDocOpnQtyCat  -- association [0..1]
LEFT OUTER JOIN R_TrdgDocItemIsComplete AS _TrdgDocItemIsComplete ON TrdgDocItemIsComplete = _TrdgDocItemIsComplete.TrdgDocItemIsComplete  -- association [0..1]
LEFT OUTER JOIN R_TrdgDocReltdSideCat AS _TrdgDocReltdSideCat ON TrdgDocReltdSideCat = _TrdgDocReltdSideCat.TrdgDocReltdSideCat  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [0..1]
LEFT OUTER JOIN I_StorageLocation AS _StorageLocation ON StorageLocation = _StorageLocation.StorageLocation AND Plant = _StorageLocation.Plant  -- association [0..1]
LEFT OUTER JOIN I_Product AS _Product ON Product = _Product.Product  -- association [0..1]
LEFT OUTER JOIN I_ProductGroup_2 AS _ProductGroup ON ProductGroup = _ProductGroup.ProductGroup  -- association [0..1]
LEFT OUTER JOIN I_Batch AS _Batch ON Batch = _Batch.Batch AND Plant = _Batch.Plant AND Product = _Batch.Material  -- association [0..1]
;