R_TrdgDocReltdDocInfoBasic

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_TrdgDocReltdDocInfoBasic.
-- 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_TrdgDocReltdDocInfoBasic AS
SELECT
  ruuid AS TrdgReltdDocumentUUID,
  cast(doc_type as wb2_reltd_doc_cat preserving type ) AS TrdgReltdDocCategory,
  vbeln AS TrdgDocRelatedDocument,
  cast(posnr as wb2_reltd_doc_itm preserving type ) AS TrdgDocReltdDocumentItem,
  gjahr AS TrdgDocReltdDocumentYear,
  tkonn AS TradingDocument,
  cast(tposn as wb2_document_itm preserving type ) AS TradingDocumentItem,
  ernam AS CreatedByUser,
  erdat AS CreationDate,
  tew_type AS TradingProcessVariantType,
  scenario AS TrdgDocBusinessScenario,
  business_step AS TradingProcessBusinessStep,
  tkonn_ex AS TrdgDocExternalIdentifier,
  complete AS TrdgDocItemIsComplete,
  error_tew AS TradingProcessErrorFlag,
  cast(pre_step as wb2_procg_pre_step preserving type ) AS TradingProcessPreviousStep,
  cast(original_step as wb2_proc_src_step preserving type ) AS TradingProcessSourceStep,
  pod_uom AS TrdgDocSlsQuantityUnit,
  pod_quan AS TrdgDocReltdBilledQuantity,
  pur_uom AS TrdgDocPurgQuantityUnit,
  pur_quan AS PurchasingDocumentOrderQty,
  guid AS TrdgDocDgtlSgntrProcID,
  tew_mode AS TradingProcessVariantMode,
  del_flag AS TrdgDocReltdDocDeltnCat,
  rel_flag AS TrdgDocDeltnIsRlvt,
  send_compl AS TrdgDocProcCompltnCat,
  cast(pred_doc_type as wb2_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_reltd_precdg_item preserving type ) AS TrdgDocReltdPrecdgItem,
  cast( side as wb2_doc_side preserving type ) AS TrdgDocReltdSideCat,
  matnr AS Product,
  matkl AS ProductGroup,
  werks AS Plant,
  lgort AS StorageLocation,
  charg AS Batch,
  unit_doc AS TrdgDocReltdDocUoM,
  cast(own_quan as wb2_quantity_doc preserving type ) AS TrdgDocReltdDocQuantity,
  umz AS TrdgDocQtnDnmntr,
  umn AS TrdgDocQtyNmrtr,
  curr_val AS TrdgDocReltdDocCurrency,
  value AS TrdgDocReltdDocItemAmount,
  val_type AS TrdgDocReltdDocValnCat,
  tax_val AS TrdgDocReltdDocItemTaxAmt,
  cast(rate_val as wb2_exch_rate_no_cnext preserving type ) AS TrdgDocReltdDocExchangeRate,
  value_cost AS TrdgDocReltdDocStkAmt,
  av_date AS TrdgDocReltdDocumentDate,
  ret_item AS TrdgDocReltdDocHasRetItm,
  bwtar AS TrdgDocReltdDocItmValnType,
  move_type_code AS TrdgDocDrctnOfGdsCshFlw,
  group_code AS TrdgDocPrcgPaytEvtGrpValue,
  exp_sum AS TrdgDocReltdDocItmTotExpnAmt,
  tax_exp_sum AS TrdgDocItmExpenseTaxAmount,
  exp_rp AS TrdgDocPurgExpnAmt,
  exp_nrp AS TrdgDocNonRcovblPurgExpnAmt,
  exp_rs AS TrdgDocRcovblSlsExpnAmt,
  exp_nrs AS TrdgDocNonRcovblSlsExpnAmt,
  cast(rate_exp as wb2_expn_exch_rate_no_cnext preserving type ) AS TrdgDocReltdDocExpnExchRate,
  cast(curr_exp as wb2_reltd_doc_expn_curr preserving type ) AS TrdgDocReltdDocExpnCurrency,
  has_shadow_tc AS TrdgDocHasShdwContr,
  di_status AS TrdgDocDiffInvcStatus
FROM wbgt
LEFT OUTER JOIN R_TrdgDocDrctnOfGdsCshFlw AS _TrdgDocDrctnOfGdsCshFlw ON TrdgDocDrctnOfGdsCshFlw = _TrdgDocDrctnOfGdsCshFlw.TrdgDocDrctnOfGdsCshFlw  -- association [0..1]
LEFT OUTER JOIN R_TrdgDocReltdDocDeltnCat AS _TrdgDocReltdDocDeltnCat ON TrdgDocReltdDocDeltnCat = _TrdgDocReltdDocDeltnCat.TrdgDocReltdDocDeltnCat  -- association [0..1]
LEFT OUTER JOIN R_TrdgDocDiffInvcStatus AS _TrdgDocDiffInvcStatus ON TrdgDocDiffInvcStatus = _TrdgDocDiffInvcStatus.TrdgDocDiffInvcStatus  -- association [0..1]
LEFT OUTER JOIN R_TrdgReltdDocCategory AS _TrdgReltdDocCategory ON TrdgReltdDocCategory = _TrdgReltdDocCategory.TrdgReltdDocCategory  -- association [0..1]
LEFT OUTER JOIN R_TrdgDocItemIsComplete AS _TrdgDocItemIsComplete ON TrdgDocItemIsComplete = _TrdgDocItemIsComplete.TrdgDocItemIsComplete  -- association [0..1]
LEFT OUTER JOIN R_TrdgDocDeltnIsRlvt AS _TrdgDocDeltnIsRlvt ON TrdgDocDeltnIsRlvt = _TrdgDocDeltnIsRlvt.TrdgDocDeltnIsRlvt  -- association [0..1]
LEFT OUTER JOIN R_TrdgDocProcCompltnCat AS _TrdgDocProcCompltnCat ON TrdgDocProcCompltnCat = _TrdgDocProcCompltnCat.TrdgDocProcCompltnCat  -- association [0..1]
LEFT OUTER JOIN R_TrdgDocReltdSideCat AS _TrdgDocReltdSideCat ON TrdgDocReltdSideCat = _TrdgDocReltdSideCat.TrdgDocReltdSideCat  -- association [0..1]
LEFT OUTER JOIN R_TrdgDocReltdDocValnCat AS _TrdgDocReltdDocValnCat ON TrdgDocReltdDocValnCat = _TrdgDocReltdDocValnCat.TrdgDocReltdDocValnCat  -- association [0..1]
LEFT OUTER JOIN R_TradingProcessErrorFlag AS _TradingProcessErrorFlag ON TradingProcessErrorFlag = _TradingProcessErrorFlag.TradingProcessErrorFlag  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _Currency ON TrdgDocReltdDocCurrency = _Currency.Currency  -- association [0..1]
;