R_ConditionDocumentItem

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_ConditionDocumentItem.
-- 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_ConditionDocumentItem AS
SELECT
  cast( num as wcb_condition_document preserving type ) AS ConditionDocument,
  item_guid AS ConditionDocumentItemUUID,
  cast( posnr as wcb_condition_document_item preserving type ) AS ConditionDocumentItem,
  cast( deact as wcb_cndn_doc_itm_act_sts preserving type ) AS CndnDocItmActivationStatus,
  date_from AS CndnDocItemValidFromDate,
  date_to AS CndnDocItemValidToDate,
  cast( eligible_cust as kunnr preserving type ) AS Customer,
  cast( eligible_vendor as lifnr preserving type ) AS Supplier,
  cast( material as productnumber preserving type ) AS Product,
  cast( list_num as wcb_cndndoc_itm_refcd_cndndoc preserving type ) AS CndnDocItmRefcdCndnDoc,
  cast( bukrs as fis_bukrs preserving type ) AS CompanyCode,
  cast( kostl as fis_kostl preserving type ) AS CostCenter,
  cast( ps_psp_pnr as wlf_psp_pnr_no_cnext preserving type ) AS WBSElementInternalID,
  aufnr AS SettlmtMgmtOrder,
  distribution_ratio AS SettlementDistributionRatio,
  cast( guid as wcb_cndn_doc_uuid preserving type ) AS ConditionDocumentUUID,
  cast( ext_guid as wcb_cndn_doc_itm_source_uuid preserving type ) AS CndnDocItemSourceUUID,
  sont_abbrv_i AS CndnDocObjNodeTypeAbbr,
  semantic_type_i AS CndnDocSemanticCode
FROM wcocoi
LEFT OUTER JOIN R_ConditionDocument AS _ConditionDocument ON ConditionDocument = _ConditionDocument.ConditionDocument  -- association [1..1]
LEFT OUTER JOIN I_CndnDocItmActivationStatus AS _CndnDocItmActivationStatus ON CndnDocItmActivationStatus = _CndnDocItmActivationStatus.CndnDocItmActivationStatus  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _Customer ON Customer = _Customer.Customer  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_Product AS _Product ON Product = _Product.Product  -- association [0..1]
LEFT OUTER JOIN R_ConditionDocument AS _CndnDocItmRefcdCndnDoc ON CndnDocItmRefcdCndnDoc = _CndnDocItmRefcdCndnDoc.ConditionDocument  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElementInternalID ON WBSElementInternalID = _WBSElementInternalID.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_InternalOrder AS _SettlmtMgmtOrder ON SettlmtMgmtOrder = _SettlmtMgmtOrder.InternalOrder  -- association [0..1]
;